•Analyzed and monitored the progress of the database of Joint India -EU and India- UK Projects with Dept. of Biotechnology, Ministry of Science and Technology, under INTERNATIONAL COORDINATION wing.•Involved in dissecting financial and investment information to derive insights crucial to the stakeholders.•Ensured data integrity and built an innovative dashboard which helped in the quick validation of the milestones and informed decisions.•Leveraged statistical models to build KPIs on the dataset.

•Did qualitative analysis of the population willing to take the COVID-19 vaccine on the ICMR dataset.•Devised and implemented data segmentation models to enhance demographic profiling accuracy.•Spearheaded the development of a dynamic dashboard integrating real-time vaccination data, facilitating prompt decision-making for public health initiatives.•Employed advanced sentiment analysis techniques to uncover nuanced opinions and concerns, providing valuable insight to health authorities.

•Fostering a data-driven culture, and presenting actionable insights to the key stakeholders of the institute.•Streamlined HR reporting which reduced manual efforts and errors.