Melissa John Email & Phone Number

Lehi, Utah, Us

Salesforce Scrum Master

Lehi, Utah, Us

Managing a team of 6 analysts.Creating the strategy for developing and implementing a data warehouse.Organizing and facilitating project planning, daily stand-ups, reviews, retrospectives, sprint/release planning, demos and other Scrum-related meetings.Reporting of key insight trends, using statistical rigor to simplify and inform the executive team of noteworthy story lines.Working with product owners to define project scope and objectives.Document data warehouse table interactions and definitions of key business metrics.

Lehi, Ut, Us

Led strategy for increasing sales across multiple products. Supervised and directed the prioritization of work and analyses of direct reports. Gave recommendations to top-level management to increase sales, improve the customer experience and cut costs.Sampling of Successful Projects:1. Standardized the reporting structure for Ancestry products to improve cross-site functionality.2. Negotiated deals with 3rd party vendors to give visibility into competitive DNA and Family History landscape. 3. +42% cross-sell subscriber growth vs forecast due to tagging, providing insight, and recommending actions.4. Created analysis and presentations for the annual end of year summary of company performance to C-level executives which helped guide strategy for the following year.5. Implemented on-site tracking of banners and CTAs to increase visibility of DNA sales sources by 58%.6. Led cross-functional effort to establish first-ever automated data pull from Amazon (via API) to drive 108% increase in sales volume.

Lehi, Ut, Us

Developed the analytics processes and structure for the rapidly growing DNA business. Analyzed data from finance, marketing, operations, product and A/B testing to identify critical business solutions.Sampling of Successful Projects:1. Created a methodology and reporting structure to track 128% DNA sales growth year over year.2. Led a committee for the AWIT organization which promotes women in leadership and technology roles.3. Created and automated 30+ Tableau dashboards to give insight into the business for top-level management. 4. Performed financial analytics to determine the cost of acquiring new customers, the price point at which products should be sold and contributed to end of year budgeting meetings.5. Participated in annual planning of product features and identified inventory issues/improvements needed.6. Wrote detail-oriented product requirements used to implement product, operations and sales strategies.7. Identified key issues with commerce flow and recommended improvements which increased average order size by 20%.

Lehi, Ut, Us

1. Performed financial analysis to determine the cost of acquiring new customers, the price point at which products should be sold and preparing for end of year budgeting meetings.2. Analyzed marketing campaigns to identify what effects they had on the business (i.e. sales and product satisfaction).3. Queried large volumes of online and offline data across various platforms.

Lehi, Ut, Us

1. Used SQL to analyze databases for quality and ensure users can make meaningful discoveries2. Published databases to the staging environment and set up the UI3. Provided statistical reports, feedback, analysis, and possible solutions based on anomalies and other markers in the data4. Acted as a back up Tester when necessary, focusing on functionality of the site and data performance-Develop processes, queries, and stored procedures in SQL to improve quality and efficiency

Researched papers that are applicable to data I analyzed.Wrote code to analyze data from doctorate students.Created a model to decrease fat content in bodies.Assisted a PhD student in writing his thesis.Presented my results at a conference for the DAAD.

Created Excel spreadsheets to organize and track company errors.Analyzed data from online and telephone surveys.Checked data to ensure accuracy of information given to clients.Helped compile reports sent to clients.Checked logic of surveys being used.

Provo, Ut, Us

Researched papers that are applicable to education in developing countries.Met with specialists in different fields of study to improve my research.Wrote code to analyze school district data for trends in test scores.Wrote a research paper to report my findings.

Provo, Ut, Us

Taught interpretation of graphs and data sets twice a week.Worked in an open lab, teaching students to use statistical tools.Graded homework assignments weekly.Provided one-on-one tutoring to students.Help International, Volunteer Uganda, Africa Summer 2010 Created a method to gather school data into Excel.Taught district education officers how to interpret statistical data.Programmed formulas in excel for government officials to do analysis on education data.Organized educational fairs for different elementary schools.Organized dental camps at elementary schools.