Summary:

• Over 12 years of experience working in IT industry with 10 years of experience in Data warehouse, data marts and ETL development, maintenance, testing, business requirements analysis, administration and documentation.
• Experienced in designing and implementing star, snowflake dimensional model.
• Experienced in implementing conformed and slowly changing dimension of all type.
• Experienced in requirement gathering, architecture, analysis, designing and developing of DWH projects.
• Has worked as Data Architect/ETL Architect in developing and implementing the DWH solutions across functional domains like Telecom, Retail, hospitality and Insurance
• Experience working in production support environment
• Proficient in Informatica administration work including installing and configuring Informatica PowerCenter and repository servers on Windows and UNIX platforms, backup and recovery, folder and user account maintenance.
• Experience in Informatica 9.0/8.6/8.1 client tools - Designer, Repository Manager and Workflow Manager.
• Experience in ORACLE, Netezza ,DB2, Teradata and Aster database programming
• Experience working individually and also in teams of different sizes. Had managed the team size of up to 25 peoples.

Technical skills:

Professional Experience:

Technology Architect

CVS Pharmacy is the second largest pharmacy chain after Walgreens in the United States, with more than 7,600 stores, and is the second largest US pharmacy based on total prescription revenue.

Responsibilities:

• Working as a Data Architect which involves defining the logical data model, physical data model and data mappings.
• Responsible for defining conformed dimension, facts and integrate them with the Enterprise logical data model.
• Worked on defining the model for Self Service BI. There are no canned reports and business can pretty much slice and dice the data on adhoc basis. The solution is implemented on HDFS/ASTER/Tableau suite and also on Teradata/MSTR suite.
• Responsible for both normalized data modelling and dimensional data modelling.
• Responsible for interacting with and business analysts, business users, SMEs.

Confidential

Technology Architect

Daren Restaurants is the parent company of around 2100 restaurants in USA. The Project aims to enable the business to perform the Check Level Analytics. The projects will help business to do fraud detection, measuring coupon performance, discount performance, most preferred menu combination, employee performance, gross revenue, sales etc

Responsibilities:

• Working as a Solution Architect which involves Defining the data model and ETL architecture.
• Create the Physical Data model, Logical Data model, Technical Design, high level low level design documents, creating ETL specifications, test cases documents for all the new mappings developed for production applications in compliance with SDLC processes
• Responsible for interacting with and business analysts, business users, SMEs technical architects.
• Defined and Delivered Re-usable ETL metadata capture solution.
• Delivered many re-usable components.
• Responsible for End to End delivery of Design and Code

Environment:

Informatica Power Center 9.x, Oracle 11g, UNIX, Erwin, Quest TOAD 9.0, Visio 2003, Microsoft Project 2003, Microsoft Visual SourceSafe

Confidential

Technical Architect

Confidential is a biggest supplier of office stationery in US. Staples had recently overtaken another company Corporate Express CE . This Project aims to design and develop the data mart which support the consolidate reporting for contract related data. The data from both Staples and CE is migrated into single data mart and report were developed on top of it.

Responsibilities:

• Working as a ETL Consultant which involves creating ETL design and leading ETL development using Informatica PowerCenter client tools
• Create the Technical Design, high level low level design documents, creating ETL specifications, test cases documents for all the new mappings developed for production applications in compliance with SDLC processes
• Responsible for interacting with and business analysts, business users, SMEs technical architects whenever there is a need for the redesign of the existing ETLs and process improvements
• Responsible for overall quality of deliverables.
• Delivered many re-usable components.
• Responsible for mentoring the new resources brought into the team
• Responsible for End to End delivery of Design and Code

Environment:

Confidential PowerCenter 8.6, IBM DB2, AIX UNIX 5.3, OS/400, DB2/400, Widows XP, Quest TOAD 9.0, Visio 2003, Microsoft Project 2003, Microsoft Visual SourceSafe

Confidential

ETL Lead Confidential

This project is aimed at providing data mart for shipment related information. J.C.Penney is contracted to 3 carriers which send the data in different format and into different systems. The project aims at loading the data from all these carriers and also enable J.C. Penny to track packages at CTN level and also enable them getting financial report.

Responsibilities:

• Exclusively design ETL Logging and Reject re-processing logic.
• Design and develop Key-Map logic to enhance performance
• Working as a ETL Tech Lead.
• Responsible for creating ETL design and leading ETL development using Informatica PowerCenter client tools
• Responsible for preparing and tracking Project Plan.
• Preparing ETL Estimates and negotiating the same with client.
• Create the Technical Design, high level low level design documents.
• Create ETL specifications, test cases documents for all the mappings developed.
• Responsible for overall quality of deliverables.
• Delivered many re-usable components.
• Responsible for mentoring the new resources brought into the team
• Responsible for End to End delivery of Design and Code
• Performed the code reviews
• Created ETL CoE Standards document for ETL compliance

Environment:

Informatica PowerCenter 8.1/7.1.4, Oracle 10g, IBM DB2, HP UNIX, Widows XP, Quest TOAD 8.0, Workflow Manager, Data Flux, First Logic and Microsoft Visio 2003

Confidential

ETL Tech Lead/Informatica Administrator

• This is a Production Support Project. Data flows into DWH from different OLTP systems. The data was broadly classified into 3 subject areas:
• Retail: All mobile and accessory sales related information
• Insurance: All insurance sales, commissions, penetration ratio etc information
• Telecom: All billing mobile , landline, Broadband related information

Responsibilities:

Support Lead/ADMIN WORK:

• Responsible for updating and configuring Informatica 8.1.1 to Informatica 8.6.1
• Responsible for setting up of High Availability Informatica environment.
• Responsible to complete loading the data into DWH with in SLA.
• The SLA met percentage is in the range of 98.2 -99.99
• Responsible for tuning the existing mappings so as to reduce the total data load run time
• Responsible for delivering many tuning projects to clients.
• Responsible for delivering many functionality enhancement projects to client.
• Design and develop the Netezza archiving strategy.

Environment:

Informatica Power Center 8.1.1, Oracle 10g, Sun Solaris 5.9, Windows XP, Windows 2003 Server, Quest TOAD 8.0, Netezza

Confidential

Tech Lead

The project involves automation of sales force data collection into central repository. The data collected in EDW will then be used by different departments like finance, sales etc for analyses.

Responsibilities:

• Code reviews for the code developed by peer developers
• Carried source control on behalf of the team
• Responsible for preparing and tracking Project Plan.
• Preparing ETL Estimates and negotiating the same with client.
• Create the Technical Design, high level low level design documents.
• Create ETL specifications, test cases documents for all the mappings developed.
• Responsible for overall quality of deliverables.
• Delivered many re-usable components.
• Responsible for mentoring the new resources brought into the team
• Performed the code reviews

Environment:

Data Stage Server edition, Oracle 9, Sun Solaris, Windows XP, Windows 2003 Server, Quest TOAD 8.0

Confidential

Tech Lead

The project involves loading of Equity data into existing data ware house.

Responsibilities:

• Code reviews of the code developed.
• Carried source control.
• Create the Technical Design, high level low level design documents.
• Create ETL specifications, test cases documents for all the mappings developed.
• Responsible for overall quality of deliverables.
• Responsible for mentoring the new resources brought into the team

Environment:

Informatica 7.1, Oracle 9, Sun Solaris, Windows XP, Windows Server, TOAD

Confidential

Software Developer

The project is taking care of benefits DB, DC, HM data of about 230 client. Data is stored into the central repository and various type of reports were provided after performing various type of transformation to the clients. The ETL side is handled in Informatica and for reporting Cognos is used

Responsibilities:

• Code reviews of the code developed.
• Developing ETL mappings
• Carried source control.
• Create the Technical Design, high level low level design documents.
• Create ETL specifications, test cases documents for all the mappings developed.
• Responsible for overall quality of deliverables.
• Responsible for mentoring the new resources brought into the team

Environment:

Informix, C, C , Unix, Informatica, Cognos

Confidential

ASET

The project has been developed for the SOCGEN bank. The software developed is to provide the complete functionality for the SOCGEN bank to automate their Payment, Funding and Transaction Reporting. Various type of message format like SWIFT, HUB, MT, SNCE etc was used in this project. The project is to be implemented in 7 countries.

Responsibilities:

• Data modeling in Master-Craft.
• Code development using Q , Power Builder.
• Peer review of the code.

Environment:

Oracle, C , Q , Power Builder, Tuxedo, Master Craft

Confidential

Software Developer

Project involves programming the ATM NCR server. Project did handle the special activities like Day end and Day Begin. The project was initially developed for citizen cooperative bank. The Plan is to rollout to other local banks as well.

Responsibilities:

• Software development using C .
• Writing procedures, Triggers etc in Oracles
• Peer code review.

Environment:

C , Oracle, Pro-C