Shahrukh Khan, CPA

Experience

• 

  The Source

  Oct 2013 - Mar 2014

  Assistant Manager

  Rapidly progressed to this role of increasing authority due to excellence in customer and relationship building. Train store staff by reviewing and revising orientation to products and sales training materials; delivering training sessions, reviews staff results, learning the needs of store manager; developing and implementing new product training. Procured inventory based on emerging products, anticipating buyer interest, negotiating volume price breaks, pacing and expediting orders. Prepared reports on sales, customer relations, and budgets. Recruited and trained peers.***Value Added***✔Rated as the highest achiever across all the stores in Ontario, broke all previous sales records in the store. ✔Thrived to deliver outstanding customer service by satisfying customer needs.✔Ensured every transaction is recorded and represented with utmost integrity and professionalism. Show less

• 

  Opta Minerals Inc.

  Mar 2014 - Aug 2015

  Accountant

  - Bank reconciliations in domestic and foreign currencies, monitor and hedge F/X fluctuations, transaction validations and proper tax reporting through reporting and reconciliation of GST/HST returns - Analyzed data and prepared documentation for monthly/quarterly/yearly reporting; posting valid and accurate journal entries to expense accounts and accrual accounts, such as prepaids and miscellaneous G/L accounts, for completeness and existence. - Review and approve suppliers’ invoice coding and data entry for reliable AP reporting - Special pricing protocols that include entering and validating accurate price data for each inventory item for a given location; taking into account f/x and current economic data - Validating and processing credit notes requested by vendors along with physical inventory returns to manufacturing locations - Analyzed general ledger, such as freight accounts, clearing accounts, accruals, and presented an analysis on variances while following up with a recommended implementation plan to mitigate these variances - Conducted inventory counts, determined volume variances and performed an analysis to show discrepancies and any recommendations to bring it to a company standard threshold - Assist in creating a financial model, using excel and macros, that utilized company’s current cash position - Assists in audit schedule setup, preparation of audit-related packages and various ad-hoc projects Show less

• 

  Holt Renfrew

  Sept 2015 - May 2016

  Financial Analyst

  - Assist Finance team in regression testing, UAT Testing and validations of action items in E-commerce Project, Purchase Order Project and Year-End Schedule- Review, prepare and reconcile inventory accounts; create, review and prepare variance analysis to explain discrepancies and recommend corrective actions- Prepare and reconcile general ledger and P&L accounts and present a variance analysis with recommended corrective actions- Conduct thorough analysis of inventory/product at a transactional level, devise cost allocation methodologies and execute said allocation in a timely manner for reliable financial reporting; while adhering to corporate and regulatory requirements- Improved the focus of stakeholder value by investigating vendor agreements and providing an analysis for a more unified business practice- Month-end duties included journal entries, adjusting entries, reconciliation, review of accounts, transfer cancellations, discrepancy reports, freight analysis and consignment reports, etc.- Reviewing and reporting Stats Can reports such as the Retail Commodity reports, Retail Monthly sales summary reports by division, store and consolidated, Retail Food Survey reports and quarterly survey of financial statements- Creating templates for sales summary for particular stores and divisions while doing a historical comparison between related periods to show % changes and facilitate decision making process- Implement advanced macro functions to automate management generated reports - Establish inventory count schedules per division for a given year schedule- Establish process improvement procedures related to vendor agreements, inventory planning, analysis of financial accounts and IT-based solutions to inventory tracking - Ad-hoc projects; utilizing SQL to retrieve financial information from databases for C-Suite presentation, invoking grants on sales models for security, and creating/updating sales models through SQL queries and Macro tracking Show less

• 

  The Home Depot Canada

  Aug 2016 - Feb 2018

  Senior Financial Analyst - Commercial Finance

  Analyzed, executed and managed the financial forecasting and planning of sales, margin and inventory for FY 2016, 2017 and 2018 with an accuracy level of +/- 10% and providing an in-depth variance analysis of actuals to forecast and planPlanning and budgeting a >$1.0B portfolio for FY 2017 from the bottom up to calculate sales, margin and inventory trends on a weekly/monthly and quarterly basisReview, analyze and validate cost benefit analysis on various capital initiatives ranging from product replacement to adding a new product lineConsolidate and present findings on sales, GM and inventory trends on departmental portfolio (Internal and External Metrics) to senior leadership team and business partners for the purpose of strategizing on business decisions and driving metricsConstruct, manage and report cost related inquires, such as cost reduction, conditions and comparison (between vendors), to determine the impact of micro/macro-economic trends and inter-departmental cost transfers on businessManage and execute financial models that present details on clearance products throughout the portfolio and highlighting a recommended strategy to exit them by calculating relevant pricing decision and Gross Margin impact; standing at over a +90% threshold of metric.Maintain a professional relationship with internal (including cross-functional departments) and external stakeholders (Product vendors and Hydro organizations) to effectively run the financial landscape of the portfolio and providing any ad-hoc support when needed Show less

• 

  Bell

  Feb 2018 - May 2021

  Responsible for the amalgamation of financial reporting data; used for analysis of performance versus Plan and/or Forecast related to the Bell Business Markets financial results (P&L, Key metrics)Responsible for developing and maintaining benchmarking and industry / competitive analysis.Managing the month-end results reporting consolidation process for all of BBM’s line of Businesses, including modelling and preparation of corporate submissionsBuilding clear and insightful reports from financial systems in support to the financial analysisMaintaining BBM’s financial system (SAP BI and BPC) and be the primary point of contact across BBM FinancePerforming financial analysis in context of financial resultsTaking an active role in the preparation of BBM monthly financial results reporting packageWorking with cross-functional teams on ad-hoc projects and process improvementAssisting with analysis and reporting to the investor relations teamAssisting with special requests from the executive team or from corporateAssisting with developing and maintaining industry leading Business Intelligence for Bell Business Markets, including benchmarking analysis using market and competitive intelligenceImproving the financial reports reliability, accuracy, and clarity and production time Show less

  • Senior Finance Manager - Business Wireless

    Oct 2020 - May 2021

  • Senior Finance Manager - Revenue Assurance/ COGs/Analytics/Special Projects

    Nov 2018 - Oct 2020

  • Finance Manager - Strategy Finance

    Feb 2018 - Oct 2018
• 

  Walmart Canada

  May 2021 - Oct 2022

  Senior Finance Manager, Regional Operations OMNI and Real Estate
• 

  Quest Window Systems Inc

  Oct 2022 - now

  Director of FP&A