Shramit N. Email & Phone Number

Bengaluru, Karnataka, India

• Developed and maintained Power BI Surgical Dashboard to monitor sales and track performance of over 80 reps, integrating real-time data from Salesforce, to streamline decision-making for leadership teams. • Designed and managed Tableau dashboards tracking patient study KPIs across 70 countries, providingleadership with actionable insights and optimizing global reporting. (connected to Databricks on AWS) • Leveraged VBA and Power Query skills to develop a dynamic Excel dashboard with real-time trend analysisand manual override features, which enhanced sales forecast accuracy to help set realistic future targets. • Designed and developed advanced Excel dashboards, including an incentive calculation tool, email/lettergenerator for medical reps, and multi-channel cycle plan calculator using VBA, improving process efficiency. • Automated forecast calculations for 32 countries by building a dynamic consolidator in VBA, reducing manual effort and increasing accuracy. • Collaborated with leadership teams and directors to define KPIs and dashboard requirements forpharmaceutical clients, including Galderma, Takeda, and Santen, driving key strategic initiatives

India

• Define project scope (SOW) - involving all relevant stakeholders while ensuring technical feasibility. • Manipulating, Cleaning & Processing (ETL) raw data of market research using Excel and PG-SQL, preparinginitial feasibility reports, budget analysis, machinery & CAPEX details. • Created dashboards using advanced Excel functionalities to track project performance, assess weekly salesreports, identified business standing and reported to executives on monthly basis.

Bengaluru, Karnataka, India

Analysed weekly and monthly trends of Liquid Nitrogen consumption to forecast business needs, reducingwastage and transportation frequency by 30%. • Automated BOM management using VBA, created userforms for Data entry. • Created procurement dashboards to maintain inventory and forecast timely purchase. • Introduced tolerance analysis to support success in high-volume LPG grommets surface finishing line up.

Bengaluru Area, India

Product development from inception to final prototype of cryogenic deflashing machine. • Project was successfully funded with INR 22 Lakhs by the Department of MSME, Government of India. • Contributed to the project to estimate performance of Multi-Layer-Insulation. Work was appreciated by senior engineers of ISRO (Indian Space Research Organization) with a token of INR 15000.

Bengaluru Area, India

• Directed production line of Honda Dream Yuga two wheeler under supervision of senior engineers, plan and organize human resource to achieve maximum daily outputs.• Involved in programming robotic welding arms to improve timing and CO2 weld precision and achieve maximum quality.

Master’S Degree, Thermal Sciences & Energy Systems

Bachelor Of Engineering - Be, Mechanical Engineering