Hi, I’m
JILLS JOY KOIKARA
Techno-Functional Supply Chain Professional
Anekal, Bengaluru,Karnataka
Summary
- An Enthusiastic Supply Chain & Analytics Professional with 12 years of Experience in Retail & E-Commerce Industry with Cross- Functional Knowledge such as Order Management, Reverse Logistics, First mile & Last Mile Logistics, Replenishment, Inventory Control & Analysis, Process Optimization, Operational Excellence, Data Analysis, Data Visualization & Interpretation, Cost optimization Analysis.
- Well-versed in various statistical methods such as descriptive and influential statistics. Independent and versatile individual skillful in identifying data issues and monitoring existing metrics.
- Proficient in Advanced Excel, SQL, Power Bi, Python.
- Diligent worker with strong communication and task prioritization skills.
- Seeking full-time position that offers professional challenges utilizing Data analysis and supply chain domain skills, excellent time management and problem-solving skills.
Overview
12
years of professional experience
5
years of post-secondary education
1
Certificate
Work History
Infosys India Pvt LtdBangalore
Consultant - Supply Chain Analytics
04.2021 - 04.2023
Job overview
- Supported clients with business analysis, documentation, and data modeling.
- Delivered outstanding service to clients to maintain and extend relationship for future business opportunities.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Designed and implemented tools to support strategic value chain optimization initiatives.
- Minimized 60% Hours of Report Processing through Automating Data Extraction.
- Developed Sell thru Analysis tool, to Identify SKU's that are Poor performing and take necessary actions.
- Key Projects - Top Assortment Value Analysis, Ecommerce Allocation Tool, Store Scorecards, Size Level Scorecard, Choice(Style-Color) level Business Reports.
Ascena Retail GroupBangalore
Senior Inventory Modeling Analyst
11.2019 - 03.2021
Job overview
- Led projects and analyzed data to identify opportunities for improvement.
- Developed Data Model to Review Store Performance on weekly Basis - Store Scorecard.
- Automated Reports using Excel VBA, MS Access & SQL
- Key Projects - Store Scorecard, SKU Size Scorecard, In-Stock Analysis Report.
- Key person in enabling data solutions for all Ascena retail brands.
- Improvised time consumption in processing metrics and business insights
Doodhwala - Banger Tech Pvt. LtdBengaluru
Senior Supply Chain Analyst
02.2019 - 08.2019
Job overview
- Improved Last Mile Productivity by Implementing Drop-point and Increase Delivery Efficiency
- Optimized Warehouse/Fulfillment Centre operations by revising operations layout
- Project owner for Tech Implementation across Last Mile & Fulfillment Centre
- Analyze data to identify problematic areas and suggest Improvements in Vendor Management, Last Mile Operations
- Root Cause Analysis conducted on Customer Dispute Escalation & Reduced it by 50%
- Capacity Planning for Building Optimum capacity for Delivery Executives with consent on reducing product Damages and Improve Customer experience
- Publish Weekly & Monthly Dashboard for Better visibility on Trend of Operational Efficiency and Scope for Process Optimization.
Sears IT and Management Services India Pvt. LtdHyderabad
Senior Analyst
01.2017 - 01.2019
Job overview
- Improved In-Stock levels of KSN's at store level
- Maintain 100% In-Stock levels for Top Stores Reduction of Inventory Cost by Analyzing to have Optimum level of inventory in stores/Warehouse
- Identify order exceptions, disruptions and supply chain constraints impacting supply chain execution and model future inventory plans against supplier capability
- Process Excellence on warehouse re-balancing by Inter-warehouse transfer that would avoid product movement to aged Inventory
- Provide regular forecasts to vendors, taking into account sales History, recent item trend, seasonality, promotional plans, and future store planning
- Leads others to adapt processes, solutions, successes, ideas and participates in continuous teaching about system capabilities and supply chain processes
- Identify root causes for store out-of-stock issues, including vendor availability, safety stock and minimum presentation levels, and sales trends.
Flipkart Internet Pvt LtdBengaluru
Assistant Manager
05.2011 - 01.2017
Job overview
- Key player in setting up and leading Analytics Team for First mile Logistics Control tower Team
- Built Daily/Weekly metrics visibility of first mile operations Performance to management
- Minimized Shipment Pickup breach, lead to accomplish 99% Compliance in creating Pickup Sheets
- Handled Project on Minimizing Seller Escalations, Improvement of Seller Operations - Minimized 99% of POD (Proof of Delivery) Escalations
- Improved Fleet Productivity from 300 to 450 Shipments/Van in Mumbai & Chennai Regions
- Initiated Cost Workshop to Identify Opportunities in streamlining Pickup Hub Cost - Output
- Weekly & Monthly Visibility on Cost Trend and Follow-up on the Cost Optimization Projects
- Initiated Process of Slot Allotting (ASN) for Shipment Deliveries to warehouse, it has Impacted on providing accurate information to warehouse, Minimized SLA breach.
Education
St. Joseph's College of Commerce, Bengaluru, KA
MBA from International Business
06.2009 - 04.2011
St. Joseph's College of Commerce, Bengaluru, KA
Bachelor of Commerce from Finance
06.2006 - 04.2009
Skills
Supply Chain Management
Timeline
Consultant - Supply Chain Analytics
Infosys India Pvt Ltd
04.2021 - 04.2023
Senior Inventory Modeling Analyst
Ascena Retail Group
11.2019 - 03.2021
Senior Supply Chain Analyst
Doodhwala - Banger Tech Pvt. Ltd
02.2019 - 08.2019
Senior Analyst
Sears IT and Management Services India Pvt. Ltd
01.2017 - 01.2019
Certified Procurement Professional (CPP),IIPMR
06-2014
Assistant Manager
Flipkart Internet Pvt Ltd
05.2011 - 01.2017
St. Joseph's College of Commerce
MBA from International Business
06.2009 - 04.2011
St. Joseph's College of Commerce
Bachelor of Commerce from Finance
06.2006 - 04.2009
Similar Profiles
Hemanth Sai Ram BhatlapenumarthiHemanth Sai Ram Bhatlapenumarthi
Senior Associate Consultant at Infosys India Pvt LtdSenior Associate Consultant at Infosys India Pvt Ltd
SAKTHIPRIYAN MANICKAMSAKTHIPRIYAN MANICKAM
Test Analyst at Infosys India Pvt Ltd (Client : FiveBelow )Test Analyst at Infosys India Pvt Ltd (Client : FiveBelow )
Muralidharan ThyagarajanMuralidharan Thyagarajan
SAP EWM Senior Consultant at IBM India Pvt Ltd.SAP EWM Senior Consultant at IBM India Pvt Ltd.