EXPERIENCE SUMMARY:

• Over 10 yearsof programming experience as anOracle PL/SQLand Java Developer/Lead in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Involved in all phases of theSDLC (Software Development Life Cycle)from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience withData flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelinganddesign 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 Oracle12c/11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOADandSQL*LOADER.
• Effectively made use ofTable, Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-WriteandTransportable table spaces.
• Good knowledge on logical and physicalData Modelingusingnormalizing Techniques.
• CreatedTables, Views, Constraints, Index(B Tree, Bitmap and Function Based).
• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• CreatedPackagesandProceduresto automatically drop table indexes and create indexes for the tables.
• Experience in SQLperformance tuningusing Cost-Based Optimization (CBO).
• Good knowledge of key Oracle performance related features such asQuery Optimizer, Execution PlansandIndexes.
• Experience withPerformance Tuningfor Oracle RDBMS usingExplain PlanandHINTS.
• CreatedShell Scriptsfor 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

Environments: 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,Long Beach, CA

Senior Java and Oracle PL SQL Developer

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.
• DevelopedPL/SQL triggersandmaster tablesfor 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 likeToad, PL/SQL DeveloperandSQL* plus.
• Created scripts to createnew tables, views, queriesfor new enhancement in the application using TOAD.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• Extensively involved in usinghints to direct the optimizerto choose an optimumquery execution plan.
• UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Createdrecords, tables, collections(nested tables and arrays) for improving Query performance by reducingcontext switching.
• UsedPragma Autonomous Transactionto avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL likeRecords, Tables, Object typesandDynamic SQL.
• Handled errors usingException Handlingextensively 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,Bellevue, 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

Project 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

Environment: Windows 7, LINUX 5.8, Oracle PL/SQL, Oracle Forms Developer, Reports Builder, TOAD, Informatica PowerCenter 8.6, MS Visio, Win SCP, PuTTY, VNC Viewer, SOAP UI, Microsoft Visual Studio Team Foundation Server (TFS), Altova XML SPY, Java 7, J2EE 6, Struts 2.0, Spring 3.x, MySQL, Hibernate 3.0 HTML 5, CSS 3, JavaScript, jQuery, Linux, Eclipse, SVN

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.