Kiran Shelke

Oracle PL/SQL Developer

Pune,MH

Summary

Oracle PL/SQL Developer with 5.3 years of experience in designing, developing, and maintaining robust database systems. Proven expertise in writing optimized SQL and PL/SQL code, creating database objects, and performance tuning. Strong understanding of business logic implementation and excellent team collaboration skills.

Overview

years of professional experience

Work History

PL/SQL Developer

Anura InfoTech

04.2023 - 06.2025

Designed and created database objects like tables, views, indexes, synonyms, and sequences.
Modified stored procedures, functions, and packages to align with evolving business requirements and enhance system functionality.
Tuned SQL queries using Explain Plan for improved performance.
Utilized Bulk Collects to optimize multi-row query performance.
Utilized Bulk Collects to enhance performance of multi-row queries, resulting in faster data retrieval.
Also have developed procedures using collections.
Collaborated with business teams to automate data processing, streamlining workflows and reducing manual effort.
Additionally, applied Power BI for creating dashboards, data modeling, and generating insights from business data.

SQL Developer

Codepix Solutions Pvt. Ltd.

03.2020 - 04.2023

Developed efficient and optimized SQL queries involving joins, subqueries, and analytical functions.
Designed databases and implemented business rules using constraints and triggers.
Employed UTL_FILE package for external file handling and data extraction, facilitating seamless data integration.

Education

Master of Computer Applications - Computer Applications Development

Pune University

Pune

04.2001 -

Skills

Languages: SQL, PL/SQL

Databases: Oracle Database

Database Programming:-Stored Procedures, Functions, Packages, Triggers

SOFT SKILLS

Strong communication and interpersonal skills
Analytical thinker and a proactive team player
Effective in fast-paced, deadline-driven environments

Timeline