Komal Thutte

Project 3: Metrolinx (Canada Government Project)
Role: Application Development Analyst
Tools and Technologies: SQL Server Management Studio, SNOW

Responsibilities:

• Incident Management & Resolution: Led the prompt resolution of high-priority incidents, minimizing downtime and ensuring continuity of business operations by quickly identifying and addressing root causes.
• Process Improvement & Automation: Spearheaded the development of an automation tool using VBA to send incident resolution emails, reducing manual intervention by X% and improving response times.
• SQL Query Optimization: Designed and optimized SQL queries, improving report generation time and ensuring reliable and efficient data retrieval from SQL Server databases.
• Collaboration & Cross-Functional Support: Worked closely with database administrators and developers to troubleshoot and resolve technical issues, reducing incident resolution time and enhancing team productivity.
• Knowledge Sharing & Training: Delivered Knowledge Transfer (KT) sessions to the team, providing guidance on best practices and ensuring seamless knowledge sharing to support the support function.
• Data Integrity & Quality Assurance: Ensured accurate and consistent data by performing regular database health checks, optimizing queries, and maintaining data integrity for improved decision-making.
• Customer Satisfaction & Stakeholder Communication: Maintained transparent communication with stakeholders during incident resolution, providing regular updates and ensuring issues were resolved within SLA guidelines.
• Reporting & Documentation: Developed post-incident reports and documented root cause analysis, corrective actions, and prevention strategies, contributing to continuous improvement in incident handling.
• Service Level Agreement (SLA) Management: Ensured incident response and resolution times adhered to established SLAs, enhancing service quality and building client trust.

Project 1: CARGO DEPS (Damage Excess, Pilferage, Shortage)
Role: Full Stack Web Developer
Tools and Technologies: Postman, Jira, Visual Studio, Swagger, PostgreSQL

Responsibilities:

• Developed robust APIs to manage and track shortages, excesses, and damages in MPS shipments, marking the AWB (Air Waybill) status and storing the data efficiently in PostgreSQL.
• Implemented an automated notification system to alert the hub manager when issues such as shortages or excesses are detected, ensuring real-time updates and faster resolution.
• Enabled smooth role-based access control, assigning responsibilities to specific users based on the marked status of shipments (shortage or excess), streamlining the issue resolution process.
• Designed and developed a ticket management system that helps the security team investigate damage and pilferage claims by raising tickets for MPS, ensuring accountability and timely responses.
• Integrated Swagger for API documentation, making it easier for developers to understand and interact with the API, thereby improving collaboration across teams.
• Ensured smooth data flow and integrity between systems by creating efficient database schemas and optimizing SQL queries for better performance.

Project 2: CLT CRM (Customer Relationship Management)
Role: Full Stack Web Developer
Tools and Technologies: Postman, Bitbucket, PostgreSQL, Visual Studio, S3 Bucket

Responsibilities:

• Developed the Nodemailer API to retrieve unread emails, assign them to relevant roles, and create actionable tickets based on the content, improving team workflow and response times.
• Integrated Redis caching mechanism to significantly boost data retrieval performance, enhancing user experience and reducing load times.
• Utilized Amazon S3 for efficient and secure storage of email attachments and images related to raised tickets, ensuring easy access and scalability.
• Designed and implemented a user-friendly frontend using Vue.js, enhancing the customer experience with an intuitive, responsive interface.
• Collaborated with cross-functional teams, including backend developers and security experts, to ensure seamless integration between APIs, front-end design, and database systems.
• Contributed to the codebase through regular commits in Bitbucket, adhering to best practices in version control and continuous integration.
• Optimized database queries and API responses, improving system performance and reducing server load by implementing best practices for PostgreSQL.