YEYUN HUANG

Tel: 646-***-**** Email: adkuid@r.postjobfree.com Linkedin: linkin.com/in/viola-huang-ab2502117 EDUCATION

COLUMBIA UNIVERSITY New York, US Sep. 2019 – Dec 2020 MS in Applied Analytics (CFA level II Candidate) Overall GPA: 3.8/4.0 SICHUAN AGRICULTURAL UNIVERSITY Chengdu, China Sep. 2014 – Jun. 2018 BS in Finance Overall GPA: 3.8/4.0

WORK EXPERIENCE

Columbia University, New York, NY Oct. 2020 – Present Business Analyst (DSI Scholar)

• Assisted data repository creation with SQL, for 10k patients who completed a universal screen in a clinical encounter.

• Handled 15k medical record data cleaning, deduplicate, drop NA and conducted EDA in Tableau for initial visualization.

• Launched unsupervised clustering KNN to see the features of obesity patients, processed one-hot for data transformation.

• Processed A/B testing on obesity towards medication adherence among 10k patients, tested with ROC curve Arc Venture, New York, NY

Venture Analyst (Technology) Sep. 2020 – Dec. 2020

• Applied EDA and selected variables for feature engineering and established machine learning model through ski-learn in Python to forecast the duration of startups for fund raising, tested with Gains table and summarized fluctuation in reports.

• Built Python project (2k lines) in Visual Studio and deployed Azure for cloud programming to trigger weekly prediction.

• Deployed Power BI to visualize fund performance based on the programming output and build dynamic dashboard as deliverables to stakeholders to assist investment decision making.

• Drafted memo for selected start-ups via investigation, business call and updated investment suggestion on daily meeting. China Asset Management, China Jan. 2018 – Mar. 2018 Business Analyst (Portfolio Management)

• Enriched data repository for 2500 client with SQL and created manager, director views to improve data security.

• Assisted Marketing team to process competitive analysis for an AI wealth management product and promoted it as a value add for clients by organizing roadshow events with the support of Legal department; Topped internal sales competition.

• Trained branch managers on product knowledge, market analysis and macro-economic trends for professional promotion.

• Led a team of five for social media promotion and made online instruction available and reached 200 invitations a day.

• Made recommendation to clients, tracked client fund subscriptions and explained new terms and market analysis to them. Athena Data Analytics & Service, China Oct. 2017 – Jan. 2018 Business Analyst (Product)

• Executed EDA on B2B companies based on POS data to strengthen marketing strategy and improve promotion efficiency.

• Applied Python to gather merchants’ basic information based on IT department’s support and assisted on creating credit model with PCA and evaluate clients’ max loan amount.

• Cross-team collaboration with external third party to acquired clients’ data and enrich database.

• Composed weekly meeting reports and assisted optimizing in product UI design as well as risk control testing. American International Assurances, Hong Kong Jun. 2017 – Jul. 2017 Business Analyst (Risk& Wealth Management)

• Received annual intern award, earning designation as VIP guests at GAMA meeting (top meeting in insurance industry).

• Awarded the best presenters in training of risk management and risk assessment.

• Assisted agents to make asset allocation for clients and assisted individual client to balance credit risks with insurance.

• Guided clients to fill risk preference survey, provided several insurance products and analyzed their application and limits to support clients’ decision making.

Price Waterhouse Coopers, China Jan. 2017– Mar. 2017 Technical Support

• Developed a double-check way via vLookup in Excel to save 40% time of Admin Department for mailing confirmation.

• Assigned and stamped correspondence confirmation in five sections in China; made 2,000 transaction registrations a day.

• Organized appointments with clients on phone and scheduled time for demanding discussion.

• Assisted for data collection with IT department based on transaction volume in each area for demanding determinations. SKILLS

Technical Skills: Python, SQL, R, Tableau, Alteryx, Bloomberg terminal, VBA, SAS, Power BI, Azure, Power Query Statistical Modeling: Regression, K-means, KNN, DBSCAN, SVM, Random Forest, Neural Network, PCA, A/B testing

Contact this candidate