RA

Robert Amos

Accountant/ Bookkeeper · Seasons Direct, Inc

Los Angeles, CA

Work Experience

Accountant/ Bookkeeper

Seasons Direct, Inc

2016 – 2018

(Consumer Products/ Manufacturing) • Processed daily A/R, A/P transactions in Quickbooks. • Made month-end JE to GL to close out accounts and adjust accruals • Put together monthly financial statements (cash flow, receivables, P/L) • Maintained inventory report and amortization schedules.

Financial Analyst (Digital Entertainment)

FOX Entertainment

2015 – 2016

• Reconciled customer royalty statements to verify contract compliance using advance Excel formulas • Read through client contract and translated to Excel spreadsheet. • Invoiced clients for minimum guarantees and earnings overages • Identified $5 million in revenue for client in six-month period.

Financial Analyst (Home Entertainment) Participations Analyst (Participations)

Warner Bros. Entertainment

2014 – 2015

• Reconciled credit memos to A/R entries using advance Excel functions. • Prepared analysis of transactions in ERP system using Excel spreadsheet. • Updated Process log (Excel spreadsheet) to make it more automotive by linking to various spreadsheets using vlookup and INDEX function.

• Created a variety of status reports by using pivot tables.

Supply Chain Analyst (Supply Chain)

U.S. Cellular

2014 – 2014

• Manage, organize, and coordinate inventory return reports in database

• Using Excel spreadsheet (vlookup, pivot tables) to create analyst report of devices returned

• Created template for SAP upload, used SAP MM

Data Analyst (Sales)

Gohealth

2013 – 2014

• Using Excel spreadsheet (vlookup, pivot tables) put together report to analysis call volume vs. sales by state and time of day.

• Performed a trend analysis using sales and performance data over a period of days, weeks, and months.

• Audited and Analyzed call center activity on a daily basis

• Analyzed data of sales over months using pivot tables, 'if' functions, and other advance functions.

Financial Analyst (Supply Chain)

U.S. Cellular

2013 – 2013

• Manage, organize, and coordinate an online auction of excess inventory device to liquidate inventory

• Using Excel spreadsheet (vlookup, pivot tables) to create Sales vs. Returns analyst report of devices over a three-year period; identified trends.

• Create a line of communication between warehouse distribution center and customers.

• Review data collected from online auction and develop trend reports using Excel Spreadsheet.

Demand Planning Analyst (Demand Planning)

McCain Foods

2012 – 2013

• Analysis actual sales volume with forecast vs approved using Excel spreadsheets.

• Validate supply demand data from SAP with data from Crystal systems.

• Create trend analyst reports.

Sr. Analyst (Financial Contracts Reporting & Administration)

Warner Bros. Entertainment

2012 – 2012

• Analyzed and compared data from two SAP databases

• Audited and Cleared 11,000 records

Sr. Accountant (Finance)

Warner Music Group

2011 – 2012

• Posted daily Sales to general ledger in SAP system

• Made month-ending and quarter-ending close entries to adjust deferred revenue, inventory, and expenses to general ledger.

• Mined data from SAP FI module to Excel spreadsheet then used a pivot table to create report for management review.

Financial Analyst

Digital Entertainment

2009 – 2011

• Using several Excel spreadsheets organized royalties due by customers based on contractual analyst.

• Tracked payments made and due to vendors by creating a variety of formulas on Excel spreadsheets based on contractual agreements.

• Managed and prepared a series of reports (pivot tables) on monthly basis for management.

Sr. Accountant (Home Entertainment)

Warner Bros. Entertainment

2007 – 2008

• Managed a series of spreadsheets analyzing the $1 billion financial activity for a 10 DVD release comparing the actual sales to forecast sales (including percentage change) for current quarter, YTD, and inception-to-date

• Prepared reports that analyzed COGS, Cash Flow, and EBTIDA against actual and forecast.

• Created ad hoc reports from data dumps from SAP FI system.

Education

Economics Bachelor of the Arts Degree

Indiana University

Economics Bachelor of the Arts Degree