- Ability to recommend the most suitable methods of data extraction and comparison.
- Ability to identify and understand the different data formats and structures used in
- each source system.
- Develop and generate reports that effectively and clearly present the comparison of
- data converted from Infor Lawson to Oracle Cloud Fusion HCM.
- Create reports to highlight differences in matched data and the absence of data from
- the source to the destination.
- Create reports to identify data that is in Lawson but not in HCM as well as the reverse,
- data in HCM not in Lawson.
- The data from the HCM Oracle cloud conversion will be validated against the source
- Lawson tables.
- Tailor the reports to allow Functional users to easily understand the highlighted data
- differences
- Ensure that all data is reviewed, not just subsets of the data.
- Document what tables and fields are being compared
- Document any limitations of the comparison
- Assist functional users in the review of the comparison reports
- Work with MCPS resources to resolve any issues that arise during the project.
- Keep the client informed of progress and any roadblocks.
- Attends meetings where reporting and analytics expertise is needed and represents the
- department in both internal and external settings.
Required knowledge, skills, and abilities must include:
- 7 or more years of data analyst and/or relational database administrator experience
- working on large enterprise-wide implementation projects.
- 5 or more years of experience working with large volumes of data from on-premise
- and cloud platforms.
- Experience translating business requirements into data requirements.
- Experience in gathering and reviewing/comparing data from multiple sources, including but not limited to Oracle databases using Lawson LBI, or SQL, Excel spreadsheets, and vendor generated reports.
- Experience in creating complex pivot tables using Excel for data comparisons.
- Experience in creating programs for data validation using SQL.
- Expert experience with database query and merging datasets using Microsoft Excel.
- Ability to design, generate and validate results of analyses of complex data sets, and facilitates reporting to improve operational outcomes.
- Ability to develop and maintain quality control standards and data reconciliation techniques for internal and external reporting.
- Experience in developing and implementing algorithms for data analysis and modeling.
- Ability to evaluate and select appropriate software tools, frameworks, and technologies.
- Ability to identify patterns in data and communicate the findings clearly.
- Design and execute effective data visualization strategies for presenting complex data.
- Experience in managing complex projects and tasks while paying close attention to details.
- A keen focus on customer-satisfaction and team collaboration.
- Detail-oriented, highly organized, and excellent oral and written communication and human relations skills.
- Excellent analytical, problem-solving, and decision-making skills, leveraging both logic and creativity.