Ashwani Kumar

Domain: Sales & Marketing (SCVPU Division)

Key Responsibilities:

• Managing Pan-India Sales and RCFI (Retail, Coverage, Finance & Insurance) data for Tata Motors SCVPU division.
• Preparing and automating Daily, Weekly, Monthly, Quarterly, Half-Yearly, and Annual business performance reports to support senior management decision-making.
• Developing interactive and visually impactful Power BI dashboards to monitor KPIs, sales trends, and operational performance across various regions.
• Providing actionable insights and data-driven recommendations to improve sales strategies, data accuracy, and overall business performance.
• Leveraging Advanced Excel (Power Query, Pivot Tables, VBA), MySQL, and Power BI for deep data analysis, data cleaning, and data transformation.
• Creating impactful presentations and business summaries using Microsoft PowerPoint for senior stakeholders and national heads.
• Collaborating with cross-functional teams to gather requirements, standardize reporting processes, and ensure high data integrity and quality.
• Supporting ad-hoc analytical requests, forecasting models, and variance analysis to assist in strategic planning and execution.

Domain: Smart Card (DLRC Project)

Key Responsibilities:

• Continually upheld and supported current Management Information Systems (MIS) for smooth operations.
• Created and updated MIS documentation to streamline system maintenance and improve operational efficiency.
• Conducted regular data analysis to generate accurate and up-to-date reports.
• Generated, revised, and distributed productivity reports using MIS dashboards.
• Created, maintained, and analyzed reports related to operations, quality, and client services.
• Collected, examined, and documented company performance data on a quarterly and half-yearly basis.
• Prepared MIS reports using advanced Excel functions like Index Match, VLOOKUP, HLOOKUP, XLOOKUP, and Pivot Tables.
• Managed data related to DL-RC smart cards (printed, printing pending, misprinted) for seven states.
• Coordinated with state leaders and managers to discuss project progress and updates.
• Oversaw DL-RC project operations across seven states: Jharkhand, Karnataka, Maharashtra, Gujarat, Rajasthan, Haryana, and West Bengal.
• Collaborated with clients and vendors to gather and organize project requirements.
• Maintained effective internal communication between Accounts, Purchase, and IT departments.

Domain: Sales & Operations

Key Responsibilities:

• Created and modified daily, weekly, monthly, and quarterly data reports as per standard procedures.
• Generated and distributed monthly client invoices in a timely and accurate manner.
• Prepared MIS reports focused on sales performance and operational efficiency.
• Monitored daily activities and performance of sales and operations teams to support management decisions.

Domain: Sales & Marketing

Key Responsibilities:

• Analyzed operational performance daily and AOD-wise; shared performance reports with managers for informed decision-making.
• Managed e-commerce department’s pickup, delivery performance, and inventory stock efficiently.
• Supervised operations to ensure timely departures and arrivals, enhancing overall customer service.
• Identified customer needs and developed systems to exceed service expectations.
• Independently handled integrated domestic and international road and air operations, MIS reporting, stock management, and branch-level finance and administration.
• Coordinated with internal teams and external agencies to ensure smooth operational workflows.
• Initiated improvements in warehousing processes and contributed to setting up retail business operations.
• Focused on customer retention and driving incremental business opportunities.
• Engaged in active customer interaction and follow-up to streamline end-to-end processes.

Domain: E-commerce

Key Responsibilities:

• Performed accurate data entry for returned goods, ensuring proper documentation and system updates.
• Sorted items product-wise to streamline inventory handling and processing.
• Coordinated the production of fresh batches and ensured timely transfer to inventory.
• Prepared and shared daily performance reports with the manager and team leader to track operational efficiency.