Project Analyst - Financial Reporting & Cost Control

DHRUV PATEL

Calgary, AB 306-***-**** **************@*****.***

FINANCIAL ANALYSIS OPERATIONS FINANCE REPORTING

PROFESSIONAL SUMMARY

Project Analyst with 5 years of experience supporting financial reporting, cost control, forecasting, and invoicing across construction and energy-sector work in Alberta and British Columbia. Advanced Excel skills, strong Power Query experience, and Power BI proficiency, supported by hands-on work with SAP and operational project systems. Experienced in investigating cost variances, validating billing data, reconciling material usage, and partnering with operations and Finance to improve reporting accuracy. Bachelor of Commerce with additional education in accountancy and finance.

CORE SKILLS

Financial and operational analysis • Month-end reporting support • Budget and forecast variance analysis • Cost tracking • Invoice preparation and validation • Operational data accuracy • Material usage reconciliation • Reporting automation • Process improvement • Cross-functional collaboration

TECHNICAL SKILLS

Analytics: Advanced Microsoft Excel, Power Query, Power BI, PivotTables, lookup formulas, data validation, forecasting models, dashboards, and large-data review.

Business systems: SAP, Vitruvi, Smartsheet, Primavera P6, JIRA, and Microsoft Office.

PROFESSIONAL EXPERIENCE

Strategic Oil & Gas Ltd Calgary, AB

Project Analyst

Maintain financial and operational records covering budgets, forecasts, actual costs, commitments, labour, equipment, materials, subcontractor costs, and invoice status across active work packages.

Prepare cost summaries and monthly and quarterly forecasts; compare budget, forecast, and actual performance to identify variances, emerging cost risks, and non-billable exposure.

Validate work tickets and invoice supporting documents against scope, completed quantities, approved rates, cost allocation, and approvals to support accurate billing and Accounts Payable processing.

Reconcile material usage with forecasts and allocations; coordinate with Materials, Procurement, Construction, and Finance to investigate differences and resolve outstanding requirements.

Consolidate field updates, quantities, and cost impacts into management reports, keeping operational activity aligned with financial records and supporting timely decisions.

Document scope, quantity, and rate changes; maintain traceable cost records and approval packages while coordinating competing priorities with Project Managers and Finance.

AFL Global Calgary, AB

Junior Project Analyst, Finance

Supported financial reporting and project controls across four Alberta and British Columbia regions, maintaining accurate cost, forecast, material, billing, and production information.

Analyzed labour production, subcontractor costs, materials, unit rates, budgets, and actual costs; investigated variances with Project Managers and operations teams and coordinated corrective updates.

Prepared cost summaries, forecasts, and leadership and client reports to support month-end stewardship, financial control, and operational decision-making.

Prepared and validated invoices by confirming completed quantities, approved rates, billable scope, project coding, and supporting documentation; resolved discrepancies with Finance and project stakeholders.

Maintained project data and reporting using advanced Excel, Power BI, SAP, and Vitruvi; corrected inconsistencies to keep operational records and financial information aligned.

Reviewed scope changes, subcontractor costs, revised quantities, and non-billable exposure to support change approvals and visibility into project financial performance.

Automated quotation, reporting, and invoice-validation workflows, reducing processing time and errors by an estimated 50–70%.

AFL Global Calgary, AB

Project Coordinator

Supported engineering and field-construction teams with cost tracking, budget maintenance, forecasting, invoicing, procurement documentation, and cross-functional follow-up.

Prepared monthly material forecasts and quarterly departmental forecasts to support purchasing, resource planning, budget visibility, and cost control.

Reconciled forecast and actual material usage, construction quantities, project costs, and commitments; investigated discrepancies and coordinated corrective action.

Validated quantities, rates, cost allocations, and invoice backup before billing; built a standardized Smart sheet material-ordering process to improve tracking and accountability.

EDUCATION AND PROFESSIONAL DEVELOPMENT

Bachelor of Commerce — India

Diploma in Accountancy and Finance — St. Martin’s Business School, United Kingdom

Diploma in Project Management — Brooks College, Calgary

Google Data Analytics Professional Certificate

Project Management Professional (PMP) — Studies in Progress

Contact this candidate