SUMMARY

• Overall 5 years of experience in software development, maintenance, testing and troubleshooting on Master Data Management (MDM), data quality, data integration and Oracle database environment in various Verticals such as Pharmaceutical, Health Care Insurance, Retail and Banking industries.
• Experience in Mater Data Management (MDM) Multi Domain Edition HUB Console Configurations, Informatica Data Director (IDD) Application creations.
• Extensive experience in Master Data Management (MDM) HUB Console Configurations such as Staging Process Configurations, Landing Process Configurations, Match and Merge Process, Cleansing Functions, User Exits.
• Experience in creating queries, packages, custom cleansing functions and reusable functions
• Implemented MDM configurations for Party, Vendor, Product and Customer.
• Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star - schema, Snowflake schema using fact and dimension tables and relational databases.
• Experience in installation and configuration of MDM Hub Console.
• Exposure in configuration of Hub Store, Hub Server, Cleanse Match Server and Cleanse Adapter.
• Participated in requirement gathering and preparation of High level and Low - level Designs Throughout the Software Development Life Cycle
• Experience working with ORACLE, SQL Server, My SQL databases & writing complex queries.
• Experience in development, configuration and management of Informatica objects and working on design reviews and code reviews.
• Extensive ETL experience using Informatica Power center client tools (Designer, workflow manager, workflow monitor and server manager).
• Worked in Data Warehouse and Business Intelligence Projects along with the team of Informatica, Talend (ETL).
• Experience in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries and packages.
• Experience in configuring Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation.
• Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarchy management.
• Working knowledge of data warehouse techniques and practices, experience including ETL processes, dimensional modeling.
• Experienced in Data Integration from multiple sources like Relational tables, flat files, MS Excel & XML files.
• Experience in integrating external application with Informatica MDM hub using message queries as a significant advantage.
• Excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and as part of a team
• Involved in Unit testing, System testing to check whether the data loads into target are accurate.
• Experience in support and knowledge transfer to the production team.
• Extensive functional and technical exposure. Experience working on high-visibility projects.
• Assign work and provide technical oversight to onshore and offshore developers.

TECHNICAL SKILLS

MDM Tool: Mata Data Management Multi Domain Edition 10.1, Informatica Data Director (IDD), Stibo Systems, STEP Tools, STEP Trailblazer 8.3

EIM Tools: Informatica MDM Multi-Domain, IDD, STEP

Design/Application Tools: Star-Schema Modeling, Snowflakes Modeling, Fact and dimension tables, Erwin, Toad, SQL Navigator, Clear case, Control-M, Maestro, Microsoft Visio. STEP Trailblazer 8.3

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, Fact and Dimension tables, Pivot Tables, Erwin

Business Intelligence Tools: SQL Server Management Studio, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, Tableau.

ETL Tools: SQL Server Integration Services

Operating Systems: Windows 2008, 2000, XP, 2010

Databases: Oracle10g, Oracle 11g, SQL Server 2012, MS Access 2007, Putty, Win SCP

Microsoft Office: MS. word, MS. Excel, MS. PowerPoint, MS. Access, MS. Outlook

PROFESSIONAL EXPERIENCE

Senior MDM Developer

Confidential

Responsibilities:

• Design and Implementation of Product Information Management, Understanding Product and Customer MDM Architecture and metadata Management to fulfill all the Business Requirements.
• Experience with more than one full cycle implementation of Stibo STEP PIM in aspects such as leadership, responsibilities, processes, controls and rules.
• Configured PIM Modules such as Attributes, Attribute Groups, List of Values (LOV’s), Hierarchies, Classifications, Keys, Business Action and Conditions, Collections, Object Types and Structures.
• Experience in implementing various Outbound and Inbound Integration Endpoints, Import and Export Configurations with various rules to export and import the data as per the requirement.
• Experience in working with XML’s, J2EE framework and WEB technologies (JavaScript, HTML, XML, CSS development tools) to create different modules in WEB UI Portals.
• Working with Integrations such as ESKO and S4 to make implementation changes, CR Changes based on the requirement from business in order to send the data to the third parties such as salesforce, Cloud Craze and various International Product Catalogs.
• Experience in developing high level Components such as Hierarchies and Classifications in PIM/MDM.
• Working with teams such as Marketing, Engineering, Packaging by Configuring EXPORT Configurations, adding attributes, mapping them to the target values in order to export the data in a template.
• Implemented different Business Actions and Conditions (Business Rules) using JAVA Scripting which helped the Integrations and Configurations to export and submit the data to the End Client.
• Experienced as a Technical Lead in various Production Deployments, Migrating changes from Quality to Production.
• Configured Asset Push Configuration by developing various EVEBNT QUEUES to push the Assets, Artwork, PDF’s to the Product catalogs.
• Experience in implementing the complete STIBO MDM/PIM Servers using FILEZILLA which includes the path setup, folder setup and access privileges to all the folders.
• Implementing AVANOS WEB UI PORTALS which includes the PIM Portal (Product Information Management), Read Only PIM Portal (For External Users), AAL Portal (AVANOS ASSET LIBRARY), Read Only AAL Portal, Vendor Portal.
• Configured USERS, VENDORS, SUPPLIERS, USER GROUPS such as Super Users, STEP PROD PIM, STEP PROD Read Only, STIBO USERS etc.
• Configured various rules to validate data, assign tasks, move tasks through workflows, integrate workflows with other processes such as import/export configurations.
• Configured CLOUZ CRAZE Export Configurations to send Product Information data in the form of XML’s to Salesforce.
• Designed and Implemented SMARTSHEETS using Publications and in STIBO STEP MDM for Product Information Management in the STEP WORKBENCH.
• Experience in working with the REEDTECH Single source to upload, link and publish item (Products) to GDSN.
• Scheduled various Daily Report Configurations.
• Experience in processing BULK UPDATES with various Business Rules.
• Experience in working with database tools such as ORACLE, SQL Servers, Toad etc.
• Implemented detailed design documentation of AVANOS PIM/MDM, Defined technical specifications for workflows, Documented data migration process.
• Experience in training and mentoring USERS in STEP implementation activities and best practices, Support Integration system and user acceptance testing.
• Experience in working with STIBO to find the root cause of the issues using JIRA Application (ZERO PORTAL) by logging in tickets.
• Included in Business talk with the Business management and superiors with regards to Production Maintenance.
• Worked with TOOLBOX 9 which is a third-party vendor tool responsible for hosting PIM SKU Product Catalog Website.
• Lead requirement gathering workspaces and project team members through all activities required to successfully deliver STEP solution using best practices.
• Working close with the Project manager and Program delivery teams to develop solutions to problems. Estimate work for completion and identify dependencies.

Environment: s: Stibo STEP 9.0, STEP WEB UI (PIM, AAL, DAL, Vendor Portals), Workbench (DEV, TST, PROD), FILEZILLA, Toad, SQL Servers, ORACLE, REEDTECH.

Senior MDM Developer

Confidential

Responsibilities:

• Design and Implementation of Master Data Management Solutions to address Business needs. Rolling out Master Data Management for Supplier, Product, Location.
• Designing and configuring MDM WEB UI Workflows (create and maintenance workflow) preferably in retail domain.
• Designed the Data Model, Web UI, Workbench in all the Environments Development, Testing, Staging, Production.
• Developed attributes in WEB UI of the DEV Environment.
• Creating and Updating Suppliers through WEB UI and taking it to approval in both create and maintenance workflows.
• Generating the Reports through Excel Macros, Knowledge of Excel Macro Coding and mapping of attributes.
• Developing and reviewing configuration documentation and design documentations, well as analyzing functional specifications and user requirement documents.
• Created Mapplets and used them in complex mappings to maintain the reference data from different sources
• Creating Outbound Integration Endpoints in all the environments and invoking them to generate the reports.
• Working with workflows, creating supplier profile category, supplier maintenance profile category in DEV Workbench.
• Exporting Supplier data from workbench and generating the Full Reconciliation Reports through Unix Server.
• Designed, Installed, Configure core Stibo Master Data Management Hub Components such as WEB UI and Workbench, Oracle Test Manager, Enterprise Data Management
• Good Understanding of the attributes, Objects, Workflows, Integrations, List of values and Data Model.
• Handled Master Data and Transactional Data and did the reporting of transactional data which is required by the Business Decision Support People
• Experience in integration of various data sources like Oracle, XML, SQL server and MS access.
• Experience in DocuSign that provides electronic signature authentication which helps to send the templates to a bulk of suppliers at a time.
• Involved in Deployment Code Plan before GO Live, validating all the Integration Endpoints, DSR/Recon Reports by creating supplier and generating the reports through Excel Macros.
• Experienced in Starting/Stopping the Application Server for any of the code deployment and conversion plan through Unix Server.
• Creating supplier in the TEST Environment based on the scenarios given to test the defects.
• Knowledge of the Business Rules and understanding of the business rule codes.
• Help in mentoring team member on various aspects of project, software processes and methodology.
• Closely worked with the reporting team to ensure that correct data is presented in the reports.

Environment: Stibo STEP Trailblazer 8.3, STEP WEB UI and Workbench’s (DEV, TST, STG, PRD), OTM (Oracle Test Manager), Win SCP, Toad, Putty Configuration, Excel Macros, DocuSign, Enterprise Data Management, MS -Office.

Senior Informatica MDM Developer

Confidential

Responsibilities:

• Designed, Installed, Configured core Informatica Master Data Management (MDM) Hub components such as Informatica Master Data Management (MDM) Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter & Data Modeling.
• Designed the Data Model, Landing Table, & Staging Tables.
• 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 Master Data Management (MDM) Hub Console configurations like Stage Process configuration, Load Process Configuration.
• Implemented cleansing functions such as pre-defined functions (STRING Functions, Logic Functions, Math Functions, Data Conversion Functions) for effective consistent master data records.
• Developed Informatica Data Director (IDD) applications and queries used for Data Steward Analysis.
• Lookup tables were configured in the IDD applications.
• Handled Master Data and Transactional Data and did the reporting of transactional data which is required by the Business Decision Support People.
• Experience in installation and configuration of core Informatica MDM Hub components such as Hub Console, Hub Store, Hub Server, Cleanse Match Server and Cleanse Adapter in Windows.
• Good understanding in entity relationship and Data Models.
• Expertise in creating Mappings.
• Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDM Hub implementation.
• Experienced in all phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Experienced in working with business analysts to understand requirements and translating them into ETL code in Requirement Analysis phase.
• Involved in creating High Level Design and Detailed Design documents in the Design phase.
• Experience in integration of various data sources like Oracle, XML, SQL server and MS access and non-relational sources like flat files into staging area.

Environment: Informatica MDM 10.1, IDD, SQL Server, Oracle, MS Access.

Senior Informatica MDM Developer

Confidential, Nashville, TN

Responsibilities:

• Integrated Customer data from different sources e.g. (IMS, SFDC, NCPDP ETC...) to create a Customer Master Data to get best version of truth as golden record
• Successfully completed the Hub configuration phase for the deployment of project.
• Defined standard interfaces, Data Profile, metadata acquisition, data migration, validation, pre-landing processing and Reference Entities.
• Analyzed customer/product data residing in various source systems and defined these source systems in Hub.
• Defined foreign-key relationships, lookups, query groups and queries
• Designed & developed multiple cleansing and standardization scenarios using source to target mappings in IDQ to get the data cleansed and standardized.
• Developing and reviewing configuration documentation and design documentations, well as analyzing functional specifications and user requirement documents.
• Created Mapplets and used them in complex mappings to maintain the reference data from different sources.
• 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.
• Involved with Master Data Management (MDM) for Customer Data Integration using Siperian tool.
• Handled Mater Data Management (MDM) Hub Console configurations like Stage Process configuration, Load Process Configuration, Hierarchy Manager Configuration.
• Involved with ETL developers, for developing complex mappings, Mapplets, using Informatica 8.6 designer to integrate data from different sources like Oracle, Teradata, Flat files, and SQL databases by following guidelines and loaded data successfully into target.
• Created Match and Merge Setups like Match path, Match columns, and Match rules 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.
• Created queries and packages in the MDM (Master Data Management) HUB Console.
• Created Applications in the IDD (Informatica Data Director) and performed Match and Merge operations.
• Assigned workflows to business users and managers to review the task.

Environment: Informatica Multidomain MDM 9.7.1, IDD, SQL Server.