About Me

More About Me

Hi, I'm Bernard

I'm a finance professional contractor and Excel-VBA Pro with a passion for accounting, analysis and reporting processes. I have hands-on experience implementing world-class finance systems and developing desktop tools for others to use. I enjoy developing simple, clean and slick Excel-VBA models that provide extra value to the end user. With my finance backgroud, I quickly grasp the business process and leverage proven Excel-VBA techniques so my clients realize exceptional time-saving results. Delivering the work "on-time and on-budget" is my motto.

Resume

My Background

My Experience

Global Controller / Iterim-Fractional CFO

20+ year of hands-on experience performing multi-currency consolidations, accounting, FP&A, M&A accounting, lender reporting, Big-4 audit oversight, and project management.


Private Equity Transitions and Transformations

13+ years working with post-acquisition private equity portcos, streamlining business processes, hands-on project management of best-in-class ERP and EPM systems implementations.

My Education

Master in Business Administration (MBA)

UC Berkeley, HAAS School of Business


Recent Excel-VBA Projects

FP&A Reporting Model Enhancements

Upgraded existing FP&A Excel model to generate individual cost center reports containing actuals vs budget variances. A requirement is that the files must contain the transaction level actuals and budget data by cost account. The file will also serve as an input tool for cost center owners to supply their forecast of projected cost. The final file did not contain VBA code and the cost center owners were able to use it without any training.


Payroll to GL Mapping Tool

The finance department needed a tool for their payroll manager to map the bi-weekly payroll runs to their accounting system. I developed the model that took the payroll data and generated a balance journal entry that was ready to upload to their general ledger. The payroll manager was able to utilize the VBA tool with almost no training.

Skills

My Skills

Finance & Accounting Process Knowledge90%

EPM / SmartView Automation 75%

Budget and Forecasting 90%

PDF reading and output automation 60%

Cash Managment & Forecasting 80%

Bank Reconciliations 99%