Anqi (Angie) Yang

*** * **** ******, *** ***, New York, NY 614-***-**** adbzqx@r.postjobfree.com

EDUCATION

Columbia University New York, NY

Master of Science in Applied Analytics (GPA: 4.2/ 4.3) September 2018 – February 2020

• Highlighted Coursework: Machine Learning, Data Modeling, Strategy and Analytics, Research Design, Storytelling with Data, Analytical Frameworks & Methods The Ohio State University Columbus, OH

Bachelor of Science in Business Administration in Information System (GPA: 3.8/ 4.0) September 2014 - May 2018

• Highlighted Coursework: Java, Relational Database, Agile System Development, Finance, Marketing, Operation, Accounting, E-Commerce SKILLS

Technologies: SQL, R, Python, Tableau, Java, JavaScript, HTML, CSS, COBOL Specialties: Data Analytics, Data Visualization, Dashboard Building, Analytical Storytelling, Machine Learning, Data Engineering, Statistical Model

WORK EXPERIENCE

Machine Learning Prediction Model Consultant - Capstone September 2019 - December 2019 AFP HABITAT Remote

Aggregated public assets indices and market regime information to build a prediction model for a Chile financial service provider to estimate private assets’ quarterly performance using R

• Analyzed client’s requirements, explored 70M data and proposed three possible models: Bayesian, CNN, and LSTM

• Processed data from different sources, constructed Bayesian Regression that outperformed traditional CAPM by 60%

• Visualized the distribution of the significant Indices, considered the drawbacks and benefits of Bayesian Model and recommended it as the best model for client to continue optimizing Business Analyst Intern June 2019- August 2019

HEYWHALE.COM - Chinese data science community (60,000+ talents), similar to Kaggle Shanghai, China

• Analyzed 170k Data Competitions data, explored the changing trends of business problems, type of sponsor, and then constructed a Tableau dashboard of Target Client in digital transformation

• Constructed Client Service Menu for clients in Finance and Retailing, with real business cases and specific Machine Learning techniques, and mapped the menu from solutions to benefits, successfully attracted 5 new potential clients

• Queried user data using SQL, ensured the customer segmentation for Marketing and helped acquire 2% new users

• Recommended business opportunities including building a talent pool and adding new forms of data competitions to fit more clients’ needs, presented to senior management and got support with new projects established Project Analyst Intern June 2016 - August 2016

STARBUCKS Shanghai, China

• Worked in a cross-functional team to facilitate the grand opening of Shanghai Starbucks Reserve Roastery

• Analyzed transportation data and recognized the problem of a low volume of snack X causing high cost

• Proposed a solution of combining multiple shipments into a consolidated shipment and simulated a 7% cost-reduced plan based on Distance, Food Quantity in Pallets, Delivery Frequency and Quotes

• Communicated with carriers participated in the bidding process, assessed their capabilities including price, unloading plans and the permission to deliver in the city center and reported to the manager PROJECT

Centers for Medicare & Medicaid Services (CMS) Data Engineering and Analytics October 2019 - December 2019

• Transformed 10K rows of raw data with 67 attributes into 15 3NF tables and created an ER diagram for schema

• Created database schema in PostgreSQL, designed data transformation plan and applied ETL workflow using Python

• Brainstormed interaction plans for different users of the database and developed 10 meaningful business problems

• Queried CMS data using SQL, built the dashboard to present all results and deliver insights for medical services

Contact this candidate