Vijay Kumar Email & Phone Number

Bengaluru, Karnataka, India

Handling a dual role for Order Management along with MIS. Order Management (Customer Service) 1. In my earlier role I have extended a global tool called tool commerce to India to avoid manual order entry. We have upgraded this order entry system to "Smart Order" with modern user experience with additional features like live stock status, credit available status, slab wise pricing, promotional banners, etc. 2. Back Order Management: order management was very crucial when it was handed over to me. Over time, I have automated most of the steps in order management, For Example: a. Automatic Stock allocation for open orders in SAP through scheduled jobs. b. Automated the process of Delivery Order & Pick List Creation in SAP through scheduled jobs. c. Automatically respective plant code determination, automatic material code switching when discontinued. d. Automatic Order Confirmation emails to customers. e. Automatic Invoice confirmation emails to customers. 3. Additionally, I have supported the warehouse team to eway bill generation in bulk using the macro sheet. 4. I have also implemented a process for order expiry policy to have a clean order book. 5. Set up SOP (Standard Operating Procedures) for the order management role as a key user based on which the present operations are executed.6. Stock replenishment for 3PL warehouse. MIS Role: Publish Daily/Monthly Business Insights to Leadership team, field sales managers and to enabling teams in HO. Also designed one click Score Card with smart growth analysis by customer, produced, etcImprovements: I have revolutionized the way the data is shared within internal and field sales team by providing intelligent business insights through Power BI. In earlier role, I used to use macro + rpa for reports automation. This time I implemented an advanced data management tool SQL Server to eliminate outdated macros & excel formulas, thus providing robust output for connecting with Power BI through RPA technology.

Bengaluru, Karnataka, India

Handling a dual role for Order Management along with MIS. Order Management (Customer Service) 1. Entering orders manually from details received in image, text and in excel format. I have streamlined the order entry process from manual order entry to a web based ordering portal called Tool Commerce. 2. Back Order Management: order management was very crucial when it was handed over to me. Over time, I have automated most of the steps in order management, For Example: a. Automatic Stock allocation for open orders in SAP through scheduled jobs. b. Automated the process of Delivery Order & Pick List Creation in SAP through scheduled jobs. c. Automatically respective plant code determination, automatic material code switching when discontinued. d. Automatic Order Confirmation emails to customers. e. Automatic Invoice confirmation emails to customers. 3. Additionally, I have supported the warehouse team to eway bill generation in bulk using the macro sheet. 4. I have also implemented a process for order expiry policy to have a clean order book. 5. Set up SOP (Standard Operating Procedures) for the order management role as a key user based on which the present operations are executed.6. Stock replenishment for 3PL warehouse. MIS Role: 1. Publish Daily/Monthly Business Insights to Leadership team, field sales managers and to enabling teams in HO by downloading the sales, open orders, under packing, etc by downloading data manually from SAP. Improvements: I have initially automated mis reports by implementing macros, but data fetching task from SAP was manual, overtime, I got a chance to learn RPA TECHNOLOGY and automated the data fetching task from SAP and thus the routine MIS is 100% automated. However, adhoc reports are still being done manually on need basis.

Bengaluru, Karnataka, India

1. Daily Business Insights to Leadership team. 2. Daily, Monthly Individual Sales dashboards for 70+ field sales managers. 3. Incentive Payout Calculations for dealers as per signed commercial policy on quarterly, yearly including the growth incentive, target achievement incentive, etc. 4. Incentive Payout calculations for sales managers every quarter based on the target vs achievement performance as per the standard payout metrics. 5. Get collection details from the sales team and publish consolidated collection reports. 6. Periodic C-form collection.

Bengaluru, Karnataka, India

1. Business Insights and daily sales & collection dashboards and various adhoc reports on need basis. 2. Retail Store management and facility management and administration activities. 3. Salary Payout for 100+ Tata Store employees. 4. Expenses & Petty Cash claim settlement for Store Managers. 5. Managing Lead Management System

Bengaluru, Karnataka, India

1. Ensuring Customer Satisfaction2. Providing Complete Information to Customers.3. Monitor Quality of Calls4. MIS Dashboard with call flow analysis like No. of calls landed vs dropped. Average talk time, Quality of services, etc.

Mba In Data Science & Data Analytics

Certification In Business Analysis

Certification In Information Technology

Bachelor Of Commerce - Bcom