OBJECTIVE

Seeking a challenging position as Sr. IBM InfoSphere MDM Solution Consultant

• He has extensive expertise in MDM product infrastructure WCC, DWL, TCRM, TAIL, SPEC/NLS, and schema etc. , understands business challenges and translates them into process/technical solutions, develops and implements MDM solutions, effectively and efficiently delivers support services, as well as manages client relationships within context of individual role.
• In the past 10 years, he specializes in Master Data Management MDM , is directly responsible for successful delivery of technical solutions. From his recent projects with IBM, Nationwide Insurance, John Hancock Insurance, Lord Taylor, TD Bank, he has developed proven a set of approaches to achieve Master Data Annotations and Integration within the budget and on time. He has extensive formatted data governance experience in SOA Service-oriented architecture , IBM IIW IBM Insurance Information Warehouse , IFW IBM Information Framework , IFIF IBM Financial Industry Framework , IBIF IBM Banking Industry Framework , and IAA IBM Insurance Application Architecture , including aligning business needs to specific data elements and integrating new elements when required for FSLDM Financial Services Logical Data Model and EDM Enterprise data modeling .
• In 2013, he was selected by IBM GBS BAO team Business Analytics and Optimization to implement the first MDM version-11 project Nationwide Insurance around the world, and currently he is working on version-11 in John Hancock Insurance.
• He is a solid team player, with Get it done attitude, advanced analytical thinking, technical leadership, and problem-solving skills

HIGHLIGHT OF QUALIFICATION

• 10 years' experience of building up Master Data Management, Initiate Meta data management, data stewardship, data quality, Data governance, Master Dataflow, and Suspect Duplicate Processing SDP :
• Develop and implement customized MDM solution based on IBM MDM Specification Documentation
• EDW/EDM Data solution, Enterprise Data Integration, Governance and Administration
• 15 years' hands-on experience of being Sr. Data Integration Consultant, providing a dominant service in J2EE environment including 12 years' experience with application servers WebSphere, WebLogic and JBoss
• 15 years of all aspects of SDLC of Data Integration, Data Collaboration, Data profiling, Data Pattern and Data Cleansing with multiple type Data Stores raging from heritage/legacy systems to latest XML technology

TECHNICAL SKILLS

• Master Data Management IBM MDM v11/10/9/8 , currently working on v11's migration, OSGI, MANIFEST, bundle/cba, BluePrint, Soft Extension, Business Proxy, External Rules, DataAdditions, DataExtensions, BehaviorExtensions, ExternalRules, FragmentedBundles and Suspect Duplicate Processing using asi, eba, bobj, eobj, csb, java/jar/ear, j2ee, xsd, Spring Framework etc
• DB2 10, Oracle 11g, SQL Server 2012/2008, Teradata, Informix, Netezza, and Exadata ETL Tools Informatica, DataStage, SSIS, Ab Initio Data Quality Tools i.e. Quality Stage
• IBM WebSphere Application Server, InfoSphere MDM Server Extension Framework and InfoSphere MDM Server Transaction Suite, Big Data/Hardtop large scale computing, Scheduler Tools i.e. MQ Scheduler
• IBM Rational System Architect RSA , Rational Application Developer RAD 8.5, JBoss XML, UML
• Mainframe OS390 , UNIX AIX, Solaris HPUX , Linux, and Windows Server.

WORKING EXPERIENCE AND ACCOMPLISHMENTS

Confidential,

Current Sr. MDM Consultant

• Database: DB2 10/9.7, Oracle 11/10 , Teradata, Netezza, SQL Server
• Operating Systems: Mainframe OS390, UNIX AIX/Solaris/HPUX , Windows, and Linux
• Languages/Tools: IBM InfoSphere MDM 11, IBM RAD Rational Application Developer 8.5, IBM WebSphere, Mavin, Log4j, Spring Framework and Fitness, IBM Data Architect, XML, UML, Java, J2EE, WSDL, XSD, ANT build script, Ant Build Java, DataStage, Informatica

Responsibilities:

• Build up MDM v11 Server, reconfigure server setting, re-code and re-engineer the dataflow based on IBM out-of-box functionalities, e.g.: OSGI, MANIFEST, bundle/cba, BluePrint, Log4j, Soft Extension, Business Proxy, DataAdditions, DataExtensions, BehaviorExtensions, ExternalRules, FragmentedBundles and Suspect Duplicate Processing SDP using asi, eba, bobj, eobj, csb, java/jar/ear, xsd etc
• Analysis, design and implement the Conversion Activities: Extraction, Copy Build, Log Apply, Record Counts, Transformation, and Verification
• Cut out the workflow for each component: Preconditions, Scripts/Tools, Triggers, Timing and Frequency, Postconditions, Algorithms and Exception Handling
• MDM Data additions, Data extensions, Behaviour extensions, Query extensions, Entity subtypes, MDM metadata specs, Product type hierarchy models
• Design and develop customized MDM code based on Specification
• Documentation such as Extension and Additions and Lightweight Services
• Design and develop customized MDM services.
• Design and develop Business Process Manager BPM , Process Center Process Designer
• Schedule recurring tasks Delta load using BPM Process Designer Initial load using Tivoli
• Mentor offshore to design and develop necessary batch interfaces to and from MDM hub.

Confidential,

Sr. MDM Consultant

• Database: DB2 10/9.7, Oracle 11/10 , Teradata, Netezza, SQL Server
• Operating Systems: Mainframe OS390, UNIX AIX/Solaris/HPUX , Windows, and Linux
• Languages/Tools: IBM InfoSphere MDM 11, IBM RAD Rational Application Developer 8.5, IBM WebSphere, Mavin, Log4j, Spring Framework and Fitness, IBM Data Architect, XML, UML, Java, J2EE, WSDL, XSD, ANT build script, Ant Build Java, DataStage, Informatica

Responsibilities:

• Maintained MDM jobs and Master Data sequences Build test scripts for unit testing of customized MDM code, create/imple ment/package/deploy/test/release the modification
• Worked on the defects from SDP, merged parties together, Data mapping, rules of visibility, real-time integration, matching based on deterministic and probabilistic matching, e.g.: Functionality for configuring the PME, which was formerly delivered through the PME Console, is now delivered within the Workbench.
• Was directly responsible for successful delivery of Enterprise Data integration solutions successfully implemented the first MDM v11 upgrade project for IBM around the world.
• Developed MDM Server extensions and additions in MDM workbench Coded maintenance scripts to implement business logic for multiple clients and carry out one-time operational activities
• Configured MDM Server, reconfigured domain setting, re-coded and re-engineered the dataflow based on IBM out-of-box functionalities Built test scripts for unit testing of customized MDM code
• Served as the Domain Expert/Subject-Matter Expert SME for MDM Solution, defined requirements and created architectural specifications
• Organize to improve IT support to customers
• Maintain stability while allowing for change
• Ensure value to customer and service provider
• Effectively and efficiently deliver support services
• Convert strategy into services

Confidential,

Sr. MDM Consultant

• Database: DB2 10/9.7, Oracle 11/10 , Teradata, Netezza, SQL Server
• Operating Systems: Mainframe OS390, UNIX AIX/Solaris , UNIX AIX/Solaris/HPUX , Windows, and Linux
• Languages/Tools: IBM InfoSphere MDM 10, QualityStage/DataStage 8.5, MDM/PIM Solution, IBM RAD Rational Application Developer 8.5, IBM RSA Rational Software Architect 8.5, IBM WebSphere, CDC, WCC, WPC, IBM Data Architect, XML, UML, Java, J2EE, WSDL, XSD, ANT build script, Ant Build Java
• Worked onsite at IBM Global Services , TD Bank, Bank of Nova Scotia

Responsibilities:

• Developed MDM Additions, Extensions, Business Proxies and Composites Customized SDP for Search and Match rules Connfigured Event Manager and Evergreening in MDM Server
• Developed the fixes for the product defects, APAR and PMR Fixed the gap from mapping parties, rule framework schema design for Automated Survivorship, Row level survivorship and Column level survivorship
• Worked with internal data governance groups in terms of polices and processes to improve overall data quality and management to ensure their requirements were reflected within the overall MDM solution being delivered.
• Managed rules for data standardization and validation, matching and merging
• Designed, built and tested MDMS custom components to capture and store multiple attributes of customer master data
• Served as the Domain Expert/Subject-Matter Expert SME for Data Governance and Stewardship including:
• Worked with IBM/DWL elite team, helped IBM Contracted clients to implement the projects within the budget and on time

Languages/Tools: Erwin Data Modeler r7, PowerDesigner 15.0. Informatica PowerCenter , MicroStrategy 7, XML, Teradata, Cognos, Essbase, WebFocus, SAS.

Operating Systems: AIX5.3/5.2/5.1/4 , OS390, AS400, Window 2000/2003 and Linux RED HAT 9

Database: DB2 UDB ESE 9/8 , Oracle 10/9 , Teradata, SQL Server

Sr. Data Architect/DBA/Data Integration Consultant

Confidential,

• Designed, built and tested MDMS custom batch processor adaptors to process fixed length flat files

Responsibilities:

• As tech prime to collaborate the project, be in charge of solution strategies/plans
• Kept Delivery manager well-informed of activities and recommends corrective actions
• Developed Data archival strategies to keep track of files processed, as well as manual Survivorship
• Migrated Master Data Module from Old OLTP Systems to New OLTP System from heritage/legacy format to the latest XML technology.
• Implemented IBM Financial Solution framework to enhance Functional Data Requirements, including High level Detail collaboration requirements gathering
• Built up the strategies for implementing and deploying Data Integration Model for OTC Master Data Management solution, for trading stocks, bonds, commodities or derivatives directly between two parties
• Interfaced MDM to RMI remote method invocation , JMS Java Message Service , Batch, Web Services
• Planed and designed PEDM Proactive Enterprise Data Management to capture rapid data volume escalating, as well as to establish the methodology for control, security, and integrity of trading systems