Confer with business stakeholders, the BEST Data and Information Lead, BEST Technical Lead, and the system integrator (SI) for the BEST Program to formulate and define data conversion requirements, scope, and objectives.
Work with the SI vendor to prepare detailed mapping specifications from which conversion software will be written or programmed.
Test and debug new conversion software and tools, that operate in both legacy on-premises environment and cloud environment.
Provide complete documentation for data conversion protocols and processes, including operational procedures and manuals as needed.
Identify and implement data cleansing, data extraction, transformation and loading utilities, conversion verification and certification protocols and tools in conjunction with the system integration vendor and product teams.
Develop reports and testing procedures to ensure data integrity and provide automated reconciliation.
Program, unit test and system test conversion software.
Map existing data to the new solution data structures. Extract and clean data from legacy systems with preferred experience with advanced techniques of data quality and data profiling through tools/platforms which may include AI/Client
Coordinate and monitor data conversion tasks assigned to agencies, including the development of conversion user interfaces to facilitate the collection of any required additional information for the new system and working with agencies to collect this information.
Assist/support BEST Technical Lead on Authority to Operate (ATO) requirements.
Support Data Governance implementation needs, which will occur throughout the life of the project.
Drive Data Quality initiatives during each stage of processing from legacy current environment to future state cloud-based solution.
Identify installation solutions for new databases.
Publish data design(s) and identify areas for improvement.
Coordinate with project team members on milestones and deadlines.
Perform auditing on database(es) to maintain quality.