Java Oracle

Amit Sethi

*********@*****.***

516-***-**** (C)

SUMMARY

* ***** ** ******** *********** experience that includes requirement analysis, designing

•

and implementing, high performance, scalable object oriented software systems using

Java, XML, and Oracle.

Extensive experience in Internet, e-Commerce, CRM based applications.

•

Experience in designing, developing multi-tier application using J2EE (RMI, Servlet, JSP,

•

Velocity, WML with custom tags, JDBC, Java Mail, JMS) technology, Struts 1.2,

iBatis.

Experience with web/application servers as Web Sphere, Web logic, JWS, Apache and

•

Tomcat.

Experience in SSL implementation in Internet based application.

•

Experience in Designing database and Developing Oracle Stored procedure, Trigger using

•

PL/SQL, SQL, Java in Oracle8i, 9i.

Possess strong problem analysis skills with ability to follow project standards and

•

procedures as per client specifications.

Evaluates stated requirements and expectations in terms of technical feasibility and cost

•

outcomes.

Ability to work both individually and in team environments.

•

Excellent communication and interpersonal skills.

•

CORE TECHNICAL SKILLS

- Java/JSP/Servlets - J2EE - Ruby on Rails - Websphere

- Tomcat/Apache - Windows/Linux/Unix - SQL Server - Oracle/Mysql

Struts - HTML /XHTML/XML - JavaScript - CSS

-

- Oracle CRM/ERP - Ajax - Google Maps - iBatis

- Adobe Flex - Spring - Hibernate

INDUSTRY

- e-Learning Portals - Manufacturing - MLM - Insurance

- Education - Communication - Hotel - Aerospace

- Law

SUMMARY OF SKILLS

Languages : Java, SQL, PL/SQL, XML

RDBMS / Database : Oracle 9i, SQL Server, DB2 8.1, Access, Mysql

Web-based : JSP, Servlets, EJB, JDBC, Java Mail, JNDI, JMS, J2EE, Ruby on Rails,

Flex

Operating System : Windows, Linux, Unix, MS DOS

Application Servers : Web Sphere 3.5/4.0/5.0/5.1, Web logic 5.0/6.1/7.0/8.1.2

Web Servers : Apache, IBM HTTP Server, TOMCAT, IIS

Third Party Tools : Ant, BugZilla, FileZilla, VMWare, Dream weaver, Ultradev6.0

CVS, Accurev, ClearQuest, CruiseControl, Subversion

Version Control :

MVC : Struts 1.1, Struts 1.2, Spring 2.5

IDE : Eclipse, NetBeans, jDeveloper, IBM RAD

ORM : iBATIS2.3, Hibernate3.X

Education & Certifications

Information Technology Infrastructure Library (ITIL) - 2009

•

Sun Certified Enterprise Architect – (SCEA) 1.4 - 2008

•

IBM Service Oriented Architecture (SOA) - 2008

•

Programming with PL/SQL, Oracle 9i (OCP) - 2006

•

Introduction to Oracle 9i - 2006

•

Microsoft Certified Solution Developer (MCSD) - 1999

•

Diploma in Computer Science, GNIIT (NIIT), Delhi, India (Duration 3 yrs) -

•

2000

Bachelor Degree in Commerce, Delhi University, India (Duration 3 yrs) - 1999

•

Projects

Employer: Sierra Systems Inc

Department of Corrections (DOC), WA 12.15.2008 – Present

Lead / Sr. System Analyst

Project Summary:

The State of Washington Department of Corrections is responsible for administering adult

corrections programs at the State’s 15 major prison facilities and 147 community field offices,

community justice centers, and Community Oriented Policing (COP) Shops across the State.

The Department employs approximately 8,000 men and women and has a current biennial

operating budget of $1.5 billion.

The management of the Department’s operations includes a number of information technology

applications and services and for over 25 years much of that has centered on a large and

complex offender management system. That offender management systems architecture and

technology has proven difficult to change as the Department’s business needs have evolved

over time.

Responsibilities:

Application Development.

•

Involved in design and implementation of major modules such as Sentence

•

Information and Prison Movements.

Sentence Information calculates the offender sentence based on infractions and

•

RCW’s. This is the most complex module of the application.

Prison Movements tracks the offender prison history, movements, temporary

•

absence.

Improved performance of reports and tuned queries.

•

Defect fixing.

•

New enhancements after launch.

•

Send messages to State Patrol through System Interface using JMS.

•

Communicate and work with associates on cross functional team.

•

Prepared Requirements/Use Case/Design/Test Case documents.

•

Writing jUnits and Selenium Tests.

•

Environment: Spring, Hibernate, Java 1.4.2, DB2 8.1.14, JSP, Java Bean, JMS, HTML, CSS,

JavaScript, Eclipse Rational RAD 6.0.1, ClearQuest 7.0.0.0, Unix, JSTL, Ajax, Web Services.

Fluke Corporation, WA 01.02.2007 – 11.30.2008

Onsite Lead / Sr. System Analyst

Project Summary

Oracle 11.5.8 and 12.0 CRM and ERP Application maintains information about Lead,

Opportunities, Forecasting, Customer Information, Contacts, Distributors,

Partners information.

Responsibilities:

Develop solutions to expand seeded system functionality and enhance performance.

•

Involved in technical design and architecture.

•

Responsible for configuring roles, responsibilities, team structure, group for users in

•

various countries like China, Europe, US required for Oracle CRM system.

Prepare system and report specification.

•

Evaluate new technologies and make recommendations.

•

Analyze and resolve Production Support and New Service Requests.

•

Communicate and work with associates on cross functional team.

•

Implemented Ajax and Google Maps with current CRM module based on users

•

territories revenues. This effort saved the company a big chunk of time and

money.

Improved online reports performance. Users and higher management were

•

relieved to see high performance reports and attracted users to come online.

Onsite Lead Coordinator, with experience of handling 6 members in offshore

•

team.

Environment: Oracle CRM, Sales and Marketing Modules, Human Resources Module,

Incentive Compensation Module, Java, JSP, JSF, Java Bean, HTML, CSS, JavaScript, Google

Maps, Ajax, Apache, CVS, Oracle 9is, Oracle Application Framework (Java based), Adobe Flex,

Ruby on Rails, Web Services.

Boeing, WA 11.12.2005- 12.31.2006

Sr. Programmer Analyst

Project Summary

A web based Central Customer Information Database (CCID). The application maintains

customer data including their addresses, phones, contacts, contact addresses, contact phones,

line of business, hierarchies, notes, team & support, events, distribution lists and tracks

account for each airline with respect to types of planes.

Responsibilities

Reviewed and analyzed existing system for converting it to Java based application.

•

Made conversion programs for converting data from existing DB2 database to Oracle

•

9i.

Involved in design and architecture.

•

Developed tool for clients to add/change data online using MVC architecture Struts

•

1.2, Servlets, JSP, Velocity 1.4.

Made module for Events and Distribution Lists for customers, which include their

•

addresses, contact information. Sales VP’s and Directors use this module to invite their

contacts to particular event like air shows, send distribution letters.

Developed Online Reports for customers to extract data online and convert it to

•

csv/excel format.

Developed Jsp, Velocity, Value Objects, DAOs, Custom Tag Library Classes and

•

Request Mapping and Screen Definitions XML files.

Made application compatible with cross browsers.

•

Prepared Requirements/Use Case/Design/Test Case documents.

•

Refactoring of tiles-defs and strut-config and source code.

•

Applied JavaScript validations using Validators.

•

Designed the layout of application using style sheets, reusable code.

•

Environment: Struts 1.2, JDK 1.2, JSDK2.0, JavaScript, JSP1.0, HTML4.0, DB2 Server,

Oracle 9i, Sybase, ssiBatis 2.1, Tomcat 5/Apache Web Server, Apache Ant 1.6.5, jUnit, Eclipse

3.1, Web Services, SOA, Ruby on Rails, Ajax, CVS, XML, Java Script, Velocity.

CIFT, UK / India 09.24.2004 -11.07.2005

Team Lead/Sr. Web Programmer

Project Summary

Worked on various banking e-Learning web based applications for banks like ABN AMRO,

WESTLB, SG CIB, Framlington, RBC, Dryden, Bank of New York, and American Express.

Responsibilities

Designed and developed application using Java, Servlets, Jsp’s and employs MVC

•

architecture, Business Delegate, Value Object and DAO design patterns

Prepared Requirements/Design/Test Case documents

•

Developed Jsp’s, Servlets, Model, Event, Custom Tag Library Classes and Request

•

Mapping

Designed and normalized database-using oracle 9i.

•

Created tables, views and wrote stored procedures, triggers using PL/SQL.

•

Created database connection classes using JDBC.

•

Online Reports based on unique Bank ID that can be downloaded in excel /css format.

•

Testing.

•

Cross Browser Compatibility web application.

•

Lead a team of 5 people in Delhi NCR Gurgaon office.

•

Developed custom extensions to CRM using Oracle as backend.

•

Environment: JAVA 1.2, JSP, EJB, Servlets, Java Beans, Java Mail, HTML, CSS, DHTML,

JavaScript, Tomcat, Apache, JDBC/SQL and Oracle 9i, MySql, Unix, Net Beans, Accurev.

Kurosoft Ltd, Delhi India 03.01.2001 - 09.23.2004

Java Developer

Project Summary

Worked as a trainee, software developer. Developed web applications for clients based in

Bangkok and Thailand.

Responsibilities

Development of external interfaces in Java including file processing and database

•

transactions.

Designed attractive and flexible user interface using Dream weaver with JavaScript

•

validations.

Performed software troubleshooting and monitoring functions for an extremely high

•

transaction rate application.

SSL implementation for quantumstore.

•

Development and Testing of Code and Reports.

•

Written Component Model using java beans for common business logic, custom tag

•

libraries and auto mail responder using servlet and java threads.

Supporting the quality assurance process.

•

Testing and implementation.

•

Environment: JDK 1.2, JavaScript, JSP1.0, ASP, HTML, My SQL 4x, MS Access, Oracle,

Apache Web Server, Linux 6.2, CVS, IIS.

Contact this candidate