Project Clients & Past Employers

• 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.
• Paramount Pictures, Television Group (television syndication)
• Paramount Pictures, Studio Group ($140M, multi-division operation)
• Warner Bros Studio Stores, International Franchise Group (retail franchise)
• TNR Entertainment Corp dba MovieCube ($40M operator of DVD rental kiosks)
• Silver State Helicopters ($100M helicopter flight training academy)
• PDQ Personnel Services, Inc. (mid-sized staffing agency)
• WorldSite Networks (internet hosting, commerce start-up)
• Federal TransTel, Inc. (telecommunications billing)
• AmSher Collection Services (mid-sized collection agency)

Functional Finance & Accounting Experience

Financial Reporting & General Accounting
• Hands-on and supervisory corporate controllership experience in mid-sized operations.
• 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 a database and reporting system 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.
• 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 key processes resulting in greater efficiency, accuracy and quality while reducing required ongoing labor. Processes included payroll processing, invoice processing, check processing, and electronic document archival.
• Designed, developed and implemented all accounting policies, reports and systems for a start-up division within Warner Bros.
• Supervisory and hands-on experience including G/L account reconciliation, bank reconciliation and account analysis.
• Provided seller-side due diligence reporting for an acquisition.
• Designed and developed customized financial reporting including a multi-entity cash flow statement showing related transactions and total distributions to owners.
• Participated in the post merger accounting integration of Viacom/Paramount Pictures Television Group including the documentation of all systems involved and determining how to migrate syndication contract data.
• Coordinated and supervised year-end audit schedule preparation and worked with external auditors through the issuance of their report.

Financial Planning & Analysis
• 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 bottoms-up financial models for businesses from a weekly transactional level. The financial models integrated with the financial statement systems to present transaction-level variances.
• 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.
• Managed the strategic planning function for a telecommunications billing company which involved the development of business plans, market research, financial projections, analysis techniques such as SWOT and Five Forces, identifying implementation and integration issues and making recommendations.
• Developed and implemented a new approach to risk management that identified trends among clients and projected potential exposure to the company.

Internal Controls & Process Engineering
• Extensive experience streamlining processes and controls and improving record retention efficiency.
• Extensive experience using common software applications to simplify and automate redundant tasks. Using Microsoft Access, 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 collection time on invoices to less than 20 days.
• Designed, developed and implemented an electronic document archival system which reduced physical space requirements and long-term storage costs and increased document retrieval speeds.
• Designed, developed and implemented an invoicing system that retrieved any pertinent archived document and displayed it on the invoice along with the charge.
• Supervised audits in public accounting in multiple industries including real estate, defense contracting and computer services.
• 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.

Financial Modeling
• Extensive experience building, improving and refining budget and forecast models.
• Developed and designed a multi-period, multi-department financial planning system for Paramount Pictures Studio Group. Actual data was imported into the system for variance reporting.
• Substantial experience in data analysis and identifying trends. In a review of chargeback data, determined that previous trending assumptions were inaccurate 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.

Restructuring & Insolvency Counseling
• 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 an effort to turn-around a company in a cash flow crisis. This involved assessing market conditions and the company situation, strategic planning and the execution of a cost savings initiative.
• 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 the various disclosures that accompany it.

Systems Expertise: Selected Detail

Excel
• Expert Level User including pivot tables, macro creation, advance charting, graphing presentations (charts, trend lines, multiple charts), 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 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.

Access
• Expert Level 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 imbeds 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.

Solomon IV
• Implemented Solomon IV at Warner Bros. International Franchise Group.
• 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 experience with G/L and Controlling modules.
• Developed reporting systems using Access and Excel which sourced data from SAP.

Education & Credentials

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