YING HAO

628-***-**** *** Army Navy Dr, Arlington, VA, 22202 ad09q8@r.postjobfree.com

EDUCATION

Master of Science, Business Analytics Washington, D.C. THE GEORGE WASHINGTON UNIVERSITY, School of Business December 2023

• Recipient of a $6,000 scholarship, GPA: 3.75

• Relevant Courses: Data Management for Analytics, Optimization, Data Analytics for Accounting, Machine Learning Bachelor of Science, Double Major in Economics and Accounting Storrs, Connecticut UNIVERSITY OF CONNECTICUT, School of Business May 2020

• Relevant courses: Financial Accounting, Cost Accounting, Federal Income Taxes

• Aetna Celebration of Student Writing, “Contact Zone” award & National Connections award (2018) TECHNICAL SKILLS

• Data Analytics: Excel (Power BI, the Solver, Decision Tree Model, Pivotable), Tableau, Python (Pyplot, Gurobi)

• Data Processing: SQL, Python (Panda), AWS

• Machine Learning: Python (Sklearn), R Classification, Regression, Times Series, natural language process RELEVANT PROJECTS

SQL Bank Customer Segmentation

• Analyzing customer demographic and transactional data from an Indian bank to provide consumer finance and retail banking insights, enhancing customer understanding and needs assessment o Processed 1,048K transaction records by 800K+ Indian bank customers using Trifacta for data cleaning and filtering, resolving missing values and biased values

o Designed a Dimension Diagram to illustrate table relationships and establish primary key connections for data access o Employed SQL to calculate and present average account balances based on transactions in the top 5 cities for expanding business o Conducted a gender analysis, revealing a 1:3 ratio between female and male account holders, aiding the bank in addressing gender disparities

o Visualized analysis outcomes using bar charts, pie charts, and linear graphs to highlight trends and patterns in Excel Machine Learning Marketing campaigns

• Applied Panda to create the model and help the company decide on the best marketing campaign o Employed histograms for client distribution and heatmaps to reveal feature correlations exceeding a 0.5 threshold o Utilized Python (Sklearn) to partition data, allocating 70% for training and 30% for testing purposes o Processed a dataset of 41K instances and 19 attributes with Python (Pandas) to ensure unbiased and error-free analysis. Combined data to implement performance assessments of five models (Logistic Regression, KNN, Decision Tree, Random Forest, SVM) via comparing k-fold cross-validation, chose Random Forest as modeling by achieving the highest AUC Mean of 79.73

o Applied Panda to predict a $2.50 expected value per customer of the telemarketing campaign by the best model Optimization Portfolio Problem at Zinca Inc.

• Applied Excel Solver and Python Gurobi to optimize drug production portfolios o Set objective function to confirm the independent variables, dependent variable, and constraints o Utilized 114 variables to maximize eNPV (Estimated Net Present Value) through function setting and Correlation o Employed Efficient Frontier to determine the drug with minimized portfolio risk, resulting in a company-wide budgeting decision with an eNPV of $2504.41

AI Ethics Bias Assessment Metrics & Measures (BAM) Repository

• Structured comprehensive AI metrics encompassing various data types (Tableau, Image, Text, Video, and Audio) to create an intuitive interface for practitioners, enabling seamless search, filter, and access capabilities

• Developed an Excel table containing image bias metrics, such as demographic parity difference, and provided guidance on optimal conditions for strengthening dataset fairness. This included measures to mitigate biases in facial recognition tools based on race, gender, or age

EXPERIENCE

Valuation Assistance (Intern) Beijing, China

CHINA TONG CHENG ASSETS APPRAISAL C., LTD Feb 2021 - Jul 2021

• Conducted thorough financial analysis for metal-casting companies in preparation for an upcoming business consolidation, utilizing Solvency Ratios to assess debt repayment capacity

• Applied specialized accounting valuation models, including depreciation formulas, to ascertain the value of assets, covering fixed assets, intangible assets, and equipment depreciation

Marketing Analyst (Intern) New York (Remote), the U.S. ELDON GROUP Nov 2019 - Dec 2019

• Created a Perceptual Map using Excel based on extensive market research of 12 competitive companies, highlighting target company competitiveness and identifying correlations

• Conducted comprehensive market research, generating reports that revealed growth opportunities and market trends, providing valuable insights to support strategic expansion

Contact this candidate