Work History

Work History

Data Analyst

Sep 2014 - Oct 2015
Nella Cutlery and Food Equipment

Data Analyst, Mississauga, Ontario: Successfully performed data conversion for ERP package implementation. Reviewed blue print, flow-charts and upload templates to plan data collection task. Gathered data extraction and transformation requirements by interviewing key users. Processed and consolidated large volumes of Inventory, Customer, Vendor master, other data from text files using MS Excel (some VBA automation), MS Access, SQL queries, and OBDC connector. Successfully extracted parsed data, with limited options and tools, and re-formatted, cleansed and dressed data set in MS Excel table format. When approached with queries, I performed research to validate and/or resolve concerns regarding SAP Business One best practices, functionality and system controls. Contributed to the collection of functional requirements by actively listening and asking follow-up questions to both system users and ERP consultants. Attended frequent meetings to discuss project work-flow and systematic approach to achieve quality project deliverables. Provided some accounting support in the form of  bank Statement reconciliation and monthly preparation of reports for third parties.

Expense Analyst

Oct 2013 - Jul 2014
University Health Network UHN

Expense Analyst(Contract), Toronto, Ontario: Reviewed procurement of products and services to assure compliance with corporate policies. Processed expense reimbursement claim and PCards to ensure completeness, accuracy and compliance with UHN expense reimbursement and purchasing policies. Quantified and recorded month-end budget accruals for salary and other expenses

Junior Accountant/analyst-Performance Business Management

Nov 2012 - Mar 2013
Rouge Valley Health Systems

Junior Accountant/Analyst-Performance Business Management (Contract) Toronto, Ontario: Documented GL mapping from legacy system to SAP. Prepared budget reports to illustrate staffing impact and program expenditures. Documented Logistics and Purchasing business processes to identify integration points with Finance. Provided custom SAP reports to facilitate control of budget and costs by program. Assisted with the maintenance of MS Excel macro-based dashboard to report on staffing impact and business performance indicators.

Billing and Administrative Support

Jan 2008 - Mar 2008
Ontario Medical Association (Contract)

Performed billing using Great Plains Dynamics to accurately reflect revenues from membership dues and other revenue streams

Accounts Receivable

Sep 2006 - Oct 2007
Atlas Cold Storage LLC

Reported AR issues and trends to CFO and Accounts Receivable Manager through regular meetings. Resolved customer complaints / issues by promptly investigating disputed items. Assisted finance to reconcile bank and other G/L accounts. SAP Conversion Role: Performed user acceptance testing to ensure the AR department’s existing business process was satisfied and documented gaps where requirements were not met. Tested customized functions to identify and document gap in functionality. Reviewed data for cleansing, accuracy, completeness and format prior to import into SAP database. Performed a review of the master and transaction data to verify records were imported accurately

Education

Education

B.Comm - Business/Information Technology Management (BTM)

Sep 2010 - Jul 2012
Ryerson University

The program is an initiative started by the Canadian Coalition for Tomorrow’s ICT Skills (CCICT) which merged with the Information Technology Association of Canada (ITAC) and rebranded itself as ITAC Talent. CCICT was an industry initiative started by Canadian companies which recognised the need for professionals specially trained to combine business and technology knowledge to drive sensible technology solutions to create value

SAP Certified Business Associate - ECC

Jul 2012 - Jul 2012
SAP Canada

Focus on business processes generic to all ERP packages (Vendor neutral)

Advanced Diploma - Accountant/Programmer Analyst

Sep 2002 - Dec 2005
Centennial College

A mixture of business and information system studies. Produced capstone project with database driven applications using VB 6.0, ADO and SQL

Skills

Skills

Microsoft Office

Advanced MS Excel user can design VBA programs with research and can write complex SQL queries in MS Access

ERP

Primarily focused on SAP (SAP Certified) with some experience with Microsoft Navision and Great Plains

Visual Basic.Net

Data driven desktop applications

Java, Eclipse

Completed coursework using Java and UML and design concepts applied to a transportation problem 

Microsoft SQL Server (Queries)

Completed hands on labs writing complex queries

Technical skills:

Eclipse, Java, Object Oriented analysis with UML (Beginner)(B, Microsoft Visual Studios, VB .NET (Beginner)(Microsoft Excel, automation with VBA, MS Access (Advanced MS Excel, Intermediate MS Access), Microsoft SQL Server 2008, T-SQL, DLL, DML (Beginner), SAP FI/CO, Navision Attain ERP, SILK ERP