Andrei Aleksandrov

• Successfully implemented various automation tools such as Robotic Process Automation (RPA) and Alteryx saving the company 1,000+ hours for several manual processes • Designed, built, and automated new TV Ultimates Model (titles lifetime value) for 600 titles. Saved 400+ hours using several automation tools - Alteryx, Excel Macros (VBA), Power Query. • Automated consolidation of multiple rights data and created analytical tools to see forecast changes dynamically • Prepared budgets, quarterly forecasts, and variance analyses ($1 billion)

• Prepared an annual budget and forecast ($250M) by region, business unit, and venue • Streamlined P&L models for each business unit/region and automated customized show metrics by creating database queries and building complex Excel models • Built several Request for Proposal (RPF) models for new concert venues that included sensitivity analyses and various scenarios • Prepared budget decks for CFO presentations

• Built a consolidated forecasting and budgeting model for WB Technology Operations by Business Unit and application • Created and automated variance analysis reports and financial summaries • Prepared presentation decks for CIO

• Created Company's Business Plan and Investor's Deck • Build 5-Year Financial Plan and P&L model • Helped design different revenue streams

• Managed consolidation of annual budgets by department and streamlined consolidation models for US and international entities • Designed and built P&L forecasting models for new products (multi-layer subscription based) • Prepared and automated monthly and quarterly management reports for CFO • Helped build a 3-year Global P&L forecast model for bank refinancing • Provided analyses of companies for potential acquisition • Assisted in implementation of Anaplan, a cloud-based financial planning tool

• Allocated royalties, Minimum Guarantee license fees for 1,000+ titles • Streamlined and automated several management reports (P&L, revenue by customer and title, variance analyses) • Managed month-end close

• Built and automated Inventory and Key Financial Ratios & Trend reports using SAP BW queries • Managed a team of accountants and controllers in five territories in Europe and Asia • Prepared and reviewed monthly journal entries (accruals, deferrals, allocations, reclasses, rev rec) • Prepared and reviewed quarterly Footnotes and Supplemental Schedules submissions for audits • Completed annual government reports

• Assisted in the integration process of the acquired company (URS) by consolidating and streamlining all key financial management reports • Built a model to allocate synergy savings from the merger by category, region, and department • Prepared Budget Plan by department and present to CFO • Built G&A allocation model for corporate departments