SUMMARY

• Around 13 years of IT experience in Development and Implementation of EIM services using Informatica Master Data Management, Oracle MDM, Informatica Power center, Data Quality in various organizations.
• Expertise in all phases of Systems Development Life Cycle from analysis, requirement gathering, planning to development and deployment.
• Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Experienced in Installing, Managing and configuring Informatica MDM core component such as Hub Server, Hub Store, Hub Cleanse, Hub Console, Cleanse Adapters, Hub Resource Kit.
• Strong understanding in Product life cycle, Data governance, Data quality, Data security for products across the enterprise from many disparate systems
• Experience in defining and configuring landing tables, staging tables, base objects, lookups, query groups, queries/custom queries, packages, hierarchies and foreign - key relationships.
• Designed & developed multiple cleanse function, Graph function and standardization scenarios using Address Doctor.
• Experience in data quality tools (Oracle EDQ and EDQP) integrating with Oracle MDM applications.
• Configured JMS Message Queue in the MDM hub Console.
• Configured Soap based SIF API calls by using Soap UI for performing multiple tasks in Informatica MDM Hub.
• Experience in configuring Entity Base Objects, Entity Types, Relationship Base Objects, Relationship Types, Profiles using Hierarchy tool.

TECHNICAL SKILLS

EIM tools: Informatica MDM Multi Domain Edition 10.4, 10.0, 9.7.1, 9.5, 9.1. Informatica Data Director (IDD) 10.0, 9.7, 9.5. Oracle MDM, Informatica Data Quality (IDQ) 10.0, 9.6, DDM 9.6

ETL tools: Informatica Power Centre 8.X, 9. X.

Cleanse Adapters: Address Doctor, Trillium

Databases: Oracle 10g/11g, My SQL 5.0/4.1, SQL Server 2008, MS Access

Editors: SQL Navigator, Toad

Data Modeling: ERWIN 4.0, MS Visio

Programming Skills: SQL, PL/SQL, C, C++, UNIX Script, Java

Application Servers: Web Logic 10.x/9.x, JBoss

Environment: Windows OS, UNIX, Windows SERVER 2003/08

BI Reporting Tools: MS Excel 2010, SSIS, SSRS.

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Informatica MDM Architect

Responsibilities:

• Worked with ETL Developers in creating External Batches to execute mappings, Mapplets using Informatica workflow designer to integrate Shire’s data from varied sources like Oracle, DB2, flat files and SQL databases and loaded into landing tables of Informatica MDM Hub.
• Designed and created BO, staging tables, mappings, transformations as per business requirements.
• Created and documented detailed level ETL SSIS framework standards and a template package to help developers understand ETL development strategies.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources like Teradata,DB2,PostgreSQL,SQL Server and external Flat files.
• Created mappings to perform the tasks such as cleansing the data and populate that into staging tables.
• Used Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment.
• Involved with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Identified Golden Record (BVT) for Customer Data by analyzing the data and duplicate records coming from different source systems.
• Helped the testing team for data integrity and consistency.
• Defined and configured schema, staging tables, and landing tables, base objects foreign-key Relationships, look up systems and tables, packages, query groups and queries/custom queries.
• Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records
• Used Hierarchies tool, for configuring entity base objects, entity types, relationship base objects, relationship types, profiles, put and display packages and used the entity types as subject areas in IDD.
• Designed data governance policy and procedures
• Configured Informatica Data Director (IDD) for data governance to be used by the business users, IT Managers and Data Stewards and also implemented IDD using hierarchy configuration and created subject area groups, subject areas, subject area child, IDD display packages in hub and search queries for searching the data.
• Closely worked with other IT team members business partners data stewards stakeholders steering committee members and executive sponsors for all MDM and data governance related activities.
• Deployed new MDM Hub for portals in conjunction with user interface on IDD application.
• Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.
• Configured match rule set property by enabling search by rules in MDM according to Business Rules.
• Created mappings using Informatica Power center and loading data into pre-landing tables.
• Successfully implemented IDD using hierarchy configuration and created subject area groups, subject areas, subject area child, IDD display packages in hub and search queries.

Environment: Informatica MDM, Informatica Power Center 9.6, Oracle 11g/10g, Toad, JBoss 5.1.0, Address Doctor 5, IDD, Informatica Data Quality IDQ 9.5.1, Windows server, Unix.

Confidential

Informatica MDM Architect

Responsibilities:

• Installed and Configured Informatica MDM 10.1 hub on Jboss application server
• Worked as an Informatica MDM Architect to install and configure Informatica and MDM suits
• Establish POC of new ideas
• Evaluate Proof of Technology(POT) for new architecture and tools
• Used SSIS to create Dynamic ETL Packages to validate, extract, transform and load data from different data sources online transaction Processing OLTP databases, Flat Files, CSV, Excel source files, XML files etc to data warehouse databases and involved in Data cleansing in the data transfer.
• Created tables using SSIS to load error data, error descriptions and package execution diagnostics.
• Developed SSIS Templates which can be used to develop SSIS Packages in such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Interacted with the Business Users & Enterprise Data Architects in the analysis & design of conceptual and logical data model that is required for solid MDM implementation & ensuring that it meets the business requirements and also supports the products capabilities.
• Involved in all phases of the project SDLC planning, design, documentation, configuration, testing activities and code migration.
• Configured Base Object Tables in schema and relationship tables in hierarchies according to data-model
• Creating Landing, Staging and Base Tables and defining Foreign Key relationships, Lookups in the Hub
• Developing the Mappings to move the data loaded from Landing to Stage by using various cleanse and address doctor functions.
• Developed the Match paths, Match Columns and Match rules (Exact and Fuzzy) in the Match and Merge Process
• Working with Hierarchy Manager to develop to Hierarchies as per the business needs.
• Creating IDD application as per the business needs by creating the subject area and subject area groups.
• Defined and tracked Data Quality and Data Governance metrics
• Configured Informatica Data Director (IDD) in reference to the Data Governance of users, IT Managers & Data Stewards.
• Configured IDD application for Party Communication, Party to Party Rel and Master Guarantee Agreement Subject Area required for data governance used by the Data Services Team.
• Responsible for setting up the Data Governance including Data Standards, Data Cleansing rules, etc in the Address Doctor
• Developing Put and Display packages for both Hierarchy Manager and IDD Application.
• Defining the Match and Merge Rules in the MDM 10 Hub by creating Path components, Columns and rules.
• Configured the Automation process for Land, Stage and Load Process (Batch Process)
• Executed MDM stored procedures and batch groups for MDM hub.
• Integration of MDM Hub with external applications using SIF APIs.

Environment: Informatica Platform 10.1,10.0,9.6,9.5.1,Oracle 12G,SQL Server Management studio, SQL Plus, Windows XP and AIX UNIX, Agile Methodology, HP Quality Center, MS Sql Server, SAP Version: 3.1.H, Flat Files, PL/SQL and Unix Scripting.

Confidential

Informatica MDM Developer

Responsibilities:

• Designed, Installed, Configured core Informatica MDM Hub components such as Informatica MDM Hub Console, Hub Server, Hub Store, Cleanse Adapter, Cleanse Match Server & Data Modeling.
• Designed the Data Model, Staging Tables and Landing Table,.
• Configured Trust and Validation rules and match rules & enable Auto Match.
• Created Queries & Packages to view the data in IDD, Data Manager or Merge Manager.
• Configured batch jobs using batch group utility.
• Created the Mater Data Management (MDM) Hub Console configurations like Stage Process configuration, Load Process Configuration.
• Match path, Match rules and Match columns and tuning of Match Rules.
• Created cleansing functions for effective consistent master data records.
• Implemented cleansing functions such as pre defined functions (STRING Functions, Logic Functions, Math Functions, and Data Conversion Functions).
• Developed Informatica Data Director (IDD) applications and queries used for Data Steward Analysis.
• Responsible for multi-domain MDM implementation, Data Governance program organization and management.
• Initiated the Data Governance processes. Assisted the DataStewards team for the data validation. Customized the Data Stewareship User Interface DSUI for the custom searches developed.
• Configured and customized Subject Area Groups and Subject Areas in IDD, as well as screens and lookups, to meet the data governance objectives.
• Defined a new a governance processes and practices for Enterprise data management, modeling and deployment in Agile development environment.
• Worked on all the components of Data Governance such as Data Definitions, rules, data stewardship, Goals, Governance Metrics, etc
• Lookup tables were configured in the IDD applications.
• Created Queries and performed the Manual match and Merge operations in IDD.
• SIF API was created to access Master Data Management (MDM) Hub from External Application.
• Handled Master Data and Transactional Data, and did the reporting of transactional data which is required by the Business Decision Support People.

Environment: Informatica MDM 9.6, IDD, SoapUI, Oracle 11g.

Confidential, Columbus, OH

Informatica MDM Developer

Responsibilities:

• Coordinated with Business Users for requirement gathering, business analysis to understand the business requirement and to prepare Technical Specification documents (TSD) to Data Model for new requirements.
• Configured and installed Informatica MDM Hub server, cleanse, resource kit, and Address Doctor.
• Handled Mater Data Management (MDM) Hub Console configurations like Load Process Configuration, Stage Process configuration, Hierarchy Manager Configuration.
• Involved with ETL developers for developing Mapplets, mappings, reusable transformations using Informatica designer to integrate data from different sources and load the data into target.
• Match path, Match rules and Match columns and tuning of Match Rules.
• Analyzed the background tables for the Data analysis purpose. Tables included Stage tables (RAW table, REJ Table, PRL table), XREF table, MTCH Table, HIS table, STRP table.
• Created cleansing functions for effective result set of mapping results.
• Implemented cleanse list functions and pre-defined functions.
• Created reusable cleanse components using Graph Function, Regular Expression function, cleanse list.
• Performed Match and Merge operations by creating Applications in the IDD.
• Assigned workflows to business users and managers to review the task.

Environment: Informatica MDM 9.5, IDD, Teradata, SoapUI, Oracle 11g