Drew Shaffer

Drew Shaffer Email and Phone Number

Pricing and forecasting analyst at Roche @ Roche
Drew Shaffer's Location
Carmel, Indiana, United States, United States
Drew Shaffer's Contact Details

Drew Shaffer work email

Drew Shaffer personal email

n/a

Drew Shaffer phone numbers

About Drew Shaffer

Finance professional with extensive Excel knowledge including Visual Basic programming, customized development, and problem-solving within data sets. Deep understanding of data analytics, financial modeling, and determining the next steps in a project sequence. Strong analytical skills that translate to business models.Proficient with Java, SQL, Python, NetSuite, SAP, ProSeries, Excel, Visual Basic, Data Analytics, Budget Development, Financial Planning

Drew Shaffer's Current Company Details
Roche

Roche

View
Pricing and forecasting analyst at Roche
Drew Shaffer Work Experience Details
  • Roche
    Strategic Pricing And Forecasting Analyst
    Roche Sep 2022 - Present
    Switzerland 🇨🇭 , Ch
  • Marathon Health
    Senior Financial System Analyst
    Marathon Health Jun 2022 - Aug 2022
    Indianapolis, In, Us
    - Built custom reports in NetSuite to efficiently distribute accurate and timely information to Regional Managers.- Created and managed projects between Finance, Accounting, and Data teams.- Created custom data fields to allow operational data to flow through to Accounting and Finance teams.
  • Trimedx
    Pricing Analyst
    Trimedx Aug 2020 - Jun 2022
    Indianapolis, In, Us
    -Created automated databases in Sigma computing allowing portfolio analysts direct access to current pricing information-Utilized and maintained data sets using both SQL and Snowflake to deliver accurate pricing information to clients-Responsible for rewriting SQL code/queries to Snowflake to smooth the transition to cloud computing-Created new pricing strategies to simplify business practices while maintaining or improving revenue generated-Identified errors and anomalies in data resulting in more accurate pricing, more consistency resulting $90k of increased revenue
  • Independent Consultant
    Financial Business Consultant
    Independent Consultant Dec 2019 - Aug 2020
    Financial Consulting:Box Fox, Indianapolis, Indiana-Pre-Acquisition financial modeling and analysis-Provided financial analysis for company saleSola Salons, Data Modeling Project-Assisted with NetSuite implementation-Created advanced Excel models for various sales and fee schedulesIndependent Tax Consultant, Various Projects-Prepared tax returns for individuals and small businesses
  • Northwest Financial Services, Inc.
    Associate Financial Planner
    Northwest Financial Services, Inc. Jan 2019 - Jan 2020
    Indianapolis, Indiana, Us
    -Created custom data models in Excel-Created a customized retirement model that solved for multiple variables and reduced employee workload by over 3 hours per week-Created an advanced dynamic forecasting model for charitable giving and tax analysis saving clients on average $2k per year- Developed comprehensive financial plans and analysis including cash flow, forecasting, and budgeting- Managed communications with over 83 clients totaling more than $85MM in assets- Responsible for money transfers up to $1.2MM- Member of the investment committee responsible for mutual fund selection for client portfolios- Presented financial models at management meetings
  • Northwest Financial Services, Inc.
    Finance Intern
    Northwest Financial Services, Inc. May 2018 - Aug 2018
    Indianapolis, Indiana, Us
  • The Hageman Group
    Real Estate Management Intern
    The Hageman Group May 2016 - Aug 2016
    - Completed and implemented an efficiency optimization study for over 200 real estate properties- Managed email communications regarding the status of the project with three separate companies to ensure the project was completed on time- Developed an Excel dynamic decision matrix to project the profitability of future development opportunities
  • Estes Design And Manufacturing
    Installation Technician
    Estes Design And Manufacturing Jun 2013 - Aug 2014
    Indianapolis, In, Us
    Field Installation Technician.Worked as part of a small team, as well as individually.Assisted in product design and development.Trusted to perform most work without supervision.

Drew Shaffer Skills

Teamwork Customer Service Python Java Accounting Data Analysis Financial Analysis Business Analysis Requirements Analysis Business Strategy Financial Reporting Microsoft Excel Microsoft Office Web Mapping Demographic Analysis Communication

Drew Shaffer Education Details

  • Taylor University
    Taylor University
    Finance

Frequently Asked Questions about Drew Shaffer

What company does Drew Shaffer work for?

Drew Shaffer works for Roche

What is Drew Shaffer's role at the current company?

Drew Shaffer's current role is Pricing and forecasting analyst at Roche.

What is Drew Shaffer's email address?

Drew Shaffer's email address is dr****@****edx.com

What is Drew Shaffer's direct phone number?

Drew Shaffer's direct phone number is +131728*****

What schools did Drew Shaffer attend?

Drew Shaffer attended Taylor University.

What skills is Drew Shaffer known for?

Drew Shaffer has skills like Teamwork, Customer Service, Python, Java, Accounting, Data Analysis, Financial Analysis, Business Analysis, Requirements Analysis, Business Strategy, Financial Reporting, Microsoft Excel.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.