Jadavpur University

• Jan 2023 - Present

Metallurgical Data Analyst Intern

• Jun 2022 - Aug 2022

-> Successfully completed a Live Project on ”Study of Manufacturing Process of Wagon Tippler,” utilizing R, Microsoft Power BI and Tableau to analyse data and optimize process efficiency and resource utilization. Implemented process improvements that resulted in a 15% reduction in material waste and saved 10 man-hours per day. -> Improved operational efficiency by 10% through the maintenance and quality assurance of computers, equipment and products. Implemented data tracking measures that reduced equipment downtime by 12%. -> Demonstrated effective communication skills through daily write-ups, reports, and presentations on industrial procedures, regulations, chemistry, geology, and market indices, facilitating better understanding and decision-making. Presented findings to a diverse audience of 30+ stakeholders. Show less

Metallurgical Data Analyst Intern

• Jun 2022 - Aug 2022

->Submitted a project on ”Liquid Level Measurement System” at Tata Steel, receiving recognition for its innovative approach to data analysis. The system implementation led to a 20% reduction in liquid overflow incidents. ->Explored and implemented methods to generate various graphs and images of processes, aiding data-driven decision-making within the organization. Introduced automated data reporting, reducing report generation time by 40%. ->Collaborated with cross-functional teams to gain insights into company products, blast furnace reactions, processes, components, shortcoming, and solutions. Contributed to a team effort that increased product quality, resulting in a 10% reduction in customer complaints. ->Conducted a human subject study to determine the most efficient industrial techniques, resulting in a 15% reduction in production time and a 10% decrease in production costs. ->Delivered multiple on-site and virtual presentations, effectively communicating complex technical concepts and data-driven findings to 100+ stakeholders across different departments. Show less

Web Development and Data Analyst Intern

• Nov 2021 - Jan 2022

> Developed a REST API using FastAPI and PostgreSQL to store data from learning management systems, optimizing data retrieval time by 30%. Successfully handled over 50,000 API requests during project. > Led development of a full-stack web application using Flask, React, Node.js, PostgreSQL, and Docker to analyze GitHub data and create comprehensive Car-Website insights, resulting in 25% increase in user engagement and over 10,000 monthly active users. > Explored innovative ways to visualize GitHub collaboration in a professional setting, enabling the team to identify bottlenecks and improve development processes. Developed and presented weekly progress reports on key performance indicators, resulting in a 20% reduction in bug-fixing time. > Conducted data cleaning using SQL, enhancing data accuracy by 20% and reducing data anomalies by 15%, leading to more reliable analysis outcomes. > Utilized R, Microsoft Power BI and Tableau to create visually compelling data visualizations, enabling better decision-making within the organization. The interactive dashboards produced were accessed by 50+ stakeholders regularly. > Used Google Analytics and Firebase for perusing and storing user references and relevant data. Show less