Sahil Mahajan

PL/SQL Software Developer with 3+ years of experience in insurance and TPA domains, specializing in Oracle database development and claims processing systems. Strong expertise in developing and optimizing PL/SQL procedures, packages, and complex SQL for high-volume transactional applications. Hands-on experience with Oracle supplied packages (UTL_FILE, DBMS_JOB, DBMS_SQL) and active involvement across SDLC phases including documentation, UAT support, production deployment, and issue resolution.

Lead development and maintenance of the EWISE Claims Processing Module for end-to-end insur ance claims handling.

• Design and optimize PL/SQL procedures, packages, and complex SQL for claims validation and report ing.
• Translate complex business rules into efficient database logic to improve accuracy and performance.
• Collaborate with business and QA teams to deliver enhancements and resolve defects.
• Support UAT and Production environments with root-cause analysis and permanent fixes • Developed and maintained PL/SQL components for enterprise insurance applications.
• Implemented validation logic for policy verification, eligibility checks, and financial calculations.
• Designed and managed Oracle database objects including tables, views, indexes, and materialized views.
• Worked on high-volume systems supporting document dispatch and customer feedback applications.
• Performed SQL optimization and performance tuning to improve system stability.
• Supported UAT, production deployments, and live issue resolution.
• Used Oracle SQL Developer and SSMS for cross-database analysis and troubleshooting.
• Utilized Oracle packages such as UTL_FILE and DBMS_JOB for file handling and scheduling

Masters of Computer (Amity University, Delhi)