Viraj Joshi

Dynamic and result-driven MIS professional with over 10 years of experience in managing and optimizing MIS operations across various industries, including manufacturing, financial services, e-commerce, and logistics. Proven expertise in handling large-scale data projects, creating interactive dashboards, and generating comprehensive reports to drive business performance. Demonstrated success in managing Pan India teams, including MIS operations, telecalling, and sourcing.

Adept at delivering real-time insights through advanced data visualization tools like MS Excel, Google Sheets, and Power BI. Known for exceptional quantitative aptitude, analytical skills, and the ability to collaborate effectively with cross-functional teams to achieve organizational goals.

Professional Experience

Assistant Manager - Zenplus Fleet Management Pvt. Ltd (Fleet)

Dec 2023 - Present

 Managed the Pan-India MIS operations team, tele-calling, and sourcing teams.

 Prepared and automated driver settlements across all regions by coordinating with the city operations team and publishing updates to drivers on a weekly basis.

 Calculated vendor and referral payouts weekly and employee incentives on a monthly basis using Uber data.

 Created interactive dashboards to monitor and track key performance indicators (KPIs) in real time.

 Collaborated with all departments to prepare and share weekly, monthly, and quarterly reports for CXOs,

including VBI, GWU, milestones, organic earnings, waivers, etc.

 Extracted daily data from the Uber supplier portal for database updates and MIS preparation.

 Analyzed MIS reports for city performance, vehicle inventory, partner registration, driver performance, and call center team performance, providing meaningful insights to management regularly.

 Handled the Route mobile portal for WhatsApp marketing and the Legality portal for driver agreement creation,

maintaining e-signatures and stamp papers as required.

Manager Automotive Alliances - Reliance General Insurance Co. Ltd (BFSI)

Jan 2023 - Oct 2023

 Budgeting and Portfolio Management for the OEM Automotive Alliances team.

 Conducted Business Reviews and Presentations with internal stakeholders and the President of the OEM team.

 Shared daily, weekly, and monthly business reports with the sales team as per requirements.

 Understood processes and requirements to generate standard Excel sheets for the operations team.

 Responsible for tracking and publishing the market share of RGI for all transactions.

 Worked on SAP for premium registration, COR (Combined Ratio), COA (Cost of Acquisition), and DPR (Dealer

Performance Ratio).

 Prepared and maintained dashboards for B2B and HRIS data on a daily basis.

 Automated the OEM Universe report for all Pan-India data received from OEM SPOCs.

 Managed Reliance Master (Motor Vertical) for dealers, salespersons, and branches (MOM).

 Verified & uploaded from Manthan (policy data portal) & QlikView (operations portal) for the Decode Report.

 Supported the sales team regularly while creating standards and procedures to achieve deal closures and service efficiency.

 Processed OEM commissions and resolved issues such as payout discrepancies and policy issuance, coordinating with the NTU team for mapping.

 Prepared KPI reports on a quarterly basis. Engaged in recruiting and onboarding agents to expand and manage the sales team, focusing on attracting new leads and clients.

 Conducted monthly reviews with higher management to monitor the performance of the OEM team.

Senior Executive (MIS) - Lumina Datamatics LTD (E-commerce)

Jun 2021 - Dec 2022

 Developed and maintained centralized project trackers for item setup and maintenance.

 Created dynamic dashboards in Tableau/Power BI to visualize and analyze key performance metrics.

 Conducted data extraction and cleansing from JIRA and Polaris to ensure accuracy and integrity.

 Prepared comprehensive reports and PowerPoint presentations for project reviews and team performance evaluations.

 Analyzed monthly YOY trends and presented findings to management for informed decision-making.

 Monitored SLA compliance and identified bottlenecks in ticket resolution processes.

 Utilized advanced Excel functions to maintain and update key trackers for project metrics.

 Implemented data integrity checks to reconcile discrepancies across platforms.

 Collaborated with team leads on Not Good to Go (NGF) tickets to clarify issues and streamline processes.

 Generated actionable insights from attendance data to improve team productivity and time tracking

MIS & Sales Coordinator - HP Adhesives Pvt. Ltd (Manufacturing)

Mar 2017 - May 2021

 Handled Tally-related work, including master creation, ledger/voucher/SKU maintenance.

 Maintained sales, purchase, and stock registers.

 Monitored CRM software for sales tracking and productivity.

 Managed outstanding data based on bill aging reports.

 Conducted competitor price list comparisons and sales team target workings.

 Managed depot inventory and forecasted production planning.

Billing Executive - Patel Integrated Logistic Ltd. (Logistic)

Feb 2016 - Feb 2017

 Handled complete billing for PAN India.

 Prepared bills according to SOP or client requirements.

 Followed up for PODs and updated the ERP system (PTMS).

 Coordinated with zones for collection and reconciled client outstanding.

Education

 Master of Commerce, Mumbai University, 2022

 Bachelor of commerce, Mumbai University, 2017

 Higher Secondary School Certificate Maharashtra State Board, 2012

 Secondary School Certificate Maharashtra State Board, 2009

Certification Course

 Master in data Science (ML / AI) Pursuing