Part of the Data Analytics, Insights, and Machine Learning team

Lead data analyst for Proprietary Food and Beverage marketing insights and strategySelected Analytical Experiences:• Conducted RFM Analysis and performance analytics for product campaigns, resulting in optimized customer segmentation, tailored customer personalization strategies, and accurate churn prediction models. Leveraged data-driven insights to achieve a 34% customer reengagement rate in a win-back campaign targeting coffee drinkers• Applied hypothesis testing in A/B testing for an email campaign. Identified the better-performing email variant. Achieved a 25% increase in email conversion rate through deployment of the optimized email strategy• Tracked user journeys for welcome email through monthly reports, pinpointing key bottlenecks and enhancing the user experience. Resulting a 17% increase in user engagement through strategic optimizations• Leveraged Python to clean and transform customer preference survey data and conduct Jaccard Analysis, ranking qualities and attributes most important to consumers. Utilized these insights to construct a customer preference quadrant chart for comparison with competitors, enabling 7-Eleven to make informed strategic decisionsSelected Technical Experiences: • Designed and managed BI dashboards that track marketing campaign performance, emphasizing critical metrics like Customer Lifetime Value, Customer Retention Rate, and Loyalty Membership Conversions• Coordinated extensively with stakeholders to understand their specific business requirements, ensuring that the BI dashboards were tailored to meet their specific needs.• Collaborated with data engineers to design data warehouses to optimize query and data pipeline efficiency for BI performance• Enhanced existing Power BI reports by implementing dimensional data modeling best practices, resulting in improved data accuracy, report performance, and user experience• Utilized advanced SQL queries such as CTEs and Window Functions for Ad-Hoc data retrieval requests

Contract role responsible for leading a comprehensive BI overhaul, including redesigning existing reports, developing new visualizations, and optimizing data models for improved performance and usabilitySelected Experiences• Designed scalable data warehouses using dimensional data modeling principles for BI purposes. Coordinated with data engineers to implement ETL processes• Built and managed BI dashboards to monitor KPIs such as revenue, views, and creator acquisition pipeline. Drafted comprehensive documentation for data models and business logic, ensuring transparency and facilitating seamless knowledge transfer within the team• Identified SCD Type 2 issues in existing BI reports stemming from custom SQL queries, partnered with data engineers to implement snapshot tables, ensuring accurate adjustments for SCD Type 2 changes• Collaborated in a cross-functional team that analyzes and identifies new income sources. Conducted data mining and sensitivity analysis on potential new revenue streams

Contract role responsible for developing SQL data pipelines for HR analysisSelected Experiences:• Developed and scheduled SQL queries to extract data from MSSQL, enabling the creation of ETL pipelines for HR analysis. This significantly reduced reliance on manual data exports from ERP software and improved overall workflows• Built BI dashboards to analyze key metrics such as employee benefit status, job site allocation, and dormancy• Automated numerous Excel reports using SQL, Python, and Bash, leading to substantial time and resource savings

Selected Experiences: • Developed and implemented an ETL pipeline using Python to enhance efficiency in sales and product data processing to a MySQL database• Designed dynamic Tableau dashboards to showcase monthly business KPIs and employee performance