PROFESSIONAL SUMMARY

• 7+ years of Data warehousing experience using Informatica, experience in implementation of ETL methodology, Data Extraction, Transformation and Loading and Business Intelligence, Distributed Computing, Analysis, Design, Test Case Preparation, Development, Implementation of Client/Server, Internet/Intranet Applications, Databases.
• Highly motivated and goal-oriented individual with a strong background in SDLC Project Management and Resource Planning using AGILE methodologies.
• Developed the Data Warehouse Architecture and dimensional modeling of data.
• Extensively worked on Designer, Repository Manager, Workflow Manager and Workflow Monitor using Informatica ETL Tool.
• Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for data loads.
• Worked extensively with Informatica Designer to create complex mappings using expressions, Routers, Lookups, aggregators
• Participated in Full life cycle development of Data Warehouse systems such as Analysis, Design, Development, and Testing & Technical Documentation.
• Developed Mappings using Type 1, Type 2 SCD (Slowly Changing Dimensions) logic to load data into Dimension tables.
• Knowledge of the software lifecycle, design techniques & OO Methodologies.
• Knowledge in designing Fact & Dimension Tables, Physical & Logical data models.
• Proficient in requirements gathering, from both functional and technical perspectives and strong understanding of Data Warehousing concepts, expertise in KIMBALL methodology.
• Extensively used Analysis Services development tools to create anAnalysis Services database and an OLAP cube, and how to use theAnalysisServices management and administrative tools to manage anAnalysis Services solution.
• Developed and operated data cleaning process and also responsible for all types of loading of data.
• Experience in Performance Tuning – Comprehensively implemented all the Tuning Methodologies involving Tuning Sources, Targets, Mappings, Sessions and the System Parameters etc.
• Strong knowledge and experience in Data warehousing concepts, Data modeling, dimensional Star Schema and Snowflakes Schema methodologies, implementing Slowly Changing Dimensions etc.
• Performed Unit, Functional, Regression, Integration, Database and User Acceptance Testing (UAT).
• Developed scripts in UNIX, SQL and PL/SQL.
• 2 years Experience in Callidus Suite-TrueComp.
• Trained in Business Objects and posses knowledge in Datastage. Exposure with Reporting tools like Crystal Reports.
• Trained non-Technical Business Users as well as mentored junior developers with BI, DW and ETL.
• Excellent Communication and Interpersonal Skills in interacting with Clients and Business Users.
• Played individual as well as team-oriented roles

Technical Skills
ETL Tools: :- Informatica Power Center 9x 8x 7x 6x Datastage 
Languages: :- SQL, PL/SQL, Java, C, C++
RDBMS: :- Oracle 10g/9i/8i, MS Access
Environments: :- WINDOWS NT/98/95/2000/XP, LINUX, IBM OS/2, UNIX,
MS-DOS
Scheduling: :- Informatica Scheduler, Unix scripts 
OLAP Development :- MS Excel spreadsheet
Reporting Tools: :- Business Objects XI/6.5/5.1, Crystal Reports

EDUCATION

• B. Tech in Information Technology.

PROFESSIONAL WORK HISTORY

Confidential, Parsippany, NJ. Jan 12 – Till Date
Informatica DeveloperGeneric Web Order System is an internet based application to activate different services via secure server on the internet. This Web Order System process is the most easily accessible, simple and convenient to the customers. By using this Web Order Entry application, customers can directly place the orders through internet.Responsibilities:

• Worked with Business Analyst and Analyzed specifications and identified source data needs to be moved to data warehouse, Participated in the Design Team and user requirement gathering meetings.
• Worked on Informatica – Repository Manager, Designer, Workflow Manager & Workflow Monitor.
• Involved in discussing Requirement Clarifications with multiple technical and Business teams.
• Created Technical Design Document from the functional specification documents.
• Worked on Informatica tools such as Source Analyzer, Data Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer to designed, developed and tested complex mappings and mapplets to load data from external flat files and RDBMS.
• Used Informatica PowerCenter 9.1 for extracting Oracle, flat files for Data Extraction Involved in the development of Informatica mappings and also tuned them for better performance.
• Extensively used various transformations like Source Qualifier, Joiner, Aggregators, Connected & Unconnected lookups, Filters, Router, Expression, Rank, Union, Normalizer, and Update Strategy & Sequence Generator.
• Used SQL, PL/SQL, TOAD to validate the Data going in to the Data Ware House.
• Worked with BA in the QA phase of testing.
• Worked on Informatica Schedulers to schedule the workflows.
• Extensively involved in ETL testing, Created Unit test plan and Integration test plan to test the mappings, created test data. Use of Debugging tools to resolve problems.
• Used workflow monitor to monitor the jobs, reviewed error logs that were generated for each session, and rectified any cause of failure.
• Created Documentation(Runbook,Technical Design Document and Low Level Design Document) for Supporting the Application using Microsoft Word, Visio.

Environment: Informatica Power Center 9.1/8.6, Oracle 11g, PL/SQL, SQL, SQL*LOADER, TOAD, Shell Scripting

Confidential- Collegeville, PA Jan 2011 to Dec 2011
Informatica DeveloperThis is a data integration project where the data from various client databases is integrated into a single database which in turn feeds various mortgage downstream applications.
Confidential is one of the world\'s largest research based pharmaceutical health-care companies. It is a global leader in pharmaceuticals, consumer health care products and animal health care products. The project deals with building a real time view of enterprise wide data. A decision support system was built to compare and analyze product prices, their quantities and patient profiles. IMS Health data is combined with data from other sources and is made available for ad-hoc reporting. This Data Warehouse is used to deliver reports and information to sales and marketing management.Responsibilities:

• Extensively Working on Informatica tools such as Source Analyzer, Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer
• Using InformaticaPowercenter8.6and9.1to make the changes to the existing ETL mappings in each of the environments.
• Involved in the migration ofInformatica8.6workflowsintoInformatica9.1version.
• WrotePL/SQLprocedures which are called fromStored Proceduretransformation to perform database actions such as truncate the target before load, delete records based on a condition and rename the tables.
• Create ETL mappings with complex business logic for high volume data loads using various transformations such as Aggregator, Sorter, Filter,Normalizer,SQL Transformation,Lookup, Joiner, Router, Update Strategy, Union, Sequence Generator, transformation language likes transformation expression, constants, system variables, data format strings etc.
• Extensively worked on building workflows, worklets, sessions, command tasks etc.
• Extensively worked on ETL performance tuning for tune the data load, worked with DBAs for SQL query tuning etc.
• Proficient in implementing all transformations available on the SSIS toolbox.
• UsingSourceQualifier&Lookup SQLoverrides,Persistentcaches, Incremental Aggregation, Partitions, Parameter Files etcfor better performance.
• Working on change requests to the existing processes in production
• UsedEvent wait Task, Control Task, Email Tasks, Command Tasks, Link conditionsin workflows.
• Bulk load the database tables from flat files usingOracle SQL Loader.
• Working on creating & modifying theunix shell scripts.
• Provide test data inQA/UATfor the downstream application testing.
• Involved in running the loads to the data warehouse and data mart involving different environments.
• Responsible for definition, development and testing of processes/programs necessary to extract data from client\'s operational databases, Transform and cleanse data, mask the data needed and Load it into data marts.
• Extensively used PL/SQL, TOAD programming in backend and front-end functions, procedures, packages to implement business rules.
• Integrated various sources into the Staging area in Data warehouse
• Provided production support to schedule and execute production batch jobs and analyzed log files in Informatica8.6/& 9.1Integration servers.

Environment: Informatica Power Center 9.1/8.6, Oracle 11g/10g PL/SQL, SQL, SQL*PLUS, SQL*LOADER, Shell Scripting.

Confidential- Omaha, NE May 2009 to Dec 2010 
ETL DeveloperConfidential’s name and symbol represent the nation’s largest and most experienced health care system. The Confidential organization is not one single company, but rather a confederation of independent, community-based Blue Cross and Blue Shield Plans. Collectively, Confidential Plans cover more than 93 million people, nearly one-third of all Americans. The project was aimed to build an Enterprise Data warehouse (EDW) to report 8 years worth of data, to be stored in SQL database, data from different sources (Main frame & Flat files) is brought into SQL Server using Informatica ETL tools Power Center & Power Exchange.Responsibilities:

• Involved with development of ETL process flows to transform data from multiple sources into common staging area and then loaded them to the target Warehouse database.
• Designed the Mapping Technical Specifications on the basis of Functional Requirements.
• Developed/Enhanced the complex mappings, Workflows to Extract, Transform, Load data from different source systems like Oracle, SQL Server, Flat files, Excel, to Target Oracle systems.
• Involved Data migration from one environment to another environment using ETL Informatica tool, Data Extraction, Data Cleansing, Data Staging of operational sources.
• Created reusable mapplets and transformations starting concurrent batch process in server and performed backup, recovery and tuning of sessions.
• Developed different mappings by using different Transformations like Aggregator, Lookup, Expression, update Strategy, Joiner, Router etc to load the data into staging tables and then to target. Aggregator, Lookup, Expression, update Strategy, Joiner, Router, processes, test cases, and error control routines Sequence generator etc transformations in the mappings.
• Used different Data Quality transformations like Standardizer, parser, merger, case converter, Match, etc in the mappings.
• Build custom profiles using IDE to analyze the data and also run scorecards.
• Extensively used Informatica client tools – Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Worked on analyzing the PLSQL code for extraction of Business logic involved in the Data loading process.
• Developed many data load rules for loading specific type of data files.
• Worked on analyzing the Quality of the Data from the Source Feeds before the ETL process could start.
• Implemented standards for naming Conventions, Mapping Documents, Technical Documents, Migration form

Environment: Informatica Power Center 8.X, Oracle 11, PL/SQL, SQL, SQL*PLUS, SQL*LOADER, ERWIN 3.5, ,MS-Excel XP Spreadsheet Add-In, Shell Scripting.

Confidential, Silver Spring, MD Nov 2008 – April 2009
ETL / Informatica DeveloperConfidential is one of the largest non-profitable Health Care Organization’s in the US providing services in the Health Care Industry. The objective RATS MAS (Risk Adjustment Tracking System for Mid Atlantic States region) is to provide consistent and valid patient’s claims and non-claims data for various subject areas.Responsibilities:

• Analyzed specifications and identified source data needs to be moved to data Mart, Participated in the Design Team and user requirement gathering meetings.
• Worked on Informatica – Repository Manager, Designer, Workflow Manager & Workflow Monitor
• Involved in discussing Requirement Clarifications with multiple technical teams.
• Created the standards for implementing the ETL jobs, Low level Design Documents, Technical Design Documents.
• Installed Informatica 8.5.
• Extensively worked on Informatica tools such as Source Analyzer, Data Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer to designed, developed and tested complex mappings and mapplets to load data from external flat files and RDBMS.
• Worked with the Business Analyst team during the functional design and technical design phases. Designed the mappings between sources (external files and databases) to operational staging targets.
• Participated in the analysis of development environment of extraction process and development architecture of ETL process. Used Informatica PowerCenter 8.5 for extracting Oracle, flat files for Data Extraction Involved in the development of Informatica mappings and also tuned them for better performance.
• Extensively used various transformations like Source Qualifier, Joiner, Aggregators, Connected & Unconnected lookups, Filters, Router, Expression, Rank Union, Normalizer, and Update Strategy & Sequence Generator.
• Extensively used Workflow Manager and Workflow Monitor and scheduling ETL jobs in Informatica PMCMD, repository creation/Backup/Restore using PMREP, Creating repository user/role/group
• Used SQL, PL/SQL, TOAD to validate the Data going in to the Data Ware House
• Worked along with the DBA to resolve performance and tuning issues
• Modeling and populating the business rules using mappings into the Repository for Meta Data management..
• Worked on Informatica Schedulers to schedule the workflows.
• Extensively involved in ETL testing, Created Unit test plan and Integration test plan to test the mappings, created test data. Use of Debugging tools to resolve problems.
• Created Task Session, Email and Workflow to execute the mappings. Used workflow monitor to monitor the jobs, reviewed error logs that were generated for each session, and rectified any cause of failure.
• Created Documentation(Technical Design Document and Low Level Design Document) for Supporting the Application using Microsoft Word, Visio
• Worked with DBA in Repository Manager to create Folders, Groups and Users.

Environment: Informatica Power Center 8.5/8.1, Power Center, Oracle 10g,PL/SQL, SQL, SQL*PLUS, SQL*LOADER, Embarcadero, ,Business Objects XI 3.1, Shell Scripting ,WINDOWS NT

Confidential, Chennai, India June 2006- Oct 2008 
Truecomp and Informatica DeveloperThe Project Confidential is one of the very few green field project. This is to create a commissions system which will have the responsibility for calculating both external and internal commission payments for Confidential. This is implemented using a package which is specialized in computing commissions in various industry segments. Confidential project uses Informatica ETL tool, TrueComp rules engine and Crystal Reports reporting tools.This system will process the incoming data feeds (Data Integration), run a batch processing job to calculate commissions (TrueComp Pipeline), extract the operational data (Report ETL) into a reporting repository (Data Mart) and produce data extracts for downstream systems.Responsibilities:

• Understanding existing business model and customer requirements.
• Analyzing the functional requirements.
• Preparations of Technical Design Documents from the Functional Design Documents.
• Analyze the new change request, estimate the new change and design the same.
• Have attended numerous walk through given by the on-shore team with my team members and got exposure on the client’s business logic.
• Extensively worked on Informatica Power Center – Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet & Transformations to import source and target definitions into the repository and to build mappings.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier.
• Developed mapping to implement type 2 slowly changing dimensions.
• Created mappings and transformations.
• Created and executed sessions using Workflow Manager.
• Have Developed Direct and Rolled Order Credit Rules in TrueComp tool.
• Have Experience in TrueComp Pipeline Execution.
• Exposure to the Stage and Repository tables of TrueComp
• Preparation of Unit Test Cases and Unit Test Data.
• Execution of Unit Test Cases and Unit test Data.
• Assisted the new joiners to the team by explaining the project functional knowledge.
• Conducted knowledge sharing sessions on True Comp for my team members that have helped them in understanding the rules and in preparing the design documents more efficiently.
• Internal review of mapping design & development, test results and raising internal defects to take corrective action and to ensure quality deliverables to onsite.

Environment: Windows XP, Oracle 10g, SQL, Callidus TrueComp (5.x), Informatica ETL (8.x), Crystal Reports

Confidential, Jun 2005 –May 2006
Truecomp and Informatica Developer
The Project Confidential is one of the very few green field project. This is to create a commissions system which will have the responsibility for calculating both external and internal commission payments for Confidential. This is implemented using a package which is specialized in computing commissions in various industry segments. The Confidential Comissiones project uses Informatica ETL tool, TrueComp rules engine and Crystal Reports reporting tools. This system will process the incoming data feeds (Data Integration), run a batch processing job to calculate commissions (TrueComp Pipeline), extract the operational data (Report ETL) into a reporting repository (Data Mart) and produce data extracts for downstream systems.Responsibilities:

• Involved in gathering user requirements along with business analysts.
• Analyzing the functional requirements.
• Preparations of Technical Design Documents from the Functional Design Documents.
• Designed and developed ETL process using Informatica tool. According to the business logic created various transformations like Source Qualifier, Normalizer, Connected and Unconnected Lookup, Stored Procedure, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression, and Update Strategy.
• Interacted with business community and gathered requirements based on changing needs.
• Created reusable transformations and used in various mappings.
• Used various debugging techniques to debug the mappings.
• Unit testing & peer reviews.
• Fixing invalid Mappings, Unit and Integration Testing of Informatica Sessions.
• Have Developed Rules in Truecomp.
• Created Participants, Positions, Plans, Titles and Categories in Truecomp.
• Knowledge about Rule Elements.

Environment: Windows XP, Oracle 10g, SQL, Callidus TrueComp (5.x), Informatica ETL (8.x), Crystal Reports