Kongathi Lakshminarasimhulu
PLSQL Developer
Mumbai,MH
Summary
Results-driven Software Engineer experienced in Oracle PL/SQL and SQL programming, with a strong background in developing complex queries, stored procedures, and performance tuning. Contributed to successful project lifecycles through effective requirement gathering, design, implementation, and testing, while also leading knowledge transition sessions for new team members. Focused on leveraging technical and problem-solving skills to drive career growth and deliver value within banking and lending systems.
Overview
1
1
Language
7
7
years of professional experience
Work History
Software Engineer
IN-SOLUTIONS GLOBAL LIMITED, MUMBAI
Navi Mumbai, Maharashtra
04.2019 - Current
- Performance Tuning & Legacy Optimization: Refactored over 10 legacy PL/SQL packages and procedures by replacing row-by-row cursor loops with advanced BULK COLLECT and FORALL operations, successfully decreasing nightly batch processing times by 40% and eliminating peak-hour timeouts.
- Query Efficiency Improvements: Improved database performance across critical reporting modules by optimizing legacy SQL queries with targeted indexes, achieving a 30% reduction in average system response times.
- End-to-End Fintech Delivery: Led database development for the core Merchant Settlement project, handling end-to-end data logic design, requirement gathering, and code analysis for marquee corporate banking clients including ICICI Bank and HDFC Bank.
- Cross-Functional SDLC Alignment: Collaborated closely with Business Analysts (BAs) to translate complex financial business requirements into scalable technical specs; coordinated daily status calls with clients to ensure seamless delivery.
- QA Support & Bug Resolution: Drove software quality by actively clearing defects raised by the QA team, providing advanced query optimization support to enhance overall testing environment efficiency.
- Agile Team Leadership: Collaborated within an active 8-member team using Agile Scrum methodologies to deliver high-quality software iterations on time.
- Mentorship & Onboarding: Mentored junior engineers and successfully managed technical onboarding and knowledge transition sessions for new team members, fostering a collaborative culture of continuous learning.
Education
Bachelor of Science - Computer Science
The Adoni Arts & Science College, Sri Krishna Deveraya Unive
Adoni, Andhrapradesh 04.2001 -
Master of Computer Applications - Computer Science
St. Mary's Engineering College, Jawaharlal Nehru Technologic
Hyderabad, Telangana 04.2001 -
Skills
RDBMS: Oracle 10g, 11g, 12c, 19c
Database Development: Advanced PL/SQL, Packages, Stored Procedures, Functions, Triggers, Views, Materialized Views, Partitions & Sub-partitions, Analytical Functions
Performance Tuning: EXPLAIN PLAN, AWR Reports, Index Optimization, Hint Usage
Advanced Capabilities: Bulk Collect, FORALL, Collections, Ref Cursors, Complex Query Optimization
Methodologies & Tools: Agile (Scrum), Waterfall, SQL Developer, Database Design, Debugging
Core Competencies: Client Handling, Requirement Gathering, Code Analysis, Cross-functional Collaboration
Timeline
Software Engineer
IN-SOLUTIONS GLOBAL LIMITED, MUMBAI
04.2019 - Current
Master of Computer Applications - Computer Science
St. Mary's Engineering College, Jawaharlal Nehru Technologic
04.2001 -
Bachelor of Science - Computer Science
The Adoni Arts & Science College, Sri Krishna Deveraya Unive
04.2001 -