| |
. |
 |
|
Consultant DC, MBA
| |
| . |
. |
| |
Project Clients & Past Employers
- KPMG Corporate Finance (middle market investment bank)
- The Boeing Company (Aerospace and defense)
- Pacific Energy Partners ($2 billion oil pipeline and storage company)
- Janas Associates (boutique investment bank)
- Consolidated Fire Protection ($200 million fire and life safety company)
- Black Emerald Capital Ltd (boutique investment bank)
- Quest Diagnostics (a $300 million medical testing and diagnostics business)
Functional Finance & Accounting Experience
Financial Planning & Analysis
- Led the budgeting, forecasting, long-range planning, and analysis functions of a $2 billion public company with annual revenues of $300 million and a $160 million capital budget.
- Presented to and advised all levels of management across multiple functions including CEO, CFO, CAO, VP/Treasurer, Director of Operations, Chief Engineer and Program/Project Manager. Previous direct report to the Chief Financial Officer of a publicly traded company.
- Performed financial planning and analysis functions across several industries including biotech, energy, aerospace and defense, manufacturing and engineering development.
- Conducted monthly reviews with senior management to evaluate financial performance and develop P&L, cash flow, balance sheet and capital forecasts.
- Prepared monthly financial reports, forecasts, financial statements, variance analyses, executive narrative, and presentation materials. Created charts and analyses to highlight operational activity and to analyze variances between actual activity and budgeted activity.
- Provided analysis of actual variance to plan and discussion of quarterly and fiscal year forecasts. Integrated into monthly operating reports distributed to the board of directors and executives.
- Recommended and implemented financial forecast process improvements that led to reductions in monthly forecast cycle time of three days. Solutions included optimization of financial models and expanded use of system reporting modules.
- Implemented new financial reporting processes which directly contributed to the achievement of additional customer incentive fees. Processes included 4-day turnaround of monthly performance data and 30-day baseline change implementation.
- Prepared operating cash flow forecasts to determine compliance with rules governing conversion of subordinate stock to common stock.
- Managed the process to develop 10 year staffing plans for a business area consisting of 200 employees. Consolidated, analyzed and presented results to division process management.
- Maintained a comprehensive business unit wide labor database for planning and budgetary comparisons. Enhanced the database functionality to encompass direct comparison of current forecasts to budget and high-level summary analysis.
- Trained and mentored new financial analysts in business analysis functions, including program, planning and control, financial planning and forecast consolidation activities for an $85M annual sales business area.
- Led a team of business analysts and managers to evaluate and recommend improvements to a process to rollout new business operations policies and procedures. Process was documented and utilized division wide for all new rollouts.
- Conducted bottoms up reviews of subcontractor budgeting systems and processes and recommended steps for improvement.
- Led auditors through reviews of project budgets and documentation to ensure compliance with regulatory requirements governing project financial management and control.
- Assisted management in establishing annual department goals and metrics, executing plans and presenting status to executive management.
- Facilitated annual budgeting process in parallel with company transition to new ownership. Driving process to completion amid priority conflicts and time constraints on process participants.
- Provided analyses for quarterly earnings analyst calls including quarterly and annual guidance variance to prior quarter and prior year actuals.
M&A Transaction Execution, Marketing And Due Diligence
- Executed sell-side and buy-side M&A transactions for an investment bank specializing in M&A advisory, debt and equity financing and strategic counsel to $10 million to $250 million companies. Industry experience includes software, healthcare, aerospace and defense, IT services, legal services and manufacturing.
- Key figure in post merger integration of the FP&A functions for two publicly traded companies. Partnered with new corporate financial planning leadership to ensure smooth transition to company's planning, budgeting and reporting requirements. Developed a forecast and budget translation model that restated the target company's P&L and capital budgets to the acquiring company's organization structure.
- Planned and conducted initial due diligence meetings with target company ownership and key management on six separate engagements.
- Led the due diligence collection processes in the sale of a $46 million medical device company and a $25 million legal services company.
- Prepared pre-engagement due diligence request lists on six M&A transactions and coordinated the collection and dissemination of documentation to engagement team.
- Conducted executive management interviews to gather information for use in marketing materials and information memorandums.
- Single-handedly managed and expedited an accelerated due diligence process leading to a shortened deal timeline. Deal closed nearly 33% faster than the firm's average. Due diligence documentation filled six banker's boxes.
- Acted as client point of contact for deal execution activities. Commended for strong organization, communication and client interaction skills.
- Constructed financial models and performed industry and company valuations. Prepared financial projections and per unit cost calculations and analyses for target companies.
- Prepared 40+page confidential information memoranda to promote acquisition opportunities to potential buyers.
- Conducted industry and company research in support of industry commentaries and analyses, information memoranda, client pitches and marketing collateral.
- Researched potential strategic and financial acquirers and recommended top candidates to senior deal professionals. Recommendations served as the basis for targeted marketing efforts on sell-side engagements.
- Directly marketed acquisition opportunities to corporate acquirers and private equity investors. Presented company background and accomplishments, summary financial performance and forecasts, brief industry overview and strategic rationale for an acquisition.
- Performed company and industry research in support of a buy-side engagement with a $300M private equity firm looking to expand its investment portfolio in the US and Canada.
- Authored monthly industry valuation analyses and distributed to over 400 CFO's and Corporate Development executives in the U.S and Canada.
- Analyzed and rebuilt privately-held company financial statements to reflect operating performance exclusive of discretionary, non-recurring and extraordinary expenses.
- Managed the sell-side due diligence process for a $200 million company and acted as the primary point of contact between company management and the investment banking community, private equity buyers, auditors and transaction consultants. Acted as a first line of defense to respond to due diligence questions and requests.
- Evaluated contracts, purchase agreements and acquisition documents to assess exposure to change of control issues which could result in accelerated payments upon consummation of a sale. Uncovered exposure to an earnout agreement from a prior acquisition that would require accelerated payout of earnout payments on the change of control date.
- Reviewed offering memorandums and financial models prepared by investment bankers and provided recommendations to improve effectiveness and accuracy.
- Reviewed purchase documents, including purchase agreement, debt security agreements, and escrow agreement, and advised management of any potential issues that could impact the company.
- Researched company and executive exposure to IRC Section 280G, taxation of change in control payments (parachute payments from stock option payouts, severance packages, and other payments triggered by a change in control), and reported results to management.
Financial Systems Implementation And Process Improvement
- Led the research, planning and implementation of new financial planning and reporting systems. Performed extensive testing and troubleshooting.
- Designed, tested and implemented Visual Basic applications used to perform data analysis and generate reports resulting in 80% reduction in analysis and reporting time.
- Established relationships with department leaders; interviewed laboratory technicians to collect usage data, to develop tool for predicting purchasing requirements for a $300 million medical testing and diagnostics business. Tool implementation is expected to reduce working capital requirements by up to $4 million and double inventory turns from 6x to 12x.
- Developed an Intranet Web Site for the Business Operations organization of 100 employees. The website was used a central location of communication of policies, procedures, tools, financial models, news and events.
- Designed and taught a training class to department coworkers in the use of the company's performance management system.
- Conducted bottoms up reviews of subcontractor budgeting systems and processes and recommended steps for improvement.
Financial Modeling
- Extensive experience building, improving and refining budget and forecast models.
- Built a financial model with what-if capability to calculate company-wide incentive compensation plan costs assuming various achievement scenarios. Prepared summary model results and graphs for presentation to the board of directors and company compensation committee.
- Modeled the interest expense forecast for a company with three fixed rate bonds, a U.S.-based revolver, a Canada-based revolver and monthly capitalization of interest. Integrated this model with the company's consolidated P&L.
- Led the development of revenue forecast models for recently acquired businesses with $60 million annual revenue. Integrated new models into corporate consolidated forecast model.
- Teamed with corporate development leadership to review, update and improve acquisition models.
- Developed and deployed complex financial models to analysts to assist in developing Long Range Business Plans and Strategic Resource Plans. Reduced cycle time by up to 25% and improved forecast accuracy.
- Developed, implemented and maintained a material receipt and payment tracking database that enabled management to quickly asses material commitment levels and outstanding accounts payable balances.
- Developed a complex five-year financial model for an early-stage organic products business seeking VC funding for new growth initiatives. Model included income statements, balance sheets, statements of cash flow, capital expenditure forecasts, depreciation schedules, a capitalization table, acquisition payout models and a long-term debt model.
- Created a centralized assumptions page to enable multiple scenario analyses. Included major assumptions such as revenue growth rates, gross margin, SG&A %, AP days, AR days and Inventory turns. Assumptions were linked back into the model to allow for dynamic updates and real-time variance analysis.
- Developed a capitalization table with the flexibility to update for new ownership, conversion of convertible debt, exercise of stock option and warrants, and new issuance of preferred stock, common stock or long-term debt. Integrated into the balance sheet and statements of cash flow.
- Converted IFRS financial statements to accounting standards consistent with US GAAP.
Systems Expertise: Selected Detail
Excel
- Expert Level User including, macro creation and customization (Visual Basic code writing), advanced charting, usage of analytical tools (like Solver, defining scenarios and tracing dependents), graphing presentations (charts, trend lines, axis scales, multiple charts), formula building (If, And/Or, V-Lookup, Mid, Concatenate, Sumif, ), shared data, heavy database linking, customization of toolbars and menus, pivot tables, and creation of user-oriented applications using controls and custom add-ins.
- Visual Basic study.
JD Edwards
- Developed standard reports for reporting and analysis, and uploading into financial planning budget and forecast models.
- Trained new financial analysts in its use.
- Created new reporting package to streamline corporate planning department modeling and reporting.
Great Plains
- Performed data queries and report generation to collect and analyze balance sheet, income statement and job cost actual performance data.
- Managed the process to migrate fixed asset data from a legacy fixed asset system to Great Plains as part of the company's new system implementation.
Cobra and MicroFrame Program Manager
- Led the research, planning and implementation of the system on a new program. Transferred data from existing cost and schedule management system into new system. Performed extensive testing and troubleshooting.
- Basic usage of Enterprise, including database inquiries, report generation, exports to Excel, organization structure and chart logic review.
- Prepared detailed account mapping for seven business units, processed conversion of one year of historical data to the new chart of accounts and performed post-conversion data tie-out.
- Acted as liaison between Business Systems department and program financial management. This included attending project scope meetings, reviewing scope documents, project timelines,
- Automated the financial reporting process and developed Excel models and macros for translating and formatting data into existing reports and templates.
- Designed and conducted a training class to new users.
- Coordinated data tie-out and report design and creation.
Education & Credentials
- The Marshall School of Business, University of Southern California, MBA, Finance
- Westmont College, BS, Economics and Business, emphasis in Finance and International Business
Contact
us at
888.595.5600 | |