Naresh Dudipalli

Highly motivated PL/SQL Developer with 5+ years of total professional experience, including 3.3+ years of relevant expertise in Oracle SQL and PL/SQL development, along with approximately 2 years of experience in non-PL/SQL roles contributing to overall system and business processes. Expertise includes complex SQL development, correlated subqueries, joins, analytical functions, performance tuning, indexing, execution plans, and data integrity management. Proficient in developing backend components using procedures, functions, packages, triggers, cursors, and exception handling. Known for supporting business applications through optimized query design and scalable database solutions. A collaborative professional with strong analytical skills, dedicated to delivering efficient, reliable, and high-quality database systems aligned with organizational objectives.

• ✅ PROJECT – 1
• Project Name: Community Blog Application

Duration: Jan 2024 – Present
Environment: Oracle Database, SQL*Plus, SQL Developer, PL/SQL
Role: Oracle PL/SQL Developer

• Project Overview:

Community Blog Application is a backend system designed to manage users, blog posts, and comments with high performance and strong data integrity. The application supports large volumes of content, enables fast search and pagination, and ensures secure transaction processing using Oracle PL/SQL.

• Responsibilities & Contributions:
• Designed and developed reusable PL/SQL packages, procedures, functions, and triggers.
• Implemented pagination and search functionality for handling large datasets efficiently.
• Optimized SQL queries and indexes to improve performance and reduce response time.
• Managed transactions, constraints, and validations to ensure data integrity.
• Built bulk upload modules for high-volume data processing.
• Designed a centralized exception-handling framework for error logging and tracking.
• Worked on performance tuning using explain plans and indexing strategies.
• ✅ PROJECT – 2
• Project Name: SBIG Insurance System

Duration: Mar 2023 – Dec 2023
Environment: Oracle Database, SQL Developer, PL/SQL
Role: Oracle PL/SQL Developer

• Project Overview:

SBIG Insurance System is an enterprise financial application used to manage agent hierarchy, client onboarding, and commission processing. The system automates multi-level hierarchies, validates onboarding data, and calculates commissions based on business rules with strong focus on performance, accuracy, and security.

• Responsibilities & Contributions:
• Developed transaction-processing PL/SQL modules for core business operations.
• Implemented complex joins, views, and indexes for reporting and analytics.
• Tuned SQL for large financial datasets and batch processing.
• Designed and maintained batch jobs for reconciliation and reporting.
• Implemented audit logging and alert mechanisms for tracking changes and failures.
• Supported UAT and production issue fixes.
• Worked closely with business teams to implement commission calculation logic.