Helping clients

through every stage of their data migration journey




Customers    Pre-migration

Project 1: Multiple data sources

The client was implementing a new LMS Cloud system for 1,000 internal users and 100,000 external users.  MDLman provided technical consultancy and data migration skills to complete this complex 5 month project.  The source data was extracted from a variety of sources: Workday iCloud; MS Dynamics (CRM database); and legacy applications that were mostly Excel spreadsheets.  The MDLresolver tool was used to analyze data such as Division, Location, Cost Centre, Position, Grade and CRM data which was then put into templates for the new system and loaded into a test environment.  MDLresolver was also used for Classroom Training and Course Catalog data integrity checks and the set up of regular data feeds.

Project 2: Global rollout

As project manager for the Master Data Feed process our database consultant standardized the template management and data load processes to make them more efficient for this data migration project.  Using the MDLresolver data cleansing tool the MDLman database expert improved the quality of data loads to the cloud-based LMS system.  This led to a rapid improvement in throughput and reduced the failed loads to zero for the 600 data loads carried out on this major global rollout project.

Customers    Implementation

Project 1: Multiple teams

MDLman was asked to project manage both the internal and external teams (including some offshore) for the implementation of a new cloud-based LMS system.  The project involved extracting the people and organization data from two different sources (SAP and MS Domain Database) into an Infomatica database.  From there the MDLman database expert transformed the information into the correct format to load it into the new LMS system.  This involved testing the data, loading it into a test environment for the new LMS system and then setting up a regular daily data feed process.

Customers    Live

Project 1: Compliance reporting issues

The client was experiencing problems with their cloud based LMS system.  They had failed to maintain data integrity, and this was causing issues around training compliance reporting.  Our data analysis experts investigated and found the root problem in a daily data feed.  This was causing issues with:

  1. User enrolment – showing up as Proxy Enrolment failures
  2. Issues with the availability of
    1. training materials
    2. tests on the materials covered
    3. course curricula
  3. Custom reports

Using the MDLresolver data cleansing tool our database consultants successfully resolved all data issues and data integrity problems within 6 weeks.

 Project 2: Data integrity issues

The project involved the use of the MDLresolver data cleansing tool and the MDLman database consultants.  The client encountered data integrity issues during the deployment of a Global eLearning system.  Our database experts used MDLresolver as deduplication software and for data integrity checking of all 30,000 courses in the Course Catalogue.  Then they were able to implement a process to extract the Course Catalogue data, verify it and update all the courses with the correct information.