Haoran L.
Risk Analyst at National Mortgage Insurance Corporation - "National MI"- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
Chinese Native or bilingual proficiency
-
English Full professional proficiency
-
Cantonese Native or bilingual proficiency
Topline Score
Bio
Credentials
-
Google Analytics Individual Qualification
GoogleSep, 2021- Nov, 2024 -
Introduction to Tableau
DataCampSep, 2021- Nov, 2024 -
Unsupervised Learning in Python
DataCampSep, 2021- Nov, 2024 -
Intermediate R
DataCampAug, 2021- Nov, 2024 -
Introduction to R
DataCampAug, 2021- Nov, 2024
Experience
-
National MI
-
United States
-
Insurance
-
200 - 300 Employee
-
Risk Analyst
-
Dec 2021 - Present
• Refine pricing algorithm to match price with risk and identify growth opportunities. • Developing analytical tools, dashboards & reports (e.g., Excel, Power BI, Tableau, etc.) • Investigate internal and external data sources to improve risk segmentation. • Explore innovative tools to extract unstructured data. • Partner with market research to assess market and competitors. • Monitor portfolio performance and identify high performance areas and potential issues. • Collaborate with risk and finance teams to research and improve reserving methodology. • Support reinsurance analysis through data analytics, financial modeling, and business case development. • Work closely with IT teams to ensure new strategies are implemented accurately and as designed. • Provide ad hoc assistance as needed. Show less
-
-
-
Gorilla Gadgets
-
Computers and Electronics Manufacturing
-
1 - 100 Employee
-
Data Analyst
-
Sep 2019 - Nov 2021
· Builds machine learning models and A/B tests to optimize marketing spend and increase sales performance · Analyzes keyword budget and performance on marketing platforms using database queries (SQL, Python), spreadsheet (Excel) models, and statistical analysis tools, which helps increase products' exposure rate by 50%. · Leads marketing, customer, as well as competitive analyses to develop product selection and regional and seasonal marketing strategies for over 300 products. · Optimizes campaigns performance on different platforms including Google, Amazon, and eBay by strategically allocating over $3000 daily marketing budgets on average. · Drives >75% of sales through marketing keyword analysis by merging weekly data from multiple sources and creating trend analysis using SQL. · Answers business questions and communicates actionable insights with cross-functional teams on a daily basis by using appropriate data discovery, visualization, data mining, and statistical techniques. Show less
-
-
-
Upperpin
-
Irvine, California, United States
-
Digital Marketing Analyst
-
Jun 2019 - Aug 2019
· Managed marketing budgets to create result-driven strategies to successfully reach annual sales goals set for company websites of $1 million. · Planned marketing budgets among marketing tools such as Google Analytics, Google AdWords, social media sites’ marketing services to drive SEO. · Compiled and delivered weekly and monthly sales reports to various internal and external stakeholders. · Managed marketing budgets to create result-driven strategies to successfully reach annual sales goals set for company websites of $1 million. · Planned marketing budgets among marketing tools such as Google Analytics, Google AdWords, social media sites’ marketing services to drive SEO. · Compiled and delivered weekly and monthly sales reports to various internal and external stakeholders.
-
-
Education
-
2020 - 2022
Cal State Fullerton, College of Business and Economics
Master's degree, Computer and Information Sciences, General -
2017 - 2019
UC Irvine
Bachelor's degree, Economics -
2015 - 2017
College of San Mateo
Computer Science -
2013 - 2015
Pacific Union College Preparatory School
Community
