Pranavi Bhoir

Software Engineer with 3+ years of IT experience in SQL Support, Application Support, Release Management, Data Patch Deployments, and Application Performance Monitoring for banking and financial applications. Hands-on experience in Oracle SQL, SQL query analysis, data validation, application troubleshooting, incident management, Root Cause Analysis (RCA), application deployments, and performance monitoring. Familiar with joins, subqueries, indexes, views, constraints, stored procedures, execution plans, and basic query performance tuning.

Software Engineer - Avekshaa Technologies Pvt Ltd - Mumbai

(2023-01)

Application Performance Monitoring - LTFS

(2026-01)

• Monitored application performance using Dynatrace, analyzing response time, throughput (RPS), JVM metrics, CPU, memory, and database performance.
• Performed SQL query analysis, stored procedure optimization, execution plan review, and index creation to improve database performance.
• Executed pre- and post-deployment performance testing, validating application behavior and measuring response time improvements.
• Compared and validated stored procedure changes, performed data verification, and documented performance analysis and optimization results.
• Investigated application performance issues using logs, metrics, and Root Cause Analysis (RCA), collaborating with development and infrastructure teams for resolution.

Application & SQL Support / Release Deployment - HDFC Bank

(2023-01 - 2026-01)

• Provided Application and SQL Support for mission-critical banking applications, ensuring high availability and timely issue resolution.
• Utilized Oracle SQL for application issue analysis, Root Cause Analysis, data validation, and backend troubleshooting using queries, joins, and subqueries.
• Worked with Oracle Database concepts including indexes, views, constraints, and basic performance tuning activities.
• Applied basic PL/SQL knowledge including procedures, functions, and cursors.
• Performed release deployments, data patch activities, and application validations while following change management and compliance standards.
• Used Linux/Unix commands for application log analysis, process monitoring, file validation, and application troubleshooting.
• Collaborated with Development, QA, Infrastructure, and Business teams for release coordination, incident management, and timely issue resolution.
• Worked with Jenkins, JFrog Artifactory, ServiceNow, Linux, and Ansible to automate and support release activities.

B.E. - Computer Engineering - VOG College of Engineering (2019-01 - 2022-01)