Uploaded File
add photo
Kelly
kellyselzer@outlook.com
614-827-3180
Dayton, OH 45459
Internal Auditor
18 years experience W2
0
Recommendations
Average rating
19
Profile views
Summary

  • Internal Audit, Data Analysis, Program Administration
  • Process Improvement, Reporting/Presentations, Collaboration
  • A dynamic, detail-oriented professional with success coordinating compliance programs, performing in-depth analysis of quantitative and qualitative factors and delivering clear, concise reports.
  • Excellent communicator with the ability to forge productive, long-term professional relationships.
  • Proven leader and team player with superb collaborative skills. Dedicated to efficiency, accuracy, and continual improvements.
  • Exceptional academic qualifications, including a Master of Business Administration from the University of Tampa.

Selected Highlights

  • Selected to serve as the transportation department data analyst due to strong performance, overseeing the effectiveness of data usage and identifying and implementing improvements.
  • Innovated on methods and controls to ensure crash record completeness, elevating the rating by 52%.
  • Key contributor for a statewide committee for over ten years, preparing well-received presentations and reports to highlight the needs of the Commission and collaborating with government agencies from local to federal.
  • After proven track record, recognized as the subject matter expert for commercial vehicle crash data in Ohio, and regularly reviewed, investigated, and responded to crash data review requests submitted by external stakeholders.

Core Competencies

  • Program Administration
  • Process Improvement
  • Leadership
  • Technology Integration
  • Relationship Management
  • Auditing
  • Data Analysis
  • Analytical Skills
  • Accounting
  • Reporting
  • Critical Thinking
  • Presentations

Additional Credentials

Technical Skills

  • Microsoft Office (Access, Excel, PowerPoint, Project, Publisher, Visio, Word, Outlook), Crystal Reports, Oracle Cloud ERP, and Microsoft SQL Server (queries & data retrieval)

Projects & Presentations

  • IT Users Workshop Panel Speaker (2015)
  • LEAN Ohio Kaizen Event (2014)
  • DataQs User Guide & Manual (2011)
  • Accounting Professional Panel Speaker – IMA - Capital University

Volunteering Experience

  • Give Kids the World Village
  • Local Farmers’ Market
  • Nationwide Children’s Hospital

Experience
Internal Auditor
Information Technology
Mar 2019 - Apr 2020
Dayton, OH

Worked independently to perform objective audits across operational, safety, financial, and regulatory areas throughout the company. Worked collaboratively to support and enhance the Oracle Cloud system and user interactions.

  • Traveled across the Midwest to conduct internal audits at service centers from pre-work to closing meetings.
  • Documented processes, identified risk, and sought best practices with the goal of improving operations and safety.
  • Acted as Oracle Cloud ERP Administrator. Set up user accounts and access, refined modules, assisted users with troubleshooting issues or learning the system, designed OTBI reports, and audited expense reports.
Auditing Compliance Microsoft Excel Project Management
Remove Skill
Internal Auditor
Information Technology
Jul 2018 - Oct 2018
Orlando, FL

Worked as an onsite contractor for Florida Municipal Power Agency to analyze internal controls and procedures.

  • Performed financial and operational audits with sampling, risk assessment, and data analysis across multiple departments. Wrote and designed audit reports to clearly communicate my process and findings to management.
  • Compiled data from multiple software systems and exported into Excel and Access to normalize the information. Once the data points were consistent, used pivot tables and formulas in Excel to analyze and draw conclusions.
Auditing Microsoft Excel Compliance Risk Assessment
Remove Skill
Data Audit Analyst
Information Technology
Aug 2017 - Dec 2017
Orlando, FL

Directly interfaced with clients to review invoice charges to determine compliance.

  • Gathered, compiled, and cleansed client data from various sources by writing SQL queries and exporting data into Excel for analysis.
  • Developed ad-hoc SQL and Access queries to identify data gaps for further follow-up.
Auditing Compliance Microsoft Excel SQL
Remove Skill
Program Administrator 2
Government
Aug 2005 - Sep 2016
Columbus, OH

Provided statistical and analytical reports to drive state-wide programs targeting a reduction in commercial motor vehicle related crashes.

  • Evaluated, audited, monitored, and improved the quality of data to meet federal regulatory compliance standards.
  • Developed clear, concise reports with key metrics and recommendations for a wide variety of grants, agency requests, annual reports, management reports, and ad hoc requests. Utilized Excel, Access, and SQL to scrutinize data and draw conclusions.
  • Regularly reviewed, investigated, and responded to crash data review requests submitted by drivers, transportation company safety departments, and other government agencies.
  • Selected to serve as the Transportation Department data analyst due to strong performance, overseeing the effectiveness of data usage and identifying and implementing improvements.
  • Collaborated with IT counterparts to implement multiple database upgrades. Incorporated new processes and approaches to analyze and transform data records to meet and exceed the requirements of a federal agency.
  • Facilitated the collection of complex transportation data from multiple government agencies.
  • Innovated on methods and controls to ensure crash record completeness, elevating the rating by 52%.
  • Key contributor for a statewide traffic records coordinating committee for over ten years, preparing well-received presentations and reports to highlight the needs of the Commission and collaborating with government agencies from local to federal.
Compliance Microsoft Excel Project Management SQL
Remove Skill
Regulation Internal Auditor
Government
Mar 2004 - Aug 2005
Columbus, OH

Completed onsite audits of approximately healthcare organizations per year and conducted follow-up audits as needed. Prepared draft audit reports to document findings and recommendations for management review and submission to Audit Director.

  • Clearly communicated and presented audit findings and integral recommendations during closing meetings.
  • Developed and revised numerous work papers draft audit reports and audit program sections used on yearly audits continuously maximize effectiveness efficiency and consistency.
  • Orchestrated specialized audit programs as needed for follow-up audits and received praise for superior professional acumen and outstanding work ethic.
Auditing Project Management Compliance Microsoft Excel
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Master's in Business Administration
University of Tampa 2003
Bachelor's in Accounting
Capital University 2002
Skills
Compliance
2020
14
Microsoft Excel
2020
14
Project Management
2020
13
SQL
2017
11
Auditing
2020
3
Process Improvement
0
1
Regulatory Reporting
0
1
Risk Assessment
2018
1