Sergio Chavez Email & Phone Number

Los Angeles Metropolitan Area

Culver City, California, United States

∙ Responsible for quarterly accruals, monthly forecasts, and long-range planning efforts. ∙ Served as the central point of contact for 10+ business partners within the Business Affairs and Development Teams. ∙ Performed cost runs, term deal expense reports, and project analysis for business partners and senior management. ∙ Ran Tableau queries, reconciling inception to date term deal and project spend to internal development reports. ∙ Tracked and forecasted development spend through updating deliverables and utilizing Polaris to pull delivery notices. ∙ Managed bookings of quarterly abandonment expense, term deal accruals and project accruals by utilizing Tableau to run actuals and forecast future expense.

Culver City, California, United States

∙ Developed weekly reports to track marketing spend, allowing executives to make key business decisions within budgeting and forecasting. ∙ Reconciled reports between Tableau and SAP for data transparency. ∙ Collaborated with Marketing team to align on budgets, forecasts, and quarter close deliverables. ∙ Consolidated and presented TV+’s title slate to senior management through tracking air dates, budgets and slot changes. ∙ Formulated quarterly impact for over 200 titles by show type and spend category.

Culver City, California

• Created ad hoc reports with SAP queries highlighting risks and opportunities.• Provided overhead reconciliation, measuring deviation from prior forecasts and budget.• Analyzed and quantified the foreign exchange impact on revenues and operating income.• Forecasted individual film labels overhead expenses by managing and analyzing actuals, utilizing Essbase to run scenarios.• Delivered annual department budget and 4 quarterly forecasts, quantifying variances for Motion Picture Finance and Corporate review.• Led in preparation of film ultimates; receive input from distributions; review for sensibility and update film models as needed for monthly close.

Greater Los Angeles Area

•Record receipts, credit card and bank transactions for partnerships and corporations in bookkeeping software QuickBooks•Organize and file company records by invoice processing and data archiving•Prepare and manage accounts payable/receivable in QuickBooks•Inform clients and supervisor on upcoming deadlines and due dates

Davis, Ca

Personal Finance Case Competition•Collaborated with a team of 3 to identify individual's financial strengths and weaknesses•Designed a spreadsheet on excel with our financial advice to reduce total debt by 27% within four years• Projected 10-year income and debt forecast analysis displaying debt reduction and financial growth•Tailored individual's retirement portfolio to include higher return investments such as: growth Index funds, value index funds and real estate investment trusts

Greater Los Angeles Area

•Catalogued student's information on Microsoft Excel and retrieved data on test scores in order to analyze and report student's overall performance and percentile •Acted as an intermediary to help students network with potential employers through the use of mail merge. •Assisted in daily operations including: answering and directing phone calls, managing company website, relaying messages between students and teachers, and creating copies of coursework

Bachelor Of Arts - Ba, Economics, 3.68

Activities and Societies: Economics and Business Student Association

Associate Of Arts - Aa, Liberal Arts And Sciences, General Studies And Humanities

Activities and Societies: Statistics and College Algebra tutor

High School Diploma

Activities and Societies: Soccer