Stanford Health Care

Principal Data Consultant

CareRev

• Liaison between the analytic department and the strategy and product teams, providing support and generating data solutions to their problems
• Built a company strategic goal dashboard, measuring yearly goals with weekly progress to allow for early interventions
• Identify customer behavior prior to churning and after returning to identify their value and proper incentives to increase return rate
• Track user behavior across the app and what they're doing and where

Senior Data Analyst

Health Catalyst

• Collaborated with multiple stakeholders (from analysts to VIPs) across client teams to implement new value-based product tools and provide training
• Guided clients through the implementation process from data verification and governance, to configuration, and on to final sign-off and delivery 
• Mapped the above process into detailed steps to enable best practices

Senior Analytics Analyst (Population Health)

• Strategized with clinical improvement teams using data to diagnose a problem, determine a SMART goal, and forecast a solution
   • Provided an analysis of hysterectomies that helped decrease LOS on average from 30 to 19 hours, saving $110K annually
   • Built a Webi/BOE dashboard measuring ambulation post-surgery to improve adherence to new standards
   • Built a dashboard tracking flu vaccine rates and enables clinicians to improve outreach to patients. Provided analysis to determine the patient demographic of who receives a vaccine. Results published in a peer-reviewed paper
   • Analyzed COVID rates among employees to determine which employees had a higher chance of testing positive and where exposure was occurring. Results published in a peer-reviewed paper
• Converted old Qlikview dashboards to Tableau
• Remediated several ETLs to fix data errors and optimize processing times
• Mentored employees new to Health Catalyst and new to the Stanford team
• Served on the technical review committee, reviewing team members’ code

Senior Analytics Analyst (Analytics Service Organization)

Intermountain Healthcare

•	Performed complex financial analysis for several insurance companies to set new contract rates with revenue totaling 3 billion of dollars
     •     Used SQL to pull data from several tables across millions of rows
     •     Optimized the query to go from outputting in days to hours
     •     Performed bootstrap analysis in R to sample several subsets of data
     •     Created statements for each payer showing actual net revenue versus anticipated net revenue under new rates
•	Provided all analytical support for a company initiative to lower prices on commonly shopped procedures for a total impact of $70 million
     •     Created a pro forma in Excel to model effects of differing price levels on net revenue by region and payer
     •     Established a Tableau dashboard to measure YOY change in revenue, net revenue, costs, and net operating income

Senior Data Analyst (Decision Support and Population Health)

•	Measured the financial impact of potential changes in laws and strategies by creating a sample population and estimating new payment rates that will impact several thousand members
•	Performed exploratory work on the populations we serve as part of an expansion of strategy. Pulled descriptive metrics to understand the target market better
•	Presented baseline metrics to leadership committees for measurables in determining the new year goals
•	Modeled differing contract pricing on future populations to determine mutually acceptable terms with insurance groups
•	Built a Tableau dashboard for leadership to track company and departmental goals

Associate Data Analyst (Decision Support and Population Health)

Larry H. Miller Dealerships

•	Created customer journey and process maps for the car buying experience across 19 different dealerships after on-site visits
•	Analyzed data from dealerships to determine processes, customer exit points, and conversion rates
•	Built a dashboard in Domo to visualize the data
•	Recommended best practices based on analysis of the process and dealers

Customer Experience Analyst Intern

Kaiser Permanente

•	Collected and analyzed data from Google Analytics, data warehouse reports, vendor extracts, and databases 
•	Analyzed paid search campaigns, including landing pages, ad copy, and keyword phrases to determine new KPIs targeting different segments of the marketing funnel
•	Created new dashboards in Tableau for website analytics

Direct Marketing Data Analyst Intern

Gibbs Smith, Publisher

•	Project manager for several books, consulting with authors and designers to ensure all parties were heard and understood while maintaining the company’s interests 
•	Designed advertising materials, including ads for print and online, mailers, and brochures; thereby increasing sales and brand exposure 
•	In-house designer for high-end coffee table books, which were referred to as “beyond gorgeous”
•	Created new products (puzzles, posters, and totes), including product design and packaging
•	Worked with contractors to establish products met printer specifications and schedules; identified bottlenecks in the process and implemented strategic systems to ensure smooth and timely production
•	Managed production team, from manuscript to printer proofs
•	Created sales materials to be sent out to national sales reps for each book, tracking costs and budget
•	Developed protocol in sending books to the printer, which cut corrections and delays at printer by 90%
•	Implemented a system for converting existing titles to ebooks utilizing CSS and HTML. Ebooks now account for $200,000 yearly in sales
•	Researched other publishing company logos and redesigned Gibbs Smith logos, implementing the 
change across all mediums to manage brand
•	Redesigned company catalog, which saved $25,000 in production costs. Many sales reps called it their best designed and most organized catalog
•	Provided career coaching for two employees

Editorial Production Manager

Standard Plumbing Supply

• Worked with clients to choose plumbing fixtures for new homes, created quotes, and 
analyzed budget constraints
• Worked with plumbers tracking orders and costs, to keep projects on schedule and within budget
• Managed showroom, rotating product and keeping layout updated to showcase new and best-selling product

Sales Associate

I’m a data geek who gets giddy when I get a dataset dropped on me and told to dig in. I love taking millions of data rows from disparate tables and bringing order to them; then working with stakeholders to discover actionable outcomes and solve problems.   
 
I have a unique skill set that combines my experience with data analytics and graphic design into the ability to create data that is understandable and engaging. 

I keep a pair of hiking boots in my car at all times in case of a hiking emergency. Experiencing, sharing, and preserving the outdoors are passions of mine.

Taplio

Melissa Dymock's Linkedin Analytics

Want to drive more opportunities from LinkedIn?

Taplio

.css-1jgreyo{background-image:linear-gradient(284deg, rgba(39,43,72,1) 0%, rgba(33,47,183,1) 100%);color:transparent;-webkit-background-clip:text;background-clip:text;}Melissa Dymock's Linkedin Analytics

Want to drive more opportunities from LinkedIn?

Melissa Dymock's Linkedin Analytics