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.