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 with around 9 years of experience.
• Worked on the physical transformation of the data model which involved creating the 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 the requirements and managing the deadlines. Possess leadership, communication, motivational and inspirational skills.
• Ensuring quality, integrity and availability of the data.
• Assisting development in design of database systems and staged implementation of changes.
• Implemented the concept of PURGE/ARCHIVE process to delete the older data from OLTP system and archived the deleted data in HISTORY to reduce the volume of tables for the performance improvement.
• Used ON DELETE CASCADE feature to delete the data from Root table to child table in a complex Data model for faster delete and for system performance improvement.
• Monitoring the critical database and configuring metrics using OEM and AUTOSYS in providing the fix in case of threshold limits crossed.
• Resolving user tickets, fixing the data issues, storage and infrastructure support during work.
• Backup of databases and recoveries with RMAN. Replacing, deleting, or modifyingPL/SQL code to correct errors.
• Applying the required transformations using ETL tool Informatica Power Center andDataStage.
• 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 the PL/SQL code to load the data into dimensional and fact tables
• Created global temporary tables to improve the query performance and helped in tuning existing and new queries.
• Worked on multiple CMS applications to provide the 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 the 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 the data
• Attended meetings with business analysts and architects to gather the requirements and have developed the code based on the requirements.
• Developed process to swap the partitions between the initial source tables and ETL tables
• Created External Tables to load data from the external files to Oracle source tables.
• Worked with Range, List and Hash partitioning to improve the performance of the load process.
• Worked with Tortoise SVN and GIT SVN for the version control of the code.
• Developed Packages to load the source data into the landing zone of ETL tables
• Developed DBMS Jobs using DBMS Job scheduler and created and ran jobs through OEM Grid.
• Unit Tested the script and procedures written for the load process
• Written PL/SQL Packages, Functions and Procedures to implement the Business Logic.
• Involved in Integration test, System test and Implementation.
• Documented the technical details of the tasks worked on and the 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 the weekly status meetings and QA tested the load process developed by others in the team to validate the 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.

Oracle PL/SQL Developer / ETL Developer

Responsibilities:

• Written PL/SQL Packages, Functions and Procedures to implement the Business Logic and Design Technical Specifications from Functional Specification (Detail Design) documents.
• Mapped the extracted data from source systems and load it into the 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 the 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

Responsibilities:

• 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 the mapping and fixed the 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 the data is loading into target, which was extracted from different source systems according to the user requirements.
• Involved in production support working with various mitigation tickets created while the users working to retrieve the 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 the mapping and fixed the bugs.

Oracle Developer/Informatica ETL

Responsibilities:

• Involved as a key team member for Requirement Analysis during the design phase and developed various Design documents according to the user requirements.
• Developed various mappings using Informatica Power Center Mapping Designer and worked with 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 the data to target warehouse tables using Informatica Workflow Manager
• Migration of New and Changed Informatica objects across the environments using Folder to Folder and Deployment Group methods.
• Wrote PLSQL programs required to retrieve data from the 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 the functional specifications.
• Customer service and organizational skills for gathering the requirements and managing the deadlines. Possess leadership, communication, motivational and inspirational skills.
• Ensuring quality, integrity and availability of the data.
• Assisting and developing in design of database systems and staged implementation of changes.
• Monitoring the critical database and configuring metrics using OEM and providing the fix in case of threshold limits crossed.
• Resolving user tickets, fixing the data issues, storage and infrastructure support during work.
• Backup of databases and recoveries with 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 the costly bugs and functional errors and used right data model for the data mart based on the requirements.

Oracle PL/SQL Developer / ETL Developer

Responsibilities:

• Mapped the extracted data from source systems and load it into the target systems after applying the 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 the 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 the mapping and fixed the 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 the upgrade of Oracle 9i to 10g.
• Performed Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Involved in production support working with various mitigation tickets created while the users working to retrieve the 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.

Informatica ETL Developer/Oracle

Responsibilities:

• Involved in Requirement Analysis and developing the 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 the 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 the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Extracted the data from the 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 the 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 the 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.

Programmer/Analyst

Responsibilities:

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