We provide IT Staff Augmentation Services!

Data Architect Resume Profile

OBJECTIVE

  • Seeking a challenging position as Sr. IBM InfoSphere MDM Solution Consultant
  • Confidential is a Sr. MDM Master Data Management Consultant with 15 years of Data Integration experience he is very hands-on, has all aspects of workbench/scripting/programming skills on IBM InfoSphere MDM Solution, Data Profiling Pattern and Data Survivorship. He has extensive expertise in MDM product infrastructure WCC, DWL, TCRM, TAIL, SPEC/NLS, and schema etc. , understands business challenges and translates them int 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 t 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 t 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 BA team Business Analytics and Optimization t 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 t 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 Initi 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

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 t design and develop necessary batch interfaces t 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:

  • Served as the Domain Expert/Subject-Matter Expert SME for MDM Solution, defined requirements and created architectural specifications
  • Convert strategy int services
  • Effectively and efficiently deliver support services
  • Ensure value t customer and service provider
  • Maintain stability while allowing for change
  • Organize t improve IT support t customers
  • 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
  • Developed MDM Server extensions and additions in MDM workbench Coded maintenance scripts t implement business logic for multiple clients and carry out one-time operational activities
  • Was directly responsible for successful delivery of Enterprise Data integration solutions successfully implemented the first MDM v11 upgrade project for IBM around the world.
  • 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.
  • Maintained MDM jobs and Master Data sequences Build test scripts for unit testing of customized MDM code, create/implement/package/deploy/test/release the modification

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

Responsibilities:

  • Worked with IBM/DWL elite team, helped IBM Contracted clients t implement the projects within the budget and on time
  • Served as the Domain Expert/Subject-Matter Expert SME for Data Governance and Stewardship including:
  • Designed, built and tested MDMS custom components t capture and store multiple attributes of customer master data
  • Managed rules for data standardization and validation, matching and merging
  • Worked with internal data governance groups in terms of polices and processes t improve overall data quality and management t ensure their requirements were reflected within the overall MDM solution being delivered.
  • 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
  • Developed MDM Additions, Extensions, Business Proxies and Composites Customized SDP for Search and Match rules Connfigured Event Manager and Evergreening in MDM Server
  • Designed, built and tested MDMS custom batch processor adaptors t process fixed length flat files

Confidential

Sr. Data Architect/DBA/Data Integration Consultant

  • Database: DB2 UDB ESE 9/8 , Oracle 10/9 , Teradata, SQL Server
  • Operating Systems: AIX5.3/5.2/5.1/4 , OS390, AS400, Window 2000/2003 and Linux RED HAT 9
  • Languages/Tools: Erwin Data Modeler r7, PowerDesigner 15.0. Informatica PowerCenter , MicroStrategy 7, XML, Teradata, Cognos, Essbase, WebFocus, SAS.

Responsibilities:

  • As tech prime t 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 t keep track of files processed, as well as manual Survivorship
  • Migrated Master Data Module from Old OLTP Systems t New OLTP System from heritage/legacy format t the latest XML technology.
  • Implemented IBM Financial Solution framework t 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 tw parties
  • Interfaced MDM t RMI remote method invocation , JMS Java Message Service , Batch, Web Services
  • Planed and designed PEDM Proactive Enterprise Data Management t capture rapid data volume escalating, as well as t establish the methodology for control, security, and integrity of trading systems

Hire Now