Business System Specialist

• Apr 2019 - Present

Senior Finance Manager

• Dec 2015 - Apr 2019

Finance Manager for the Sarjeant Asphalt division.Certified Jet Reports SpecialistFinance Manager for The Sarjeant Companies land development division.NAV system specialist.

NAV Implementation Specialist

• Feb 2015 - Apr 2019

I am helping The Sarjeant Co. Ltd. renew it's instance on Microsoft Dynamics NAV in anticipation of an upgrade to a current version. I have employed my MS Access and MS Excel skills to clean up the Customer base and the Item processes within NAV.

Senior Manager NAV Implementation and Support

• Jan 2012 - Nov 2012

I managed the seamless data migration from SAP to Microsoft Dynamics NAV and ensured FAS 52 Foreign Currency compliance. I also supported and responded to regional control teams regarding Foreign Currency inquiries. I designed JET reports to support external reporting and audit schedules. I modified and maintained the ACCESS database in order to track account reconciliations in NAV.--I developed an audit report to verify the Foreign Exchange impact on financial statements.--I project managed the migration of data containing 70+ legal entities from SAP to Microsoft Dynamics NAV.--I wrote complex reports using JET reporting in NAV.--I successfully launched a new global finance system in less than 4 months, on time and on budget.

Senior Finance Manager SAP Support

• 2007 - 2011

I was responsible for confirming the proper foreign exchange functionality of SAP. I spearheaded the process to streamline the foreign exchange reporting procedure for SAP by developing and then running a detailed Access Database monthly. I provided expert feedback to the global finance community regarding how to best document and correct foreign exchange reporting issues. I revised month-end close procedures to process foreign exchange jobs. I also served as Account Reconciliation Coordinator for all Canadian and Latin American companies.--I revised the foreign exchange close process, reducing the total processing time from 8+ hours to less than 2 hours.--I corrected SAP foreign exchange reporting deficiency by developing a detailed Access model to report integrated global foreign exchange results in a more streamlined format. This resulted in more consistent regional submissions of quarter-end reports being prepared in much less time.--I developed an Access database to effectively track Canadian and Latin American account reconciliations. We were then able to deactivate the outdated, more expensive Legacy system. --I repaired a critical opening balance conversion issue that caused account reconciliation difficulty by accurately processing corrected/updated entries in a parallel GL.

Senior Manager Finance Transformation

• Apr 2005 - May 2007

As a member of Finance Transformation project team, I was responsible for implementing SAP on a global scale. I created new, simplified global chart accounts for SAP. As the Data Conversion Lead, I managed the Oracle data extraction and input and verification process of opening SAP data. I collaborated with department leaders to develop a global close calendar for SAP.--I simplified the chart of accounts, reducing the number of accounts by 50% by teaming with multiple members of the finance organization and linking results directly to published financial statements.--I successfully executed and documented the conversion of Oracle data to SAP within the projected timeline using Access database conversion tools.--I created a more efficient global close calendar. --I spearheaded data cleansing activities prior to the conversion.

Manager Financial Planning and Analysis

• 2003 - 2004

I maintained oversight over forecasting the corporate-wide Global Consolidated Balance Sheet. I designed and built the forecasting model utilized for tracking and monitoring cash flow to assist the Treasurer with future cash planning.--I developed an Excel cash flow model for receipts and disbursements by collaborating cross-functionally with the Accounts Payable, Accounts Receivable, and Treasury teams globally.--I participated in monthly executive cash committee meetings with senior executives and presented the current cash forecast. This involved documenting inputs from the executive team to keep forecast models updated.--I created an Excel model to validate goodwill balances for an audit of financial statements.--I consolidated and produced a detailed quarterly balance sheet forecasts for the executive team.

Finance Manager Corporate Services

• 1999 - 2004

I supervised up to 14 Direct Reports and provided finance support to multiple corporate entities, including Human Resources, Nortel Ventures, and Corporate Services. My responsibilities included monthly results reporting and conducting presentations to leaders in charge of managing various corporate functions. I performed the quarterly consolidation of forecasts for the consolidated corporate budget and views. I supervised staff and oversaw goal setting, communicating/delegating responsibilities, salary planning, and performance evaluations.--I planned finances to establish a global centralization of HR function.--I provided finance support to arrive at mutually beneficial labour negotiations with the Canadian Auto Workers (CAW).--I leveraged my financial expertise to facilitate an HR budget reduction from $750M USD to $100M USD over 2 years.--I performed Excel modelling to consolidate various entities throughout the company.

Senior Financial Analyst

• 1994 - 1998

I analyzed monthly Canadian market results for multiple enterprise products. I prepared annual budget submissions with quarterly updates for the global marketing team. I provided financial support to the entire executive team of Nortel North America. I consolidated annual budget submissions from various Nortel North America product and marketing teams, also consolidated quarterly budget view updates throughout the year. I prepared monthly results for the senior management team, and reconciled accounts and SQL queries. I monitored all internal controls of the payroll system.--As Senior Financial Analyst, I assumed the increasing responsibilities of the role designated via the Leadership Training program.--I conceptualized the pricing model for the Companion product line.