Shanmugam S

Python Full Stack Developer

• Developed and maintained full-stack web applications using Django and React.js, enhancing user experience and application reliability.
• Designed RESTful APIs for data exchange between client and server, improving performance by 20%.
• Optimized SQL queries and database schema, reducing query execution time by 30%.
• Supported deployment and troubleshooting in production environments, ensuring minimal downtime and swift issue resolution.
• Automated testing using PyTest, achieving 95% test coverage to ensure software quality and reliability.

ETL Workflow Monitoring (Informatica + Autosys)

• Investigated production job failures in ServiceNow S3 incidents, managing lifecycle from assignment to resolution to minimize downtime.
• Retrieved job details from Autosys, analysed failure messages in Informatica Workflow Monitor, and extracted session/loader logs using WinSCP.
• Re-ran sessions for known issues and worked with Teradata and Oracle DB teams to resolve unknown failures by sharing error details and database context.
• Coordinated with batch teams for job restarts and documented resolution steps with KB articles and tags in ServiceNow

Oversaw file transfers using Axway MFT application, ensuring timely delivery of data.

• Analysed job failures based on exit codes using Axway application.
• Investigated source and target file errors, collaborated with relevant teams identified through GitHub, and resubmitted inbound/outbound files based on failure diagnostics.
• Addressed user queries on file tracking and resubmissions by verifying delivery paths and confirming successful transmission to target systems.
• Verified missing files in Axway and coordinated with source teams to initiate resends, ensuring successful delivery to target systems.

Incident Management & Documentation

• Managed S3 incidents in ServiceNow, attaching logs, resolution details, and communication history.
• Developed and updated knowledge base articles to facilitate future troubleshooting and enhance team workflow.

• Handled client tickets daily, resolving queries and escalations within SLA of 1 to 5 days based on priority.
• Delivered reports to clients monthly, bi-weekly, or weekly per database requirements.
• Updated end users on ticket status, resolution timelines, and follow-ups.