Ben Dhillon Email & Phone Number

Toronto, Ontario, CA

Toronto, Ontario, CA

• Developed and maintained strong working relationships with clients while leveraging expert knowledge of CaseWare, Caseview, TaxPrep, Netsuite, Intacct, QuickBooks, Microsoft Dynamics Nav, Zed Axis, Sage, Simply.
• Created and introduced scalable practices to increase efficiency and remove the need for manual data entry wherever possible.
• Performed consulting work for various clients utilizing programming and expert financial systems knowledge to create robust and easy to use internal accounting systems shortening period end finance/bookkeeping tasks.
• Automated bookkeeping tasks allowing for data extracts from financial sources, such as sales listings or bank statements, to be mass uploaded as transactions to financial systems including but not limited to QuickBooks.
• Employed strong time management skills to meet deliverable deadlines related to bookkeeping, notice to readers, and review engagements as well as T1, and T2 income tax returns, T3 trust returns, and T4s or T5s where.
• Performed a combination of analytical procedures and tests across all balance sheet and income statement items, including key areas such as investments, capital assets, long-term debt, revenues and expenses.

Brampton, Ontario, CA

• Developed, piloted and implemented a company-wide forecast model which drew on budgets, prior year data, current period promo deals, and outside factors affecting sales to forecast financial results; then later pulled.
• Oversaw the creation and consolidation of budgets and forecasts across all discount grocery categories
• Assisted senior management with analysis and strategic planning based on actual results and year over year comp metrics.
• Extracted large amounts of complex information from multiple sources, including SAP, and produced simple and easy-to-understand reports. These reports showcased business results with great detail and outlined relevant.
• Performed financial impact & sensitivity analysis to monitor and evaluate the financial performance of proposed strategies
• Prepared senior management presentations and reports including but not limited to; - Weekly sales scorecards with the ability to view results at any granular level from entire business unit down to a particular item.

Brampton, Ontario, CA

• Worked closely with HABA categories to ensure that all vendor income related activities were processed in an efficient and accurate manner while ensuring a clean audit trail and compliance to accounting standards
• Maintained and reported purchasing rates in legacy systems as well as SAP, listing new items when required as well as making changes to ensure all rates in the system are correct
• Updated and adjusted company-wide Vendor Audit Database totaling 100 million plus yearly using information collected from auditors in order to keep track of all audits, billed or not, as well as publish a report to the.
• Completed periodic review, reconciliation and accrual of outstanding Vendor Audits
• Designed and helped lead a lunch and learn session teaching other analysts unfamiliar with macros how to record and edit them with specific examples being macros to consolidate large amounts of data stored in different.
• Created macros written from scratch using Visual Basic to eliminate need for repetitive tasks related to processing vendor deal sheets and cut period end upload processing time down from days to just hours

• Designed custom high end home theatre solutions with appropriate components based upon individual customer needs
• Installed as well as troubleshot hardware and software components
• Upgraded existing setups with modern peripherals allowing for the best audio visual experience
• Maintained balanced books for business in order to track all revenues and expenditures
• Marketed all services offered through effective use of social media as well as online advertisement websites
• Ensured customer satisfaction with all services rendered; sales, installation & troubleshooting

Brampton, Ontario, CA

• Maintained a large database relating to a companywide COGS reduction project in the hundreds of millions of dollars using information gathered from various business units
• Liaised regularly with VPs and directors of various business units to verify accuracy as well as request changes to values reported for evaluation metrics in order to ensure project success
• Prepared period end reports to track project performance versus various metrics to effectively show COGs reduction for varying time frames and business units
• Presented periodic performance to business units leads while sharing suggestions and key concerns that could influence future performance
• Leveraged expert knowledge of Microsoft Access, Excel, and VBA macros to create templates, forecast models and databases replacing older less efficient versions and cutting report preparation time in half
• Prepared quarterly report for all individual Loblaw banners and stores to review year-over-year performance measured according to predetermined metrics and suggested corrective action where necessary

• Completed quarterly and annual GST returns for various corporate clients as well as y/e financial statements.
• Designed and implemented firm budget template receiving feedback from partner at key points of process.
• Created various forms and templates to help make the accounting process easier and more efficient for clients and the firm resulting in vast time savings
• Discussed tax implications from changes in the federal budget (i.e. HST, home renovation tax credit) with clients, in addition to assisting in the development and implementation of tax planning strategies for various.
• Entered credit card charges, cash deposits, cash disbursements, invoices and compiled financial statements subsequent to bookkeeping using QuickBooks.
• Reconciled various accounts proposing adjusting and reversing entries to senior team members, while maintaining open communication regarding progress and other significant issues

• Conducted bank reconciliations to verify accuracy of all user accounts to increase the efficiency, reliability and cost-effectiveness of reports that would later be created.
• Documented debit, credit, and total accounts on computer spreadsheets and databases, using specialized finance and accounting software including but not limited to Excel, Quickbooks, Simply Accounting, and Quicken.
• Established Excel templates that were used to perform computerized data entry which were later incorporated into the day to day operations of the business.
• Utilized independently drafted templates to post entries following the GAAP and tax accounting rules on the general journal, ledger, subsidiary ledger, accounts receivable ledger, accounts payable ledger, and purchase.
• Collaborated with a small group of individuals to synthesize all reports and statements to prepare year-end financial statements.
• Gathered financial transaction histories as a means to complete tax returns for numerous clients which were later reviewed and approved by manager.