We provide IT Staff Augmentation Services!

Pl/sql Developer Resume

Boca Raton, FL

SUMMARY

  • Over 5+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using Oracle RDBMS.
  • 2+ years of experience as a Java Developer in Analysis, Design and Implementation of Client/Server,Distributed,Internet and E - Commerce Applications.
  • Involved in leading software development on software projects from conception through implementation, execution and maintenance with timely delivery against aggressive deadlines.
  • Efficiently worked and deployed distinct Client-Server applications using Oracle 12c/11g/10g PL/SQL, iSQLPLUS, SQL *PLUS, TOAD and SQL*LOADER
  • Efficient in writing PL/SQL Stored Procedures, Functions, Cursors, Triggers and Packages.
  • Have automated many jobs using unix crontab in unix
  • Expertise in complex SQL queries including inline queries and subqueries for faster data retrieval from multiple tables.
  • Tuned SQL queries to improve performance.
  • Troubleshoot and debug system and/or data errors
  • Worked in Onsite/Offshore global delivery model.

TECHNICAL SKILLS

Database: Oracle 10g/11g/12c (SQL, PL/SQL)

Operating System: UNIX, Windows NT/2000, and Windows XP

Programming Languages: Core Java, PL/SQL, Shell Scripting (sh/ksh/csh)

RDBMS: ORACLE

Markup Languages: XML, HTML, XHTML

Utilities: SQL*PLUS, iSQLPLUS, SQL*Loader, and TOAD

PROFESSIONAL EXPERIENCE

Confidential, Boca Raton, Fl

PL/Sql Developer

Environment: s: Oracle 10g/11g SQL, PL/SQL, UNIX, SQL*Loader, SQL Navigator, TOAD, SQL DEVELOPER.

Responsibilities:

  • Developed procedures,functions and packages to implement the business requirement using pl/sql.
  • Used SQl*Loader and created External Tables in order to load data from flat files into oracle tables.
  • Extensively used Bulk Binding and Collections for manipulating the large amount of data and enhance performance.
  • Wrote complex SQL queries using joins and subqueries to retrieve data from the database.
  • Involved in the continuous enhancements and fixing of production problems.

Confidential, Tampa,FL

PL/SQL Developer

Environment: s: Oracle 11g, TOAD, GIT, SQL Developer, Windows XP.

Responsibilities:

  • Technical investigation of many enterprise banking applications responsible for the collection of merchant transaction data and providing reports of provided information spanning multiple environments for Java and C++ applications.
  • Creation and tweaking of scripted monitors utilized bash, Perl and groovy.
  • Navigation of oracle database data in relation to processes, logs and data.
  • Performed production and UAT code rolls with self-designed systems scripts to speed up the otherwise manual process.
  • Provided bug analysis and working closely with development to correct undesired application behavior.
  • Writing procedure and scripts to work around defects.
  • Tuxedo application administration.
  • Creating jobs for Control-M monitors which is a fancy crontab with GUI.
  • Used PeopleSoft for tracking the issues and resolving them.

Confidential

PL/SQL Developer

Environment: s: Oracle 10g/11g SQL, PL/SQL, UNIX, SQL*Loader, SQL Navigator, TOAD, SQL DEVELOPER

Responsibilities:

:

  • Worked for a billing Application Maintenance Project on which maintained and extended the application system for better performance and efficiency
  • Created and reorganized all types of Oracle database objects including tables, views, indexes, sequences, synonyms and setting proper parameters and values for all the objects
  • Wrote Oracle database triggers, stored procedures, stored functions, and stored packages to perform various automated tasks for better performance
  • Created indexes on the tables for faster retrieval of the data to enhance database performance.
  • Used different joins, subqueries and nested queries in SQL query
  • Effectively made use of Table Functions, Indexes, Table Partitioning, Analytical functions, and Materialized Views.
  • Involved in the continuous enhancements and fixing of production problems.

Confidential

Java/Oracle Developer

Environment: s: Java, JavaScript, Oracle 10g/11g SQL, UNIX, SQL*Loader.

Responsibilities:

  • Involved in complete SDLC - Requirement Analysis, Development, System and Integration Testing.
  • Implemented the application using Spring Framework which is based on Model View Controller design pattern.
  • Created Tables, Views, Constraints
  • Developed Complex database objects like Stored Procedures, Functions,
  • Packages and Triggers using SQL and PL/SQL.
  • Used Oracle utilities like SQL*Loader, TOAD, SQL*Navigator
  • Loaded Data into Oracle Tables using SQL Loader.

Confidential

Jr Java Developer

Environment: Java, JSP, JavaScript, SQL, JMS, Eclipse, WSDL, SOAP Web services, Oracle 10g.

Responsibilities:

  • Developed the component using Java, J2EE/JEE, JSP, Struts, Hibernate framework.
  • Involved in complete SDLC - Requirement Analysis, Development, System and Integration Testing.
  • Implemented the application using Spring Framework which is based on Model View Controller design pattern.
  • Implementation of SOAP Web Services using CXF.
  • Involved in designing frontend using JSPs, HTML, DHTML and CSS.
  • Analyze the performance of the application and fine tune the code where it is necessary.
  • Debugging and resolving issues for web service binding and deployments with attachments.

Hire Now