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, Market, Irvine CA

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, Bowling Green, KY

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

Confidential, Malvern, PA, USA

Oracle MDM Architect

Responsibilities:

• Involved in implementing Oracle MDM system and defined master data that connects to transactional system and Data warehouse.
• Converted Data from different legacy systems with respect to the organization's business rules into the Oracle Application system.
• Led fresh implementation of Oracle Product Information Management Data Hub (PIM) and Customer Data Hub (CDH)
• Designed and configured item masters including Oracle Inventory and Oracle PIM and Oracle Product Data Quality (PDQ) modules.
• Wrote MD50 functional specifications for custom extensions of Oracle PIM, including fully automated item inbound process for daily item creation and update from multiple external data sources, item outbound process to publish new and updated items to subscribers, new item request (NIR) and update approval workflows.
• Designed integration solutions between Oracle Site Hub, Oracle HRMS and Oracle Customer Data Hub.

Environment: Oracle MDM, Oracle PIM, Oracle PDH, Oracle 11g, SQL, PL/SQL, MS Excel (VBA), UNIX Shell Scripting

Confidential, Foster City, CA, USA

MDM/EDQ Architect

Responsibilities:

• Designed & Developed a Clustering Algorithm to cluster / group similar records for purpose of Matching & Merging.
• Developed Rules for Exact Match & Partial Match Records. Partial Match Rules involved Fuzzy Matching of Records.
• Designed & Developed EDQ scripts for reading the records from Database and output Merged Records for Exact Match Related Parties (RPs) and Partial Matched Records in separate groups, to be sent for review.

Environment: Oracle EDQ, Fuzzy / Advanced Matching Rules, Oracle 11g, SQL, PL/SQL, MS Excel (VBA), UNIX Shell Scripting

Confidential, Atlanta, GA, USA

ETL/ MDM Developer

Responsibilities:

• Analyzing, designing and developing ETL strategies and processes, writing ETL specifications, Informatica development, and administration and mentoring other team members.
• Developed mapping parameters and variables to support SQL override.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, and SQL, Lookup (File and Database) to develop robust mappings in the Informatica Designer.
• Involved in gathering business requirements, logical modeling, physical database design, data sourcing and data transformation, data loading, SQL and performance tuning.
• Defining the schema, staging tables, and landing zone tables, configuring base objects, foreign-key relationships, complex joins, and building efficient views.
• Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer, Workflow Manager, Workflow Monitor.
• Worked on Slowly Changing Dimensions - Type 1, Type 2 and Type 3 in different mappings as per the requirements.
• Good exposure in Informatica MDM where data Cleansing, De-duping and Address correction were performed
• Using various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.

Confidential, Foster City, CA, USA

MDM Developer

Responsibilities:

• Responsible for Analysis, Design, Installation, Development, Deployment of master data solution of key data domains
• Participated in the requirements gathering sessions along with business and technical stake holders
• Responsible for MDM Hub development including Data Profiling, Data modeling & Data Mappings (Landing, staging and Base Objects), data validation, match and merge rules, queries and packages
• Configured entity objects, entity types, hierarchies, relationship base objects, relationship types, and profiles in the Hierarchy Manager.
• Configured Informatica Data Director (IDD) subject area groups, child subject areas, workflows, validation and deployment, among other tasks
• Used Informatica Data Quality (IDQ) profiler and developer tool to analyze source system data and discover underlying issues
• Configured address doctor tool to be used as part of the MDM solution for validating customer and vendor addresses
• Worked with Java developers in setting up SIF for real-time integration with MDM Hub
• Worked with ETL developers in integrating MDM Hub with source and target systems
• Worked on Informatica Power Center tools - Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Assisted in testing of the MDM solution including unit, integration, regression testing
• Migrated the MDM code using repository manager to different environments, administered MDM and IDD users

Confidential, Weight Watchers, Cummins,

Sr. Analyst

Responsibilities:

• Building views, synonyms on Oracle and SQL database.
• Building different reports with Charts and drill through, Prompts.
• Maintaining existing system like Inventory Management, NCR, E-Commerce, Call Center, Payment Analysis, Financial Reporting.
• Generating reports using Query, Join, Union, Intersect, Except, for pulling data from different tables those are not part of the model for generating some exception reports.
• Also involved in publishing package, bursting reports, granting permission to different groups, scheduling jobs.
• Worked on building Views and writing stored procedures as per the requirements.
• Optimizing the Framework Manger model and reports

Confidential, Nashua, NH

Business Analyst

Responsibilities:

• Gathering & defining business requirements while managing the risks to improve business processes and translating the requirements into systems solution by preparing functional specifications.
• Coordinating with business partners, executives and other client personnel to define engagement along with project development and resource estimates.

Confidential

Business Analyst

Responsibilities:

• Business analyst for all phases of the Software Development Lifecycle for two new commercial programs plus other implementations for changes to existing products.
• Responsible for gathering and verifying requirements, creating validity test cases and final implementation
• Lead analyst for bureau and state reporting specifications and standards; Responsible for ISO specifications
• Worked as business requirements implementation analyst for regional business analysts by verifying and coordinating modifications and other system changes.
• Lead test analyst of product performance and downstream report development.
• Met regularly with senior management to report on product development to ensure on time delivery