SHAHID KHAN (CPA)
*** ****** ****** ***** **, Calgary, AB T3A 4Z5
Cell # 587-***-****, E-mail **************@*****.***
Profile:
Over 20 years of Business and Cost / Financial Analysis experience.
9 years of working experience in Project Controls in Construction / Mining & Nuclear industry.
Working experience on Ecosys, MS Project, Primavera P6, Power BI, Workday, Tempus & Maximo.
Bachelor of Commerce, Payroll Administrator, CMA, CPA.
Expertise in Accounting Principles, Cost Management, Forecasting/Budgeting, Financial statement.
Proven skills in Costing, Budgeting, Capital Asset, Process Improvement, Recon, Closing process etc.
Excellent Interpersonal, Organizational, Managerial, Time Management,
Excellent Written & Verbal communication skills.
Knowledge of Planning, Variance Analysis, Business Analysis, Enterprise Risk Management, etc.
Professional
Experience
Project Cost Analyst Jan, 2024 – Current
Canadian Fiber Optics, Calgary AB
Establish budget and cost control procedures to ascertain the tracking of all project cost.
Prepare Estimate in Ecosys based on RFQ’s, submit PCR, Change Control Forms (CCFs) and baseline it.
Monthly accrual & reversal entries, monthly forecast and analyze with budget and EAC.
Compare BAC vs EAC as well as Contingencies for the projects in Ecosys.
Prepare milestones as per P6 schedules and outages changes based on Vendors’ PO’s and baseline the deliverables in forecast and budget in order to update the EAC and compare with BAC.
Senior Project Controls Cost Analyst Jan, 2020 – Dec, 2023
Bruce Power, Tiverton ON
Prepared Estimate based on RFQ’s, submit PCR, Change Control Forms and baseline it.
Prepared CD Gates and funding milestones based on deliverables and analyze with Project team.
Discussed the Scope with project team to plan & develop schedules & Milestones in Primavera P6 and outages changes based on Vendors’ PO’s and baseline the deliverables in forecast and budget in order to update the EAC and compare with BAC.
Developed WBS & maintain resource-loaded schedule in P6 and baseline it.
Set up project controls systems (cost codes, project rules of credit).
Reviewed Risk Assessments and analyze COPQ’s (Cost of Poor Quality) to mitigate it.
Assisted management in monitoring performance related to program activities, budgets, projects, and key performance indicators.
Established budget, Forecast & post actuals and prepare Variance Analysis along with the causes of over/under Cost run and commentary for Management package.
Post Month-end accrual & reversal entries, actuals and compare with Forecast and EAC.
Compared BAC vs EAC as well as Contingencies for the projects and suggest cost, schedule and scope commitments.
Prepared project plan & Business Case Summary for all the units in order to finalize Project Execution Plan.
Prepared month-end Management package in Power BI and Statistical Reports for stakeholders including % completion Earned Value (EV) Reports and analyze the project performance.
Analyzed budget vs expenditures for each project and identify the cost overruns/under-spends so that project management can take appropriate actions.
Developed and maintain performance metrics and KPI, i.e., predictive reporting, statistical reports, and progress reports.
Monitored Project financial performance through ongoing reporting and maintenance of internal spreadsheets to track budget, actuals and forecast.
Supported annual Business Planning process through historical financial trend analysis, risk management assessment, Project Management engagement and data input.
Acquired benchmark information from internal and external sources to support performance improvement.
Contributed to project review meetings, as necessary, to monitor progress, identify problems, and initiate corrective actions.
Cost / Schedule Analyst Jan 2016 – Dec 2019
Kuehne & Nagel, Toronto
Analyzed Costs/Benefits for Projects. Identified variances and causes; recommend corrective actions and recommended on Financial Results. Prepared Management month-end package and Statistical Reports for stakeholders.
Prepared weekly and monthly Manpower Reports i.e., forecast vs. actual hours in order to analyze and show variance for Projects, Programs and Portfolios.
Prepared budgeting, forecasting and planning (Operational and Capital), including sanity check for reasonableness, analysis and recommendations regarding budget matters and uploaded in SAP and addressed all queries from Senior Management.
Monitored and reported for Management package and internal package for stakeholders.
Trained the finance team and designed internal control system and division of responsibility among staff members to the implementation of financial management systems.
Performed variance analysis to identify the actual results compared to the desired results and commentary on the causes of the variances.
Helped sales and marketing staff to define and track KPI’s with financial review of all major tenders, including profitability and any potential exposure to the business.
Revenue & Cost recognition with updated Bank reconciliation and GL reconciliation.
Prepared year-end financial schedules including supporting working papers for auditors.
Investigated and assist divisional cost variance quarries. Fix and suggest with Corrective Actions to mitigate variances.
Financial Analyst 2009 –2015
CNH Canada Ltd, Saskatoon
Prepared annual budgeting, forecasting and planning (Operational and Capital), including sanity check for reasonableness, analysis and recommendations.
Prepared Financial Models for projects, Department Budgets, Forecasts and Actual Variances.
Closely worked with Managers, review planning and integrate both qualitative and quantitative data into business analyses.
Financial Analyst 2002 – 2008
CIBC, Toronto
Participated in corporate business plans; design, implementation and maintaining business process tools, development of financial business systems, internal control implementation and SOX compliance.
Delivered commentary on monthly financial results. Compiled Management Package.
Prepared budgeting, forecasting and planning (Operational and Capital), including sanity check for reasonableness, analysis and recommendations regarding budget matters and uploaded in SAP and addressed all queries from Senior Management.
Designed Fixed Asset Schedule Continuity Sheet with Accumulated Depreciation schedule.
Ensured that the integrated systems being developed are producing journal entries that comply with IFRS, are mapped accurately to the GL, and are at the appropriate level of detail to enable automated financial analysis and reporting.
Participated in staff training related to the implementation of financial management systems.
Variance Analysis Reports to the Branch Manager identifying actual achievements compared to desired results, analyzing the causes of the variances
Auditor 1998-2001
Hameed Chaudhry & Co. Chartered Accountants (Pakistan)
Education
Certified Public Accountant - US (CPA Designation) 2007 - 2008
Associate Member of American Institute of Certified Public Accountants (AICPA)
Certified Payroll Compliance Practitioner (PCP) 2004 - 2005
Institute of Canadian Payroll Association
Diploma in Computer Science 2002 - 2003
Humber College, Toronto
Cost & Management Accountant (CMA Designation) 1996 - 2001
Institute of Cost & Management Accountants of Pakistan (I.C.M.A.P)
B. Comm. 1993 -1995
University of Karachi, Pakistan
Technical
Expertise
Memberships/
Affiliations
Thorough knowledge of:
-Ecosys, MS Project, Workday, Maximo, Primavera (P6), Power BI, SAP, Great Plains, ACON, Kronos, Day Force,
-QuickBooks, Simply Accounting, MYOB,
-Advanced Microsoft Excel and Access skills
-Lotus Notes, Outlook, AS 400
-
Working knowledge of:
-IFRS, Financial Accounting, Oracle Financials, Business Object Reports
American Institute of Certified Public Accountants (Associate Member)
Institute of Cost & Management Accountants of Pakistan (Associate Member)
References will be furnished upon request