SUMMARY

• 8 years of IT experience wif extensive Data warehousing implementationsusing Informatica PowerCenter 9x/8x, SSIS and MS SQL.
• IT experience in all aspects of SDLC process: Requirement analysis, time estimates, functional specification, design, development, testing, packaging, andsupport/maintenance.
• Experience in Data Analysis, Data Modeling, Data Cleansing, Data Migration, Standardization and Migration and Data Staging of operational sources.
• Informatica ETL Architect, Define ETL Standards, ETL process, batch processing, bulk loading, initial data capture, change data capture, implementation process, identifying re - usability.
• Informatica and SQL expertise combined includes Architectural Design & development of BI&DWH, Expertise in implementing of End-to-End BI & DW Projects and Creation of Flexible, expandable DWH architecture to meet business requirements.
• Extensively worked ondevelopingand debugging Informaticamappings,mapplets, sessions andworkflows.
• Strong experience onData Warehouse concepts, ETL, OLAP, OLTP, Star Schema, Snowflake, AS-IS TO-BE models, FACT & Dimensions tables, Conceptual, Physical & Logical Data Modeling. Providing ongoingtroubleshootandsupport for maintenanceandenhancingthe applications to meet the changing business requirements through a Change Management process.
• Experienced in Installation, Configuration, of Informatica PowerCenter on Client/Server environment. Experience in Debugging/Optimizing/Tuning Informatica 9.x, 8.x, 7.x mappings for better Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Experience in creatingTransformationsJoiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer, Rank and processing tasks usingWorkflow Managerto move data from multiple sources into targets.
• Experience in implementing complex business rules by creatinguser defied functions, re-usable transformations and mapplets usingPowercenter.
• Well acquainted wifPerformance Tuningof sources, targets, mappings and sessions to overcome the bottlenecks in transformation and Loading.
• Performed system Analysis and QA testing and involved in Production Support.
• Worked on PLSQL, Stored Procedures, Packages, Views, Synonyms, and Triggers.
• Excellent interpersonal, communication, team management and leadership skills.
• Wif Outstanding leadership abilities, able to coordinate and direct all phases of project based efforts while managing, motivating and leading project teams.

TECHNICAL SKILLS

ETL and BI Tools: Informatica Power Center 9.6/9.1/8.6/8.1/7.1 ,Power MartInformatica Power Exchange tools, SQL*PlusSQL Server 2005/2008 Integration Services (SSIS 2005/2008)SQL Server 2000 DTS Packages, Informatica Metadata Manager

Job Scheduler: Autosys, Informatica scheduler

Databases: SQL Server 2008/2005/2000 , MySQL, MS Access, AS400, DB2, Oracle, Salesforce

Programming: C/C++, MS SQL, PL/SQL

Operating Systems: Windows XP/2000 NT/9.x, MSDOS, UNIX

Web Technologies/Script: HTML, XML, JavaScript, VB Script, CSS, XML

Application Packages: MS Office, Service Now

Data Modeling: Visio, Ervin

Testing and Tracking tools: QTP 7/9, QC, SharePoint, InfoPath, VSS, Visual Studio

PROFESSIONAL EXPERIENCE

Confidential, Hartford, CT

Informatica Lead Developer

Responsibilities:

• Involved in specification gathering and creating technical specification.
• Verification was done in an extensive scale to make sure that data was in sync wif the Source tables.
• Created the data model structure and E-R modeling wif all related entities and relationship wif each entities based on the rules provided by the business manager.
• Developed Mapplets for faster development, standardization and reusability purposes, used stored procedures for the data coming from database systems to join table at database level rather than in Informatica joiner transformation providing more efficiency.
• Worked extensively wif transformations such as Lookup, Joiner, Aggregator, Filter, Joiner, Stored Procedure, Sorter and Update Strategy to create several mappings.
• Used various user defined functions, reusable transformations, mapplets and concurrent workflow executions.
• Created workflows, worklets and designed dependency among them using workflow manager. Concurrent workflow execution.
• Used Workflow Monitor to monitor the workflows as they are executed and used the information provided to troubleshoot sessions and improved session performance.
• Created and ran pre-existing and debug sessions in the Debugger to monitor and test the sessions prior to their normal run in the Workflow Manager.
• Used Pre and Post SQLs to drop and re-create indexes and compression for faster loads.
• Created file lists for flat file sources coming from legacy system, created parameter file for better control over session variables.
• Used repository manager to administer repository, created roles, groups, users and assigned them wif access rights.
• Planning and supporting application load balancing.

Environment: Informatica 8.6.1/7.1, SQL Server 2008/2000, DB2, Oracle, AS400, Salesforce, SSIS, Autosys 4.5, Windows, Visual studio, Visio

Confidential, Hartford, CT

Informatica Lead Developer

Responsibilities:

• Responsible for ETL Process for loading data from Legacy System, Flat Files to stage data mart, transform and load into warehouse schemas.
• Responsible for consolidating various systems to in-house product.
• Responsible for the full cycle of the integration. Starting from system study, specification gathering to loading the data to data warehouse.
• System studies included finding gaps between systems and incorporate the gaps as enhancements to Destiny and Reinsurance Data warehouse.
• Worked on creating reusable mappings for various ETL process.
• Used Informatica Designer wif Various Transformation to achieve this task.
• Worked extensively wif transformations such as XML, Lookup, Joiner, Aggregator, Filter, Sorter and Update Strategy to create several mapping.
• Used various active and passive transformations for data control and cleansing.
• Developed materialized view and summary tables necessary for structured and ad-hoc reporting.
• Used debugger for testing purposes as well as used expression editor for conditional check on values coming passing through mappings.
• Created workflows and designed dependency among them using workflow manager using various tasks.
• Involved in designing incremental load strategy.
• Used Autosys to scheduling jobs, implemented file watcher to trigger load processes.
• Used Parameter files extensively to define the changing database connections and variable changes as per the Source System.
• Part of the production cutover team that include capacity planning, resource planning and cutover documentation preparation.
• Involved in pre and post migration planning for optimizing data load performance, capacity planning and user support.

Environment: Informatica 8.6.1/7.1, SQL Server 2008/2000, DTS, Autosys 4.5, Windows, Salesforce, Visio

Confidential, NY

Informatica Developer

Responsibilities:

• Interacted wif five different operating insurance units in the company get the required specification for the extracts.
• Interacted wif various levels of management to make sure the planning data and extract data are valid.
• The extracts were used by various business units for planning and reporting purposes.
• Extract, transform and load data based on set of business rules, built reusable mapplets and reusable transformations using Informatica designer.
• Used Reinsurance Data Warehouse Dimension tables and Fact tables as sources and created Tables, Flat files as target.
• Implemented sets of reference data to map the dimension tables to the Revenue Planning Engine attributes.
• Used extensively Flat file and xml file as source or target.
• Created mappings wif transformations such as source qualifier, aggregator, expression, lookup stored procedure, rank and update strategy.
• Used various functions in Aggregator Transformation to build summary tables.
• Used stored procedure on pre-loading and post loading for sources and targets to generate and drop temporary tables, indexes for better performance.
• Identified bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs and redesign the existing mappings for improving the performance.
• Created batches and sequences for running and controlling set of jobs.
• Documented existing mapping.

Environment: Informatica 8.6.1/7.1, SQL Server 2008/2000, DTS/SSIS, Autosys, Visio, Visual Studio

Confidential

Informatica/SSIS Developer

Responsibilities:

• Being an ETL developer, developed T-SQL stored procedures, triggers to the stakeholders as per their ad-hoc requirement.
• Also created SSIS packages and Informatica Mappings wif various transformations and scheduled as per the stakeholders requirement to load the new Data marts for BI team to generate the reports.
• Extensively supported and enhanced the MSBI-SSIS packages for legacy applications.
• Coordinated wif SQL Server/Informatica DBAs, and systems support personnel in elevating and automating successful code to production.
• ETL architecture - Prepare Data Flow diagrams, identify major streams like Data Conversion, Historical, Data Retention Archival, Data Quality, Reconciliation
• TEMPEffectively used various Informatica transformations including but not limited to Normalizer, Router, Union and Update Strategy.
• Developed SSIS packages using transformations such, Union All, Merge/Merge Join, Lookup, Join, Derived column.
• Hands on expertise in migrations from MS SQL Server 2000(DTS Packages) to MS SQL Server 2005 and to MS SQL Server 2008.
• Extensive experience in writing Transact-SQL (DDL/DML/Procedures) queries.

Environment: Informatica 8.6.1/7.1, SQL Server 2008/2000, DB2, DTS/SSIS, Autosys, Windows

Confidential

Informatica Developer

Responsibilities:

• Designed the Data Warehouse (logical and physical models), designed and developed the dimensional data models (star schema), and supported the UAT and production phases.
• Created the Transformation Rules, Mapping Specifications and Workflow Specifications.
• Involved in doing the Impact Analysis of the changes done to the existing mappings and providing the estimations.
• Created the design specs for loading the data from OLTP to STG Schema, STG schema to DWH Schema.
• Developed and maintained ETL mappings to extract the data from multiple source systems which comprise of Oracle 9i, flat files to multiple targets like Oracle and Flat files.
• Created extensive mapping/Mapplets, reusable transformations using all the transformations like Normalizer, lookup, filter, expression, stored procedure, aggregator, update strategy, worklets etc.
• Extensively worked on tuning and improving the Performance of Mappings.
• Created utility programs for file manipulations, pre-session, post-session using shell scripts.
• Performed ETL testing, created Unit test plan and Integration test plan to test the mappings and created the test data.

Environment: Informatica Power Center 7.1.2, Oracle 9i, SQL, PL/SQL, SQL*Plus, DB2, Windows 2000, UNIX, Ervin