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 and inCollections (PL/SQL Tables and array’s), SQL and Oracle supplied packages.
• Extensive experience in Data Modeling, Relational Database concepts and ER diagrams.
• Received training and actively practiced the Agile, Kaizen, Kanban methodologies 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.
• Developed packages, procedures, functions, code optimization required for the development of interfaces to suffice the requirement.
• Experience in performance tuning and Sql optimization using (Hints, Explain Plan), restructuring tables, denormalize tables and build Materialized views.
• 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

Oracle 9i/10g/11g, MS Access, MS SQL Server, DB2

ETL Tools

SQL*Loader

OS

MS DOS, Windows 2K/XP, Linux, UNIX, Sun Solaris

Languages

SQL, PL/SQL, HTML, XML, JAVA, UNIX Shell scripting

TestingTools

Quality Center, Clear Quest

DBTools

TOAD, SQL Programmer, SQL Developer and Import/Export, Pl/Sql Developer

Confidential, Valley Forge, PA
Senior Developer Feb 12 Present
Vanguard Group is one of the world’s largest investment management companies that offers mutual funds and financial products and traditional management services to individual and institutional investors in United States and abroad.
Responsibilities:

• As a product lead, identified the key business needs of the client in prod support team to fix the issues using Kanban methodology.
• Extensively worked on packages and procedures using cursors, Pl/SQL Tables and Collections with exception handling.
• Involved in Database partitioning to improve the availability, performance and maintainence and applying Indexes as part of optimization techniques in the interface development and trouble-shooted the performance issues and bugs within packages,
• Integrated the VPAS system - Oracle based system and Vanguard legacy systems working in conjunction with the data conversion and data identification teams
• Co-ordinated and Interacted with the front-end application team and testing team for any kind of database issues and fixed them.

Environment: Oracle 11g, UNIX/Solaris, TOAD 10.6, SQl Programmer, SQL*Loader.

Confidential, Ramsey, NJ
Senior Oracle Developer Jul 10 Dec 11
Alere Health LLC, is a provider of personal health support solutions and offers health management offer encompassing services for chronic diseases and insight to take the actions for the better health.
Description: Working on Healthcare management system to offer best services on Providers, Claims and services related to other client related data in a huge database in Oracle 11g using TOAD, Pl/Sql Developer, Import/Export etc.,
Responsibilities:

• In the capacity of team lead, was responsible for design documents, technical documentation and implementation of database design.
• Developed the procedures to integrate and sync the data in Oracle DB supporting the legacy system, SQL Server 2008 using DB Links and scheduled the jobs to automate the process.
• Extensively worked on Dynamic SQL and expertise in Collections and PL/SQL using cursors, reference cursors, FORALL and BULK COLLECT to handle multiple records
• Involved in the performance tuning and optimization of SQL queries whileusing unique, bit-map and function-based indexes and Index-Hints whenever required for the faster retrieval of the data and tracing the statistics with Explain Plan.
• Expertise inusing advanced features of Oracle 11g such as Merge, Oracle analytical functions, global temporary tables, string aggregation techniques, Invisible Indexing etc., when necessary.
• Good knowledge and familiarity with the Materialized views to refresh jobs and DBMS Scheduler jobs.

Environment: Oracle 11g, UNIX, TOAD 9.0, Pl/SQl Developer 8.0, SQl Programmer, SQL*Loader.

Confidential,Hershey, PA
Senior Oracle Developer Feb 10 Jun 10
Hershey\'s is one of the oldest chocolate manufacturing companies in the United States and its headquarters are located in Hershey, PA.
Description: Worked on Siebel CRM Application supporting the client and customer relationship for tracking the Sales Volume Planning, Consumptions, Customers, Products and other information with Oracle database as the backend in the UNIX environment.
Responsibilities:

• Configured and built the database objects, packages, stored procedures, functions for the business scenarios for the huge implementation of tracking the Product and Sales information for the client.
• Performed schema comparison and Import/Export to sync up the data in test and production regions.
• Workedon UNIX (K-shell) environment, developed the shell scripts required to retrieve from the database and populate the necessary in the Siebel tables.
• Highly experienced in writing the Control files and shell scripting for conversion program and loading external data from flat files using SQL* Loader.
• Worked on FTP in the UNIX environment to import and export the data files and place the scripts in the appropriate locations so that they could be executed with Shell scripts.
• Defects were tracked, reviewed, analyzed and compared using Quality Center.

Environment: Oracle 10g, SQL, PL/SQL and UNIX, TOAD, SQL Programmer SQL*Loader, Putty, Siebel CRM.

Confidential,Valley Forge, PA
Senior Developer Jan 07 Jan 10
Vanguard Group is one of the world’s largest investment management companies that offers mutual funds and financial products and traditional management services to individual and institutional investors in United States and abroad.
Description: Vanguard Pension Administration System VPAS, 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.
Responsibilities:

• Expertise in data modeling and design with normalization/denormalization techniques.
• Implemented the business into the current system VPAS to ensure the successful conversion of Defined Benefit Clients using agile methodology techniques.
• Wide experience in applying business logic using database triggers, Packages, Stored Procedures, Functions and autonomous transactions tointegrate the data from the legacy system to into the Oracle database.
• Participated in code packaging, data identification and optimization of SQL queries when needed.
• Vast knowledge on the Version management capabilities and comprehensive coverage across the version, defect and issue management on the Serena Issue and Defect management to co-ordinate the system development.

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

Confidential,New York City, NY
Oracle Developer Jul 06 Dec 06
Coty, Inc. 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.
Description: Worked on customized Database implementing Oracle Applications Enterprise Resource Management system, more into the customization of the interface program development, modifying existing Reports and optimizing the queries.
Responsibilities:

• Involved in Software Requirement Specification and technical design, development, testing, Implementation and Training with web Development techniques. Wrote stored procedures to provide extra functionality, including loading and modifying of data and retroactive business rule changes.
• Built Sql scripts for reporting and tracking purposes.
• 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.

Environment/Tools: ORACLE Applications 11i, Oracle 9i, SQL*Plus, Toad, SQL*Navigator.

EDUCATION:

• M.S Control Systems