SUMMARY:

• 14 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 10.1/9.5.1/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 /10.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.

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: InformaticaPowerCenterV9.6.1, 9.5.1/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/9.5, Informatica Analyst 9.1/9.5.1/10.1 Informatica MDM Multi-Domain 9.1/ 9.5.1/9.7.1 /10.1, IDD, SIF

Application Server: Jboss,weblogic

Other Tools: AutoSys, Control - M, SQL*Plus, TOAD for Oracle, Toad for Db2, SQL*Loader, MS Visio 2000/stash/jira, version1,service desk, OEM, SOAP, Eclipse

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

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

PROFESSIONAL EXPERIENCE:

SR INFORMATICA ADMIN / CONSULTANT

Confidential, HANOVER, MD

• Working on Informatica Admin and support all the informatica applications like powercenter, Data Quality, Big Data Management, MDM, & Metadata Manager.
• Maintaining Servers, Nodes & Services for Informatica all tools.
• Worked on powercenter deployments.
• Worked on outage activities like password changes, patch installation, restarting services, license updates & network changes.
• Worked with networking teams regarding informatica Powercenter server moves from one place to another.
• Oncall support for entire application like working on MDM, DQ, Powercenter, Address Doctor, IDD,
• Userexit for MDM & IDD, salesforce workbench, application server ( weblogic ) .
• Working with integration people like Middleware team Tibco, sourcing team Salesforce & peoplesoft
• Worked on migrations for HUB & IDD
• Work on indepth code analysis like userexits issues, server issues, data issues.
• Worked Admin tasks like rebooting application server, migrations adding users, roles .
• Work on enchancement of user exits, mdm hub development like cleans functions.
• Match rules creations, batch groups, hierarchies .
• Working experience on Autosys & control m batch jobs.
• Can handle late night support calls.
• Worked on OEM ( oracle enterprise manager )
• Very good experience on Metadata Manage & Big Data Management
• Environment: MDM 10.1, Data quality, IDD, weblogic, Tibco, salesforce, Unix, Toad 11.5.1, SOAP, Eclipse,
• Powercenter, version1, service desk, xmatters, OEM.
• Worked on Address Doctor transformation and files.
• Worked on creating new mappings and DQ scorecards, mapplets using and applications deployment migrations in IDQ.
• Configure ActiveVOS setup in MDM and worked on userexist in IDD & MDM.
• Administration on weblogic for MDM like Messages, Active VOS, Hierarchies.
• Worked on BDM ( BigDataManagement ) setup, created new connections, created new mappings and tested successfully, migrations from different environments.

Environment: Informatica Powercenter 9.6.1, Data Quality (Developer & Analyst )9.6.1, MDM 10.1, Metadata Manager 10.1, BDM 10.1, Oracle 11.2, weblogic 12, version1, CAService Desk, Autosys, Unix, ActiveVOS,Eclipse, AddressDoctor5

SR INFORMATICA MDM CONSULTANT / DATAQUALITY(IDQ) / POWERCENTER

Confidential, Rochester, NY

• Involved in business requirement meetings with business for the source to target mappings.
• Created mapplets and mappings usng informatica developer tool for IDQ process
• Worked on HUB & IDD administration tasks like migrations from DEV to other environments & IDD configurations
• Worked on HUB related activities like Landing, Staging & BO tables, queries, packages, mappings & custom cleanse functions.
• Created mapplets in Informatica developer ( IDQ ) using webservices and importing into HUB cleanse functions.
• Worked on Hierarchies for SITE, ORG, ENTITY for customer master.
• Good experience on Customer MDM Architecture.
• Created publish queries for party, account, site, site use, location etc.
• Configured message triggered setup in HUB & weblogic.
• Worked on exact & fuzzy match rules for Address in customer master in HUB.
• Worked on security resources, roles and user and groups for accessing hub & idd data information.
• Worked metadata for hub migrations to dev to other environments.
• Worked on UserExit for Party, Account, Account Site, Site Use save handlers for idd.
• Worked on SIF calls for Hub related activites.
• Worked on Hierarchies entity objects for Party, Account, Account site, Hierarchie Nodes.
• Worked on message Queue, C Repos tables, Systems & Trust Score.
• Worked on Validation Rules setups, Trust scores.
• Worked on IDD config file like idd config xml, error bundle, message, metadata..
• Giving knowledge transfer to downstream teams like integration.
• Created batch groups for different countries like Asia pacific, Europe, USA etc.
• Worked on weblogic configurations and erors.
• Worked on Address Doctor using these mapplets for location base object for Address fields.
• Worked on ITEM project for diffierent activities like Hierarchies, HUB related activites & IDD. knowledge on core java.
• Working experience on scheduling tools like autosys, control-m.

Environment: Informatica MDM HUB 9.5.1/10.1, Informatica Developer 9.5.1/10.1, Informatica Power Center 9.5.1/10.1,IDD 10.1,Oracle 11.2, windows, Weblogic, Address Doctor, SQL Developer,Java,SOAP,Stash,Jira,Service now.

SR INFORMATICA MDM CONSULTANT / DATA QUALITY (IDQ) / POWERCENTER

Confidential, Canons burgh, PA

• Involved in business requirement meetings with business for the source to target mappings.
• Created mapplets and 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.
• Created new mappings using different types of cleanse functions in MDM HUB.
• Good experience in IDD, worked on save handlers using java code.
• Worked on MDM & IDD administration like migrations, support tickets.

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 Develo

SR INFORMATICA MDM CONSULTANT / DATA QUALITY (IDQ) / POWERCENTER

Confidential, Herndon, VA

• 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 (IDQ) 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, Remed

LEAD INFORMATICA POWERCENTER / DATA QUALITY (IDQ) & MDM CONSULTANT

Confidential, Columbus, OH

• 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 (IDQ) 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, SQL, Developer, UNIX, Control-M, Cognos, Ab-Initio Metadata Hub

LEAD INFORMATICA POWERCENTER / DATA QUALITY (IDQ) CONSULTANT

Confidential, New York, NY

• 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

Confidential, Irvine, CA

• Worked with systems analysts to understand source system data to develop accurate ETL programs.
• 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.
• 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

Confidential, Los Angeles, CA

• 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

Confidential, Warren, NJ

• 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