Debasmit Guchhait
Howrah
Summary
Accomplished Production Support Analyst with nearly 10 years of experience in managing multiple business Critical Applications for the Citi Bank Client for TCS from offshore and onshore.
Expert in leading production support teams across 24*7 to effectively monitor and tracking activities and maintain the bank’s critical technology infrastructure and analyzing issues, supporting the resolution of more complex technical issues, while minimizing disruption to operations.
Technical Expertise in Ab-Initio (ETL), Unix, Shell Scripting, Schedulers - Autosys, Control-M, Database concepts, Oracle SQL, PL/SQL, Monitoring tool like AppDynamics, Incident Management, Change Management, Problem Management, Working Knowledge of Big Data (Hadoop, HDFS Basic Level)
Overview
9
9
years of professional experience
1
1
Certification
Work History
Senior Production Engineer
Tata Consultancy Services Ltd
08.2016 - Current
- Facilitated collaboration among 20 offshore team members to enhance operational efficiency and optimize production processes.
- Led onshore production support from TCS at Budapest Citi Bank office for 5 years, ensuring seamless functionality of Regulatory Reporting Applications.
- Monitored and managed AutoSys and Control-M batch operations to support efficient start-of-day, intra-day, end-of-day, and end-of-period processes as outlined in the service operations runbook.
- Diagnosed and resolved production batch issues in Java, Spark and Ab Initio environments by meticulously reviewing Spark, Autosys, Control-M logs and error messages.
- Analyzed the system logs of repetitive issues and reduction of reoccurrences by YoY 15% by permanent fix.
- Achieved a 99% on time resolution rate for all priority incidents through effective management of SLA and KPI. Enhanced service management processes, including incident, change, and problem management, to optimize operational efficiency.
- Achieved timely report generation through proficient SQL and PL/SQL query writing for troubleshooting. Enhanced data retrieval processes, resulting in improved reporting accuracy. Drove initiatives to resolve data issues, contributing to overall project success.
- Implemented automation solutions using Unix and Python shell scripting, reducing manual task workload by 12%.
- Oversaw planning and implementation of 12 annual disaster recovery tests, enhancing application reliability and preparedness.
- Led project transitions by developing resource plans and coordinating handover activities from existing vendors. Oversaw KPI management and engaged stakeholders to align project objectives.
Education
Bachelor of Technology - Computer Science And Engineering
West Bengal University of Technology
Kolkata, India07-2016
Skills
- Strong experience in Application Production Support
- Strong incident management skills with experience to handle critical situation
- Ab-Initio (ETL),
- Unix, Shell Script
- Oracle SQL, PL/SQL
- Core Java, Tomcat, Apache
- Autosys, Control-M
- ITIL, SLA & KPI Management
- Service Management
- AppDynamics, ServiceNow, JIRA, Confluence
- Strong Analytical Ability to debug performance issue
- Expert in disaster recovery
- Excellent problem-solving skill
- Stakeholder Management
Certification
ServiceNow IT Leadership Certificate through LinkedIn Learning
TCS Certification on Ab-Initio Foundation
TCS Certification on AWS Foundation Course
TCS Certification on ITIL Foundation
Timeline
Senior Production Engineer
Tata Consultancy Services Ltd
08.2016 - Current
Bachelor of Technology - Computer Science And Engineering
West Bengal University of Technology