Feb 2024 – Jun 2024 · 4 mos · Providence, Rhode Island, United States · On-site

• ⚫Work with SAS databases to improve and maintain current grids and data entry documents
• ⚫Create new workflow and efficiency grids for SAS
• Work inside Clockwork to improve/repair/create reports
• ⚫Create new grids that provide efficiency to various sectors of SAS
• ⚫Help remedy day to day tech problems as they arise
• ⚫Create clear instructions in the document comments and/or a easy to understand trouble-shooting guide
• Access:
• The student will need access equal to the student exam teams clockwork
• The student will need access to a specific section of the shared google drive folders

Sep 2022 – Dec 2022 · 3 mos · Hartford, Connecticut, United States · Remote

• ⚫ Led a team of five UConn Graduate Consultants in a capstone project for SBD, developing Tableau dashboards to monitor overproduced and underproduced materials, utilizing both internal and external data sources.
• ⚫ Created a metric with Python to analyze weekly production variances across multiple plants, comparing planned supply volumes with actual outputs to identify discrepancies in the supply chain.
• ⚫ Developed a Tableau dashboard with drill-down features for detailed analysis across sectors, enabling the monitoring of production by plants, SBUs, and materials, including weekly filters and comparative analyses against industry standards.

Dec 2021 – Jul 2022 · 7 mos · Los Angeles, California, United States · On-site

• ⚫ Mined data with SQL and implemented A/B testing to developing 100+ promotional strategies and predicting songs lifecycle.
• ⚫ Revitalizing underperformance songs by building Logistic Regression Model with Python to get rhythms, achieving success for 12 songs to 5% weekly national market share.
• ⚫ Identified suboptimal usage durations through market research with A/B testing and SPSS to optimize artist page content. collaborated with development team to boost click rates around 17%.
• ⚫ Resolved discrepancies in hotlist song data metrics and enabled real-time tracking of hotlist song data by creating an internal data reporting dataset with Hive and SQL.

Aug 2021 – Nov 2021 · 3 mos · Shanghai · On-site

• ⚫ Analyzed user satisfaction for non-sink markets with SQL and bulit Random Forest Model with Python to cluster data from 120K repurchase events and >7K questionnaire responses, increasing the user retention rate.
• ⚫ Developed 10+ pages visualized reports about product diversity analysis diversified warehousing proposals, and logistics tiering with Tableau and Python(Pandas&Numpy) for reducing cost investment.
• ⚫ Assisted in expanding product offerings and regional consumption trends by implementing A/B testing.
• ⚫ Built 10+ visualized dashboards in PowerBI with financial reports, retail trends, benchmarked competitor data for market share estimations and our investment advice.

Jul 2018 – Sep 2018 · 2 mos · Hybrid

• SF Delivery Company Smart Logistics Transportation Project
• ⚫ Integrated 50+ academic papers and industry research in non-sink markets with Nvivo and used k-means clustering to devise logistics classification, visualizing data metrics with Python(Numpy&Matplotlib).
• ⚫ Used Excel(Vlookup) to summarize data and supported business expansion for client companies. Deloitte Intelligent Financial Robot Evaluation Project
• ⚫ Evaluated and upgraded robots against usage scenarios for 40 target companies' financial products with Powerpoint&Excel.
• ⚫ Aided in creating web-based data analysis product, resolving cross-border fund payment delays, performance glitches, and other client issues.