PROFESSIONAL SUMMARY:

• 11 years of extensive experience in the field of Information Technology with PL/SQL, Oracle Databases, ETL and Informatica.
• Application Developer for Confidential from , working on developing speciality pharmacy applications and Enterprise Data Warehouse to support Speciality Pharmacy Operations and Reporting.
• Application Developer for Confidential from , working on the Clinical Data Operational Datastore and the Enterprise Data Warehouse.
• Technology Consultant with Confidential from , in both functional and technical roles across both execute (Development) and operate (Post Production Support) phases of large scale projects in the IT Industry.
• Possess extensive knowledge of client’s business process spanning across the health care Industry and Public - sector engagements that have Oracle Applications, JAVA Applications or .NET Applications.
• 10 years of experience as an Oracle Database Lead and Oracle Database Developer, which includes designing, developing, debugging and improvising database applications in Oracle RDBMS 12c,11g/10g/9i/8i OLTP and OLAP environments.
• Ability to write SQL queries and PL/SQL programming making use of Oracle Collections like Varrays, Nested Tables and PL/SQL objects like Functions, Stored Procedures, Packages, Triggers, Constraints, Exception handling, Dynamic SQL, Views, REF Cursors, CLOBs and BLOBs.
• Proficient in rewriting, optimization and tuning SQL queries using Optimizer Hints, alternative indexing strategies and by reviewing the explain plan/execution plan.
• Proficient in using the SQL*Loader Utility to import data from flat files using a defined control file.
• Skilled at multithreading Oracle Processes using the DBMS Parallel processing to ensure better utilization of the processing capabilities.
• Experienced in using software change management utilities lie Harvest SCM, Tortoise SVN and SharePoint.
• 6 years of experience in Data Warehousing ETL using Informatica 9.1/8.6.1/8.5/8.1 . PowerCenter Client tools - Mapping Designer, Workflow Designer, Repository manager, Workflow Manager for loading data into OLTP and OLAP databases.
• 3 years of Unix Shell Scripting experience gained while automating Custom ETL and ELT jobs using the CRON Tab and parsing text files to be loaded into the oracle database using the SQL*LOADER Utility.
• Skilled at using the SQL Developer Data Modeler and ERWIN Data Modelling tool.
• Good understanding of JAVA Application Development and integration with Oracle PL/SQL Objects for Data Access like calling stored procedures and package procedures from JAVA code as well as building Value Objects and Data Access Objects.
• Worked on developing Unix Shell Scripts to perform as custom FTP service.
• Have good knowledge in providing troubleshooting, issue debugging, production maintenance, production support in 24x7 environments and proficient in using Microsoft Office Suite tools for business purposes.
• Excellent communication and interpersonal skills and ability to work independently with minimal supervision to meet deadlines.

IT SKILLS:

Operating Systems: Linux, Windows7/XP/NT/98

Languages and Technologies: PL/SQL, Unix Shell scripting

Concepts: ETL, ELT, OLTP, OLAP, Database Schema designing

Software: Informatica 9.1/8.6.1/8.5/8.1 , Oracle SQL Developer, SQL Modeler, JIRA, IBM ClearQuest, Harvest SCM, Tortoise SVN

Database: ORACLE 12c,11g/10g/9i/8i

ORGANISATIONAL EXPERIENCE:

Confidential, Monroeville, PA

PL/SQL Lead/Developer

Responsibilities:

• PL/SQL Development, Unix Shell Scripting.
• Developed a process for transitioning patient information and prescription information from legacy Oracle Forms Application to New Oracle database schema tables.
• Wrote stored procedures to parse and analyse CLOB data for business needs.
• Developed many stored procedures and functions to suit business needs and accomplish business objectives.
• Designed and Developed a new process, including table structure, to store third party vendor information. These vendors are then paid based on their services to the patients for each bill that is generated.
• Designed and developed process to capture Customer Credit Card Information using Third Party SEMAFONE web application invoked from Oracle Form for secure PCI compliance.
• Developed Stored Procedures and Oracle Packages that were invoked by the JAVA application for Data Access and Data Validation.
• Worked on the Oracle Explain Plan for many long running queries to improve application performance as well as batch process performance.
• Used Tortoise SVN for checking-In code and managing code changes and migration.

Confidential, Detroit, MI

PL/SQL Lead/Developer

Responsibilities:

• PL/SQL Development, Unix Shell Scripting, Informatica Mapping and Workflow Designer.
• Worked on developing a custom ELT process that loads the xml file with Hospitalization data of members into Clinical Database. This file is in Health Level 7 international standards that is used to sanitize the data collected from hospitals.
• Custom ELT process has ability to add new fields in the input without any code change and least Production Office intervention. This was accomplished by making use of Dynamic SQL with the fields stored in a configuration table.
• Designed a schema for storing Medication reconciliation information of patients using the SQL Developer Data Modeler. The solution required about 32 new table that were designed in a Star Schema with referential integrity maintained with respect to the Patient data.
• Wrote stored procedures to parse and analyse CLOB data for business needs.
• Worked on developing many Shell Scripts to parse and load data into the staging tables by employing the SQL*LOADER Utility and stored Procedures in Oracle 11g and 12c OLTP and OLAP environments.
• Extract the data from multiple source systems like Oracle 11g/12c, SQL Server 2014 etc.
• Partitioned the Database tables (70 tables) to improve the performance of queries and provide an appropriate archiving solution instead of using separate archive tables. With the partitioning of the tables, the file system has become an archival solution.
• Worked on improving about 30 queries over the last year to ensure that all jobs that are scheduled to run complete at the expected time.
• Developed Stored Procedures and Oracle Packages that were invoked by the JAVA application for Data Access and Data Validation.
• Developed JAVA Value Objects and Data Access Objects for project requirements.
• Used Harvest SCM for source code management, code migration and versioning needs.

Confidential, Camp Hill, Harrisburg, PA

PL/SQL Lead

Responsibilities:

• PL/SQL Development, Informatica Mapping and Workflow Designer.
• Identify gaps in the HBE application. These gaps tend to cause faulty data which effects the end customers who claim insurance services from service providers through this portal.
• Provide data fixes to correct the faulty data. Identify patterns in these errors to help fix the bugs in the HBE application.
• Provide data fixes for faulty enrolments. These are caused because of existing application bugs and some time because of incorrect data entered by the customers. This would tend to jeopardize the customer’s health insurance coverage.
• Prepared PL/SQL Stored procedures to identify all data anomalies across the system.
• This was an exhaustive process that lasted 6 months. In these 6 months, we converted all the business rules into a PL/SQL process that would be triggered once a week to provide a report of the data with anomalies.
• Worked independently on a PL/SQL process to identify and fix all data security issue, primarily involving PII violation.
• Worked on CLOB and BLOB data in accordance with business needs.
• Developed the oracle processes to run in parallel by making use of Oracle DBMS Parallel Execute capabilities to multithread the process objectives.
• Designed a schema for identifying PII violations be flagging duplicate and shared person Ids within the system. This required 7 new table designed in the Star Schema to identify unique individuals based on the person demographic information.
• Worked with a team which Upgraded Oracle DB 10g to Oracle 11g.
• Worked on migrating data from legacy system to Oracle database using Informatica ETL Tool.
• Used Tortoise SVN for checking-In code and managing code changes and migration.

Confidential

PL/SQL Developer

Responsibilities:

• PL/SQL Development, Informatica Mapping and Workflow Designer.
• Developed Forms using Oracle Forms builder to display department specific data at a sales representative level.
• Developed Reports using Oracle Reports Builder to report on the sales representative performance for the Directors to review the Sales Campaign effectiveness.
• Worked on Informatica PowerCentre tools- Mapping and Workflow Designer, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse and loading data from various sources into Oracle 11g Database.
• Created mapping documents to outline data flow from sources to targets.
• Developed PL/SQL Objects like Stored Procedures, function and custom BI publisher reports during the implementation and operate team.

Confidential

PL/SQL Developer and Data Quality Tester

Responsibilities:

• Assisted in the development of Function Design Documents, developed and executed test scripts.
• Performed Data Testing by running queries to identify data anomalies that were reported to the SIEBEL Development team who in turn fixed the code.
• Provided data testing and data quality reports using PL/SQL Stored Procedures.
• Assisted in the maintenance of all client functional and technical documentation by acting as the SharePoint representative for the entire offshore team.

Confidential

PL/SQL Developer and Data Quality Analyst

Responsibilities:

• Assisted the development team in understanding the functional impact of technical design changes. Identified gaps in business requirements and communicated them to the client.
• Conducted impact analysis to understand technical data model changes from a set of high level business requirements.
• Provided data testing and data quality reports using PL/SQL Stored Procedures.
• Successfully supported the application and delivered enhancements with minimum defects.