• Designed and implemented an A/B testing framework to evaluate bariatric surgery outcomes, enabling leadership to optimize obesity treatment coverage plans based on PMPM savings, long-term stability, and improvements in members’ health.• Developed data layer for KPI risk score calculated model, enabling provider performance benchmarking; collaborated with finance, medical, pharmacy, and AI solution teams to identify cost-saving opportunities and strengthen provider relationships.• Developed a multi-functional automated ETL tool to integrate Episode of Care data across 3 years and 70+ features, streamlining data access and facilitating comprehensive analysis of patient health condition and medical history.• Created and maintained 4 interactive dashboards partnering with People Analytics Team, displaying employee information at multiple granularities to extract actionable insights on organizational networks and collaboration efficiency.

• Led a cross-functional team in Agile development to design an interactive Tableau dashboard, streamlining data from 34 suppliers and 60 raw materials to enhance inventory planning and procurement efficiency.• Developed a comprehensive data dictionary for inventory and supplier data, standardizing table formatting and creating a unified index to improve readability and usability for all future data entries.• Built an inflation tracking framework to monitor real-time spending and inflation trends, enabling internal stakeholders to conduct detailed analyses across multiple timelines and granular categories to make informed business decisions.• Delivered an additional demand prediction function to accelerate responsiveness to future demands, exceeding expected deliverables within assigned timeframe through effective Scrum practices, including sprint planning and retrospectives.

● Collect and clean user engagement data in SQL, define project scope through EDA analysis, perform feature engineering, and create data visualizations. Build and test random forest and XGBoost models in Python, and the final prediction model used for reference answers has AUC-ROC and F1 of more than 90%.● Build and test data pipelines for course projects, build fully automated Tableau dashboards to support future feature reproduction and data iteration ● Maintain and update data sheets and code files required for the course, and work with professors to write reference answers for projects and assignments● Participate in data pipeline design, participate in data analysis projects under Professor David Bergman and improve multiple KPI definitions. Responsible for the daily maintenance of the database, including establishing more than 40 data tables and checking data import

• Consulted clients across healthcare, finance, and retail sectors, addressing complex business challenges through in-depth competitive analysis, customized recommendation systems, and market trend forecasting to drive sustainable growth.• Generated consumer segmentation and satisfaction forecasts by building and validating Random Forest and XGBoost models in Python, achieving 90%+ AUC-ROC and F1 scores. Visualized insights to support data-driven decision-making.• Developed and implemented ETL processes for 200GB+ datasets, enhancing SQL queries with window functions, indexing, and caching. Reduced average database response time from 4s to 3s, lowering database and dashboard maintenance costs.• Collaborated with engineering and marketing teams to redesign KPI dashboards, resulting in a 30% increase in ROI.

● Conducted statistical analysis (e.g., Pearson's chi-squared test), built predictive models (e.g., Multinomial Logistic Regression) in python to identify associations on insurance data ● Collaborated with internal pricing department, managed and cleaned over 300k products' data, calculated descriptive statistics. Delivered market trends insights and created actionable dashboard ● Collaborated closely with cross-functional product and engineering team to extract meaningful business insights and identify the room for profit growth. Increased monthly profit from $1,000 to over $5,000