Manager Financial Analyst

Professional Profile

A results-oriented team player, quality-driven professional with extensive experience in corporate reporting, and financial analysis; strong technical and analytical skills, dedication to organizational goals and objectives.

Core Competencies

● Financial and Strategic Planning ● Advanced Excel Modelling ● Problem solving

● Financial Reporting Systems ●Analytical Thinking ● P&L Management

● Knowledge of IFRS and GAAP ● Training and Development ● Initiative

● Inventory Management ● Supply Chain Operations ● Valuation Reserves

TECHNICAL SKILLS

●Microsoft Office (Word, Excel, Access, PowerPoint, MR Project, Outlook & Visio)

●Excel Advanced formulas (Examples Pivot Tables, SUMIFS, SUMIF, INDEX MATCH, VLOOKUP)

●Oracle Hyperion Planning 11, Strategic Finance and Essbase Administration

●ERP JD Edwards, PeopleSoft A/P, G/L, COA, CDW, MDW, GMAIL, Google sheets, Adobe Acrobat

WORK EXPERIENCE

Sears Canada Inc. Toronto ON July 2000 – Jan 2018

Sears Canada Inc. is an Omni-channel retailer that offers quality merchandise and services to the Canadian consumer at affordable prices.

Manager, Finance Systems & Infrastructure Sep 2017 – Jan 2018

●Maintained and administered Hyperion Essbase for Financial Reporting

●Analysis to support business by Hyperion Essbase cubes, data loads, reports & scripts

●Reconcile data between PeopleSoft Financials and Hyperion Essbase Reporting

●Month End Reconciliations and Chart of Accounts maintenance

●Provide Training and ad hoc requests as needed

Merchandise Financial Planning Jun 2015 – Jun 2017

●Provided leadership and direction to team members in executing category buying plans and providing effective service and support to senior level to ensure achievement of category goals

●Developed monthly sales forecast and Annual Budgets, analyze plans prior to submission and prepare summary analysis and commentary for Senior Management review

●Forecasted weekly, monthly P&L and variance analysis for executive review

●Perform bottom up financial plan ($ and units) in partnership with operations

●Tracked key divisional performances such as sales, direct margin, discounts, inventory turns, cycle time, and analyze results to identify opportunities for improvement

Manager Corporate Reporting: May 2013 – Jun 2015

●Manage reporting team to support analysis & business decisions for system testing & implementation

●Co-ordinate between business teams’ requirements and criteria for UAT testing to approve completion

●Implementation team for Oracle Hyperion 11 Challenged with organizational changes leading to roll out for HFP and HFP for Finance

●Provide criteria for UAT, investigate accounting detail in legacy systems migrating to new (RIM to JD Edwards)

●Responsible for developing models reports and templates to improve processes of business teams

●Lead teams by making data available to deliver reports for management decisions

Manager Financial Planning: Apr 2012 – May 2013

●Maintain Sales, GP and Inventory Forecasting

●Formulated what if scenarios and analytical models to identify business opportunities and mitigate risk

●Reporting & Analysis training to staff to support planning business decisions comply with IFRS

●Achieved demanding deadlines for merchandise team line reviews by automating and centralizing reports for all planning teams. This allowed consolidation

Financial Analyst, Merchandise Support: Aug 2006 – Apr 2012

●Responsible for aged inventory reserve & source revenue valuation model’s GAAP/IFRS

●Automated complex models and process to improve month-end close to 3 days from 7

●Tested system fixes and upgrades and provided design specifications to system programmers.

●Communication with external and internal auditors regarding quarterly & yearend audit

●Provide auditors with support for journal entries & business rationale on annual variances

●Calculated, analyzed Inventory reserves for IFRS and U.S. GAAP.

Process Improvement Manager Finance Reporting: May 2005 – Jul 2006

●Documentation of processes leading to creating test scripts for UAT testing for process change and audits

●Performed process improvement activity on a project basis, ensuring efficient and effective processing of financial activities.

●Provide auditors with support for journal entries & business rationale on annual variances

Financial Analyst Reporting Systems: Jul 2000 – May 2005

●Prepare journal uploads for corporate accounting functions

●Tested system fixes and upgrades and provided design specifications to system programmers.

●Essbase administration created cube for managing projects and marketing retail ads expense

Education:

●Project Management Institute (In-progress PMP) 2018

●Oracle Hyperion 11 Planning training 2014

●Hyperion Solutions Hyperion Administrator 2000

● Centennial College Business Administration 1998

- Accountant Programmer Analyst Co-op

- Associate CGA member - credits received

Contact this candidate