Gulshan Kumar

Experience

• 

  Polestar Solutions & Services

  Apr 2022 - now

  Senior Analyst

  - Developed comprehensive Business Requirement Documents (BRDs) and Technical Specifications, detailing project architecture and integration strategies.- Implemented robust SQL solutions including stored procedures, indexes, and optimized data models, enhancing data accuracy and seamless utilization by Power BI.- Created APIs for efficient data transfer, including sending data from SQL databases to Salesforce and retrieving encrypted deleted transaction data from NetSuite, significantly reducing manual data handling.- Reduced NetSuite clicks from 50,000 to 1,000 per day by optimizing models and creating dashboards for streamlined data visualization and analysis.- Orchestrated Azure pipelines for efficient data migration and ingestion from diverse REST APIs, and automated data processing using Azure Functions.- Achieved a 20% reduction in stock-outs and improved customer satisfaction by developing predictive models for accurate drug demand forecasting.- Conducted field force sizing analysis to determine the optimal number of medical representatives needed for effective market coverage, focusing on high-potential hospitals based on patient volume and specialty services. Show less