Kiera Lynn Carvalho Email & Phone Number

Los Angeles, Ca, Us

Greater Los Angeles Area

• Led data strategy and analytics for promotional campaigns for Beachbody’s Network of 400,000 distributors, including: o Baseline modeling, forecasting and determining the viability and rules of a promotion o Creating tables and views utilizing Snowflake, and building and executing complex queries with SQL and Alteryx o Analyzing promotion results and providing leadership with key insights and actionable recommendations for future initiatives• Spearheaded the launch of promo-code initiatives, creating tracking systems in Hive and delivering $2.3 million in incremental sales.• Automated email campaigns sends and ETL processes using SQL and Python• Developed and maintained Tableau dashboards to provide stakeholders with the ability to make data-driven decisions ; while also training users to access and derive insights from their customized reporting• Partnered with BI and product management to define data structures and analytical solutions for new product/feature launches

Greater Los Angeles, California, United States

Greater Los Angeles Area

Greater Los Angeles Area

• Developed a comprehensive CRM database powered by Redshift and Knime providing greater depth, scope, and timeliness of analytical reports• Created self-service BI systems using PowerPivot and Tableau for Key Accounts, Marketing and Legal that allow business users to view relevant data, and trained users to optimize the value of these systems• Automated weekly programmatic campaign sends using SQL and Knime – successfully measured the impact of these campaigns and provided actionable insights to marketing to iterate promotion strategy• Successfully led a cross-functional project with Key Accounts, DBA and BI to automate the rebate calculation and payment process for TVG’s most valuable customers• Conducted exploratory research using SQL and MS Excel to identify new revenue generation opportunities for TVG• Created Real-time Dashboards using Tableau to assist TVG’s TV producers and on-air talent with decision making

Greater Los Angeles Area

Conducting research analysis to identify gaps between the syllabi of Business Analytics courses across the United States on one hand, and the industry requirements for positions in the field of Analytics on the other hand• Designed databases using SQL and MS Access and created Excel templates to organize required research topics for professors and present weekly reports and deliverables

Master Of Business Administration (M.B.A.), Information Science/Studies And Marketing, 3.98

Dissertation titled “The Realized and Unrealized Value of Mobile Proximity Payments”, 2015

Pgdhrm, Human Resources

Activities and Societies: Core Team Member, International Relations Committee, MDI (2008 - 09) Core Team Member, HR Research Panel.

Bachelor Of Arts, Psychology/Sociology

Activities and Societies: Graduated with Honors in Psychology, St. Xavier's College; Secretary - Social Service Leagues, St. Xavier's.