OBJECTIVE:

To obtain the position of a Senior ETL Developer or ETL Tech Lead and utilize my skills in data integration services with highly advanced data warehousing and BI solutions to help the organization achieve their long term and short-term goals.

TECHNICAL EXPERIENCE:

• 8 years of experience in business requirements analysis, application design, data modeling, coding, development, testing and implementation of business applications with RDBMS, data warehouse/data mart, ETL, OLAP, OLTP and client/server environment applications.
• Strong experience in Informatica Power Center 9.5/9.1/8.1.1/8.6/8.5/7.4 /7.1 and IDQ/IDA/IDD 9.1/9.5 and Informatica data validation option DVO 9.5.
• Excellent knowledge and experience in UNIX shell scripting.
• Integrated various data sources/targets systems with multiple relational databases such as Oracle, Teradata, Flat Files, COBOL files, DB2 and MS SQL Server 2005/2008, and Oracle performance tuning, constituting analysis of Informatica codes and PL/SQL scripts.
• Proficient in Software Development Life Cycle SDLC Methodologies, ISO 9001:2000, SEPG, CMM Level 5 and validations to ensure complete quality assurance control.
• Strong knowledge in reporting/analytical concepts using reporting tools such as Business Objects XI and Microstrategy 9.3.
• Acted as liaison between the clients, programmers and managers of the project development. Instrumental in the development and implementation of several project/module phases, maintenance and application testing.
• Experience in bio-pharmacy, biotech, health care and financial business industries.
• Strong team player with excellent analytical and inter-personal skills, detail oriented with the ability to multitask and effectively communicate verbally and in-writing.

TECHNICAL SKILLS:

• ETL Tools: Informatica Power center 9.5/9.1/8.5/8.1.1/7.4/7.1 IDQ/IDA/IDD 9.1/9.5 DVO 9.5
• Databases: Oracle 11g/10g/9i, Teradata V2R5/V2R6/V2R12, DB2, MS SQL Server 2005/2008, MySQL, MS Access and Netezza 5.0
• Data Modeling: MS Visio 2003/2007/2010, ER/Studio
• Reporting Tools: Microstrategy 9.3 and Business Objects XI, Cognos 8.2/7
• Operating Systems: Windows 7/vista /XP/ 2000, UNIX/Linux Red hat, AIX and HP-UX
• Languages: SQL, PL/SQL, C, C , Java, HTML
• Scripting: Shell Scripting, SQL, PL/SQL, C/ C , MATLAB, VBA
• Querying Tools: TOAD, SQL developer, SQL Navigator, Query Analyzer
• Application: MS Office 2003/2007/2010, HTML, XML
• Misc. Tools: MKS Tool Kit 8.7 OS Inter-operability software . Aqua Data mapping validator

PROFESSIONAL EXPERIENCE:

Confidential

ETL Tech Lead Brokerage Data Management

• Brokerage data management integrates the data pertaining to brokerage accounts, their investment/wealth management and retirement plans and portfolios for financial advisors to help brokerage clients, and for internal financial advisory groups for continuous financial service improvement. It acquires the data from various external finance partners such as Thomson Reuters on centralized file distributions CFD engine and distributes to operational data sore Oracle 11g thru Informatica/shell script processes and then integrates in brokerage data warehouse DB2 to organize the data and history within the brokerage unit. The brokerage data gets integrated into enterprise information management Teradata for company analytical/reporting purposes and then reports thru Microstrategy.
• Led all project activities from technical stand point.
• Responsible for the legacy subject areas, source systems, target system, jobs and the deployment processes with minimal supervision.
• Involved in all phases of the software development life cycle.
• Improved performance of various slow mappings especially for historical load related jobs and involved closely with the administrator to get code deployments in production and different environments.
• Designed and developed the ETL process to load and extract data using Db2 Load and Oracle the SQL loader and automated scheduling of the UNIX scripts and Informatica sessions using autosys.
• Prepared high level and low level technical specifications.
• Participated in design, code, unit and integration testing reviews.
• Involved in creating the technical run books and playbooks.
• Coordinated with the QA teams during QA and the pre-production testing process.
• Analyzed and coordinated the testing related activities with various stakeholders.
• Provided status reports to management as specified. Transferred the requirements and coordinated with cross platforms on development activities.
• Participated with the software configuration management to promote the codes to live environments.
• Executed the data refresh loads as per business on-demand analyzing and resolved the production issues in a timely manner.

Environment: Oracle 11g, DB2, XMLs, Teradata 12.x, Informatica 9.5, IDQ 9.5, DVO 9.5 and Linux

Confidential

Sr. ETL Analyst - Integration Hub

• Confidential a global health service company, dedicated to helping people improve their health, well being, and sense of security. The Integration Hub IHUB is a data integration, data management, and data services/delivery platform being established by this program to support CIGNA's individual family plans business. IHUB receives data from the health plan services in the COBOL files. The Informatica process translates COBOL files to the ASCII delimited files then load them into the master tables and an internal system IL parses all XMLS thru the Informatica data transformation service DTS and loads the data to IFP master tables and subsequently IFP derived master DM IFP layer tables. Finally, IHUB would generate the flat files for three subjects and sends to the SYNYGY system.
• Primary responsible person to drive the whole project activities from the technical stand point.
• Involved in all phases of SDLC: requirements gathering, impact analysis, designing, architecting, constructing and testing.
• Identified and worked on the enhancement based on the business requirements and transferred the requirements and coordinating with the cross platforms on the development activities.
• Analyzed and developed the new codes as per the requirements and validated and tested the changes done by the team.
• Tracked the development activities and reported to the project management and participated with the software configuration management to promote the codes to live environments.
• Organized meetings with the clients to review the production bugs if there were any existing roadblocks.

Environment: Oracle 10g, XMLs, Informatica PowerCenter 9.5 and Linux

Confidential

Sr. ETL developer - HR Acquisition Data Integration

• Confidential is the world's largest and most diverse medical devices and Diagnostics Company. The aim was to automate the data integration of HR employee and payroll practices from the acquired companies into the SAP HR system, which is hosted by NgA and performance tuning for the existing system. The system would pre-validate thru IDQ/IDA/IDE to create Cognos reports for the HR data validation and reconciliation load into Integration layer tables and automated ETL process to unload in TXT Files into the MBOX landing zone. This information would be loaded into the staging validation database tables for reconciliation activities. Cognos reports would be created for data validation /reconciliation.
• Transferred the business requirements to technical requirements.
• Performed analysis and developed the new code as per the requirements per Data mapping specs
• Validated and tested the codes to ensure it was aligned with source to target matrix.
• Tracked the development activities and reporting to the project management.
• Participated with the platform software configuration management.
• Data refresh loads as per business on-demand analyzing and resolving the production issues.
• Provided status reports on production and development activities to the business.
• Met clients for the project document deliveries and gathered the enhancements.
• Identified the performance bottlenecks of the Informatica code and tuned them.

Environment: Informatica 9.1, IDQ 9.1, Teradata 12.x, SQL server 2008, Oracle9i, UNIX shell scripting.

Confidential

Sr. ETL Systems Analyst - Product Complaints Metrics and Trending PCMT

• Confidential Amgen is a biotechnology company. Products Complaints Metrics and Trending PCMT provided the meaning to standardize and automate creating the reports to the FDA to satisfy various departmental reporting requirements. PCMT dealt with complaints, issues and assessments/activities related to the products. Informatica extracts data from various data and loads the data into Teradata database thru stage, integration, core layers to populate Facts, dimension tables. Finally, data is exposed to business reporting through schematic layer accessed thru business intelligence reporting tools.
• Performed impact analysis for various applications such as IRPC and legacy PCMT.
• Involved in complex designs, code enhancements, testing documents and reviews.
• Implemented performance tuning techniques for the existed PCMT 3.x.
• Involved in coordinating with the offshore development teams for technical code reviews and migrations.
• Involved in all phases of SDLC: requirements gathering, impact analysis, designing, architecting, constructing and testing.
• Tracked the development activities and reported to the project management
• Learned and implemented Informatica DVO for validation to meet FDA reports.

Environment: Informatica 9.1/ 9.5, DVO 9.5, Teradata V2R6/12.x, SQL server 2008, Oracle10g

Confidential

ETL Developer On-site Coordinator - Reporting Data Store RDS

• Confidential a transactional, data storage and reporting application, which combines many features of an Operational Data Store ODS and a reporting system. RDS integrates a number of existing reporting systems which have been dispersed across sales and marketing with limited integration and consistency. RDS integrates this data into one central location that is integrated into the Business Information Requirements Architecture BRIA set of sales and marketing applications.
• Involved in performing analysis for various applications such as contracts and Chargeback System CCS ,Product Master PM and External Data Exchange EDX
• Involved in the preparation of effort estimations for major enhancements, issue tracking, prioritization and resolving technical issues and business enhancements.
• Involved in efforts estimation and gathering technical requirements.
• Implemented performance tuning techniques on daily, weekly, monthly processes and prepared Analysis and solution approach document, design documents, unit testing review documents.
• Involved effectively in all phases of project phases.
• Meeting clients for project document deliveries and gathering enhancements

Environment: Informatica 9.5, Teradata V2R6/12.x, Oracle10g, MKS tool and UNIX shell scripting.

Confidential

ETL Developer On-site Coordinator - Sales Rep Field Activity Reporting ADS

• Confidential a data warehouse system that would consolidate information of the sales representative activities. Sales rep Field Activity Reporting is designed to track the activities of the sales representatives across territories in the US and report to the respective sales managers. Sales representatives get assigned with targets to meet health centers and schedule meetings with health care professionals to promote the Amgen products. Their activity data is integrated in FAR Field Activity reporting and reported through business objects.
• Developed ETL jobs using Informatica, oracle and Teradata tools.
• Created detailed planning and estimation documents for the enhancements/projects and shared it with the Amgen system analyst and business teams for discussion/approvals to the project sponsor/manager.
• Responsible for the offshore deliverables from a technical stand point.
• Involved in preparation of effort estimation for major enhancements, Issue tracking, prioritization and resolving technical issues and business enhancements
• Participated in analysis, solutions approach, design and unit testing review documents.
• Involved effectively in all phases of project phases such as requirements gathering, impact analysis, designing, architecting, constructing and testing.
• Met the clients for project document deliveries and gathered enhancements.
• Participated in production support activities along with offshore teams.

Environment: Informatica Power Center 7.4/9.1, Teradata V2R6/12.x and Oracle10g.

Confidential

Sr. ETL Developer On-site Coordinator - Lynx System Non-Clinical studies

• Confidential one of the largest Pharmaceutical Company. The Lynx system was designed to streamline the protocol generation, data interpretation and study reporting processes through the standardization and automation. It was created to increase the efficiency of the study protocol development, interpretation and reports supporting the Drug Safety Research and Development DSRD 's ability to mine safety data across studies and share the data across Pfizer Global Research and Development PGRD , in support of attrition analysis.
• Developed mappings and from multiple sources to a single staging area using the ETL process.
• Automation of Informatica jobs and error handling via UNIX shell scripting.
• Involved in the client processes to meet targets and deliver solutions.
• Peer review Mappings/Mapplets/Workflows and shell scripts , Defect tracking and control.
• Coordinated with the offshore about requirements, issues and deliverables.
• Involved in the major enhancements, issued tracking, prioritized and resolved the technical issues.
• Involved in analysis, Solution Approach, Design and unit testing review documents.
• Involved in all phases of SDLC: requirements gathering, impact analysis, designing, architecting, constructing and testing.
• Tracked the development activities and reported to the project management.

Environment: Informatica Power Center 8.6, Oracle10g and UNIX shell scripting.

Confidential

ETL Developer, Secondary Factory DF2

• Confidential is the leading provider of information services for the healthcare industry. This project is aimed to build secondary data ware housing on netezza database. Prescription data would be integrated which comes from various geo locations and pharmacies across the US. Source system is flat file dump loaded in to all dimensional and fact data would be loaded through the Informatica ETL process and scripting.
• Developed the ETL codes across various layers.
• Requirement analysis according to the business demand and standard.
• Requirements review, coding and unit-testing of the Informatica mappings.
• Prepared design, test plans, defect reports, unit test case documents.
• Responsible for Offshore deliverables from technical stand point
• Prepared estimates, issued tracking, prioritized and resolved the technical issues.
• Involved in all phases of SDLC: requirements gathering, impact analysis, designing, architecting, constructing and testing.
• Tracked the development activities and reported to the project management.

Environment: Informatica Power Center 8.1/8.5, Oracle9i, netezza 5.0, flat files and UNIX shell scripting.

Confidential

ETL Developer - PCV Patient Centric View Clinical studies Development and RIF Support

• Confidential the opportunities for creating a clinical data warehouse, integrating the data for a patient from different sources, i.e. all the clinical data of a patient is stored in one mart. The aim of the project was to enhance the current process of collecting data related to the patients, develop DWH using Informatica which is secure, flexible and easy to retrieve the patient data.
• Developed mappings using the Informatica process across various layers.
• Requirement analysis according to the business demand and standards.
• STM requirement review, coding and unit-testing of Informatica mappings.
• Prepared design, test plans, defect reports and unit test cases documents.
• Peer review ETL codes and shell scripts , defect tracking and control.
• Coordinated with the offshore about requirements, issues and deliverables.
• Responsible for offshore deliverables from the technical stand point.
• Prepared effort estimation, Issue tracking, prioritization and resolving technical issues
• Tracked the development activities and reported to the project management.

Environment: Informatica Power Center 8.1, Oracle clinical 9i, flat files and UNIX shell scripting.

Confidential

ETL Developer - Data Quality Gap Analysis DQGA Card Services

• Confidential a savings bank holding company and loan association as one of the giant financial institutions in the US. The objective was to identify the data quality gaps in legacy WaMu card services data management applications and fixing data gaps that were found missing.
• Analyzed technical needs and developed ETL mappings.
• Participated in the client processes to meet targets and deliver solutions.
• STM requirement review, coding and unit-testing of Informatica mappings.
• Peer review Mappings/Mapplets/Workflows and shell scripts , defect tracking and control.
• Coordinated with offshore about requirements, issues and deliverables.
• Prepared analysis and solution approach, design and unit testing review documents.
• Involved in all phases of SDLC: requirements gathering, impact analysis, designing, architecting, constructing and testing.
• Tracked the development activities and reported them to project management.

Environment: Informatica Power Center 8.1/7.4, Oracle 8i and UNIX shell scripting