Robert Amos
Accountant/ Bookkeeper · Seasons Direct, Inc
Los Angeles, CAWork Experience
Accountant/ Bookkeeper
Seasons Direct, Inc2016 – 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 Entertainment2015 – 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. Entertainment2014 – 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. Cellular2014 – 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)
Gohealth2013 – 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. Cellular2013 – 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 Foods2012 – 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. Entertainment2012 – 2012
• Analyzed and compared data from two SAP databases
• Audited and Cleared 11,000 records
Sr. Accountant (Finance)
Warner Music Group2011 – 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 Entertainment2009 – 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. Entertainment2007 – 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 UniversityEconomics Bachelor of the Arts Degree