Aileen P.

Senior Financial Analyst @McKinstry

Seattle, WA, US

Optimized and automated a KPI spreadsheet with SQL and PowerQuery improving speed and accuracy by 50%.* Build SQL lite queries used by multiple departments for reports, integrated with excel.* Built KPI dashboard in PowerBI used by the entire organization to monitor unbooked contract amounts & billings.* Reduce revenue recognition errors by 50% by leading monthly meetings with business unit managers, fixing and investigating errors, and reviewing with the CFO.* Build automated reports using SQL lite, and VBA to reduce variance research by 95%.* Responsible for full job cost & WIP close at month-end, preparing and posting adjusting journal entries and research variances.* Built and run job cost and WIP reconciliations monthly, research root-causes of variances, clean the data, report material variances* Quality control of all change orders, balancing back against complex multi-million dollar contracts for clean audit control

Saint Martin's University

Bachelor of Arts - BA

Western Governors University

Bachelor of Science, Computer Science

Seattle Pacific University

Master of Business Administration - MBA, Data Analytics

Launch School

Computer Software Engineering