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.