Ashish Jadhav

Detail-oriented PL/SQL Backend Developer with 3.6+ years of experience at Tata Consultancy Services (TCS) in designing, developing, and optimizing backend systems using SQL, PL/SQL, and Java Spring Boot. Seeking to contribute technical expertise and innovative problem-solving skills as a PL/Sql, Oracle Sql and Java Developer to help the organization achieve operational excellence and scalability.

Application Engineer I - HPS Worldwide - Pune

(2026-05)

APAC Support Team

• Provide application support for customers across the APAC region by resolving customer-facing issues within defined SLAs.
• Investigate, troubleshoot, and resolve application, database, and functional issues to ensure uninterrupted business operations.
• Coordinate directly with customers through Jira to track incidents, service requests, and issue resolutions.
• Analyze logs, SQL queries, and application behavior to identify root causes and implement appropriate fixes.
• Collaborate with development, QA, and cross-functional teams to resolve complex production issues.
• Maintain incident documentation, provide timely status updates, and ensure high customer satisfaction.
• Participate in production support activities, issue prioritization, and continuous service improvement.

System Engineer - Tata Consultancy Services Limited - Mumbai

(2022-08 - 2026-03)

• Designed and developed high-performance PL/SQL components including Stored Procedures, Packages, Functions, Triggers, Views, and Indexes to support enterprise-level financial systems.
• Implemented modular and reusable PL/SQL packages for business logic, improving maintainability and scalability.
• Developed complex SQL queries with joins, subqueries, analytical functions, and aggregations for data processing and reporting. Worked on large datasets with performance optimization techniques.
• Used Bulk Collect and FORALL for efficient bulk data processing and performance optimization.
• Performed query optimization using execution plans (EXPLAIN PLAN), indexing strategies, and query restructuring, improving performance by up to 20–30%.
• Identified and resolved slow-running queries, locking issues, and deadlocks in production.
• Applied indexing techniques (B-tree, composite indexes) to improve query execution time.
• Reduced data retrieval latency by optimizing joins, avoiding full table scans, and minimizing redundant operations.
• Actively involved in production release deployment, validation, and post-release monitoring.
• Handled production issues with RCA (Root Cause Analysis) and provided quick fixes to ensure system stability.
• Managed Database Password Change activities ensuring secure and uninterrupted application connectivity.
• Created and maintained production runbooks, release documents, and technical documentation.
• Executed End-of-Day (EOD) batch processes to ensure timely completion of financial transactions.
• Participated in Business Continuity Planning (BCP) and disaster recovery activities.
• Ensured data consistency and reconciliation during critical business operations.
• Monitored batch jobs, logs, and system health during production cycles.
• Developed dynamic reports (CSV, PDF) using SQL backend and SAP Crystal Reports.
• Designed data extraction queries for business reporting and analytics.
• Automated report generation, reducing manual effort by up to 70–80%.
• Optimized report queries to ensure fast data retrieval and accurate reporting.
• Worked closely with Business Analysts, QA teams, and Frontend developers to gather requirements and deliver solutions.
• Participated in Agile ceremonies like sprint planning, stand-ups, and retrospectives.
• Coordinated with DevOps and Release teams for smooth deployments.
• Provided technical support and knowledge transfer to junior team members.
• Performed data migration, validation, and reconciliation for legacy to modern systems.
• Ensured data integrity and consistency during bulk operations.
• Worked on data correction scripts and one-time data fixes in production.

Bachelor of Engineering - Mechanical - P K Technical Campus (2021)