Ronald McVicar
Claremore,OK
Summary
Business Analyst with extensive experience in Dynamics NAV and Oracle Fusion integrations at Champion Home Builders. Developed Power BI dashboards that significantly improved decision-making processes. Recovered $200,000 in unbilled revenue through innovative analytics solutions, demonstrating strong project management and Agile methodology skills. Proven ability to implement business improvement strategies and oversee technology integration in competitive environments.
Overview
21
21
years of professional experience
Work History
Business Analyst
Champion Home Builders
Troy, MI
10.2023 - 05.2025
- Configured and maintained integrations between Dynamics NAV and Oracle Fusion, optimizing data flow and ensuring system interoperability for a large-scale manufacturing operation.
- Designed and deployed powerful Power BI dashboards for sales analysis, providing key stakeholders with real-time insights that boosted data-driven decisions.
- Managed the full software development lifecycle and use-case management using Azure DevOps, ensuring all project milestones were met on time.
Senior Business Analyst
OEConnection.com
Richfield, OH
09.2022 - 10.2023
- Led full-cycle implementations of Dynamics NAV and D365 Sales for over 20 multinational clients, managing project timelines and resources using Monday.com.
- Authored custom subscription billing analytics that led to the discovery and recovery of $200,000 in previously unbilled revenue.
ERP Consultant / ERP Business Systems Analyst
01.2004 - 01.2022
- Leveraged foundational experience in RDBMS and Database Development to become a strategic ERP consultant.
- Expert in pre- and post-implementation consulting, focusing on upgrades and custom integrations for clients using Dynamics AX, Solomon, Great Plains, and Navision.
- Developed comprehensive reporting and data migration solutions, and led implementations of key third-party add-ons for Manufacturing, EDI, and HR/Payroll.
Education
Some College (No Degree) - Undergraduate Studies
USAF Community College
Biloxi, MSSome College (No Degree) - Undergraduate Studies
College of Lake County
Waukegan, ILSome College (No Degree) - Liberal Arts
Trinity College
Deerfield, ILSome College (No Degree) - Undergraduate Studies
University of Maryland
College Park, MDSome College (No Degree) - Undergraduate Studies
Golf Coast Community College
Gulfport, MSVarious Military Certificates - : Technical Instructor, Fund Accounting, Office Ad
US Military SMART
Pensacola, FLSkills
- Dynamics Business Central
- Dynamics GP
- Dynamics SL
- Dynamics AX
- D365 F&O
- Oracle Fusion
- DAX
- PowerQuery
- SQL Server
- SSRS
- SSIS
- SSAS
- ETL
- Dynamics 365 Sales
- Power Platform
- Power Apps
- Power Automate
- Agile
- Kanban
- Waterfall
- Solution Architecture
- CI/CD
- DevOps
- Manufacturing MRP
- Field Service
- Warehousing
- Supply Chain
- SCM
- EDI
- HRIS
- Finance
- Microsoft Project
- Project Online
- Mondaycom
- C#
- NET Framework
- JavaScript
- Web API
- T-SQL
- XML
- HTML
- SOAP
- REST
- Lanham EDI
- eShip
- eReceieve
- WMS
- Distribution
Education Certifications
- USAF Community College, Biloxi, MS
- College of Lake County, Waukegan, IL
- Trinity College, Deerfield, IL
- University of Maryland, College Park, MD
- Golf Coast Community College, Gulfport, MS
- US Military SMART, Pensacola, FL
Technical Skills Matrix
Dynamics 365 CE, GP, NAV/BC, SL, AX/F&O, MS SQL Server, SSRS, SSAS, Power BI, DAX, PowerQuery, ETL, C#, .NET Framework, JavaScript, Web API, T-SQL, XML/HTML, SOAP/REST, Microsoft Project/Project Online, Azure DevOps, Git, Lanham EDI, Eship, Ereceive, Field Service, WMS, Distribution
Volunteer Leadership
Sunday School Teacher & Hallway Chaplain, Claremore First Methodist Church
Selected Achievements
- Led a migration from Adage Infor to Dynamics NAV, which improved overall order accuracy by 25%.
- Authored and developed over 50+ Power BI reports, which reduced data-retrieval time for key business stakeholders by 40%.
- Orchestrated a complex NAV to Oracle Fusion reconciliation process, decreasing financial and data discrepancies by over 95%.
Core Competencies
Dynamics NAV/Business Central, Dynamics GP, Dynamics SL, Dynamics AX/D365 F&O, Oracle Fusion, Power BI (Desktop/Pro/Gateway), DAX, PowerQuery, SQL Server, SSRS, SSIS, SSAS, ETL, Dynamics 365 Sales, Power Platform (Power Apps, Power Automate), Azure DevOps, Agile, Kanban, Waterfall, Solution Architecture, CI/CD, DevOps, Manufacturing MRP, Field Service, Warehousing, Supply Chain (SCM), EDI, HRIS, Finance, Microsoft Project, Project Online, Monday.com, Azure DevOps
Timeline
Business Analyst
Champion Home Builders
10.2023 - 05.2025
Senior Business Analyst
OEConnection.com
09.2022 - 10.2023
ERP Consultant / ERP Business Systems Analyst
01.2004 - 01.2022
Some College (No Degree) - Undergraduate Studies
USAF Community College
Some College (No Degree) - Undergraduate Studies
College of Lake County
Some College (No Degree) - Liberal Arts
Trinity College
Some College (No Degree) - Undergraduate Studies
University of Maryland
Some College (No Degree) - Undergraduate Studies
Golf Coast Community College
Various Military Certificates - : Technical Instructor, Fund Accounting, Office Ad
US Military SMART