Consultant TAH03 - Senior Financial Consultant

Los Angeles

Finance

Senior Experience Level

 

Consulting                                                                                    9/2009 – Present

Senior Financial Consultant

Large Global Multinational Entertainment Company Los Angeles

International Television Distribution (Interim Financial Director)

  • Responsible for coordinating the timely and accurate completion of financial reports including the consolidation and preparation of financial statements (P&L, balance sheet, SG&A, cash flow) for monthly forecasts, actual monthly/quarterly closes, annual budgets, semi-­annual forecasts, and long-­term (multi-­year) plans

  • Oversee SG&A overhead reporting including accruals and budgeting/forecasting and review of actuals and Inter company variance analysis

  • Work with corporate financial reporting & budgeting, enterprise financial service, tax, and participation & residuals departments in the resolution of financial issues

  • Oversee the client’s channel’s financial activities such as monitoring and reconciling the inventory, contract payments, subscription sales with HBO, and ad sales with Turner

  • Review the monthly financial statement upload of foreign offices in Brazil and Venezuela

  • Coordinate compilation of schedules and responses to facilitate reviews and audits performed by both internal and external auditors

  • Assist with preparation and on‐going updates of Sarbanes­‐Oxley (SOX) Act compliance documentation narratives

  • Monitor and analyze monthly earned AR journal entries generated by new internal COSMOS contract system

  • Perform various special projects and ad‐hoc reconciliations as required

Shared Services – Enterprise Finance Services

  • International Home Office Reporting: analyzed & prepared financial close of financials such as P&L, B/S, Cash Flow, footnotes and disclosures, supplemental schedules, monthly validation checks for out of balance journal postings with corresponding trading partners, inter-company balances analysis and follow up on timely clearing by territories, cash clearing postings, refresh of BW reports to check results against SAP, various quarterly and annual regulatory government reporting, and territory’s income withholding tax reconciliation.

  • Managed dates in the submission close calendar per FRB email correspondences & monitored territory’s submission of the monthly/quarterly close deliverables to FRB in eroom.

  • Ensured timeliness of overall monthly close activities in CLOCO, accuracy of close processes and management of BPO activities for Switzerland and Germany for 2 months.

  • Prepared desk top procedures and hands on training.

Large Global Entertainment Company– International Finance Group

  • Financial statement reporting: reviewed and analyzed major European & Asia Pacific territory’s financial statements including balance sheet review, analysis of divisional reserves and allowance calculations, P&L variances to Plan, accounts receivable aging, currency translation adjustment review, P&L foreign exchange analysis and other supplemental and footnotes disclosures.

  • Corporate support: reviewed the calculation and proper recording of Management Fees, MUR (Master Use Royalty) to ensure compliance with underlying agreements, identify transactions that are not being properly captured under these agreements and make recommendations to tax and legal departments to amend agreements.

  • New initiates support: assisted various task forces as they relate to new Company initiatives to streamline and standardize reporting process.

  • Prepared ad hoc request from corporate or management.

Large Global Entertainment Company -Consumer Products and Interactive Media  

  • Prepared journal entries for month‐end, quarter‐end& annual close.

  • Prepared & analyzed monthly balance sheet account reconciliation & uploaded to SAP’s reconciliation tool for review

  • Provided variance explanation of monthly balance sheet for review and presentation with Management.

  • Prepared various government schedules and surveys as needed.

  • Prepared monthly Gift Card & C3 (Rewards Card) Reimbursement form and reconciliation.

  • Prepared & submitted MPM requests in SAP per merchandising team’s requests.

  • Reconciled & reviewed Amazon & eBay transactions to Mozart and weekly settlement to SAP.

  • Created desktop procedures for reconciliation on business partnership with Amazon & eBay.

  • Completed Tax Driver Federal and State Package & footnote disclosures.

 Financial Consultant                                                                                                 5/2002 –3/2009

 Large Global Entertainment Company

International Television Distribution (Interim Manager)

  • Responsible for managing and reviewing all aspects of monthly close process.

  • Reviewed consolidated financial statements for accuracy and compliance to GAAP.

  • Reviewed Turner, HBO & New Line participation calculations, periodic reports including Statement of Operations, TV/TH split, footnote submission, Imputed Interest Discounts & subsequent Imputed Interest Income, and quarterly Inter company Copyrights holders Participation statement.

  • Prepared T & E analysis report by summary, country, and person against budget & forecast.

  • Responded to inquiries related to monthly results from senior management & Corporate Accounting.

  • Prepared & reviewed annual budget and semi annual forecast including forecast overhead, capital expenditures, advertising, print & ad costs, and participation expenses.

Large Retail Theatres

  • Responsible for month‐end close activities and P&L review for all 11 Hawaii theaters and accruals and annual reconciliation of Coke rebate and AOL/Movie Ticket.com contracts.

  • Prepared actual vs. budget variance analysis for consolidated HI locations.

  • Reviewed leases and contracts to ensure compliance with terms

  • Prepared percentage rent reports and schedule monthly theater rent, CAM, property tax, insurance, and utilities expenses payments.

  • Prepared and created procedures for HI bank reconciliation and interact with theatres to resolve discrepancy.

  • Calculated Hawaii Gross Excise Taxes and file monthly returns.

  • Assisted in preparing auditor work papers (annual audit)

Large Global Entertainment Company - Studio Controllership

  • Created query of BW reports in SAP to compile MPAA annual revenues and expenses survey for domestic and international Theatrical, Home Video, and Television units.

  • Coordinated and compiled various quarterly regulatory reports for all studio production business units.

  • Created various ad hoc and special projects as necessary.

Large Insurance Medical Company, Pasadena

  • Compiled various monthly schedules and charts on financial data and performance indicators for Hospice, Pharmacy Service Area, and Outside Security.

  • Researched variances from budget and prior year.

  • Developed desk procedures.

  • Created various ad hoc and special projects as necessary.

Large Global Multinational Record Label (4Bil), Los Angeles

  • Responsible for the financial records including the compilation of monthly, quarterly, and year-­‐end journal entries and interaction with management to resolve issues

  • Prepared financial statement packages and various supporting schedules

  • Resolved inter company variances and various issues in the legacy system (PeopleSoft) and SAP

  • Set up account reconciliation for 3 BVMG’s record labels

  • Compiled desk/job functions procedures

 Large Global Entertainment Company, Burbank - Television Studio Production Accounting

  • Compiled and monitored the development and production spending for Walt Disney’s Television Animation, Direct­‐to­‐Video, and Feature Animation units and resolve any issues as necessary

  • Monitored and adjusted overhead cost for production spending per appropriate overhead rates

  • Analyzed and monitored the actual development and production cash flow against forecast and budget

  • Monitored write­‐off, transfer, and network reimbursement to ensure accuracy in film inventory

  • Prepared various monthly, quarterly, and annual financial reports for development and production spending, various inventory audit schedules, special projects, and ad-­hoc reports

  • Reconciled the legacy system’s inventory to ensure complete conversion to the new SAP system

  • Redesigned all inventory spending schedules to conform to the new platform in SAP

 

Large Global Entertainment Company; Culver City                                                7/2000 –9/2001

Accounting Manager of International TV Production

  • Compiled, analyzed and monitored financial performance and operation of 10 overseas territories to ensure reporting conformity to U.S.GAAP

  • Consolidated overseas territories’ trial balances and cash flows for completeness, reasonableness & accuracy

  • Performed network billings, collection status update, and accounting support to Game Show Format Sales by analyzing all sales contracts and related funding memos

  • Consulted international financial controllers and operation personnel on budgets, forecasts, and various accounting and operation issues

  • Analyzed financial operation variances from budgets to fine tune the quarterly forecasts and 4‐year‐plan

  • Developed TV show ultimate profitability estimates to monitor the production status, cost, and revenue

  • Streamlined and automated various month-­‐end close schedules for management and financial reports

Large Global Law Firm                                                                      5/1999 –7/2000

Accounting Manager

  • Managed 4 staff accountants responsible for the general ledger/financial reporting functions of the US & 4 foreign offices and resolved issues as necessary

  • Oversaw the multi­‐branches’ month-‐end close including the review of journal entries, 60 plus account analysis, bank reconciliation, fixed assets, and retirement investment account

  • Prepared financial statements, foreign office income tax work papers, and documentation of procedures

  • Coordinated and prepared year-­‐end and interim audit schedules

Large Non-Profit Automobile Association                                                               1/1994 –5/1999

Senior Accountant

  • Supervised and provided technical supports to staff accountants & accounting clerks

  • Assisted in the annual budget development and monthly forecast

  • Prepared and analyzed consolidated operating statements, supporting schedules, cash flow, budget variances of revenues and expenses, and year end audit schedules

  • Coordinated & prepared multi‐companies’ journal entries on income and expense accruals, prepaid expenses, amortization, adjusting entries, and expense allocation

  • Recorded and reconciled employee benefits expenditures in medical health insurance, pension expenses, and post­‐employment and post­‐retirement benefits

  • Compiled annual financial reports such as the Motoring Club Statement, survey, and economic census

Pioneer Electronics Services                                                                     4/1993 - 12/1993

Staff Accountant

  • Responsible for the month-‐end close and journal entries on inventory, depreciation, adjusting entries and inter-company cost allocation in accordance with GAAP

  • Journalized inventory receipts from Tokyo, domestic purchases, freight & duty, transfer, and adjustment

  • Initiated and developed the general ledger accounts reconciliation

  • Analyzed and reconciled 4 disbursement bank accounts

Large Outdoor Media Company                                                    7/1991 -­ 2/1993

Staff Accountant

  • Prepared journal entries on income and expense accruals, inventory, depreciation, adjusting entries, and inter company transactions in accordance with GAAP

  • Monitored the fixed assets' acquisition, depreciation, transfer, sale and disposal against the budget

  • Re-established and monitored the fixed assets system for the Northern California division

  • Prepared sales & use tax return and backup withholding tax return

  • Reconciled accounts receivable & payable balances and investigated inter company discrepancies

Large Global Cosmetics Company                                                                        7/1990 -­‐5/1991

Staff Accountant

  • Updated and analyzed various professional expense accounts

  • Reconciled both the federal and state fixed assets tax depreciation schedules

 COMPUTER SKILLS

Windows XP, Microsoft Office – Excel, Word, Access & PowerPoint, Essbase, AS 400, Dun & Bradstreet MSA accounting systems, Elite, Hyperion, Peoplesoft, SAP, and JD Edwards

 

EDUCATION

  • Master of Business Administration, Option in Computer Information Systems, California State University, Los Angeles

  • Bachelor of Science in Accounting (Magna Cum Laude), University Of SouthernCalifornia

  • Active California CPALicense

Contact us