Ryan Mclaughlin Email & Phone Number

Cincinnati, Ohio, United States

Analyzed Marketing and Consumer Incentive programs and products, and presented campaign results to clients and internal leadership.Reported KPIs for individual campaigns, as well as portfolio performance on a cadence that fit with client planning.Worked closely with Sales organizations to determine successful Digital Incentives, based on Return on Ad Spend, Product Trial, or other KPIs to optimize Marketing Programming, and assisted with strategic planning of marketing spend with… Show more Analyzed Marketing and Consumer Incentive programs and products, and presented campaign results to clients and internal leadership.Reported KPIs for individual campaigns, as well as portfolio performance on a cadence that fit with client planning.Worked closely with Sales organizations to determine successful Digital Incentives, based on Return on Ad Spend, Product Trial, or other KPIs to optimize Marketing Programming, and assisted with strategic planning of marketing spend with data-driven insights and recommendations.Assembled recurring Business Review decks for Retailer and CPG clients to analyze product performance and campaign results.Utilized in-house proprietary reporting alongside syndicated BI tools, and designed and implemented custom reports as-needed. Formulated ad hoc database queries to assemble custom analyses for client or internal deep dives when appropriate. Show less

Cincinnati, Ohio, United States

Led and facilitated Quarterly and Annual forecasting for C-Suite Execs, Sales, Operations, and Finance Leaders in the organization, substantially improving forecasting accuracy over prior processes Managed the 2023 annual Volume Building Blocks (VBB) process for Revenue Planning and Quota setting for Sales Verticals and Product Families Supported multifunctional teams within the organization, delivering insights, analytics, and reporting in both a recurring and ad-hoc capacity

Cincinnati, Ohio, United States

Established recurring reports to measure sales forecast and diagnose performance of Influencer and other Media Campaigns Developed models for calculating Media Margin based on market conditions and financial inputs in order to simulate margin estimates against expectations, as well as evaluate real-world conditions against assumptions Visualized, reported, and diagnosed margin, and built tools to project P&L statements

Cincinnati, Oh

Provide and manage Business Intelligence services and IT support for a restaurant franchise group, which owns and operates up to 31 Casual and Fast-Casual concept restaurants in OH, KY, PA, and WV.Manage ETL processes for the flow of data from restaurants Back Office Systems to a myriad of systems of record, including Accounting, Sales, Payroll, Human Resources, and Accounts Payable.Compile annual accounting budgets for 31 Restaurants and Support Center.Design, maintain, and produce… Show more Provide and manage Business Intelligence services and IT support for a restaurant franchise group, which owns and operates up to 31 Casual and Fast-Casual concept restaurants in OH, KY, PA, and WV.Manage ETL processes for the flow of data from restaurants Back Office Systems to a myriad of systems of record, including Accounting, Sales, Payroll, Human Resources, and Accounts Payable.Compile annual accounting budgets for 31 Restaurants and Support Center.Design, maintain, and produce reports and visualizations for CFO, Board Members, and department leaders to communicate restaurant performance, financial metrics, and operational indicators.Provide and manage IT support to restaurants and Bistro Management back office.Manage outside service providers, including contract developers, technology purchases, support, and licensing.Administrator for local network, ERP software, and G Suite. Show less

Cincinnati, Oh

Create end-to-end BI dashboards and applications in QlikView to provide intelligence, insights, and reporting tools for Human Resources, Labor Management, Operations and Financial organizations within the company.Elicit, document, and fulfill functional and technical requirements for applications and data warehouse sources.Work with BI Architects to integrate unconventional data sources into the Enterprise Data Warehouse.Develop ongoing ETL Processes to convert data streams into… Show more Create end-to-end BI dashboards and applications in QlikView to provide intelligence, insights, and reporting tools for Human Resources, Labor Management, Operations and Financial organizations within the company.Elicit, document, and fulfill functional and technical requirements for applications and data warehouse sources.Work with BI Architects to integrate unconventional data sources into the Enterprise Data Warehouse.Develop ongoing ETL Processes to convert data streams into functioning data models for applications and data storage. Show less

Cincinnati

Led the integration and adaptation of legacy Business Intelligence and analytical systems and processes for the Pringles brand from P&G legacy into Kellogg’s architecture.Elicited requirements from Pringles leadership and Kellogg executives for the development of IT and BI tools that are critical for maintaining and monitoring the business.Developed Master Plan for the Pringles Brand to integrate into Kellogg Data Management systems, and for Kellogg IT to enroll Pringles Best Practices… Show more Led the integration and adaptation of legacy Business Intelligence and analytical systems and processes for the Pringles brand from P&G legacy into Kellogg’s architecture.Elicited requirements from Pringles leadership and Kellogg executives for the development of IT and BI tools that are critical for maintaining and monitoring the business.Developed Master Plan for the Pringles Brand to integrate into Kellogg Data Management systems, and for Kellogg IT to enroll Pringles Best Practices that are deemed beneficial, along with a training program to facilitate adoption company-wide.Constructed Business Intelligence tools for the Pringles brand, including Executive Topline reports, Sales and Marketing Dashboards, and data/reporting warehouses.Drove the construction and restatement of Relational Databases for Retail scanner Point of Sale data (Nielsen) to eliminate overlap and outages between the Kellogg- and P&G-defined categories of Cookies, Crackers, and Salted Snacks. Show less

Cincinnati, Ohio Area

Business Analysis Lead for the Pringles business, responsible for areas which included Business Intelligence, Commercial Analytics, and Market and Consumer Measurements.Worked closely with the Category Leadership Team (CLT) and commercial functions.Developed analytic tools and reports to meet business requirements.Facilitated the Strategic Revenue Management (SRM) process for US and Canada markets.Delivered quarterly Market Update to Leadership Team, enabling a holistic… Show more Business Analysis Lead for the Pringles business, responsible for areas which included Business Intelligence, Commercial Analytics, and Market and Consumer Measurements.Worked closely with the Category Leadership Team (CLT) and commercial functions.Developed analytic tools and reports to meet business requirements.Facilitated the Strategic Revenue Management (SRM) process for US and Canada markets.Delivered quarterly Market Update to Leadership Team, enabling a holistic perspective of market dynamics, and conveying trends and potential challenges. Developed an effective distribution defense, which led to preserving 20% of SKUs in the Drug Channel.Proposed adjustments to the Trade Promotional Strategy, increasing promotional lift by 50% over prior year.Integrated a consumption-based forecast into the monthly Demand Planning review process, improving accuracy by 10%.Managed Data Services Budget, vendor contracts, and contractor capacity. Show less

Cincinnati, Ohio Area

Commercial Analyst for Beauty Care GBU brands including Olay, Gillette, Old Spice, Venus, and Secret.Led the North America Market Measures component of the Global Beauty & Grooming organizational redesign.Executed Business Review Workshops for the Personal Cleansing, Deodorants, and Shave Care categories.Managed Data Services Budget, vendor contracts, and contractor capacity.Instituted a monthly data review process with Brand teams; created and produced market reports.

Cincinnati, Ohio Area

Corporate Engineering Technologies (CET) internal consultant to engineering and manufacturing leaders in the domain of processes involving the handling, manipulation, and transformation of powders.Recommended interventions, technologies, and system process modifications to troubleshoot, improve, and innovate manufacturing processes.Designed, conducted, and documented experiments at various scales.Lab owner - operated and maintained two labs with multi-scaled manufacturing equipment,… Show more Corporate Engineering Technologies (CET) internal consultant to engineering and manufacturing leaders in the domain of processes involving the handling, manipulation, and transformation of powders.Recommended interventions, technologies, and system process modifications to troubleshoot, improve, and innovate manufacturing processes.Designed, conducted, and documented experiments at various scales.Lab owner - operated and maintained two labs with multi-scaled manufacturing equipment, product raw materials, and analytic equipment.Recommended process improvements to Cosmetic manufacturing, which led to nearly doubling throughput at a savings of $500M annually.Consistently received high marks for safety, cleanliness, and compliance during Lab Audits. Show less

Berea, Ky

Supervised restaurant and delivery operations in excess of $500M annual sales.Maintained staffing, scheduling and training for 25+ employees, balancing labor cost, sales projection, and employee satisfaction. Managed inventory and supply chain to meet production demand and optimize cash flow.Designed and executed local marketing and promotion plans.

Master Of Science, Management Science / Operations Research

Bachelor Of Science, Physics

Sigma Pi Sigma