Business Analyst Resume

Title
Business Analyst

Primary Skills
SAP FI, EDI Ansi,

Location
Canada-ON-Toronto (will consider relocating)

Posted
Sep-14-08

OBJECTIVE:
To secure a challenging role as a Business Analyst in SAP.
PROFILE:
• Over Advanced professional accounting experience and IT knowledge ,CGA Level 5
• Working experience and knowledge to effectively communicate between business and IT stakeholders.
• Certified Consultant and Super User Working knowledge of Visual Enterprise module Visual Financials and SAP Financials, mySAP ERP 2005, ECC6.0. .
• Ability to assist with technical design to ensure that business needs are met.
• Working Expert in the use of system modelling tools for analysis, e.g. use cases, sequence diagrams, activity diagrams
• Ability experience of business analysis best practices such as requirements workshops, story boarding and proof of concepts.
• Strong understanding of business processes and postings in ERP environment
• Super user knowledge of Sterling's Commerce, Gentran Server , an EDI application software and related daily mapping issues related to document types eg 810, 820, 850 852, 997 and related functional acknowledgements
• Conducted training sessions for end-users and developed complete documentation for end user manuals for Visual enterprise Finance module and SAP FI module
• High learning curve with the ability to embrace new tools and technologies with ease and to seamlessly integrate skill set into the project implementation lifecycle


EDUCATIONAL BACKGROUND:
• SAP Certified Solution Consultant - Financial Accounting with mySAP ERP 2005, SAP AG 2008
• Bsc Hons Statistics and Mathematics 2000
• Certified General Accountants of Ontario, CGA Finalist ,INFORMATION SYSTEMS
• IIBA Member ,International Institute for Business Analysts Certification in Progress

Technical Skills
ERP: SAP R/3 FI/CO, ECC6.0, Visual Financials Version 6.5.2
Methodology: Solution Manager and ASAP
Languages: XML and SQL
Databases: MS SQL Server Access and SAS
Reports Crystal Reports
Operating Systems: MS Windows 9X/NT/2000/XP,
EDI Standards ANSI X12 and EDIFACT


PROFESSIONAL EXPERIENCE

Magickwoods Ltd Toronto, ON
2006 Sept--Present
www.magickwoods.com

Magickwoods Ltd is a medium sized manufacturing entity which manufactures high end bath vanities and cabinets. It supplies products to various retailers in USA and Canada such as Lowes USA, Lowes Canada, Home Depot Canada, Menards and Rona and other smaller boutiques. It has been growing fast and has subsidiaries in China and India. Projected sales for this year are 150 million

Business Analyst Visual Enterprise's Visual Financials www.infor.com

Major projects Include
• E-Doc Project Phase 1 and 2: Identified and recommended new technology to cut operational costs and electronically archiving and retrieving invoices, Bill of lading and Packing Slips for easier retrieval resulting in reduced costs in terms of direct and indirect costs. This was calculated to save costs by up to 20% per year. After successful implementation, working as Super User analyzing daily Exception reports for unmatched documents and escalated to concerned department such as shipping and order entry
• Global Consolidation Chart of Accounts: Working with IT, mapped, Tested and Implemented a new Chart of Accounts by mapping the new accounts, creating the account groups, posting level and summary level accounts configured report writer for GL Reports and financial statements for easier profitability analysis and cost centre and departmental reporting across subsidiaries in Canada, China and India. This enabled multiple companies to use a unified Chart of Accounts from the new fiscal year Sept 1, 2008.
• Instrumental in designing the nomenclature for new inventory product code for new chart of accounts
• Redesigning of the RGA process for Lowes defective product returns resulting in more streamlined and efficient process which was more accurate resulting in reduced variance with EMM Dashboard
• Configuration of Cash Management Application for accurate and consistent cash flow estimation for organizational strategic positioning
• Configured the VMDI Cash Applications for Importing the 820 EDI document from EDI server directly into Visual Financials for easier and faster cash application processing
• Liaised and coordinated with Home Depot EDI department in Atlanta in resolving EDI mapping issues arising from their SCORE Project, which was a Pilot Test Project for 9 stores and leading to conversion of all Canadian stores into SAP
• Responsible for monitoring the automated invoice printer shutting it off at last day of month to ensure month end AR postings are posted in correct dispatched period to ensure correct cut off for correct revenue recognition
• Acted as knowledge base for EDI, researched and advised IT department and recommended changes to EDI maps to accommodate changes due to changing business requirements and Legislation such as Bill C-198 making Bill to mandatory for, GST rate changes
? Influenced decisions and orientations with respect to detailed functional specifications
? Technology scanning on current and future IT trends to make sure organization continues to meet its strategic objectives in competitive environments
? Acted in the capacity of Visual Financials functional specifications expert and trained new employees
? Ensuring the Change Management is handled properly for smooth transition
? In charge of research, analysis and documentation of business requirements specifications

RELEVANT EMPLOYMENT HISTORY: (cont.)

? 2005 October --2006 August
Magickwoods www.magickwoods.com
Indyca Solutions www.indyca.com

Accounting Analyst
? Ensured subledgers are reconciled at month end to agree with General ledger
? End of year customer Program Provisions reconciliation of General Ledger with Provision as per customer agreement and provided recommendations to increase or reduce the provision in the General Ledger at year end to the Controller
? Maintained and kept custody of current customer contract agreements and enforced the terms of agreement
? Reconciliation of Quarterly Volume Coop and Rebate Calculations for all customers
? Ensured that the PO Accrual Accounts is cleared at month end and balance minimized
? Supported the consultants in mandates to develop management information system applications by explaining the business requirements
? Supported and performed year end and month end closing procedures, provided auditors with walk through of business processes and procedures for analysis of risk
? Acted as a knowledge base for all technical issues related to EDI and provided error resolutions on a day to day basis and coordinated with Home Depot supplier centre Edi department in Atlanta (www.suppliercenter.homedepot.com)
? Increased accuracy of Cash-flow forecasts for 3 month and 4 week rollover significantly by overseeing the Accounts receivables function and monitoring daily transmission return documents in EDI and escalated on exceptions
? In charge of managing onlinestore www.lifeandstylestore.com , resolving customer issues, issuing refunds and transferring funds from Paypal to bank account.
• Other projects as assigned by Controller and Management Accountant
,

2003 August to 2005 September

Accounting Analyst The Dixie Auto Group, Mississauga
www.401dixiesuzuki.com
The following were achieved using Visual Financials accounting software
• Processing of accounts payables into the system
• Maintained an accurate and up to date Accounts Payable Ledger
• Followed up on inquiries to ensure accuracy and integrity of A/P ledger
• Maintained an accurate and Updated vendor database by creating and activating new ones to payable status
• Prepared daily cash deposits and cash applications
• Reconciliation of AR Sub-ledger balance to GL
• Monitored and overseeing issues pertaining to Accounts Receivables going beyond terms by putting orders on hold
• Accurately Performed monthly in-house Inter-Company reconciliations for 6 sister dealerships by analyzing necessary documentation such receivables and corresponding payables ledger entries and performing necessary adjusting entries
• Accurately performed Auto group fixed asset reconciliations for year end audit purposes by matching the GL fixed asset balances to the physical assets and purchase invoices
• Routinely created, entered and posted journal entries to make adjustment, correct errors
• Processed credit applications by customer dealerships by contacting references.
• Independently prepared various reports and projects as requested by Controller

ACCOUNTING WORK EXPERIENCE:

GENERAL TRAINEE ACCOUNTANT, AIR ZIMBABWE CORPORATION, Jan. 2001¬ to Feb.2002

Duties included the following
• Processed employee expense reports into SAP Financial system
• Generated bill of lading reports using SAP Financials
• Processed accounts payable invoices into SAP Financials System
• Auditing and Reconciliation of employee expense reports
• Matched daily computer generated reports with the original documents to verify accuracy
• General ledger reconciliation to AP and AR Sub ledgers
• Cashflow forecast and analysis for three month rollover
• Account Analysis, budgeting, cash management, and internal and external reporting.



References are available upon request.

Certifications
SAP FI Certification ECC6.0
Certified General Accounting


You must be logged in and have a current resume access subscription. Login or Register »

Resumes in Toronto, ON | Resumes in Ontario

View other Business Analyst resumes