(208) 555-0192 ◇ Meridian, ID
winifred.aoki@example.com ◇ linkedin.com/in/winifred-aoki ◇ winifredaoki.com
Financial Analyst with 8 years whose Excel depth is the reason the models get trusted. Built the driver-based forecast model now used across a $220M business, replaced 14 manual reports with 3 refreshable workbooks saving 60 hours a month, and cut a recurring reporting error that had misstated margin by up to $400,000. Holds the Microsoft Office Specialist Expert certification and has taught 90 colleagues.
Minor in Information Systems; coursework in Financial Modelling, Statistics, and Database Fundamentals.
Scored 964 of 1000; also holds a financial modelling and valuation certification earned in 2022.
- Own financial modelling and reporting for a $220M business across 5 product lines and 3 sites.
- Built the driver-based forecast model now used company-wide, which improved forecast accuracy from 76% to 93%.
- Replaced 14 manual monthly reports with 3 Power Query workbooks, saving about 60 hours of preparation a month.
- Produced monthly reporting and variance analysis for a $90M business, covering 9 cost centres.
- Found and corrected a formula error in the margin report that had misstated results by up to $400,000 in a single month.
- Built a 2,000-row pricing model with scenario switching that the commercial team used for 40 customer negotiations.
- Reconciled about 900 transactions a month and prepared supporting schedules for the monthly close.
- Automated the expense allocation workbook, cutting a 6-hour monthly task to 20 minutes.
- Rebuilt 12 legacy spreadsheets with structured tables and named ranges, removing 40 hard-coded values.
Driver-Based Forecast Model. Built a forecast model tied to volume, price, and mix drivers with documented assumptions and a scenario switch. Forecast accuracy rose from 76% to 93%, and the model is now the company standard across 5 product lines.
Reporting Automation. Replaced 14 hand-assembled monthly reports with 3 Power Query workbooks refreshing from the source systems. Preparation time fell about 60 hours a month, and month-end reporting stopped depending on one person being available.
Model Audit Standard. Wrote a checklist covering formula consistency, hard-coded values, input separation, and error trapping after a live error misstated margin. Applied across 20 recurring workbooks, it has caught 9 further errors before publication.
- Teach a free monthly Excel workshop at a community centre for 20 to 30 small business owners.
- Answer questions in an online spreadsheet community of about 40,000 members, posting several times a week.
- Volunteer treasurer for a Boise arts nonprofit, maintaining the books on a $180,000 annual budget.
- Trained 90 colleagues across 12 sessions on Power Query and model integrity practice.
- Set the workbook standard the finance team builds to, covering structure, documentation, and version control.
- Mentor 3 analysts, 2 of whom now build and own their own forecast models independently.

.webp)



.webp)


%20Which%20Should%20You%20Use.webp)