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.

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.

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