Here is the link.
- • Led the cross-functional team of 8 to detect 25M potential Alexa shopping opportunities by CX features with logic in SQL, defined 5 critical business metrics to drive business goal decision making for 2022, presented key business findings and recommendations of improving 4 shopping engagement feature of Alexa behaviors to senior management and established ETL automating the metrics reporting Weekly and Monthly.
• Cooperated with SDE and PM to track AB Testing of Beta feature launch, increased customer positive feedback rate by 5.4% of shopping experience on 4 locales with ~ 5 million Alexa Shopping customers by SQL.
• Created, automated and maintained SQL sampling logic and ETL pipeline of weekly Excel dashboards tracking the week-over-week worldwide performance of 28 product error, unactionbility and CX feature metrics to prepare for migration from human annotation to ML detection of Alexa.• Led the cross-functional team of 8 to detect 25M potential Alexa shopping opportunities by CX features with logic in SQL, defined 5 critical business metrics to drive business goal decision making for 2022, presented key business findings and recommendations of improving 4 shopping engagement feature of Alexa behaviors to senior management and established ETL automating the metrics reporting Weekly and Monthly. • Cooperated with SDE and PM to track AB Testing of Beta feature launch, increased customer positive feedback rate by 5.4% of shopping experience on 4 locales with ~ 5 million Alexa Shopping customers by SQL. • Created, automated and maintained SQL sampling logic and ETL pipeline of weekly Excel dashboards tracking the week-over-week worldwide performance of 28 product error, unactionbility and CX feature metrics to prepare for migration from human annotation to ML detection of Alexa.
- Skills: Data Engineering · ETL Tools · Amazon QuickSight · Quicksight · Python (Programming Language) · R (Programming Language) · Apache Spark · SQL · Microsoft Excel · TableauSkills: Data Engineering · ETL Tools · Amazon QuickSight · Quicksight · Python (Programming Language) · R (Programming Language) · Apache Spark · SQL · Microsoft Excel · Tableau
- • Designed, defined, developed and maintained the logic and ETL of Food Safety Audit and Escalation Monitor Tracking System with PM and DE by SQL and S3, automated and visualized 50+ key business metrics in Weekly reports via Tableau and Excel covering Amazon Go,Amazon Fresh and Whole Foods on 550+ sites, helped to increase the overall compliance rate from 83.4% to 93.3% with visibility to C level leadership.
• Discovered influential Food Safety miss on EggArmor compliance of 1K orders per week, worked with PM and DE teams to launch new EggArmor business metrics and establish ETL and reporting for consumption cross teams, preventing financial loss of 756K USD.
• Partnered with 10+ PM, DE, Legal and PR teammates on conducting cost business analysis of overbagging issues on Raw Meat and Fresh Produce in Whole Foods Market stores, optimized the business strategy as reducing 1.5 Million USD on bagging cost while insisting on highest Food Safety Compliance Standards.
• Identified fatal driver of low compliant performances ( audit failure miss of 200+ stores) of Whole Foods Market by SQL, implemented Stats experiment to validate assumption on the targeted stores, helped on document RCA and built Tableau reports for corresponding business decision monitor , increasing the compliance from 62.7% to 90.75%.
• Coordinated with EU team to standardize Food Safety Training SOP and automated status report involving 6K+ Amazon employees.
• Responded and answered ad-hoc media inquiry of Customer Feedback and Food Safety business questions with data support collaboration with PM and Legal team using SQL.• Designed, defined, developed and maintained the logic and ETL of Food Safety Audit and Escalation Monitor Tracking System with PM and DE by SQL and S3, automated and visualized 50+ key business metrics in Weekly reports via Tableau and Excel covering Amazon Go,Amazon Fresh and Whole Foods on 550+ sites, helped to increase the overall compliance rate from 83.4% to 93.3% with visibility to C level leadership. • Discovered influential Food Safety miss on EggArmor compliance of 1K orders per week, worked with PM and DE teams to launch new EggArmor business metrics and establish ETL and reporting for consumption cross teams, preventing financial loss of 756K USD. • Partnered with 10+ PM, DE, Legal and PR teammates on conducting cost business analysis of overbagging issues on Raw Meat and Fresh Produce in Whole Foods Market stores, optimized the business strategy as reducing 1.5 Million USD on bagging cost while insisting on highest Food Safety Compliance Standards. • Identified fatal driver of low compliant performances ( audit failure miss of 200+ stores) of Whole Foods Market by SQL, implemented Stats experiment to validate assumption on the targeted stores, helped on document RCA and built Tableau reports for corresponding business decision monitor , increasing the compliance from 62.7% to 90.75%. • Coordinated with EU team to standardize Food Safety Training SOP and automated status report involving 6K+ Amazon employees. • Responded and answered ad-hoc media inquiry of Customer Feedback and Food Safety business questions with data support collaboration with PM and Legal team using SQL.
- Skills: Data Engineering · ETL Tools
No comments:
Post a Comment