We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer / Etl Developer Resume

Bellevue, Wa

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.
Confidential, Des Moines, IA

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
Confidential

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.
Confidential, St Louis, MO

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.
Confidential, Des Moines, IA

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.
Confidential, Denver, CO

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.
Confidential, Southlake, TX

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.

Hire Now