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