ERP, Implementation, Finance & IT project delivery and coordination

Professional Summary

Innovative, detail-oriented problem solver with years of proficiency in extraction and manipulation of financial data from BI tools and various report writing. Experienced in forensic analytical work for large corporate entities, government organizations and NPOs. Recognizes the importance of working collaboratively whilst also using initiative thinking independently in the workplace. 6+ years’ experience managing multiple teams for projects, demonstrating a robust approach to solving complex problems and the agility to adapt to new ways of working.

Skills

Project procurement expertise.

Expertise in QuickBooks, Oracle, SAP and NetSuite

Budget analysis and financial reporting

Advanced Powerpoint, Excel and Access skills

Project cash flow analysis and forecasting

Full cycle project management incl remotely

Shopify admin with product cycling and pricing.

Implementing ERP systems and processes.

Improving and managing departmental and project processes

E-commerce and 3PL project and processes.

Project Software: JIRA, Salesforce, Trello, Asana, Kanbanize and Scoro.

Work History

ERP Finance and E-commerce specialist (Consultation) 08/2021 to Present

The Royal Conservatory of Music – Toronto ON

• Integration of E-Commerce platforms and supported applications with the ERP system as they impact

financial, reporting and tax related transactions

• Establish, liaise, and leverage relationships with solution providers and other external partners

• Establish relationships with business and IT leaders to understand the strategic direction of the

enterprise.

• Work closely with the IT infrastructure team to monitor the performance and uptime of the ERP system

• Acts as the Finance Departments' ERP operations Subject Matter Expert

• Proactively plan and implement ERP system upgrades and patches.

• Participate in ERP system development projects to extend functionality needed by business units

• Proactively plan and implement ERP system upgrades and patches.

• Administration of Shopify platform and its integration with warehousing systems with Propack and

Ryder.

• Managing the product lines and tuition programs on Shopify for both US and CA sites.

• Implementing and testing for new warehousing Propack phase 1.

• Working with third-party process partners Vlomni for Navision and Cloudsnap for Concur.

• Administration of Concur and its integration with NAV via Cloudsnap partner.

• Support the Finance Team system needs and requests, as well as prioritizing tasks as directed by the

Controller

• Designing reports using Jet Reports for business use.

NetSuite Consultant (Consultation) 10/2021 to 02/2022

War Child Canada– Toronto ON

• Implemented wave 1 for NetSuite ERP.

• Mapped data to templates for donors, grants and programs.

• setup users in both NetSuite and Sandbox environments.

• Mapped BMT classes for each country office's programs for different donor reporting.

• Worked on the chart of accounts mapping with the finance team.

• Set up employee templates for HQ and country Offices with HR.

• Worked with the grants team for mapping each grant and program to the templates.

•Coordinated on deadlines for the project with the NetSuite team.

Senior Finance Project Manager / US Sales Tax Manager (Consultation) 11/2020 to Present

AutoData Inc (SAAS Company) – London ON

Implemented wave 1 for NetSuite ERP.

Mapped Fixed Assets from Dynamics Nav to NetSuite.

Tested the scripts in the UAT working with Deloitte.

Designed reports in NetSuite using analytics and script suite.

Worked on implementing Sales Tax for the USA for different products and bundles.

Designed the sales tax matrix for UAT using Avalara database.

Implementing Wave 2 integration and training for Salesforce.

Filing for sales tax where the company has a nexus and meets the threshold on products sold in the individual US states and for Canada.

Reconciled Sales tax to Avalara for filing and journals to move taxes to correct GLs.

Mapped product SKUs for AutoData and subsidiaries to Sales Tax map for the US.

Created reports in Coupa and OpenAir for project expenditure, form 1099 & W2 for US and T-2200 for Canada.

Maintaining the product database mapping with correct definitions and sales tax code mapping from Avalara.

Reduction in reporting requirements by 30% by coordinating the evaluation of input and deliverables for multiple finance processes.

Trained members of the finance team in NetSuite report usage and customization of list searches.

Acting Accounting Manager (Project Contract) 12/2019 to 11/2020

Teranet Inc (SAAS Company) – Toronto

Provided Managerial support to the AR and Billing teams; for the implementation of a new ERP system Workday.

Chaired weekly status meetings to management, including progress and action plans for addressing risks/issues/changes.

Reduced the errors and time taken for the month-end close period during COVID; by cross training the teams and enabling inter-company communications on the critical bottlenecks during the month-end.

Lead the effort to change how cash collection from customers handled due to the sensitive nature rising from the COVID situation.

Supervised a team of ten staff divided into AR and billing for four different entities; provided them with training and support needed for WFH during COVID. Oversaw the month end closes remotely for AR and billing teams.

Looked after projects involving Integrations and new software implementations for sub companies.

Approved and checked journal entries for accuracy, making sure that the multiple revenue and expense streams were captured correctly.

Managed accounting operations, including journal entries, collection efforts, reconciliations and payroll processing.

Outlined work plans, determining resources, wrote timelines and generated initial budgets as part of project scope determination.

Monitored contracts and service level agreements to identify potential risks and implement mitigation actions to protect the development process from unforeseen delays and costs.

Senior Project Accountant (Short Term Contract) 08/2019 to 12/2019

Maru/Matchbox (Business Intelligence Technology) – Toronto

Planned the new Project revenue and cost process after inaccuracies in the previous method used.

Remapping the deferred revenue and the direct costs associated with the BI projects from US GAAP to IFRS standards.

Reconciling and remapping the Customer billing to the Netsuite ERP system and designing a new drawdown process for the project billing.

Changing of Project revenue from deferred to non-billable contractual budgets GL, set up in the Balance Sheet.

Reconciling the Balance sheet accounts for 2016 to 2019 to validity the balances and making adjustment entries in the current year.

Integrated the Sales data and the ERP data from the two implementation changes and elimination of Salesforce for project use.

Training the AR team and Project Analysts in the new processes and methods has been implemented.

Acted as a lead driver of the project success, facilitating the resolution of day-to-day business, technical and general project issues.

Planning, Designing and implementing new Contractual Budgets process for the projects.

Reviewed the budgets, including the capital appropriations and operating funds, and communicate findings to senior management.

Senior Accountant / SAP specialist (Short Term Contract) 04/2019 to 08/2019

Laborie (Medical Equipment Manufacturing) – Toronto

Consulted with the implementation team on the correct mapping of accounts and balances.

Tested the asset creation and amortization after consultations with the US office.

Month-end reconciliation of Holding companies and consolidation of financial statements for investor firm review.

Reconciliations of Liabilities, Expenses and Fixed Assets.

Amortization and depreciation of assets; accruals for the project costs.

Testing and documentation of SAP Hanna scripts for ERP implementation.

Delivering training on SAP to internal staff for both Canada and the US.

Created reporting on projects regarding revenue, expenditure and budgets.

Managed the project and the budget for the implementation of a new expense software and creation of new expense policy.

Designed the new Sales Tax matrix using Avalara for the US.

Helped with reviewing and making recommendations regarding the budgets been overdrawn for the new software and the medical device unit projects.

Worked with the IT department to bring their processes in compliance with SOX.

Reviewed budgets, including capital appropriations and operating budgets, and communicated findings to senior management.

Set up and improved accounting systems and processes to meet business needs and maximize the effectiveness of operations.

Senior Accountant (Full Time Restructured) 03/2018 to 04/2019

Nexonia (SAAS company) –Toronto

•Managed and owned Month-end and Management reporting for Nexonia and sub-companies of ExpenseWatch and Tallie.

•Weekly reconciliation of AP/AR, Banks and ACH for all three companies in Netsuite for use with Cash Forecast and the month-end.

•Project to create Deferred Revenue streams reports for different sub-companies.

•Managed and implemented a SaaS tax project for the USA.

•Analysis and comparison of Month to Month for Payroll, Balance Sheet and Credit Cards.

•Provided weekly cash forecast, weekly numbers and end of month sales commissions report.

•Worked on a project to implement Netsuite for three companies under the Nexonia umbrella.

•Implementing a project to integrate Salesforce reporting for the sales department into Intacct.

•Creating Journal templates to eliminate manual input and uploading journals for the payroll, expenses and corporate visa.

•Monthly asset consolidation with depreciation and amortization schedule journals.

•Worked with IT department and Developers for devising budgets for the client projects, software development, hardware requirements and personnel needed.

•Presented Projects Budget forecast and analysis on a monthly basis to the investment firm.

•Worked with the implementation consultants on the mapping of financial data from different ERP systems to the Netsuite.

•Ensured that the sales figures and deals from Salesforce were integrated into NetSuite via templates after consultations regarding the changes that the Sales Director wanted.

•Reviewed budgets, including capital appropriations and operating budgets, and communicated findings to senior management.

General Accountant (Full time, Management change) 04/2017 to 03/2018

Mary Brown's (Food Retail)–Toronto

•Daily reconciliation and upload for store deposits and sales

•Ensure complete, accurate and relevant balance sheet account reconciliations are completed on a timely basis.

•Weekly store package administration, including analysis of Man-hours and profitability. Calculation of hours and pay for store employees.

•Assist in month-end and year-end processes/audit

•Communicate with stores and other field personnel on deposit and sales issues

•Report writing for Sage, Clearview, Bluestreak and Drafting analysis and budget templates in Excel.

•Assist setting up new store operational accounts – utilities, phone, internet, POS system and fiscal package.

•Created and uploaded journals for payroll, adjustments to prepay and accrual adjustments.

Programs Project Lead (Contract) 03/2016 to 04/2017

Canadian Feed The Children (NGO) – Toronto

Analyzed projects for capital deployment and helped structure multi-million dollar deals as directed by the finance controller or the directors.

Developed and managed budgets and forecasts for government contracts totaling over $60 million.

Worked with the General Accountant to close month-end for the head office and then for the projects running on different revenue streams.

Designed Payroll templates for the US and overseas mission offices to show accountability and compliance.

Reviewed and analyzed project operational and capital spending throughout the project life cycle.

Identified risks associated with projects, contract approvals and other client accounting issues.

Developed spreadsheet models for diverse projects and analysis using advanced excel and access functions.

Created daily and weekly cash reports for accounting management.

Coded and processed AP invoices, payments and expenses for the head and country offices.

Working closely with both Country offices and project teams to deliver support and financial infrastructure needed for success.

Coordinated financial aspects of large- and small-scale projects with an acute sense of budget constraints.

Drafted budgets according to strict constraints and submitted for review on schedule.

Project Finance Analyst (Full Time, Moved to Canada) 05/2015 to 02/2016

The University of Manchester (Education) – Manchester, UK

Designed excel report templates integrating supplier organization's NAV r2 with data from Ledgers on Oracle.

Supported the Central Finance team with the implementation of Dynamics AX and linking it to the school's Oracle system.

Carried out investigative forensic analysis of departmental expenditure and corporate credit card accounts.

Reviewed all expense reports for accuracy and proper expense disclosure.

Carried out compliance and ethical conduct investigation on departments within Social Sciences school.

Examined, verified and provided cost benefit analyses for key divisional projects.

Intermediate Programs Lead (Full Time, Funding cuts) 10/2013 to 05/2015

LGBT Foundation (NGO) – Manchester, UK

Maintained the integrity of the general ledger, including the chart of accounts.

Filed tax returns and prepared governmental reports in compliance with strict standards.

Optimized and managed research and development spending through collaboration with key business leaders.

Generated financial statements and facilitated account-closing procedures each month.

Managed the month-end reporting for social projects and the General Ledger closing.

Oversaw the payroll and volunteer expenses for social projects.

Implemented system changeover from Access Dimensions to QuickBooks.

Integrated various project finances with information from Salesforce into a series of charts in excel.

Managed development projects and implemented new procedures.

Prepared and reconciled financial month-end and quarterly variance reports.

Dedicated support for finance and project infrastructure for the project teams out in the field and helpline center.

Identified plans and resources required to meet project goals and objectives by setting realistic timelines and checkpoints.

Developed implementation methodologies to rein in project costs while meeting key milestones.

Finance and Accounting Officer (Full Time, Funding cuts) 02/2010 to 09/2013

Greater Manchester Police – Manchester, UK

Staffed the Finance Helpdesk for AP/AR daily basis.

Carried out bank reconciliation and income statement reports.

Extraction of information from Oracle using discovery reports and PowerPivot tables.

Ensure Supplier and Vendor database across Oracle, SAP and Nav 3.70 was maintained, and errors dealt with.

Created batching codes for both AP/AR. This is to separate invoicing into different systems such as Socrates, Microsoft Dynamics Ax 2009 and SAP.

Performed preparation of journal entries, account analysis and balance sheet reconciliations for the month-end.

Education

B.Sc: Comptia Network and Security: 2014

University of Manchester - Manchester, UK

Management Level: Management Accountancy, CIMA: 2012

University of Manchester - Manchester, UK

Level 3 and 4: Associated Accounting Technician: 2011

HomeLearning College - Manchester, UK

BBA: Business Management and IT: 1998

West Thames Valley University - London, UK

Certifications

Certification Level: PMP Started: 08/2020

Simplilearn- Online classes

Certification Level: Agile and Scrum, PRINCE2 Foundation and Sigma project management : 2016

Simplilearn

References available on request

Contact this candidate