Operation Analyst

4 years

0 Lacs

Posted:5 days ago| Platform: Linkedin logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

*Key Responsibilities:*


*1. Warehouse & 3PL Planning*


- Forecast daily and weekly dispatch volumes and derive capacity plans for 3PL partners.

- Monitor warehouse KPIs: order processing TAT, inventory turnover, reverse logistics timelines.


*2. Logistics & Last-Mile Tracking*


- Analyze courier performance: delivery SLA, RTO %, zone-wise delays, and claim management.

- Build courier allocation models to optimize cost and reduce delays based on zones and weight slabs.


*3. Advanced Excel Automation*


- Build fully automated Excel tools using:

- Pivot Tables and slicers for interactive reports

- Nested formulas, array functions, and INDEX-MATCH logic for SKU planning


*4. Dashboarding*


- Create live Power BI dashboards for:

- Warehouse throughput (inbound/outbound trends, TAT, aging)

- Inventory health (stock cover, sell-through, replenishment)

- Logistics tracking (dispatch vs delivery, courier TAT, cost/order)


*5. Inventory Split across Multiple WH*


- Design automated excel on inventory split across multiple WH pan India.


*Required Qualifications:*


- Bachelor’s degree in Engineering, Business, Logistics, or Supply Chain.

- 2 – 4 years of experience in supply chain operations, 3PL or logistics analytics.

- *Advanced Excel* expertise: PivotTables, complex formulas, VBA/macros.

- Experience with WMS/OMS systems (Unicommerce, Vinculum, SAP, etc.).

- Excellent problem-solving and coordination skills.


*Preferred Skills (Nice to have):*


- SQL, Python, Power BI.

- Experience in e-commerce, fashion retail, or multi-WH networks.

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now

RecommendedJobs for You

bangalore, chennai, kurnool, rajahmundry, tamil nadu, tirupati, nellore, vijayawada, vishakhapatnam, kakinada

Mumbai, Maharashtra, India

Bengaluru, Karnataka, India

Bengaluru, Karnataka, India