Kimberly Moore
Iowa City,Iowa
Summary
Data Analyst with expertise in data analytics, process automation, and reporting. Proficient in using Microsoft Excel Power Query, VBA, SQL, and Power BI to enhance data analysis, automate workflows, and improve decision-making processes. Experienced in creating continuous audits, designing databases, and reporting monthly reconciliations from Blackline through Power BI. Skilled at collaborating with cross-functional teams to streamline operations and reduce human error, delivering actionable insights through advanced data analysis techniques.
Overview
12
12
years of professional experience
Work History
Internal Auditor / Data Analyst
CRST The Transportation Solution, Inc.
06.2022 - Current
- Led data analysis projects using Excel Power Query and VBA, supporting business decisions through data-driven insights
- Automated key audit processes and data workflows using VBA, improving operational efficiency and reducing manual errors
- Reported monthly reconciliations from Blackline using Power BI, providing management with clear, actionable data insights
- Currently learning SQL to enhance database management and reporting capabilities
- Developed continuous auditing models using Power Query, leading to improvements in audit accuracy and efficiency
- Designed and maintained customized databases using Microsoft Access to enhance data tracking and reporting for audit-related projects
- Collaborated with business teams to create data-driven dashboards and reports using Tableau and Power BI, streamlining decision-making processes.
Accountant Auditor
University of Iowa
Iowa City
07.2018 - 03.2020
- Conducted monthly audits and data analysis, ensuring compliance and identifying trends to enhance accuracy and reduce fraudulent activity
- Created and maintained Excel-based tracking systems for university transactions, providing data insights and recommendations.
Mathematics Teacher
Ames Community School District
Ames , IA
08.2012 - 08.2017
- Instructed and mentored over 120 students annually, developing tailored lesson plans to improve classroom performance by 80% in two years.
- Utilized clear communication and problem-solving skills to address student needs and ensure 100% pass rates for five consecutive years.
- Collaborated with teaching staff to ensure students received a well-rounded education, demonstrating strong teamwork and leadership abilities.
- Trained and mentored teaching assistants, helping them develop classroom management skills and improving their professional development.
Education
Bachelor of Business Administration - Marketing
University of Iowa, Iowa City
Bachelor of Science - Mathematics
University of Northern Iowa, Cedar Falls
Skills
- Data Analytics & Reporting
- Proficient in using Excel Power Query and Power BI to generate insights and support strategic decisions, including monthly reconciliations from Blackline
- SQL & Database Management
- Learning SQL to improve data querying and manipulation for enhanced data analysis and reporting
- Automation & Process Improvement
- Automated data workflows using VBA and Excel to streamline processes and improve operational efficiency
- Python (Basic Proficiency)
- Completed a Python programming course, gaining foundational skills for data analysis and automation
- Audit Process Automation
- Experience automating continuous audits and test work using Excel Power Query, VBA macros, and audit tools
- Software Proficiency
- Microsoft Excel (advanced), Power Query, SQL (learning), VBA, Power BI, Microsoft Access, Smartsheet, Blackline, TeamMate Analytics
Accomplishments
- Graduated Magna Cum Laude
Timeline
Internal Auditor / Data Analyst
CRST The Transportation Solution, Inc.
06.2022 - Current
Accountant Auditor
University of Iowa
07.2018 - 03.2020
Mathematics Teacher
Ames Community School District
08.2012 - 08.2017
Bachelor of Business Administration - Marketing
University of Iowa, Iowa City
Bachelor of Science - Mathematics
University of Northern Iowa, Cedar Falls
Similar Profiles
Mitchell LongcorMitchell Longcor
Product Owner III at CRST The Transportation SolutionProduct Owner III at CRST The Transportation Solution
Ja'Asia GlasperJa'Asia Glasper
Operations Associate at CRST The Transportation SolutionOperations Associate at CRST The Transportation Solution
Julius VasquezJulius Vasquez
Class A Delivery Driver at CRST The Transportation Solution, Inc.Class A Delivery Driver at CRST The Transportation Solution, Inc.