Experience summary:

• 8 years of IT experience in Data warehouse projects involving Informatica power center 9.1, Informatica PowerExchange 9.1, Oracle PL/SQL, Sybase ASE, IBM DB2 and UNIX Shell programming.
• Core competency in all phases of software development life cycle which includes analysis, design, development, testing and implementation.
• Experienced as being a team lead for different projects and has been successful in bringing new resources up to speed for ongoing projects.
• Strong experience in development of Informatica mappings and workflows.
• Extensive expertise in tuning the Informatica mappings and SQL queries, to facilitate an improved performance in the production batch cycles.
• Extensive experience on Data Extraction and Load (ETL) from relational and legacy systems such as Oracle, DB2, Mainframe, SAP R/3, XML files and flat files using Informatica Power Center.
• Experience in creating various transformations using aggregator, Look up, Sorter, Update strategy, Joiner, Filter, Sequence generator, Union, Router, SQL, Stored procedure in Informatica power center designer.
• Strong understanding of dimensional modeling, Star and Snowflake schemas.
• Experience in writing and executing test cases for data transformations in Informatica.
• Recognized for building strong client relationships, with over 3 years of onsite experience [USA and Germany].
• Had provided training on Informatica power center tool to a team of new software engineers at Infosys.
• Familiarity with automated job scheduling tools such as Maestro.
• Self starter with excellent communication skills and problem solving skills.

Technical skills:

• Operating system: Windows XP, WIN 2000/2003 server, UNIX (Sun Solaris/AIX).
• RDBMS: IBM DB2, Oracle 91/10g, Sybase ASE 12.5
• Languages: PL/SQL, UNIX shell programming
• ETL tools: Informatica Power Center 8.6/9.1, Informatica PowerExchange 8.6/9.1, Informatica Power Connect (To get data from SAP sources)
• Version management: IBM Rational clearcase, Virtual Safe Source(VSS)
• Other tools: HP Quality Center, SharePoint, Quest TOAD and Tivoli workload scheduler (Maestro)

Employment Summary:

Confidential : Mar 5 2007 till date
Confidential : Dec 13 2004 – Mar 2 2007
Confidential: Nov 17 2003 – Dec 11 2004

Relevant Experience:

Confidential, MA (USA) Oct 2008 till date
Technology Lead

Project Scope:

Insurance Information Factory (IIF), a business unit of Mass Mutual contains the repository of consolidated Insurance data. The data is intended long term to provide business Intelligence, allowing historical analysis, Information delivery, data mining, ad-hoc reporting and file delivery. Additionally, IIF is used to feed many downstream systems, minimizing the maintenance of point-to-point integration between numerous interfaces and the policy administration system.

The major projects implemented at IIF are STP (Straight through Processing) and CDM (Customer Data Management)

• STP

The STP project introduced the TERM policies to the insurance factory from a relatively new (T.P.P) Policy processor (PlanetSoft instance) as well as from the new EDS Radiance Admin system. The Objective of the STP project was to enable the timely access of business critical information and reducing the cost of information delivery through consolidated information. The data from TPP enabled the IIF warehouse to produce the business reports used mainly for historical analysis and decision making.

• CDM

The CDM database is the customer domain of Mass Mutual’s master data management system. The objective of the CDM project is to bring together client records from various administrative systems across the enterprise to create a single, consolidated view of the customer. In addition, CDM will not introduce any data to the existing system but it will rather ensure that the existing data is more accurate.

Roles and Responsibilities:

• To involve in full SDLC of various change requests of IIF application from requirement analysis till production implementation.
• To understand the project data warehousing and reporting requirements.
• Conversion of complex business requirements into modularized Informatica designs.
• To provide the efforts estimations for any change request including all build work, unit testing and deployment.
• To Optimize the Informatica mappings by tuning the SQL queries and session partitioning.
• Responsible for reporting business SLA if the upstream systems for IIF are delayed with the source data in the production cycle.
• To coordinate with offshore team and address their work related issues and concerns.
• To develop FAC and improve the (financial audit and control) process for every IIF feed to meet the SOX compliance.
• To create UNIX scripts and checker jobs to facilitate the ETL integration with other IIF areas such as mainframe and SAP BW.

Confidential
July 2008 – Oct 2008
Technical Specialist

Project scope

The project dealt with creation of a consolidated database ‘Eagle’ which will contain the customer information and their portfolio from various applications of Deutsche bank. Earlier, the data within the bank was scattered in different applications and its integration resulted in inaccurate correspondence, multiple point of contacts, complex processes and slow turnaround time. The project addressed the need to consolidate data from various applications of the bank into Eagle database which acted as a source for many downstream systems.

Roles and Responsibilities

• To gather requirements from business users on a daily basis to analyze the various other existing applications of Deutsche bank.
• To involve in Pre sales for the usage of Informatica power center for data extraction and load.
• To understand the project data warehousing and reporting requirements.
• To create the functional specification document for the data analysis and customer portfolio.
• To involve in the analysis and detail design phase of the project.
• Participated in the effort estimation of development task

Confidential
Mar 2007 – Jun 2008
Technical Specialist

Project scope

The project FDFIMIS involved around the maintenance of Management information System (MIS). This project also facilitated maintaining & re-writing the existing batch process for better performance, which resulted in low maintenance and operational costs. The main objective of the MIS group at Fidelity is to provide support to Sales & Marketing groups by creating Reports on targets, projects, key markets, IPs, clients & products.

Roles and Responsibilities

• To involve in requirement analysis and create functional specification document.
• To involve in performing impact analysis and creating design documents.
• To develop Informatica mappings, sessions and workflows based on the requirement analysis and detailed level document.
• To handle enhancement projects single handedly and to involve in DW support activities.
• Played the role of a DPR (Defect Prevention Representative) for the project.

Confidential Dec 2004 – Mar 2007
Senior Software Engineer

Project scope

Warehouse Management System (WMS) is one of the critical sox compliant applications of GE Aviation. The project at WMS facilitated IT services to the picking, packing and shipping of kit/components at Erlanger distribution center of WMS. Besides identifying and tracking the country of origin for the warehouse parts, the project also enabled to create sales order report and computed shortages at the warehouse location.

Roles and Responsibilities

• To create reusable components in the project such as percentile calculation, representation of data in whisker graph and generic UNIX scripts.
• To create mappings, sessions, workflows to extract data from legacy systems into WMS.
• To provide knowledge transfer on WMS processes and methodologies to new joiners in the team.
• To participate in the user acceptance testing and to interact with end users whenever required.
• Configuration management of different enhancement projects.
• To document the existing process of warehouse management system and save it in the project repository.

Certifications

• Certification: Informatica certified developer

Education

• Confidential University – Bachelor of Engineering (Computer science)