•Implement advanced SQL techniques (aggregation, CTE, window functions) to optimize ESG data queries, ensuring efficient navigation of dynamic data requirements•Automate ETL pipeline for ESG data on AWS (Athena, S3, Spark) to provide analysis on social development goals and Scope 3 emissions for oil and mining companies•Perform extensive web scraping on social media data and key disclosures such as SEC filings, applying NLP models to assess companies' social performance on ESG initiatives•Create political network maps and visualizations using PyVis and Tableau, uncovering political relationships and social sentiment trend for informed investing decisions

• Lead HR data analysis, tracking performance, engagement, and retention metrics, resulting in a 10% improvement in retention rates and supporting data-driven People Ops decisions • Construct data pipeline for ERP product standardization with data governance solution, boosting efficiency by 30% • Build exec-facing dashboards via Tableau to monitor sales trends and key initiatives, driving revenue by 10% • Coordinate cross-functional teams to support the SDLC of a last-mile delivery app, enhancing operational performance and scaling revenue by 10%

• Conducted preliminary market researches and quarter promotion campaign and data preprocessing• Performed A/B Testing for product ad copy on the Baidu Ads Platform to enhance ad performance, resulting in a significant CTR improvement from 65% to 70%, with a daily traffic volume of 5000• Drove marketing effects report by using various effect monitoring tools such as Google Analytics to facilitate future marketing strategy

• Conducted data cleaning operations for financial data of power grid company and established a new, more accessible and holistic database to streamline digital financial platform building process• Defined and computed over 25 KPIs using Tableau to provide comprehensive insights into the operational performance of the grid financial platform