Michael Mays Email & Phone Number

Chicago, Illinois, Us

• Created and owned Power BI architecture and implementation of enterprise-scale CRM datasets used for internal analysis of all client-facing work• Successfully transitioned dataset from Salesforce to Dynamics while ensuring all downstream reports remained operational• Worked with stakeholders to understand their true needs to develop metrics and create actionable reporting• Used advanced M language to create custom functions and solve challenging data transformation needs

Chicago, Illinois, Us

• Conceived and developed VBA solution to automate process for delivering interactive Excel reports to client• Used internal Excel add-in to facilitate the ETL process while ensuring each associate was using the latest version of each Excel template• Provided client users increased flexibility in viewing/charting the data• Automated ~15,000 client deliveries per year, accounting for time savings of ~4,000 hours each year

Chicago, Illinois, Us

• Managed Nielsen relationship with and oversaw brand analyses for all of Family Care (6 brands with annual sales of $3.3 billion).• Developed Joint Business Plan in conjunction with client’s analytics team to guide research objectives throughout the year.• Saved client hundreds of thousands of dollars by creating a report that automated the process of pulling syndicated data into a customized format, preventing the need for a custom database.• Created four automated Nielsen Panel reports, allowing for customized calculations, improved data visualization, and error free delivery while saving Nielsen team more than 400 hours in time spent compiling data for ad hoc requests.

Chicago, Illinois, Us

Reporting/Tool Creation• Used VBA to automate a report that took 4 hours per month to create for one market and period (and was subsequently only used by one team) so that it can now be updated for any market and period in less than 3 minutes, with additional functionality to help the user find assortment opportunities and threats.• Created and rolled-out a quarterly report that helped reduce custom client requests by nearly 70% and reduced the amount of time it took for users to find a compelling sales story.• Developed tool that allows the client's category management team to create a standardized, eight slide PowerPoint retailer story in minutes.Sales/CatMan• Prevented a major retailer from delisting a sub-brand by demonstrating that the product was incremental to the category, which helped the client retain $1.2 million in salesBrand• Disproved retailer’s assertion that an MVM was not effective at bringing new buyers into the store, leading the retailer to run the promotion – which increased a new sub-brand’s total dollar volume by 42% – a second time.• Determined why a $900 million brand was losing buyers and identified an expansion opportunity of 10% as the brand transitioned from a loyalty to a penetration strategy.• Oversaw all Nielsen work for three brands with combined retail sales of $1.8 billion, including the launch/expansion of three sub-brands.

Chicago, Il, Us

• Identified target expansion opportunity among college students and created presentation of findings, leading client to rethink long-held assumptions and expand its growth target by 4.1 million people.• Helped develop strategies for six-figure new business pitches by utilizing 3rd party research (Experian Simmons, Mintel, etc.).• Evaluated cross-purchase data to generate insights for creative team and ensure their ideas aligned with client's marketing goals.• Created custom tools to give team members easy access to hard-to-find Census data needed for insight development.

Chicago, Illinois, Us

• Analyzed data to determine impact of in-store execution (POS, shelf space, etc.) on sales rates, leading to change in location of additional coolers.• Supported still beverage category at Coca-Cola Enterprises by supplying clients with insights into effectiveness of promotions, pricing, and distribution• Designed Excel reports to provide over 400 Coca-Cola employees (including executives) with extensive Nielsen weekly data to help them report metrics to the business community and better understand the performance of Coke and its competitors.• Developed Excel tool using VBA that allows field users to personalize selling stories by providing individual stores with retailer, store, and nearest competitor data.

Bethesda, Md, Us

• Designed a database and implemented a strategic system to continuously update the status of safety inspections at Marriott hotels worldwide. • Developed PowerPoint analysis for corporate executives documenting violations of partnership agreements by Internet wholesalers.• Coordinated and managed relationships with executives from over 150 Marriott properties to collect documentation necessary for the completion of a corporate partnership.

New York, Us

• Produced a directory of more than 40 Georgia based service organizations to assist full time staff in contacting and placing volunteers. • Composed persuasive descriptions of upcoming service opportunities to attract potential volunteers. • Entered data daily into in-house database used to manage confidential donor and patient information.

• Developed new systems for correcting duplicate and corrupt Excel data, which increased efficiency in contacting potential donors and raising money.• Compiled invitation lists of potential donors and assisted in organizing fundraising events exceeding 3,000 attendees.

B.S., Marketing, Management

Education record