Data Analyst Tableau

ZIYUAN (KENNETH) WANG

*** **** **** ******, *** York, NY, 10019

+1-949-***-**** adgsep@r.postjobfree.com

EDUCATION

Fordham University New York, NY

M.S. Business Analytics, STEM, GPA: 4.0 / 4.0 Sep.2018 – Feb.2020

• Coursework: Risk Management & Performance Analytics, Statistic Methods, Web Analytics, Data Mining, Database Management

• Award and Honor: Dean’s List (All Semesters), Alpha Sigma Nu International Honors Society, Leadership Intelligence Certificate University of California, Irvine Irvine, CA

B.A. Economics Sep.2012 – Jun.2016

• Coursework: Corporate Finance, Applied and Empirical Econometrics, Economics of International Business, Global Economics

• Extra Curriculums: Co-Founder of Winners Collective (E-commerce Entrepreneurship Club), Member of Finance Association EXPERIENCE

Global AI Corp. New York, NY

Data Analyst Mar,2020 – Present

• Evaluated the performances, position-sizing, and sector exposure of target portfolio based on return ratios and selected benchmarks

• Constructed data pipeline for more than 5000 transaction records using SQL to improve client’s database overall ETL performance

• Created Tableau dynamic dashboards for the performances and risk exposures of 8 benchmark indices across different time periods New York International Capital, LLC New York, NY

Investment Data Analyst Intern Oct,2019 – Feb,2020

• Consolidated financial analysis and investment research into two M&A deals while preparing pitch books and due diligence reports

• Conducted benchmarking analysis for our client’s firm with projections on the future operating income and various valuation ratios

• Developed 10+ spreadsheet databases for clients and actively arranged cross-functional communication between buyers and sellers Apple Inc. Costa Mesa, CA

Specialist – (Small Business Advisory) Sep,2016 – Jun,2017

• Connected with 20+ small business partners; presented industry insights to solve clients’ inquiries and boost business performance

• Applied cross-selling techniques and interpersonal skills to support technical teams and increased the monthly local revenue by 6%

• Managed clients’ information database daily; promoted strategic business solutions to clients by exploiting emerging technologies

• Supported sales team by analyzing statistical market data utilizing Excel spreadsheet models, which led to a 10% increase in profit China Construction Bank Corp. Liaoning, CN

Risk Data Analyst Intern Jun,2014 – Sep,2014

• Crafted weekly risk and business attribution reports; monitored key parameter changes and updates of bank’s portfolios using SQL

• Conducted credit rating reviews for individual mortgage loans and completed analysis on financial statements in collateral pledged

• Drafted loan files with loan repayments control; compiled presentations and generated ad-hoc reports for senior management teams PROJECT

Prospect 33 Future Leader Bootcamp New York, NY

Data Analytics Mentee Jan,2020 – Apr,2020

• Delivered data analysis on 20,000+ financial transactions records and presented in-depth strategic plans to the senior management

• Established reports on Anti-Money Laundering activities of real-life datasets and remediation plans by utilizing SQL and Tableau

• Built change management plan using Collibra data governance tool to support client’s business glossary, data lineage, and controls Relational Database Tracking System New York, NY

Team Leader Jan,2019 – May,2019

• Demonstrated a transactions tracking system that contains both Logical and Relational databases using Oracle Developer & APEX

• Collected, matched, and queried 10+ datasets from 5+ online platforms and interpreted the result into meaningful business insights Text Mining with Data Scraping New York, NY

Project presenter July,2019 – Dec,2019

• Crawled 10,000+ online movie reviews and audience comments from www.IMDb.com via Beautiful Soup & Selenium on Python

• Conveyed the text data on NLTK and calculated polarity score with sentiment analysis to predict box office performance & trends TECHNICAL SKILL & ADDITIONAL

• Analytical Tools: SQL, Python, Tableau, Excel Spread Sheet Modeling, R, VBA, Bloomberg Terminal, Alteryx, Qlikview

• Language Competences: Fluent in English and Mandarin

• Other Interests: Entrepreneurship, Fitness, Basketball, Travel, Hiking, Piano, Guitar, Songwriting

Contact this candidate