Yang Liu (ian)
*** * ******* ***, *** Angeles, CA 90020
Seeking an analyst position with a company that will enable me to use my knowledge and analytical skills appropriately while absorbing new experiences along the way
M.S. Accounting The University of Texas at Dallas (Jan 2012 -Dec 2013)
M.S. Finance The University of Texas at Dallas (Aug 2009- May 2011)
B.A. Marketing, Sino-Canada, Shanghai Institute of Technology
CERTIFICATION CFA Level 1 candidate
Proficient in financial analysis and modeling using Excel(Pivotal table, V-Look Up and advanced functions),Valuation Models,
Micro-Strategy,SQL Database, Google Analytics and Facebook Insight
Sony Pictures Entertainment
Residual Analyst,2015 March-Present
Lead revenue analysis and analyzed revenue metrics and KPIs across all markets including Domestic/International Home Entertainment, Pay/Free TV, DTR, EST, ADSS and etc...
Prepare revenue schedules with and revenue-related payments every quarter, performing worldwide income analysis to identify profitability implications for film and television.
Calculate residual payments from various feeder systems (SAP,Tigers,etc) and complete a detailed analysis of each report for accuracy and reasonableness.
Populate back-end reports and payments including quasi-guild, film-district, royalty payments, residuals paid reports, journal entries, etc.
Perform special on-request and Ad-Hoc projects such as preparing report for Audit, validating peers’ performance and etc…
Business Analyst, 2014 June – 2015 Feb
Assisted campaign manager in budgeting and analyzing performance while recommending opportunities for digital media optimization.
Performed Ad-Hoc projects of Cross-Function Campaigns for client: Procter & Gamble, Warner Bros Entertainment and HULU
Analyzed campaign by forecasting P&L and network performance to understand value provided by data publishers.
Created and conducted weekly and monthly reconciliation model for Client reporting across KPIs such as revenue and leads
Designed and implemented tests to evaluate model, dashboard and feature performance in Excel and Micro-Strategy.
Worked with clients and internal teams to create real-time brand optimization reporting that align with campaign goals, but also create strong, clear signals that our models can use to optimize campaign delivery and performance.
Consulted and discussed with internal client service team and director of Analytics to understand key business challenges and design analytical and testing plans to derive actionable intelligence.
Deloitte Touche Tohmatsu
Financial Analyst Intern, 2012 June-2012 September
Involved in the due diligence process and conducted market research and ad-hoc financial analysis for the client.
Conducted studies to improve financial effectiveness and analyzed financial data and defined relevant information for client
Interpreted data for the purpose of determining past financial performance of client
Utilized ERP and excel spreadsheets to assemble, manipulate and format data
JPMorgan Chase & Co.
Data Analyst, 2011 May-2011 November
Extracted and compiled data from various computer systems into MS Excel and prepared reports to the senior manager.
Ensured processing controls and analyzed information provided by requestors or to determine accuracy and completeness of data prior to entering into various processing systems.
Monitored various communication tools that instruct the team to set up new securities, enter floating rates and/or modify and research discrepancies for existing securities with data providers.