SUMMARY:

• Over 10 years of programming experience as an Oracle PL/SQL and Java Developer/Lead in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• 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.
• Programming Skills in designing and implementation of multi - tier applications using Java, J2EE, JDBC, JSP, HTML, Spring Boot, JavaScript, Servlets, JavaBeans, CSS, EJB, JAXB
• Experience in developing Web Services using - SOAP, REST, WSDL and developing DTDs, XSD schemas for XML (parsing, processing, and design).
• Involved in building and deployment of applications using build tools like ANT and Maven.
• Knowledge with applications requiring Component Development, Multithreaded Programming, Session Tracking and Connection Pooling
• Expertise in Client-Server application development using Oracle 12c/11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER .
• 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.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• 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.
• 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.
• Experience working in Agile & Safe Agile Methodology
• Hands on experience in Web Application Security scanning tools AppScan & VeraCode

TECHNICAL SKILLS:

Databases: Oracle 12c/11gR2/10g/9i, SQL Server 2014

Environment: s: LINUX, Windows NT, Windows server 2000/2003, Sun Solaris

Application Server: Jboss 6.0, Wildfly 8.1.0

Tools: TOAD 10.6, SQL Developer 3.1, Eclipse, Version one, TFS, SOAP UI, PUTTY, WinSCP, Oracle Application Testing Suite (OATS), Altova XMLSPY, XY Enterprise XPP, Folio Builder, Jenkins, Pycharm

Languages: SQL, PL/SQL, Perl Script, UNIX shell Script, Java, Spring Boot, Python 3.0

Web Technologies: JavaScript, JSP, Servlet, HTML, DHTML, CSS, Web services

Version Control System: Clear Case, TortoiseSVN, Visual Source Safe (VSS) 6.0, GIT

RDBMS: Oracle8i, 9i and 10g, 11g, 12c

Scheduler: Cron Scheduler, Autosys

PROFESSIONAL EXPERIENCE:

Confidential, CA

Senior Java and Oracle PL SQL Developer

Role & Responsibilities:

• Lead Developer at client location.
• Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Developed Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Involved in the continuous enhancements and fixing of production problems.
• Involved in multi-tier Java and J2EE based applications support, responsible for writing business logic using core Java, SQL queries for the backend RDBMS.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys
• Involved in the creation of database objects like Tables, Views, Stored Procedures, Functions, Packages, DB triggers, Indexes using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Involved in multi-tier Java and J2EE based applications support, responsible for writing business logic using core Java, SQL queries for the backend RDBMS
• Performed backend programming for Java applications using JDBC connections.
• Developed JavaBeans, Java Server Pages (JSP), PL/SQL Procedures and Functions to perform business transactions.
• Wrote windows batch scripts, Ant scripts and shell scripts, to automate FTP process to deploy the web application.
• Performed POC using Python to automate manual processes involved in the application flow.

Confidential, WA

Senior Java Developer

Environment: Java, Spring, Hibernate, Eclipse, SVN, Maven, Web Sphere Application Server, Web Services, Jboss, Oracle Database, HTML, Java script, xml, CSS, LINUX, Oracle PL/SQL, TOAD, MS Visio, Win SCP, PuTTY, SOAP UI, Altova XML SPY, Eclipse, SVN

Role & Responsibilities:

• Senior Developer at client location.
• Involved in various SDLC phases like Design, Development and Testing.
• Used various Core Java concepts such as Exception Handling, Collection APIs to implement various features and enhancements.
• Developed server side components servlets for the application.
• Involved in coding, maintaining, and administering Servlets and JSP components to be deployed on a Web Sphere application server.
• Implemented Hibernate ORM to Map relational data directly to java objects
• Worked with Complex SQL queries, Functions and Stored Procedures.
• Involved in developing spring boot frame work for portals application.
• Implemented the logging mechanism using log4j framework.
• Developed SOAP and Rest Web Services.
• Wrote test cases in JUnit for unit testing of classes.
• Used Maven to build the J2EE application.
• Used GIT to track and maintain the different version of the application.
• Involved in maintenance of different applications with offshore team.
• Used to interact with share brokers to do the changes in the code according to their requirements.

Confidential

Oracle PL SQL Developer

Role & Responsibilities:

• Analyzed data to check for Data Integrity and Referential Integrity when loaded to source-staging tables.
• Created tables to capture errors and data that failed Validation Checks.
• Re-validated corrected data from source and re-processed to get them loaded to the oracle target.
• Re-worked on the BAD Files that were generated by SQL Loader.
• Used SED and AWK in UNIX Shell scripting to correct the data issues in the SQL-Loader data file.
• Responsible to write scripts which identify the legacy data and the valid data.
• Created Database Objects such as Tables, Views and Synonyms to provide data access to subscribing parties.
• Created/modified various Packages, Stored Procedure & Functions as part of the data validation and cleansing process.
• Pro-actively participated in SQL tuning, Used ANALYZE, DBMS STATS, EXPLAIN PLAN, SQL TRACE and TKPROF.
• Used SQL hints and Indexes as needed to improve SQL performance.
• Designed and Created Database objects and Written PL/SQL scripts for data extraction and transformation.
• Wrote UNIX Shell scripts for performing development and DBA activities.
• Tested the ETL process in testing environment and created test cases.