Learn Data Skills
Beta
Juan Alfaro

Juan Alfaro

Pricing Analyst

Amazon Web Services | Seattle, WA

Technologies

My Portfolio Highlights

My New Course

Introduction to Python

My New Workbook

Unicorn funding vs valuation

Data whisperer, turning numbers into captivating stories.

My Work

Take a look at my latest work.

course

Introduction to R

course

Introduction to Python

DataLab

Unicorn funding vs valuation

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Amazon Web Services (AWS) | Feb 2022 - Oct 2023

Custom Pricing Analyst

• Implemented private pricing agreements, collaborating cross-functionally with Pricing Analysts, Product Management, and Sales Operations teams on pricing strategies and technical responses into RFPs, resulting in a 13% increase in cloud revenue for Q3 2023. • Executed automation initiative to standardize pricing across 500,000 SKUs, resulting in a 5-week reduction in pricing adjustment process time, boosting operational efficiency and streamlining pricing management. • Enhanced pricing models by refining private pricing strategies for high-priority customers and securing over $50M in billing revenue. • Developed SQL queries for automation removing manual touchpoints, increased the volume and accuracy of queries within a 99.5% range, reducing customer churn, and bolstering profitability goals. • Leveraged expertise in OKR and KPI management to provide Product and Leadership teams with actionable insights, enabling data-driven decision- making and strategic course adjustments, leading to a marked improvement in team performance alignment.
Show More

Intelsat | Jun 2021 - Feb 2022

Supply Chain Operations Analyst

• Facilitated monthly S&OP, managed demand forecasting, analyzed inventory and sales data, and communicated key shifts and causative factors to stakeholders. • Improved inventory accuracy and shipment performance by analyzing ERP vendor data, pinpointing improvement opportunities, and reducing Q4 2021 escalations by 20%. • Implemented process improvements and automation tools to optimize team efficiency and reduce manual interventions, resulting in a 15% increase in customer lifetime value and enhanced stakeholder response rates by 2022. • Optimized critical inventory levels from the ERP system to align with 2022 demand forecasts enhancing cross-functional efficiency and financial planning resulting in a reduction of aircraft downtime globally by 17% in Q4 2021.

McMaster-Carr | Apr 2014 - Jun 2021

Distribution Specialist

• Established comprehensive standard operating procedures to streamline processes by eliminating inefficiencies and managed team workflows in order fulfillment, packaging, shipping, and quality management. • Facilitated the "goods-to-person" system during beta testing, boosting operational efficiency, reducing manual touch points, and enabling company- wide adoption by Q4 2023, while supporting daily logistics in freight and parcel sales. • Project managed warehouse-wide operating initiatives such as refining product storage locations and improving capacity planning, leading to a 33% boost in operational efficiency in 2020.

McMaster-Carr | Apr 2014 - Nov 2015

Freight Distribution Generalist

N/A

Old Navy | Jul 2012 - Apr 2014

Assistant Store Manager of Merchandising

Increased sales and profits through merchandise placement and marketing strategies. Developed an inclusive workplace environment through recruitment and hiring and provided guidance and support to direct reports within the onboarding process. Led in financial success ending 2012 +15% in budget level sales and +18.3% in sales comparable to previous year. Developed and implemented new standard operating procedures to increase business metrics, increase productivity, and improved retention. Pioneered new strategies through business analytics to promote company-wide goals to be aligned with evolving consumer behaviors.

Old Navy | Oct 2010 - Jul 2012

Customer Service and Training Manager

Trained and managed direct reports by implementing new sales strategies, product information, and stakeholder knowledge. Participant in the ASPIRE program which targets high-potential talent throughout the United States to train, develop and promote within the organization.

Old Navy | Jul 2009 - Oct 2010

Pricing Specialist

Improved marketing placement and pricing standards by utilizing customer experience behavior to succeed in profitability growth. Managed the execution of company defined operating standards and internal auditing compliance benchmarks.

My Education

Take a look at my formal education

Master of Science - MS Candidate, Data ScienceNorthwestern University | 2022
Master of Business Administration - MBA, MarketingLewis University | 2019
Bachelor of Arts (B.A.), Political Science and HistoryOlivet Nazarene University | 2009

About Me

Juan Alfaro

Juan hasn't filled in a bio text

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free