PL/SQL Developer at Clover Infotech Pvt Ltd (2021-11 – 2025-09)
PL/SQL Developer at ICICI Lombard Insurance Pvt Ltd (2023-11 – 2025-09)
- Developed and maintained database objects including Tables, Views, Indexes, Synonyms, Stored Procedures, Functions, Packages, and Triggers using Oracle PL/SQL.
- Created and altered database tables to support new business requirements while ensuring data integrity and performance.
- Designed and managed Views and Synonyms to simplify data access and improve application maintainability.
- Implemented Indexes and analysed query execution plans to optimize database performance and reduce query response times.
- Developed complex Stored Procedures and Functions to automate business processes and data transformations.
- Created Database Triggers to enforce business rules, maintain audit information, and support data validation requirements.
- Wrote complex PL/SQL programs using Cursors, Loops, Conditional Statements, Collections, and Dynamic SQL.
- Implemented robust Exception Handling mechanisms to identify and resolve errors effectively.
SQL Developer at Philip Morris, USA (2021-11 – 2023-10)
Retail Sales Data Warehouse participated in data warehouse design, development and testing activities, including fact/dimension table understanding.
- Wrote and validated SQL queries for data verification and business rule validation.
- Supported ETL testing and ensured data integrity across multiple data layers.
- Contributed to data transformation logic and exploratory testing of processed datasets.
- Collaborated with cross-functional teams to document and troubleshoot data issues.
Floor Man at Dynamic Drilling Services Pvt Ltd (2012 – 2018)
Trainee Instrumentation Engineer at HPCL (2011 – 2012)
