Project Clients & Past Employers

• Paramount Pictures, Television & Studio Groups (television syndication)
• Warner Bros Studio Stores, International Franchise Group (retail franchise)
• Westfield LLC, International commercial real estate management company with $63.2B in assets under management
• Apria Healthcare ($1B health services company)
• CB Richard Ellis ($1B global real estate services firm)
• Arcadian Healthcare ($600M Medicare Advantage health insurance provider)
• The Apothecary Shop ($100M specialty pharmacy)
• Silver State Helicopters ($100M helicopter flight training academy)
• ITS Pharmacy, Inc. ($60M specialty pharmacy)
• TNR Entertainment Corp dba MovieCube ($40M operator of DVD rental kiosks)
• PDQ Personnel Services, Inc. (privately held staffing agency)
• WorldSite Networks (internet hosting, web commerce start-up)
• Federal TransTel, Inc. (privately held telecommunications billing)
• AmSher Collection Services (mid-sized collection agency)
• Deloitte & Touche USA LLP - Clients included: Computer Sciences Corporation (SEC), Northrop Electronics, Trust Company of the West, R&B Investment Co. (real estate investor), Mission Insurance (litigation support), various real estate companies, REITS and construction contractors.

Functional Finance & Accounting Experience

Financial Reporting & General Accounting
• Hands-on and supervisory corporate controllership experience in a variety of large and mid-sized operations. Directed and participated in month-end and year-end closing processes, assuring the timeliness and accuracy of data including developing accruals, reconciling accounts and preparing journal entries; executed all tasks related to finance, accounting and systems for various entities including A/P, G/L, credit and collections, payroll and client service.
• Oversaw the development and operation of a business-class billing software platform serving MCI WorldCom as its major client.
• Designed, developed and prepared monthly operational reports, financial statements, trend and variance analyses, executive narrative and presentation materials.
• Designed, developed and implemented many databases and reporting systems which stored data in Access and sent processed data to Excel for reporting and distribution. Reports were interactive and included detailed revenue reports for field-level personnel, accounting reports and executive dashboards.
• Directed a payroll function processing 2,000 employees a year.
• Designed, developed and implemented all accounting policies, reports and systems for a start-up division.
• Designed and developed customized financial reporting including a multi-entity cash flow statement showing related transactions and total distributions to owners.
• Coordinated and supervised year-end audit schedule preparation and worked with external auditors through the issuance of their report.

Financial Audit & Internal Controls
• External audit background in real estate development, construction, defense contracting and computer services.
• Enhanced and maintained internal control processes for GAAP compliance.
• Planned and performed and/or oversaw financial and operational audits including inventory handling and costing and financial reporting.

Financial Planning & Analysis
• Hands-on and supervisory experience preparing annual operating plans, budgets and forecasts for multiple companies, utilizing top-down, bottom-up, zero-based and incremental budgeting methods.
• Designed, developed and implemented systems to accumulate, calculate, and present annual operating plan and budget information.
• Created charts and analyses to highlight operational activity and to analyze variances between actual and budgeted activity.
• Created several bottom-up financial models for businesses from a weekly transactional level. The financial models integrated with the financial statement systems to present transaction-level variances.
• Managed the strategic planning function including the development of business plans, market research, financial projections, analytical techniques such as SWOT and Five Forces, identifying implementation and integration issues and making recommendations.
• Re-engineered a 5-year financial plan model which included multi-dimensional revenue growth and tracking multiple scenarios. Process included significant changes in the way revenue dimensions are developed resulting in a model which is significantly more defendable by management.
• Participated in equity capital raise process which included development of a 5-year plan, draft and review of various distribution and presentation documents and providing information to potential investors.
• Developed and implemented a new approach to risk management that identified trends among clients and projected potential exposure to the company.
• Created a multi-period, multi-department financial planning system including loading actual data into the system for variance reporting.
• Developed a methodology and reporting system to estimate cumulative month end revenues. Used daily revenue data and a trend line developed from historical data. The model could project total monthly revenue within 2% by the 15th of the month.
• Determined that previous trending assumptions were inaccurate in a review of chargeback data and developed a new, significantly more accurate methodology.
• Performed an analysis which indicated a significant relationship between revenues and certain store-level demographics. Used these studies to change the way revenue projections are calculated.

Business Process Re-Engineering
• Extensive experience streamlining processes and controls and improving record retention efficiency and using common software applications to simplify and automate redundant tasks.
• Integrated barcode scanners into the payroll process resulting in greater efficiency and accuracy while eliminating tens of thousands of keystrokes each week.
• Developed and implemented an electronic billing interface with a major client which reduced DSO from over 40 days to less than 20.
• Designed, developed and implemented an electronic document archival system which reduced physical space requirements and long-term storage costs and increased document retrieval speeds.
• Improved efficiency, accuracy, and quality while reducing headcount requirements for a variety of processes including payroll processing, invoice processing, check processing, and electronic document archival.
• Designed, developed and implemented an invoicing system that retrieved pertinent archived documents and displayed it on the invoice along with the charge.
• Directed and participated in migrations to new accounting software packages. Process included documentation of existing system and new system, development of conversion plan, testing components of the conversion plan and executing the conversion.

M&A Transaction Execution & Due Diligence
• Supported sell-side due diligence reporting for an acquisition; coordinated response to buyer's request list, prepared financial statements and ad hoc analyses, answered subsequent questions and resolved issues as necessary.
• Participated in meetings with prospective buyers, private equity groups, investment bankers and other advisors.
• Interacted with investment bankers and attorneys in the preparation of the merger agreement and supporting schedules.
• Participated in a post merger accounting integration including the documentation of all systems involved and determining how to migrate syndication contract data.
• Performed all purchase accounting/goodwill transactions for an acquired company including determination of fair value for AR, AP, Inventory and miscellaneous balance sheet items. Included the calculation of a mid-month balance sheet and the analysis of a proposed retroactive change in the revenue recognition policy.

Corporate Restructuring & Turnaround
• Participated in a capital raise which involved significant modeling and forecasting. When capital raise failed, participated in an effort to restructure the company to reduce overhead and helped develop strategy to achieve better results from existing assets.
• Participated in several efforts to turn-around companies in cash flow crises; assessed market conditions and the company situation, conducted strategic planning sessions, and executed cost savings initiatives.
• Participated in the shut down of a company and a filing in bankruptcy court. Directed virtually all the logistics involved in the shutdown including coordinating HR, payroll, IT and legal roles. Accumulated all data necessary for the filing and completed the necessary forms including the Statement of Financial Affairs and various accompanying disclosures.

Systems Expertise: Selected Detail

Microsoft Excel
• Certified Microsoft Office Specialist - Excel 2007
• Expert Level Excel User including pivot tables, macros, advanced charting, graphing presentations (charts, trend lines, multiple scales), formula building (ISERROR, IF, VLOOKUP, HLOOKUP, GETPIVOTDATA), input validation, customization of toolbars and creation of user-oriented applications using controls and custom add-ins.
• Created financial statement reporting packages including the statement of cash flows utilizing pivot tables and other Excel tools. The reports were fully automated and involved no manual entries.
• Created comprehensive operational reporting tools in Excel including multi-axis graphs running on trailing 52 week data. Graphs were fully automated so that period data and client order were controlled from a centralized location.

Microsoft Access
• Certified Microsoft Office Specialist - Access 2007
• Expert Level Access User including database design, query construction and report development. Use of advanced techniques such as image imbedding and the utilization of custom add-ins. Creation of user-oriented applications using controls and self-executing macros.
• Created an invoicing system that output invoices in difference formats based on client requirements and imbedded an image of the archived timecard. For a major client, it suppressed the paper invoice and created an electronic file in the format required by the client.
• Created a paycheck processing system that processed paychecks and direct deposit stubs in tandem, scrubbed employee addresses against a USPS database, imbedded a POSTNET barcode and sorted the documents so that they would qualify for presort postage discounts. The presort discount varies by the level of concentration but is at least 21%.
• Created a payroll board system that takes data from the transaction processing system and formats it using barcodes. The users would then use the barcodes to enter payroll information instead manual entry. The barcodes were also used in the electronic archival of the timecards. The system eliminated tens of thousands of key strokes every week and greatly improved accuracy. The system was a self-executing routine that required no user interaction.

MAS90/MAS200/FRX/Crystal Reports
• Utilized MAS90 to prepare, review and post journal entries, export trial balance and transaction data and run inquiries into the A/P module.
• Designed and programmed financial reports utilizing the FRx report writer.
• Designed and programmed ad hoc reporting using Crystal Reports including creating table linkages.

Microsoft Dynamics GP
• Worked with outside programmers to complete an integration of this software with the client's transaction processing system. Shipped merchandise triggered the passing of data to GP which created the sales invoice and relieved inventory. The system also included processes to accommodate the company's revenue recognition practices (reserves and write offs).

Solomon IV
• Implemented Solomon IV
• Prepared detailed G/L account mapping and compiled historical data for conversion.
• Acted as liaison with Solomon IV consultants, the finance group and the operations group. This included attending project scope meetings, creation of system documentation, project timelines and scheduling staff from various other departments.

SAP R/3
• Limited SAP experience with G/L and Controlling modules.
• Developed reporting systems using Access and Excel which sourced data from SAP.

Blackline Systems
• Participated in the implementation of this GL documentation system for a billion dollar real estate company.

Education & Credentials

• California State University, Long Beach, MBA, Information Technology
• California State University, Northridge, BS, Accounting
• CPA, California
• Certified Insolvency and Restructuring Advisor (CIRA)