Summery

• Total IT: 9 Years ETL Developer: 7 Years Oracle Experience:4 Years Informatica Power Center Experience: 6 Years SUMMARY
• An ETL Lead/Business System Analyst with nearly 9 years of very strong professional background in Data warehouse and solid industry experience in the software engineering, processes and methodologies.
• Strong experience in gathering Business requirements for Enterprise Business Intelligence Team, understand client issues and data challenges and translate into functional requirement.
• Requirement gathering for new product enhancements and delivering the system infrastructures that apply business processes.
• Experience in creating BRD, functional specifications, Use Cases and other design.
• Conduct meetings with Subject Matter Experts SME for requirements gathering and present project findings, statuses etc. to Stakeholders.
• Extensive professional experience in Data warehouse Architecture/Design, Development using Informatica Power Center 9.x/8.x/, Dimensional modeling like Star schema and Snowflake schema, Oracle 11G/10G, DB2, Greenplum 3.0.
• Skilled in Planning, Designing, developing and deploying Data warehouses/Data Marts.
• Strong experience in designing and developing Business Intelligence solutions in Data warehouse/Decision support systems using ETL tools.
• Experience in designing/developing complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and Normalizer.
• Involved in ETL Migration strategy, Data Lineage and defining the data granularity.
• Have good hands-on experience in creating technical design document, ETL architecture, ETL Process design, ETL logic conversion, Deployment, Production Data volume estimation.
• Have good hands-on experience in designing and developing ETL Processes using Informatica mappings, Sessions, Event based Tasks, Workflows and Parameters.
• Have good experience in Change Data Capture Processes, Implementing Type 1, Type 2 SCD tasks.
• Have good experience in UNIX Shell scripting to provide effective solutions, creating Parameter files, Process Log files, Automated Archival of log files, Scheduling ETL jobs
• Performed Advanced level Data warehouse testing which verifies and validates the ETL Mappings, Stored Procedures.
• Created High-level ETL Design Document, Data Model Diagram, Data warehouse Test Strategy documents.
• Experience in building QA/UAT test cases and defect tracking using Quality Center defect tracking system .
• Good Team player possessing good inter-personal, strong analytical and problem solving skills, communication skills, presentation skills, proven leadership qualities, mentored a team of developers with industry best practices.

TECHNICAL SKILLS

• ETL Tools : Informatica Power Center 8.1.1, 8.6.1, 9.1.0
• Operating Systems : Windows, UNIX
• OLAP : SAP crystal reports, Microstrategy9, Trained on
• Business Objects XI
• RDBMS : Oracle 11G, 10G, Greenplum 3.0, SQL Server 2005.
• Applications : MS Office Suite Word, Visio, Excel, PowerPoint, Outlook, Project , TOAD 11.0
• Other tools : Autosys, MS excel macros
• CERTIFICATIONS
• Certified on Informatica Power Center 8 Mapping Design

PROFESSIONAL EXPERIENCE

confidential

Senior ETL Developer / Business System Analyst

Confidential

The IIR application provides an integrated, consistent and efficient repository to perform reporting and data analysis. It has numerous sources that feed a multitude of transformations and loading processes which in turn are put to a process to load multiple Data Marts.

Responsibilities:

• Prepared the High-level Design document to provide an overview of the technical design specification system required for Application Enhancements and involved in logical and physical data modeling.
• Understand advantages and limitations of Salesforce Integration with Power Center and provide ETL Design Solution for the Business requirements received.
• Extensively worked on Data Integration from Oracle to Oracle.
• Hands on experience with SFDC load.
• Understand source systems for getting data into IIR - Collection of data source information from all the legacy systems and existing data marts.
• Lead meetings to discuss all aspects of requirements gathering and project development.
• Perform requirement gap analysis for data load from multiple source systems to IIR.
• Gather and document requirements and specifications to meet project objectives.
• Interact with internal and external clients for eliciting requirements.
• Responsible for case study on implementing Informatica mappings and workflows for ETL
• Developed complex mappings using SFDC lookups, multiple sources and targets in different databases, flat files to facilitate one time, Daily and Monthly Loading of Data.
• Created different transformations using Informatica power center 9.1 for loading the data into targets including Salesforce Target using various transformations like Source Qualifier SOQL , SQL transformation, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, and Sequence Generator.
• Conducted research related activities associated with enhancements in applications. Also led the root cause analysis for issues coming out during various project phases and proposed remediation action.
• Tuned Informatica Mappings and Sessions for optimum performance.
• Provide Status reports on Weekly basis to management on the overall status of the application
• Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments.
• Design Documents TSD, Traceability Matrix, Unix Scripts, Test Logs, SDLC Docs
• Designed a Customizable ETL Audit framework with a generic data model for ETL load Auditing Exception tracking.

Environment: Informatica Power center 9.1,ORACLE 11.2.0.3, Flat files, TOAD 10.6., Autosys

Confidential

Senior ETL Developer / Business System Analyst

Confidential

PVC application is developed to serve as a regional compliance data base. The system will allow Marketing Companies MCs to track, monitor PV activities, analyze trends, identify emerging issues and demonstrate span of control. The objective of the system is to ensure PV responsibilities and compliance standards are consistently met as efficiently as possible. This system is the deliverable of the databasework stream within the PV Compliance for America's project.

Responsibilities:

• Analysis of Data flow from multiple source systems.
• Requirement Gathering and analysis on the changes of pharmaceutical compliance data feed
• Led the Requirements Gathering and Business Analysis as technical architect.
• Participated in Sessions along with Project Manager and End users.
• Conducted End User interviews to gather reporting and analysis requirements.
• Assisted in Logical Modeling. Back traced the Physical Data Model to understand the existing system which helped in designing the new model based on new source system.
• Responsible for Design, Development and automation of ETL processes.
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Involved extensively in Data Analysis, functional and remediation testing
• Transformation, Data Loading and Testing. Created Project and corresponding Source and Target modules in Informatica
• Created, executed and managed ETL processes using Informatica.
• Coordinating with source system owners, performed data migration and monitored day-to-day ETL progress, Data mart target schema Design Star Schema and maintenance.
• Extraction, Transformation and Loading of the data using Informatica
• Created ETL mappings with PL/SQL Procedures to build business rules to load data.
• Tuned Informatica Mappings and Sessions for optimum performance.
• Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments.
• Approval of Design Documents TSD, Traceability Matrix , Unix Scripts, Test Logs, SDLC Docs

Environment: Informatica Power center 9.1, ORACLE 11G, Flat files, Autosys, TOAD 10.6., PLSQL

Confidential

Senior ETL Informatica Developer and support analyst

Confidential

LMSDM System is a data mart and business intelligence solution that integrates, organizes and makes available information from oracle source systems in order to provide Learning management data to Amgen that enable operational reporting and ad hoc analysis of the LMSDM business processes

Responsibilities:

• Resolve Production Tickets, work on RFCs and Implement the changes in PROD
• Work on Business Enhancements, meeting with End User to gather reporting and analysis requirements.
• Preparation of strategy for Data Conversion as per the business rules
• Responsible for Design, Development and automation of ETL processes and implement the enhanced code in PROD.
• Developed Complex mappings in Informatica to load the data from various sources using different transformations like Custom, Union, Source Qualifier, Look up connected and unconnected , Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router transformations. Used debugger to test the mapping and fixed the bugs.
• Developed Mapplets using corresponding Source, Targets and Transformations.

Environment: Informatica Power center 9.1, ORACLE 11G, Flat files, TOAD 10.6.

Confidential

ETL Developer/ETL System Analyst

Confidential

The Unified Database UDB project which envisages building an integrated repository of data from the service provider networks. This repository of data will enable to draw out network configuration, fault and performance reports that help manage the networks in a better way.

Responsibilities:

• Requirement gathering and source system analysis.
• Creation of Mappings, Sessions and Workflows.
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Fix on errors Deployment of code and data fixes by performing root cause analysis, and application performance improvements.
• Involved in performance analysis of process flows
• Work on Enhancements.
• Source System Analysis and data mapping from source to target.
• SIT/UAT testing.
• Analysis of ETL jobs and create Inventory.
• Worked on BI Stability Enhancement Project and fixed the data synchronization issue

Environment: Informatica 8.x, Oracle 10g, Greenplum 3.0, Microstrategy 9, Postgresql

Confidential

Intern-BI Developer

Performance Management Reporting:

Performance management reporting project provides simplification of network performance management by analyzing the business reports developed using excel macros and SQL queries from the oracle database. The oracle database receives data from all the telecom network elements periodically

Responsibilities:

• Analysis and generation of reports using sql and excel macros.
• Fix on errors Deployment of code and data fixes by performing root cause analysis, and performance improvements.
• Report testing and documentation.
• Worked on different Minor Enhancement Offshore/Onsite Modules.
• Source System Analysis and data mapping from source to target.
• Worked on End-to-End Project Implementation.
• Introduced status reporting process design documentation as a part of the day-to-day project implementation.

Environment: MS-Excel Macros, Oracle 10g, SQL, Shell scripting.