Resume

Sign in

Sales Data Analyst

Location:
Oxnard, California, United States
Salary:
67,000
Posted:
September 12, 2018

Contact this candidate

Resume:

Kurt Felix Wong

**** ******* ***. **** ******, CA, 93063

ac6026@r.postjobfree.com

818-***-**** cell phone

Summary:

Results driven; Strong attention to detail; Excellent analytical skills; Ability to communicate effectively with internal teams including senior management; Self-motivated; Organized; Effective management skills; Team player and prefers to work in a fast-paced environment; 7+ years of work experience in the entertainment and/or finance industry with a track record of advancement; Ability to lead and effectively motivate internal team members and external parties

Education:

University of California, Los Angeles 09/00- 09/04

B.A. International Relations

Date of Graduation: Summer 2004

Employment history:

Sheraton Universal, 5/18- current

Universal City, CA

Sales Reporting Analyst

Run Sales and forecasting report for the Sales Team

Work directly with sales representatives to assist in the completion of sales contract

Evaluates potential enhancements to current reports or makes recommendations for new reporting.

Record and report monthly sales results

Facilitate the flow of information between the Accounting and Sales departments

Update and maintain a record of data extracted from the sales contracts

Entertainment Partners, 11/16- 12/17

Burbank, CA

Associate Manager – Residuals setup Basic Cable/Theatrical

Manage and oversee operational processes of Residuals staff to ensure accuracy and timely deliverables for Basic Cable Market and Theatricals

Prepare and review morning status reports for Basic Cable/Theatrical setups

Liaison between Residuals Account Managers and Residuals staff

Coach and develop team building efforts to strive for high morale and comradery

Sony Pictures Entertainment, 05/13- 11/16

Culver City, CA

Residuals Administrator – Sony Motion Pictures Residuals

Analyze and interpret production and distribution contracts for residual liability

Setup and report residual liabilities

Administer residual calculations and payments for owned original content

Perform Sony Music royalty payments

Interpret the SAG, DGA, WGA, AFM and IATSE collective bargaining agreements

Researching and responding to various written correspondence and oral inquiries pertaining to residual payments from the guilds, talent, and management while ensuring compliance

Time Warner Cable., 03/12- 04/13

Van Nuys, CA

Inventory Coordinator

Analyze daily, weekly, and monthly inventory integrity queries to modify transactions, solve reporting issues to root cause, and ensure inventory records are accurate

Coordinate with vendors on product lead times

Add, modify, and delete items in the inventory systems including master file information and cost

Assist Operations Management with coordination of physical inventories and cycle counting

Monitor inventory levels and PO delivery. Prevent back-orders or excess inventory.

Analyze vendor productivity and customer satisfaction levels to ensure support of supply requirements

Randstad Corporation., Contractor 10/11- 12/11

Century City, CA

Retail Analyst – Fox Home Entertainment

Support account teams with fact-based selling and provide in-depth planning, analysis and reporting to drive growth at Fox’s retail accounts

Deliver in-depth analysis of New Release, Catalog and TV promotions at the account level, including spending and lift associated with programs, returns analysis, shipment analysis, and seasonality trends

Monitor title level sales/shipments for accounts in order to develop more effective sales programs

Lionsgate Entertainment Corp., 06/10- 05/11

Santa Monica, CA

Inventory Reconciliation, Coordinator- Lionsgate Home Entertainment

Daily identify, reconcile, and correct inventory balance inaccuracies in assigned warehouses and locations

Collaborate with I.T. to develop new business metrics eliminating redundancy and enhancing time efficiency

Resolve 861 iDoc failures caused by Stock Deficits

Prepared for and participate in the Annual Cinram Physical Inventory in Huntsville, Alabama

Retrieve daily ad hoc reports from SAP database and process through V-lookups

Create inventory control standard of procedures as reference for current employees and new hires

Warner Bros. Home Entertainment, 09/08- 04/09

Burbank, CA

Inventory Operations, Analyst- Warner Bros. Home Video

Identify, reconcile, and correct Inventory balance inaccuracies in assigned warehouses

Manage 861 iDoc failures caused by Stock Deficits to resolve inventory discrepancies and increase efficiency

Monitor and manage the Aging of Purchase Orders by purging remaining low inventory balances

Prepare for and participate in weekly Cinram and 3rd Party Physical Inventories and reconciliations to ensure accurate inventory levels

Develop and deploy metrics measuring departments’ Inventory Accuracy results

Retrieve daily ad hoc reports from SAP database and process through V-lookups

Create procedural standards for inventory control as reference for current employees and new hires

NBC Universal, 08/07- 08/08

Universal City, CA

Contractor- Universal Home Entertainment Data Analyst

Develop, analyze, and monitor new, routine and monthly ad hoc reports for Account Executives

Retrieve daily ad hoc reports from SAP database and process through V-lookups

Provide analytical support when compiling and reporting inventory information

Develop recommendations and alternatives for management review and presentation

Technical skills:

C++ Programming, Advanced MS Excel, MS Access, SAP Database, Tableau 9.0

Certificate(s):

Data Science (currently pursuing)

SQL (currently pursuing)



Contact this candidate