SUMMARY

• Over 14 years of experience in Application Architecture/Development/Administration/Support in Finance/Banking, Communications, Insurance, Sales, Media & Health Care industries.
• Expertise in designing/re - designing, developing and implementing ETL processes.
• Experience with complete Informatica Product Suite (Power Center, Data Quality (IDQ), Data Explorer (IDE), B2B Data Transformation (DT), B2B DT Accelerator
• Informatica ILM Products (Data Archive, Data Subset & Persistent Data Masking), Power Exchange CDC for Oracle & Mainframes
• Informatica Developer 9.1.0, Informatica Analyst 9.1.0, Proactive Monitoring for Power Center Operations and Data Validation Option.
• Experience in using Power Connect/Power Exchange for ERP and Mainframe Systems and Oracle CDC (PWX for Oracle CDC) & Power Exchange for Netezza.
• Extensive experience with Informatica 9.x server administration.
• Data warehouse architecture in both Kimball & Inmon styles and thorough understanding in the field of Data warehouse and Data marts
• Analysis, Design, Development & Implementation of Data Warehouse, ETL, Client Server applications.
• Database and table design and implementation for Data warehouses and related ETL processes.
• Have experience in Source System analysis and Data Quality Analysis.
• Full software life cycle development across numerous software & hardware platforms in a variety of industries.
• Worked on Netezza Data Warehouse Appliance. Worked with Netezza Utilities (NZLoad/NZSQL).
• Experience in Agile/Waterfall development methodologies.
• Experience in Performance Tuning of Source, Targets, Mappings & Sessions.
• Experience in Star Schema/Snow Flake modeling, Fact/Dimension, Physical/Logical Data Modeling using ERWIN.
• Experience in OLAP tools using Business Objects XIR2 and Cognos Report Net.
• Experience in writing UNIX Shell Scripts, SQL*Loader & Performance tuning of Database. Proficient in SQL, PL/SQL, Procedures/Functions, Triggers and Packages.
• Team Player with excellent communications and problem solving skills.
• Experience in Offshore/Onsite Project models & handling multiple projects at a time.

TECHNICAL SKILLS

Databases: Netezza 6.0.5, Oracle 7.x/8i/9i/10g/11g, MS SQL SERVER 2000/2005/2008 , DB2/UDB, Teradata, SAP Tables and MS Access.

ETL Tools: Informatica (PowerCenter 5.1/6.2/7.1/8.6.1/9.1/9.5.1 , Power Connect/Power Exchange for Netezza, SAP R/3, Main Frame and Oracle Change Data Capture (CDC), SQL*Loader.

EDI Tools: Informatica B2B Data Transformation 8.6.1/9.1.0 . B2B DT Accelerator.

Reporting Tools: Business Objects Developer Suite 5.x/BO XIR2, Cognos 6.0, Cognos Report Net 1.1MR2, Crystal Reports, Oracle Reports 2.5

Operating Systems: UNIX (Sun Solaris, LINUX, HP UNIX, AIX), Windows NT/98/95/2000 & Windows XP.

Data Modeling: Erwin 3.5.2,4.0

Languages/Utilities: SQL, PL/SQL, Unix shell scripts, Java, XML, C and Cobol.

Other Tools: Informatica Data Quality, Informatica Power Exchange, Informatica 9.1.0 Developer/Analyst, Proactive Monitoring, Informatica Information Lifecycle Management(ILM) (Data Archive Workbench/Enterprise Data Manager & Persistent Data Masking/Data Subset), AutoSys, Control-M, PVCS, WIN CVS

PROFESSIONAL EXPERIENCE

Confidential, NYC, NY

Sr. Informatica Lead/Architect

Responsibilities:

• Designed, Implemented and Maintained ETL platforms.
• Developed ETL Architecture in accordance with Business Requirements.
• Creating and designing source to target mapping document.
• Carried out root-cause analysis and provide solutions for problems in Informatica.
• Written and implemented ETL standards and best practices for ETL code.
• Created and maintained mappings as needed.
• Designed and developed the near Real Time Web Services.
• Worked on doing the POC for Informatica ILM (Data Archive & Data Masking), B2B DT, Data Analyzer and DVO.
• Worked with Web Services Consumer, Web Services Provider & Unstructured Data transformations.
• Worked on B2B Data Transformation Studio. Created Parsers, Mappers projects in DT.
• Worked on B2B Data Transformation Accelerator to create Mappers from Source to Target XSD’s.
• Created DT Services and used them in Power Center Mappings. Used UDT and XML Parser transformations.
• Extensively worked with Informatica ILM Tool for Data Archive to Retire/Archive the PeopleSoft Database for one of the division (End to End).
• Extensively worked with Persistent Data Masking & Subset to mask the sensitive data and subset for different projects.
• Extensively used DVO to validate the data from Source to Target.
• Extensively used the Power Exchange for Netezza to load data into Netezza database.
• Utilized the Netezza Bulk Reader/Writer to extract and load high volumes of data for updates.
• Educated developers and other team members on Netezza basics.
• Created Data Profile Warehouse and configure profiling from Informatica Power Center.
• Profile source data using data profiling tools (Informatica Power Center/Analyst), understand the source system data representation, formats and data gaps.
• Extensively worked with Informatica Analyst (IDE) tools for Source Profiling and Reference Table Management.
• Configured the Reporting Service. Generated & scheduled the metadata reports using the Informatica Data Analyzer.
• Managed and administered the Informatica Platform across environments.
• Administered users, groups, folders and deployment process across environments.
• Configured and administered the Informatica Services (Integration, Repository, Model Repository, Data Integration, Analyst, Web Services Hub & Reporting services) across environments.
• Setup and Configured the Pro Active Monitoring for Power Center Operations.
• Managed and administered the Rule Point and RTAM tools for Pro Active Monitoring
• Resolved difficult design and development issues.
• Contact Informatica Support and get solutions for the unknown issues.

Environment: Informatica 9.1.0/9.5.1 , B2B Data Transformation, B2B DT Accelerator, Informatica Developer/Analyst 9.1.0, Netezza 6.0.5, Power Exchange for Netezza, RulePoint 5.2, RTAM 3.1, Informatica Information Life Cycle Management (ILM) for Data Archive, Persistent Data Masking & Data Subset, Linux.

Confidential, Trenton, NJ

Sr. Informatica Consultant

Responsibilities:

• Involved in Analysis, Development and Testing of ETL process using Informatica 9.1.0.
• Involved in Design specifications and technical sessions.
• Created and maintained mappings as needed.
• Legacy data from Mainframe’s is extracted using Informatica PowerExchange DataMaps and is stored in Intermediate Staging Database.
• Developed ETL processes to extract staged data, applied various transformation logic based on the mapping document and populated the General claims database.
• Developed and implemented the coding of Informatica Mappings for different stages of ETL
• Used Informatica Data Explorer (IDE) to profile the source data for DQ issues.
• Involved in analyzing the DQ issues and fixed using Informatica Data Quality (IDQ) tool.
• Perform unit testing at various levels of the ETL and developed Low Level Visio flows for the processes.
• Attended On-Site training session from Informatica Education Services on Informatica 9.1.0 Analyst and Developer Tools.

Environment: Windows XP, Informatica Power Center 8.6.1/9.1.0 , PowerExchange, Informatica Developer/Analyst 9.1.0, SQL Server 2005/2008, SQL, Mainframe, Window 2000 Server.

Confidential, Newark, NJ

Sr.Informatica/ETL Lead Developer

Responsibilities:

• Responsible to better understand the Business Requirements.
• Documented user requirements, Translated requirements into system solutions and developed implementation plan and schedule.
• Responsible in writing Technical Requirements Document (TRD) and Low Level Design (LLD) Document.
• Extracted data from wide variety of data sources like Legacy Systems (Main Frames), Flat Files, XML and Relational Database (NMS, CAREMARK, NASCO etc.).
• Extensively used Power Center to design multiple mappings with embedded business logic.
• Extensively worked in developing & testing of ETL, Informatica mappings, workflows / sessions using Informatica.
• Extensively worked with transformation like Aggregator, Joiner, Filter, Router, Expression, SQL, Union, XML Parser, XML Generator, Unstructured, Transaction Control, Java etc. Transformations.
• Created the Data Maps to extract the data from Main Frames using Informatica Power Exchange.
• Extensively worked with Informatica Power Exchange for Oracle CDC to develop a process that involves real time sources to capture the change data.
• Created Table Registrations and Configured the DBMOVER.cfg file.
• Imported the CDC Datamaps(Registrations) in to PowerCenter.
• Knowledge of all kinds of CDC Real-time, Condense Batch and Condense Continuous.
• Worked with Informatica Data Explorer to profile the source data.
• Worked with Informatica Data Quality to generate different plans as per the business requirements and integrated with Power Center as Mapplets.
• Helped the team in analyzing the data to be able to identify Data Quality issues using IDQ.
• Worked with Informatica B2B Data Transformation to parse complex XML’s and integrated with PowerCenter using Unstructured Data Transformation with ServiceDB.
• Worked with Performance tuning of the Mappings, Sessions and SQL Queries Optimization.
• Involved in writing shell scripts for file transfers and other database scripts to be executed from UNIX.
• Hands on experience working with the Informatica Admin Console.
• Train, mentor and work with offshore development teams.

Environment: Windows XP, Informatica Power Center 8.6.1,Power Exchange for Oracle CDC/MainFrame, IDQ, IDE, B2B Data Transformation, Oracle 10g, DB2, SQL Server 2005/2008, ClearQuest and AIX

Confidential, Parisppany, NJ

Sr.ETL/Informatica Developer

Responsibilities:

• Analyzed business requirements, performed source system analysis, prepared technical design document and source to target data mapping document.
• Developed and implemented the coding of Informatica Mapping for the different stages of ETL. Worked on Data Integration Projects extracting data from SAP Systems to SQL Server and Oracle databases.
• Developed new and maintained existing ETL Process under Windows Environment.
• Supporting in Production deployment activities for every release.
• Extensively worked on Power connect/Power Exchange 8.6.1 for SAP R3 to extract from SAP sources.
• Extracted SAP R/3 data by generating ABAP programs and RFC/BAPI function mappings.
• Optimized performance by tuning the Informatica ETL code as well as SQL’s.
• Developed and implemented the coding of Informatica Mapping for the different stages of ETL.
• Perform unit testing at various levels of the ETL. Worked closely with QA team during the testing phase and fixed bugs that were reported.
• Troubleshooting the issues encountered in different environments like Integration Testing, UAT and Production.
• Maintaining Informatica administration works like repository administration, user & security administration.

Environment: Windows XP, Informatica Power Center 8.1.1/8.6.1 , Power Connect for SAP 8.1.1/8.6, Oracle 10g, SQL Server 2005/2008, SQL,Business Objects XIR2, Window 2000 Server.

Confidential, Jersey City, NJ

Sr. DW/ETL Developer

Responsibilities:

• Developed Informatica Mappings, Mapplets and Transformations for different tasks.
• Developed and documented Data Mappings/Transformations and Informatica sessions as per the business requirement.
• Worked closely with the end users and Business Analysts to understand the business and develop the transformation logic to be used in Informatica.
• Analyzed the source data coming from different sources and worked with business users to develop the Mappings.
• Created design documents for ETL mappings.
• Extensively worked in developing & testing of ETL, Informatica mappings, workflows / sessions using Informatica.
• Developed New and Maintained existing ETL Process using different transformations.
• Worked with Informatica PowerCenter 7.1/8.1.1 suite for extraction, transformation and loading of Data Marts. Worked on complete SDLC from Extraction, Transformation and Loading of data using Informatica.
• Worked with different source systems like DST (TA 2000), SEI, FETA, NFS etc., and loaded data into Warehouse for the purpose of business user reporting.
• Extracted Security Data from various sources (CUSIP, ISIN).
• Extensively involved with Data Modeling Team to create the FACTS & DIMENSIONS.
• Developed Informatica mappings to automate and process data loads into ODS and Date Warehouse tables i.e to load data into Dimension and Fact Tables using Informatica.
• Worked with COBOL data source by creating the Copy Books, Flat Files and Relational sources.
• Administration of Informatica i.e. created and maintained the users and privileges.
• Interacted with Business Users and Business Owners to know their Business views in developing and modifying Universes and Reports accordingly.
• Used Cognos Report Net 1.1. MR2 to develop the reports initially and later we upgraded to Business Objects.

Environment: Informatica Power Center 7.1/8.1.1, SQL*Loader, Dimensional Data Modeling, DB2, Oracle 10g, Business Objects XIR2, Rapid SQL, Sun Solaris, CONTROL-M, Win CVS.

Confidential, Basking Ridge, NJ

Sr. ETL Developer

Responsibilities:

• Worked closely with the end users and Business Analysts to understand the business and develop the transformation logic to be used in Informatica.
• Developed mappings in Informatica to load the data from various sources using transformations like Source Qualifier, Expression, Lookup (connected and unconnected), Aggregator, Update Strategy, Filter and Router.
• Worked with Informatica Power Connect for SAP R/3 to extract data from SAP R/3 system.
• As a lead member of ETL Team, responsible for analyzing, designing and developing ETL strategies and processes, writing ETL specifications for developer, ETL and Informatica development, administration and mentoring
• Used Application Source Qualifier for extracting and joining data from SAP R/3.
• Generated and Installed the ABAP codes for the mappings using SAP and transported to UAT and Prod.
• Configured SAPRFC.INI file with PowerCenter Server and PowerCenter Client with parameters specific to SAP R/3 System. This allows PowerCenter to connect to the R/3 system as an RFC client.
• Tested Informatica mappings and also tuned them for better performance and implemented various Performance and Tuning techniques
• Worked on Configuring session tasks in Stream or File Modes with SAP R/3 systems.
• Worked extensively with Cognos ReportNet Framework Manager, Query Studio and Report Studio.
• Developed and maintained the packages in the Framework Manager.
• Developed and modified various complex reports according to the business requirement using Report Studio.
• OLAP Cubes were designed using Cognos Transformer and Impromptu Query definition files.
• Worked on fine-tuning the performance of reports by tuning the Tabular SQL used in the reports.
• Involved in Production Support of the applications on a cyclic basis.

Environment: Informatica Power Center 7.1,Dimensional Data Modeling, Power Connect for SAP R/3, Oracle 9i, Cognos Report Net 1.1MR2, Cognos Series 7, TOAD, Linux, AutoSys.

Confidential, Newark, DE

DW/ETL Developer

Responsibilities:

• Extensively worked on the requirement definition and analysis in support of Data Warehousing efforts.
• Documented user requirements, translated requirements into system solutions and developed implementation plan and schedule.
• Developed and implemented the coding of Informatica Mapping for the different stages of ETL.
• Created mappings using the transformations such as the Source qualifier, Aggregator, Expression, lookup, Router, Filter, Rank, Sequence Generator, and Update Strategy.
• Created and Monitored Batches and Sessions using Informatica Power Center Server.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures.
• At ETL stage, worked in multiple source data extraction and data transition from existing production system to test environment.
• Done extensive testing and wrote queries in SQL to ensure the loading of the data.
• Perform unit testing at various levels of the ETL.
• Developed and implemented the UNIX shell script for the start and stop procedures of the sessions.
• Created and Monitored Tasks, Workflows and Worklets using Workflow Manager.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Applied business and application knowledge to design the data loads for consistency and integrity.
• Developed and tested the backend programs, Informatica mappings.
• Developed Interfaces using UNIX Shell Script to automate the bulk load & update Processes.

Environment: Informatica Power Center 5.1/7.1, SQL*Loader, Oracle 9i (9.2.0.1), Sun Solaris, MSSQL Server, Business Objects 5.1, ERwin 3.5.2, PL/SQL Developer, AutoSys.

Confidential, Lafayette, IN

Data Warehouse/ETL Developer

Responsibilities:

• Involved in the requirement definition and analysis in support of Data Warehousing efforts.
• Interpreted logical and physical data models for Business users to determine data definitions and establish referential integrity of the system.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures.
• Involved in the implementation of this application, which involved the Extraction, Transformation, and Loading of IMS Xponent data into an Oracle database.
• Extensively worked on Drug Distribution Data (DDD), which is used to track sales activity for every major distribution channel, including hospitals etc.
• Developed and tested all the backend programs, Informatica mappings and update processes.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Responsible for troubleshooting any steps that failed, and providing both immediate and long-term problem resolution.

Environment: Informatica Power Center 5.1/6.1,SQL*Loader,Oracle 9i(9.2.0.1) on Sun V880, SQL, PL/SQL, Teradata, Business Objects 5.1, SQL,PL/SQL,Erwin 3.5.2, TOAD 7.3.