Junaid Masood Email & Phone Number

Milton, On, Ca

Mississauga

• Executive Presentation – Conducted executive reviews with CTO, Tech VPs and Directors on monthly basis to provide an in-depth analysis on business financial performance, process efficiencies, cost containment and risk mitigation strategies and forecast dynamics• Planning & Analysis – Proactively managed quarterly forecast, annual budgeting, variance analysis and ad-hoc reporting to address changing business dynamics of four Business Units (BU). Process involved collaboration between management and executives to outline BU’s financial strategy, while ensuring company’s long-term objectives• Project Finance – Effectively analyzed and monitored various projects/CRs, including planning, prioritizing, budgeting, spend variance analysis, forecasting estimated cost to complete (ETC) in consultation with PMs, procurement and project resourcing• Project Lead – Managed a special project assignment as finance lead to integrate employee compensation from Lotus Notes to standalone Excel model. Excel model is being used by HR to calculate employee’s severance, vacation payouts, salaries and benefits, whilst adhering with minimum legal requirements• Financial Modeling – Self-initiative taken to develop an extensive excel based financial model, which exhibited dynamic P&L reporting, dashboards, scorecards, along with embedded capability of preparing live forecasting, annual budgeting & 7 year strategic planning. Excel based financial model not only consolidated various reporting templates, but also significantly reduced team work effort by more than 40%• Excel Coaching – Educated & Trained a group of 17 finance colleagues at various hierarchy levels on Microsoft Excel. Training included advanced Excel functions and financial modeling• Accounting – Competently managed desk level procedures related to month-end: Preparation and posting of adjusting JEs in Oracle, Balance Sheet reconciliation, asset impairments, technology charge-backs, P&L reviews and ad-hoc reporting

• Weekly Planning – Developed dynamic forecast model that analyses Trading Product group’s weekly, monthly, quarterly and annual P&L forecast against actual and budget plan. Performed comprehensive analysis to incorporate market volatility and risk associated with counterparty credit rating through valuation and offered recommendations to the senior management on anomalies.• Financial Modeling – A self-initiated project to create a $2.5 billion P&L model for Trading Products Group, which generated separate reports for executives and business managers based on their individual business needs. Dynamic and user-friendly financial model reduced report preparation time by 40%• Operational Efficiencies – Proactively explored options to optimize existing processes by transforming financial models, data templates, journal entries and by developing dynamic models for ad-hoc reporting

• Project Lead – Transformed Microsoft Canada’s telecom infrastructure by terminating redundant business lines and negotiating rates from different carriers via procurement. Effective communication between IT, procurement and telecom companies allowed for an after-tax cost savings of $152,000/year• Fund Manager – Managed $6 million Business Investment Fund that provides incentives to Microsoft partners. Accountability included setting policy guidelines, managing approvals and ensuring proper due diligence is in place. Recipient of CPE award in recognition of exceptional service • Financial Modeling – Created and managed a $2 billion Excel based P&L model that generated over 20 report views, customizable to each business segment with more accuracy and efficiency. Published reports allowed an in-depth analysis for both overall and at BU level for executive reviews

• Project Lead – Drafted flight plans by evaluating multiple flight schedules through sensitivity analysis to determine an ideal cost effective strategy for each station. In collaboration with engineering team, created an Excel based models to increase productivity in budgeting process. The fuel savings model prompted for more accurate and efficient budget preparation• Budget Plan – Prepared $500 million Air Canada Cargo’s budget by collaborating with business managers worldwide and then presented to the CFO and executives

Woodbridge, On

To budget, create and maintain mobile based SMS applications. Preparation of status reports and coordination among IT team and other stakeholders. Final product to be marketed and promoted through sales strategies

Certificate, Leadership Essentials

Bachelor'S Degree, Specialized Honors In Finance

Activities and Societies: Schulich Investment Club, International Students Mentorship, Community Services, Exams Proctor