Saigopi Kasaraneni

Highly skilled PL/SQL Developer with over 4 years of IT experience, including 4.2 years of hands-on expertise in translating complex business requirements into efficient Oracle SQL and PL/SQL solutions. Proven ability to develop and optimize database objects like Procedures, Functions, Triggers, Packages, Tables, Views, and Indexes to enhance performance and support critical operations. Adept at leveraging advanced SQL concepts, performing high-performance data operations with BULK COLLECT and FORALL, and automating table partition management.

Experienced in the full development lifecycle, including code deployment, version control, and providing robust production support for data-related issues.

PL/SQL Developer at Accenture (2024-02 – Present)

• Designed and implemented PL/SQL-based ETL processes to extract, validate, transform, and load business-critical data from multiple source systems into Oracle target tables.
• Designed and developed PL/SQL packages, procedures, and batch processing programs to handle millions of records per cycle, implementing complex business rules, validations, and optimized data processing logic.
• Configured and maintained Partitioned Tables to optimize query performance and efficiently manage large volumes of time-based data.
• Designed and implemented indexes on high-volume tables, improving query performance for critical production workloads.
• Leveraged advanced SQL concepts including Analytical (Window) Functions, Common Table Expressions (CTEs), Joins, Subqueries, CASE Expressions, MERGE Statements, and Set Operators to implement complex business logic and optimize SQL performance.
• Implemented high-performance batch processing using BULK COLLECT, FORALL, Cursors, Collections, and Exception Handling, significantly improving large-volume data processing efficiency.
• Automated flat-file ingestion using SQL*Loader Control Files, reducing manual effort and improving data load reliability.
• Implemented centralized exception handling and error logging mechanisms to improve application reliability and simplify production issue analysis.
• Executed Oracle SQL and PL/SQL batch jobs using Mainframe JCL and ProcMan, ensuring timely execution of scheduled data processing and database maintenance activities.
• Collaborated with business analysts and cross-functional teams to analyze requirements, optimize business logic, and resolve production issues.
• Coordinated production deployments using Git, Bitbucket, Jenkins, and CDD, ensuring smooth releases with minimal production issues.
• Provided production support by investigating database issues, performing root cause analysis, resolving data-related incidents, and ensuring application stability.

PL/SQL Developer at Accenture (2022-05 – 2024-01)

• Developed and optimized Oracle PL/SQL packages, procedures, and triggers to streamline business operations, improve data processing efficiency, and ensure adherence to business rules.
• Designed and managed database objects including Tables, Views to meet client requirements.
• Created and maintained Indexes on high-volume tables to improve search performance and support critical business queries in production environments.
• Applied column-level security in views and queries to safeguard sensitive data.
• Implemented comprehensive exception handling and user-defined error logging, reducing debugging and issue resolution time.
• Collaborated with business analysts to gather and analyse requirements and actively participated in Agile development (daily stand-ups and sprint planning), enabling the on-time delivery.

Bachelor of Technology in Electronics and Communication Engineering – Kakinada Institute of Engineering and Technology (2021)