SUMMARY

• Developing software applications using Oracle 12c/11g/10g/9i database server, and other Oracle products in wide range of applications including Health care, Banking/financial, Manufacturing and Agricultural sectors wif around 9 years of experience.
• Worked on teh physical transformation of teh data model which involved creating teh database objects like Tables, Indexes, Stored Procedures, Functions, DB Links, Packages, Triggers, Views and Materialized Views.
• Application Development using Oracle SQL, PL/SQL, Oracle Forms/Reports and Informatica ETL.
• Administration of Oracle databases on Unix/Windows platforms. Vast experience in Data modeling, Development.
• Customer service and organizational skills for gathering teh requirements and managing teh deadlines. Possess leadership, communication, motivational and inspirational skills.
• Ensuring quality, integrity and availability of teh data.
• Assisting development in design of database systems and staged implementation of changes.
• Implemented teh concept of PURGE/ARCHIVE process to delete teh older data from OLTP system and archived teh deleted data in HISTORY to reduce teh volume of tables for teh performance improvement.
• Used ON DELETE CASCADE feature to delete teh data from Root table to child table in a complex Data model for faster delete and for system performance improvement.
• Monitoring teh critical database and configuring metrics using OEM and AUTOSYS in providing teh fix in case of threshold limits crossed.
• Resolving user tickets, fixing teh data issues, storage and infrastructure support during work.
• Backup of databases and recoveries wif RMAN. Replacing, deleting, or modifying PL/SQL code to correct errors.
• Applying teh required transformations using ETL tool Informatica Power Center and DataStage.
• Installing and Configuring Oracle databases, implementing effective backup and recovery strategies.
• Scripting using SQL, PL/SQL, UNIX Shell programs and providing production Support.
• Used DBMS PARALLEL EXECUTE package extensively in PL/SQL procedures to incrementally update table data in parallel.
• Used Query tuning techniques for better performance and execution through suitable Indexes, Primary - Foreign key constraints.
• Developed Data Mapping and Data Conversion scripts using SQL and PLSQL.
• Experience in using sql trace and tkprof tools for SQL tuning, used explain plan, analyze and hints.
• Experienced in Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) System Study, Analysis and E-R modeling.

TECHNICAL SKILLS

Databases: Oracle 12c,11g/10g, MS SQL Server

Languages: SQL, PL/SQL, C, C++

Tools: TOAD, SQL Developer, PL/SQL Developer, Oracle Enterprise Manager 10g/11g, SQL*Plus, SQL*Loader, Oracle Forms and Reports

Internet Technology: HTML 5.0, XML, .NET

Scripting: Unix Shell Scripting, Java Script, Perl

Operating Systems: Solaris, Red Hat Linux, UNIX, Windows 95/98/2000/NT/XP/Vista and AIX

ETL Tools: Informatica, DataStage

PROFESSIONAL EXPERIENCE

Confidential, Bellevue, WA

Oracle PL/SQL Developer / ETL Developer

Responsibilities:

• Worked on ETL process for New York state and Arkansas State department of Health Data ware house project.
• Implemented teh PL/SQL code to load teh data into dimensional and fact tables
• Created global temporary tables to improve teh query performance and helped in tuning existing and new queries.
• Worked on multiple CMS applications to provide teh health care data based on Medicare and Medicaid claims for Arkansas and New York states.
• Developed SQL/PLSQL code to develop various Episode of Cares data into dimensional and fact tables.
• Worked on various CRs and quarterly EOC runs to provide teh data to end users for Data mining and Business Intelligence purposes for CMS applications.
• Performed Development, Testing and Code reviews, extensively worked on preparing test cases and plans to verify teh data
• Attended meetings wif business analysts and architects to gather teh requirements and have developed teh code based on teh requirements.
• Developed process to swap teh partitions between teh initial source tables and ETL tables
• Created External Tables to load data from teh external files to Oracle source tables.
• Worked wif Range, List and Hash partitioning to improve teh performance of teh load process.
• Worked wif Tortoise SVN and GIT SVN for teh version control of teh code.
• Developed Packages to load teh source data into teh landing zone of ETL tables
• Developed DBMS Jobs using DBMS Job scheduler and created and ran jobs through OEM Grid.
• Unit Tested teh script and procedures written for teh load process
• Written PL/SQL Packages, Functions and Procedures to implement teh Business Logic.
• Involved in Integration test, System test and Implementation.
• Documented teh technical details of teh tasks worked on and teh deployment documents.
• Assist reporting teams in developing Tableau visualizations and dashboards using Tableau Desktop.
• Good understanding and implementation of Tableau features like calculated fields, parameters, joins, filters and data blending.
• Attended teh weekly status meetings and QA tested teh load process developed by others in teh team to validate teh process.
• Tuning SQL Statements, PL/SQL Packages, Triggers, Functions and Procedures.
• Involved in Database performance tuning using Explain plan.
• Used Query tuning techniques for better performance and execution through suitable indexes, primary-foreign key constraints.

Confidential, Des Moines, IA

Oracle PL/SQL Developer / ETL Developer

Responsibilities:

• Written PL/SQL Packages, Functions and Procedures to implement teh Business Logic and Design Technical Specifications from Functional Specification (Detail Design) documents.
• Mapped teh extracted data from source systems and load it into teh target systems
• Use SQL*Loader/Perl Script to load data from various sources into an Oracle database.
• Written PLSQL programs required to retrieve data from teh Data repository using Cursors, Dynamic SQL, Global Temporary tables and Exception handling.
• Involved in Quality Assurance testing, Integration test, System test and Implementation.
• Good experience in Database Design of logical and physical models of various applications Using Sybase Power Designer.
• Proficiently developed test cases in Quality Center.
• Extensively developed complex PL/SQL packages for Pricing.
• Written complex SQL using joins, sub-queries and correlated sub-queries.
• Used debugger to test teh mapping and fixed teh bugs.
• Developed Data Mapping and Data Conversion scripts using SQL and PL/SQL.
• Applied Performance Tuning logic to optimize session performance.
• Attended business user sessions to make changes in warehouse loads.
• Performed Unit testing, User Acceptance Testing to check whether teh data is loading into target, which was extracted from different source systems according to teh user requirements.
• Involved in production support working wif various mitigation tickets created while teh users working to retrieve teh database.
• Developed UNIX Korn shell scripts to process file feeds.
• Involved in production support during deployment.
• Developed shell scripts for batch processing and database transactions.
• Tuning SQL Statements, PL/SQL Packages, Triggers, Functions and Procedures.
• Involved in Database performance tuning using Explain plan.
• Used Query tuning techniques for better performance and execution through suitable indexes, primary-foreign key constraints.
• Written complex SQL using joins, sub-queries and correlated sub-queries.
• Used debugger to test teh mapping and fixed teh bugs.

Confidential, St Louis, MO

Oracle Developer/Informatica ETL

Responsibilities:

• Involved as a key team member for Requirement Analysis during teh design phase and developed various Design documents according to teh user requirements.
• Developed various mappings using Informatica Power Center Mapping Designer and worked wif Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Created and Configured Workflows, Worklets and Sessions to transport teh data to target warehouse tables using Informatica Workflow Manager
• Migration of New and Changed Informatica objects across teh environments using Folder to Folder and Deployment Group methods.
• Wrote PLSQL programs required to retrieve data from teh Data repository using Cursors.
• Develop and maintain complex stored procedures, triggers, functions and ad-hoc SQL scripts in a highly normalized ORACLE, SYBASE databases comprised of 400+ tables.
• Extensively involved in preparing Detailed Technical Documents from teh functional specifications.
• Customer service and organizational skills for gathering teh requirements and managing teh deadlines. Possess leadership, communication, motivational and inspirational skills.
• Ensuring quality, integrity and availability of teh data.
• Assisting and developing in design of database systems and staged implementation of changes.
• Monitoring teh critical database and configuring metrics using OEM and providing teh fix in case of threshold limits crossed.
• Resolving user tickets, fixing teh data issues, storage and infrastructure support during work.
• Backup of databases and recoveries wif RMAN. Replacing, deleting, or modifying PL/SQL code to correct errors.
• Installing and Configuring Oracle databases, implementing effective backup and recovery strategies.
• Developed Data Mapping and Data Conversion scripts using SQL and PL/SQL.
• Involved in Code Reviews and preparing Unit test cases.
• Used Quest code tester for Oracle, a component of Toad used to identify and eliminate teh costly bugs and functional errors and used right data model for teh data mart based on teh requirements.

Confidential, Des Moines, IA.

Oracle PL/SQL Developer / ETL Developer

Responsibilities:

• Mapped teh extracted data from source systems and load it into teh target systems after applying teh required transformations using Oracle SQL/PLSQL.
• Use SQL*Loader/Perl Script to load data from various sources into an Oracle database.
• Written PL/SQL Packages, Functions and Procedures to implement teh Business Logic.
• Involved in Integration test, System test and Implementation.
• Proficiently developed test cases in Quality Center.
• Extensively developed complex PL/SQL packages for Pricing.
• Written complex SQL using joins, sub-queries and correlated sub-queries.
• Used debugger to test teh mapping and fixed teh bugs.
• Created mapping documents to outline data flow from sources to targets.
• Applied Performance Tuning logic to optimize session performance.
• Attended business user sessions to make changes in warehouse loads.
• Developed UNIX Korn shell scripts to process file feeds.
• Involved in production support during deployment.
• Developed shell scripts for batch processing and database transactions.
• Tuning SQL Statements, PL/SQL Packages, Triggers, Functions and Procedures.
• Application Testing and Documentation in teh upgrade of Oracle 9i to 10g.
• Performed Unit testing, User Acceptance Testing to check whether teh data is loading into target, which was extracted from different source systems according to teh user requirements.
• Involved in production support working wif various mitigation tickets created while teh users working to retrieve teh database.
• Involved in Database performance tuning using Explain plan.
• Used Query tuning techniques for better performance and execution through suitable indexes, primary-foreign key constraints.

Confidential, Denver, CO

Informatica ETL Developer/Oracle Forms and Reports

Responsibilities:

• Involved in Requirement Analysis and developing teh Project Definition Document.
• Responsible for Business Analysis and Requirements Collection.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building teh ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modeling (Star Schema) of teh Data warehouse and used Erwin to design teh business process, dimensions and measured facts.
• Extracted teh data from teh flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in teh Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Developed a PL/SQL conversion program and SQL*Loader program for validating and migrating teh legacy agent’s information into Oracle base tables.
• Involved in Performance Tuning of various custom PL/SQL reports and PL/SQL packages.
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Developed Master Detail, Detail reports using tabular and Group above reports.

Confidential, Southlake, TX

Programmer/Analyst - Intern

Responsibilities:

• Understanding teh business requirements and load teh reference data tables wif values provided by UI team.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Requirement Analysis and developing teh Project Definition Document.
• Involved in Code Reviews and preparing Unit test cases.
• Performed SQL code implementation.