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.

PROFESSIONAL EXPERIENCE

Confidential

Senior ETL Developer / Business System Analyst

Confidential known as The Confidential is one of Confidential largest insurance and financial services company. It is focused on a customer-oriented strategy and organized around various reporting segments like Life Insurance, Group Benefits, Commercial, Consumer Markets and Mutual Funds.

Project

Integrated Information Repository

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:

• Designed a Customizable ETL Audit framework with a generic data model for ETL load Auditing Exception tracking.
• Design Documents TSD, Traceability Matrix, Unix Scripts, Test Logs, SDLC Docs
• Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments.
• Provide Status reports on Weekly basis to management on the overall status of the application
• Tuned Informatica Mappings and Sessions for optimum performance.
• 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.
• 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.
• 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.
• Responsible for case study on implementing Informatica mappings and workflows for ETL
• Interact with internal and external clients for eliciting requirements.
• Gather and document requirements and specifications to meet project objectives.
• Perform requirement gap analysis for data load from multiple source systems to IIR.
• Lead meetings to discuss all aspects of requirements gathering and project development.
• Understand source systems for getting data into IIR - Collection of data source information from all the legacy systems and existing data marts.
• Hands on experience with SFDC load.
• Extensively worked on Data Integration from Oracle to Oracle.
• Understand advantages and limitations of Salesforce Integration with Power Center and provide ETL Design Solution for the Business requirements received.
• 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.
• 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 is a global, innovation-driven, integrated biopharmaceutical company. The company discovers, develop, manufacture and market prescription medicines for six important areas of healthcare, which include some of the world's most serious illnesses: cancer, cardiovascular, gastrointestinal, infection, neuroscience, and respiratory and inflammation.
• Confidential 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 forConfidential 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

Confidential

Senior ETL Informatica Developer and support analyst

Confidential is a leading human therapeutics company in the biotechnology industry and pioneered the development of novel products based on advances in recombinant DNA and molecular biology. The purpose of the project is to create EDC Forecasting and Tracking Datamart, that integrates, organizes and makes available information from multiple source systems in order to enable operational reporting and ad hoc analysis of business process.

Learning Management System

Confidential 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.

Confidential

ETL Developer/ETL System Analyst

Confidential Networks provides managed network services to GSM, VAS and Hosting service providers around the globe from their Global Network Solution Centre located in Confidential . Confidential Networks' Global Services Business Unit employs 28,000 people delivering the highest quality of projects that enable customers Operators to enhance the efficiency of their networks. This includes the building, management and maintaining of operator networks as well as network planning and optimization activities. Its unique and innovative global service delivery model brings together the best of global expertise and local insight from 150 countries around the world with a very high standard of service excellence.

Unified Data Base

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

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.