SUMMARY

IT professional with around *+ years of extensive working experience in Data Warehousing, Business Intelligence and ETL technologies in Finance, Insurance and Manufacturing domain.

Strong Working Experience with various clients in Finance/Insurance/Annuity industries.

Very strong experience in Informatica Power centre suite, which includes Mapping Developer, Workflow Manager, Workflow Monitor, Admin Console and Repository Manager.

Strong experience in Informatica Power Exchange tool.

Experience in design and development of Data Warehouse, Marts and ODS.

Expert in designing the ETL architecture, Load Strategy and the Data Flow. Expert in designing the ETL architecture, Load Strategy and the Data Flow.

Played Business Analyst for some time alongside ETL Lead role, which involved business interaction, understanding the requirements, Data Analysis and designing Techno-functional mapping documents.

Solid understanding of Data Modelling (Star and Snow Flake Schemas), Physical and Logical models, DWH concepts, ER diagrams, Data Flow Diagrams/Process Diagrams.

Elaborate experience in databases like Oracle, DB2, SQL Server and database tools like TOAD, AQT, Win-SQL, PL/SQL Developer. SQL Developer.

Extensive experience in Performance Tuning and optimizing ETL process and coming up with the best design to obtain superior performance. Have also worked on creating UNIX shell scripts to automate the ETL process.

Good understanding of PL/SQL packages, procedures, functions, triggers and other database components. Experience in converting PL/SQL procedures to ETL Interfaces.

Experience in the Data Analysis, Design, Development, Implementation and Testing of Database/ Data warehousing/ Server/ Legacy applications for Annuity and other industries using Data Modelling, Data Extraction, Data Transformation, Data Loading and Data Analysis.

Created UNIX Shell Scripts to automate the ETL process.

Excellent soft skills, team-building skills. Sr Informatica Developer roles for various projects and handled team as big as 10-12.

Extensively involved in system analysis development and implementation of Data warehouse systems (SDLC).

Good Experience in creation of Quality related documents (Function specification, ETL architecture design, High Level and Low Level design, and Unit Test Case documents).

Excellent analytical skills in understanding clients organizational structure

Fast Learner, good communication and presentation skills, ability to quickly adapt to the technical environment coupled with very positive user interaction & team spirit.

TECHNICAL SKILLS

BI & ETL Tools

Informatica Power Centre 9.x/8.x/7.x, Informatica Power exchange, Data Warehousing

Databases

Oracle 11g/10g/9i/8i, IBM DB2, SQL Server, SQL, PL/SQL,

Operating System

Windows 7/XP/NT/2000/98/95, Unix

Scripting Languages

UNIX Shell Scripting

Job Scheduler

iXp AutoSys, Tivoli Maestro

Others

Win SQL, TOAD, SQL DBX, AQT, Ipswich, WinSCP, HP Quality Center, MS Office, MS Visio, Edit plus, Text pad, Oxygen XML Editor,

BMC Remedy Management tool and version controlling tools like Smart SVN, VSS and Calligo.

Domains

Finance, Annuity & Life Insurance

EDUCATIONAL QUALIFICATION

Bachelor of Engineering, India

PROFESSIONAL EXPERIENCE

Project 1: Marketing Staging Area and Client Reporting (November 2012 to Present)

Client: OppenheimerFunds, NYC

Position: Tech Lead / ETL Specialist / Sr. ETL Developer

The Oppenheimer family of mutual funds includes over 70 funds covering virtually all major asset classes and investment styles. OppenheimerFunds and its controlled affiliates offer a broad range of products and services to individuals, corporations and institutions, including mutual funds, separately managed accounts, investment management for institutions, qualified retirement plans and subadvisory investment-management services.

Oppenheimer Funds generate and circulate monthly and quarterly reporting materials (both web and print materials), which goes to the financial advisors. Financial advisor is a valuable and essential partner who helps clients determining the investment choices that are right for them. Marketing Staging Area (MSA) and Client Reporting (CR) stages data from different sources like Investment Data Warehouse (IDW), Enterprise Operational Data Store (EODS), EFM, RISK, FACTSET, and XAMIN. Depending upon the different publications, data is sent to downstream applications like PRISM (web), Desknet (Print – Pitch books, Portfolio Strategy, Data Packs), Kennis - Advisor (web), MSA Extracts (web).

Responsibilities:

Performed role of Sr Informatica Developer, which includes requirement analysis, design, development, testing, and documentation, production deployment tasks.

Designed ETL Architecture using Informatica for implementing various phases of MSA and CR build.

Worked on Informatica Power Centre to develop mappings, sessions and workflows. Built new ETL process and enhancement of some of the existing processes.

Integrated data from different sources like relational table, flat files etc into the CR and MSA database, built stage layer with error checking strategies.

Involved working on Oracle 11g database, designing and creating tables, view, packages, triggers, constraints, indexes.

Also developed UNIX Shell Scripts to automate the ETL processes.

Used XML targets to send data to Desknet.

Extensively involved in writing SQL queries (sub queries and join conditions) for building and testing ETL processes.

Have built performance-tuned systems with maximum optimization, reusability and ease of operation.

Created Function specification, High-level design document (ETL design architecture) and Low level design document and Unit Test Case, deployment and operational document.

Environment: Informatica Power centre (v9.1), Oracle 11g, SQL Server, SQL, UNIX, AutoSys scheduling, Windows

Project 2: MSA and CR Production Support (November 2012 to Present)

Client: OppenheimerFunds, NYC

Position: Tech Lead / ETL Specialist / Sr. ETL Developer

Responsibilities:

Performing role of a Tech Lead/Sr. ETL Developer, which includes requirement analysis, design, development, testing, and documentation and production deployment.

Responsible for participating and providing analytical solutions for the strategic vision of the MSA and CR in the Architecture Meetings.

Provide Analytical Solutions to Production Support problems with my technical and analytical knowledge base.

Participate in design, code reviews, documentation of design, and implementation of methodologies for all databases.

Proof of Concept (POC) for any new applications.

Architect, design and execute strategic projects for IDW and its Marts.

Involved working on Oracle 11g database, designing and creating tables, relations, constraints, indexes.

Fine tune SQL queries and database performance for all applications within the development environment.

Effectively communicate to Business Partners and team members to resolve the problem and the expected time of resolution.

Responsible for resolving critical issues and permanent fix to Production issues.

Responsible for provide timely (weekly) feedback and necessary help/cooperation to refine processes in order to meet business’s expectations

Frequent communication with the client, business, and QA team on technical and functional queries related to critical production issues.

Environment: Informatica Power centre (v9.1), Oracle 11g, SQL Server, SQL, UNIX, AutoSys scheduling, Windows 7

Project 3: IBDW CCV, CMR and SECPRINT Enhancements (May 2011 to November 2012)

Client: METLIFE INSURANCE, NJ

Position: Tech Lead / ETL Specialist / Sr. ETL Developer

The CCV project was in the Holdings part of the Individual business Data Warehouse (IBDW). The Annuity, Life and disability data from various admin systems are loaded into the IBDW. The data consists of policy, dates, measures, transaction, loan, riders, fund allocation and daily positions.

The address data is sent as a request to CMR (Client Management Repository) from where the response is received with standardized data. CMR is an integrated system, which stores gold copy of standardized client address data.

From IBDW, the data is carried to ODS and SEC Marts. SECMART has daily SLA to mail the clients on their current positions. The data from ODS passed to I Tracker reports for the agents to view/analyse.

Responsibilities:

Performed role of Informatica Specialist, which includes requirement analysis, design, development, testing, documentation, production deployment and Administrator tasks.

Designed ETL Architecture using Informatica for implementing various phases of EDW build.

Worked on Informatica Power Centre to develop mappings, sessions and workflows.

Used Informatica Power Exchange tool to read source data and generate feeds to external systems.

Integrated 34 admin systems into IBDW, built stage and stage history layer with error checking strategies.

Built new ETL process and enhancing some of current processes.

Worked on ACORD data model, which is global standard for Insurance domain, built Marts to enable data exchange with external systems.

Involved working on IBM DB2 database, designing and creating tables, relations, constraints, indexes.

Also developed UNIX Shell Scripts to automate the ETL processes.

Used XML sources to load data into relational tables.

Extensively involved in writing SQL queries (sub queries and join conditions) for building and testing ETL processes.

Have built performance-tuned systems with maximum optimization, reusability and ease of operation.

Created Function specification, High-level design document (ETL design architecture) and Low level design document and Unit Test Case, deployment and operational document.

Role also involved leading the onshore and offshore team members, assigning and reviewing their work.

Environment: Informatica Power centre (v8.6 / v9.1), Power Exchange, IBM-DB2, SQL, UNIX, Maestro scheduling, Windows XP.

Project 4: MetLife Institutional Data Warehouse L3 Support (July 2010 to April 2011)

Client: METLIFE INSURANCE, NJ

Position: ETL Specialist / Sr. ETL Developer

MetLife is the number one Insurance provider in USA. MetLife, Inc. operates through its affiliates and subsidiaries as a provider of insurance and other financial services. MetLife has built an Institutional Data Warehouse (IDW) that is loaded on a daily basis from internal and external data sources. This Enterprise Data Warehouse further feeds data at various intervals into various Marts viz. Company Relationship Mart, Dental Mart, Disability Mart, Finance Mart, e-Metrics Mart, Long Term Care Mart and Life Mart.

The IDW/Data Marts provide critical information for business analytic and decision-making purpose. IDW receives data in the form of flat files, which are transformed and loaded into warehouse using Informatica as an ETL tool. Business users use this information for their decision-making using COGNOS and ACTUATE reports. IDW/Data Marts are available 24x7 and reside on a distributed hardware across different sites.

The project involves production support activities for the data load process for IDW and current Marts and any other data marts that might be sourced from IDW in future. The scope of support covers the code developed for data load processes using Informatica Power Mart, Unix Scripts, UDB SQL scripts and Maestro Schedules.

Responsibilities:

Performing role of a Tech Lead/Sr. ETL Developer, which includes requirement analysis, design, development, testing, and documentation and production deployment.

Responsible for participating and providing analytical solutions for the strategic vision of the IDW in the Architecture Meetings.

Responsible for creating SQL Utility tool which removes DBA intervention in the execution of SQLs in production environment in case of abends/new releases and allows production management team to do so through Maestro job by simply uploading SQL in a file on production server.

Provide Analytical Solutions to Production Support problems with my technical and analytical knowledge base.

Participate in design, code reviews, documentation of design, and implementation of methodologies for all databases.

Proof of Concept (POC) for any new application.

Architect, design and execute strategic projects for IDW and its Marts.

Work with Relational Modelling (Logical and Physical) IDW and Dimensional Modelling for all the Marts.

Involved working on IBM DB2 database, designing and creating tables, relations, constraints, indexes.

Fine tune SQL queries and database performance for all applications within the development environment.

Effectively communicate to Business Partners and team members to resolve the problem and the expected time of resolution.

Responsible for planning the Disaster Recovery Scenarios.

Responsible for resolving critical issues and suggesting the fix/permanent fix to Production Management team (L1/L2).

Responsible for provide timely (weekly) feedback and necessary help/cooperation to refine processes in order to meet business’s expectations

Frequent communication with the client, business, and QA team on technical and functional queries related to critical production issues.

Environment: Informatica Power centre (v8.6), IBM-DB2, Oracle 10g, SQL, UNIX, Maestro scheduling, Windows XP.

Project 5: MetLife Capitol Market Investment Product (CMIP) (July 2010 to April 2011)

Client: METLIFE INSURANCE, NJ

Position: Tech Lead / ETL Specialist / Sr. ETL Developer

MetLife is the number one Insurance provider in USA. MetLife, Inc. operates through its affiliates and subsidiaries as a provider of insurance and other financial services. This project involves the migration of Capital Market Investment Products from FMS2 onto the MUREX application currently being utilized by the Investments department. The transition of CMIP full life cycle administration from FMS2 to MUREX will allow for enhanced functionality and reporting that will address the financial risks that exist today as a result of manual processes in place. This initiative will include an upgrade of the MUREX application to address required FAS52 enhanced calculations and data conversion of existing business from FMS.

Responsibilities:

Performing role of a Tech Lead/Sr. ETL Developer, which includes requirement analysis, design, development, testing, and documentation and production deployment.

Working on Informatica Power centre to develop mappings, sessions and workflows.

Responsible for the planning and management of all technical and operational activities.

Requirement analysis, Logical and Physical database design. Architect, design and execute strategic projects for IDW and its Marts.

As a designer, he was responsible for designing and coding of various key modules, which includes creation of Analysis document, Function Specification, Mapping document, HLDs, LLDs and UTCs, KT document for QA Team and for production rollout.

Responsible for updating the latest versions of the entire project related documents in Calligo.

Worked on Power Centre client tools like Source Analyser, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.

Developed mappings for extracting data from various sources involving flat files.

Mapping business requirements to technical specifications and design logic for implementing the same. Developed data mappings using various transformations between source systems and warehouse using Informatica Designer.

Created sessions using Informatica Power Centre workflow Manager.

Involved testing and UAT support activities.

Responsible for planning the disaster recovery scenarios.

Running integration test cycles and integration testing.

Involved working on IBM DB2 database, designing and creating tables, relations, constraints, indexes.

Extensively involved in writing SQL queries (sub queries and join conditions) for building and testing ETL processes.

Frequent communication with the client, business, QA team on technical and functional queries.

Generic Error Strategy implementation.

Automated the process through UNIX Shell scripting.

Environment: Informatica Power centre (v8.6), IBM-DB2, Oracle 10g, SQL, UNIX, Maestro scheduling, Windows XP.

Project 6: IBDW CCV, CMR and SECPRINT Development (January 2009 to July 2010)

Client: METLIFE INSURANCE, NJ

Position: ETL Specialist / Sr. ETL Developer

The CCV project was in the Holdings part of the Individual business Data Warehouse (IBDW). The Annuity, Life and disability data from various admin systems are loaded into the IBDW. The data consists of policy, dates, measures, transaction, loan, riders, fund allocation and daily positions.

The address data is sent as a request to CMR (Client Management Repository) from where the response is received with standardized data. CMR is an integrated system, which stores gold copy of standardized client address data.

From IBDW, the data is carried to ODS and SEC Marts. SECMART has daily SLA to mail the clients on their current positions. The data from ODS passed to I Tracker reports for the agents to view/analyse.

Responsibilities:

Performing role of a Sr. ETL Developer, which includes requirement analysis, design, development, testing, and documentation and production deployment.

Working on Informatica Power centre to develop mappings, sessions and workflows.

Responsible for the planning and management of all technical and operational activities.

Requirement analysis, Logical and Physical database design. Architect, design and execute strategic projects for IBDW and SEC Mart.

As a designer, he was responsible for designing and coding of various key modules, which includes creation of Analysis document, Function Specification, Mapping document, HLDs, LLDs and UTCs, KT document for QA Team and for production rollout.

Responsible for updating the latest versions of the entire project related documents in Calligo.

Worked on Informatica Power Centre to develop mappings, sessions and workflows.

Used Informatica Power Exchange tool to read source data and generate feeds to external systems.

Integrated 34 admin systems into IBDW, built stage and stage history layer with error checking strategies.

Worked on Power Centre client tools like Source Analyser, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.

Developed mappings for extracting data from various sources involving flat files.

Mapping business requirements to technical specifications and design logic for implementing the same. Developed data mappings using various transformations between source systems and warehouse using Informatica Designer.

Developed different ETL strategies like Set Processing, Error Strategy, Polling and Reconciliation, Error Processing and Re-processing.

Created sessions using Informatica Power Centre workflow Manager.

Responsible for updating the entire project related documents in VSS, the project-tracking tool.

Involved in testing and UAT support activities.

Running integration test cycles and integration testing.

Frequent communication with the client on technical and functional queries.

Building Generic code for quick implementation.

Generic Error Strategy implementation.

Automated the process through UNIX Shell scripting.

Performance Tuning of Sessions and Mappings to meet the SLA of almost 25 systems required for this critical project.

Environment: Informatica Power centre (v8.6), Power Exchange, IBM-DB2, SQL, UNIX, Maestro scheduling, Windows XP.

Project 7: MetLife IB Platform Services Team – Production Support (September 2008 to December 2008)

Client: METLIFE INSURANCE, NJ

Position: ETL Specialist / ETL Developer

MetLife, Inc. operates through its affiliates and subsidiaries as a provider of insurance and other financial services. MetLife is in the process of building a data warehouse for Individual Business. The Individual Business Data Warehouse will integrate the information from various data sources into one central repository providing the organization a cross-enterprise consolidated view of the information. The Individual Business Data Warehouse will serve as the primary source for the Data marts. The purpose of this project is to build a data warehouse for Individual Business that will have information that spans several subject areas, including Compliance, Sales, Policy, Product and Party/Organization, MetLife Bank, EDW (Enterprise Data Warehouse), LDW (Legacy Data Warehouse).

In IBDW Area we have been monitoring the process of loading the data into the various marts.The IBDW Area contains various Warehouses in it like SALES, MetLife Bank, Compliance, IBDW Annuity, and IBDW Citi-street. We have also been supporting the Enterprise Data Warehouse, which contains two marts one for Annuity, which contains information about the various annuities, and QPS mart, which has all the Information about the Special Qualified Plans that company, holds. We also supported legacy Data warehouse. This warehouse contains data containing the information about various Policies and Premiums.

Responsibilities:

Monitoring and reporting through Maestro.

Analysing and preparing the documents for the new requirements.

Reporting for daily production loads.

Worked on troubleshooting the mappings to improving Performance by identifying bottlenecks.

Effectively communicate to Business Partners and team members to resolve the problem and the expected time of resolution.

Provide Analytical Solutions to Production Support problems with my technical and analytical knowledge base.

Have a constant follow-up whether the ABEND or SLA for each task is been logged on to the defect tracking system.

Participate in design, code reviews, documentation of design, and implementation of methodologies for all databases.

Proof of Concept (POC) for any new application.

Responsible for planning the Disaster Recovery Scenarios.

Responsible for provide timely (weekly) feedback and necessary help/cooperation to refine processes in order to meet business’s expectations

Frequent communication with the client, business, QA team on technical and functional queries related to critical production issues.

Environment: Informatica Power centre (v8.6), Power Exchange, IBM-DB2, Oracle 9i, SQL, UNIX, Maestro scheduling, and Windows XP.

Project 8: Project M-Warranty (February 2008 to August 2008)

Client: Volkswagen of America

Position: ETL Developer/Designer

The Project M – Warranty project is a subset of Project M that deals with the changes that are needed in the Volkswagen warranty process to cater to Minivan claims. The primary objective of this project is to enable the Volkswagen and Chrysler warranty systems to seamlessly communicate with each other. The data is populated on weekly basis from Underlying OLTP applications, using ETL methods (Extraction, Transformation and Loading methods) in Informatica. This ETL job was run on daily and weekly basis to feed data.

Responsibilities:

Used Informatica Power Centre for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.

Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.

Created Mappings using Mapping Designer to load the data from various sources into multiple targets, using different transformations like Aggregator, Expression, Filter, Lookup, Sequence Generator, Router and Update Strategy.

Worked on Informatica Power centre tools- Mapping Designer, Workflow Manager and Workflow Monitor.

Update all the project related documents in VSS, the project-tracking tool.

Have a constant follow-up whether the defects for each task is been logged on to the defect tracking system.

Testing & debugging

Environment: Informatica Power centre (v7.1), Oracle 10g, SQL, UNIX, Windows XP.

Contact this candidate