Roshan Vishwakarma
Faridabad
Summary
Results-driven Business Analyst with 3+ years of experience as a Data Analyst across logistics and e-commerce industries. Proven track record in end-to-end cost analysis, vendor cost modeling, invoice validation, and product development. Adept at collaborating with tech and product teams to ensure seamless operations and enhanced customer experience. Previously at 1K, contributed to network efficiency by tracking leading and lagging KPIs across stores, and developed comprehensive incentive plans for retailers and the sales team.
Overview
4
4
years of professional experience
Work History
Data Analyst
Xindus Trade Networks Private Limited
06.2023 - Current
- Delivered weekly end-to-end cost visibility from First to Last Mile, enabling accurate company-wide gross margin (GM) calculations
- Created an impact gross margin visualization dashboard in Power BI, enabling data-driven decision-making and fostering business growth.
- Managing a serviceability engine that analyzes different delivery combinations for a single shipment across the US and provinces to determine the cheapest option.
- Performed cost modeling analysis of all cost components by logistics leg to identify potential savings from newly onboarded vendors.
- Handling Last Mile issues to ensure smooth operations and enhance customer experience by minimizing delivery disruptions
- Managing a serviceability engine that analyzes different delivery combinations for a single shipment across the US and provinces to determine the cheapest option.
MIS Analyst
Odicea Distribution Technologies Private Limited
Gurgaon, India
05.2022 - 05.2023
- Maintained all the data points of all stores and provided workable information to the higher management on leading and lagging KPIs of stores to improve the network hygiene
- Build end-to-end incentive plans for retailers and the entire sales team.
- Prepared and maintained all the data sets for the required field teams & also for the entire operations team.
- Published reports daily Using app script to the higher management & Sales team.
MIS Executive
Cars24 Private Limited
Gurgaon
08.2021 - 04.2022
- Maintained organized records and databases for KYC processes, supporting audit readiness and regulatory reporting.
- Prepared and maintained all the datasets for the respected team.
- Coordinated between KYC, Sales, and Finance teams to collect and organize necessary documentation for client onboarding and compliance checks.
Education
Bachelor of Arts -
IGNOU
New Delhi12-2022
Certicate of Higher Secondary Education -
Haryana Board of Secondary Education
Faridabad Haryana05-2019
Skills
- Data Visualization
- Power BI
- Looker Studio
- Database Management
- MySQL
- Google Apps Script
- Analytics
- Google Analytics
Accomplishments
- Developed a serviceability engine to analyze cost data from multiple last-mile delivery partners.
- Assigned the last-mile partner with the lowest cost to each shipment.
- Aligned shipment delivery zones (based on distance) and ports (airports where flights land) with the chosen last-mile partner.
Serviceability Engine, Xindus Trade Networks Private Limited
Timeline
Data Analyst
Xindus Trade Networks Private Limited
06.2023 - Current
MIS Analyst
Odicea Distribution Technologies Private Limited
05.2022 - 05.2023
MIS Executive
Cars24 Private Limited
08.2021 - 04.2022
Bachelor of Arts -
IGNOU
Certicate of Higher Secondary Education -
Haryana Board of Secondary Education
Similar Profiles
Anisha YadavAnisha Yadav
Key Account Manager at Xindus Trade Private LimitedKey Account Manager at Xindus Trade Private Limited
Ravi GuptaRavi Gupta
Assosicates Manager (Accounts and Finance) at Xindus Trade Networks Pvt LtdAssosicates Manager (Accounts and Finance) at Xindus Trade Networks Pvt Ltd
Pranjul GuptaPranjul Gupta
Sr. KAM at Xindus Trade NetworkSr. KAM at Xindus Trade Network