SUMMARY

• Overall Fourteen plus years of extensive experience in design and development of information systems for various applications in client/server and web environment.
• Extensive expertise in designing, coding and testing of variety of software applications using Oracle Database 11g, Oracle Developer 6i/9i/10g Forms.
• Proficient in many programming languages, multi - platform development, web development and object oriented methodologies.
• Worked on complete software life cycle starting from information strategy planning, requirement analysis, design, development, coding, testing and implementation to production support.
• Has sound foundation in relational and object design methodologies.
• Well versed in Windows NT, and client/server environments.
• Actively involved in the full project life cycle from user requirements to implementation.
• Expertise in Oracle Database 11g/10g/9i/8i/7.x.
• Extensive experience in building applications with Oracle as the backend.
• Expertise in writing SQL Scripts, Stored Functions / Procedure and Packages.
• Expertise in Oracle PL/SQL, SQL*plus.
• Expertise in migration of applications in oracle (4.5 / 6i /9i/ 10g).
• In-depth knowledge of PL/SQL and Oracle Program Units.
• Expertise in writing Batch Jobs executed nightly as required by the business.
• Designed and developed many applications with Oracle Forms as front-end.
• Developed screens, LOVs, alerts, list item controls, master-detail forms and relations using Oracle Forms.
• Developed various reports as per the business and client requirements using Oracle Reports.
• Managed implementation efforts and coordinated with business and technical groups for the successful deployment of healthcare applications.
• Excellent communication skills, including oral, written, and interpersonal.
• Hands on experience working on Rational

TECHNICAL SKILLS

SQL & PL/SQL: Expert in SQL, PL/SQL, Stored Procedures, Packages

Databases: Oracle, MS-Access, Skills in writing complex SQL, Procedures, Functions, Triggers, Cursors in Oracle.

Reporting: Oracle Reports, Crystal Reports.

Enterprise Scheduling Tool: AutoSys to create jobs dependencies and schedules.

Primary Skills: Data Architecture and Design, ER Modeling

Languages/Tools: SQL, PL SQL, Autosys, ERWIN, Visio and UNIX Shell Scripts

PROFESSIONAL EXPERIENCE

Confidential

Senior Developer Consultant

Responsibilities:

• Create Batch Jobs in PL/SQL per Functional Requirements
• Batch Jobs to read the input files in various formats
• Batch Jobs to write to an output file in various formats
• Unit Test the Batch Jobs | String Test the Batches or Screens
• Using the Scheduler to schedule and run the batch cycle
• Designed and developed front end forms using Forms 10g
• Designed and developed Reports by using Reports 10g
• Involved in writing Technical Designs, Unit Test Plans and String Test Plans.
• Database design, creation and installation of Database Server & Clients.
• Performance monitoring and trouble-shooting at Application Level.
• Gathering the Client requirements and Peer reviewing the Functional Designs

Environment: LanguagesPL/SQL, SQL*Plus, Pro*C, C

Confidential

System Systems Analyst

Responsibilities:

• Designed and developed front end forms using Developer Suite 10g.
• Designed and developed Reports by using Developer Suite 10g.
• Involved in taking Backups, Restoring, Import/Export data.
• Database design, creation and installation of Database Server & Clients.
• Performance tuning of the database creating indexes on tables.
• Performance monitoring and trouble-shooting at the NT and Database Level.
• Managed and resized temporary and index table spaces.
• Optimized INIT.ORA parameters such as shared pool and rollback segments.
• Managed data files and resized table spaces.
• Troubleshooting on-site databases or application issues on-line thru VPN.

Environment: Oracle 10g, Developer Suite10g, PL/SQL, Windows NT / 2003.

Confidential

Project Leader

Responsibilities:

• Designing & Create front end Forms and Reports using Developer 2000 (6i).
• Developed screens, LOVs, alerts, list item controls, master-detail forms.
• Developed various reports as per the business and client requirements.
• Installed and created Oracle 8i back end database on Windows NT / 2003.
• Created tables, indexes, views, constraints, database triggers and sequences.
• Reorganized data using Export/Import. Managed users and passwords.
• Configured TNSNAMES.ORA for client connections.
• Analyze the User Requirement and Assign the same to the Programmers.
• Created stored procedures & Writing of Triggers for functionality.
• Testing on development environment and implementing to production.

Environment: Oracle 8i, Developer 2000 (6i), Windows NT/ 2000

Confidential

Senior Programmer

Responsibilities:

• Designing & Create front end Forms and Reports using Developer 2000 (6i / 4.5)
• Installed and created Oracle 8i back end database on Windows NT / 2003.
• Created tables, indexes, views, constraints, database triggers sequences.
• Created stored procedures & Writing of Triggers for functionality.
• Updating of Production Database by writing SQL Scripts.
• Maintaining user security, designing and implementing roles.
• Testing on development database and migration to production database.
• Data loading into Oracle database using Export / Import.
• Testing on development environment and implementing to production.

Environment: Oracle 8i, Developer 2000 (4.5 / 6i), Windows NT/ 2000

Confidential

Programmer

Responsibilities:

• Development/customization of Forms using Developer 2000 (Version 4.5)
• Development/customization of Reports using Developer 2000 (Version 2.5)
• Migration from Character Base to GUI.
• Involved in Form design, form coding.
• Written the validation functions for controls.
• Involved in Testing and debugging.
• Creating appropriate Indexes for optimum performance of the application.

Environment: Developer 2000(4.5), Oracle 7.x, Windows NT