KOTLA SURENDRA REDDY

Phone: +919581122534
E-mail: surendrareddykotla430@gmail.com

Career Objective:
To succeed in an environment of growth and excellence and earn a job which provide me job satisfaction and self-development and help me achieve personal as well as

organizational goals.

Professional summary
● Possess over 3 years of experience in SQL, PL/SQL, and Oracle APEX development,
delivering and enhancing robust database solutions and applications. Proficient in
designing, developing, and optimizing complex queries and interactive web applications,
with ongoing active engagement in these technologies.
● Currently working as an Oracle APEX Developer on Harmonic, an e-commerce website,
specializing in Oracle APEX technology to develop and enhance its functionality.
● Led the successful upgrade of the Oracle database from 11g to 19c, resolving
compatibility issues, optimizing performance, and ensuring minimal downtime.
● Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
● Created Cursors, Collections, and database Triggers for maintaining complex integrity constraints and implementing the complex business rules.
● Worked with dynamic SQL queries by creating SQL queries at runtime using EXECUTE IMMEDIATE, DBMS_SQL.
● Good Debugging skills and good at using Predefined and User Defined Exceptions RAISE application clause and Error Handling.
● Extensively worked with third party database tools like TOAD & PL/SQL Developer
● Extensive knowledge in using SQL queries for backend database analysis.

● Experience in database development using SQL and PL/SQL and experience working on databases like Oracle 11g/19c.

Academic Qualifications:

Bachelor of Technology in Electronics and Communication Engineering with First class from
Jawaharlal Nehru Technological University, Anantapur (India).

Technical Forte:
Databases Oracle 11g/19c.

Languages SQL, PL/SQL, Oracle APEX, Java, HTML, CSS, Java Script

Tools SQL Tools, TOAD, SQL developer, Oracle EBS R12, WinSCP, Putty

Professional experience:

Currently working as Senior Systems engineer in Infosys Ltd, Hyderabad (India) From June 2021.

Project details:

Project #1: HARMONIC APPLICATION DEVELOPMENT, Oracle APEX

Duration: 2022/06-Present

Role: Oracle APEX Developer

Project Description:
Contributed to the development of Harmonic, an e-commerce website built using Oracle APEX
technology. The project aimed to create a robust and user-friendly platform for online shopping,
leveraging Oracle APEX capabilities to ensure scalability, security, and ease of maintenance.
Responsibilities
● Designed and developed web pages, forms, and reports using Oracle APEX, ensuring a
seamless user experience.
● Developed complex SQL queries and PL/SQL procedures, packages, functions, and
triggers to handle data processing, validation, and business logic.
● Implemented dynamic actions and validations to enhance interactivity and ensure data
integrity.
● Created and managed PL/SQL stored procedures to handle various backend processes
and maintain business logic.
● Conducted performance tuning of SQL queries to optimize application performance and
ensure efficient data retrieval.
● Integrated the application with Oracle EBS R12 Finance, OM, and P2P modules for
comprehensive data management and reporting.
● Collaborated with cross-functional teams, including designers, QA testers, and business
analysts, to gather requirements and deliver high-quality solutions.
● Provided support for deployment, troubleshooting, and post-launch enhancements,
ensuring the stability and continuous improvement of the application.
Environment: SQL, PL/SQL, Oracle APEX, SQL developer, Toad, Oracle database 11g/19c.

Project #2: SONY(GEAS) Oracle EBS R12 Finance Module Enhancement and Database Upgrade

Duration: 2021/12-2022/05

Role: PLSQL Developer

Project Description:
Participated in the enhancement of the Oracle E-Business Suite R12 Finance module and
successfully upgraded the database from Oracle 11g to 19c. The project aimed to enhance
financial processes, improve system performance, and address challenges during the database
upgrade.
Responsibilities:

● Developed and optimized SQL queries and PL/SQL procedures, packages, functions, and triggers to enhance the functionality of the Finance module.
● Managed the upgrade process from Oracle 11g to 19c, ensuring a smooth transition with
minimal downtime.
● Developed and optimized complex SQL queries and PL/SQL procedures, packages,
functions, and triggers for data processing and reporting.
● Identified and resolved various challenges related to compatibility, performance, and data
migration during the upgrade.
● Implemented performance tuning techniques to optimize query execution and improve
overall system performance.
● Enhanced financial workflows, customized reports, and forms to align with updated
business requirements.
● Provided support for PL/SQL code deployment and troubleshooting issues in both pre-
and post-upgrade environments.

Environment: SQL, PL/SQL, SQL developer, WinSCP server, Putty, Oracle EBS R12, Toad, Oracle database 11g/19c, Oracle service Request, BMC ROD Portal.

Project #3: SONY I-SEMICON (Oracle EBS R12 OM and P2P Modules)
Duration: 2021/06-2021/11

Role: PLSQL Developer

Project Description:
Contributed to the enhancement of Oracle E-Business Suite R12, specifically focusing on the
Order Management (OM) and Procure-to-Pay (P2P) modules. The project aimed to streamline
business processes, improve system performance, and provide additional functionalities to meet
evolving business needs.
Responsibilities:
● Worked on Order Management (OM) and Procure-to-Pay (P2P) modules on enhancing
and customizing workflows.
● Developed and optimized complex SQL queries and PL/SQL procedures, packages,
functions, and triggers for data processing and reporting.
● Implemented performance tuning techniques to improve query execution and data
retrieval times.
● Created and managed PL/SQL stored procedures for data validation and business logic
execution.
● Provided support for PL/SQL code deployment and troubleshooting issues in a
production environment.
● Collaborated with cross-functional teams to analyze business requirements and
implement solutions.

Environment: SQL, PL/SQL, SQL developer, WinSCP server, Putty, Oracle EBS R12, Toad, Oracle database 11g, Oracle service Request, BMC ROD Portal.