Seattle, Washington, United States
I have a genuine passion and profound appreciation for what I do. For me, deciphering complex data is like solving a puzzle. I am inherently curious and love stringing information together, giving it meaning, and bringing it to life as a holistic, easily intelligible story. I find fulfillment in solving complex challenges through data and providing insights that help companies make more informed and powerful decisions. I also have a natural talent for uncovering discrepancies within datasets. I have yet to encounter an issue that I cannot solve for. If there is an error in data, no matter how deep it goes, I will find and provide a solution for fixing it. Data Technologies: SQL, Excel, Tableau, MicroStrategy, Azure Databricks, Power BI, Access, Abode Analytics, Google Analytics / GCP, AWS, Salesforce, Zoho, Visio, PowerPoint Consumer Demographics & Behaviors: Nielsen/Scarborough, IRI, NPD, MRI Simmons, Kantar, SPINS
Contract based business partner specializing in data analytics and surrounding spaces: • Data Analytics / Data Analysis • Exploratory Data Analytics / Data Mining • Insights, Storytelling & Visualizations • Dashboarding & Report Automation • Trend and Performance Tracking • Campaign / Program Strategy • Consumer Behaviors & Motivations • Segmentation & Cohort Analytics • Strategic Planning & Forecasting • Competitive Landscape & Whitespace Opportunities • A/B Testing & Scenario Modeling • Data Validation and Investigation • Process Improvement, Creation & Documentation • Data Migration • Data Hierarchy Structure • Statistical Relevancy • Critical Thinking • Multitasking • Presenting • Working in Ambiguous Environments
Expanded Microsoft’s listening mechanisms and insights centered around the customer experience. Integrated learnings into organizational decision making by creating a cycle of continuous learning across measurement programs. ● Distilled large amounts of qualitative survey feedback into quantifiable themes and actionable recommendations. ● Built capability awareness by incorporating insights into stakeholder meetings and executive business reviews. ● Developed and execute strategic insight programs; assess stakeholder needs, manage logistics, analyze data. ● Revamped existing reporting with key metrics representative of current business needs.
• Streamlined company-wide reporting by extracting, testing, cleaning, and aggregating data from sparse sources, along with publishing Tableau dashboards, redesigning Excel legacy reports, and automating updates • Increased speed to insights for analysts’ company-wide by exploring raw data sources in SQL and building Databricks datasets, with reference libraries, data dictionaries, linkage trees, and best practice manuals • Uncovered errors in data feeds driving inconsistencies between tables and created root cause and solution summaries for team leads and BI; tested fixes with BI prior to publishing • Ran multitude of ad-hoc analytics, distilling complicated sales data into easily understood concepts; presented storytelling summaries of key insights and recommendations to senior leadership and cross-functional partners • Investigated promotion performance, at item and customer segmentation levels, through SQL and Databricks; assisted Sr. Director of Marketing in designing client-centric strategy plans, with forecasts • Prepared test and control groups for conducting A/B testing and analyzed results for initiative validation • Participated in a cross-functional SME collaboration committee, responsible for triangulating data and improving accuracy and efficiency in reporting across teams
• Identified sales trends and explained shifts in spend, orders, number of buyers, saturation rates, purchase frequency and loyalty; presented visualizations and commentary on business impact to C-suite • Developed advanced SQL queries to extract and manipulate large datasets to quickly test key hypotheses, sharing relevant story-driven insights cross-functionally • Established key target markets through mixed-methodology research; devised meaningful benchmarks for performance indexing across geographies and provided metric driven heat maps with demographic overlays • Created user-friendly, scalable Tableau, Salesforce and MicroStrategy dashboards; provided access to accurate, real-time data for Sales Development, Loyalty, and Customer Service teams • Measured social media impact; tracked new followers, impressions, and engagement across multiple platforms, utilizing Google Analytics, Adobe Analytics and Grytics • Forecasted and made recommendations for enrollment and marketing campaigns; shared performance through systematic reporting and long-term client behavior analyses, i.e., behavioral differences between cohorts • Designed sophisticated scenario planning and forecasting models in Excel utilized by Brand and Marketing • Performed data validation and error tracing through SQL, Tableau and Excel • Generated appropriate client segmentation lists for the Market Research team; assisted with customer feedback survey design, analyzing results and preparing storyboards • Supported the development of a CRM tool that standardized ticket entry, and prepared legacy data for Salesforce software conversion