SUMMARY
2+years of IT experience in developing applications using Java, J2EE technologies, Oracle and SQL Server. Involved in all the phases of a project life cycle including requirement analysis, design, development, testing, deployment and support. Ability to be a good team member and quick learner. Willing to learn and adapt new challenges. Have strong interpersonal skills.

• Experience in Object Oriented Analysis and Design.
• Involved inVarious Stages of Software Development Life Cycle (SDLC).
• Worked extensively on Oracle client/server application tools and RDBMS.
• Well experienced in database development stored procedures/packages, Functions, Table creation scripts & database triggers.
• Good understanding of all three layers of MVC architecture and experience in developing applications using Java, JSP, Java Beans and Servlets.
• Experience in writing Java Script/VB Script for client side validation.
• Experience in J2EE Architecture, Design Patterns and Debugging Techniques.
• Very good understanding of Web Servers like IBM Web Sphere, BEA Web Logic, Apache Tomcat and JBoss.
• Worked on different IDE’s like ECLIPSE, JDeveloper, and Toad.
• Experience in Object Oriented Analysis and Design (OOAD) techniques using UML in Rational Rose, MS Visio.
• Expertise in Database Design, Creation and Management of Schemas, writing Stored Procedures, Functions, DDL, DML SQL queries. Working experience of all three layers of MVC architecture and experience in developing applications using Java, JSP and Servlets.
• Expertise in client side designing and validations using HTML, XHTML, CSS and JavaScript/VBScript.
• Developed PLSQL Packages/procedures to process the data and called from the front end applications using JDBC. (Worked with different drivers)
• Written UNIX Shell scripts for programs and tools.
• Report development experience with Pentaho report designer.
• Experience in STRUTS frameworks.
• Developed Java utilities for the service layer to process the queries and batch update statements against database.
• Excellent interpersonal skills, ability to interact with people at all levels, good communication and presentation skills.
• Experience in using the source control systems like CVS, VSS and TFS (Team foundation server).
• Working experience in Mercury Quality center.

Technical Skills:

Databases:

ORACLE 7/8/8i/9i/10g, MS Access and SQL Server 2000.

Languages:

C/C++, Java, Oracle SQL, PL/SQL, Unix Shell Script, Struts.

Tools/Utilities:

SQL*Plus, TOAD, PL/SQL Developer, SQL navigator, MS Office, JDeveloper, Web Services, Eclipse, Visual studio 2008, Pentaho Report designer.

Workflow Tools:

MS-Visio, MS-Project

Platforms :

Windows 95/98/2000/Me/NT/XP, UNIX.

Testing Tools:

Win Runner ,Mercury Quality center

Version control:

Vss, Clearcase, CVS.

Project Description:

Confidential,Jun 2012- Till Date Richmond, VA
Java/Pl/SQL Developer

Confidential,provides and manages various applications for the schools Education System in Virginia.
Project Description:
In VDOE, each application developed consists of three modules. Application Module, Admin Module and Reports Module.
IDEAMOE:
Individuals with Disabilities Education Act Maintenance of Effort Application (IDEAMOE).
The objective of this project is to create a web based application by which divisions can certify their IDEA Maintenance of Effort and enter exceptions if they did not meet the requirements.
School divisions are required to report all expenditures yearly to provide special education and related services to students with Individual Education Programs (IEPs). These expenditures are reported through Schedule A of their Annual School Report (ASR). This data is used by Special Education Data and Finance staff for the local division’s IDEA Maintenance of Effort (MOE) tests. When a division does not meet at least one of these MOE tests, they have the opportunity to provide exceptions. These exceptions are currently handled manually though an excel spreadsheet. This project is to automate this process and begin capturing the data electronically for auditing and reporting.

• Involved in designing the data model and developed ERD diagram for the application.
• Developed tables for collection window functionality.
• Involved in developing various packages, functions, procedures and triggers.
• Used merge statements to handle bulk insertions and updates to the tables.
• Thorough understanding of MVC architecture and integration between each layer. The application is built based on Struts framework (MVC Architecture).
• Used struts validation, Struts tiles and developed breadcrumbs for the navigation in the application.
• Developed PL/SQL API and java wrappers to enable the role based security for the Department users and division users.
• Developed many Javautilities such as Log Manager and Service layer to support query execution and batch data processing.
• Involved in developing various Form beans, Action classes and view pages using JSP, Java script, HTML, CSS and Ajax.
• Developed generic email wrapper API to send email from all applications using PLSQL.
• Setting up development environment using JDeveloper and configuring it for application development.
• Worked on the Pentaho reporting designer to develop the reports.
• Experience using telnet and FTP tools such as Putty, winscp, cuteFTP.
• Created several views and oracle data extraction utilities for the reports.
• Worked on the performance issue fixes by tuning the queries used in dashboard screens.

Environment: Oracle11g, Sql*plus, Pl/sql, Toad, Jdeveloper, Struts, java, Jsp, JavaScript, Pentaho-Report Designer,UNIX, Oracle Application Server.

Confidential,INDIA. May 2008–Oct 2009
Java Developer

Confidential,manufactures exhaust systems and fabricated tube products such as EGR, charged air tubes, coolant tubes, and exhaust tubes. Involved in Analysis, design, development, testing and user training.

Central Billing Process:

This is developed to handle the distributor tickets served Nelson customers and invoice the customers accordingly.Involved in Requirements gathering and designing the solution for the central bill process.Developed various JSP Pages with security for the users to enter the ticket information received from distributors.Created a process developed using advanced PLSQL techniques to validate the pricing on the tickets.Developed a new process to Invoice the customer and give the credit to Distributor.Created various reports for the users to review the batches processed and distributors served.Involved in designing the database design to efficiently store the data.Created various error handling scenarios and handled using sending emails and notifying users.

Rebate Processing System:

This system is developed to handle the Rebates for the customers. This allows users to define various rebates at the customer level and product group level. If the customers reach a target amount, Nelson needs to pay the rebate to the customer.

Involved in the database design for the rebate process system implementation.Developed rebate setup screen to define the rebate definition for the customers.Created JSP pages to view the rebate information and other master information like Customers/Items.Developed a process to calculate the rebate amount based on the sales for the customer over the specified period in the rebate.Worked on various reports to review the payments made and rebates processed.Developed a process to issue rebate checks for the customers.

Responsibilities:

• Development of registration module using Struts framework.
• Presentation layer development using JSP, JavaScript, HTML for registration Page.
• Used JSP, Tiles (Jakarta), HTML and CSS for developing views.
• The client side validations were done using Struts Validator framework.
• Involved in Configuring Web.XML and struts-config.xml according to the strut framework.
• Mainly worked on database side to create tables, views to store product details.
• For accessing data from database wrote SQL statements in Java programs using JDBC connectivity.
• Coded all required Procedures, Functions and Packages for (client and server side) back end.
• Developed several stored procedures, functions, cursors and triggers using PL/SQL for application database and business reporting.
• Design presentation layer using Java script, and Struts tag libraries.
• Handle production support issues, providing time estimates and resolutions.
• Wrote use cases for functional requirements
• Development Testing and integration testing of various modules.
• Deployment of the application using ANT.

Environment: JAVA/JSP, DAO Design pattern, Toad, Eclipse, Struts1.1, HTML, XML, Oracle 10g, VSS, UNIX.

Education:

• Bachelor of Science (B.Sc)
• Master of computer applications (MCA)