SUMMARY:

• Nine Years of Information Technology experience in Design, Analysis, Development, Support and Implementation of Data Warehouse projects using Informatica, Teradata, Oracle and UNIX.
• Experienced as ETL Architect, Technical Lead, Senior Informatica Developer and Business Analyst.
• Experienced in all phases of the project life cycle include Requirement Analysis, Design, Coding, Support and testing. Worked in the areas of Finance, Consumer, HealthCare, Manufacturing and Corporate domains.
• Performed major role in understanding the business requirements, designing and loading the data into data warehouse (ETL), Data Modeling.
• Good experience in the development of mappings, transformation standards and processes using Informatica (9.x/8.x).
• Experienced in using transformations like Dynamic Lookup, Unconnected lookup, Persistent Cache, Java, SQL, Normalizer
• Worked on performance improvements of the interfaces by implementing techniques like partitioning, compressing techniques, tuning of complex queries, PDO’s and TPT’s.
• Designed and developed the modules which include very complex business requirements and are critical for business.
• Experienced in creating Sourcing Specification Documents, Functional Design Documents, Technical Design Documents and Detailed Technical mapping specifications.
• Extracted and transferred source data from different databases like Oracle, Teradata, SAP BW, LDAP and Flat file into Oracle and Flat file.
• Designed and implemented ETL for automation of BO access requests by pulling the data from LDAP. This reduced manual work 2 persons every day.
• Involved in writing UNIX shell scripts. Involved in projects having an effective onsite and offshore model.
• Strong understanding of dimensional modeling of Star Schemas, Snow - Flake Schemas, Slowly Changing Dimensions (SCDs), FACT and Dimension tables. Methodologies for building enterprise data warehouses.
• Have good problem solving and analytical skills. Highly motivated professional, Team player and the ability to effectively work with communicate and mentor people.
• Strong experience in client interaction and understanding business application, business data flow and data relations from them
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.
• Having knowledge in tools like BO, Cognos, Hyperion, Oracle Data Integrator (ODI), TM1

TECHNICAL SKILLS:

ETL Data Warehouse Tools: Informatica 9.6/9.5/ 9.1/8.6.1/8.1/7.1, Informatica 8.X, Informatica Data Quality (IDQ), Oracle Data Integrator (ODI), Business Objects Data Integrator (BODI)

Operating Systems: Windows, UNIX, Linux

Database: Teradata 14.10/14.0/13.11, Oracle 11g/10g/9i/8i

Business Tools: Visio, Tableau 8.1, HP Mercury Quality center 10.00, Tidal Scheduler, Toad, SQL Developer

Data model: Erwin 7.3/4

EXPERIENCE:

Confidential, New York City

ETL Lead

Roles & Responsibilities:

• Design Architect/ETL Lead for the project. Redesigned the existing ETL design and the DB design.
• Client Interfacing, Requirement gathering and analysis, ETL design and development.
• Understanding Workday, PeopleSoft and other related systems (Rex, MFT Scripts) for integration.
• Creation of Technical Design Document, High level ETL Design Document, ETL Mapping Document.
• Development, review and testing of code as per standards.
• Providing knowledge transfer to support team.
• Production implementation.
• Bridging the gap between Client and Offshore team.
• Manage Client Communication.

Environment: Informatica, Business Objects Data Integrator (BODI), Oracle, UNIX, Global Event Control Scheduler (GESC)

Confidential, New Jersey

ETL Lead

Roles & Responsibilities:

• ETL Architect and Lead for Global Finance Data Warehouse (FDW). The project used Informatica as ETL tool to extract financial information (FI-GL, FI-CO-PCA, FI-CO-CCA, FI-CO-COPA and FI-IO) from 15+ SAP ECC systems into Teradata Enterprise Data Warehouse.
• Gathering and Analysis of the Requirements, Functional and Technical design of the Interfaces, Change Requests and Defects
• Development of the ETL’s using Informatica, Teradata and UNIX shell scripts for the approved design
• Responsible for overseeing the Quality procedures related to the ETL
• Profiling of data using Informatica Developer
• Development and Review of test scripts in Quality Center and defect tracking
• Data Validation using Tableau
• Testing and Functional Review of the Interfaces, Onsite - Offshore coordination

Environment: Informatica, Informatica Data Quality (IDQ), Teradata, Tableau, UNIX, HP Mercury Quality Center, Visio, Tidal, SAP BW

Confidential, CT

ETL Developer

Roles & Responsibilities:

• Development of the Informatica mappings, Oracle SQL Queries and UNIX shell scripts for the approved design
• Performing Code reviews and Functional Review of the Interfaces
• Prepared test cases for mapping validations and also for data validation.
• Analysis of the Interface Requirements, Change Requests and Defects for Program Indicators and Rebate Accounting System
• Responsible for Onsite - Offshore coordination
• Involved in providing Estimations for interface development
• Functional and Technical design of the Interfaces
• Unit testing and integration testing of the developed code
• Responsible for overseeing the Quality procedures related to the ETL documents.

Environment: Informatica, Oracle, Visio, HP Mercury Quality Center

Confidential, CA

ETL Developer

Roles & Responsibilities:

• Development of the Informatica mappings, Oracle SQL Queries and UNIX shell scripts for the approved design
• Analysis of the Interface Requirements, Change Requests and Defects
• Functional and Technical design of the Interfaces
• Unit testing of the completed code, Peer Code and Functional Review of the Interfaces, Onsite - Offshore coordination
• Prepared test cases for mapping validations and also for data validation.
• Responsible for overseeing the Quality procedures related to the ETL documents.

Environment: Informatica, Facets, Oracle, Teradata, Unix, HP Mercury Quality Center

Confidential, CT

ETL Lead

Roles & Responsibilities:

• Analyzed the requirements provided and interacted with the Business users regarding requirements.
• ETL designing, Development of Mappings, Workflows using Informatica. Prepared test cases for mapping validations and also for data validation.
• Made changes in the existing Scripts to add more countries expenses data.
• Added control checks at Data base level after stage load and before fact data load.
• Delivering the tasks on time.
• Responsible for overseeing the Quality procedures related to the ETL documents.

Environment: Informatica, Oracle, UNIX, HP Mercury Quality Center

Confidential, OH

Module Lead

Roles & Responsibilities:

• Responsible for gathering the requirements.
• Created a Data Model for stage database ETL to meet the requirements.
• ETL Design of mapping in VISIO.
• Development of Mappings, Workflows using Informatica 8.1 and migrated the code to Informatica 8.6.
• I was responsible in the document work that involved the preparation of Design Document, Requirement Document, and Technical Specification Document.
• Responsible to get sign off for the data model review, ETL design review, ETL code review.
• Prepared test cases for mapping validations and also for data validation.
• Responsible for overseeing the Quality procedures related to the ETL documents.
• Also we have made use of Oracle Data Integrator (ODI), which is a very new and advanced data loading tool. It has got many data source technologies inside it to support the daily upcoming needs.

Environment: Informatica, Oracle, Unix, HP Mercury Quality Center, Visio, Erwin, Hyperion, Oracle Data Integrator (ODI)

Confidential, CT

Team Member

Roles & Responsibilities:

• Involved in the migrated the GQDW warehouse which is in UNIX to Informatica which can help anyone to maintain the system easily and there is no complexity of loading the data through UNIX scripts.
• Redesigned most of the code in GQDW to provide quality deliverables to reduce the run time and to make error free.
• Drastic improvement in the reduction of data loading time in GQDW. Done the Process improvement in GQDW which has reduced the repeated way of creating and dropping indexes.
• Delivered the developed or enhanced code with best quality which has no defects found later.
• Prepared the documents and charts of the loading time taken, failures and defects for all the RTS applications.

Environment: Informatica, Oracle, Unix, Cognos