SUMITHRA BASHYAM
Summary: Two years of strong experience in analysis, design and development
of database applications using Oracle 8i/8.0/7.x, Developer 2000 (Forms
6.0/4.5, Reports 6.0/2.5), SQL, PL/SQL, SQL*Loader, Export/Import,
OEM,Visual Basic under Windows NT environment. Developed packages,
procedures, functions and database triggers using PL/SQL.
Skills/Tools:
RDBMS: Oracle 8i/8.0/7.x, SQL Server 7.0/6.5
GUI: Visual Basic, Developer 2000 (Forms 6.0/5.0/4.5, Reports 6.0/3.0/2.5,
Graphics 1.5)
Oracle Tools: Oracle Enterprise Manager, Web Publishing Assistant, Web DB,
, Export/Import, Net 8, SQL*Loader
Languages: SQL, PL/SQL
CASE Tools: Designer 2000
OS: Windows NT/98/95
Hardware: IBM 704 Server, Pentium based servers and workstations
Experience:
NEYVELI LIGNITE CORPORATION
Design of Fluidised Bed Combustion system
November 1998 - March 1999.
Designed and developed a system that helps a chemical engineer who
undergoes a long bookwork of labtests which assist him in knowing the
efficiency of combustion.
· Developed an interface using Visual Basic 6.0.
· Created tables,constraints ,DAO objects,and indexes,
· Developed database and stored the intermediate values using MS-Access.
· Developed Charts and graphs using OLE.
· Developed an user interface to prepare Fluidisation module.
· Generated periodical reports of the material balance and Combustion
efficiency.
Environment : Visualbasic 5.0 , CrystalReports, MS-Access , SQL, Windows
NT
SPAARK INFORMATION SYSTEMS
Banking system - Deposit Mobilistion
June 1998 - September 1998
Designed and developed a banking system that concentrates on funds raised th
rough deposits.Created modules to keep track of deposit and withdrawals
from their customers.
· Developed user interface using Visualbasic 5.0 .
· Designed database using MS-Access
· Created tables,indexes,constraints and DAO objects.
· Developed blocks for the validation of the amount.
· Generated periodical balance of the customers using Crystal reports.
Environment : Visualbasic 5.0 , CrystalReports, MS-Access , SQL, Windows
NT
GOSAKA GAS SERVICE
Gas agency system
January 1998 - March 1998
Designed and developed an gas agency system to facilitate refill booking
and supplies. Created modules to keep track of store inventory for
reporting of Orders.
· Reviewed client specification.
· Designed database and developed user interface using Forms 4. 5 and
Reports 2.5.
· Created tables, indexes, sequences, constraints and snapshots.
· Developed PL/SQL blocks for the validation of the forms.
· Generated periodical reports using Reports Designer
Environment: Oracle 7.3, Forms 4.5, Reports 2.5, SQL, PL/SQL, Export/Import,
OEM, Windows NT
SPAARK INFORMATION SYSTEMS
Patient Care System
August 1997- January 1998
Worked as a team member who involved in the analysis, design and development
of the application.
· developed user interface using Developer 2000 (Forms 6.0, Reports 6.0).
· Created tables, indexes, sequences, constraints and snapshots.
· Developed many procedures, functions and database triggers using PL/SQL
for auditing and enforcing business rules.
· Generated reports using Reports designer and graphical reports using
graphics designer.
· Transferred data using SQL*Loader.
Environment: Oracle 8i, Developer 2000 (Forms 6.0, Reports 6.0), SQL,
PL/SQL, SQL*Loader, Export/Import, OEM, Windows NT
SPAARK INFORMATION SYSTEMS
Inventory System
June 1997 - May 1997
Designed and developed an integrated purchase system to facilitate purchase
activities. Developed purchase requisition inquiry, tabulation and purchase
order applications. Enabled application to prevent repetitive data entry as
well as monitoring of purchase status. Developed inward goods advice,
source of supply, part detail and inventory modules.
· Developed user interface using Forms 4.5, and Reports 2.5.
· Created tables, indexes, sequences, constraints and snapshots.
· Developed packages, procedures and functions.
· Developed SQL queries for the manipulation of data.
· Generated periodical reports using Reports Designer.
· Developed many PL/SQL blocks for the validation of the forms.
Environment: Oracle 8.0, Developer 2000 (Forms 4.5, Reports 2.5), SQL,
PL/SQL,
Windows NT.
Education : Masters in Computer Applications. |
, All rights reserved.