Marshall Shine, CPA

Professional CPA with diverse experience in IT and accounting

Experience

Technology Assurance Audit Associate

KPMG

Jan. 2024 - Present

Conducted comprehensive IT audit testing for Sarbanes-Oxley and SOC engagements, focusing on security, data integrity, and control environments. Created Power BI dashboards to track project progress, analyzed complex datasets for testing, and synthesized technical findings into strategic executive-level reports. Managed audit lifecycle with effective scheduling and budgeting to meet hard deadlines.

IT Support Specialist

Missouri State University

Aug. 2021 - Dec. 2023

Delivered comprehensive IT support, including rapid troubleshooting for classroom technology, managing hardware rollout projects for faculty and staff, and conducting data migration and user training. Maintained detailed documentation of technical issues and resolutions in Jira ticketing system.

Projects

Financial Statement Dashboard

Power BI, SEC's EDGAR Public API

Developed a Power BI dashboard for financial analysis, leveraging the SEC's EDGAR API. Utilized M Language for complex data transformations, created custom DAX measures, and built interactive visualizations with filtering capabilities. Automated ETL processes to enable direct API connectivity and standardize financial data across multiple companies.

View Here →

Skills

Hard Skills

Data Analysis & Visualization

Power BI, Advanced Excel (Power Query, M Language, Pivot Tables, X/VLOOKUP)

Programming & Query Languages

SQL (Primarily MySQL), Python, Java

Productivity Software

Microsoft Office Suite (Advanced)

Data Cleaning & Transformation

Connecting to data sources, cleaning data, and transforming data to be used in reports

Soft Skills

Public Speaking and Presentations

Problem-Solving and Technical Troubleshooting

Written and Verbal Communication

Project Management

Delegation and Collaboration

Education