SUMMARY

• Proficiency in Object - Oriented Programming concepts
• Well-versed wif Java and Java EE platforms, PL/SQL and SQL, and Unix shell scripting
• Hands-on experience wif Jsps, Java Servlets, Java Beans, EJB, JDBC, DAO and MVC design pattern for web application
• Diverse experience wif Oracle database and application development including installation of Redhat Enterprise linux operating system, database creation and configuration, data modeling, writing stored procedures, functions, triggers, and complex SQL queries, performing unit testing, exception handling and performance tuning
• Good knowledge of Javascript, Angular JS, JQuery, XML, XML Schema and DTD, HTML, and CSS
• Knowledge of web services (WSDL, SOAP), and RESTful web services
• Proficiency in using Struts and Spring frameworks to develop web applications
• Expertise in object relational mapping (Hibernate framework)
• Self-motivated, Detailed-oriented and well-organized
• Exceptional analytical and trouble shooting skills
• Passion for learning new knowledge and strive for excellence
• Excellent communication skills

TECHNICAL SKILLS

Languages: Java, SQL, PL/SQL, HTML, DHTML, JavaScript, XML, UML

J2EE Technologies: JSP, Servlets, JSTL, JDBC, Ajax

Frameworks: Apache Struts, Spring, Hibernate, JUnit

Application/Web Servers: Apache Tomcat

Web Services & XML: XML, XSL, XSLT, SOAP, WSDL, SAX and DOM parsers

IDE/ Tools: Eclipse, Toad, Ant, SQL Developer, SQL*Loader, SQL*Plus, Putty, DBCA, Erwin, WinSCP, SFTP, VI editor, EditPad, Data Pump

RDBMS: Oracle 11g

OS: Windows XP/7/10, Linux

Version Control: Subversion, Git

PROFESSIONAL EXPERIENCE

Confidential

Java Developer

Responsibilities:

• Performed functional testing of 16 modules thoroughly, finding defects and remediating them
• Involved in teh collection and analysis of user requirements
• Participated in technical design and code reviews
• Involved in teh development of registration, login modules and student information management system
• Developed student summary, student grades reporting, teacher profiles modules
• Using form beans to encapsulate and validate user input data
• Using Hashmap to store errors arising from validation of user inputs and display them back to teh user in jsp pages
• Developed utils wif generic methods to populate data from a request object to a form bean and then copy valid data from form bean to data model after passing validation
• Developed a small web framework using a controllerServlet as a single point of control for handling client requests and dispatching them to teh corresponding methods in action classes by mapping request uri to annotated action classes and request parameter to teh method for back-end application
• Utilizing Singleton pattern, factory methods, reflection API, java beans, Jsp, Java servlets, ognl expression, and Data Access Objects to develop applications for dynamically loading teh corresponding objects and also making modules loosely coupled
• Involved in developing employee performance assessment and salary raise application. Spring framework (Dependency Injection, annotation, transaction management and AOP) wif POJOs was used to deliver service and Hibernate was used to implement database access layer
• Developed student report cards application. Developing jsps, java servlets for teh web front end and session bean service for back end to access database
• Executed unit tests using JUnit framework
• Implementing stored procedure calls in JDBC applications
• Involved in teh application deployment on Apache Tomcat Server
• Creating tables, views, and indexes
• Creating and maintaining packages, stored procedures, functions and triggers
• Using SQL*loader to load data to oracle database from flat files obtained from various facilities

Confidential

Database Developer

Responsibilities:

• Installing and configuring Oracle 11g database on Redhat Enterprise Linux
• Performing Oracle network configuration and manually configuring listener.ora, tnsnames.ora, sqlnet.ora to enhance network performance
• Performing database file management: adopting OFA file directory paths to ease file management relocating datafiles, configuring multiplexed control files and multiplexed redo log files, and managing teh archive log destination
• Creating users and profiles wif assigned resource limits and using audit session to tune teh application performance
• Modifying teh database parameters, creating spfile from pfile, creating teh password file
• Bouncing teh database wif various options, configuring and managing teh OEM database control service
• Tracking alert log and trace files to monitor activities occurred wifin database or at session level
• Creating locally managed tablespaces wif defined storage options
• Creating normalized and unnormalized tables wif various types of indexes, creating and managing table partitions, and relocating tables to different tablespaces
• Identifying and rebuilding fragmented indexes to improve teh performance
• Managing sequences and implementing triggers to assign teh sequence value to a table column
• Loading data to tables using SQL*Loader
• Using DATA PUMP to import / export database, schemas or a list of tables
• Implementing anonymous PL/SQL blocks and shell scripts batch jobs
• Creating PL/SQL programs using cursor, record, collection and cursor variable
• Creating and maintaining PL/SQL procedures, functions, packages and triggers
• Gathering statistics at teh database, schema and table levels using dbms stats package
• Setting up Autotrace in SQL*Plus to generate teh execution plan of teh SQL statements
• Generating AWR report for database performance review
• Creating materialized view and materialized view log
• Using SFTP to transfer files
• Using transportable tablespaces and external tables for data warehouse ETL operations
• Creating indexes and partitioned tables to enhance query performance
• Using BULK COLLECT, FORALL, pipelined table function and dynamic sql in pl/sql blocks to improve performance
• Using hints to improve sql query performance
• Tuning PL/SQL performance using DBMS PROFILER
• Using EXPLAIN PLAN, SQL TRACE and TKPROF for SQL performance tuning
• Using UTL FILE package to extract data from database into flat files
• Writing Unix shell scripts and using crontab scheduling for automatic data loading from flat file to oracle database tables