Han (Angeline) Zhao

929-***-**** adjj71@r.postjobfree.com

Jersey City, NJ https://www.linkedin.com/in/hzhao21

EDUCATION

Fordham University Gabelli School of Business New York, NY

M.S. in Business Analytics Major GPA 3.90 Graduated 2016

•Relevant Coursework: Business Analytics for Managers (Tableau), Data Mining (IBM Advanced SPSS Modeler), Database Management (DB2, SQL), Data Warehousing, Big Data Analytics (Hadoop, AWS), Web Analytics (Python, Weka, Gephi)

Beijing University of Technology Beijing, China

B.S. in Business Administration GPA 3.64 Graduated 2013

•Relevant Coursework: Economic Decision-making Method and its Application; Marketing theory; Modern Theory of Consumer Behavior

EXPERIENCE

ViacomCBS New York City, NY

Contract Operation Analyst Oct 2019 – Apr 2020

•Enter deal memo for inherited Paws, Baby Shark deals

•Review proposed deals against Consumer Products Health Check Policy (a robust set of Business, Finance and Legal guidelines)

•Prepare SOX audit reports for Compliance team and flag any errors uncovered

Financial Data Analyst Mar 2019 – Oct 2019

•Trace financials through a contract’s life cycle to identify and resolve discrepancies

•Review large Excel data sets weekly for anomalies including but not limited to royalty recoupment, invoicing, revenue recognition

The College of New Jersey Ewing, NJ

Data Reporting Analyst Apr 2017 – Jun 2018

•Create and publish reports using SAP Web Intelligence from various data sources for Deans, Chairs, college administrative staff and academic office; Conduct TQM reporting and analysis used to increase Records and Registration's effectiveness and to support operational decision making

JPMorgan Chase & Co New York, NY

Financial Analyst (Project Based) Mar 2016 – May 2016

•Develop data variance analysis and liaise with LOB (Line of Business) counterparts for variance explanations on balance sheet and NII (Net Interest Income);

•Support the CCAR (Comprehensive Capital Analysis and Review) NII team and operate internal forecasting database to project NII and FTP (Fund Transfer Pricing)

TheBloc New York, NY

Content Analyst Feb 2016 – April 2016

•Collected web traffic datasets with Google Analytics and visualized the datasets with Tableau, generating insights on KPI click through rates, bounce rate, page views, conversion rate

•Presented my findings and recommendations in PPT to manager and account executives

ADDITIONAL

Languages: Mandarin – native; English – fluent;

Technical Skills: Excel, Tableau, Power BI, IBM SPSS Modeler, Cognos, Spotfire, Qlickview, Jasper, Google Analytics, Google Adwords, DB2, SAP Business Objects, SQL

Interests: Piano, Dance, Table Tennis, Basketball

Contact this candidate