.
DLC inc.
Consultant KS, MBA
. .
 

Project Clients & Past Employers

  • Thomson/Technicolor (Entertainment)
  • Spark Network (Entertainment)
  • ACT Litigation (Legal Data Duplication)
  • 99 Cent Only (Retail)
  • Concord Music Group (Entertainment)
  • Paramount Pictures.- (Entertainment)
  • THQ INC.- (Video Gaming/Entertainment)
  • Warner Bros. Studios- Corporate Theatrical Production (Entertainment)
  • HR Textron- Missiles Division/Systems Implementation Team (Aerospace)
  • Washington Mutual Bank- Financial Reporting/ Activity Based Costing (Banking)
  • International Rectifier- Corporate Accounting (Semi Conductor Manufacturing)
  • Walt Disney Co. Animation/Music Publishing (Entertainment)
  • Kal Kan/Mars Inc.-In Market Finance- (Food Manufacturer)
  • DirecTV- General Accounting (Satellite/Cable Provider)

Functional Finance & Accounting Experience

    Financial Reporting & General Accounting
  • Management and hands on experience in all aspects of g/l accounting, including month-end closing, P&L and reconciliation account analysis, financial statement preparation, inter-company eliminations and consolidations
  • Managed domestic and international consolidation of balance sheet & P&L on a monthly, quarterly and yearly basis for US and 3 international entities.
  • Improved month-end closing process and issuance of monthly financials from 5 days to 2 1/2 days.
  • Improved processes and procedures for fixed asset accounting, including fixed asset impairment for 3 entities.
  • Published accounting processes and procedures for construction-in-progress (CIP) & fixed assets.
  • Created process documentation for work flows for Sales and Accounting functions.
  • Prepared SEC Forms 10-Q, 10-K, footnotes and disclosures and MD&A.
  • Prepared year-end audit schedules and interfaced with auditors
  • Supported SOX compliance effort including mapping of processes and procedures, delineation of roles and responsibilities, and other associated tasks
  • Prepared domestic and international tax packages.
  • Managed monthly, quarterly and annual cashflow analysis and reporting.
  • Managed and analyzed the negotiations of music catalog asset acquisitions
  • Managed International Pay Television Contract Administration
  • Managed and assisted in the creation of International VAT tax procedures.
  • Managed Royalty and Inventory reporting.
    Financial Planning & Analysis
  • Built operating budget and plan for 250MM ++ entertainment division
  • Managed domestic and international hedge budgets including on-going currency translations and revaluations.
  • Performed activity-based costing analysis including product profitability and overall business performance
  • Built financial models enabling executives to evaluate viability of products and services of within various business segments
  • Created new bottoms-up detailed financial model for sales and marketing executives and trained non-finance associates to analyze summary budget-to-actual detail
  • Developed trade, consumer and advertising promotion budges totaling $400M.
  • Implemented improved sales policies and procedures for deduction management including financial model development and reduction of DSO.

Systems Expertise: Selected Detail

    SAP
  • Functional expert for Project Accounting and Program management. Performed advanced analytical, research-related and or consultative activities to administer and maintain operations, policies/procedures and guidelines related to SAP project system accounting conversion.
  • System testing configurations and validations expert.
  • System validations for WBS, Network activities, Sales, COS, WIP/Inventory and resource related billing, results analysis, CTD/MTD/YTD capital expenditures.
  • Earned Value analysis, calculations, conversion and validation
  • Trained and mentored staff to handle pre- and post Go-Live requirements
    Hyperion
  • Basic usage of Enterprise including consolidations, running and verification of reports, uploading of external database financial information, and data imports/exports from/to Excel
  • Reviewed data tie-out of financial information of imports in Essbase
    PeopleSoft
  • User knowledge of accounting module functionality including creation & posting of journal entries, query detail analysis, financial reporting, exporting, sales & invoice creations etc.
    Excel
  • Intermediate to advanced capabilities including V-look up, pivot tables, macros, if statements, advance financial modeling, charts, trends, database linking, exports from various systems; completion of some visual basic coursework.
    SMACS
  • Intermediate to advanced capabilities including contract administration, invoicing, reporting, and basic queries
    IMPROMPTU
  • Intermediate capabilities including query creation, report importing and exporting.
    MAS 500
  • Intermediate capabilities including data inquiry, journal entry and report creation for exporting.
    LOFT
  • Intermediate capabilities including data inquiry, billing/order entry, deal creation, updates and report creation for exporting.

Education & Credentials

  • Pepperdine University, MBA
  • California State University, Northridge, B.A.

 

Contact us at 888.595.5600