SUMMARY

• 8 years of IT experience with 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.
• Knowledge of Data Warehousing concepts &Dimensional modeling likeStarandSnowflake Schemas.
• 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 Teradata 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.
• 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.
• Strong experience onData Warehouse concepts, ETL, OLAP, OLTP, Star Schema, Snowflake, AS-IS TO-BE models, KPI's, BPM, 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 creatingReusable Transformations(Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and 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 withPerformance 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.
• Experience in building ETL standards, ETL process, batch processing, bulk loading, initial data capture, change data capture, implementation process, identifying re-usability.
• Excellent interpersonal, communication, team management and leadership skills.
• With 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.1/8.6.1/7.1 , Informatica Metadata Manager, SSIS 2005/2000

Job Scheduler: Autosys, Informatica scheduler

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

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

Application Packages: MS Office, Service Now

Data Modeling: Visio

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

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 with 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 with 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 with access rights.
• Planning and supporting application load balancing.

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

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 in corporate the gaps as enhancements to Destiny and Reinsurance Data warehouse.
• Worked on creating reusable mappings for various ETL process.
• Used Informatica Designer with Various Transformation to achieve this task.
• Worked extensively with 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, NY

Informatica Developer

Responsibilities:

• Interacted with five different operating insurance units in the company get the required specification for the extracts.
• Interacted with 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 with 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, UNIX

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 with 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 with 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
• Effectively 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, DTS/SSIS, Autosys, Windows