SUMMARY:

• Oracle Certified Professional (OCP) with more than 10 years of experience as Oracle PL/SQL Developer.
• Professional experience in handling Very Large Databases using Oracle 12c/11g/10g/9i.
• Proficient working experience in Oracle development using various Oracle key components such as PL/SQL, Stored Procedures, Functions, Packages, DB Triggers, External Tables, Merge Statements, Global Temporary Table(GTT), Bulk Load, Ref Cursor, Partitions, Dynamic SQL, Analytical functions, Materialized View, Cube, Dimensions, SQL*Loader, Data Pump, Export/Import and UTL FILE.
• Hands - on experience in performance tuning of SQL Statements and Stored Procedures using various Optimization techniques such as Hints, Indexes, TKPROF, Explain Plan and Autotrace.
• Experienced in data migration across different Oracle versions.
• Proficient working experience in ETL Tool like Informatica PowerCenter 9.1.0, Ascential DataStage 7.5
• Experienced in various functional domains such as Investments, Insurance, Banking, Healthcare and Materials Management
• Involved in all stages of SDLC (Software Development Life Cycle) from requirements gathering to production support using Waterfall and Agile methodologies
• Extensive experience in writing shell scripting
• Professional experience in reporting tools such as Crystal Reports, Actuate 9.

TECHNICAL SKILLS:

Databases: Oracle 12c/11g/10g/9i, SQL Server 2005

Database Tools: PL*SQL 2.0, SQL*Plus 9.2, Forms 6i/5.0, Reports 3.0

ETL Tools: Informatica 9.1.0, Ascential DataStage Standard (Server) Edition 7.5.1

Reporting Tools: Crystal Reports XI, Actuate 9, SQL Server Reporting Services (SSRS) Scripting Shell Scripting

Data Modeling Tools: Rational Rose, Erwin

Other Utilities: Toad 10.1.1.8, PL/SQL Developer, Visual Source Safe, PVCS, CVSRational ClearCase, HP Quality Center, Ascential Version Control, StarteamControl-M, Autosys, Github, PPMC

Operating Systems: Sun Solaris 5.8, Red hat Linux, UNIX, Windows NT

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Responsibilities:

• Created Stored Procedures, Packages, Materialized Views, and Indexes for implementing the business requirement.
• Extensively used Bulk Load, Collections, Ref Cursors and UTL FILE.
• Optimized the Query performance using Explain Plan and Hints.
• Extensively used utPLSQL for unit testing the PL/SQL.
• Involved in Discovery, Iteration planning, impact analysis and providing development estimates to delivery lead

Environment: Solaris 10, Linux, Oracle 12c/11g, PL/SQL, Toad, UNIX Shell script, Autosys, HP Quality Center (QC) and Github

Confidential, Merrimack, NH

Responsibilities:

• Created Stored Procedures, Packages, Materialized Views, and Indexes for implementing the business requirement.
• Optimized the Query performance using Explain Plan and Hints.
• Designed the ETL jobs using Informatica to Extract, Transform and Load the data into the Oracle Staging Tables.
• Involved in resolving the defects identified in DIT, SIT and UAT environments.
• Created UNIX Shell scripts as an interface to invoke Oracle stored packages.
• Implemented automated batch scheduling using Control-M for loading inbound feeds, processing relationships and crediting and generating Outbound Feeds.

Environment: Solaris 10, Linux, Oracle 11g, PL/SQL, Toad, UNIX Shell script, Control-M, Informatica, HP Quality Center (QC), ClearCase and PVCS

Confidential, New York City, NY

Responsibilities:

• Developed Stored Procedures, Packages and Materialized Views for implementing the UI application.
• Extensively used External Tables, Merge Statement and Global Temporary Table(GTT)
• Involved in Performance Tuning of the existing Stored Procedures using various Optimization techniques such as Explain Plan, Hints, Indexes, DBMS STATS, TKPROF and Autotrace.
• Implemented automated batch scheduling using crontab.

Environment: HP UNIX, Oracle 10g, PL/SQL, Toad, UNIX Shell script, and ClearCase

Confidential, New York City, NY

Responsibilities:

• Handled Very Large Database (VLDB) with the Database size of 7 terabytes.
• Created Stored Procedures, Functions & Packages for implementing the reporting requirements.
• Designed and implemented Account variance, Claim tracking, Claim Aging and several client facing reports for EDI and FNX (fee negotiation system).
• Developed and customized reports using Crystal Reports XI.
• Used the oracle advanced features like External Tables, Merge Statement and Global Temporary Table(GTT)
• Optimized the Query performance using the Oracle utilities like TKPROF, Explain Plan and Autotrace.

Environment: HP UNIX, Oracle 10g, PL/SQL, Toad, UNIX Shell script, Crystal Reports and VSS

Confidential, Morristown, NJ

Responsibilities:

• Developed stored procedures and implemented the reporting requirements.
• Developed and customized reports for Charles River Trading System using Actuate report designer.
• Involved in Performance Tuning and Query Optimizations of the existing Stored Procedures.
• Provided production support and handled Critical Issues.
• Used UNIX Shell scripting for different audit purposes as well as for running the PL/SQL scripts.
• Involved in the creation of database objects like tables, views, stored procedures, packages and triggers
• Used Dynamic SQL using execute immediate, Bulk Load, VARRAYS, and Object types.
• Used SQL*Loader to perform data loading.
• Involved in taking regular database backups using Export/ Import utility
• Involved in the creation of flat files using UTL FILE utility
• Involved in the DB links Creation, View and Synonyms

Environment: Oracle 10g, PL/SQL, Actuate 9, UNIX Shell script, Toad and CVS

Confidential, Schaumburg, IL

Responsibilities:

• Involved in the design for data acquisition and created technical specifications for the application.
• Designed the ETL jobs using Ascential DataStage to Extract, Transform and load the data into the Oracle based WSI Advanced Marketing Platform Data warehouse.
• Developed PL/SQL scripts, stored procedures, triggers to implement complex ETL transformations in Oracle 10g
• Used the oracle advanced features like External Tables, Merge Statement and Global Temporary Table(GTT)
• Involved in Partitioning for very large tables with millions of records.
• Used the techniques such as Bulk Load, Ref Cursors, No Copy complier hint to improve performance.
• Involved in design the operational process flow for the ETL jobs in Datastage.
• Designed and implemented jobs using DataStage Job sequencer.
• Executed periodic operations in DataStage Director and its run-time engine to schedule, validate, run and monitor the resulting executable versions.
• Used UNIX Shell scripting for different audit purposes as well as for running the PL/SQL scripts.
• Used Crontab for scheduling the jobs and batch job for loading the data.
• Used the Hints, Indexes, Analyze Commands, DBMS STATS, TKPROF, Explain Plan and Autotrace for Query Optimization
• Participated in building the error handling logic and Quality Metric design using the PL/SQL.

Environment: Ascential DataStage Standard (Server) Edition 7.5.1, Oracle 10g, PL/SQL, Erwin 4.1.4.4003 , AIX UNIX, Unix Shell script, Toad & Ascential Version Control.

Confidential

Responsibilities:

• Evaluated the tools for Data migration (Oracle Migration Workbench) and Stored Procedure migration (Swiss SQL and SQL Ways).
• Handled Very Large Database (VLDB) with the Database size of 5 terabytes.
• Migrated the Stored Procedures using Swiss SQL.
• Analysis of DB2 procedures and converted to oracle PL/SQL Procedures for the ETL, NMR Modules.
• Used the Oracle utilities like TKPROF, Explain Plan and Autotrace for Query Optimization.
• Created Partitions on database tables for quick accessing of Details.
• Involved in taking regular database backups using Data Pump utility.
• Involved in Unit testing and Integration testing for the ETL and NMR Modules.
• Involved in the System testing, Data Analysis and support for NMR application.

Environment: Oracle 10g, PL/SQL, UNIX Shell Scripting, Sun Solaris 5.8, Rational Rose, VSS and