Susmita Debnath

Software Developer with 4+ years of experience at McWane India Private Limited, promoted from Graduate Engineer Trainee to Software Developer after driving a 40% efficiency improvement on the Smart Water Meter (AquaMesh Portal) monitoring system. Recognized with the Bright Debutant Award for strong early performance. Builds desktop applications and automation tools using Python, HTML/CSS/JavaScript, and MySQL, with hands-on experience in CSV/Excel automation, hardware communication protocols (Serial, CAN), and secure data management.

Software Developer at McWane India Private Limited (2024-02 – Present)

Project: Automated Report Generation System – CSV to Excel Automation (Desktop Application) Built a desktop application (Python backend with an HTML/JavaScript interface via the Eel framework) that converts CSV data into 10 predefined Excel report templates through an editable preview screen, with export to Excel or PDF.

• Designed the application flow, starting with a loading screen and moving to a main screen where users could browse for a CSV file and choose where to save it.
• Built 10 separate HTML preview pages, one per Excel template, each matching that template's specific fields and layout.
• Implemented logic to auto-fill each preview page with values parsed from the selected CSV file, while keeping designated fields open for manual entry.
• Developed the process to merge auto-filled CSV values with manually entered values and write the combined data into the corresponding Excel template using OpenPyXL.
• Added export functionality so users could save the completed report as an Excel file or a PDF.
• Automated report generation across 10 distinct Excel templates, cutting manual data entry and formatting time.
• Built a per-template preview and editing interface that let users verify and correct data before final export.
• Enabled flexible output by supporting both Excel and PDF export formats.

Software Developer at McWane India Private Limited (2024-02 – Present)

Project: Armor Utility Panel (Desktop Application) Built a panel-monitoring desktop application with an HTML/CSS/JavaScript front end designed to replicate the look and feel of a native Windows application (a client requirement), backed by a Python engine that communicated with the physical panel hardware over serial-based CAN communication for real-time monitoring and control.

• Designed and built the front end in HTML, CSS, and JavaScript, styling it to match a native Windows application per client requirements.
• Developed the Python backend to communicate with the panel hardware over serial communication using the CAN protocol.
• Implemented live monitoring of panel hardware status, including LED indicators, fire LED, trouble relay, and fire relay.
• Built an event log feature that pulled log data from the panel, displayed it in the application, and exported it to Excel for record-keeping.
• Built a firmware update feature that let users upload a firmware file and update the panel's firmware version directly from the application.
• Delivered real-time panel monitoring and control via serial-based CAN communication, connecting the application directly to panel hardware.
• Built an event-log export feature that gave users a persistent Excel record of panel activity.
• Delivered a firmware update capability that let users manage panel firmware versions directly from the application.

Graduate Engineer Trainee (GET) at McWane India Private Limited (2022-02 – 2024-02)

Project: Smart Water Meter – AquaMesh Portal (Web Application) Managed the backend MySQL database for the AquaMesh Portal, maintaining customer and meter records that fed real-time updates to the customer-facing web portal.

• Added and maintained customer and meter details in MySQL, ensuring accurate data flowed through to automatic updates on the web portal.
• Monitored the automated sync between the database and the web portal to catch mismatches between customer and meter records.
• Manually corrected data discrepancies when automated updates didn't match, maintaining the accuracy and reliability of information shown on the portal.
• Contributed to a 40% efficiency improvement in the Meter Monitoring System by reducing data errors and manual correction time.

B. Tech – Gulzar College of Engineering, Punjab (2016 – 2020)