Data Analyst Supply Chain

Alex Puma

Port Orange, FL 631-***-**** *******@*****.***

DATA ANALYST

Accomplished data analyst with experience implementing systems including supply chain analysis, data mining, pricing trends, data consolidation, empirical data recognition, problem solving, and identifying network improvements to meet business goals.

CORE COMPETENCIES

Transportation Management Data Analysis KPI Metrics Model Optimization Customer Service

Pricing and Contract Visibility Data Mining Performance Management Market Inefficiencies

PROFESSIONAL EXPERIENCE

Bio-Rad Labs (Hercules, CA) 2023 – 2025

Transportation Analyst III

Performed data mining to identify pricing improvements and cost mitigation opportunities with the shipping network while maintaining on-time performance for our customers.

•Compiled and analyzed historical shipping information for the purposes of running RFPs to reduce cost, aligning to market inefficiencies and adjust to pricing requirements.

•Negotiated rates and maintained pricing rate sheets with Transportation Service Providers and established spot rates and technical guidance for one-off consignments.

•Worked with cross-functional departments such as sales, finance and accounting to develop models to obtain necessary price reduction goals and target tighter KPIs.

•Designed and generated standard reports that summarize key operational metrics on a daily, weekly and monthly basis.

•Created a communication system (e.g. mailing list, web system) to deliver market intelligence, regulation changes, fraud, etc.

Abbott Labs (Orlando, FL) 2016 – 2023

Transportation Analyst

Utilized historical spend to build a cohesive benchmark of cost and service that would help leadership make important decisions regarding pricing and customer compliancy.

Developed strategies to enable business growth and cost mitigation though thorough modeling and dashboard implementation.

Produced a comprehensive cost per test model that yielded shipping costs for COVID-19 tests globally in order to identify pricing trends and highlight key ebbs and flows in the market for the planning and finance teams. Worked with Transportation Service Providers to set up a system to provide shipment status in a timely manner to fulfill operational requirements.

Invoiced audit, accruals, reconciliation, freight payment monitoring, and contract compliance.

Supported the efforts to improve the performance of the Transportation Service Providers which may include attendance at routine (annual or quarterly) reviews.

Performed global freight RFP events with the cost savings while preserving customer expectations and delivery functions.

Leviton Mfg. Company Inc. (Melville, NY) 2013 – 2016

Financial Logistics Analyst

Worked hand in hand with the finance team to monitor monthly transportation spend, identify abnormal trends, and determine the root cause of these abnormalities. Developed business tools and solutions based on knowledge, product, and technology, and identified logistics process improvements, such as the Least Cost Carrier program that mitigated freight costs by about $30K per quarter.

•Compiled PNL reports and fixed/variable costs for profitability and present to upper management on a monthly basis.

•Performed data management through a combination of data mining with Access, data modeling, data analysis, cost/benefit analysis, and/or problem analysis.

EDUCATION

Bachelor of Arts, Mathematics

SUNY Albany, New York, US

TECHNICAL SKILLS

Microsoft Access Excel Outlook Word PowerPoint Teams

SAP/TMS SQL Power BI Smart Sheets Hyperion

Contact this candidate