SUMMARY

• Motivated and result oriented professional with a 18+ years of experience in IT. Certified Salesforce Developerand expertise with Master Data Management using various MDM products from Informatica, SAP, Stibo, Microsoft (MDS). Extensive end to end exposure in product development and customer facing IT projects.
• Certified Salesforce Developer - Good knowledge of programming in Apex, Lightning, Integration, Visualforce etc
• Expertise in Master Data Management (MDM) - experience with major MDM products such as Informatica MDM, Stibo MDM, i2-MDM/ABPP, TIBCO-MDM, Microsoft-MDS,SAP-MDM
• Strong Experience in Technical Analysis, Architecture, Data Quality Analysis, Data Discovery, Business Process Analysis, Impact Analysis, Master Data Design, Data Governance Design, Creation of Reference Materials, Creation of Business Glossary, Data Quality Rules Implementation
• 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 JBoss, WebSphere
• Experience in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match & Merge rules, Batch Group creation, Address Doctor,user exits using Java, SIF API, REST
• Experience in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages, data loading process
• Experience in implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDM Hub implementation
• Good knowledge of PIM for CPG/Retail, Global Data Synchronization (GDSN)
• Good knowledge of J2EE, EJB, SOA and Web services, SAP-HANA
• Complete SDLC experience including functional, requirements gathering, design, development, testing, maintenance and support and development using Core Java, JFC/Swing, Jython, Python, and XML.

TECHNICAL SKILLS

Applications: Salesforce, Informatica-MDM, SAP-MDM

Programming: Apex, Lightning,J2EE, Struts, EJB, Hadoop, Hive, SOA, Web Services (SOAP, WSDL), XML, XSL

Scripting: Java Script/Jscript, Python, Jython, VBScript, Perl

Web/App Servers: Weblogic, WebSphere, Tomcat

GUI: Java Swing, HTML

OS: Windows XP/2k, Unix (HP, Solaris), AIX

Databases: Oracle, SQL Server, DB2, MySQL

Version Control: Clear case, CVS, MKSSI

Project Management: Microsoft Office, MS Project, MS Visio

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Informatica MDM Lead

Responsibilities:

• Act as SME for MDM (Customer/Party Master)
• Mentor team members on Informatica MDM
• Conduct gap analysis, create technical design, coding adhere to tech standards
• Update Party data model, mappings, Trust rules, match rules, cleanse functions etc using console
• Configure for various batch processes - stage, load, match-merge etc
• Build and modify the Informatica Data Director (IDD) interface per Business Users requirements
• Configure Business rules and workflows for process management/approvals
• Analyze and Maintain Reference data using ‘Load by Row ID’ for 40 different Lookup tables from two sources
• Code Migration & Data loading across different environments - DEV, QA & UAT
• Follow-up with vendor on product related issues and help resolve
• Identify & resolve data related issues at various stages of data integration - ETL,Landing, Staging, Loading
• Using SIF Survives to clean data, register indexes etc and Actives(AVOS) workflow configuration
• Development methodology: Agile(Kanban), daily standups, sprint planning and weekly Dev team meetings

Environment: Informatica-MDM v10.1, WebSphere, IDQ, Oracle, Power center

Confidential

Integration Lead

Responsibilities:

• Profile existing data across Legacy Systems and help define Primary and Secondary (Reporting, Geography)taxonomies
• Identify gaps in data, consolidate and cleanse data
• Define Data Migration Strategy, import Maps&Migrate data
• Load Primary & Secondary Classifications, Attributes &Assignments, different enumerations
• Merge Profile for merging from Supplier Catalog to Master Catalog
• Help define the Business Workflows and Data Validations using IDQ and ActiveVos workflows
• Integration- using REST and Unix scripts forInbound from SAP (Suppliers), and Outbound (Items,Products) using Export template, Unix scripts to ESB and legacy systems
• Involved in all stages of Project through UAT and Production deployment

Environment: Informatica-PIM (Cloud), WebSphere, IDQ, ActiveVOS, Oracle, AS2

Confidential, Ohio

MDM Developer

Responsibilities:

• Analyze requirements for new data attribution of Products
• Propose solution for new attributes mapping to old attributes
• Updating Model ( Attributes, Attribute Links, Valid Object Types etc ) using Talend process to read from Excel
• Develop Business rules and workflows for process management/approvals

Environment: Stibo-MDM, Talend, Excel, JavaScript

Confidential, Vancouver, WA

MDM Architect

Responsibilities:

• Architect ETL process for Initial & incremental Load of approx 100 source tables from various sources using BIML, C# to generate SSIS packages
• Develop Data Integration Hub for various domains - Customer, Vendor,Product,Finance etc.
• Create Data Dictionaries of metadata
• Develop various other SSIS packages for Sales, Finance and other data processing for various downstream BI/Analytics and SAP applications
• Analyze existing data and help develop MDM artifacts
• Gap Analysis and help generate Data for BI & integration with Adaptive Insights, Tableau, Confidential Supply Chain planning etc., Oracle Product/Customer Hub
• Participate in requirements gathering and drive MDM data strategy using TIBCO MDM & Microsoft Data Services (MDM) for mastering Product,Vendor,Customer,Bank for BI
• Initial data standardization and quality analysis using Talend MDM

Environment: Dell Boomi, Talend-MDM, Microsoft -MDS, TIBCO- Cloud MDM 8.3x, TIBCO-Business Works, TIBCO-EMS, SQLServer 2012, BIML,SSIS, Excel, BI

Confidential, Carlisle,PA

MDM Architect

Responsibilities:

• Gathered requirements from business users
• Define workflow process
• Help create data model according to the requirements

Environment: Tibco MDM, Tibco EMS, Tibco BW

Confidential, Irving,TX

MDM Developer

Responsibilities:

• Gathered requirements from business users
• Help create data model according to the requirements
• Help create Mappings to get the data loaded into the Staging tables during the Stage Process
• Coordinate with Leads to understand Match & Merge requirements and help incorporate
• Create IDD application and Subject Areas, Subject Area Groups, Deploy and test IDD application, cleanse functions, utilizing timeline, export and import master data from flat file
• Analyzed the data by running the queries and provided the stats after Initial data and incremental Loads
• Defined Roles and privileges for each environment according to the platform requirement
• Created Match rule sets in for the base objects by defining the Match Path components, Match columns and rules
• Involved with ETL team in getting the data loaded into the landing tables
• Created Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation,Address Doctor
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• 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.
• 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.
• Involved in creating, monitoring, modifying, & communicating the project plan with other team members.

Environment: InformaticaMultidomain MDM 9.5.0, JBoss 5.1, Oracle 11g R2, Address Doctor 5, IDD, SIF, Toad, SQL*Loader, Windows Server 2008

Confidential, Buffalo,NY

MDM Lead Consultant

Responsibilities:

• Participate in requirements and design review meetings
• Analyze requirements and propose solution for Initial Load and Incremental data loading process
• Create Logical Model in CIM Studio and the Physical model in database using CIM Studio
• Assist in implementing the Match and Merge process using BW and CIM Workflow
• Implement the merge workflow and custom Rule base function for merging based on precedence

Environment: TIBCO-CIM, TIBCO-BW, TIBCO-EMS, UNIX, Weblogic

Confidential, Dalton,GA

MDM Lead Consultant

Responsibilities:

• Facilitated daily scrum meetings
• Participate in requirements and design review meetings
• Mentor developers on development of processes and workflows
• Implement workflow and validations based on a set of parallel/split approval processes
• Debugging and fixing issues in solution

Environment: TIBCO-CIM, TIBCO-BW, TIBCO-EMS, UNIX, Weblogic

Confidential, Milwaukee, WI

MDM Lead Consultant

Responsibilities:

• Define and design the Data Acquisition, Transformation, and Data Cleansing approach for the MDM implementation
• Mentor and provide direction to offshore junior engineers on development, processes, and product architecture
• Participate in planning and design review meetings with technical leads and project managers to determine schedules, review technical problems, and assign tasks and resource
• Create Logical Model in CIM Studio and the Physical model in database using CIM Studio
• Application Performance testing with high volumes of data
• Debugging and fixing issues in solution

Environment: TIBCO-CIM, TIBCO-BW, TIBCO-EMS, Unix, Weblogic

Confidential, New Jersey

MDM Lead Consultant

Responsibilities:

• Mentor and provide direction to junior software engineers regarding MDM platform development, processes, and product architecture
• Responsible for developing custom workflows/processes and validations in CIM.
• Deployment of Hotfixes of the product
• Help the Support team troubleshoot customer issues
• Supported customer go-lives

Environment: TIBCO-CIM, TIBCO-BW, TIBCO-EMS, UNIX, Weblogic

Confidential, Bentonville, AR

Data Analyst & Product Integration

Responsibilities:

• Workflow/UI development using ABPP for custom User/Role Management
• Responsible for System Integration and analysis of high volumes of raw data (millions) from SAMS Club’s legacy systems (that existed in various formats)
• Using Java/Python/Jython scripts to prepare raw Product Hierarchy, Time Hierarchy, Stores & miscellaneous data to database loading requirements
• Writing code & helping in code fixes
• Creating sample data of millions of records in DB2 to test aggregation and various other scripts for History data and other analysis, performance testing etc
• Using DB2 Load to load high volume data
• Writing SQL & batch scripts to load formatted data in a form required for loading into final tables
• Installing and maintaining the Hub Servers and Satellite clients on various servers & laptops in SAMS Club environment
• Helping in debugging issues at client site and capturing logs from time-to-time

Environment: .Net, C#, Microsoft Excel (UI), Microsoft Office & Charts, Java, DB2, Python/Jython