Aileen P.

Experience

1. Senior Financial Analyst

   McKinstry

   Jul 2021 — Present · 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

Education

• Saint Martin's University

  Bachelor of Arts - BA

  2006 — 2010

• Western Governors University

  Bachelor of Science, Computer Science

• Seattle Pacific University

  Master of Business Administration - MBA, Data Analytics

  2019 — 2023

• Launch School

  Computer Software Engineering

Skills

• E-Payments
• Debit Cards
• Risk Management
• Merchant Services
• Payment Systems
• Finance
• Financial Analysis
• Payment Gateways
• Accounts Receivable
• Acquiring
• Salesforce.com
• Payment Card Processing
• Staff Supervision
• Fraud Detection
• Payment Services
• Financial Reporting
• Account Reconciliation
• Payments
• Gift Cards
• Supervisory Skills
• General Ledger
• Credit Cards
• Financial Risk
• Transaction Processing
• Electronic Payments
• Ach
• Accounting
• Relationship Management