• Utilized Databricks in order to formulate automated monthly ETL pipeline for email metrics such as spam and bounce

• Examined multiple data sources containing over 100,000 monthly records employing SQL & Python and designed a singular

aggregated table through multiple joins and queries

• Created scoring methods for email health category through PCA analysis utilizing 3 principal components and weights for the 6

metrics

• Established a live data product using Tableau assisting stakeholders to see email metrics, health, and reporters filtered by month,

scoring method, and health category, reducing potential email send risk by 20%

• Collaborated with 2 engineers and 1 analyst to retrieve 10000+ record datasets from SAP and PEGA to filter down variables relevant to feedback cases for loaned-out/trial products

• Examined data using Python, SQL and Jupyter notebooks to see top trending problems within cases related to various geographic regions in order to present 3 areas of impact for cross-sectional engineer, finance, and management teams

• Implemented cluster program based on k-means and found 8 main root causes within text descriptions of cases

• Automated data analysis and detection processes and generated reports within 1 day, reducing workflow timeline by 14 days

• Analyzed results from a 500+ person survey using Tableau and Excel to formulate and promote pricing analysis to management

• Researched and evaluated 3 different target launch cities for 2021 based on SWOT framework to drive GTM motion

• Spearheaded efforts around creating unique B2B and B2C playbooks to generate 2 target markets of customer acquisition funnel

• Composed and implemented a daily plan for 3-month periods to balance fun events and learning, leading to increased satisfaction for kids and increased revenues for the camp

• Formulated stories of life lessons in order to expand and increase the knowledge of kids