Wenxin Mo Email & Phone Number

- Developed and performed monthly business reviews (MBR) for a cross-functional team of 6 departments, utilizing SQL and Python to gather and analyze data. Utilized visualization tools such as Tableau and PowerPoint to present key performance indicators and identify areas for improvement. - Utilized Snowflake SQL to collect and deploy department data, leveraging SQL windows functions, complex joins, subqueries, and stored procedures to organize and analyze the data.- Visualized data using Tableau reports and PPT, collaborating with department leadership to identify key data points and trends, and perform root cause analysis of abnormal data patterns. - Developed Key Performance Indicators (KPIs) to drive deeper insight into department performance and created ad-hoc reports to support confident decision-making.

- Automated and streamlined daily and monthly reporting by leveraging Snowflake SQL and Python tools, reducing effort and increasing efficiency.- Delineated actionable insights through visually impactful Tableau and Excel reports, reducing report generation time by 80%.- Completed complex data migration from MS SQL to Snowflake and designed Snowflake frameworks for visualizations in Tableau.

Atlanta, Georgia, United States

- Created Tableau reports enhancing understanding and visualization of agent and department productivity.- Designed, created, and enhanced the agent incentive model process based on strategy, utilizing Snowflake SQL, Python, and Excel files.

Atlanta, Georgia, United States

Atlanta Georgia

• Projected trends in customer retention by using Quantitative Analysis, Survival Analysis, Logistic Regression, Decision Tree, Random Forest and Loss Forecasting in python and R• Collaborative with risk management team to clean and analyze 13MM raw data with Excel and python, and recorded monthly trends. Moreover, Engineered Feature by using Random Forest and visualized by SAS.

Georgia

• Created healthcare database (over 200 tables) by importing data and developing calculated variables in Cluster server (PostgreSQL and Python); • Gathered data from disparate sources and synthesized raw data into meaningful reports.

Atlanta Ga

• Comparative analysis using Python and Topic Modeling indicated superhosts secure ~13% reservations with minimal feature difference compared to non-superhosts.• Analyzed 4k unstructured Airbnb media data points after scraped and cleaned data by python, used NLP to create Bag-of-Words and LDA algorithm to identify the frequency of word and to the cluster, then Topic modeling to define 4 prominent cluster.

Atalanta Ga

• Projected increase ticket sales by adding variety and lower cost of food through sentiment analysis (python), and topic modeling (R). Social media comments (14mm) indicated 30% discussed food, and 60% indicated price is too high.• Analyzed 14MM unstructured social media data points to identify trends in reviews and comments by using python to clean data, conducted sentiment analysis in R, and Topic modeling using python to cluster and identify main focal topics.

Pine Hill,Al

Managerial Assistant• Analyzed the productivity of department using VBA and visualized data by Excel to identify trends, then prepared weekly analysis reports and optimized production.• Translated Chinese to English messages to improve communications and collaboration among colleagues.

Livingston Al

Teaching Assistant• Assisted 35 students in VBA for financial computer class• Proctored and graded exams and quizzes

Livingston Al

• Projected 12-month target price of Nintendo Co., Ltd. using DCF, multiples analysis, and sensitivity analysis using Monte Carlo simulations.• Performed financial analysis using company 10-K and 10-Q.• Forecasted revenue using econometric modeling.

Master'S Degree, Master Science Of Analytics

Bachelor’S Degree, Finance, General, 3.8

Activities and Societies: financial club member, Chinese dragon new year, National Day of the Arabia, middle moon festival, campfire.