Sign in

Oracle PL/SQL Developer

Arlington Heights, Illinois, United States
April 06, 2019

Contact this candidate


Symon S


Professional Summary

Brain Bench Certified Java Programmer with over 8+ years of professional IT experience in Software Development, involving in Analysis, Design, Development, Testing, Implementation & Maintenance of application software in Web-based and Client/Server environment and Having 3+ years of experience an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).

Experienced in large-scale custom development and/or systems integration projects across multiple phases of the software development lifecycle (SDLC)

Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.

Expertise in Client-Server application development using Oracle 11g/10g/9i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.

Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.

Domain expert in Retail, HealthCare, Manufacturing.

Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.

Expertise in Core Java and J2EE technologies such as Servlets, JSP, JDBC, JSF, JPA, Hibernate, Spring, JMS, HTML, CSS, XML, DOM/SAX parsers, JavaScript, JQuery, Ajax, Spring Framework, JSF Framework and O/R mapping Hibernate framework and JPA.

Well versed in all stages of Software Development Life Cycle including proposal, process engineering, requirement analysis, design, development, testing, deployment and support and maintenance with various methodologies such as Waterfall, Scrum and Agile models.

Possesses good leadership qualities, good Interpersonal Skills, team-working attitude, takes initiatives and very proactive in solving problems and providing best solutions.

Quick learner and ability to work in challenging and versatile environments and Self-motivated, good written/verbal communication.

24 X 7 Production Database on Call Support.

Technical Skills:

Operating systems: Windows 95/98/NT/2000/XP/Vista/7/10, UNIX

Languages: SQL, PL/SQL, Java, J2EE and Java Script, JSF, Spring, Hibernate, JSP, Servlet, CSS, HTML, XML.

Database: Oracle 9i/10g/11g (SQL, PL/SQL), MS Access, MS SQL Server, MySQL, DB2.

Software: MS Office, Visio, SSRS and MS Office Project.

Version Control: PVCS, CVS, SVN, GIT.

IDE: IntelliJ IDEA, Eclipse, My Eclipse, My Eclipse Blue, PRPC, Eclipse, Eclipse Juno, TOAD.

Professional Experience

ISL, Des Moines, IA May ‘17 – till date.

Oracle PL/SQL Developer


Responsible for creating Database Design (Physical and logical) and modifying the PL and SQL procedure, function according to the business requirement.

Used SQL LOADER to upload the information into the database tables.

Created database objects like stored procedures, function, packages, Cursor, Ref Cursor and Triggers.

Wrote and modified Oracle PL and SQL, Sql statements procedures and functions that are called in the Java Scripts, Jsp and Hibernate.

Participates in continuous improvement efforts in enhancing performance and providing increased functionality

Work with development team in build out of application code

Wrote custom support modules for upgrade implementation using Pl/Sql and Unix Shell Scripts

Involved in analysis, design, coding and Testing.

Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database.

Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Planned version control of production source code using Subversion (SVN).

Environment: VB 6, Oracle 9i/10g/11g SQL, PL/SQL, Forms 9i, Unix Shell Scripts, SQL*Loader, SQL Navigator, TOAD, Agile methodology - Scrum, JIRA.

John Deere, Moline, IL March ‘16 – April ‘17.

Oracle PL/SQL Developer


Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.

Designed logical and physical data models for star and snowflake schemas using Erwin.

Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.

Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle..

Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.

Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.

Worked on XML along with PL/SQL to develop and modify web forms.

Designed Data Modeling, Design Specifications and to analyze Dependencies.

Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.

Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.

Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.

Used Oracle JDeveloper to support JAVA, JSP and HTML codes used in modules.

Worked with production support management to identify issues.

Provided 24 hour on-call production support. Attended calls related to customer queries.

Environment: VB 6, Oracle 9i/10g/11g SQL, PL/SQL, Forms 9i, SQL*Loader, SQL Navigator, TOAD, Agile methodologies - Kanban and Scrum.

AccuCare - Anjani International, IL Dec ‘14 – Feb ‘16

Java/SQL Developer


Vigorously developed User Interfaces using the Java Server Faces and Richfaces which includes JSF Modal, Sections and Tabs etc.

Developed JSF Managed beans, Service and DAO Implementation classes, Hibernate scripts to implement and support end – to- end functionality.

Dependency Injected several Spring Application Context and JSF Faces Configuration to Auto-wire the Java Beans for various components.

Handled the flow of business logic of the application and Data integration at with back-end using Spring framework.

Plan, design, and implement application database code objects, such as stored procedures, functions, synonyms and views in SQL Server 2008 R2/2008

Built and maintained SQL tables, scripts, views, functions, indexes, and complex queries for data analysis and extraction in SQL Server 2008 R2/2008.

Developed new processes to facilitate import and normalization, including data file for counterparties.

Assisted client with integration and data conversion activities.

Documented and maintained database system specifications, diagrams, and connectivity charts.

Identified data issues and provided recommendations for resolution to ensure optimal performance.

Work with internal and external clients for import and normalization of third-party data.

Performed data integrity checks by scheduling jobs and stored procedures.

Maintained databases containing Patients Medical Records data in a multi-server environment.

Created Data Flow Diagram and Data Architectural Flow in MS Visio.

Used SQL Profiler monitor Performance of Queries and to index the Tables

Created Maintenance Plans and setup log files to monitor jobs

Environment: Java/J2EE, JDK 1.6, JSF, Rich faces, Spring3.2, Hibernate 4, JPA, JSP, Servlets, HTML, CSS, JavaScript, JQuery, XML, ANT, SVN, Web services, SOAP, WSDL, Design Pattern, JUnit, Jenkins, Scrum methodology,TFS, Java Security, RSA Authentication Manager, My Eclipse Blue Edition, Microsoft SQL Server, IBM WebShpere Application Server 8.5 and Windows 7

IBM, Seattle, WA June ‘13 – Nov ‘14

Java Developer


Developed User Interfaces using the Java Server Pages and Servlet.

Wrote several Hibernate scripts to connect Domain Objects and the Middle Layer Business components to backend using JPA.

Dependency Injected several Spring Application Context to Auto-wire for various components.

Designed reusable components like Search Criteria’s and Search Results.

Handled the flow of business logic of the application and Data integration at with back-end using Spring framework.

Wrote & Customized Stored Procedures, SQL queries to incorporate database logic.

Involved in Database design that is creation of Tables, Indexes, and Constraints.

Implemented provider transformations between JAXB entities representing the models and the entities.

Using AngularJS, created custom directives for data manipulations and to display data in company standard

format in UI. Applied AngularJS for client-side Validation.

Active participation in Defect tracking and fixes. Involved in validation, analysis & resolution of the defects reported by the clients and the QA team.

Responsible for working on the deliverables for releases.

Throughout the development lifecycle, applied quality assurance standards in compliance with company procedures and industry best practices.

Actively Participated in group discussions with peers or external groups on system related topics.

Responsible for taking back-up of code base on daily basis using GIT.

Day to day co-ordination and interaction with Architects and Manager.

Performed Unit and functional testing of the components.

Involved in analysis, design, development, testing and implementation.

Development with implementation on enterprise level server J2EE infrastructure for high availability and high performance.

Detailed walk through and hand over the artifacts to production support team.

Environment: Java/J2EE, JDK 1.6, Spring, Hibernate, JPA, JSP, Servlets, HTML, CSS, JavaScript, AngularJS, Webservices Maven, Git Repository,TFS, Jenkins, Eclipse JUNO, Oracle 11g, TOAD, Tomcat Application Server and Windows 7

Cleartrack, Brentwood, TN Oct ‘12 – May ‘13

Programmer Analyst


Design software architecture, development process, and implementation alternatives for large scale, desktop and/or web-based solutions based on Java technology and including open source solutions where appropriate.

Involved in the High level and detailed design, Coding, Testing, and Implementation of the applications.

Worked closely with the Business Analysts while defining requirements.

Responsible for reviewing and validating the use cases with Business analysts before designing the web pages.

Developed Interactive GUI Screens using JSF, JSP, Java Script, CSS and HTML.

Integrated Spring with JSF to take advantage of AOP (Aspect Oriented Programming) and its cross cutting abilities.

Connected back-end with middle tier using Spring with ORM tool Hibernate framework.

Creation of Plain Java Old Objects (POJO) by following the OR mapping file.

Using Data Access Object (DAO) pattern, created classes for implementing the access logic to the database using Hibernate mapping file, Hibernate SQL Queries and POJO.

Used Crystal report as reporting tool.

Used CVS for version controlling System.

Environment: Java/J2EE, JDK 1.6, JSF, Spring, JPA, JSP, Servlets, HTML, CSS, JavaScript, XML, ANT, SVN, Web services, SOAP, WSDL, Design Pattern, JUnit, Jira, Agile methodology, My Eclipse, Crystal Report, Microsoft SQL Server JBoss and Windows 7

TIM, Rome, Italy Feb ’10 – Sep ’12

Programmer Analyst


Responsible for writing Java code for database activity

Conduct detailed business analysis to architect & design IT solutions that meet functional and technical requirements.

Wrote SQL Queries, and integrated SQL Queries into DAO.

Work and support testing team to ensure testing conforms to design and requirements.

Work with the project team to develop implementation, build and deploy artifacts.

Development of JavaScript for client end data entry validations and Front End Validation.

Responsible for developing of test procedures for unit testing.

Developed the presentation Tier using JSP, XML, HTML, CSS and JavaScript.

Designed Class & Sequence diagrams for fund calculators, Search & document services using UML.

Worked with production support team in debugging and fixing various production issues.

Detailed walk through and hand over the artifacts to production support team

Involved in configuration and deployment of application on WebLogic Application Server.

Post Production monitoring of the deployed software to ensure successful implementation

Environment: Java/J2EE, JSP, JavaScript, XML, PVCS, IntelliJ IDEA, Tomcat, iText Library, Barcode4j Library, JSP, CSS, Servlets, XML, XSD, XSLT, Web Methods, UML, JMS, MDBs, Session Beans, JDBC, JNDI, JUnit, Unix, ANT, MySQL, WebLogic


Brain Bench Certification in JAVA

Brain Bench Certification in MySQL

J2EE Certificate from Mahatma Gandhi Education Foundation (India)


PRPC - PegaRULES Process Commander

Hadoop Developer

Linux Administration

Contact this candidate