PROFESSIONAL SUMMARY

• Over 7 years of ETL and data integration experience in developing ETL mappings and scripts using Informatica Power Center 9.X/8.x/7.x using Designer Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer , Repository Manager, Workflow Manager Workflow Monitor, ETL, OLAP, OLTP.
• Dimensional Data modeling experience using Data modeling tool Sybase Power designer modeling implemented the Star Schema/Snowflake Schema for FACT Dimensions tables.
• Strong experience with business requirement analysis, source system and Data Analysis
• Involved in all phases of data warehouse project life cycle. Designed and developed ETL Architecture to load data from/to various sources/targets like DB2, Oracle, Flat files, and XML files, Teradata, Sybase and MS SQL Server, SAP and MS SQL Server.
• Created UNIX Korn Shell scripts for Informatica post and pre session operations.
• Experienced withInformatica SAP interfaces.
• Extensive experience in Informatica Designer to create complex mappings using different transformations to move data to a Data Warehouse.
• Hands on experience in tuning mappings, identify and resolve performance bottlenecks in various levels like source, target, mappings and session.
• Hands on experience in scheduling jobs through Autosys Jobs.
• Good knowledge in writing Unix Shell Autosys JIL scripts and PERL Scripts
• Hands on experience in maintaining the code versions using Visual Source Safe.
• Proficient in writing complex Oracle SQL, Views, for database applications.
• Very good exposure to Oracle 10g, 9i, 8.x, MS SQL Server 2000/2005, IBM DB2, Teradata databases
• Good Knowledge in Reporting Tool Business Objects Reports XI and Crystal Report
• Hands on experience working in LINUX, UNIX and Windows environments.
• Experience on Business Requirements Analysis, Application Design, Development, testing, implementation and maintenance of client/server Data Warehouse and Data Mart systems in the Industrial, Insurance, Pharmaceutical industries
• Excellent Verbal and Written Communication Skills. Have proven to be highly effective in interfacing across business and technical groups.

TECHNICAL SKILLS

OS : Unix, AIX 5.2, Windows 7/XP/2000/NT

ETL/Reporting :DTS in SQL Server, Informatica Power Center 9.1,8.6/8.1/7.1.3/6.2, Business Objects XI

Database : Oracle 10g/9i/8i,DB2 9, MS-SQL Server 2000/2005

Data Modeling : Sybase Power Designer 15.2

SQL Editor : PL/SQL Developer, TOAD for DB2

Scripts : UNIX Shell , PERL, Autosys JIL , JavaScript

Scheduler : Autosys

Config Mgmt : Visual source safe, Quality Center

Web Applications : ASP, VB .NET ASP.NET, PHP,HTML

WORK SUMMARY

Confidential

Data Analyst/Informatica Developer

Confidential is an automobile insurance company providing services through agents and online. RTR is a service oriented application interacting with agent's dashboard to give the quote based on the coverage, vehicles, drivers included on the policy. It modifies the request according to the Bristol West BW rules, calls COBOL ALR, generate payplans, calculates premium, applies discount.

Responsibilities

• Involved in translating business requirements to Technical specifications.
• Involved in full project life cycle - from analysis to production implementation and support
• Created pre and post session Stored procedures to drop, recreate the indexes and keys of source and target tables.
• Work as Data Modeler using the Sybase Power Designer to design the tables needed for the dashboard project. Develop the High level design to map the data from source into the data mart tables
• Develop the source to target mapping document for ETL development in Informatica
• Perform system testing and enter test cases in Quality Center to ensure data is loaded and mapped correctly to Data warehouse/ Data mart models according to the source to target mapping document
• Assist business analysts/users in identifying data gap and data variances
• Work with source system SMEs to identify the source data to be brought down to the Data mart
• Developed ETL procedures to transform the data in the intermediate tables according to the business rules and functionality requirements.
• Create and execute unit test plans based on system and validation requirements Troubleshoot, optimize, and tune ETL processes
• Used Informatica Designer to design transformations, reusable transformation, mappings and Mapplets
• Update the data dictionary on system data and mapping information
• Responsible to create interactive Dash board reports as per the Business requirements.
• Documented and maintained and ensured the process and quality of the system.

Environment: Informatica Power center 9.1, Sybase Power Designer 15.2,DB2 9, Toad for DB2 4.5, Flat Files, Quality Center, UNIX and ESP

Confidential

Senior ETL Developer

Confidential is the second-largest pharmaceutical company in the world. As with all drug-makers, research and development is the engine of its business.

Confidential Services project was initiated to store the Dimensional and transactional data of Confidential . The dimensional data included the doctor's details/Pharmaceutical products etc.

• The data warehouse of the transactional data is stored in oracle warehouse using the ETL Informatica and the Customer/ Product Master data was maintained using the Siperian MDM tool.
• Several Summarized reports were created using the Cognos reporting tool.

Responsibilities

• Involved in translating business requirements to Technical specifications. Also performed Column Mapping identifying the Business Rules for some of the requirements.
• Involved in the Preparation of Detail Design Document DDD .
• Developed ETL jobs to extract information from disparate systems like SAP, DB2, Flat Files, Oracle, MS SQL and XML's.
• Involved in creating stage tables/mappings/ setting the trust level -HDD in Siperian for Customer Master system
• Performed Source system study to load the Hierarchy Table. Created Multiple Mappings to load data from including mainframe data available in DB2 schema.
• Worked extensively on Margin controlling system, which is rated as critical for Business and successfully loaded multiples tables as required for reports.
• Extensively used Informatica to load data from DB2 and flat files into staging loading area.
• Performed various transformations, aggregations and ranking routines on the data to be stored in the Data Provisioning Mart
• Used Informatica Designer to design transformations, reusable transformation, mappings and Mapplets.
• Developed and modified existing Hierarchy Table to increase the level of granularity for BO reporting requirements.
• Used Informatica workflow manager to create sessions and workflows for corresponding mappings.
• Conducted unit testing and generated test case reports to ensure the expected Business Standards.
• Documented the mappings and workflows periodically updated the status of the work assigned to the system Owners.
• Involved in identifying the performance Bottlenecks on source, target, mapping, session and successfully tuned them to increase session performance as wells as Oracle views.
• Created mappings in designer to implement all different types of slowly changing dimensions.
• Involved in the code reviews and bug fixing of mappings in production to increase the efficiency.
• Documented and maintained and ensured the process and quality of the system
• Worked with mapping parameters and variables to load data from different sources to corresponding partition of the database table

Environment:Informatica 8.1.1/8.6.1, Oracle, SHELL script, SIPERIAN tool MDM , Autosys

Confidential

ETL / Informatica Developer

Confidential healthcare is one of the largest and most experienced private medical insurance providers in the UK.

Confidential , project was initiated to store the data in the Data warehouse related to products , Insurance Quotations, Customers Individual and Businesses and Services that meet the insurance, protection, savings, retirement and financial planning needs of millions of customers throughout the UK.

Responsibilities

• Involved in the ETL Design and Development of Informatica Mappings
• Involved in Requirement Gathering, Analysis and Design for Loading the VSAM file in to SAP through Power Connect for SAP
• Prepared Unit test Plans and System Test Plans
• Created PERL scripts for Unzipping / Archiving source files and performing looping operations
• Performed Unit testing and delivered the IDOC Status Report for each file posted to SAP conducted Informatica Power connect SAP ALE IDoc methodology training to the team
• Tuning Informatica Mappings and Sessions for OptimumPerformance.
• Executed prototypes for ETL and Data Quality demonstrating their capabilities while training the team to use of the new platform.
• Project management activities:
• Adherence to quality process
• Responsible for on time delivery
• Ensuring Reusability and continuous learning
• Experience in Unit testing and IntegrationTesting of different process in Data warehouse.
• Quality Center is used to document test cases and test cases are executed in Quality center for each new release.

Environment: Informatica Power center 7.1.3, Toad for Oracle, Quality Center, PERL script

Confidential

Software developer

Responsibilities

• Studying existing functionality.
• Involved in DB design. Creating web based reports using ASP and Windows based report using VB.NET
• Developed mappings using DTS to extract CSV files to SQL server DB
• Developing the Stored Procedures
• Performing code migration from Dev to Test Unit testing the modules.
• Created Job package using DTS that sends emails periodically using SQL Server Job scheduler.
• Import Excel Sheets to SQL-Server database using DTS mappings.
• Development of stored procedures.
• Written complex SQL using joins, sub queries and correlatedsub queries.

Environment: ASP 2.0, SQL Server 2000, IIS and JavaScript, DTS Microsoft Server ETL tool , ASP.NET 1.1, C .NET code behind , Microsoft Application Blocks Data Access , DTS in SQL Server 2000, Microsoft Visual Studio.NET 2003, VB.Net Windows Forms, Crystal Reports, SQL Server 2000 DTS