Your browser is outdated!

To ensure you have the best experience and security possible, update your browser. Update now

×

John Madol

Financial Analyst at Hudson's Bay Company

Variance Analysis
Financial Forecasting
Accounting
Financial Modeling
Project Management
John Madol
Toronto Canada (Ontario)
Professional Status
Employed
Available
About Me
John is a creative and hardworking BCom graduate focused on growing professionally and achieving a long career in finance.
Resume created on DoYouBuzz
  • Creating Purchase Orders for capital projects, managing IT budgets, and providing financial analytical support to business owners on capital projects; compare actuals and trend analysis of forecast/spend. Perform analysis on ad hoc special projects, wire transfers, new vendor setup and respond to overdue invoice inquiries from vendors and internal stakeholders.
Detailed Description
  • • Accounting for IT capital & expense invoices received against respective budgets, obtaining
    appropriate approvals and ensuring
    timely processing by Accounts Payable (paid $15M monthly).
    • Assisting in capital planning process for both future capital spending and the evaluation of
    past capital projects.
    • Supporting preparation of month-end, quarter-end and year-end financial results, auditing
    line items and explaining variances.
    • Training HBC India associates on financial systems, policies, overseeing their work, and
    ensuring accuracy of our financials.
    • Helping clean up backlogged unpaid invoices by developing IT invoicing review fast track
    process, solicited management buy- in and trained offshore support team to implement it (an average
    of 600+ invoices a month).
    • Guiding project managers on HBC capital policies and accrual accounting principles in their
    project dealings with vendors,
    cross border contracts, spending limits, withholding taxes and legal business entities (Hudson’s
    Bay, Saks and Lord & Taylor).
  • Created financial models and priced new deals/bids for opportunities pursued by Accenture, and ensured those new projects met/exceeded forecasted financial targets by pricing expected risks into the contracts.
Detailed Description
  • Developed billable time tracking process guides and facilitated bi-weekly billable time submissions on Power BI for offshore project support teams to better track costs. ● Tracked each account sales forecast for different lines of work, and supported monthly sales booking and reporting. ● Worked with account leadership to develop annual budgets, forecasts and submitted annual financials to divisional finance leads and served as audit point of contact to address delivery related questions or revenue discrepancies. ● Performed monthly, quarterly and annual variance analysis on sales, revenue and other internal KPIs for each project and the overall account ($7M - $10M in revenue per account). ● Invoiced $500K-$1M monthly, monitored receivables followed up with clients directly and closed outstanding positions with the help of account leadership; reduced average outstanding receivables.
  • Created client profiles and updated clients’ statuses on Oracle's Siebel Global Case Management System and other databases
  • Analyzed, tracked and stored client applications with integrity and confidentially as required by government protocols
  • Reviewed applications and submissions as well as electronic records and applied program guidelines to request and analyze supporting documentation, where necessary, before making a decision on a case
  • Conducted qualitative and quantitative project research and presented the analyzed data to the lead consultant
  • Compiled comparative analysis of best practices among benchmark firms; practices incorporated into our project recommendations
  • Played different analytical roles in writing and contributing towards the final project report which was presented to the client
  • Analyzed and initiated the expansion of the filing system by presenting observations to the Registrar; recommendations adopted
  • Received guests and triaged issues at high volume reception desk, delivered mails to multiple departments
  • Performed clerical assignments, including integrating files of hundreds of newly admitted students into the filing system
  • Provided guided tours of University College and residences to incoming first year students, their families and other visitors
  • Helped Prepare and distribute leaflets to new students Answered queries about UC, student life and U of T academic programs
  • Market games on U of T campus through selling exclusive discounted merchandise and student tickets to home gamesRegistrar; recommendations adopted
  • Drive on campus awareness and recognition of the Toronto FC and other Maple Leaf Sports and Entertainment brands through the use of social media by collaborating with University of Toronto Students’ Union to reach more student