SUMMARY:

• Around 12 years of professional Information Technology experience, with expertise in the field of Enterprise Data Warehousing, Data Integration and Master Data Management.
• Extensive exposure to Business Intelligence projects with experience in building Enterprise Data Warehouse, Integrated Consumer Data Warehouse, Data Marts and Operational Data Stores.
• Involved in different phases of Data Warehouse Life Cycle including business reporting requirements gathering, source system analysis, logical/physical data modeling, ETL design/development, project deployment, production support.
• 8 years of experience in using Informatica ETL tool v 9.1.0/9.0.1/8.6.1/8.1.1/7.1.3/6.2/5.1, Informatica PowerExchange 8, Informatica Developer 9.1.0, Informatica Analyst,9.1/9/5.1, Informatica Administrator with industry best practices and experience in Reporting tools like Business Objects and Cognos.
• 3 plus years of experience in understanding the architecture and business process in Informatica MDM 9.1/ 9.5.1/9.7.1 and also responsible for the developing, enhancing and supporting the MDM and Informatica Data Director (IDD) platforms and related data integration applications.
• Hands - on experience with Informatica MDM Hub Console like working with Data Mappings from Landing, staging and to Base Objects, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation and involved in customizing and configuring IDD applications
• Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Expertise in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages
• Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDM Hub implementation.
• Around 2 years of experience in production support with CITI, resolving on-going maintenance issues and bug fixes; monitoring Informatica processes, as well as performance tuning of mappings and sessions.
• Expertise in Ralph Kimball & Bill Inmon’s Methodologies.
• Experience in dimensional modeling (Star Schema & Snow Flake Schema) and SOA.
• Expertise on various UNIX (AIX, SUN, HP - UX and SVR) systems and Scheduling tools like AutoSys & Control-M.
• Good knowledge of Oracle RDBMS v11g/10g/9i/8i with proficiency in writing SQL queries and PL/SQL procedures.
• Experience in writing bash, ksh UNIX scripts.
• Good business knowledge in Banking, Finance, Auto, Healthcare & Manufacturing.
• Team player, self-starter with excellent communication and interpersonal skills.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, C, COBOL, XML

Scripting: UNIX shell scripting (ksh), DOS scripting

Databases: Oracle 11g/10g/9i/8i, SQL Developer, SQL Server 2005 / 2008, DB2, Teradata SQL Assistant 13.0, Postgre SQL

ETL Tools: InformaticaPowerCenterV 9.1.0/9.0.1/8.6.1/8.1.1/7.2/6.2/5.1, Informatica PowerExchange, Informatica Administrator, Informatica Metadata Manager

Data Quality Tools: Informatica Developer 9.1.0, Informatica Analyst 9.1/9.5.1

EIM Informatica: MDM Multi-Domain, IDD, SIF

Application Server: Jboss

Other Tools: AutoSys, Control - M, SQL*Plus, TOAD for Oracle, Toad for Db2, SQL*Loader, MS Visio 2000

Operating Systems: AIX, Solaris, Windows 95/98/2000/NT/XP, MS DOS

Methodologies: ER Modeling, Dimensional Modeling, Data Warehouse Life Cycle

PROFESSIONAL EXPERIENCE:

Confidential, Canons burgh, PA

SR MDM CONSULTANT / DATA QUALITY / POWERCENTER

Responsibilities:

• Involved in business requirement meetings with business for the source to target mappings.
• Created deduplication mappings usng informatica developer tool for IDQ process
• Created matching analysis mapping to identify the matching records for Arcos & Veeva files.
• Created basic column profiling for all the files under Veeva.
• Created source to target mappings using informatica powercenter to load data into staging tables using different types of transformations like expression, lookups, filter.
• Created Trust matrix document and configure into MDM Hub Console for all the attributes.
• Configure landing and staging tables in MDM Hub console.

Environment: Informatica MDM HUB 9.7.1, Informatica Developer 9.5.1, Informatica Power Center 9.5.1 Oracle 11.2, Unix, Autosys, Informatica Analyst. Putty, SQL Developer.

SR MDM CONSULTANT / DATA QUALITY / POWERCENTER

Responsibilities:

• Involved in business requirement meetings with analysts for the source to target ( staging ) mappings.
• Performed land process to load data into landing tables of MDM Hub using external batch processing for initial data load in hub store.
• Created mappings using different cleanse functions to load Cleansed data from landing to staging tables.
• Configure Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties for base objects.
• Created entity objects, entity relationships and profile for hierarchy using Hierarchies workbench.
• Involved with Informatica team members in Designing, document and configure the Informatica MDM Hub to support loading, cleansing, matching, merging, and publication of MDM data.
• Used Metadata manager (Repository Manager) for validating, promoting, importing and exporting repositories from development and checkout on clearcase for migration to SIT environment.
• Worked on performance tuning for MAST BD-4 interface.
• Created different Query Groups for Security IDD and Data Distribution.
• Created Display and PUT enabled packages for IDD.
• Configure Subject Area and Subject Area Groups for Security IDD.
• Involved with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Worked on SIF calls and MDM workflow manager.
• Created Java User Exists and Java Cleanse Functions.
• Created Custom Stored Procedure for Super Group ID for STCMS - REMIC interface.
• Created Batch Groups for different interfaces like STCMS & SIR - BD4.
• Created MDM Release Notes and Application Release notes for the Migration.
• Documented the issues and actions taken related to data cleansing using cleanse lists and predefined cleanse functions..
• Worked on GoldenGate replication ( testing ) using Data Manager . Data is vended out from GoldenGate to external vendors. MDM Mastered Data is replicated onto Data Store using GoldenGate Replication,.Tested the entire Data Flow to make sure that data is replicated correctly and successfully vended out to external applications which need to consume Mastered Data from MDM.
• Worked on shell scripts for Autopsy’s batch scheduling jobs.
• Profiled the data using Informatica Analyst tool to analyze source data (Departments, party and address) coming from Legacy systems and performed Data Quality Audit.
• Integrated DQ cleanse functions into MDM hub.
• Created On-demand and Ad-hoc data profiling ( column level ) and created DQ rules in Informatica Developer tool executing through powercenter workflow.
• Created mappings using Informatica Powercenter and loading data into prelanding tables.
• Created mappings using different transformations like Source Qualifier, Sequence Gen, Java, Sorter, Joiner, Expression, Lookup, Aggregate, Filter, Router, Update Strategy and etc.
• Created sessions and workflows to execute the sessions.
• Created Unit Test Case Document, Detailed Design Document, Supplementary Document and Knowledge Transfer Document.
• Good Knowledge on Informatica MDM 10.1 and Active VOS

Environment: Informatica MDM Hub 9.5.1/9.7.1, Informatica Data Directory (IDD), Informatica Powercenter 9.5.1, Informatica Analyst 9.5.1, Eclipse, TortoiseSVN, JBoss, Oracle 11g, Unix, Toad, ClearCase, Doors, Remedy.

LEAD INFORMATICA POWERCENTER / DATA QUALITY & MDM CONSULTANT

Responsibilities:

• Good Exposure on ICDW default and customer architecture.
• Designed ETL processes using Informatica to load data from Oracle, Flat Files, Excel files to Teradata database
• Created Reusable Transformations and Mapplets and used them in various Mappings to reduce the redundant work.
• Created mappings using different types of transformations for CE (ICDW) Data mart.
• Created mappings using change data capture ( CDC ) patterns.
• Created mappings using Push Down Optimization.
• Redesigned some of the existing mappings in the system to meet new functionality.
• Did error handling and performance tuning in Teradata queries and utilities.
• Worked on onsite-offshore model to coordinate offshore teams.
• Created Audit scripts ( schd job, sess parm ) in Error Audit table.
• Worked on ICDW Production support L2 / L3 member.
• Worked on Unit testing & Regression testing for ETL.
• Created Control - M Jobs for all Workflows.
• Worked with Data Governance team.
• Created Profiling for tables and flat files using Informatica Developer and Informatica Analyst tools.
• Created custom objects for selected columns for Database tables.
• Created Profile Models and Primary Key profiles using Informatica Developer tool.
• Created Data Quality Rules using different transformation and Mapplets in Developer tool.
• Worked with Labeler transformations for Data masking.
• Experience on working with Match & Address validation transformations.
• Worked on migrating Mapplets into Informatica PowerCenter mappings to load target data.
• Experience on data analysis.
• Giving demo’s to business users on Profiling results.
• Worked with Cognos tool for Profiling results reporting.
• Good knowledge on ICDW & MDM design and architecture.
• Worked with Informatica Metadata Manager tool to load Teradata Resource and ETL Resource and proving Metadata information to Ab Initio team.
• Worked with Data Lineage on Informatica Metadata Manager.
• As an MDM Developer, responsible for the developing, enhancing and supporting the Informatica MDM platform and related data integration applications.
• Worked with data stewards and business analysts to design, develop, and configure business rules for data standardization, match and merge.
• Designed and developed the mappings for bringing the data from different sources like Flat files and Relational tables into MDM Hub i.e. landing tables.
• Implemented Informatica MDM new source workflow, including data profiling, configuration specification and coding, match rules tuning.
• Developed Data Mappings from Landing, staging and to Base Objects, and then applied Match and Merge processes to identify the Golden record.
• Developed and involved in creating Subject areas, Groups, cleanse functions and workflows using IDD.

Environment: Informatica PowerCenter 9.1.0, Informatica Developer 9.1.0, Informatica Analyst, Informatica Metadata Manager, MDM 9.1, Teradata SQL Assistant 13.0, DB2, Toad 9.5, SQLDeveloper, UNIX, Control-M, Cognos, Ab-Initio Metadata Hub

LEAD INFORMATICA POWERCENTER / DATA QUALITY CONSULTANT

Responsibilities:

• Involved in the overall design of EPAD (SFCP)
• Designed the ETL processes using Informatica to load data from Oracle, Flat Files to target database.
• Implement ETL Processes using Informatica tools: Source Analyzer, Target Designer, Transformation Developer, Mapping Designer, Mapplet Designer and Workflow Manager
• Performed data manipulations using various Informatica Transformations like Source Qualifier, Sequence Gen, Java, Sorter, Joiner, Expression, Lookup, Aggregate, Filter, Router, Update Strategy and etc.
• Created Reusable Transformations and Mapplets and used them in various Mappings to reduce the redundant work.
• Created Mappings for Dimensions and Facts.
• Created sessions and workflow for designed mappings.
• Extensive performance tuning was done by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Redesigned some of the existing mappings in the system to meet new functionality.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions and scheduling them to run at specified time with required frequency.
• Developed pre-session and post session scripts using UNIX.
• Involved in preparation of Specs for the mappings.
• Involved in designing test cases for the sessions.
• Developed Breach and Exposure reports.
• Worked on Migration from DEV to TEST & TEST to PROD Repository.
• Created column profiles and rule based profiles.
• Good experience Informatica admin console.
• Worked on rule based Mapplets using Informatica Developer and integrating Informatica PowerCenter mappings.
• Worked on parser, labeler, comparison, standardizer, match transformations.
• Created scorecards using Informatica Data Explorer.
• Giving demos to the business users.
• Worked on data analysis, profiling results.
• Created ETL Documentation for end users.

Environment: Informatica PowerCenter 9.0.1, Informatica Developer 8.6.1, IDE, Oracle 10g, Toad 9.5, UNIX, AutoSys, SQL, PL/SQL, Business Objects XI R3

SR. INFORMATICA DEVELOPER

Responsibilities:

• Worked with systems analysts to understand source system data to develop accurate ETL programs.
• Experience on data analysis (field validation) for source, staging & DW.
• Developed INFA mappings, sessions, workflows in line with industry best practices and standards.
• Data Integration from disparate source systems like Sap R/3 (MM & SD), AS400 mainframes, FTP, COBOL, DB2, Xml, MS SQL Server, flat files (fixed width, delimited) into a staging area with Data Cleansing.
• Worked on SAP Data Integration (SAP source data) pulling data from SAP source system and loading into staging area for Reference and Transacton tables. (Full Load & Incremental Load)
• Created mappings for SAP source data using Application Source Qualifier in Infa v8.6.1
• Using Informatica PowerExchange v8 for SAP Data Integration.
• Extensive experience on handling Cobol Sources in PowerCenter.(This includes creating VSAM Source definition by importing Cobol copy books into PowerCenter and then use normalizer as source qualifier to read the Cobol file associated to the copy book/layout imported and load the target as defined by the business).
• Developed load control table based technique to incrementally load data from EDW into the data mart.
• Designed and developed a number of complex INFA PowerCenter mappings using various transformations like Source qualifier, VSAM, Lookup, Expressions, Update Strategy, Router, Filter, Sequence Generator, Aggregator, Joiner, Union, App Multi-Group Source Qualifier, Application Source qualifier, Xml source qualifier.
• Created EDW dimension table load programs as Slowly Changing Dimensions (SCD) with Type II logic.
• Extensively worked in data Extraction, Transformation and loading from source to target system using Bteq, FastLoad, and MultiLoad.
• Involved in writing scripts for loading data to target Data Warehouse for Bteq, FastLoad, and MultiLoad.
• Did error handling and performance tuning in Teradata queries and utilities.
• Did data reconciliation in various source system and in Teradata
• Implemented code re-usability by creating re-usable transformations.
• Implemented the Change Data Capture extensively to send only the delta records to the target systems.
• Loading facts and dimensions from source to target data mart
• Resolved memory related bottleneck issues like DTM buffer size, cache size to optimize workflow/session runs.
• Performance tuning through SQL tuning, indexes and INFA mapping and session level .
• Documented all ETL related work per company's methodology.
• Worked on UNIX shell scripts.

Environment: Informatica PowerCenter 8.6.1, Informatica Powerexchange 8, UNIX, Oracle 10g, Teradata V2R6, Toad 9.5, Power Exchange 8, Microsoft .Net, Brio.

SR. INFORMATICA DEVELOPER

Responsibilities:

• Involved in design and development of Business Requirements in liaison to business users and Technical teams by gathering requirement specification documents and identifying data sources and targets
• Analyzed application requirements and provided recommended design and Studied the current system to understand the existing data structures
• Participated actively in user meetings and collected requirements from users
• Used Informatica PowerCenter 8.1 for extraction, transformation and loading (ETL) of data in the Data Warehouse and used velocity methodology
• Designed, developed and documented several mappings to extract the data from Flat files and Relational sources
• Performed ETL into ORACLE Data Warehouse using Informatica Mappings including transformations Aggregator, Joiner, Lookup (Connected & Unconnected), Filter, Update Strategy, Stored Procedure, Router, Expression, SQL and Sorter
• Involved in design and development of ad-hoc data load or business critical code enhancement
• Worked on stored procedures, functions, and views.
• Developed data Mappings between source systems and warehouse components
• Created workflows and tested mappings and workflows in development, test and Production environment.
• Developed re-usable transformations, mappings and Mapplets confirming to the business rules. Used Debugger to test the mappings and fix the bugs.
• Actively involved in Performance improvements of Mapping and Sessions and fine-tuned all transformations
• Performed Informatica code Migration from Development/ QA/ Production and fixed and solved mapping and workflow problems
• Developed and maintained optimized SQL queries in the Data Warehouse

Environment: Informatica 8.1.1, UNIX Scripting, Toad, Oracle 11g, SQL, PL/SQL, Business Objects XI, Data Analyzer

PRODUCTION SUPPORT

Responsibilities:

• Studied the existing environment and accumulating the requirements by querying the Clients on various aspects.
• Collecting new requirements from client.
• Meeting with user groups to analyze requirements, proposed changes in design and specifications by the reports development group
• Developed and implemented various enhancements to the application in the form of production and new production rollouts.
• Used Repository Manager to create user groups and users, and managed users by setting up their privileges.
• Extensively used ETL to load data using PowerCenter from source system into staging tables and to load the data into the target database.
• Worked on PowerCenter Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Created PL/SQL Scripts and Stored Procedures for data transformation on the Data Warehouse.
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels.
• Creating / Updating and Running / scheduling Batches and Sessions.
• Developed PL/SQL stored procedures for pre and post session commands.
• Analyzing specifications for various applications enhancements for compatibility within the system.
• Designed and developed UNIX shell scripts.
• Tuned performance of Informatica session for large volumes of data by increasing data cache size and target based commit interval.

Environment: Informatica PowerCenter 7.1.3, UNIX Scripting, Oracle10g, PL/SQL, DB2, AutoSys, Hyperion Essbase 9

ETL DEVELOPER

Responsibilities:

• Participated in business meetings and Involved in design and development and identifying data sources and targets
• Most of the transformations were used like the Source qualifier, Aggregators, Expression, Connected & unconnected lookups, Router, Update Strategy, Filter & Sequence generator, and Sorter.
• Create stored procedure Transformations ( Unconnected ) to call database Stored Procedures/functions from Informatica mappings
• Created Reusable Transformations and Mapplets and used them in various Mappings to reduce the redundant work.
• Optimizing SQL Queries, trouble shooting and tuning the Informatica mapping for performance.
• Created views, functions & stored procedures.
• Used Debugger and set the break points to test sample Data
• Involved in the Upgrade project from Informatica 5.1.1 to Informatica 6.2 in all phases of Development, Test and Production.
• Extensively worked in the performance tuning of the mappings & sessions.
• Extensively used Business Objects Supervisor for creating repository, creating and managing the universes, creating categories, creating and managing the users, giving access permissions for Business Objects Reports.
• Creating canned and ad hoc reports through Business Objects Reporter.

Environment: Informatica 6.2/ 5.1.1, Windows, SQL Server 2005, Business objects 5.1