RELEVANT EXPERIENCE:

• 13+ 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 /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.
• Team player, self-starter with excellent communication and interpersonal skills.

SKILLS SUMMARY:

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.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 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/stash/jira

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

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

PROFESSIONAL EXPERIENCE:

SR MDM CONSULTANT / DATAQUALITY

Confidential, Rochester, NY

Responsibilities:

• 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.
• 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, Informatica Power Center 9.5.1,IDD,Oracle 11.2, windows, Weblogic, Address Doctor, SQL Developer,Java,SOAP,Stash,Jira,Service now.

SR MDM CONSULTANT / DATA QUALITY (IDQ) /

Confidential, Mylan, Canons burgh, PA

Responsibilities:

• 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 Confidential 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 Developer.

SR MDM CONSULTANT / DATA QUALITY

Confidential, Fannie Mae, Herndon, VA

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 (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 Confidential workflow.
• Created mappings using Informatica Confidential 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 Confidential 9.5.1, Informatica Analyst 9.5.1, Eclipse, TortoiseSVN, JBoss, Oracle 11g, Unix, Toad, ClearCase, Doors, Remedy.

LEAD INFORMATICA / DATA QUALITY 

Confidential, Columbus, OH

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 (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 Confidential 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 Confidential 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 / DATA QUALITY 

Confidential, New York, NY

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 Confidential 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 Confidential 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, Los Angeles, CA

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 Confidential 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

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 Confidential from source system into staging tables and to load the data into the target database.
• Worked on Confidential 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 Confidential 7.1.3, UNIX Scripting, Oracle10g, PL/SQL, DB2, AutoSys, Hyperion Essbase 9