Senior Oracle SQL/PLSQL Technical Lead

RAMA (RAMAKRISHNA) THUNUGUNTLA

Phone: 952-***-**** Email: ***********@*****.*** Eden Prairie, MN US Citizen

PROFESSIONAL SUMMARY

Senior Oracle SQL/PL/SQL Developer and Technical Lead with 27+ years of IT experience, including 24+ years of hands-on experience delivering enterprise database applications, financial systems, and mission-critical business solutions. Specialized in Oracle SQL and PL/SQL development, database application design, performance optimization, and production support for large-scale enterprise environments.

Extensive experience designing, developing, enhancing, and supporting Oracle database applications using SQL, PL/SQL, Stored Procedures, Functions, Packages, Triggers, Views, Cursors, Collections, Dynamic SQL, Exception Handling, and advanced database programming techniques. Strong expertise in complex SQL development, query optimization, execution plan analysis, indexing strategies, SQL/PLSQL performance tuning, debugging, and troubleshooting to improve application performance, scalability, and reliability.

Delivered successful application enhancements, system customizations, integrations, and production support solutions for the U.S. Small Business Administration (SBA) Disaster Credit Management System (DCMS) built on Oracle Financial Services Lending and Leasing (OFSLL/Daybreak). Extensive experience supporting enterprise lending applications, performing impact analysis, resolving critical production issues, implementing business requirements, and collaborating with stakeholders to deliver high-quality solutions.

Specialized in Oracle Database technologies including Oracle Database 19c, 12c, and 11g, Oracle Forms & Reports, Oracle Application Server, SQL Server, JDeveloper (ADF), TOAD, SQL Navigator, GitHub, SVN, PVCS, Shell Scripting, XML processing, data migration, and enterprise system integration. Experienced in Oracle-to-SQL Server migration initiatives, application customization, and database-driven application development.

Extensively worked on ORACLE MODULES like Accounts Payable (AP), Accounts Receivable (AR), General Ledger (GL), Purchasing/Procurement (PO), Inventory (INV) and Fixed Assets (FA), Dealer management, Vendor management.

Involved in SQL Server Integration Services (SSIS), ETL Development, Data Integration, Data Migration, SSIS Packages, Control Flow, Data Flow, Execute SQL Task, Data Flow Task, Script Task.

Proven ability to lead technical initiatives, perform requirements analysis, create technical designs, conduct unit testing and integration testing, execute root cause analysis, and provide end-to-end SDLC support. Recognized for delivering scalable Oracle solutions, improving system reliability, mentoring development teams, and partnering effectively with business users, technical teams, and clients to achieve successful project outcomes.

Strong analytical and problem-solving skills with excellent communication skills and extensive experience supporting complex enterprise applications, coordinating issue resolution, and delivering customer-focused solutions in fast-paced environments.

KEY ACHIEVEMENTS

Played a key role in building and supporting the Daybreak Lending Suite used by the U.S. Small Business Administration (SBA)

Led implementation of the Disaster Credit Management System used for disaster loan processing

Worked closely with clients like MUFG and Harley-Davidson Financial Services on system delivery and enhancements

Managed multiple data migration efforts across Oracle and SQL Server environments

TECHNICAL SKILLS

Oracle SQL, PL/SQL

Stored Procedures, Functions, Packages, Triggers

Complex SQL Queries, CTEs, Analytical Functions

Query Optimization, Performance Tuning, Execution Plans, Indexing

Oracle 19c/12c/11g, SQL Server

TOAD, SQL Navigator, JDeveloper, Oracle Forms & Reports, JDeveloper (ADF)

GitHub, SVN, PVCS, Shell Scripting

ETL Development

Debugging, Unit Testing, Integration Testing, Impact Analysis, Production Support

PROFESSIONAL EXPERIENCE

Oracle Financial Services Software, Inc.

Consulting Technical Manager 2004 – April 2026

(Formerly I-Flex Solutions / Super Solutions Corp, Eden Prairie, MN)

Client & Project Work

Worked directly with clients to understand requirements and provide practical technical solutions

Coordinated with business users, developers, and managers to ensure smooth project delivery

Acted as a point of contact for technical discussions and issue resolution

Project Delivery

Managed end-to-end delivery of multiple projects, including planning, development, and support

Helped define scope, timelines, and handled risks during project execution

Worked with teams across different locations to complete deliverables on time

OFSLL / Daybreak Work

Contributed to development and customization of Oracle Daybreak Lending Suite

Worked on enhancements to application processing and loan management modules

Built custom solutions based on client-specific requirements

Data Migration & Integration

Worked on Oracle 12c to 19c migrations

Migrated data from external systems into Daybreak and SQL Server databases

Converted Oracle database components to SQL Server where needed

Development Work

Developed and enhanced enterprise applications using JDeveloper (ADF) and Oracle Forms, delivering user-focused solutions integrated with Oracle database back-end systems.

Designed and implemented application interfaces and automated business processes, including cash drawer functionality, queue management workflows, and background processing solutions to improve operational efficiency.

Created complex reports and developed backend database logic using Oracle SQL and PL/SQL, supporting business requirements and improving application functionality.

Extensive experience in Oracle PL/SQL development, including designing, developing, optimizing, and maintaining Stored Procedures, Functions, Packages, Triggers, Cursors, Views, and database objects.

Developed complex SQL queries using joins, subqueries, Common Table Expressions (CTEs), analytical functions, and advanced data manipulation statements to support enterprise application requirements.

Specialized in SQL query optimization and database performance tuning using execution plan analysis, indexing strategies, SQL/PLSQL optimization techniques, and performance best practices.

Proven ability to analyze, debug, troubleshoot, and resolve complex PL/SQL application issues, ensuring system stability, data accuracy, and reliable application performance.

Performed Integration Testing, Impact Analysis, Unit Testing, and end-to-end workflow validation to ensure application quality, business process accuracy, and data integrity.

Analyzed business requirements and translated them into efficient database solutions, delivering scalable, maintainable, and high-quality Oracle applications.

Identified root causes of production issues, implemented corrective solutions, and supported application enhancements while minimizing business impact and maintaining system availability.

Applied strong knowledge of Oracle database design principles, including data integrity, exception handling, transaction management, and performance optimization.

Collaborated effectively with business analysts, developers, QA teams, and stakeholders throughout the SDLC, supporting requirements gathering, technical design, testing, deployment, and production support activities

Support & Improvements

Analyzed production issues and worked with teams to fix them

Helped improve system performance and usability

Federal Project (SBA)

Worked on Disaster Credit Management System for SBA

Helped customize the system to meet federal requirements

Supported systems used for disaster loan processing

CLIENT ENGAGEMENTS

Harley-Davidson Financial Services

Island Financials

Mitsubishi UFJ Financial Group

U.S. Small Business Administration – Office of Disaster Assistance

SBA Disaster Credit Management System (DCMS)

Caribbean Financial Group

MEPCO

Pioneer Financial Services

EDUCATION

Post Graduate Diploma in Computer Applications, Andhra Pradesh, India

Bachelor of Engineering - Acharya Nagarjuna University, Andhra Pradesh, India

ADDITIONAL INFORMATION

Comfortable working in client-facing roles

Strong coordination and communication skills

Experience handling long-term and complex projects

References available upon request

Contact this candidate