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.
• 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.
• 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.
• 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.
• 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.
• 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

• 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.
• 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.
• 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.
• 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.
• 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.

• 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.
• 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