Oracle Developer

Soundarya Pejjaye

********@*****.*** 703-***-****

OBJECTIVE

I am an Innovative, Self-Motivated, and Results-Oriented Software developer eager to contribute significant technical, interpersonal and web development expertise toward supporting a dynamic employer in achieving goals and objectives.

SUMMARY

• More than four years of IT experience in designing, developing n-tier web applications and client / server applications.

• Experience in all aspects of the Software Development Life Cycle, with the ability to work and communicate effectively.

• Experience in developing applications using Java, J2EE, EJB, Strut, Spring, Servlets, JSP, JAXP(DOM/SAX), .NET, Hibernate and JDBC

• Experience with HTML, XML, XSLT, AJAX, Xschema, Java Script and Windows platform.

• Worked on different IDE s like Eclipse, NetBeans, JDeveloper.

• Good experience in coding SQL, PL/SQL stored procedures and Packages.

• Strong experience in Oracle, SQL Server, PostgreSQL, MySql, database programming using PL/SQL and standard built-in Oracle Packages

• Hands-on experience on Oracle development tools such as TOAD, Oracle SQL Developer.

• Experience in developing Enterprise software applications using Application servers such as JBoss.

• Worked on understanding User/Business needs and built tailored solutions as per needs

• Experience in testing to ascertain the quality and standards of the application.

• Good understanding of JMS, JavaMail and Web Services.

• Innovative and ambitious looks at every opportunity with optimism

• Can team up and work with people from diverse background and also resilient under any sort of pressure and deliver a quality job on time.

EDUCATION

Masters of Science in Information Systems, George Mason University May’10 GPA 3.81

Bachelor of Engineering in Information Technology, O.U. India. May’08 GPA 3.92

TECHNICAL SKILLS

• Languages : C, C++, Java, Vb.Net, C#.

• Java/J2EE Technologies : J2EE, JSP, Servlets, EJB, Struts,Spring, JDBC, JUnit, Log4j.

• Database : Microsoft Access, SQL Server, Sybase, Oracle, PostgreSQL, MySql.

• Application Servers : JBoss

• Web Server : Apache Tomcat

• IDE : Eclipse, NetBeans ,Toad ,SQL Developer ,Visual Studio 2008

• Operating Systems : MS-DOS, Windows NT/2000/XP,Linux, Windows 7.

• Design Tools : Rational Rose Enterprise, Microsoft Visio.

• Web Technologies : HTML, XML, CSS, XSD, XSLT, JavaScript ,JSON.

WORK EXPERIENCE

Tetra Tech,VA June'10-Present

Programmer Analyst

CalWQA (California Water Quality Assessment Database)

A New Database that enables the State of California to accurately report and interpret water quality conditions and provide a clear picture of existing water quality in the State.

Key Responsibilities:

• Involved in Analysis, Design, Development and Testing phases.

• Worked closely with functional analyst and gathered client requirements, analyze the feasibility and prepared the technical documentation.

• Member of core development team which developed Customer user interface.

• Application is based on MVC pattern and designed and developed web components using JSPs and Struts framework.

• Worked on different J2EE Design Patterns such as Session Facade, Service Locator and Singleton.

• Developed / Implemented XML schema for validation of XML documents.

• Extensively used MVC Architecture to isolate each layer of the application.

• Developed Ant build scripts.

• Used JPA over Hibernate for access to Oracle database.

• Involved in unit testing, system testing, and user acceptance testing of the application.

• Deployed the application in JBoss application server.

• Used SVN as a version control tool and Mantis for defect tracking.

• Involved in bug fixing and production support.

Environment : Java, Java / J2EE Patterns, JSP, Struts, JDBC, XML, Jboss, Oracle , SQL, ANT, UML, Eclipse, TOAD, HTML, MS Visio, SVN, Mantis.

NNEPA(Navajo National Proposal)

Customized the NetDMR application to handle NetDMR flow and basic permit and limit information. Produce an ICIS-NPDES compliant XML for the DMR data family that can be used by NNEPA to be submitted to EPA.

Key Responsibilities:

• Involved in gathering of Requirements, Design, Analysis, Coding and Unit Testing.

• Mapped the NNEPA permit information with the Basic permit, Limit, Limit set schemas of

ICIS-NPDES.

• Developed mock up for the design document using Creatly.

• Used Spring Framework MVC for application development.

• User Interface was developed using JSPs,Javascript.

• Deployed application on JBoss Application server.

• Used Hibernate O/R mapping for communication between the Front end and the database.

• Used Log4j for logging and debugging statements.

• Worked closely with Business users during UAT testing.

Environment: Eclipse Helios, Spring Framework, Hibernate, JSPs, JBoss, Windows XP, Oracle, XML, XSLT, HTML, CSS,CVS.

US Geological Survey, VA May'09-May'10

Computer programmer

Mineral Resource Data System (MRDS) project

The primary objective of the Mineral Resource Data System (MRDS) project is to provide an up-to-date database of mineral occurrences, including their locations and attributes, for easy use by USGS staff as well as by the general public.

Key Responsibilities:

• Involved in gathering requirements from end user, analysis, design, development and testing phases.

• Modeling the project solution using UML with Object Oriented Analysis and Design concepts.

• Implemented Client- Server application using Struts MVC Framework.

• Used Hibernate object-relational mapping framework to create the data model.

• Developed Front End using JSP,HTML, Javascript,CSS.

• Developed / Implemented XML schema for validation of XML documents.

• Developed web pages using XML and XSLT.

• Used an XML DOM Parser in order to parse the XML results.

• To maintain consistent look and feel Cascading style sheets (CSS) are created.

• Tested the application thoroughly before releasing it to the users.

Environment: Java, JSP, Servlets, Struts, Tomcat ,Ant, HTML, SQL ,JavaScript, Eclipse, JSON, WindowsXP, Xml, PL/SQL, XSD, XSLT, Oracle, SQL Server, PostgreSQL, MySql,CSS, Microsoft Visio.

George Mason University ,Virginia.

Database Developer Aug’ 08 –April’ 09

Worked as a database developer at School of Management, GMU. Responsibilities include requirements gathering, analysis, design and development of database.

Key Responsibilities:

• Responsible for developing advanced stored procedures, triggers and complex query to implement business logic and rules

• Responsible for performing data mining and/or producing SQL reports

• Responsible for coding Oracle package and procedures.

• Work with QA team to verify data migration and data quality.

• Work with Database Engineering team to tune SQL code for performance.

• Enhance existing SQL code.

• Assist in ad hoc projects, assignments and provide solutions using SQL and backend Oracle databases.

Environment: Oracle, MS Access, MySql, Win 2000.

Virtusa Pvt Ltd, Hyderbad, India

Application Developer Intern May’ 07– Jun’ 08

Sales Business Flow Integration

This project aims to automate all the processes that triggered because of a Sales Order. In this project there are 3 types of users that will interact with this application. They are Administrator, Customer and Supplier.

Key Responsibilities:

• Involved in analyzing the requirements, drafted use cases and created UML class and sequence diagrams.

• Used APIs of Java SQL and Struts framework extensively.

• Involved in the front-end dynamic screens using Struts, JSP, JavaScript, HTML and CSS.

• Used Java and JDBC APIs for database access.

• Written complex SQL queries, PL/SQL Stored procedures, Triggers and Packages to handle the problems arising in a distributed database environment.

• Used Eclipse for Java as IDE tool.

• Deployed application on Tomcat web server.

• Performed unit testing and system testing.

Environment: Eclipse, Java, Struts, JSPs, Tomcat, Oracle, Windows, Oracle, XML, XSLT, HTML, CSS, MS Visio.

ACADEMIC PROJECTS :

Bank Application

Description:

Developed a Web Based Application where a user can update the User Profile, Cash Transaction, check the account Deposit/Withdraw Cash details and display transaction report for particular time period.

Key Responsibilities:

• Involved in gathering of system requirements, performed design and analysis as per end user.

• Design and development of the Modules pertaining to user profiles, transaction business logic, cash and transaction details using JSP, SERVLETS.

• Design of Oracle database with respect to the different modules.

• Writing stored procedures & triggers in PL/SQL.

• Conducting validation tests of the databases.

Environment: Java, JSP, Servlets, Tomcat, JDBC, Oracle, PL/SQL & Windows 2000, JavaScript, HTML, Microsoft Visio

Human Resource System

Description:

As a Java programmer at school I developed Human Resource application using J2EE technologies. This application provided user the capability to search for employees based on Name or their SSN and also displays their profile, payroll information.

Key Responsibilities:

• Involved in all phases of SDLC Requirements gathering, Design, Analysis, Coding and Testing.

• Leveraged Use Cases and Sequence diagrams to show business and process flow.

• User Interface was developed using JSP and Struts.

• Used Struts for MVC architecture of the application.

• Used JDBC for storing and retrieving user data into and from Oracle database.

• Written complex SQL queries to retrieve data from Oracle database.

• Application was deployed to Tomcat web server.

Environment: Java, JSP, Struts, JDBC, Tomcat, Oracle, SQL, UNIX, Microsoft Visio, Windows XP.

General Store application

Description:

General Store application is a Web-based, e-commerce application that let the customer to browse products, find products, maintain account, maintain cart, and create order.

Key Responsibilities:

• Involved in Analysis, Design, Development, and Testing phases.

• Involved in application development using JSP, EJB and MVC pattern.

• Front-end application development was done using HTML, JSP.

• Developed the bean components like Session Bean to implement business logic.

• The back end consisted of the Oracle database and the connectivity was done using entity beans (JAVA Persistence API).

• Developed Ant build scripts.

• Used JUnit to write Unit test cases.

• Deployed the application in JBoss application server

Environment : Java, JSP, EJB, JDBC , XML, JBoss, JUnit, Oracle, SQL, ANT, UML, Eclipse, TOAD, HTML, MS Visio.

REFERENCE:

Reference provided on request

Contact this candidate