Profisee, Mdm Lead Resume
Dallas, TX
SUMMARY
- Motivated and result oriented professional with 21+ years of experience in IT. Certified Salesforce Developer and 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, knowledge of Orchestra EBX5
- 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
- Expertise in 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, Dallas TX
Profisee, MDM Lead
Responsibilities:
- Participate in workshops with Business & IT Team for MDM requirements gathering
- Triaging issues with MDM data
- Design and develop Model, business rules and Portal UI Layouts
- Deploy solution to UAT and Prodction servers
Confidential
STIBO STEP MDM Lead
Responsibilities:
- Participate in workshops with Business & IT Team for MDM requirements gathering
- Triaging issues with data across upstream, STEP-MDM and downstream systems
- Updating Business Rules, workflows, Web-UI, scheduled exports and other configurations to requirements
- Work with offshore technical team for delivery
Confidential, Troy, MI
Informatica MDM Developer & Analyst
Responsibilities:
- Participate in workshops with Business & IT Team for MDM requirement gathering
- Responsible for working with Business and Technical stakeholder teams for functional requirements
- Define, architect and design Informatica MDM based solutions, help build Testcases for UAT
- Analyze data from legacy systems for Customer & Organization domains
- Conduct gap analysis in data
- Lead and guide the technical team offshore in solution design and build during the course of the project
- Implementation of MDM Data Model based on past implementations
- Python\Excel scripting for data preparation, analysis and data quality reports
- Help Configure MDM for Customer, Organization, and D&B models
Environment: Informatica-MDM v10.2, IDQ, D&B, Mainframe, Salesforce, SQLServer
Confidential
Informatica MDM Lead
Responsibilities:
- Mentor team members on Informatica MDM (Customer/Party Master)
- Conduct gap analysis in data
- Using console update Customer data model, mappings, Trust rules, match rules, etc
- Create mappings for staging table
- Configure batch processes - stage, load, match-merge etc
- Build and modify the Informatica Data Director (IDD) interface per Users requirements
- Configure Business rules and workflows for process management/approvals
- Analyze and Maintain Reference data for 40 various Lookup tables from source data
- Code Migration & Data loading across different environments - DEV, QA
Environment: Informatica-MDM v10.1, JBoss
Confidential
PIM 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 for GDSN synchronization & 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 for Inbound 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
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 Activos (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