Summary
Overview
Work History
Education
Skills
Timeline
Generic

TOBY RAINE

Glen Allen

Summary

Self-motivated professional with a background conducting market research and implementing pricing methodologies. A determined pricing analyst with exceptional data assessment, relationship building and writing skills.

Overview

8
8
years of professional experience

Work History

Data Analyst

McKesson Corporation, Pharmaceutical and Medical Supply Distribution
08.2021 - Current
  • Develop hundreds of customized pricing reports that highlight weaknesses and product management opportunities for Sales to target
  • Automate price changes and increases that are implemented on a quarterly or month-to-month basis
  • Use SQL and PowerBI to accurately demonstrate pricing trends and low-margin products that need updated pricing
  • Participate in company-wide pricing projects that tackle large-scale price/product updates
  • Identify data reporting errors and make changes that positively impact sales and contracting efforts.

Pricing and Contracts Administrator

Spectrum Chemical Mfg, Chemicals & Lab Supplies
07.2018 - 01.2020
  • Used SQL and company ERP to mine pricing and sales data and conducted costing analysis to determine overall profitability within corporate strategy when creating or modifying pricing contracts
  • Took over as software professional for the company’s data analytics and business flow software; took classes in SQL and Filemaker coding to automate daily business practices and ensure accuracy in data reporting
  • Collaborated with Sales, Finance, and multiple other departments to establish and review strategic pricing models, performed a complete review of over 500,000 individual discounts and special pricing modifiers
  • Worked with Sales to determine product viability with regard to market analyses, updated internal product database and troubleshooted quoting discrepancies to ensure product and pricing accuracy
  • Developed personalized automated daily sales report for CFO that showed pricing methods and their effect on the annual sales goals
  • Looked for room to improve methods and expand target sales
  • Surpassed target sales in both years of employment
  • Developed annual commissions plan for two separate sales teams that incentivized growth and improved upon shortcomings from previous years’ plans.

Pricing Data Analyst

Scat Enterprises
08.2015 - 07.2018
  • Managed and updated price sheets across multiple sales departments, creating multiple price levels and custom pricing for VIP customers
  • Mined product data from ERP system and compiled it into viewer-friendly product reports
  • Communicated with overseas manufacturing companies to coordinate product shipping and delivery specifications
  • Streamlined the product pricing system through ERP procedures and linking product pricinglevels to their respective customer profiles
  • Compiled competitor price and product data to maximize profits but maintain competitiveness across key resale customers
  • Experimented with overseas design and database teams to create industry standard data presentations.

Education

Bachelor of Science - Biology

Principia College
Elsah, IL
05.2015

Skills

  • Capital and Resource Allocation
  • Data Quality
  • SQL
  • Statistical Analysis
  • Model Data
  • Microsoft Power BI
  • Advanced Excel Spreadsheet Functions
  • Competitive Market Analysis

Timeline

Data Analyst

McKesson Corporation, Pharmaceutical and Medical Supply Distribution
08.2021 - Current

Pricing and Contracts Administrator

Spectrum Chemical Mfg, Chemicals & Lab Supplies
07.2018 - 01.2020

Pricing Data Analyst

Scat Enterprises
08.2015 - 07.2018

Bachelor of Science - Biology

Principia College

Similar Profiles

CREATE PROFILE
TOBY RAINE