Sumeet Patel

Software migration and security enhancements for IoT SCADA Systems. Data Processing and User Management Improvements with experience in Spring Boot (Java 11/17), Kafka, PostgreSQL, and Keycloak integration.

• Actively participated in the migration of a complete IoT SCADA system database from MongoDB to PostgreSQL, ensuring data integrity and optimized performance with GCP migration from Linode.
• Collaborated continuously with data architects to design and implement a robust data model for the SCADA application, leveraging modern streaming technologies such as RabbitMQ, Kafka, Redis, and MQTT to enhance real-time data processing capabilities.
• Successfully migrated critical system features, including the Alarm Management System, by architecting a robust and scalable solution for alarm handling. This involved strategic planning for the database migration from MongoDB to PostgreSQL, integrating an effective escalation system to ensure prompt responses and resolutions.
• Integrated Redis with the alarm features for ticket assignment using the shadow key concept and pub/sub mechanisms, enhancing real-time notification and management of alarm tickets.
• Utilized Java 11 and 17 during the development of alarm features in Spring Boot, ensuring the application benefits from the latest language enhancements and performance improvements.
• Efficiently processed approximately 5,000 alarm messages per minute using Spring Boot and Kafka, significantly enhancing system performance and responsiveness while minimizing PostgreSQL database calls through the implementation of effective caching mechanisms.
• Leveraged architectural best practices to optimize PostgreSQL, incorporating hardening concepts to enhance security and performance.
• Updated Spring Boot application to integrate with Kafka for real-time data streaming, optimizing the system to handle high volumes of incoming data while ensuring low latency. Implemented an automatic ticketing feature for alarm assignments, complete with an escalation matrix to improve incident response times and user accountability.
  
• Integrated Keycloak with Spring Boot, establishing a secure authentication and authorization framework that enhanced overall application security.
  
• Implemented Single Sign-On (SSO) capabilities, providing users with seamless access across multiple applications without the need for repeated logins.
  
• Designed and deployed Role-Based Access Control (RBAC) for both the application and Spring Boot REST APIs, effectively managing user permissions and ensuring that access levels align with organizational roles and responsibilities.
  
• Secured backend APIs by enforcing RBAC, allowing for granular access control, and enhancing the overall security posture of the application.
  
• Implemented page access control through Keycloak, ensuring that users can only access authorized pages based on their roles and permissions, thereby enhancing application security and user experience.
  
• Streamlined user management processes, allowing for dynamic role assignments and efficient access control, improving security protocols and user experience.

• Modify existing application code or interfaces, or build new application components from detailed requirements.
• Analysis of requirements, support of the design, development of the code, testing, debugging, deployment, and maintenance of those programs and interfaces.
• Participation in most aspects of programming and application development, including file design, update, storage, and retrieval.
• Maintaining the developed solution on an ongoing basis is essential.
• Formulating concepts, defining system scope, and technical objectives based on user needs.
• Enhance processes to resolve operational problems and add new functions, taking into consideration schedule, resource constraints, process complexity, dependencies, assumptions, and application structure.
• Ensured quality assurance of software components by writing unit test cases and performing manual testing.
• Monitored server logs to identify potential problems before they become major issues.
• Programmed applications and tools using object-oriented languages with goals of code abstraction, stability and reuse.

• Working as a Software Engineer to maintain and develop the IoT application ecosystem. Design, development, and implementation of complex, scalable, and extensible functionalities. To ensure architectural oversight and contribute to the continuous journey of tech-stack upgrade. Analyze performance issues, identify the cause, and resolution.
• Migration of legacy Node.js module to Rest API’s in Spring Boot(Java 1.8) using MongoDb as the database system.
• End-to-end deployment process of an application on local servers (Ubuntu/Windows) as a service.
• Proficient with Linux Command Line interface, with development and maintenance of Python and Bash Scripts.
• Familiar with the concepts of SSH and Reverse SSH tunneling.
• Maintained coding standard as per SonarLint regulations and integration with SonarQube.
• Familiar with IoT data collection protocol, including the use of Kepware, OPC-UA Client, and messaging protocol MQTT (Broker).

• Gained experience as a software intern. Opportunity to work with cross-functional teams to enhance and build the back-end architecture and to maintain the code base. To resolve bugs and any type of code breakage.
• Developed, tested, and maintained software applications in accordance with specified requirements.
• Utilized version control systems like Git to manage code changes and collaborate with team members.
• Assisted in the creation of technical documentation for software users and developers.