Pranay Jamuar

• Controlling master database of the Delivery orders.
• Creating dashboards by extracting data from Oracle database.
• Efficient in Excel and Power Bi dasboards.
• Creating and Reviewing Delivery Sales in the form of dashboards.
• Owning Route/Vehicle optimization project and software and responsible for making any required changes in the tool for optimizing delivery operation
• Managing complete backend/ source code (JAVA Based) of the tool and fixing the bugs if store team facing any technical issues with the above-mentioned tool
• Analyzing performance of store delivery efficiency and find out ways to achieve more efficiency
• Implementation of Vehicle optimization tool across all stores
• Support Store team for achieving their goals in regards with on time and optimized deliveries
• Have collected data from different sources and created dashboard for yearly/Monthly delivery performance
• Owning 2 projects and implemented across all the stores and personally trained store team
• Set delivery processes and implemented across all the stores
• Implemented COD delivery project by making required changes and tested end to end personally
• Implemented Apps for the drivers and provided training
• Currently achieving 95% on time delivery and 90% vehicle capacity by implementing the optimization tool.

• Complete live scout monitoring and support.
• Planning routes as per the order counts and time slots for the next operational day for cities like London, New York, Birmingham, Manchester, Dublin, Amsterdam and multiple cities in Middle East
• Taking, understanding and fixing real time issues of drivers to help them collecting and delivering orders in the allotted timeslots
• Optimizing planned routes to make it more efficient during the live operation
• Giving Training to new drivers on boarded
• Back office operations for verifying, confirming and creating new order
• Good experience in Apps like On fleet, Jira.

• Managing complete data of the Franchise's across country.
• Collecting data from multiple resource and visualizing the same.
• Giving insights to the management for business progress.

Skills:

Ms Excel and Excel Formulas

• Handling End to End Ecommerce operation and Order processing within defined SLA.
• Maintaining the monthly Sales data .
• Regular coordination with the Suppliers as per market studies.
• Selection of vendors with respect to price and inventory
• Communicating with the Vendors to add a new category a product as per the Customer’s Demand
• Maintaining a tracker to track an order’s flow
• Involved in the designing of the e-Commerce Market Place
• Worked very closely with developers with requirements of the marketplace and the Online Site
• Tested build by build to make the application bug free
• Analyze, document, prioritize requirements and analyze the needed scope for the requirement and its financial impact

• Complete End to End Ecommerce operation
• Managing returns and their disputes completely, as we are sellers/vendors for marketplaces
• Doing analysis of fraud orders before confirming the same
• Handling all major communication with marketplaces (Amazon, Flipkart, Paytm etc.)
• New Product setup planning
• Making sure orders are getting processed within the SLA and tracking them till time payment gets received
• Dispute is happening and escalating the same with respective marketplace
• Familiar with tools like Flipkart Seller Hub, Amazon Seller Central, Amazon Dropship, Amazon Flex, Paytm Seller portal etc
• Involved in the entire major decision making with respect to business for our company
• Interaction with clients, vendor to understand their business needs and requirements
• Requirement gathering from clients/Distributors/buyers/vendors
• Leading the team of product listing and pricing