TWO PAGE RESUME 1 by aniltheblogger


More Info
									Mobile: E-Mail:

Check the below link for more 1000’S of formats
Curriculum Vitae

Professional Summary
              Have more than 3.5 years of experience in the IT industry in the field of Data Warehousing. Have a strong business knowledge and understanding of the Chemical and Manufacturing domains. Have extensive experience in Informatica PowerCenter (7.1.2 / 8.5.1). Have created complex mappings in Informatica using transformations like Lookup, Normalizer, Joiner, Aggregator, Router, Sorter, Union and Update Strategy. Have worked extensively on data extraction from relational tables and flat files using Informatica. Have worked on Informatica RFC mappings to extract SAP table data to DB2 tables. Have extensively worked on writing SQL queries for generation of ad-hoc reports. Have written UNIX shell scripts, for invoking workflows with pmcmd command and automation of workflows and creation of parameter files. Have some experience in reporting tools like Cognos ReportNet, and certified in Cognos ReportNet 1.1 and Cognos Impromptu 7.3. Have extensive knowledge of data migration, including the whole process of loading data from legacy systems to the SAP environment. Have had the experience of leading a team of 3, and was completely in charge of day-today deliverables during development. Have worked extensively on unit and integration testing of informatica mappings, and documenting the same. Have proficiency in understanding the user/business requirements, and converting the same into Informatica mappings and workflows. Have been involved in a customer facing role while with DuPont, Wilmington, Delaware, for the loading and analysis of bulk data on a daily basis.

Page | 1

Page | 2

Degree B.E. (Computer Hardware and Software Engineering) University Year of Passing



Designation Senior Software Engineer

Duration 10/2005 – Till date

Technical Skills

ETL Tools OLAP Databases OS Language Tools Domain knowledge

Informatica 8.5.1, Informatica PowerConnect 7.1.2 Cognos Impromptu 7.3, Cognos ReportNet 1.1 IBM DB2, Oracle 10g/9i/8i Windows XP/2000/NT/98, UNIX, Mac 8i UNIX shell scripting Smart FTP, Toad, Rapid SQL Chemical Manufacturing

Page | 3

Projects Profile

1. Client Role Organization Duration Team Size

Project Name : Informatica Developer, Team Lead 07/2006 – 11/2008 Project : 60 Software:

Module : 7

Tools : Informatica 7.1.2,Power Connect Database : DB2 SAP interface: RFC Script :Unix Scripts

Project Description
E.I DuPont de Nemours, founded in 1802, puts science to work by creating sustainable solutions essential to a better, safer, healthier life for people everywhere. Operating in more than 70 countries, DuPont offers a wide range of innovative products and services for markets including agriculture, nutrition, electronics, communications, safety and protection, home and construction, transportation and apparel. DuPont is in the process of migrating legacy data to SAP. P&IP ETL team was responsible for data cleansing and separating the good and error records before loading the legacy data of the P&IP (Polymers and Industrial Packaging) business into SAP. This also involved extensive interaction with the client during the development and data loading process. This project, where ETL is used as an intermediate step before the SAP load, after successful implementation, is used as a template for other such data migrations in DuPont.

Offshore Informatica Developer / Team Lead        Analyzing the business rules as per SAP and ETL template. Creation of technical specification according to the template. Developing Informatica Mappings and Workflows. Testing the mappings with respect to the required LSMW format and requirements. Optimization of the existing Mappings to reduce the runtime. Converting legacy data to standard LSMW data. Analyzing all errors generated by Informatica and fixing those errors in data collection.

Page | 4

 

   

Automating the workflows by use of UNIX scripts to reduce manual intervention and increase efficiency. As part of the offshore team, was the only ETL resource working on the project during the initial development, and had to work on inputs provided by the Onsite SAP functional people. Initially required to work Onsite at Wilmington for 2 months for KT to the offshore team. As the offshore Informatica Team Lead, was responsible for all deliverables with respect to the SAP STC (Sales to Cash) objects, and loading the data for the same. Required to work with the SAP technical team for loading the flat files provided as output from Informatica into SAP. Also responsible for fixing the data errors after consultation with the SAP functional cocoordinators and the client.

Onsite Software Specialist      As part of the P&IP onsite team, was responsible for loading the data for P&IP’s Material Master into SAP. Required to monitor the load at every stage and communicate errors immediately to the client, and also to correct the errors for subsequent loads. Providing real time load status reports by querying from the database as per customer requirements. Required to write UNIX scripts to completely automate the whole Informatica process, including all workflows and lookup table refreshes (using RFC). Involved in extensive knowledge transfer sessions to give the client-managed support team which was primarily non-technical, to take on and manage the entire data load process for the P&IP business. Also involved in KT sessions to other businesses of DuPont, which now follow the same template for data load (Informatica/LSMW/SAP R3) after the successful implementation of this methodology in P&IP.


2. Client Role Organization Duration Team Size

Project Name : Informatica Developer / Tester 03/2006 – 06/2006 Project : 15 Software: Module : 1 Tools : Informatica 7.1.2, Power Connect Database : DB2 SAP interface: RFC

Page | 5

Project Description
CET is a tool which is used to load data from the database into SAP using Informatica SAP R3 PowerConnect. This tool, which can be reused, has been designed to load data into various SAP objects like Material Master, Customer Master, Vendor Master, and the various Quality and Sales objects.

     Analyzing the business rules as per SAP template, and checking that all rules have been implemented in the Informatica Mappings. As tester, was responsible for unit testing all the mappings for all business rules for the Material and Customer Master, and preparing documents for the same. Was required to prepare test data files, with both positive and negative test scenarios, after extensive sessions with the functional consultants. Also responsible for integration testing the extremely complex rules of the Master objects, and extensively documenting the same for understanding. Was also responsible for conveying erroneous rules in the mappings to the SAP functional coordinators.

Page | 6

Personal Details
Date of Birth Nationality Gender Languages Passport No. Visa Address : : : : : : :

- Valid Upto: - Valid Upto:

Page | 7

To top