Markham, Ontario, Canada
An accounting professional with over 20 years solid experience in financial reporting & variance analysis including lead design and implementation of a company-wide excel budget system and various improvement/automation projects.
Reporting Analyst: • Prepares monthly/quarterly financial statements including variance analysis and commentaries. • Prepares P&L forecast trends and scenarios to top management for financial planning purposes. • Designed, developed and implemented the company budget template. • Performs bank and inter-company reconciliations and booked corresponding adjusting entries. • Setup month-end prepaid expenses amortization and year-end fixed asset depreciation. • Setup month-end credit card expenses and prepares accruals for billing and payroll. • Assists in analyzing departmental processes, including the identification of process improvements, as well as the development of solution options and recommendations. • Resolves discrepancies, errors & omissions and provides feedback to operations. • Provides assistance during audits including account reconciliation & schedules preparations. Senior Billing Analyst: • Responsible for accurate and timely invoicing and preparation of backup documents. • Ensures all revenue are accounted for and reconciled with source documents. • Understands and applies customer’s contracts and special requirements to be applied to billing. • Coordinates with operations in setting up new customers and price updates. • Prepares month-end revenue accruals and revenue reconciliation. • Automated the invoicing process enabling the company to handle large volume invoicing centrally from head office. • Created billing templates in excel to reduce invoicing lead time and setup checks and control in invoicing.
•Handle full cycle accounting duties using QuickBooks •Record expenses, monitors accounts payable and process payment to vendors through cheque, online banking and wire transfer payments •Perform billing, monitors accounts receivable aging, and follows up collection from customers •Handle logistics function including inventory management, placing purchase orders to international vendors, and dispatching inventory sales to customers •Setup accruals, computes payroll, and handles HST filing •Perform bank accounts, payment application, and e-commerce sales reconciliation
•Plans and manages the invoice processing team's activities for 4 major client groups to meet KPI requirements •Checks the accuracy and validity of invoices processed against contract, purchase & work orders •Perform analysis and reconciliation on invoices processed in Basware against invoices paid in Oracle •Perform reconciliation of payables report with operations accrual report and vendor statements •Investigates and releases payment holds to ensures timely payment to vendors •Coordinates with project managers and vendors on payment status and inquiries •Prepares weekly invoice aging report per client group and other reports as required
• Prepared consolidated financial reports, dashboards, executive commentaries and variance analysis on Sales Business Units, Corporate Department and Manufacturing Profit • Created financial models on latest estimates forecast, multiple year financial projection, and budget scenarios for strategic business planning purposes • Designed and implemented the company-wide budget system thru excel templates and handled capital expenditure reporting and control • Conducted budget exercises and Excel training in Saudi Arabia, Dubai and Iran offices
• Prepared income statement, variance analysis and budget for clients such as Proctor & Gamble, Philips, ON Semiconductors and Vendor managed inventories in compliance with GAAP • Prepare month-end entries for accrual and perform reconciliation between client-wise operating result with budgeted and targeted figures • Computed cost plus, activity based, and fixed billing, monitored aging of receivables and projected the collection forecasts for each client • Performed review of purchases request, request for payments and payroll computations for the client and discussed budget recommendations, billings, operational results and KPIs with the client