Susmitha
gsusmitha034@gmail.com
234-200-6047
Olmsted Falls, OH 44138
Oracle PL/Sql Developer
15 years experience C2C
0
Recommendations
Average rating
139
Profile views
Summary

  • 8+ 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).
  • Experience in developing PLSQL Stored Procedures, Functions, Packages, Database Triggers using features like Cursors Ref Cursors, Analytical Functions, Collections, Exception Handling.
  • Extensive experience in Performance tuning and optimization using execution plans.
  • Design and Develop Oracle Interfaces and Conversions using SQL Loader
  • Good experience as Data analyst for migrating data from Oracle to CSV files or Excel.
  • Tuned SQL queries using Explain Plan and performed refinement of the database design leading to significant improvement in system response time and efficiency.
  • Extensive programming knowledge in PL/SQL, SQL*Plus, TOAD, SQL*Loader.
  • Wrote stored procedures and UNIX scripts as a part of ETL Process.
  • Experience in using External Tables and Temporary tables.
  • Experience in writing Unix shell scripts to generate outbound feeds and ftp'ing to other systems.
  • Extensive knowledge and experience in SQL Queries.
  • Proficient in writing PL/SQL Packages, Stored Procedures, Functions, Database Triggers.
  • Purging data in tables using PL/SQL routines.
  • Expertise in all aspects of SDLC requirement analysis, technical specifications, Logical and physical design, development, testing, documentation, implementation and maintenance in multi-tier and client/server architectures.
  • Experience in production support.

Experience
Education
Skills
Oracle
2022
8
PL/SQL
2022
1
SQL
2022
1
SQL Developer
2022
1
Architecture
0
1
Data Analysis
0
1
Database Design
0
1
ETL
0
1
FTP
0
1
Implementations
0
1
Microsoft Excel
0
1
Performance Tuning
0
1
Production Support
0
1
Shell Scripts
0
1
SQL Loader
0
1
Stored Procedure
0
1
TOAD
0
1
Triggers
0
1
UNIX
0
1