SAI SUMUKH SUDIGALA
Riceland Foods Inc.
Lakeland,TN
1
Certification
15
years of professional experience
Experienced Oracle PL/SQL Developer with 15 years in business application analysis, design, and implementation using Oracle RDBMS. Proficient in developing and upgrading web applications with Oracle APEX and creating complex database objects including stored procedures and triggers. Skilled in performance tuning, ETL frameworks, and DevOps methodologies, including CI/CD practices with GitHub and Jenkins. Demonstrated ability to manage project activities effectively in Agile environments.
Work History
System Engineer
5 Years 11 Months- Develop and maintain Business applications using Oracle APEX (5.1) as front end and Oracle database 19c as backend.
- Tested and migrated Oracle Apex applications from 5.1 to 22.2, fixing issues during the process.
- Participated in business requirements meetings, gathered requirements, and created business requirement documents.
- Provided bug fixes for applications and created tickets for production deployment of changes.
Reports Developer
1 Year 5 Months- Develop reports using Active Reports 11 using VB.Net and support the TAS (Trust Accounting System) application.
- Build database components such as packages and procedures.
- Migrated Active Reports 6 to Active Reports 11 and enhanced user interface for improved report accessibility.
- Participate in project team meetings on a weekly basis and provide status on the tickets and reports to the business.
- Optimize the long running report in production environment.
- Validate the reports in the TAS application with the database query.
- Optimized long-running reports in production environment to improve performance and user experience.
- Managed TAS O&M activities by resolving service now tickets, ensuring adherence to SLA requirements.
Oracle PL/SQL Developer
11 Months- Performed SQL and PL/SQL tuning and application tuning using various tools like EXPLAIN PLAN, SQL TRACE, TKPROF and AUTOTRACE.
- Developed and modified UNIX shell scripts to adapt to evolving project and client requirements.
- Used bulk collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
- Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
- Designed PL/SQL scripts to extract data from operational database into flat text files using UTL_FILE package.
- Extensively used the advanced features of PL/SQL like records, Tables Object types and dynamic SQL.
- Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
- Authored scripts for creating new tables, views, and queries to support enhancements in the application using TOAD.
- Designed application framework and developed Oracle APEX Application.
- Worked on SQL Loader to load data from flat files obtained from various upstream systems every day.
- Created and modified several UNIX shell scripts according to the changing needs of the project and client requirements.
- Environment: Oracle 11g, PL/SQL, SQL.
- LOADER, SQL PLUS, TOAD, GitHub, Jenkins, HP-UNIX shell scripting, Squirrel 3.6, RTC, Quality Center and ETL Testing tool.
- Developed complex SQL queries for data extraction and reporting.
- Optimized database performance through indexing and query tuning.
- Collaborated with cross-functional teams to define data requirements.
- Conducted data modeling and design for relational databases.
- Mentored junior developers on best practices in SQL development.
- Implemented ETL processes to streamline data integration workflows.
- Ensured data integrity and security through rigorous testing protocols.
Oracle Developer and Lead
11 Months- Developed Advanced PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator.
- Created, designed, coded, debugged, maintained, tested, implemented and validated applications and collaborated and communicated with appropriate parties.
- Monitored execution plans for long-running queries in PL/SQL Developer and optimized performance by applying hints and modifying queries.
- Developed advanced PL/SQL packages, procedures, triggers, functions, indexes, and collections to effectively implement business logic using SQL Navigator.
- Monitoring the Informatica workflows in the Workflow Monitor and fixing the job failures.
- Contributed to ETL processes using PL/SQL to facilitate extraction, transformation, cleansing, and loading of data from source to target data structures.
- Closely worked with ODS team for the incoming files into the database and made sure the system is up and running.
- Worked closely with database engineers and architects to maintain integrity and stability of the database.
Oracle Developer
4 Years- Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
- Analyzed requirements, designed tests, prepared test cases, executed tests, managed defects, and reported on project management.
- Developed scripts for new tables, views, and queries to enhance application functionality using TOAD for OLTP system.
- Loaded data using PL/SQL and SQL.
- Automated data loading by calling UNIX scripts. to download and manipulate files.
- Involved in requirement Analysis, Test Design, Test Preparation, Test Execution, Defect Management, and Management Reporting for the project.
- Code walkthrough and deployment in different environments.
- Addressed production support issues to ensure system reliability. and resolving errors in quick time.
Education
Bachelor of Technology - Computer Science and Engineering
GPA: 3.6/4.0
Skills
Tools: Oracle APEX
TOAD
Oracle PL/SQL Developer
Informatica
Visual Studio 2015
GitHub
SVN
Control M
Jenkins
Database management
Programming languages : · SQL
PL/SQL
R
SQR
Excel VBA
VB.NET and C
Scripting: Unix scripting
Platforms: Windows
Unix
Technical Documentation
Business analysis
Certification
Oracle Certified Professional PL/SQL Developer
Timeline
System Engineer
Riceland Foods Inc.
10.2020 - CurrentRead More
Reports Developer
PBGC, Tera Think Corporation
04.2019 - 09.2020Read More
Oracle PL/SQL Developer
Syntel Inc
10.2017 - 09.2018Read More
Oracle Developer and Lead
Humana Inc, Syntel Inc
11.2015 - 10.2016Read More
Oracle Developer
John Hancock, Syntel Inc
10.2011 - 10.2015Read More
Jawaharlal Nehru Technological University
Bachelor of Technology from Computer Science and Engineering
Read More