Financial Analyst Data

DIANA CEVALLOS

**** *. ***** ****** #**, Burbank CA, 91505

Cell phone: 407-***-**** / Email: adjw57@r.postjobfree.com

TWENTIETH CENTURY FOX STUDIOS – Account Service Coordinator June 2016 – June 2020

Processing manual, EDI PO & VMI account for Fox, Anchor Bay, MGM, DreamWorks Animation, Lions Gate, Sunrise Records (Canada) & Best Buy (Canada) for DHE Prod Promotion Mgmt. department. Also maintain continuous flow of information between sales reps, customers, 3rd party vendors, and distribution center contacts. Plus handling Walmart Hotline customer inquiries in a timely manner. Entering data using JD Edwards & Siebel systems.

THE MERGIS GROUP – RANDSTAD PROFESSIONAL STAFFING LLC

Randstad @ Warner Bros. Consultant – Senior Financial Analyst April 2016 – April 2016

Assisted with forecasting regarding revenue accruals for Consumer Products Finance. Entered data utilizing Excel.

Randstad @ Warner Bros. Consultant – Analyst June 2015 – December 2015

Generated billing through analyzing daily work orders submitted to Post Production Services (PPS) for processing from various clients in Feature, Animation, & Games productions. Ensured all PPS bookings made by client were accurately entered into Xytech and properly billed to clients. Ensured any revenue earned but not invoiced is accrued each month end. Responsible for cash uploads regarding payments received from clients. Contacted “C.O.D” clients to ensure payment was received upon receipt of invoice. Entered data utilizing SAP, Excel and Xytech.

Randstad @ Warner Bros. Consultant – Credit Analyst March 2015 – May 2015

Assisted supervisor with generating A/R forecasting reports, recreated financial statements sent by Brazil, US/Canada & Mexico accounts to excel format & sent bank & trade references to customer. Administrative duties such as copying & sorting files. Entered data utilizing SAP, Excel & Business Objects.

Randstad @ Warner Bros. Consultant – Senior Financial Analyst August 2014 – March 2015

Assisted in financial month-end closing procedures by analyzing financial data to identify and initiate necessary P&L adjustments and accruals, submitted journal entry requests and ensured timely posting for Studio Facilities department. Provided accurate selection of G/L accounts used for creating purchase orders. Verified and billed First Aid billable hours. Plus researched invoice discrepancies and processed invoices for business unit approval. Also reconciled petty cash. Entered data utilizing Capital Budgeting System (CBS), FoxPro, SAP and Excel.

Randstad @ Warner Bros. Consultant – Financial Analyst June 2013 – June 2014

Responsibilities included preparation of accruals and re-classes, variance analysis and preparation of month end close reporting package. Shopping cart maintenance, PO creation, and SAP coding on PWO’s for Corporate Projects & BPO towers (AP, Procurement, R2R, ITC, SOX). Invoice maintenance such as review coding, validate contract pricing, research invoice discrepancies and process invoices for business unit approval. Support budget and forecasting process, cost tracking and maintenance of Corporate Projects & BPO tower models. Also handled special projects for Technology Business Management (TBM) such as creating & updating monthly Project Financials. Enter data in data utilizing SAP, Clarity & Excel.

Randstad @ Warner Bros. Consultant – Financial Analyst November 2012 - April 2013

Researched, compiled and analyzed data for the International Television Distribution Rights Administration department during the Cosmo system conversion. Reconciliation of TV titles/episodes of data for rights, restrictions and release window. Also verified that Delta Title attributes data was converted from ITD Staging to SAP as expected. Plus SAP projects such as pushing down rights to episodes against TV titles & testing of data. Entered data utilizing ITD (Extra) system, SAP and Excel.

Mergis @ Warner Bros. Consultant – Senior Financial Analyst February 2011- September 2012

Prepared Home Video & Games participation statements to ensure accuracy & compliance with contractual obligations. Analyzed income & expense activity for discrepancies. Able to read & understand digests/abstracts of legal agreements and other related written correspondence in the picture jacket file. Entered contract master deal setups into Gatekeeper for Deal Review & Control department. Also scanned contract masters into EDOCS system. Plus handled deal setup inquiries. Entered data utilizing VCAS/Vanguard systems, Gatekeeper financial system, SAP and Excel.

Mergis @ Warner Bros. Consultant – Financial Analyst June 2010 – February 2011

Processed and updated Domestic, Mexico & Games Sales deal requests for the Home Video Sales Administration department. Also trained staff on Mexico Sales deal & entered pricing for such deals. Verified pre entry audits for discount programs from retailers. Verified net cost & discounts for Wal-Mart deals. Plus handled special projects for management which dealt with Black Friday & Boxing programs, cutouts, & pricing audits. Entered data utilizing Siebel/Presidium system, SAP and Excel.

Mergis @ Warner Bros. Consultant – Financial Analyst May 2010 – June 2010

Created credit & debit memos for HV Credit & Customer Operations department. Also created worksheets for on-hand units/costs & uploaded data into SAP for price protection. Plus verified back up for customer case claims/disputes & handled special projects for management. Entered data utilizing SAP and Excel.

Mergis @ Warner Bros. Consultant – Financial Analyst April 2010 – May 2010

Processed and updated Sales deal requests for the Home Video Sales Administration department. Also

verified pre entry audits for discount programs from retailers. Plus handled special projects for management. Entered data utilizing Siebel systems, SAP and Excel.

Mergis @ Warner Bros. Consultant – Financial Analyst March 2010 – March 2010

Responsible for recreating a large audit request tracking file for the Participation department. The file was corrupted and MIS department was not able to recover. Tracking file was recreated utilizing Excel.

MODIS AGENCY @ Warner Bros. Consultant – Senior Financial Analyst Nov 2007 – Feb 2008

Responsibilities included working with SAP financial system and analyzing methods to increase the efficiency of this system for the MIS department. Streamline all invoices for the MIS department and created methods to increase timely payments to vendors. Provided Director with procedures regarding daily operations such as creating shopping cart requests & financial reporting maintenance process.

PARAMOUNT PICTURES Finance Director August 2006 – June 2007

Responsibilities included budgeting & financial analysis for Vantage film division. This included analyzing & updated Estimated Film costs for Marketing & Distribution budgets. Monitored actuals against budget & provided weekly variance analysis & explanations. Also attended weekly budget meetings with department heads and management to discuss overages and/or resolve any budget issues. Implemented & handled departmental inquiries on new finance policies & procedures. Plus worked closely with IT on new SAP financial system for division. Handled daily operations such as supervising a coordinator, reviewed invoices & PO requests. Division spending was tracked utilizing Excel, Impromptu & BIS mainframe systems.

DREAMWORKS PICTURES

Finance Manager January 2005 – June 2006

Responsibilities included budgeting, forecasting, and financial analysis for International Marketing & Distribution on Live Action and Animation films. This included preparing Los Angeles & London budgets, generic budget models, annual overhead budgets, quarterly overhead forecasting, monitor actuals against budget and providing monthly variance analysis and explanations. Also reviewed UIP Head Office budgets & compared budget vs. actuals in local and US currency. Monitored UIP reports on current films which included Advertising & Publicity budget vs. actuals, print actuals & Home Office variances. Additionally, prepared BAFTA budgets for awards campaign & adhering to Sarbanes-Oxley policies during testing phase. Provided guidance & support to Worldwide Technical Services during SOX testing. Handled daily operations such as supervising one clerk, approved purchase order requests, invoices, expense reports and online purchase orders. Division spending was tracked utilizing Excel, Midas and Oracle financial systems.

Financial Analyst July 1999 – December 2004

Responsibilities included budgeting, forecasting and financial analysis for International Marketing, Domestic Distribution & Theatrical Marketing Services. Prepared Marketing & Distribution overhead budgets, quarterly overhead forecasting, & Distribution Pre-Release budgets. In addition, prepared BAFTA, Academy & Golden Globes budgets for awards campaign. Also reviewed and handled Home Video media costs and updated Media Broadcast costs for Domestic releases. Handled daily operations such as approving purchase orders, invoices and expense reports.

Finance Coordinator July 1998 – June 1999

Responsibilities included processing purchase orders, matching invoices with purchase orders, entered data in the media planning system, analytical research, maintained that actuals did not exceed approved budgets, & filing. Also reviewed and coded media & newspaper invoices for payment.

Accounts Payable Clerk March 1996 – June 1998 Responsibilities included processing invoices and check requests for payment. Verified coding, approval signatures and bank accounts. Also handled vendor and departmental inquiries.

FOX BROADCASTING COMPANY Accounts Payable Clerk August 1995 – March 1996

Reviewed and coded invoices for payment. Also processed month end accruals. Set up vendor/1099 file maintenance. Entered data on IRMA system.

SONY PICTURES ENTERTAINMENT Senior Account Payable Clerk Jan 1995 – Aug 1995

Coded invoices, expense reports and check requests for payment. Assisted controller with month end closing and administrative duties. Also posted daily program schedules and billing for The Game Show Network Traffic Department. Entered data on Excel, WordPerfect, Dynamics and Enterprise systems.

EDUCATION IONA COLLEGE, New York Bachelor of Business Administration

Contact this candidate