Amit Kumar Hazra

Results-driven PL/SQL Developer with 3.3+ years of experience in Oracle SQL, PL/SQL development, and L2 Production Support within the Insurance domain. Proven track record of resolving 400+ production incidents, optimizing complex queries, managing month-end batch processes, and performing Root Cause Analysis (RCA). Expert in insurance accounting, data reconciliation, and automation, consistently delivering high-quality business solutions with 98+ SLA compliance.

System Engineer - Tata Consultancy Services (TCS)

(2023-01)

• Provide L2 Production Support for Oracle 19c-based Insurance applications covering Motor, Fire, Health, and other insurance products.
• Successfully resolved 400+ production incidents and service requests while maintaining strict SLA compliance.
• Develop and maintain PL/SQL Packages, Procedures, Functions, and Triggers for enterprise insurance applications.
• Manage month-end batch processing, job scheduling, monitoring, validation, and issue resolution activities.
• Conduct Root Cause Analysis (RCA) for production failures and collaborate with DBA, Infrastructure, and Development teams to implement permanent solutions.
• Perform exception analysis, transaction correction, reconciliation, and data validation activities ensuring data integrity and regulatory compliance.
• Execute bulk data loading activities using SQL*Loader and perform large-scale data correction initiatives.
• Handle insurance accounting processes including premium accounting, policy accounting, financial transactions, and reconciliation.
• Develop reusable PL/SQL utilities and automation solutions, reducing manual effort by approximately 40%.
• Optimize complex SQL queries using Explain Plan, indexing strategies, and performance tuning techniques.
• Support Oracle Database 19c production environments ensuring high availability and business continuity.
• Collaborate with business users, QA teams, DBAs, and developers using Agile methodologies and JIRA workflows.
• Support UAT activities, production deployments, release validation, and post-release monitoring.

Bachelor of Technology (B.Tech) - Electronics & Communication Engineering - Asansol Engineering College, MAKAUT (2022)

Diploma in Electronics & Telecommunication Engineering (ETCE) - Electronics & Telecommunication Engineering - Bengal Institute of Technology (2019)

Higher Secondary - WBCHSE (2016)

Madhyamik - WBBSE (2014)