Evan Huangfu Email & Phone Number

New York, United States

• Utilized NationWide's built-in financial analysis tools to calculate life insurance premiums, cash value accumulation, and payout scenarios; with in-depth financial data analysis, provided detailed suggestions to clients to meet investment and financial goals• Responsible for 10+ comprehensive client analysis reports including historical return rates, future profits, cash flow projections and detailed investment performance conclusions; compared different investment strategies and suggested higher return investment methods which would in average improve clients’ return by 20%

Chicago, Illinois, United States

• Addressed low data processing efficiency by proposing switch from Excel to PostgreSQL for handling large datasets; led the transition and independently built a centralized Data Warehouse with enhanced data governance standards, which improved data accuracy by 30%, processing efficiency by 50% and clustering identification by 25%• Developed and implemented 6 Python (Selenium, smtplib) Scripts individually to accomplish automation of filtering and connecting social media influencers, tripled team productivity with 10,000+ influencers contacts and improved marketing cooperation by 15%• Applied statistical analysis and data mining techniques (clustering and 5+ different predictive models) with SQL and Python (Pandas, Scikit-learn) to analyze user behavior, demographics and video playback statistics; delivered suggestions including product development, content development (e.g., preference for short videos, preference for Christian content), led to 25% increase in average user duration and 40% increase in user interaction and subscription

Shanghai, China

• Took initiative to regularly engage with Volkswagen to clarify requirements and ensure alignment with project goals • Drove the execution of ETL processes using Python (Selenium) and SQL, including data collection, cleaning, and transformation and oversaw the integration of 200,000+ car reviews from 50+ external sources, achieved a 40% boost in data processing efficiency• Developed weekly BI dashboards and reports using Tableau and SQL queries results, which presented comprehensive data findings and visualizations on market trends and consumer sentiments; provided actionable insights (e.g., increased focus on electric vehicle marketing) that boosted Volkswagen’s lead generation by 34%

Shanghai, China

• Conducted financial analysis on financial derivatives using R and advanced Excel functions like Power query and pivot table, supporting accurate valuations and contributing to a 21% improvement in pricing accuracy.• Implemented statistical models and machine learning algorithms to predict portfolio risk and potential returns based on historical performances and market trends, identifying investment opportunities that could potentially lead to 30% increase in portfolio returns and improved risk management strategies.

Master Of Science - Ms, Applied Data Analytics, 3.74

Activities and Societies: Stock Trend Prediction Project • Developed machine learning algorithms (Scikit learn) to forecast 5 selected.

Bachelor Of Statistics, Statistics

Activities and Societies: KWCSSA Welcome Event • Organized a welcome event for Chinese freshmen, featured with performances.