SUMMARY

• Over 7 years of IT experience wif extensive Data warehousing implementationsusing Informatica PowerCenter 9x/8x, SSIS and SQL.
• Experience in Data Analysis, Data Modeling, Data Cleansing, Data Migration, Standardization and Migration and Data Staging of operational sources.
• Knowledge of Data Warehousing concepts &Dimensional modeling likeStarandSnowflake Schemas.
• Hands on Experience in writing SQL queries, Stored Procedures, Function and File - Group in MS SQL server 2008.
• Extensively worked ondevelopingand debugging Informaticamappings,mapplets, sessions andworkflows.
• 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.
• Excellent interpersonal, communication, team management and leadership skills.

TECHNICAL SKILLS

ETL and BI Tools: Informatica Power center 9.1/8.6.1/7.1, Metadata Manager, SSIS

Job Scheduler: Autosys, Informatica scheduler

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

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

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

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

Application Packages: MS Office, Service Now

Data Modeling: Visio

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

PROFESSIONAL EXPERIENCE:

Financial Improvements

Confidential, Hartford, CT

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.
• 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.
• 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, SSIS, Autosys 4.5, Windows

Insurance Data warehouse

Confidential, Hartford, CT

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

Confidential

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.
• 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.