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 teh 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 teh business rules completely based on High Level document specifications and implements teh 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 teh 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 dat data was in sync with teh Source tables.
• Developed Mapplets for faster development, standardization and reusability purposes, used stored procedures for teh data coming from database systems to join table at database level rather TEMPthan 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 teh workflows as they are executed and used teh information provided to troubleshoot sessions and improved session performance.
• Created and ran pre-existing and debug sessions in teh Debugger to monitor and test teh sessions prior to their normal run in teh 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 teh full cycle of teh integration. Starting from system study, specification gathering to loading teh data to data warehouse.
• System studies included finding gaps between systems and in corporate teh 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 dis 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 teh changing database connections and variable changes as per teh Source System.
• Part of teh production cutover team dat 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 teh company get teh required specification for teh extracts.
• Interacted with various levels of management to make sure teh planning data and extract data are valid.
• Teh 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 teh dimension tables to teh 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 teh data flow, evaluating transformations and fixing teh bugs so dat they conform to teh business needs and redesign teh existing mappings for improving teh 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 teh stakeholders as per their ad-hoc requirement.
• Also created SSIS packages and Informatica Mappings with various transformations and scheduled as per teh stakeholders requirement to load teh new Data marts for BI team to generate teh reports.
• Extensively supported and enhanced teh 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