Pranay Kekre

Pranay Kekre

About

Detail

Manager, Supply Chain Analytics at QVC | Transportation, Fulfillment, Network Planning & Optimization, Operations Analytics | DE&I Advocate
United States

Timeline


work
Job
school
Education
folder
Project
flag
Award

Résumé


Jobs verified_user 0% verified
  • Qvc
    Manager, Operations Business Analytics, Transportation & Dropship
    Qvc
    Dec 2022 - Current (3 years 11 months)
    Leading a team of Operations Business Analysts working across 2 retail brands at Qurate - QVC & HSN - that supports analytics, reporting, and forecasting for Outbound Transportation and Dropship. Responsibilities also include defining the future QxH fulfillment network roadmap & transportation strategy, optimizing for minimal cost & transit time to deliver joyful customer experience.
    Optimize & enhance team's productivity through Kanban-based Trello boards.

    ● Leading all aspects of Ship to Deliver strategy via modelling & analytics support for Project Athens, a strategic company turnaround initiative, navigating competing deadlines & business pivots
    ● Drove $60M+ cost savings via outbound & returns parcel carrier RFP an
  • Qurate Retail Group
    Communications Lead, FC Operations DE&I Advisory Council
    Qurate Retail Group
    Jul 2022 - Current (4 years 4 months)
    Nominated & selected to lead internal/external communications strategy & execution as a core functional lead within the FC Operations DE&I Advisory Council - a company wide initiative to expand/roll-out DE&I across QVC US & HSN Operations.
  • C
    Advisory Council Member
    Customer Experience at California State University East Bay
    Sep 2021 - Aug 2023 (2 years)
    Board Member, Advisory Council, Customer Experience Certificate Program at CSU East Bay - Continuing Education.
    CX is and needs to be the common thread interwoven across the fabric of every enterprise that strives to serve its customers. In my role as an Advisor for the CX Program, I provide thought leadership drawing from industry experience, and collaborate with fellow CX Advisors and Faculty to build and grow the program and discipline.
  • Qvc
    Senior Business Analyst, Order Fulfillment & FC Operations Analytics
    Qvc
    Jun 2020 - Dec 2022 (2 years 7 months)
    Senior Business Analyst focused on the Order to Ship (Order intake -> Drop/FC-Receive -> Ship) leg of the order fulfillment lifecycle, within Operations Planning & Optimization, across core US entities of the Qurate Retail Group - QxH: QVC, HSN (Home Shopping Network).

    ● Improved customer experience with a 20% (0.6 d) decrease in Order to Ship via order hold time reduction & optimized FC drop schedules matching demand patterns
    ● Led KPI development, consolidation & revamp of fulfillment operations reporting (WBR/MBR), operations root-cause visibility & action tools
    ● Modelled bottom-up Pack Factor forecasts for QxH FC network budget & MoM projections incorporating network changes, volume & mix trends
    ● Led re
  • rhi
    Business Analyst, Transportation & Supply Chain Analytics
    rhi
    Jul 2017 - Jun 2020 (3 years)
    Business Analyst on the Supply Chain Analytics team within Transportation, with experience across both inbound International Logistics (ocean/air freight, drayage, freight forwarding) & outbound Domestic Transportation (Middle Mile: FTL (OTR, InterModal, OTR Team), LTL, Furniture LTL, Last Mile Home Delivery, Small Parcel). Experience working on impactful strategic initiatives affecting the bottom line, supporting a best-in-class supply chain.

    ● Built interactive tools, scorecards & KPI dashboards across all areas of logistics by compiling data from multiple sources into actionable insights
    ● Supported $30M last mile network cost savings by analyzing carrier sourcing RFP bid costs & SLA’s, across strategic what-if scenarios<
  • B
    Graduate Instructor, Presentations & Public Speaking
    Brian Lamb School of Communication Purdue University
    Aug 2016 - May 2017 (10 months)
    Led 4 freshman sections (~200 students) of COM 114 (Presentations & Public Speaking/Fundamentals of Speech Communication) in the Brian Lamb School of Communication - College of Liberal Arts.
    ● Designed & led interactive lectures, presentations, quizzes & all hands-on classroom activities for 4 freshman sections; rated 4.9/5
    ● Participated in weekly activities & feedback driven instructor training sessions
  • Dana Incorporated
    Supply Chain Analyst, Procurement Analytics
    Dana Incorporated
    May 2016 - Aug 2016 (4 months)
    Supply Chain Analytics Intern within Strategic Sourcing & Procurement at Dana Incorporated (previously known as Oerlikon Fairfield), America's leading Tier-1 manufacturer & supplier of engineered Gear & Drive systems. Reported directly to 'Global Supply Chain Project Manager' and 'Head of Purchasing - Americas'.

    ● Developed a predictive regression (MLR) Should-Cost tool based on spend categories, led $250K savings from top 10 suppliers
    ● Conceptualized a supplier ranking & risk assessment scorecard based on KPIs such as cost, on-time delivery, quality & reliability
    ● Streamlined & automated monthly reporting data flows & dashboards with Excel VBA, reduced manual hours by 75%
    ● Improved procurement expense forecasti
  • P
    Graduate Research Assistant, Machine Learning
    Purdue University School of Industrial Engineering
    Oct 2015 - May 2016 (8 months)
    NSF-funded research in Advanced Analytics (Machine Learning) to gain insights into key energy consumption drivers and patterns across the US residential building stock.
    ● Extracted & wrangled combinations of US residential energy & census data using R to identify demand drivers & consumption patterns of energy use
    ● Built machine learning models & used comparative measures & cross-validation to identify model with highest out-of-bag predictive accuracy
    ● Featured in Engineering Impact Purdue campus magazine ("Keeping the lights on through the storm")
  • ISRO - Indian Space Research Organization
    Design Analysis Engineer, Chandrayaan-2 Lunar Rover
    ISRO - Indian Space Research Organization
    Jan 2015 - May 2015 (5 months)
    Worked on the telescopic landing leg mechanism of a historic & unprecedented Lunar Lander/Rover (Mission: Chandrayaan 2, launched in 2019) at the ISRO Satellite Center (ISAC), within the Spacecraft Mechanisms Group, as part of the senior year Capstone Experiential Learning Project.
    ● Optimized design of telescopic landing mechanism by generating vibration, stress & strain profiles at both launch & impact, using Finite Element Analysis software such as Nastran, Patran on Linux RedHat OS
  • Astrazeneca
    Supply Chain Analyst, Operational Excellence
    Astrazeneca
    Jun 2014 - Jul 2014 (2 months)
    Embedded within the on-site Operational Excellence initiative - 3V's (Visibility, Variability, Velocity) of Supply Chain.
    ● Recommended warehouse-overflow storage capacity expansion by analyzing existing capacity against rolling demand forecasts & Just-in-Time lead times by SKU
    ● Transformed a key drug process with a 20% reduction in lead time by identifying bottlenecks using Value Stream Mapping
    ● Improved site-wide Supply Chain Visibility by mapping material & information workflows via process flowcharts & swimlane diagrams
    ● Trained in-house on Lean Six Sigma & Process Improvement via Gemba Academy
Education verified_user 0% verified
  • Purdue University
    Master of Science - MS, Industrial Engineering
    Purdue University
    Jan 2015 - Dec 2017 (3 years)
    ● Specialization: Supply Chain/Operations (SCM/Ops IE & business school coursework, IE core coursework)
    ● Research: Data Analytics, Machine Learning (R modelling, tuning & testing)
    ● Purdue University Scholarship as a Graduate Research Assistant & Instructor (3 Semesters: Spring 2016 - Spring 2017)
  • Ramaiah Institute of Technology
    Bachelor of Engineering - BE, Mechanical Engineering
    Ramaiah Institute of Technology
    Jan 2011 - Dec 2015 (5 years)
  • V
    Indian Certificate of Secondary Education (ICSE
    Vidya Niketan School VNS Hebbal Bangalore
    Jan 2006 - Dec 2009 (4 years)
    Award for Academic Excellence (Mar 2009)
Projects (professional or personal) verified_user 0% verified
  • P
    PwC Technology Consulting Case Competition, 2017: Cybersecurity breach root cause analysis, PR response & mitigation str
    Mar 2017 - Current (9 years 8 months)
  • E
    Entrepreneurial Ideation, Business Model Selection & Strategy Planning, 2017: Peer-to-Peer student discount locator app
    Aug 2016 - Dec 2016 (5 months)
    Development of a full business model and business strategy of an entrepreneurial idea from inception to launch
Awards verified_user 0% verified
  • Purdue University
    Graduate Research & Teaching Assistantships: Spring 2016, Fall 2016, Spring 2017
    Purdue University
    Jan 2016
    Full tuition waiver with monthly stipend & insurance benefits
  • V
    Award for Academic Excellence
    Vidya Niketan School VNS Hebbal Bengaluru
    Mar 2009
This is a community-created genome.