Giriraj Yalpalwar

Sales Dashboard: Designed and developed a comprehensive sales dashboard to track daily, monthly, and yearly orders, sales, achievements, collections, outstanding balances, and returns. Key features include:

• Order monitoring and detailed sales reports
• Top seller tracking
• User and product management capabilities
• Admin functionalities for adding new users/products, order cancellation, product approval matrix, and managing user-registered hospitals
• Created server cron jobs to fetch data from client servers, with automated email notifications to clients when server connections fail.

ML Forecast : Built a sales forecasting system using the SARIMAX ML model, achieving precise trend prediction and outperforming Amazon Forecast.

Hospital Management System: Developed APIs within the HMS website to facilitate seamless data transfer between systems.

Event Hosting Site: Managed event hosting for New Year, optimized code, resolved bugs, and implemented new libraries.

Order Management System for Medical Representatives

Developed a comprehensive order management system for Medical Representatives (MR) handling hospital medicine orders. Key features include:

• Order Placement: MRs can select hospitals, add products to the cart, and place orders with automated quotation generation.
• Product Approval: Products are approved based on price by managers, with approval notifications sent via email.
• Sales Tracking: Detailed tracking of sales on a daily, monthly, and yearly basis, including order and hospital details.
• Historical Data: Access to previous product prices for informed decision-making.
• Hospital Registration: Functionality for MRs to register new hospitals.
• Currency Conversion: Supports international users with the ability to change currency.
• Order Quotations: Generated quotations are sent to users and product approval managers via email.