DREW GETSINGER
Phoenix,AZ
Summary
Strategic and analytical professional with 6 years of success and growth within multiple lines of business. Proven results in delivering advanced Excel and SQL reporting to plan, design, action and evaluate key performance indicators. Highly adept in analyzing business needs using technical skills to provide data and information analysis to achieve continuous improvement. Proficient in advanced Excel formulas and functions, developing QuickSight dashboards and writing scheduled and ad hoc SQL queries.
Overview
13
13
years of professional experience
Work History
Business Analyst
PillPack Pharmacy
12.2021 - Current
- Lead analyst for Dynamic Facility Optimization launch and expansion to reduce procurement, labor, and shipping costs resulting in a cost to fill savings of $0.12 per order across over 1MM orders monthly.
- SME for the Customer Promise Guarantee, an Amazon first with a contractually obligated DEA metric. Amazon Pharmacy became the exclusive mail order pharmacy for 2 insurance providers and expanded to 12 providers while increasing partner order volume by 1700% within 2 years as a result of this success.
- Completed all FDA required URAC testing to promise same day delivery in 7 metro areas while maintaining a >99% on time delivery.
- Identified the opportunity to consolidate multiple purchases from the same customer on the same day into a single shipment. Performed a cost benefit analysis to obtain the ideal hold time to attain 76% of opportunity with minimal impact to the order charge curve. This reduced the cost to ship by $4 per shipment and reduced the environmental impact of unnecessary packaging waste.
Data and Reporting Analyst
Amazon.com
03.2020 - 12.2021
- Created an automated tracking mechanism for CPT Bus Route Audit compliance for the TNS network to decrease missed customer promise delivery windows.
- Performed an in depth analysis and pilot of the zone stowing method proving its efficacy and partnered with a program developer to build and implement a web tool resulting in a passive labor cost savings of $10MM annually.
- Onboarded all USNS fulfillment centers to the Future VRID webhook script to alert outbound dock teams when trailers were being loaded out of sequence preventing CPT misses.
- Attended the 2020 network summit and redesigned and implemented an improved standard for ASIN categorization across all USNS sites reducing inventory defects.
- Collaborated with the Process Engineering team to overhaul and relaunch a network capacity report to alert all inbound teams of fullness risks and automatically generate actions to avert them.
- Calculated the imbalance in a critical bin type, Pass-Through, across the three Northeast regions to redirect freight to the buildings with the capacity to process and decrease inbound backlogs.
Data Analyst
Amazon.com
07.2018 - 03.2020
- Performed all capacity management functions and duties as Bin Meister including leading weekly Space Management meetings with senior leaders.
- Launched, trained, and established standard work practices for Bin Meisters on CMH3, ACY2, and GSO1 away teams.
- Strategically added capacity during peak to achieve maximum FC utilization of 106% and 109% in 2018 and 2019 respectively.
- Coordinated with engineering, procurement, operations and contractor teams to complete retrofitting racking of bulk floor space resulting in a 745,000 gross cubic feet addition.
- Utilized wasted space areas behind bat-bins in VNA racking as part of Project Open Eyes and remotely assisted implementation of this at RIC1.
- Redesigned pick paths in VNA to minimize travel time and reducing vertical travel by up to 50%.
IC/QA Process Guide
Amazon.com
09.2017 - 07.2018
- Evaluated quality problems and produced detailed reporting to identify and resolve issues.
- Updated quality control standards, methods and procedures to meet compliance requirements.
- Followed quality standards and procedures to minimize errors and maximize customer satisfaction.
Shift Manager
CVS Health
08.2010 - 06.2015
- Kept employees operating productively and working on task to meet business and customer needs.
- Devised new promotional approaches to boost customer numbers and market penetration while enhancing engagement and driving growth.
- Tracked receipts, employee hours and inventory movements.
- Trained and mentored new employees to maximize team performance.
Education
Bachelor of Science - Computer Science
Southern New Hampshire University
Hooksett, NHHigh School Diploma -
Kingsway Regional High School
Woolwich Township, NJ06.2009
Skills
- SQL including ETL Processes
- Amazon RedShift Databases
- QuickSight and S3
- Google LookML and Looker
- Microsoft Office
- Web-Based Reporting Tools
- Data Visualization
- KPI Tracking
Timeline
Business Analyst
PillPack Pharmacy
12.2021 - Current
Data and Reporting Analyst
Amazon.com
03.2020 - 12.2021
Data Analyst
Amazon.com
07.2018 - 03.2020
IC/QA Process Guide
Amazon.com
09.2017 - 07.2018
Shift Manager
CVS Health
08.2010 - 06.2015
Bachelor of Science - Computer Science
Southern New Hampshire University
High School Diploma -
Kingsway Regional High School
Similar Profiles
TAHNEE THOMASTAHNEE THOMAS
Pharmacy Customer Care Team Leader at PillPack Pharmacy / Amazon PharmacyPharmacy Customer Care Team Leader at PillPack Pharmacy / Amazon Pharmacy
Susan LumbSusan Lumb
Billing Specialist/Data Entry Pharmacy Technician at PillPack PharmacyBilling Specialist/Data Entry Pharmacy Technician at PillPack Pharmacy
Louise MosconeLouise Moscone
CPHT at PillPack PharmacyCPHT at PillPack Pharmacy
Tatum GallaspyTatum Gallaspy
Waitstaff at Magnolia TableWaitstaff at Magnolia Table
Katie PenaKatie Pena
Assistant Principal of Curriculum and Instruction at Pinnacle High SchoolAssistant Principal of Curriculum and Instruction at Pinnacle High School