Andrew H.

Project Clerk (Oil & Gas) @Ceda

Edmonton, AB, CA

Analyzed 6 regional invoice datasets (10+ years) using Python and SQL, working with a 14-person finance team — built a Power BI dashboard that resolved $50K+ in billing delays. Automated reporting in Power BI, reducing prep time from 8 to 3 hours — supported monthlyplanning and KPI reviews for 5 department managers. Collaborating with accounts payable and IT to resolve data quality issues in Dynamics AX— performing manual ETL processes — reducing vendor payment cycles from 45 to 30 days. Processing $100K+ in daily invoices with 99% accuracy — ensuring clean data and timelyreporting across finance and operations teams.Tech stack: Python (Pandas, NumPy), SQL (PostgreSQL), Power BI, Excel, Microsoft Dynamics AX, Git