We provide IT Staff Augmentation Services!

Sr. Mdm/data Integration Consultant Resume Profile

OBJECTIVE

Seeking a challenging position as Sr. IBM MDM Solution Consultant/Data Integration Consultant

HIGHLIGHT OF QUALIFICATION

  • 15years' hands-on experience of being Sr. Data Integration Consultant, providing a dominant servicein J2EE environment including 12 years' experience with application servers WebLogic, WebSphere and/or 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
  • 8 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 MDM Data additions, Data extensions, Behavior extensions, Query extensions, Entity subtypes, MDM metadata specs, Product type hierarchy models
  • Integrate IBM MDM Server, IBM Initiate Master Data Service, IBM MDM Collaboration Server, cover three MDM hub patterns Coexistence hub, Transaction hub and Register hub
  • EDW/EDM Data solution, Enterprise Data Integration, Governance and Administration
  • MDM Matrix, MDM Adaptor, Metadata, Enterprise Master Patient Index EMPI Leverage WISD WebSphere Information Service Directory
  • Generate EJB, Jar files, and replace the existing components and attributes followed MDM server reboot.

TECHNICAL SKILLS

  • IBM InfoSphere MDM Master Data Management v10,IBM Initiate Master Data Service, MDM Collaboration Server, IBM MDM Server for PIM, MDM Hub,Java, J2EE, EJB,WSDL, XSD,WebLogic, WebSphere, JBoss XML, UML
  • IBM InfoSphere Identity Insight, DataStage/QualityStage, Information Analyzer v8.7
  • DB2 10, Oracle 11g, SQL Server 2012/2008and Informix
  • IBM Rational System Architect 11.4, IBM WebSphere, Big Data/Hardtop large scale computing.
  • Mainframe OS390 Unix AIX, Solaris HPUX , Linux, and Windows Server

WORKING EXPERIENCE AND ACCOMPLISHMENTS

Confidential

Sr. MDM/Data Integration Consultant

Operating Systems: Mainframe OS390, 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 11.4, IBM WebSphere, CDC, WCC, WPC, IBM Data Architect, XML, UML, Java, J2EE,WSDL, XSD, ANT build script,Ant Build Java

Responsibilities:

  • Install MDM Server, develop hubs, reconfigure domain setting, re-code and re-engineer the dataflow based on IBM out-of-box functionalities Build test scripts for unit testing of customized MDM code
  • Develop MDM Server extensions and additions in MDM workbench Code maintenance scripts to implement business logic for multiple clients and carry out one-time operational activities
  • Use MDM workbench, program the code/script, implement the deployment merge new MDM parties and update existing MDM parties develop CONFIGELEMENT table, OCIF, SIF, Ex-SIF, SDP Suspect Duplicate Processing
  • Performance tuning on various source systems, import data and syndicated data, in particular recode Query extensions to modify how the data is accessed
  • Upgrade MDM software to meet the vendor support requirement, and document out all the procedures
  • Work on the defects, troubleshooting and provide ongoing product/applications production support 24x7
  • Create MDM jobs and sequences to manage various tasks and/or steps to be executed by various users
  • Assist ODS define the standards for IBM MDM services and the requisite approaches for Data enhancements
  • Mentor offshore to prepare workspace in RSA, create/implement/package/deploy/test/release the modification.

Confidential

Sr. MDM/Data Integration Consultant

Database:DB2 10/9, Oracle 11/10 , SQL Server 2008

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 for IBM MDM Contracted clients, developed the fixes for the product defects, APAR and PMR
  • Programmed, implemented, stored, and maintained Initial Data Load and Delta Data load, performed schema-level exports and imports to support application development requirements
  • Delivered technical solutions with emphasis on Metadata Management, Data Quality and Data Integrity
  • Reviewed and governance database schema, data cleansing, data mapping, data integration
  • Ensured that external and internal regulations and policies governing data management were met including regulations concerning security, audit-ability and privacy
  • Ran queries against the source database as documented in the Data Profiling strategy and document results
  • Fixed the gap from mapping parties, rule framework schema design for Automated Survivorship, Row level survivorship and Column level survivorship
  • MDM architecture design Set up maintenance SQL code to implement business logic for multiple clients and carried out one-time operational activities
  • Structured and iterative data warehouse and application development lifecycle methodologies
  • Performed schema-level exports and imports to support application development requirements
  • Led re-infrastructure for the creation of database ERD diagrams and database schemas
  • Worked with application development team to design new and re-engineer existing applications.

Confidential

Sr. MDM Consultant

Database:DB2 9.5 DB2 UDB 9.7/9.5, Oracle 11/10 , SQL Server 2008

Operating Systems: Mainframe OS390, UNIX AIX/Solaris/HPUX , Windows, and Linux

Languages/Tools: IBM InfoSphere MDM 9, QualityStage/DataStage 8.5, MDM Solution, IBM RSA Architect V7, IBM WebSphere, CDC, WCC, WPC, IBM Data Architect, RSA, XML, UML, Java, J2EE,ANT build script, Ant Build Java

Responsibilities:

  • Programmed, implemented, stored, and maintainedInitial Data Load and Delta Data load, performed schema-level exports and imports to support application development requirements
  • Implemented repository configurations and survivorship rules to the MDM repository
  • Developed data cleansing, matching, merging and survivorship rules
  • Created mapping specifications from source systems to OCIF Operational Customer Information File Formats
  • Developed mapping specifications from OCIF file formats to SIF and X-SIF file formats
  • Validated existing data within the ECM repository, review and Analyze functional requirements, mapping documents, assist in problem solving and troubleshooting
  • Achieved optimal utilization cross entire Data architectures and subject matter with MDM Solution
  • Implemented cleansing, standardization and matching rules within IBM Quality Stage
  • Structured and iterative MDM SDLC of Data Management, Data Integration, Data Collaboration, Enterprise Data warehousing with multiple type ODS Operational Data Stores raging from heritage/legacy systems to latest XML technology
  • Delivered aligning Business Intelligence Strategy with Corporate goals and objectives by translating complex policing needs into technical solutions with emphasis on Metadata Management, Data Quality and Data Integrity.

Confidential

Sr. MDM/Data Integration Consultant

Database: DB2 UDB ESE 9.7/9.5/8 , Oracle 11/10 , SQL Server 2008

Operating Systems: AIX 6/5, Solaris 10/9, Window 2000/2003, and Linux RED HAT 9

Languages/Tools: IBM InfoSphere MDM 9, QualityStage/DataStage 8.5, IBM RSA Architect V7, IBM WebSphere, CDC, WCC, WPC, IBM Data Architect, RSA, XML, UML, Java, J2EE, WSDL, XSD,

Responsibilities:

  • Verified MDM setting, configuration, re-coded and re-engineered the dataflow based on IBM out-of-box functionalities CONFIGELEMENT table, OCIF, SIF, Ex-SIF, SDP Suspect Duplicate Processing
  • Ensured that external and internal regulations and policies governing data management were met including regulations concerning security, audit-ability and privacy:
  • Performed schema-level exports and imports to support application development requirements.
  • Structured and iterative data warehouse and application development lifecycle methodologies.
  • Reviewed and governance database schema, data cleansing, data mapping, data integration.
  • Extensively Used Quality Stages to Investigate , Standardize, Match and Survive
  • Extensively Used Quality stages built in wizards for parsing and removing duplicate records
  • Provided Data warehouse design on Data Flows for ETL jobs
  • Define the ETL project plan and ETL database framework foundation and MDM workbench
  • Assist with Data Integrity documenting the Data Profiling and Data Cleanup strategies for the data conversion
  • Ran queries against the source database as documented in the Data Profiling strategy and document results
  • Designed developed and maintaining existing SQL code to implement business logic for multiple clients and carried out one-time operational activities
  • Developed Data archival strategies to keep track of files processed
  • Designed and implemented customized multi-national Address Standardization process using IBM Web Sphere Quality Stage
  • Worked with the Data Integrity in presenting Data Profiling results to the client.

Confidential

Sr. MDM/Data Integration Consultant

Database: DB2 UDB ESE 9/8 , Oracle 11/10g, and SQL Server 2005/2000

Languages/Tools: MDM/PIM Solution, WCC/WPC, Erwin, IBM InfoSphere Data Architect, Oracle Designer, PowerDesigner, IBM Rational System Architect 11/10, UML, XML, Java, J2EE, SAS 8

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 Managementsolution, for trading stocks, bonds, commodities or derivatives directly between two parties
  • Create functional specifications including System Requirements Specification SRS and mapping matrix
  • 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

Hire Now