SUMMARY

• Excellent experience in data analysis, design, development, customization and testing of various business applications involving Oracle 10x/11x.
• Expertise in writing anonymous blocks, procedures, packages, functions, triggers, views and other database objects using SQL and PL/SQL.
• Expertise in Collections (PL/SQL Tables and array’s), SQL and Oracle supplied packages.
• Studied gap analysis and designed extensions to bridge the gap between business needs and

product functionality.

• Good knowledge of data acquisition, data integration and data loading.
• Received training and actively practiced the Agile methodology and Software Development Life Cycle (SDLC) for large-scale software projects.
• Extensively used SQL*Loader to load data from flat files, worked with external tables.
• Performed SQL tuning, DB performance enhancement tasks for the performance and speed of execution of database objects and performed dynamic SQL embedding and execution.
• Developed packages, procedures, functions, code optimization required for the development of interfaces to suffice the requirement.
• Good knowledge and experience in data modeling, database design using industry standard tools, handling security issues, importing and exporting database.
• Expertise in performance tuning, normalization and De-normalization, indexing of tables.
• Have a professional attitude and excellent communication skills, self-motivated and multi-task oriented, with strong work ethics and the ability to work effectively.

TECHNICAL SKILLS

Databases: Oracle 9i/10g/11g, MS Access, MS SQL Server
ETL Tools: SQL*Loader
OS: MS DOS, Windows 2K/XP, Linux, UNIX, Sun Solaris
Languages: SQL, PL/SQL, HTML, XML, JAVA, UNIX Shell scripting
Tools: TOAD, SQL Programmer, SQL Developer and Import/Export

PROFESSIONAL EXPERIENCE

Confidential,Valley Forge, Pennsylvania, USA

Oracle Developer Jan 07 - Present

Confidential,is one of the world’s largest investment management companies that manage approximately $1.3 trillion in assets. This offers mutual funds and financial products including index, risk-controlled active quantitative and traditional management services to individual and institutional investors in United States and abroad. Defined Benefit Services is one of the wide ranges of the services that Vanguard provides the customized solutions and traditional pension plans that defines a benefit for an employee upon the retirement.
Description: Confidential,is the ground-breaking implementation of a new pension administration system for Defined Benefit Services. This enables deliver outstanding value to our clients by increasing the efficiency of our operations. Improves the business user experience, simplifies data access and expands audit capabilities.

Responsibilities:

• Configured and built the database objects, packages, stored procedures, functions, and database triggers.
• Worked on UNIX (K-shell) environment to retrieve data from the database and produce the retrieved data in list files, which are important for creating reports.
• Actively participated in the client and business meetings and gathered the business requirements to integrate the operational data.
• Extensively worked on Dynamic SQL and expertise in Collections and PL/SQL using cursors, reference cursors, FORALL and BULK COLLECT to handle multiple records
• Performed the performance tuning, optimization of SQL queries, normalization and De-normalization, indexing of tables for the speed and the execution of reports.
• Followed the agile methodology and assisted with the significant business changes and required enhancements to existing Oracle systems as well as new add-ons and interfaces.
• Expertise in Data Modeling, Database design using industry standard tools, handling security issues, importing and exporting database.
• Extensive knowledge on the Version management capabilities of Serena PVCS Version Manager and comprehensive coverage across the version, defect and issue management on the Serena Issue and Defect management to co-ordinate the system development.
• Highly experienced in writing the Control files and shell scripting for conversion program and loading external data from flat files using SQL* Loader.
• Experience in writing anonymous blocks, procedures, packages, functions, triggers, views and other database objects using SQL and PL/SQL.
• Performed unit testing for all the development activities and involved during the design phase of the project for requirement analysis.
• Involved in the integration testing with a focus on improving the quality of production deliverables.

DBMS developments include building data migration scripts using Oracle SQL*LOADER and UTL packages.

• Interfaced with the business users in conceptualization and development of business requirements and their technical realization with the development environment.
• Coordinated with the business team, data conversion and data identification teams for system testing.
• Involved in preparing the functional/technical documentation according to the business user needs.
• Integrated the VPAS system - Oracle based system and Vanguard legacy systems working in conjunction with the data conversion and data identification teams.
• Implemented the business into the current system VPAS to ensure the successful conversion of Defined Benefit Clients.
• Outstanding analytical and problem solving abilities, interpersonal, verbal and written communicational skills and an effective team player.

Environment: Oracle 9i/10g, SQL, PL/SQL and UNIX, Power Builder 7.0, TOAD, SQL Programmer SQL*Loader, UTL Scripts, MS-DOS.

Confidential,
Oracle Developer Jul 06 – Dec 06

Confidential,is a beauty products manufacturer whose core businesses are fragrances, color cosmetics, and skin care. It is known for its cooperation with designers and celebrities for the creation of fragrances. It has achieved a leadership position in fragrance and quickly emerged as a global leader in the world of beauty with the sales of $4 billion.

Description: Worked on customized Database implementing Oracle Applications Enterprise Resource Management system. Developed the customized Reports for the in OM & Shipping and registered in Oracle applications and involved in the customization of the interface program development, modifying existing Reports and optimizing the queries.

Responsibilities:

• Involved in Client meetings to gather the business requirements and analysis of the same.
• Worked on mapping the data and data identification.

Wrote stored procedures to provide extra functionality, including loading and modifying of data and retroactive business rule changes.

• Developed shell scripts for batch processing for loading the database transactions.
• Configured and built the re-usable base of functions and stored procedures and Database objects.
• Wide experience in applying business logic using SQL Scripts, PL/SQL, Database Packages, Stored Procedures, Functions and Triggers.
• Worked on Performance Tuning issues and bugs within packages using explain plan and TKPROF.

Used PL/SQL that allows creating Web Applications using Oracle stored procedures. Modified existing packages to add new functionality and to optimize the performance.

• Performed unit testing for all the development activities and involved during the design phase of the project for requirement analysis.
• Worked with cross-functional teams such as business, data and testing while performing the unit-testing and integration testing with a focus on improving the quality of production deliverables.
• Involved in deployment of various versions of application builds to different development and testing environments and regions in UNIX environment.
• Trained new developer to assist in ongoing system support and maintenance.

Identified and fixed more than 20 bugs in the application.

• Monitored the database and tuned the application code for the better performance

Keep track of source code additions and changes and versions using version control software.

Environment/Tools: ORACLE Applications 11i, Oracle 8i, Developer 2000, SQL*Plus, Toad, SQL*Navigator, PL/SQL, Reports 2.5, Forms 4.5, Discoverer 3.0, Modules - AOL, AR, AP, PO, Order Entry.

Confidential,INDIA

Project Engineer Jun 03 – Jul 04

A multi-disciplinary organization which has major contributions in Atomic Energy Sector, Space, defense sector, Electronic Security Applications, Communications & Networks, E-Governance Applications and Exports. It has committed partnerships with nuclear energy establishments of India particularly Bhabha Atomic Research Center (BARC), Nuclear Power Corporation of India Limited (NPCIL) and also supports other strategic sectors such as defense, Department of Space, Civil aviation.

Description: Worked on the development of the automation of relay logic in a customized Database. Designed and implemented a robotic model “Automation of pellet pushing arrangement” for fabrication of uranium oxide pellet and coordinated with a team to analyze ladder logic using Allen Bradley Micrologix 1000 which is still in use.

• System study, analysis and collection of information from various user groups.
• Interacted with the end-users for gathering requirements.
• Involved in testing the scripts in test database and moved into production.
• Entailed migrating files from mainframe and loading them to Oracle database using SQL Loader.
• Creating indexes on huge number of data available in tables based on requirements.
• Worked in a team to develop relay logic for the inspection method of pellets using stepper motor.
• Modifying the objects like add or drop columns or change the columns data type size if needed.
• Optimized the queries using EXPLAIN PLANS and SQL analyzer.
• Used FTP to transfer dump files from production server to testing server.

Environment: UNIX, Oracle8i, Reports2.5, TOAD, SQL*Loader, UTL Scripts, SQL, PL/ SQL, Power Builder 4.0

EDUCATION:

• M.S Control Systems
• B.S Electricals and Electronics Engineering