Shawn Brannigan
Brighton
Summary
Data and Power BI analyst with a track record of turning messy data into clear insights that drive action. I like solving real problems, improving processes, and building reporting that teams can rely on.
Overview
4
4
years of professional experience
Work History
Sr. Business Analyst
Kem Krest
Brighton
01.2025 - Current
- Created four Power BI dashboards to enhance Finance, Supply Chain, Operations, and Logistics processes.
- Initiated 'Business Analytics and Automation Team' to accelerate technical capabilities company-wide, with a heavy focus on AI integrations.
- Supported FP&A management in constructing the 2026 budget.
Financial Analyst
Kem Krest
Brighton
05.2022 - 01.2025
- Developed 'Profit-by-Program' PowerBI dashboard for real-time program-level accounting analysis.
- Created Budget vs. Actual spend PowerBI dashboard for department managers to effectively oversee budgets.
- Automated multiple Finance processes, including Accounts Receivable payment matching and freight accruals.
- Streamlined Cost Analyst price change process and sales tracking by part through automation.
Finance Intern
Kem Krest
Brighton
01.2022 - 05.2022
- Automated inventory walkout process, improving PPV process by 1-4 days.
- Served as interim Inventory Control Analyst. Created automated drop-lists, generated safety stock reports, and conducted DC walkthroughs.
Education
Bachelor of Science - Economics
University of Michigan
05-2020
Skills
- Power BI
- AI
- Data analysis
- Financial modeling
- Process automation
- PowerQuery M
- SQL
- Power Automate
References
Justin Chouinard
MS Business Applications Developer
thyssenkrupp Aerospace
-
Byron Emick
Director of Finance
Kem Krest
Timeline
Sr. Business Analyst
Kem Krest
01.2025 - Current
Financial Analyst
Kem Krest
05.2022 - 01.2025
Finance Intern
Kem Krest
01.2022 - 05.2022
Bachelor of Science - Economics
University of Michigan