Joginder Singh
Summary
Results-driven Data Analyst with a strong background in data modeling, analysis, and visualization. Experienced in transforming complex data sets into actionable insights to drive business success. Proficient in SQL, Big Query, Tableau, and Python, with a proven track record of optimizing operational efficiency and maximizing profitability. Committed to leveraging analytical and problem-solving skills to support informed decision-making and business growth.
Overview
10
10
years of professional experience
Work History
Senior Data Analyst
Just Eat Takeaway (Skip The Dishes)
01.2022 - Current
- Analyze big data using SQL to build driver pay trends, identify problem areas and develop actionable recommendations for approximately 200 zones and 90,000 active couriers
- Develop and maintain market trends, economic variables like inflation, CPI for stakeholders and build forecasting and reporting tools
- Collaborate with cross-functional teams to track, report and reconcile budget allocation across courier pay, incentive, marketing programs
- Identify opportunities using programming & reporting tools for process improvements to remove human error and increase efficiency.
- Improved data accuracy by implementing stringent data validation processes and quality control measures.
- Optimized database performance, implementing indexing strategies and partitioning techniques to reduce query times.
- Identified untapped revenue opportunities by conducting thorough market research and competitor analysis using collected datasets.
- Trained junior analysts in best practices for statistical modeling techniques, fostering professional growth within the team.
- Served as a subject matter expert on various projects, sharing valuable insights derived from extensive industry experience as a Senior Data Analyst.
- Provided guidance on data governance policies to ensure compliance with industry regulations.
- Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
Supply Chain Analyst - Transportation
Princess Auto
06.2019 - 12.2021
- Developed a network optimization model that aimed to reduce direct and indirect costs related to domestic purchase orders
- This model, based on a Hub & Spoke approach, aimed to consolidate, and decrease the total number of POs on an annual basis
- Developed inventory capacity models for distribution centers and stores using historical data, event-driven volume, and seasonality to understand inventory flow
- Responsible for forecasting inventory for three distribution centers and finding solutions to optimize inflow and outflow
- Developed, automated, and managed weekly reports resulting in standardizing, and better performance of the reports
- Developed various models with the help of Power BI tools to cut time from basic, labor-intensive data processing to fully automated reporting, resulting in 40-60 hours of savings in the department.
Transportation Analyst
The Northwest Company
03.2018 - 06.2019
- Responsibilities included leading network optimization projects to improve processes, increase profitability, and reduce costs
- Developed a statistical model using regression and confidence interval analysis to forecast fuel surcharge based on crude oil pricing, which resulted in a profit of $500,000 in Q4-2018, with an estimated annual profit of over $2 Million
- This project was well-received company-wide and was featured in the company's internal newsletter
- Additionally, I was the project lead for a cold-chain optimization project budgeted at over $400,000 annually, with an estimated net savings of over $500,000 over a 5-year project cycle
- Developed various models to cut time from basic, labor-intensive data processing to fully automated reporting, resulting in countless hours of savings in the department
- Responsible for reporting on FY budgeting & forecasting on P&L, forecasting, and incidentals
- Developed KPI on SLA performance using an advanced data modelling approach for over 3 years of historical data
- Furthermore, I performed regular analysis for rate updates from various carriers handling freight for over 130 retail stores in the North Canadian market.
Pricing Analyst
Bison Transport
03.2014 - 01.2018
- Lead the Pricing & Admin units within the LTL department by focusing on various pricing models specific to customer requirements
- Performed network optimization on one of the Elite accounts that resulted in a net savings of $420,000 annually
- Administered pricing for new and existing contracts which included, maintaining accurate and timely contractual updates, adjustments & extensions, etc
- Sustained growth by winning contracts with both volume and margin-centric pricing models by analyzing historical data
- Worked closely with national and regional account managers in aligning sales and operations opportunities to support rational pricing proposals
- Worked on RFPs & RFQs for major clients in sectors like retail, manufacturing, automotive, etc
- Situated in both the Canadian and the US market.
Education
Post-Graduation Diploma in Technology Management -
Red River College
Winnipeg, Manitoba01.2014
BEng in Engineering Management -
University of West of Scotland
Glasgow, Scotland01.2012
Skills
- SQL
- Big Query
- Excel
- G-Suite
- Looker
- Tableau
- Excel Dashboards
- Python
- Power Query
- ETL Processes
- Business Intelligence
Additional Experiences
Project assistant at St. Amant (Development disability and Autism center).
Profile Objective
As a data enthusiast, my mission is to transform complex data sets into meaningful insights that drive business success. With years of experience in data modeling, analysis, and visualization, I am eager to help organizations harness the power of their data and make informed decisions that maximize profitability. My passion for uncovering hidden patterns, coupled with my expertise in cutting-edge tools like Power BI, Tableau, and SQL, enables me to create dynamic and visually appealing reports that captivate and inform stakeholders. With my analytical and problem-solving skills, I strive to continually enhance business performance, accelerate growth, and optimize operational efficiency. Let's work together to unlock the full potential of your data and drive success in today's competitive business landscape.
References
References available on request.
Timeline
Senior Data Analyst
Just Eat Takeaway (Skip The Dishes)
01.2022 - Current
Supply Chain Analyst - Transportation
Princess Auto
06.2019 - 12.2021
Transportation Analyst
The Northwest Company
03.2018 - 06.2019
Pricing Analyst
Bison Transport
03.2014 - 01.2018
Post-Graduation Diploma in Technology Management -
Red River College
BEng in Engineering Management -
University of West of Scotland
Similar Profiles
Akshay PatelAkshay Patel
Inventory Coordinator at SKIP THE DISHES/ SKIP EXPRESS LANEInventory Coordinator at SKIP THE DISHES/ SKIP EXPRESS LANE
Varun SinghVarun Singh
Delivery Driver at DoorDash & Skip The DishesDelivery Driver at DoorDash & Skip The Dishes
Pardeep SinghPardeep Singh
Food Delivery (Full Time) at Skip The Dishes/ Uber EatsFood Delivery (Full Time) at Skip The Dishes/ Uber Eats
Jonathon NanceJonathon Nance
Senior Data Analyst /Lead Data Analyst at Two Kings CasinoSenior Data Analyst /Lead Data Analyst at Two Kings Casino
Gopala ChandraGopala Chandra
Senior Consultant/Senior Data Analyst/Data Science Specialist at Gopala RSenior Consultant/Senior Data Analyst/Data Science Specialist at Gopala R