SUMMARY

Over ** years of IT experience in Analysis, Design, Development, Implementation and Testing of Data Warehousing and Business Intelligence Applications using ETL and BI tools with Informatica PowerCenter 10.x/9.x/8.x, Oracle 11g/10g/9i, SQL, PL/SQL, SQL*Plus, SQL developer.

Ability to quickly grasp new concepts and team player with strong leadership and time management skills.

Possess strong communication and problem-solving skills with positive attitude.

TECHNICAL SKILLS:

Operating Systems: Windows, UNIX, LINUX

Programming Languages: SQL Plus, PL/SQL, C, Java, Unix shell scripting

Web: XML, HTML

Databases: Oracle 11g/10g/9i/8i, SQL SERVER 2016/2012/2008/2005, Teradata

BI and DW Technologies: Informatica Power Center 10.x/ 9.x/8.x, Business Objects XI R2, Talend

Tools: Erwin, Visio

EDUCATION:

MASTER OF SCIENCE IN COMPUER SCIENCE – 02/2008-12/20009

BACHELOR’S IN INFORMATION TECHNOLOGY – 07/2003-04/20007

PROFESSIONAL EXPERIENCE:

Genentech. Inc, South San Francisco, CA Apr 2013 – Till Date

Senior ETL Developer

Project Description:

1)Connect GA/ ONE GA: Purpose of this project is for User to view a summary of the GNE Asset data for the given state, listing all the aggregates from the 4 categories: GNE Clinical Trials data, GNE Charitable contributions, GNE Employee data, GNE Authorized Distributors.

2)Org Split (MDM): Purpose of this project is to have a separate PA 2020 Org instance since it deals with PHI/PII data and another Org for Synapse leaving the other SFDC applications on the main Org. As part of the proposed Common Foundation Solution, Master Data Management life cycle needs extended to support for Multi Org Application Environment of SFA, PA2020 and Synapse. Based on this Org Split over all solution will allow common application reusable components to each Multi Org Application Environment to extend and customize the Master Data Management integration with application org.

3)Customer Contract Channel Performance Insight (C3PI): The primary focus of C3PI Phase 2B is to provide MCCO the ability to measure effectiveness of our contract strategies, enhance operational capabilities to support business processes and develop infrastructure to support future requirements.

4)SFDC-ODS: ODS was built to extract data from multiple source systems like SFDC, Oracle, Flat files and provide landing area for downstream applications.

Responsibility:

Worked closely with application owners, business users, collected the requirements, designed the data flow, created technical documents, and developed the final solution.

Worked closely with offshore and provided 24/7 support.

Worked on the upgrade of MDM system and supported the necessary changes to downstream systems and worked on changes to ETL mapping.

Responsible for testing, support and maintenance of the ETL process. Developed several complex mappings in Informatica using various transformations, Mapplets, Sessions and Workflows using mapping parameters and variables.

Created various documents such as STM’s, Unit Test Cases, Run Books and Data Migration Document to various data movement and transformation processes.

Also involved in performance tuning to get faster data retrieval. Developed processes for automation of loading data using parameter driven sessions for various workflows, verification and re-conciliation of data stored in several different source systems.

Worked on M&E’s as per the business needs.

Environment: Informatica Power Center 9, Oracle 10g, Redwood 7, Salesforce, SAP Data Services Tool

DirecTV, El Segundo, CA Nov 2011 – Mar 2013

ETL Developer

Project Description:

1) Project Title EPS Upgrade-Integrated Billing: Build-out a dedicated EPS R3 test environment, migrate 1-3 additional payment types to new EPS v7 system from existing EPS v3.7 system (oracle 10g)- existing EPS v3.7 system will run in parallel with new EPS v7 (oracle 11g) system until all payment types are migrated.

2) Project Title- Billing Center 10: This Project Scope is to accept and process the new set of Strip Files generated by AMDOCS and Migrate large L&I accounts to 10th Billing Center. Billing Center 10 contains all the commercial accounts (Ex: Each hotel room receiver and services configured information).

3) Project Title- Qwest CenturyLink Merger: This project’s objective is to migrate new Qwest subscribers and new Qwest opt-in accounts onto the CenturyLink economics.

Responsibility:

Collaborated with Business users in development and documentation of complex business scenarios into technical specifications applicable to various data movement and transformation processes.

Involved in the upgrade of Informatica PowerCenter from 8.6 to 9.1 for the R3 and R5 Environments (Test and Stage).

Created views and indexes at the database level. Implemented the Packages, Stored Procedures and functions in order to generate the payment reports.

Developed Informatica mappings/sessions/workflows for ETL processing.

Designed and developed UNIX shell scripts to schedule jobs.

Scheduled jobs using Autosys.

Environment: Informatica Power Center 8.6/9.1, Oracle 10g/11g, UNIX, LINUX, Toad, Shell Scripting, SQL*Plus, PL/SQL, SQL Navigator, COBOL files, SAP, Microsoft Visio, Autosys, TrueComp 3.7/7.

Hyundai, Irvine, CA Sep 2010 - Nov 2011

ETL Developer

Project Description:

1)HCA – Hyundai Capital America: This Project is involved in creating data marts for Collections, Commercial Credit and EDM which contain dimensions and facts information for RETAIL, LEASE Portfolio and Dealer Loans. Data was extracted from eight source systems, transformed, and loaded into data warehouse and then into data marts. Data warehouse primarily consist of Snapshot tables and Transaction tables.

Responsibility:

Analyzed the source data from Oracle, Flat Files, and Microsoft SQL Server coordinated with data warehouse team in developing Dimensional Model.

Implemented Slowly Changing dimension methodology for accessing the full history of accounts and transaction information.

Tuned the Performance by creating Partitions at Informatica level as well as database level.

Created debugging sessions before the session to validate the transformations and used existing mappings in debug mode extensively for error identification by creating break points and monitoring the debug monitor. Tuned the ETL mappings for better performance.

Given 24/7 Production support and handled many issues.

Environment: Informatica Power Center 8.6, Oracle, UNIX, Erwin, Toad, Shell Scripting, SQL*Plus, PL/SQL, Flat files, SAP, MS SQL Server 2005, Microsoft Visio.

Contact this candidate