Sunil Kumar

• Core backend developer for Tata Steel’s Digeca Application, an internal digital solution used by business units and distributors.
• Actively collaborated with Tata Steel’s business teams and external distributors to understand their real-time challenges and feature requests.
• Translated business requirements into scalable backend logic and REST APIs using Spring Boot.
• Created modules for user onboarding, role-based access, audit logs, and analytics dashboards.
• Designed and deployed services using MongoDB (for audit data) and PostgreSQL (for transactional operations).
• Built custom workflows and data visualizations with minor frontend work using Bootstrap, and ReactJs.
• Deployed solutions on Google Cloud Platform with automated Jenkins pipelines.
• Integrated OpenAI ChatGPT APIs for automating support ticket suggestions and document summaries.

• Implement Level 1 automation at our all-processing lines through PLC tag address mapping and Kepware configuration so that we can monitor and capture real time processed data in our servers using opc communication.
• Worked extensively with PostgreSQL and MySQL for PIMS Application modules like order tracking, user management, and inventory.
• Designed normalized database schemas and implemented stored procedures to handle complex business rules.
• Wrote and optimized SQL queries and joins for high-performance data retrieval in reports and dashboards.
• Developed data migration scripts during module upgrades and schema changes.
• Implemented data integrity rules using triggers and constraints in PostgreSQL.
  
  
  

Implement and configure VPN (virtual private network) in our office systems for ease of doing work outside the office.
Work closely with leadership team to improve wired and wireless network resulting in a uptime of 99.99%.
Implement a local area network for PIMS (Plant Information Management
System) project in our plant with the help of seniors Using Cisco switches,
firewall and Gateway servers.
Implement and Configure DHCP in all office systems and time to time
monitor DHCP server for new changes and authorization for new users.

Monitor and maintain the LAN or WAN infrastructure in the office. Ability
to troubleshoot TCP / IP networking issues.
Install applications on client environment, troubleshoot the issues,
taking backups of the data and make necessary upgrades to the
system
Responsible for VOIP (Voice Over Internet Protocol) Video Conferencing and
Audio Conferencing in our office and branches. Timely plan and schedule all
calls on VC Helpdesk.
Configure end-user software, hardware and upgrade existing client