Susmita Debnath

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.

Hire this person

About

Experience

Education

Skills

Reviews

Similar people near Coimbatore

Preethi Parameshwaran

Deva Prasath

Kavibharathi P

Lakshanaa Priya

Sabareswaran Kuppusamy

Sriram Kumar

Other similar people

Priyanka Yadav

Laeeq Khan

Akhil Soni

Aaryaman Raj

Srimathi S

Related