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.

Years of Finance Experiance
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%