Adarsh Hoode

Software Engineer with 3.4 years of professional experience specializing in oracle PL/SQL and Python for enterprise backend systems. Strong expertise in database programming, SQL performance optimization, Python automation REST API integration and production support. Experienced in building scalable database solutions, optimizing complex queries, integrating external systems, and supporting mission-critical application in Agile environments.

Software Engineer - Tech Mahindra - Bengaluru, India

(2022-12)

Client: London Stock Exchange Group (LSEG)

• Designed and developed Oracle PL/SQL procedures, functions, packages, and triggers to support enterprise-level backend systems handling large transactional data.
• Created and optimized complex SQL queries involving joins, subqueries, and aggregations for reporting and analytics requirements.
• Performed SQL performance tuning by analysing execution plans, implementing indexes, and restructuring queries, resulting in significant reduction in processing time.
• Implemented high-performance PL/SQL logic using Bulk Collect and FORALL to efficiently process high-volume datasets.
• Automated recurring database tasks using DBMS_SCHEDULER, improving operational efficiency and reducing manual effort.
• Developed Python automation scripts for data extraction, validation, and backend processing integrated with Oracle databases.
• Integrated external REST APIs using Python, processed JSON responses, and stored relevant data into Oracle tables.
• Implemented robust logging, exception handling, and monitoring mechanisms to ensure application reliability.
• Actively handled production support activities, including incident resolution, root cause analysis, and deployment support.
• Worked closely with cross-functional teams in an Agile/Scrum environment, tracking tasks and releases using JIRA and GitHub.

Bachelor of Engineering - Electronics & Communication - Srinivas Institute of Technology (2022)