We provide IT Staff Augmentation Services!

Etl-technical Resume

Westchester, PA

Professional Profile:

I have around 7 years of experience in the field of Information Technology as a Sr ETL Consultant.

  • Demonstrated expertise in Designing and Implementation of ETL processes using ETL tool Informatica.
  • Extensively worked with Informatica tools -PowerCenterClient tools - Designer, Repository manager, workflow manager/monitor and Server tools – Informatica Server, Repository Server manager.
  • Extensively worked with Oracle and Tera-Data.
  • Proficiency in creating relational and dimensional data models.
  • Experience in designing integration and analytic solutions with data modeling and associated tools.
  • Very good experience in UNIX environment in my past assignments.
  • Very good experience in MDM implementation.
  • Involved in end to end life cycle of projects, which includes:
    • Data Analysis for finding Key Attributes.
    • Converting Business requirements into technical ETL requirements.
    • Designing detailed level ETL Mapping documents.
    • Developing the ETL Source to Target Mappings, Sessions and Workflows.
    • Worked in various phases in Project Execution such as Development, Quality Assessment, Testing and User Acceptance Modes.
    • Involved in System Test activities such as designing test scripts, maintaining the system test matrix to track all the Issues found in System Test.
    • Excellent knowledge in Creating database objects like Stored Procedures, Views, packages, functions and Triggers using PL/SQL.
  • Hands on experience with preparing documents from Release to Production
  • Expert in Validation of Code, Performance Tuning, Error Handling and System Test Activities.
  • Proficient in troubleshooting, problem solving,Testing & Debugging Errors with in ETL Transformations using Informatica Debugger.
  • Experience in leading and managing the technical team to coordinate the day to day activities work stream for Onsite-Offshore model.
  • Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills and excellent presentation skills.
  • Trained in other DWBI technologies like Siperian, Business Objects,AB-Initio,Cognos8,OBIEE.

Technical Skills:

ETL Tools:

Informatica Power Center 9.1/8.6.1/8.1.1

RDBMS:

Oracle 8i/9i/10g,11g, Teradata, Flat files, MS Access

Tools

Toad, ERwin , Autosys, SQL*Developer, SQL*PLUS, Teradata SQL Assistant ,Teradata BTEQ

Languages:

C, XML, SQL, PL/SQL,

Operating System:

Windows 95/98/NT/XP/2000/2003, UNIX

Others:

MS Office, MS Excel

Education Qualifications: Bachelor of Technology

Assignment history:

10/2010 - to date

Client:Confidential, Westchester, PA.
Role: ETL-Technical Lead
Project: Confidential-Aggregate Spend Reporting System

Project Description:IBM worked with Confidential to develop an Aggregate Spend Compliance Management Roadmap that will help facilitate compliance to current State legislation and Office of the Inspector General (OIG) reporting requirements. IBM implemented the first part of the road map, I.e. Phase 1 of Customer Master and Aggregate Spend Reporting System (ASRS) that included Health Care Professionals (HCP) essential to support the spend types required for state and federal/OIG reporting requirements.

The Customer Master (MDM) and Aggregate Spend Reporting System (ASRS) Phase 2 project add remaining HCP sources containing non-prescribes and also include Institutions/Organizations. This will support Corporate Integrity Agreement (CIA) for 2010 and 2011 as well as recently released State Legislation requirements. The project will also help drive towards a “single source of truth” by propagating profile updates to SFA and other systems.

The US based IBM team consisted of member IBM Team consist of 9 members split across the two systems ASRS and CM. The IBM Team was supported by an offshore team ranging from 4-7 members. The efforts of the team were centered on providing the required Promotional Spend Compliance State and Federal (According to the Corporate Integrity Agreement CIA) reports through the use of the ASRS and CM system.

Project Contribution:

  • Responsible for managing and loading the Fact data and CM(MDM) from Source Files to Data Mart.
  • Verify the BR files, if we received new set of files from Business Analyst and Compare the files to previous version and give the BR Comparison Report to the Business Analyst and ensure that the changes impacted were good and as expected.
  • Use the application and provide information before starting the Load.
  • Ensure that there were no Failures/Errors at each stage of the process like Stage, ODS, BR, DM.
  • Update the Load status to Business Analyst and make sure that reports were generated.
  • Check the Under Merge data and share it with CM (MDM) team and gather the updates whether the records were merged or not.
  • Once the reports were verified and Submitted by Global Compliance, take the Backup of all the files used for that particular load.
  • Prepare the system test script if the new source system is added to system.
  • Performed Onsite lead managing the Off-shore people.

Environment:Informatica 9.1, Oracle 11g, Sql Developer 1.5.4, OBIEE, Windows Environment

03/2009 - 09/2010

Client:Confidential , Westchester, PA.
Role: ETL- MDM Lead and System Test Analyst
Project:CONFIDENTIAL-MDM Phase 1 and 2

Project Description: The implementation of a robust and scalable Customer Master solution is a key component of the Global Master Data Management initiative that will link together information about Confidential’s customers and provide a trusted, comprehensive view of customers to Confidential in support of the Aggregate State Spend and other activities.
The Customer Master solution has been designed to fulfill the Business Requirements in support of the State Spend Solution while maintaining flexibility and adaptability to accommodate future requirements and business needs of Confidential Master Data management strategy.
The Master will provide a “single version of truth’ for Confidential’s customer information and has been architected to manage information for ongoing value. Information is defined and organized according to common business terms aligned to the global taxonomy for consistent use and to prevent ambiguities in communications. Master data integration design utilizes established standards to provide a flexible and scalable framework for information sharing and for the addition of new data sources and consumers.

Project Contribution:

  • Preparation and delivery of Technical Design Template for Customer Master.
  • Preparation and delivery of ETL Logical Integration Design.
  • Preparation and delivery of ETL Technical Specification and detailed ETL mapping design for data integration
  • Responsible for developing ETL mappings for data migration for Customer Master(MDM).
  • Responsible for developing mappings in Siperian hub from Landing to Siperian stage and Load tables.
  • Testing the BDD usability for End Client.
  • Extensively worked with different transformations.
  • Developed various sessions using Informatica power center creating worklets and mapplets of extracted sources.
  • Involved in creating reusable transformation and mapplets and used in mappings.
  • Extensively involved in Data Analysis.
  • Data modeling using Erwin tool.
  • Performed Onsite lead managing the Off-shore people.
  • Regressively involved in System Test Activities and delivered metrics in time guide lines.

Environment:Informatica 8.6.1,Oracle 10g,Sql Developer 1.5.4,Siperian MDM tool, Cognos 10,Windows Environment,Erwin.

07/2008 - 03/2009

Client:Confidential, Lansdale, PA.
Role: Sr. ETL-Developer
Project:CONFIDENTIAL-MDM

Project Description:Confidential implementation of the Customer and Product Masters to coincide with the Global Siebel Solution implementation. The objective of the Global rollout will be to provide a cost-effective Master Data Management solution for the targeted countries, add incremental data to global solution, provide cross-country reporting and enable new reporting capabilities to country users. The first release of Customer and Product Masters is targeted at Sweden with considerations for further global deployments in subsequent releases

Confidential will be using Informatica 7.1.4 with Siperian (Data Cleansing tool) to feed data from SIF to Publish Data Base. The project will create Informatica ETL mappings required for data feeds/fetch from SIF (Standard Interface Format) and updating attributes and entities within Publish Data Base based on the input records.Siperian is used to Match/Merge the records based on the rules defined.
Project Contribution:

  • Preparation and delivery of GMDM Technical Design Template for Customer & Product Master.
  • Preparation and delivery of ETL Logical Integration Design.
  • Preparation and delivery of ETL Technical Specification and detailed ETL mapping design for data integration
  • Assist in creating the Customer Master and Product Master design specifications
  • Responsible for developing ETL mappings for data migration
  • Responsible for developing mappings in Siperian hub from Landing to Siperian stage and Load tables.
  • Responsible for developing Sample data for checking the code for different source systems(CRM,KD,UN,CEG)
  • Extensively worked with different transformations.
  • Developed various sessions using Informatica power center creating worklets and mapplets of extracted sources.
  • Involved in creating reusable transformation and mapplets and used in mappings.

Environment:Informatica 8.5, Oracle 10g,Sql Developer 1.5.4,Siperian MDM tool, Unix Environment.

04/2008 - 06/2008

Client:Confidential, Oklahoma City, OK
Role: ETL-Developer
Project:Confidential EDW phase-1

Project Description:For more than 50 years, Confidential. has built a dominant position in the drive-in restaurant business in Unites States of America. Today, CONFIDENTIAL is the largest chain of drive-in restaurants in America. As a business, they continue to thrive, maintaining strong real sales growth, industry-leading customer frequency and high returns for our stockholders. So take a cruise through to learn more about the company and the people who help make it an American success story.

Project Contribution:

  • Understanding the functional specifications and the documents related to the Architecture.
  • Preparation of Technical Specification document.
  • Development of the mappings and building Workflows.
  • Used Re-Usable transformations.
  • Versioning of objects done.
  • Created Type-1, Type-2 for objects.
  • Developed code as per ETL Interface Specification.
  • Unit Testing.

Environment:Informatica Power center 7.1.2, Oracle 9g,Sql Developer 1.5.4.

10/2007 - 03/2008

Client:Confidential, New York, NY.
Role: ETL-Developer
Project:S4 Transformation Project

Project Description:Confidential’s U.S. Pharmaceutical Sales Force is considered the most effective in the Life Sciences industry. They have achieved this position by: developing innovative selling models based on advanced segmentation and targeting strategies with actionable information and IT services comprised of both internal and external support. Although this external support was predominantly provided by Dendrite International, the contract between the two companies was set to expire December 31, 2006.
Project Scope:
The Operate team is responsible for the day-to-day maintenance of multiple Confidential Data Warehouses, including Consumer Core Master, Customer Core Master, Product Core Master, and Territory Master Systems. As part of this responsibility, the Operate team integrates and aggregates the data from multiple vendors and stores the data for use by Confidential for business decisions that are related to Sales & Marketing

There are two types of ETL Process 1) From Base tables to Facts And Aggregates. 2) From Facts And Aggregates to Flat Files for further applications. My area deals with Data loading to Flat Files. Workflow are scheduled using autosys tool on daily, weekly or on monthly basis.

Responsibilities:

  • Understanding the functional specifications and the documents related to the Architecture.
  • Preparation of Technical Specification document.
  • Development of the mappings and building Workflows.
  • Developed code as per ETL Interface Specification.
  • Unit Testing.

Environment:Informatica Power center 7.1.2, Oracle 9g, Windows Environment.

03/2007 - 10/2007

Client:Confidential, Richmond, VA
Role: ETL-Developer

Project Description:The Integration Architecture ensures a seamless integration between these infrastructures, the MST application systems and the Legacy and Contemporary applications systems
There are two types of ETL Process 1) conversion. 2) Interfaces. Conversions are initial load or one time load process where workflow is run manually and Interfaces are run on daily, weekly or on monthly basis, in interfaces workflow is run using a scheduling autosys tool

Project Contribution:

  • Understanding the functional specifications and the documents related to the Architecture.
  • Preparation of Technical Specification document.
  • Development of the mappings and building Workflows.
  • Developed code as per ETL Interface Specification.
  • Unit Testing.

Environment:Informatica Power center 6.1.2, Oracle 9g,Sql Developer 1.5.4.Putty,Unix Environment.

03/2006—2/2007

Client:Confidential, Cincinnati, OH
Role:ETL-Developer
Project Name: PGP-SF Integration

Project Details:
This project requirements are to integrate the existing data warehouse of Confidential to the salesforce.com which is a web based CRM. Confidential is migrating to an externally hosted web-based CRM(salesforce.com) solution as a result of which it needs to synchronize specific functional entities between PGP data warehouse and salesforce.com.
Project Scope:
P & G will be using Informatica 8.1 with Informatica Connector to feed data to and from salesforce.com. The project will create Informatica ETL mappings required for datafeeds/fetch from salesforce and updating attributes and entities within salesforce based on specified events. Control-M is used for scheduling the Workflows.
Contribution: As a Team Member

  • Implementing ETL solution using Informatica.
  • Analyzing Source System data.
  • Worked on Informatica – Source Analyzer, Application source qualifier, Warehouse Designer, Mapping Designer and Transformations.
  • Used most of the Transformations such as Source Qualifier, Aggregator, Lookup, Filter, Sequence generator, Router, Update strategy,XML Transformation etc.,
  • Extensively used ETL to load data from Oracle and salesforce.com to Data Warehouse.
  • Used Informatica Workflow Manager to create Sessions, Workflows to run with the logic embedded in the mappings.
  • Used Harvesting for migrating HLD from One environment to Other Environment.
  • Used Control-M, for scheduling the work Flows.
  • Involved in preparing the various Documentations, and testing the mappings.

Environment:Informatica Power center 6.1.2, Oracle 9g,Sql Developer 1.5.4.Unix Environment.

Hire Now