Shayan Afzal Email & Phone Number

Mississauga, On, Ca

Mississauga, Ontario, Canada

Key Accomplishments: - Developed a Percentage of Complete (POC) analysis model to extract project data from disparate systems, enhancing month-over-month revenue tracking and financial forecasting.- Integral member of the Reporting and Analytics Development team, focused on collecting and streamlining data across international divisions to improve decision-making and operational efficiency.- Set up a process for analyzing and forecasting deferred revenue, that helped identify… Show more Key Accomplishments: - Developed a Percentage of Complete (POC) analysis model to extract project data from disparate systems, enhancing month-over-month revenue tracking and financial forecasting.- Integral member of the Reporting and Analytics Development team, focused on collecting and streamlining data across international divisions to improve decision-making and operational efficiency.- Set up a process for analyzing and forecasting deferred revenue, that helped identify trends that helped maximize YTD revenue.- Built cost analysis infrastructure using VBA to provide real-time job costing insights.- Built an automated sales backlog analysis system using VBA that helped track down delays and helped maximize revenue. • Support Financial Controller and International accountants on month-end financial analysis for multiple divisions and projects.• Prepare proforma analysis on potential new deals.• Conduct calls with project managers to monitor project progress.• Monthly analysis of project revenue, expenses and earnings.• Preparation of project P&L, Forecast/Budgets and variance analysis.• Oversee the monthly billing function with the billing team.• Assist with the implementation and enhancement of month-end closing procedures. Show less

Education record

Honors Bachelor Of Business Administration (Bba)

Bachelor Of Arts (Ba)