Headline

PL/SQL Developer | Oracle SQL | Senior Software Engineer | Insurance Domain | L2 Support Lead

About

I'm a PL/SQL Developer with 4+ years of hands-on experience in Oracle PL/SQL and SQL Server, specialising in backend database development, performance optimisation, and production support in the insurance domain. At Clover Infotech, I work on Bajaj Allianz General Insurance projects — building and maintaining complex stored procedures, packages, functions, and batch processing pipelines for Agri Policy Issuance, Claims, and Pet Dog Insurance modules under PMFBY. One of my key achievements was resolving a critical batch processing bottleneck where 1–2 lakh records needed to be processed daily within a 5-hour scheduler window. I refactored the PL/SQL procedure using BULK COLLECT and FORALL, split records into 3,000-record batches with independently scheduled jobs — eliminating the need for manual backend support entirely and ensuring all records processed before midnight. As L2 Support Lead for the AgriNxt product, I manage 60–70 production issues per month, perform root cause analysis, deliver permanent fixes, and coordinate NRCR calls for data corrections. I also handle server monitoring, deployments, SSL certificate management, and end-user feedback coordination. I'm now looking for Senior Software Engineer / Senior PL/SQL Developer opportunities where I can bring my database expertise, problem-solving skills, and leadership experience to a larger team. Skills: PL/SQL · Oracle (11g, working knowledge of 12c/19c) · SQL Server · Stored Procedures · BULK COLLECT · FORALL · ETL pipeline devlopment.Unix.shell scripting,Linux Performance Tuning · Batch Processing · Jira · Postman · GitHub.Copilot

Location

Greater Nagpur Area

Work experience

Software Engineer (PL/SQL Developer) at Clover Infotech Pvt. Ltd., Jan 2022 - Present · 4 yrs 6 mos, Pune City, Client: Bajaj Allianz General Insurance Project: Agri Policy Issuance, Claims & Pet Dog Insurance Module | AgriNxt Product PL/SQL Development: - Developed and maintained stored procedures, packages, and functions for policy issuance and endorsements under PMFBY for loanee and non-loanee farmers. - Built PL/SQL backend for the Agri Claims Module — intimation generation, claim calculation, registration, payment requests, and claim approval workflows. - Designed the Pet Dog Policy module (Internal + i-Mitra interfaces) supporting issuance, endorsement, and renewal. - Optimised a critical batch processing bottleneck using BULK COLLECT and FORALL — processed 1–2 lakh records daily within a 5-hour window by splitting into 3,000-record scheduled batches, eliminating manual backend support entirely. - Wrote complex SQL queries using analytical functions, DECODE, CASE, correlated subqueries, and joins for data extraction and reporting. - Created automated schedulers and mailers, reducing manual intervention significantly. L2 Support Lead — AgriNxt Product (SQL Server): - Managed 60–70 production issues per month; delivered permanent PL/SQL fixes reducing 15–20 repetitive issues per month to zero recurrence. - Coordinated NRCR calls for case-specific frontend data corrections between business users and the development team. - Handled server operations — reboots, disk space monitoring, SSL certificate installation and renewal. - Coordinated application deployments across DEV, UAT, and production environments. - Acted as primary point of contact for end-user feedback and issue escalation.

Senior Software Engineer at Clover Infotech, Jan 2022 - Present · 4 yrs 6 mos, Client: Bajaj Allianz General Insurance | Project: Agri Policy Issuance, Claims & Pet Dog Module 1. Eliminated manual backend intervention entirely — from a daily 5-hour processing window requiring continuous monitoring and manual scheduler restarts, down to zero manual support — by refactoring a critical Oracle PL/SQL batch procedure using BULK COLLECT and FORALL, splitting 1–2 lakh daily records into independently scheduled 3,000-record batches. 1. Reduced recurring production defects to zero recurrence (from 15–20 repeat issues/month) across a 60–70 issue/month support load, by performing root-cause analysis and delivering permanent PL/SQL fixes as L2 Support Lead for the AgriNxt product (SQL Server). 1. Improved claims data integrity on the Agri Claims Module by identifying and resolving duplicate claim records, through systematic data analysis spanning intimation generation, claim calculation, registration, payment requests, and approval workflows. 1. Delivered a new revenue-generating product line — the Pet Dog Insurance Policy (issuance, endorsement, renewal) — across two channels (internal + i-Mitra), by designing and implementing a dual-interface PL/SQL backend from scratch. 1. Sustained policy issuance and endorsement throughput for PMFBY loanee and non-loanee farmer segments at production scale, by developing and maintaining Oracle PL/SQL stored procedures, packages, and functions. 1. Built ETL pipeline development for data-extraction and reporting workflows — performance-optimized SQL using analytical functions, correlated subqueries, DECODE/CASE logic, and multi-table joins — cutting turnaround time for business and audit reporting. 1. Minimized production downtime during deployment cycles by debugging and applying permanent code fixes across DEV, UAT, and production environments — rather than recurring patches.

Support Lead at Clover Infotech, 2022 - Present · 4 yrs 6 mos, Led L2 support team for the AgriNxt product — assigned and tracked production issues to team members, ensuring timely resolution and SLA adherence. Managed 60–70 production issues per month; performed root cause analysis and delivered permanent PL/SQL fixes, reducing 15–20 repetitive issues per month to zero recurrence. Coordinated NRCR (Non-Repetitive Change Request) calls for case-specific frontend data corrections, liaising between business users and the development team to resolve data anomalies requiring manual intervention. Acted as primary point of contact for end-user feedback, coordinating between business users and the development team for issue resolution and enhancements. Coordinated application deployments across environments, ensuring smooth rollouts with minimal downtime. Managed server operations including server reboots, monitoring server disk space, and proactive alerts for capacity issues. Handled SSL certificate installation and renewal to ensure uninterrupted and secure application access.

Education

Master of Technology - MTech, Structural Engineering, G.H. Raisoni College of Engineering(GHRCE), Nagpur

Master of Technology, Structural Engineering, RTMNU Study Stuffs