| |
Project Clients & Past Employers
- Ticketmaster Entertainment ($1B global ticketing and artist services company, subsidiary of Live Nation Entertainment)
- THQ ($665M, developer and publisher of interactive entertainment software)
- Abraxis BioScience, Inc. ($350M biopharmaceutical company, subsidiary of Celgene Corporation)
- J2 Global Communications, Inc. ($255M internet software and services)
- Fox Broadcasting Company (television programming provider, subsidiary of Fox Entertainment Group)
- Talon International, Inc, ($41M global supplier of zippers and other apparel accessories)
- FX (cable programming provider, subsidiary of Fox Entertainment Group)
- A&M, Geffen & Interscope (record label group, subsidiary of Universal Music Group)
- JD Power and Associates (global information services company, subsidiary of McGraw Hill)
- ArtistDirect.com (online digital media entertainment company)
- Medical Analysis Systems (manufacturer of diagnostics products for clinical laboratories, subsidiary of Microgenics Corporation)
- Jewish Home for the Aging (nursing home facility)
Functional Finance & Accounting Experience
Financial Planning & Analysis
- Hands-on and supervisory experience preparing $1B annual budget including deliverables, consolidation, management presentation and reviews. Coordinated and communicated changes approved by management to business leaders to ensure accuracy of the final budget. Also ensured that company wide initiatives were properly addressed and implemented.
- Managed consolidation of quarterly forecast, reviewed submissions and provided explanation for variances to the annual budget.
- Responsible for submission of completed consolidated budget and forecast to the parent company on a timely manner.
- Prepared general and administrative budget and actual to budget variance analysis for several departments.
- Partnered with field sales managers and division accounting leaders for preparation of annual budget and quarterly forecast for new products.
- Developed financial model to demonstrate new product viability and profitability.
Business Process Re-Engineering
- Streamlined month end close process for recording of sales deductions for a biopharmaceutical company from four days to three days.
- Coordinated with business units to develop ticket reporting by genre (concerts, arts, sports and family) that was not readily available due to different system platforms. This report was critical to explain business trends as each genre generated different level of revenue stream.
- Partnered with internal groups for development and improvement of process control including fraud prevention, chargeback process, launching new products and reporting requirements.
- Directed the programmer in the design and implementation of settlement calculation and reporting for multiple clients. Reviewed payment requests and proper support for settlement payments.
- Worked with the MIS department in the implementation of general ledger, accounts payable and payroll during a system conversion of a nursing home facility including account mapping, testing and reporting.
- Improved sales territory reporting including development of sales data base, annual plan, sales analysis and management/Board reporting packages,
Financial Reporting & General Accounting
- Responsible for reporting and financial analysis of all business units including financial reporting packages and executive summaries for management reviews.
- Managed and participated in month end close process for new products division including recording of revenue, sales deductions, chargeback expenses, amortization of sponsorship and general and administrative expenses. Communicated with division controllers for activity directly recorded in the business unit ledgers.
- Managed chargeback, credit and debit memos process in SAP for a biopharmaceutical company. Researched and resolved customers' issues related to chargebacks, credit memos and unknown deductions and payments. Developed and prepared payment schedule to streamline the calculation as well as to process payments timely.
- Evaluated chargeback processed mix in order to explain changes in expenses.
- Maintained fixed assets ledger and ensured proper recording of depreciation expenses.
- Designed and prepared gross to net revenue reporting package including revenue by client, price/ volume variance analysis, sales/royalty analysis, utilization/price analysis of sales deductions and changes in sales mix.
- Analyzed accruals and payments of sales deductions, and developed reporting to ensure appropriate future accruals.
- Researched and acquired documentation from customers for drug recall returns in order to process credit memos and to record expenses accurately. Worked closely with the Quality Assurance team to ensure the accuracy of vials returned and followed up with wholesalers to process credit memos.
- Assisted in the due diligence spin off of a public company's ticketing division, by verifying historical financial information and business metrics including ticket sold, event sold and other non-financial data.
- Prepared weekly profit and loss flash report for senior management including ticket sold, revenue, direct and indirect expenses.
- Participated in monthly result calls with all business units including Europe, Canada and Australia to better understand risks and opportunities and advised corporate team of any changes.
- Managed and coordinated ticket reporting and analysis. Partnered with the national data center for improvement and timely delivery of ticket reporting.
- Prepared reporting details to track business unit performance against company wide initiatives by market and by program.
- Supported preparation of the quarterly and annual press releases by providing business metrics and underlying financial data.
- Tracked and monitored special event costs for broadcasting company, which helped the related department manage and explain variance to budget.
- Analyzed programming inventory for television series, which included amortization and commitment of acquired and original programming as well as production costs and rights.
- Applied cash payments and reconciled against bank statements.
- Prepared audit schedules and interfaced with external auditors.
- Responsible for maintenance and reporting restricted and unrestricted funds for a nursing home facility.
M&A Analysis & Accounting Integration
- Assisted in the analysis of net revenue for acquisition of ticketing companies. Ensured the accuracy of financial data and non- financial data including client and contract information.
- Prepared net revenue pro forma for post merger analysis, identified opportunities for additional revenue stream and changes in revenue structure.
- Worked closely with the acquired company to ease the transition and integration including general ledger mapping, month end close procedures and reporting requirements. Provided training for system conversion as needed.
Systems Expertise: Selected Detail
Microsoft Excel
- Advanced Level Excel User including, pivot tables, formula building (IF, IF And/Or, Sum if, V-Lookup, H-Lookup etc), graph presentations (charts option, trend lines, axis scales), conditional formatting, subtotal and data validation.
Microsoft PowerPoint
- Proficient Level PowerPoint User including, creating slide masters, working with templates and layouts, creating graphs, slide transition and animation as well as creating and running slide shows.
SAP
- Familiar with FICO and AP modules, ran and modified general ledger reports, uploaded journal entries from excel and run inquiries on vendor history and information.
- SD module - ran sales reports, processed return good authorization, credit and debit memos, and ran inquiries on invoices, purchase order and sales order.
- Vistex, integrated with SAP for processing of chargebacks in a biopharmaceutical company.
Other
- Working experience with the following packages: Hyperion Enterprise, Cognos, Fox Pro and JD Edwards.
Education & Credentials
- Pepperdine University The Graziadio School of Business and Management, MBA
- California State University, Northridge, BS, Business Administration
Contact
us at
888.595.5600 or info@dlcinc.com |