Summary
Overview
Work History
Education
Skills
Timeline
Generic

KETHAVATH SAROJA

Hyderabad,TG

Summary

  • 2+ Years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
  • Knowledgeable Oracle Developer skilled in data collection, analysis and management. Works well under pressure and consistently meets deadlines and targets while delivering high quality work.
  • Highly-skilled software development professional bringing more than 2 years in software design, development and integration. Advanced knowledge of Oracle SQL, PL/SQL and MS T-SQL.

  • Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
  • Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.Expertise in Client-Server application development using Oracle 12c/11g/10g, PL/SQL, SQL *PLUS.
  • Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
  • Good knowledge on logical and physical Data Modeling using normalizing Techniques.Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
  • Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
  • Developed materialized views for data replication in distributed environments.
  • Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
  • Experience in Oracle supplied packages,Dynamic SQL, Records and PL/SQL Tables.Loaded Data into Oracle Tables using SQL Loader.
  • Partitioned large Tables using range partition technique.Experience with Oracle Supplied Packages such as DBMS_SQL,DBMS_JOB and UTL_FILE.
  • Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.Worked extensively on Ref Cursor, External Tables and Collections.
  • Expertise in Dynamic SQL, Collections and Exception handling.Experience in SQL performance tuning using Cost-Based Optimization (CBO).
  • Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
  • Experience in ETL techniques and Analysis and Reporting including hands on experience with the Reporting tools such as Cognos.
  • Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
  • Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.


Overview

3
3
years of professional experience

Work History

Oracle PL/SQL Developer

Azentio
09.2021 - Current
  • Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator.
  • Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
  • Created management analysis reporting using Parallel Queries, Java stored procedure.
  • Participated in change and code reviews to understand the testing needs of the change components. Worked on troubleshooting defects in timely manner.
  • Involved in creating UNIX shell Scripting. De-fragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency.
  • Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
  • Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle.
  • Extracted data from the XML file and loaded it into the database.Designed and developed Oracle forms & reports generating up to 60 reports.
  • Performed modifications on existing form as per change request and maintained it.
  • Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL_FILE, DMBS_SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
  • Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.
  • Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL.
  • Involved in data replication and high availability design scenarios with Oracle Streams. Developed Linux scripts to automate repetitive database processes. Built databases and table structures following n-tier architecture methodology for web applications.

Trainee

Azentio
08.2021 - 10.2021
  • Learned new materials, processes, and programs quickly.
  • Attended training courses to build understanding of processes, techniques, and industry.
  • Established lasting relationships with peers, leadership and customers using strong communication and interpersonal skills.

Education

B.Tech - Computer Science

Mahatma Gandhi Institute Of Technology
Hyderabad
08.2021

Skills

  • PL/SQL
  • Java
  • Python
  • Oracle SQL Developer

Timeline

Oracle PL/SQL Developer

Azentio
09.2021 - Current

Trainee

Azentio
08.2021 - 10.2021

B.Tech - Computer Science

Mahatma Gandhi Institute Of Technology

Similar Profiles

CREATE PROFILE
KETHAVATH SAROJA