Yogesh Karbhari

Oracle PL/SQL Developer with 4 years of experience in SQL development, database programming, and data warehousing. Skilled in developing complex SQL queries, PL/SQL procedures, functions, packages, triggers, and database objects. Experienced in query optimization, performance tuning, ETL support, data validation, and ensuring data integrity across large datasets. Strong ability to understand business requirements and deliver efficient, scalable database solutions.

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 Oracle database objects including Tables, Views, Indexes, Constraints, Synonyms, Stored Procedures, Functions, Packages, and Triggers.
• Created and modified database tables to support new business requirements while maintaining data integrity.
• Designed Views and Synonyms to simplify data access and improve application maintainability.
• Implemented Indexes and analysed execution plans to optimize SQL query performance.
• Developed complex PL/SQL procedures and functions to automate business processes and data transformation.
• Created database Triggers for business rule enforcement, auditing, and data validation.
• Developed PL/SQL programs using Cursors, Collections, Loops, Conditional Statements, Dynamic SQL, and Bulk Processing.
• Implemented robust Exception Handling to improve application reliability.
• Worked on database security by creating Users, Roles, and managing privileges.
• Performed SQL query tuning and troubleshooting to improve application performance.
• Collaborated with developers, testers & business analysts to deliver database solution.

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.

• Participated in data warehouse development and testing activities involving Fact and Dimension tables.
• Developed and executed SQL queries for data validation and business rule verification.
• Supported ETL testing and ensured data accuracy across multiple data layers.
• Assisted in implementing data transformation logic and validating processed datasets.
• Investigated and resolved data quality issues in collaboration with cross-functional teams.
• Prepared SQL scripts for reconciliation, reporting, and data analysis.
• Contributed to documentation of data validation processes and defect resolve.

Floor Man at Dynamic Drilling Services Pvt Ltd (2012 – 2018)

Trainee Instrumentation Engineer at HPCL (2011 – 2012)

Bachelor of Engineering in Instrumentation Engineering – Mumbai University, Mumbai (2010)