Financial Analyst Sap

Debbie-Kay Harris

*** *** *****

Dollard-des-Ormeaux, QC H9B 1M1

(514) 865- 5076

**********@*****.***

https://www.linkedin.com/in/debbiekayharris/

CAREER PROFILE:

• SAP End User/Super User

• SAP/VISTEX/LEGACY Data Analyst

• SAP Implementation – Data Validation Specialist

• SAP BPC/EPM Report Writer/Developer

• SAP BW/AO Report Writer Developer & Trainer

• VISTEX MDM SME (Mater Data Management - Subject Matter Expert)

• MICROSOFT EXCEL Expert (Function and Formula Writer -pivot tables, v-lookups, index, match, sum-ifs, advanced filters)

I have a solid financial analysis background with expertise in both the private and public sectors using corporate accounting software, with concrete analytical experience.

TECHNICAL SKILLS:

• SAP ERP • Great Plains ERP

• VISTEX Software

• Microsoft Excel Expert: level 3: certified by IACT International Academy of Computer Training

(iactonline)

• BPC Software (Business Planning

Consolidation) EPM Front-end

• MINX/Legacy Project Accounting Software

• SharePoint • E.D.I. System Software

• AS400 ERP • Access 2003

• HP ALM ERP

• BW/AO (Business Warehouse/ Analysis for Office)

• PeopleSoft ERP • IBM Cognos Software

LANGUAGES:

• English: mother tongue

• French: fluent

EDUCATION:

• Introduction to US Corporation Taxation, O.C.A.Q 2006

• GST, HST & QST Update, O.C.A.Q 2004

• B.A., Economics, Concordia University 1994

• D.E.C., Commerce, Vanier College 1990

PROFESSIONAL EXPERIENCE:

MCKESSON CANADA, division of MCKESSON CORPORATION (Public Sector, Healthcare, revenue $123 billion) SAP/VISTEX Data Conversion Consultant- McKesson Specialized Distribution –MDM Governance February 2018 – March 2019

• Created a reference guide/cookbook of master data governance rules for VISTEX customer creation

• Created data and populated test environment

• Cleansed and converted transformed data

• Performed/uploaded trial data migrations into Test environment

• Transformed /uploaded Data migrations into Production Environment

• Worked with key users and stakeholders to identify and resolve data issues as part of Post Go-Live Support

• Created customer reconciliation between old legacy data and newly created SAP customers as a reference guide for the business

MCKESSON CANADA, division of MCKESSON CORPORATION (Public Sector, Healthcare, revenue $123 billion) SAP AO/BW Report Writer & Trainer - SAP IMPLEMENTATION PROJECT (MOSAIK) September 2017 – November 2017

• Performed UAT (User Acceptance Testing) of BW reports for AO (Analysis for Office) super users prior to power training

• Created extensive and detailed PowerPoint presentations for the purpose of End-User training

• Trained Business super users on the AO Reporting Tool specific to their Finance department domains (ex. Procurement, Sales, Volume Rebates, Master Data)

MCKESSON CANADA, division of MCKESSON CORPORATION (Public Sector, Healthcare, revenue $123 billion) SAP Data Validation Developer – Finance & MDM SME SAP IMPLEMENTATION PROJECTS March 2015 –August 2017

• Created and maintained the excel validation models for specific SAP objects as part of the Implementation plan for both ATLAS & MOSAIK(Vendor Master, Customer & Credit Master, GL, AR Open Items, AP Open Items) at each Business Group Rollout as part of the SAP ERP implementation

• Participated in the Master Data cleansing process for system vendors and customers for the SAP Implementation as an MDM SME

• Trained SAP End users at remote sites on the Master Data Maintenance platform VISTEX for the SAP Implementation as an MDM SME

• Performed data analysis of GL reconciliations (INFINIUM versus SAP – implementation of transformed data)

• Created process documentation, for audit purposes, identifying that random sampling was in line with the Business KPIs for both projects

• Presented PowerPoint reports to the stakeholders to demonstrate that the data validation of converted objects was completed and in line with Business KPIs and Audit requirements for the Go-Live Date of the SAP Implementation

• Automated excel files for data analysis of different SAP Business objects (Journal Entry classifications & cost center mappings) MCKESSON CANADA, division of MCKESSON CORPORATION (Public Sector, Healthcare, revenue $123 billion) SAP BPC/EPM Finance Report Writer - BPC REJUVENATION PROJECT (as part of ATLAS) January 2016 – November 2016

• Skilled as a BPC /EPM Report Writer for the Finance Team and provided user support to project team & finance end users subsequent to Go-Live

• Conferred with Business Users to define Finance Requirements based on Reporting specifications and a means of creating BPC/EPM (Enterprise Performance Management) reports for Actuals, Budgets & Forecasts

• Performed unit testing on BPC embedded model for Security Front-End & Back End compliance of SAP Employee IDs

• Accomplishments: Successfully performed two In-House Excel Training course presentations for the SAP SMEs, Functional analysts and SAP consultants

MCKESSON CANADA, division of MCKESSON CORPORATION (Public Sector, Healthcare, revenue $123 billion) Financial Analyst (temporary) Business Unit Accounting & Analysis March 2014 – March 2015

• Full cycle accounting for three business units including booking all journal entries, accruals, reconciliations

• Produce sales analysis reports, financial business reviews and dashboards to management

• Furnish Monthly, quarterly and yearly schedules to Consolidation Team

• Accomplishments: automated the CES Business Review Excel file to compute actuals vs budget vs forecast, for the purpose of narrative explanations. Optimized the process thereby reducing processing time from 2 hours to 20 mins via LOOKUPS and INDEX/MATCH formulas

BOMBARDIER AEROSPACE INC. (Public Sector, Aviation, revenue $18 Billion) Sr. Financial Analyst SAP Super User Cost Accounting Labor & Overhead Reporting for the Global Completion Programs 2011- 2014

• Reporting the actuals versus forecast vs. budget for direct and indirect hours clocked on all aircraft program

• Producing learning curve graphs as Key Performance Indicators for the direction of the business

• Reconciling the labor to the WIP for month-end reports via Journal entries and accruals

• Preparing the overhead expenses for each department to the directors on a monthly basis in relation to the unit costs

• Preparing Monthly Caption Reports and Wrap Rate Roll forward Analysis

• Accomplishments: created a common database that consolidated actuals, forecast, budget used by all departments BOMBARDIER AEROSPACE INC. (Public Sector, Aviation, revenue $18 Billion) Sr. Financial Analyst SAP Super User responsible for Financial Reporting of Intercompany & Trade Receivables 2007- 2011

• Process all intercompany customer accounts and set their corresponding credit levels

• Responsible for the accounts receivable intercompany, trade and consolidation month-end reconciliations

• Prepare analysis related to the account receivable section for Canadian entities

• Prepare the AR Monthly details that feed the Financial statements

• Calculate the monthly variance and narratives for AR actuals vs. forecast vs. budget

• Consolidate account receivable and intercompany quarterly forecasts and budgets

Contact this candidate