Serena D. Email & Phone Number

Hillsboro, Oregon, US

Austin, Texas, US

Dallas, Texas, US

• Conducted financial analytics and business planning optimization for multi-national companies in various industries and improved their operational productivity by over 30% and saved cost by over $4M
• Designed and created multi-dimensional database structures for data ingestion and transformed datasets in SQL and Excel
• Built interactive data visualization reports to visualize end-to-end financial and operational planning view
• Forecasted category item sales using driver based ML models including ETS, random forest and GBM etc. in Python and achieved an overall accuracy of over 85% for a F500 food and beverage company
• Created algorithm to identify forward-looking sales opportunities and provide gap shrinking recommendations by conducting scenario planning comparisons to reduce profit loss by over $3M for a CPG manufacturer
• Collaborated in automated replenishment algorithm development to automate supply planning activities in R

Round Rock, Texas, US

Predicted Dell laptop system failure with deep learning model using system-generated signal data

Austin, TX, US

Conducted EDA, frequency analysis, topic modeling, lift ratio, sentiment analysis and K-core decomposition to extract insights from twitter troll posts

Austin, Texas, US

Predicted software development teams’ performance scores with various code evaluation parameters in Python

Irving, TX, US

• Conducted EDA, regression models and data ensemble models including tree techniques in Python to predict KC products’ sales
• Shaped data in Alteryx, built VDMs in SAP HANA and connected VDMs to Tableau to generate interactive data visualizations
• Utilized SWOT and marketing analysis strategies to find over $1M opportunities in Huggies for KC products sold in Walmart
• Collaborated in resume ranking project using NLP in python to automatically rank resumes received with certain key words
• Observed the whole developing process of vendor fraud detection project using NLP distance learning techniques in R

Austin, TX, US

• Assisted with data collection for a PhD level MIS text analysis research project predicting stock prices with words in news articles
• Labeled more than 50K topics with different sentiments and pipelined them into excel form

Austin, TX, US

• Researched Health-Tech industry with industry operational data and came up with marketing segmentation reports
• Conducted competitive pricing analysis and designing choice experiments using focus groups to set private clinic price

• Conducted cost-based research for investment portfolio strategies using Morningstar
• Maintained and updated over 5K clients’ database using Penelope for financial reports preparation

• Analyzed stock performance and provided suggestions on investment strategies
• Managed stock portfolio and researched on economy trends
• Conducted financial-diligence and analyzed company’s’ financial reports

• Hosted both online and offline events to spread ERP system awareness among students
• Organized ERP business competition with 200+ participants’ signups

Master Of Science - Ms, Business Analytics

Bachelor'S Degree, Economics & Statistics