Excel
SUJIT MAHADIK
Data Analytics - (Manager)
Mumbai
Summary
- A capable professional enthusiast with a well proven record who want to deliver best and grow professionally and personally by pursuing assignments in environments where learning never stops.
- Over 15 years of experience in data analysis and supply chain management.
- Expertise in transforming complex data into actionable insights for strategic planning.
- Proven track record in optimizing supply chain processes and improving business performance.
- Strong collaborator with a knack for building and maintaining cross-functional relationships.
- Effective communicator with a history of training and developing subordinates.
- Skilled in balancing revenue and cost models to enhance supply chain efficiency.
- Experienced in developing KPIs to drive performance improvements and cost reductions.
- Adept at optimizing inventory management and reducing supply chain spend through strategic procurement.
Overview
16
16
years of professional experience
1
1
Language
Work History
Data Analyst - (Deputy Manager)
Team Global Pvt Ltd
- Tracked weekly sales data to ensure departmental goals were met, utilizing analytical tools to measure performance
- Produced comprehensive reports and presentations using Velocity ERP and developed visualizations in Power BI
- Developed 85% custom Microsoft Power BI dashboards and visualizations to support data-driven decision-making
- Focused on aiding clients in making informed decisions by leveraging Power BI as the primary reporting tool
- Supported the continued scoping and development of Data Analytics projects, enhancing analytical capabilities
- Built internal data analytics capabilities, creating dashboards and visualization tools with Power BI
- Collaborated with team members to collect and analyze data, ensuring data accuracy and relevance
- Prepared critical decision-making reports, providing actionable insights for various stakeholders
- Planned and executed new strategies to boost sales, tracking salesperson performance weekly and monthly using volume and revenue statistics
- Prepared segment, city, and region-wise budgets and forecasts, performing revenue and cost budget vs
- Actual analysis
- Conducted product and profitability analysis on a regional and individual marketing person basis
- Delivered timely and accurate financial reporting and analysis to support business decisions
- Identified, developed, deployed, and managed business intelligence solutions to enhance organizational efficiency
- Utilized ETL processes for data cleaning and formatting, and employed DAX functions like SUM, SUMX, IF, nested IF, CALCULATE, TEXT, TIME DAX, ROUND, CONCATENATE, NUMBER & COUNTS for advanced data manipulation
- Supported BI – Qlik Sense integration, automating multiple reports to eliminate duplication of work
- Independently developed and integrated Power BI for the invoice process using charts and graphical representations
- Monitored Unbilled and DSO (Days Sales Outstanding) metrics, motivating team members to maintain standards
- Improved POD (Proof of Delivery) flow by conducting follow-ups with the operations team
- Created workspaces in Power BI services and published dashboards in specific workspaces
- Sent trading and non-trading customer outstanding details to credit control for due payments
- Managed Unsubmitted Invoice Aging, Unsubmitted Outstanding Aging, Unsubmitted Docket at Destination Pending for Delivery, Unsubmitted Docket In Transit, Unsubmitted PFM Done & POD Received, and Unsubmitted PFM Done but Not Received
- Reconciled data with ERP and followed up with the ERP team to ensure data accuracy
- Provided user-wise details of Docket Delivered but PFM not generated to the billing department
- Prepared TGI PPT weekly review reports for presentation to the TGXL Director and the Team Global MD.
Operations Data Analytics - Supply Chain (Manager)
Boston Ivy Healthcare Solutions (Medikabazaar)
6 2023 - Current
- Led a 60-person supply chain team, spearheading change management projects to enhance operational processes
- Defined workflows and cultivated a collaborative work culture, empowering team members and driving operational excellence
- Developed and monitored key performance indicators (KPIs) to track supply chain performance
- Implemented strategies that enhanced procurement and sourcing operations, reducing the annual supply chain spend by 25%
- Analyzed supplier performance data for a $4M supply chain, utilizing data analytics to inform sourcing decisions
- Conducted demand forecasting to predict future needs and align sourcing strategies, improving supply chain responsiveness
- Collaborated with finance, sales, procurement, and logistics teams to execute process improvement initiatives
- Achieved a 20% improvement in lead time and a $250k reduction in materials cost through cross-functional collaboration
- Ensured material fulfillment met customer service-level agreements by coordinating with operations and logistics teams
- Developed and maintained communication channels to proactively address material fulfillment challenges
- Conducted complex data analysis on inventory management and ERP systems to reduce waste and improve material handling
- Identified areas for improvement in inventory practices, leading to more efficient operations and reduced waste
- Prepared monthly PowerPoint presentations on fulfillment and logistics performance, providing insights and recommendations to senior management
- Compiled detailed reports to track progress and highlight key performance trends
- Monitored and analyzed current stock levels across multiple locations, ensuring optimal inventory management
- Identified and reported expired and near-expiry stock to relevant branches, minimizing waste and optimizing stock rotation
- Tracked GRNs at various locations, ensuring accurate records of receipt dates and usage durations
- Analyzed GRN data to identify patterns and inform procurement strategies
- Conducted comprehensive analysis to differentiate between moving and non-moving materials, optimizing stock levels and reducing excess inventory
- Generated reports on order frequency and patterns to support strategic decision-making in procurement and inventory management.
Data Analyst (Assistant Manager)
Scorpion Express Pvt Ltd
11.2018 - 07.2022
- Analyzed overall company transactions by region, year, month, and quarter to identify trends and insights
- Created complex data models using Power Query and Data flows, performed data ingestion from various corporate sources, and implemented transformations and calculations using DAX code
- Developed dashboards to visualize data and supported decision-making across various teams and branches
- Conducted audits and reconciliations of contracts, ensuring correct levied rates and charges, and analyzed variance in rates
- Reported monthly to the CFO on revenue leakage and analyzed regional contract performance versus revenue yield
- Sent direct sales outstanding reports to pan India teams, monitored unbilled and DSO, and ensured timely POD flow through OPS team follow-ups
- Led rate mapping and validation with OPS costs, and managed warehousing invoicing
- Controlled POD Cell department to ensure timely receipt of PODs
- Managed billing branches across India and sent detailed reports on outstanding invoices and unsubmitted dockets
- Sent daily sales target achievements to the head of sales, analyzing branch-wise performance, customer contributions, and profit/loss
- Analyzed sales trends, revenue by region/zone, product yield, and charge weight ratios
- Conducted monthly sales closing activities and created customer sales profitability dashboards in Power BI
- Generated reports on consignment statuses and operations-related performance
- Managed key clients, analyzed service levels, and worked with the operations head to improve client services
- Solved complex customer problems and conducted monthly customer visits to understand requirements
- Focused on resolving late delivery cases and handling insurance claims
- Led a team of customer service staff, improving client interactions and service delivery
- Managed key clients including INDCHEMIE HEALTH SPECIALITIES PVT LTD, CACHET PHARMACEUTICALS PRIVATE LIMITED, and GALPHA LAB LTD, ensuring high client satisfaction and service quality.
Deputy Manager – Operation & Agency MIS
Future Generali India Life Insurance Co. Ltd.
06.2013 - 11.2016
- Led a team of 4 executives and 5 off role staff to manage end to end activities related to pre and post advisor licensing for PAN India
- Conducted data quality analysis and reconciliation of the system, ensuring high accuracy and integrity
- Educated branches on standards for error reduction and implemented a proper First Time Right (FTR) check system
- Improved the MIS tracker and assisted in automating the MIS processes to meet organizational requirements
- Generated and shared daily reports and updates with top management, brokers, corporate agents, and referral partners
- Prepared presentation slides for CEO reviews, ensuring clear and concise communication of key insights and performance metrics
- Coordinated with outsourced staff and performed cross verification and reconciliation of data with the system.
Sr Executive – Agency Channel
Future Generali India Life Insurance Co. Ltd.
06.2010 - 06.2013
- Led a team of 4 executives and 5 off role staff to manage end to end activities related to pre and post advisor licensing for PAN India
- Conducted data quality analysis and reconciliation of the system, ensuring high accuracy and integrity
- Educated branches on standards for error reduction and implemented a proper First Time Right (FTR) check system
- Improved the MIS tracker and assisted in automating the MIS processes to meet organizational requirements
- Generated and shared daily reports and updates with top management, brokers, corporate agents, and referral partners
- Prepared presentation slides for CEO reviews, ensuring clear and concise communication of key insights and performance metrics
- Coordinated with outsourced staff and performed cross verification and reconciliation of data with the system.
Executive – Operation
Future Generali India Life Insurance Co. Ltd.
05.2008 - 06.2010
- Led a team of 4 executives and 5 off role staff to manage end to end activities related to pre and post advisor licensing for PAN India
- Conducted data quality analysis and reconciliation of the system, ensuring high accuracy and integrity
- Educated branches on standards for error reduction and implemented a proper First Time Right (FTR) check system
- Improved the MIS tracker and assisted in automating the MIS processes to meet organizational requirements
- Generated and shared daily reports and updates with top management, brokers, corporate agents, and referral partners
- Prepared presentation slides for CEO reviews, ensuring clear and concise communication of key insights and performance metrics
- Coordinated with outsourced staff and performed cross verification and reconciliation of data with the system.
Junior Marketing Support Executive
Birla SunLife Insurance Co. Ltd.
12.2007 - 04.2008
- Verified advisor documents received from branches for recruitment, ensuring compliance with company standards
- Acted as the single point of contact for all branches regarding the licensing and coding of advisors
- Managed the coding of Agency Managers and handled the deposition and refunding of advisor demand drafts
- Prepared renewal, nonrenewal, and resignation letters for advisors, and facilitated the MPP test for Agency Managers
- Developed and managed advisor and Agency Manager agreements.
Education
S.S.C. Examination -
H.S.C. Examination - undefined
Mumbai University
Bachelor of Commerce - undefined
Mumbai University
Skills
- Data Analysis and Reporting
- Inventory Management
- Supply Chain Optimization
- Power BI DAX and Excel for Data Visualization and Data Analysis
- Communication and Stakeholder Management
- ERP: CMS, Web Express, Velocity
- Office Package: Microsoft Word, Excel, Access, PowerPoint, Outlook Express
- Advanced Excel: Macros, Pivot Tables, Charts, X Lookup, V Lookup, H Lookup, Index, Match, Nested IF, SUMIF, SUMPRODUCT, Conditional Formatting, Data Validation, Concatenate, COUNTIF, Slicer
- Power BI: ETL, append column, merge table, group by, pivot/unpivot, Query Editor Filter, Slicer Filter, Drill Through, Edit Interaction, Group, Bookmarks, Page Navigation, Conditional Formatting, Parameter, Relationship, create workspace, publishing reports in Power BI services
Personal Information
- Father's Name: Shyam Mahadik
- Date of Birth: 06/21/84
- Gender: Male
- Marital Status: Married
Software
Word
Power Point
Power BI
Timeline
Data Analyst (Assistant Manager)
Scorpion Express Pvt Ltd
11.2018 - 07.2022
Deputy Manager – Operation & Agency MIS
Future Generali India Life Insurance Co. Ltd.
06.2013 - 11.2016
Sr Executive – Agency Channel
Future Generali India Life Insurance Co. Ltd.
06.2010 - 06.2013
Executive – Operation
Future Generali India Life Insurance Co. Ltd.
05.2008 - 06.2010
Junior Marketing Support Executive
Birla SunLife Insurance Co. Ltd.
12.2007 - 04.2008
Data Analyst - (Deputy Manager)
Team Global Pvt Ltd
Operations Data Analytics - Supply Chain (Manager)
Boston Ivy Healthcare Solutions (Medikabazaar)
6 2023 - Current
S.S.C. Examination -
H.S.C. Examination - undefined
Mumbai University
Bachelor of Commerce - undefined
Mumbai University
Similar Profiles
JOEL B THANUVELILJOEL B THANUVELIL
LOGISTIC ASSISTANT at Team global logistics pvt LtdLOGISTIC ASSISTANT at Team global logistics pvt Ltd
Nicolas CaseyNicolas Casey
Delivery Driver, Shipping at Team Global ExpressDelivery Driver, Shipping at Team Global Express
Nina HemmatyNina Hemmaty
English-Farsi Enterpreter at Landmark Global Education Farsi TeamEnglish-Farsi Enterpreter at Landmark Global Education Farsi Team