PORTFOLIO
Welcome to my Supply Chain Analytics Portfolio. Here, you will discover my professional journey, key projects, and unique insights into supply chain analytics.
Gijo Kochuparambil John
Supply Chain Specialist | Aspiring Supply Chain Analyst
Welcome to my Supply Chain Analytics Portfolio. I’m glad you’re here! Let’s embark on a journey through my professional experiences, explore key projects I’ve undertaken, and gain unique insights into the world of supply chain analytics.
As a dedicated supply chain enthusiast, I have always been passionate about the analytical side of things. My expertise lies in supply chain operations, covering inventory management, inbound, and outbound operations. I have honed my skills and gained valuable insights into these areas. As a certified data science professional, I am committed to leveraging analytical tools to optimize supply chain processes and drive meaningful results.
Current Location: India, Chennai | Email: johngijo1@gmail.com |
Awards & Recognition
Education
Bachelor of Commerce
Institute Name : Mar Gregorious College of Arts & Science, Chennai
Grade: 7/10
MBA in Supply Chain & Operations
Institute Name : New Delhi Institute of Management, New Delhi
Grade: 7.2/10
Certified Data Science Professional
Institute Name :Odin School, Chennai
Certifications & Records
Data Analytics Projects
Data Analytics Project: Delivery App Data Analysis With Power BI
Introduction: Delivery App Data Analysis Using Power BI Problem Statement In the highly competitive and fast-paced e-commerce industry, efficient delivery processes are crucial for maintaining customer satisfaction and…
Data Analytics Project: Exploring Coffee Quality Data with Power BI
Introduction In the realm of coffee production, quality is paramount. The Coffee Quality Institute (CQI), a non-profit organization dedicated to enhancing the quality and value of coffee globally….
Data Analytics Project: Analyzing NREGA Effectiveness Across Indian States
The National Rural Employment Guarantee Act (NREGA) is a crucial initiative aimed at enhancing livelihood security in rural areas of India by providing at least 100 days of…
“In the world of supply chain, analytics reign, turning data into insights, and challenges into gains“
– Gijo Kochuparambil John
Professional Experience
Jun 2017 to Mar 2018 · 10 mos
Location-Chennai, Tamil Nadu, India
Godrej & Boyce Mfg. Co. Ltd
Graduate Trainee- Sales
Cultivated and nurtured relationships with existing customers, resulting in a 7% increase in customer retention rate.
Exceeded sales targets by 13% through strategic planning and effective relationship management, while concurrently spearheading initiatives to enhance the store’s online presence.
May 2020 – Jul 2020 · 3 mos
Location– Remote
ICICI Bank Limited · Internship
Management Intern – Market Research
As part of my MBA curriculum, I completed an internship with ICICI Bank, where I undertook an in-depth micro-market analysis of the Moti Nagar region in Delhi, delving deep into local market dynamics and customer preferences to uncover valuable insights.
Devised and executed a strategy aimed at elevating customer experience through digital channels, culminating in a comprehensive report detailing findings and actionable recommendations. Implementation of these recommendations is projected to result in a minimum of 15% rise in online customer engagement and a 20% reduction in customer churn rate within the first six months.
Identified pivotal customer requirements and preferences to tailor financial products that resonate with their distinct needs.
Offered insightful suggestions for formulating new products precisely tailored to meet customer needs, driving business growth and enhancing overall customer satisfaction.
( Based on this Internship Project submission I was offered Pre-Placement Offer with ICICI Bank )
Click Here – Pre-Placement Offer Letter Link
Sep 2021 – May 2024 · 2 yrs 9 mos
Location: Gurgaon, Haryana & Chennai, Tamil Nadu (India)
Flipkart India Pvt.Ltd
Operation Executive- Warehouse Operations
Supervised and Led a team of 120+ members to optimize operational efficiency in warehouse functions.
Ensured seamless inbound and outbound operations, leading to a 13% reduction in pendencies.
Pioneered continuous improvement initiatives, yielding a 43% reduction in breach incidents, a 11% decrease in mis-shipments. Reinforced safety and quality guidelines, reducing workplace incidents by 62% over the fiscal year 2023.
Over my tenure,I up-skilled and trained the team, resulting in a remarkable improvement in the warehouse’s knowledge assessment score from 60% to 97%.
Acievment: Received the OPS Champion Award for the AMJ’22 Quarter by orchestrating a significant reduction of 50,000 shipments in losses and misshipments.- Issued by Flipkart India Pvt Ltd – (Jan 2022)
Click Here to view Award Recognition
May 2024 – Jun 2024 · 2 mos
Location: India · Remote
Mentorness · Internship
Data Analyst Intern
Conducted in-depth analysis of COVID-19 data using SQL, uncovering critical insights and trends to inform public health strategies.
Developed and visualized key performance metrics for NREGA (National Rural Employment Guarantee Act) using Power BI, aiding in policy evaluation and decision-making.
Click Here to View Certificate of Completion
Blogs
Understanding Inventory Optimization in Supply Chain Analytics
What are common inventory valuation errors? how can they be avoided?
Accurate inventory valuation is crucial for businesses of all sizes, influencing financial reporting, operational decisions, and overall profitability. However, several common errors can lead to inaccuracies in inventory valuation, potentially impacting business performance. Let’s explore…
How can you address discrepancies found during inventory audits?
Inventory audits are crucial for maintaining accuracy in inventory records and ensuring smooth operations. Inventory Discrepancies found during these audits can lead to stockouts and negatively impact the order fill rate, disrupting the supply chain…
How to account for the Hidden or Indirect Inventory Carrying Cost?
Inventory carrying cost is a crucial aspect of inventory management that often goes unnoticed. Understanding and accounting for these hidden or indirect costs can significantly impact your bottom line. In this blog, we will explore…
- Advanced Excel
- SQL
- Power BI
- Python
- Operations Management
- Inventory Management
- Process Improvement
- Planning
- Customer Relationship Management
- Stakeholder Management
- Certified Data Science Professional – Odin School
Projects
Palletized RFID Tracking System Implementation
Led a project to implement a palletized RFID tracking system, significantly reducing mis-sorts and breaches, thereby enhancing operational efficiency.