• Developed a data visualization dashboard using Power BI and Streamlit to analyze 85,000+ lines and 165+ columns of street lighting data, enhancing decision-making for smart city infrastructure.• Helped the team identify the perfect solution for their specific use case, tailoring tools and approaches to their needs.• Linked Power BI with data extracted from the database in Excel format and used Streamlit to visualize real-time data from an SQL database, enhancing decision-making capabilities.• Executed data manipulation and processing efficiently using Python and Pandas for ETL processes, along with data visualization with Plotly.• Authored a detailed report on deploying the Streamlit app on a server, ensuring scalability and usability for long-term operations.• Led a training session on data analytics using Power BI and Streamlit, helping the team optimize street lighting audits by deepening data insights for cities.

• Developed a REST API using Java and Spring Boot to manage internship processes, including database integration and request handling.• Managed SQL databases using MySQL Workbench, ensuring efficient data storage and retrieval, and used Postman to test API endpoints for reliability.• Implemented key features for internship management, including data persistence and security, using technologies like Spring Data JPA, Spring Security, JWT, and Project Lombok.• Used Power AMC for UML-based modeling and IntelliJ IDEA for code development, while tracking progress and collaborating through GitHub.• Led software development projects independently, utilizing Scrum methodology for sprint planning, task management, and project coordination.