Katie ZHAO
Queens,NY
Summary
Organized and detail-oriented candidate successful at managing multiple priorities with a positive attitude. Great teamwork player, wiling to take added responsibilities and a take all the challenges and difficulties.
Overview
3
3
years of professional experience
Work History
Healthcare Analyst Intern
Aflac
06.2023 - 09.2023
- Licensed health insurance agent responsible for the New York City region. (NYC Healthcare State test passed)
- Collaborated with a cross-functional team to design and develop interactive reports and dashboards using data visualization tools (Tableau and Power BI) to provide actionable insights into critical healthcare trends, and patient outcome.
- Assisted in design customized visual reports tailored to different departments, resulting in a almost 10% reduction in the time required to communicate data-driven insights.
- Applying financial expertise and industry knowledge to provide strategic insurance solutions and optimize clients' financial portfolios.
Data Analyst Intern
Price Waterhouse Coopers (PwC)
10.2021 - 01.2022
- Assisted in analyzing potential M&A targets by acquiring 2,000+ data with R and SQL from the database, managed and processed it in reporting and statistics
- Performed ad-hoc research in GMV and marketing strategies through backtesting, time series analysis, and capital market modeling to support new product development, and marketing solutions generation
- Implemented linear-regression-based models to compare the portfolio exposures to risk factors with the new energy market (e.g., S&P 500) by calculating several statistical correlation metrics among 50 random variables
- Assisted and promoted “Empower Women in Tech” campaign, awarded by UN Women 2021 Asia-Pacific WEPs awards
- Applied Porter’s Five Forces model to analyze the competitive strategies of PwC
HR Analytics Intern
Porsche, Motors
05.2021 - 10.2021
- Estimated key indicators such as internal rate of return and dynamic payback period based on financial reports and on-site inspection information
- Composed VBA scripts to automate 5k+ data entries, and transformed client requests into data deliverables to include data models, data mappings, and data transformation rules by Excel and Informatica
- Increased the internal HR platform’s usage rate by 20% through the promotion of recruitment incentives, new employee orientation, and employee relations; and provided policy consultation service to HRD
- Assisted recruiting and the biding process by building close business communications with headhunter companies.
Marketing Analyst Intern
China Mobile Group Co
06.2020 - 09.2020
- Wrote SQL queries to add 500+ data to company’s database, analyzing 3000+ consumer information automatically
- Applied R package to implement table merging, and data frame cleaning including customer information, consumer behavior, and current financial holdings
- Conducted research work in distributed computing tools (Map/Reduce) with large data sets of complex data from computer-industry companies
- Utilized R database to collect public information of comparable computer-industry companies, and drafted 40+ daily industry reports, including company assets, market info, profit data, NAV value, and national policies, Statistical Analysis of Academic Performance: Distance Learning vs Fact-to-Face Learning
Researcher / Data Assistant
Ningxia University
- Used R programming to clean and validate data and Anova to analyze the data, changed the independent variables, evaluated the influences and possibility of different variables on conclusions
- Conducted SPSS in generating statistics of grades that students got in a face-to-face learning environment and in a virtual instructing environment, executed descriptive statistical analysis and t-test
- Applied independent t-test via Jamovi, summarized data to analyze results
- Operated neural networks using PyTorch packages, complied R comparing fact-checking information
Education
Master of Science - Business Analytics
Columbia University in The City of New York
New York, NY01.2025
Bachelor of Arts - Economics, HRM
Rutgers University–New Brunswick
New Brunswick, NJ05.2023
Skills
- Microsoft Office (Excel, Word, PowerPoint)
- R, Tableau, Power BI, SQL, MATLAB
Hobby
tennis / skiing / dancing (k-pop) / dog lover
Timeline
Healthcare Analyst Intern
Aflac
06.2023 - 09.2023
Data Analyst Intern
Price Waterhouse Coopers (PwC)
10.2021 - 01.2022
HR Analytics Intern
Porsche, Motors
05.2021 - 10.2021
Marketing Analyst Intern
China Mobile Group Co
06.2020 - 09.2020
Researcher / Data Assistant
Ningxia University
Master of Science - Business Analytics
Columbia University in The City of New York
Bachelor of Arts - Economics, HRM
Rutgers University–New Brunswick
Similar Profiles
Angela SycksAngela Sycks
Benefits Advisor at AFLACBenefits Advisor at AFLAC
Quentin FosterQuentin Foster
Benefits Advisor at AflacBenefits Advisor at Aflac
Lisa V. LambertLisa V. Lambert
Field Sales Agent at AflacField Sales Agent at Aflac
Victoria BlackmerVictoria Blackmer
Independent Insurance Agent at AflacIndependent Insurance Agent at Aflac
Scott BackmanScott Backman
Delivery Driver at OntacDelivery Driver at Ontac