David Heath available

David Heath

Consultant, Data Migration Consultant, MIS Analyst Consultant

Profileimage by David Heath Consultant, Data Migration Consultant, MIS Analyst Consultant from
  • Freelancer in
  • Graduation: BSc Mathematics
  • Hourly-/Daily rates:
  • Languages: English (Native or Bilingual) | French (Native or Bilingual)
  • Last update: 25.09.2020
CV - David Heath

You need an account to view this information.

SSMS, SQL Server, SAS, VBA, MS Access, MS Excel, DAX, Power BI, Alteryx Designer, Python, Oracle NetSuite, Oracle PPM, SAP, MS Dynamics, DynaRent, MS Office, G Suite, MS Project, Crystal Reports, PeopleSoft, Infusionsoft CRM, Visio, Leisure, Textile Manufacturing, Journalism, Agriculture, Data Migration, NetSuite, ERP, InspHire, video conferencing, file sharing, ETL, MS SQL Server, SQL, SAP Hana, OPPM, Alteryx, training data, MS Access/Excel/VBA, Outlook, HTML, data modelling, Excel, Infusionsoft CRM, data extraction, PeopleCode, Paradox, Lotus
  • 11/2019 - 07/2020

    • Riwal
    • Other
  • Data Migration Consultant
  • Worked with global subject matter experts & project managers to determine the data requirements for conversion to Oracle NetSuite and InspHire systems from MS Dynamics/Dynarent. G Suite was used exclusively and extensively for all aspects of the project, including collaboration, video conferencing, and file sharing.

    Developed and executed ETL data migration and integration plans in a frequently changing environment, primarily using SSMS/MS SQL Server, VBA, MS Access and MS Excel.

  • 11/2017 - 11/2019

    • Yara International ASA
    • Other
  • Data Migration and BI Consultant
  • Developed and ran the global data migration process, converting multiple standalone systems on all continents into the new OPPM system.

    Worked with global production and sales & marketing managers to determine the data requirements for migration to OPPM.

    Defined and developed data definitions, mappings, data templates.

    Developed a self-checking data-input template to streamline the data migration process.

    Provided technical and business guidance for the technical contacts to deliver high quality, timely project data.

    Designed and developed MIS reporting using SQL, Power BI, DAX, and VBA, combining data from SAP Hana and Oracle PPM (OPPM) via Alteryx.

    Prepared training data tailored to individual trainees.

  • 11/2009 - 08/2017

    • Various
  • MIS Analyst Consultant
  • Clients: Various across South-West France

    Established an MIS reporting facility for a major tourism business, providing rapid, accurate information to senior management.

    Designed and automated all weekly MIS reporting for senior management of a film production company, primarily using SQL/MS Access/Excel/VBA.

    Installed robust processes for populating a complex petty cash system in Access.

    Created Outlook VBA functions for producing HTML templates for the Marketing department.

    Provided technical guidance in data modelling, data definition, mappings and data management.

    Streamlined the payroll process through development of Excel functions.

  • 05/2004 - 03/2009

    • Effective Directory Ltd
    • Marketing, PR and Design
  • IT Director
  • Developed successful digital marketing campaigns to attract local businesses to advertise.

    Introduced online automated, tailored marketing campaigns using Infusionsoft CRM.

    Sold the business in 2009 following relocation to France in 2006.

  • 06/1999 - 05/2004

    • UK Sport
  • International Athlete
  • Took a sabbatical from full-time work to train and compete at international level, competing for Great Britain on the track and in cross-country.

    Project-managed the overhaul of legacy systems at UK sport, establishing data extraction and cleansing routines using MS Access/Excel/VBA.

  • 07/1994 - 06/1999

    • Citibank
    • 1000-5000 employees
    • Banks and financial services
  • Senior Systems Analyst/Project Manager
  • Project managed the data-migration of confidential legacy systems' data to the HR module of a new ERP system (Peoplesoft), including a complex payroll system. Data included personal information, employment details, salary and bonus history for over 3000 employees, including expats in multiple countries. The migration required extensive, detailed analysis and understanding of all HR processes, systems and data sources.

    Streamlined the compensation process through the development of effective MIS systems, using VBA, SQL, MS Access, MS Excel, Crystal Reports and PeopleSoft .

    Established complex year-end compensation systems reports - sourcing data from European personnel systems, from head office in New York and from market data companies.

    Analysed the data and calculation of year-end bonuses and tax-efficient ways for paying those