Java Sql Server

Objective:

To obtain a Senior Developer position in an organization that can utilize

my strong analytical skills and experience in the field of software design

and development with expertise in Java, J2EE.

Summary:

V Over Eight (8) years of strong Java development experience.

V Sun Certified Java2 Programmer

V Expertise in Distributed computing and Server side programming in

Java.

V Excellent Knowledge of Object Oriented Analysis & Design using UML

V Extensive knowledge of Web protocols and Networking with TCP/IP, JMS,

MDB.

V Extensive experience in Developing Internet/Intranet applications,

J2EE technologies and Java, JSP, JSF, Servlets, HTML, JDBC, Hibernate,

Spring, AWT, SWING, Applet, RMI, Java Beans, EJB, JavaScript, Oracle,

SQL

V Involved in full life cycle development of projects

V Good Experience in RDBMS (Sybase, DB2, Oracle, PL/SQL and Transact

SQL) developing stored procedures and triggers in SQL Server and

Oracle.

V Strong interpersonal/team skills and ability to interact with people

at various levels, Strong organizational skills coupled with high work

ethics, Excellent written and oral communication skills, Capable of

delivering optimized, effective and well documented code

independently, Highly self motivated, eagerness to learn and explore.

Technical skills:

Programming Languages: JAVA, SQL, PL/SQL, VB 6.0, PHP, Perl, C, C++,

UML

Scripting Languages: RUBY, PERL, JavaScript, ANT, VBScript, UNIX shell

Scripting, Bourne Shell

Java Technologies and API: J2EE, Servlets, JSP, JSF, JDBC, RMI,

Swing/AWT, JUnit, SOAP, JSTL, EJB, Hibernate, JNI,

JNDI, Java Mail API, JMock, Drools, Spring.

Application Servers: WebLogic Application Server 6.1/7.x, IBM WebSphere

5.0, Tomcat, JBOSS

Web Servers: Tomcat, Apache, IBM Http Server,

Java Web Server 2.0, IIS

RDBMS: Oracle 7.3/8.0/9i, SQL Server 6.5/7.0/2000, DB2, MS-Access

97/2000

Design Tools: Visio, Oracle Designer 2000, SELECT,

Rational Rose, RUP, EA

Web Technologies: XML, XSLT, HTML, CSS, DHTML, Web

Services, ASP, JDO

Java IDE: WSAD, Eclipse, JBuilder5.0, Net Beans, IntelliJ

Operating Systems: Windows 95/98/NT/2000/XP, UNIX, Sun Solaris,

Linux

Version Control Systems: CVS, Clear Case, SVN

Other Tools & Protocols: RAPID SQL, SQLDBX, Query Analyzer, TOAD, SQR

Brio, PL/SQL Developer, FrontPage, Dream Weaver,

Flash

Education/Certifications:

MS, Computer Science, 2004

Southern Illinois University at Carbondale, Illinois

BS, Computer Science and Engineering, 2001

Nagarjuna University, India

Professional Experience:

Merrill Lynch, Jersey City, NJ Oct '06

- Current

Senior Specialist

Market Risk: The Market Risk application helps in computing the Financial

Risk involved in various positions that are held by Merrill Lynch. The

primary inputs are the risk scenarios as computed and submitted to Risk by

the trading systems, non-scenario risk exposures, historical time series

data used for VaR calculations, trading books and hierarchical rollup from

BookMap, P&L from Finance, and risk limits as specified by risk managers.

Applications are reporting tools that display scenarios, and computes VaR

number using various methodologies on the fly.

Responsibilities:

V Implemented and supported Front end logic for Credit Specific Risk in

Scenario Analysis Tool, which is implemented in Java Swing and

interfaces RiskServer using RMI Calls.

V Enhanced stored procedures to support Risk Server.

V Fixed Bugs in Scenario Analysis Tool, that helps in calculating Risk.

V Improved code to solve memory issues for Scenario Analysis Tool, an

applet based application.

V Enhanced Adhoc Query Tool (AQT) to support Credit Specific Risk which

is a web based application uses JSP, Struts and Dynamic SQLs.

V Working on DB2 Migration project, moving from Sybase to DB2. All the

tables, stored procedures and dynamic SQLs embedded in application

logic converted to DB2.

V Enhanced VaR Back Testing Tool, a tool that displays differences in

Var Number and PNL data. Helps Risk Managers to find exceptions in the

scenarios, to support Credit Specific Back Tests. This application is

also a web based application which uses JSP, Struts, Perl and Shell

Scripts. Modified Perl and shell scripts to help prevent Memory Issues

thrown by RiskServer during batch process.

V Fixed Issues and supported VaR Back testing application during UNIX to

LINUX migration.

V Designed and implemented VaR AddOn Logic in VBT application involving

Feed Server integration.

V Trained offshore team to support VBT application.

V Developed Shell scripts and Perl Scripts to support Batch process

generating multiple reports.

V Handled multiple user requests for all the three applications

simultaneously.

V Improved Stored Procedures to support new features in Risk Server.

V Worked on performance tuning, and brought the timings of few SQLs from

5 hours to 20 minutes.

V Worked on Feed Server, implemented BCM matrix. Supported Feeds

Reporting.

V Implemented Mortgages functionality in Position Viewer application,

which helps in viewing Credit Risk and Mortgages Data. Rewritten

majority of the code to be generic.

Environment : Java 1.4, J2EE, ServletExecAS, Sybase, Oracle 9i, DB2, SQL,

RapidSQL, SQLDBX, PL/SQL, Eclipse 3.2, CVS, RMI, Swing, Perl, Shell

Scripting, LINUX, Struts, Spring, iBatis, XML

Consultant at Arizona State Retirement Systems, ASRS, AZ

Sep '05 - Sep 2006

Senior Developer

Arizona State residents register with ASRS to avail the benefits of various

retirement programs. Four of the key components of the ASRS system that I

worked on were - Demographics, Account Management, Interest Calculation and

Forfeiture. Demographics involved maintaining general member information.

Account Management kept track of all transactional payments made by

customers. The Interest Calculation component computed interest on an

account for each fiscal year based on various business criteria. The

Forfeiture component handled accounts that underwent forfeiture. These

modules comprised both Intranet applications as well as interfaces to the

public website. The Intranet applications were built around JSF and spring

while the interfaces to the public website were developed using EJB and

Struts with JSP. Hibernate was used to interact with the backend database

Oracle. The workflow was implemented using Business Process Management

system.

Responsibilities:

V Designed and developed Audit Service Project from back end to the

front end.

V Designed various projects in Enterprise Architect. Business Logic was

implemented using Java and presentation layer in JSF. Developed custom

tag libraries to facilitate easy data presentation.

V Implemented back end using Hibernate and Spring, modules were tested

using JUnit and DBUnit.

V Prepared Queries to extract insert and modify data using SQL and

projected the query results into XML file for transactions.

V Identified and fixed bugs in Print Request Project code having

functionality of saving and retrieving CLOBs into oracle database,

generating the necessary data files for converting to Adobe PDF and

interacting with various BPM (Workflow) processes.

V Designed and developed enhancements to the Member State Service,

implemented using DROOLS, used by all the applications.

V Designed and developed Interest Calculation service which provided

applications the capability to calculate accrued interest and offset

on all accounts in various scenarios and is tightly coupled with

Accounting Structures.

V Design and Code reviewed applications written for ASRS.

V Did System Analysis to find whether the accounting structures at ASRS

can be integrated with FMS (Financial Management System). Worked on

design and analysis of survivor benefits project.

V Coached/Mentored Junior developers and did code reviews; participated

in resolving production issues.

V Created utilities for HSQL functions for testing using DBUnit.

Environment : Java 1.5, J2EE, Tomcat, JBoss 4.0, Oracle 9i, SQL, XML,

PL/SQL, Web Services, Hibernate 3.0, Spring 1.2, JUNIT, JMock, DROOLS,FIT

Tests, XStream, Eclipse 3.2, Quartz Enterprise Job Scheduler, java mail

API, JSF 1.1, Ruby 1.8.4, SVN, JMS.

Consultant at Major League Baseball, New York City, NY

June2005 - Sep2005

Portal Developer

Drug Testing Project: MLB Players are tested every year based on the team

or club they belong to. The system developed using Portlets provided an

interface to test administrators to enter drug test results, maintain the

records per team basis, and if necessary generate 'Suspension Letters'. The

application was built as a Portal on IBM WebSphere using JSP in a Struts

framework along with Spring and Hibernate to connect to the DB2 database.

Responsibilities:

V Installed Portal Server and set up the environment to use Hibernate

and Spring.

V Prepared Hibernate Mappings, Domain Objects and DataAccessObjects

(DAO) necessary for the project by implementing HibernateDAOSupport

Class.

V Developed JUnit test cases and thoroughly tested the persistent layer.

V Service Layer was written using POJO's, and tested with JUnit test

cases.

V Developed Front end using JSP, Struts and portal tags with wrote

various action classes that get triggered from JSP pages.

V Used Struts /Tiles Controller for supporting the front end in the

portal environment.

V Integrated Struts JSP's on to Portal Server, validated JSP's using

Struts Validation Framework.

V Installed JBoss server for internal applications.

V Maintained the server, deployed applications and participated in

troubleshooting deployment issues.

V Provided solutions to security issues like mapping roles and

applications.

V Used mapping tools like ISeries Navigator to migrate data from

production to test servers for DB2 database.

V Prepared various migration Scripts on DB2 database.

Environment: J2EE, IBM WebSphere Portal Server, Eclipse, Maven, Struts,

JUNIT, JSP, Servlets, Tiles, JavaScript, DB2, LDAP, Hibernate, spring, CVS,

JBOSS.

Consultant at Wells Fargo, Minneapolis, MN

Mar 2005 - Jun 2005

Home Mortgage

This project involved rewriting and enhancing the existing middle and front

end layers (JSP & EJB's) of the system to support the Struts framework that

provided for added customizability.

Responsibilities:

V Developed design documents (Sequence diagrams) using Visio.

V Implemented the presentation layer using Struts framework (JSP, Tiles,

Action, ActionForm, Validation)

V Designed and developed classes to plug-in Struts Common Validation

framework in non Struts legacy MVC ILONLINE application.

V Redesigned and enhanced the Decision Response and Pipeline Detail

Pages using JSP.

V Developed and generated Reports using Batch Processing Concepts.

V Implemented Progress Bar in several web pages using multi threading

Concepts.

V Used Stored Procedures, functions and packages in generating reports.

V Source code control using Clear Case

Environment: Java, JSP, Servlets, XML, XSLT, Java Script, JDK 1.4.1,

Websphere Application Server 5.x, WSAD 5.1.1, Struts 1.2.4, HTML, CSS,

PL/SQL, TOAD, Clear Case, MQ Series, Hibernate.

Consultant at Covansys, Milwaukee, WI

Oct 2004 - March 2005

Retirement Systems (CM)

The Retirement Systems was an in-house project and focussed chiefly on the

functionality of processing payroll for the Retired Personnel and providing

them with pension checks after the deductions (Health Care Tax etc.). This

project strictly followed JClarity Architecture and was developed in a

Struts environment on a WebSphere Server.

Responsibilities:

V Developed and deployed batch programs on JClarity architecture for

different modules

V Used UML to create class diagrams, sequence diagrams, process flow

charts etc on RUP.

V Analysed Design issues and developed programs using Select Component

V Developed JSP's using Strut's tag library, used SQR BRIO was used for

SQR Report Generation

V Developed complicated queries and Stored Procedures in SQL. Modified

and added Business Logic for various components, participated in

fixing and Submitting PIR's (Problem Investigation Reports).

V Generated Letters, Forms and Reports from Batch jobs (JBatch).

V Extensively used various Design Patterns like Singleton, Business

Delegate, Filters etc.,

V Involved in unit, integration and acceptance testing and created the

test data to test the functionality Health care module. Identified

bottlenecks in loading test data and rectified the same.

V Fixed Bugs In Various Components like Tabs consisting of JSP Pages and

Business Logic Code (EJB's)

Environment: Java, JSP, EJB, JavaScript, Servlets, JDBC,, Websphere

Application Server 5x, WSAD, HTML,SQL Server, PL/SQL editor, Query

Analyzer, SELECT, CVS, Struts/Tiles, BRIO SQR Reports

(BioInformatician), Dept of Plant, Soils and General Agriculture, SIUC

May 2003 - Sep 2004

Responsibilities:

V Requirement gathering, Analysis and OO Design using Rational Rose/UML

by preparing Use Cases, Sequence Diagrams, Class diagrams, etc.

V Installed Tomcat Server on windows 2000, Developed and maintained JSP

pages, which are connected to a huge Database (SQL server).

V Normalized new application tables and written complex store procedures

and triggers in oracle.

V Used Eclipse IDE. Validation and checking authenticating users using

JSP and JavaScript

V Involved in developing Business logic, written JAVA code for

connecting to database (JDBC) and retrieving data based on user

specification in the forms.

V Surveyed user's for their feedbacks, added enhancements to the

application and fixed bugs.

V Generated results using an Automation tool (Web Crawler) in Java that

searched a list of websites for specific data and retrieved the data

in flat files, installed GBrowse software (Powerful Genomic Software)

on LINUX

V Setting up Formatting and setting up DNA sequencing data to be GBrowse

Compatible (LINUX, programming in JAVA and PERL).Developed ANT Scripts

to initiate the jobs scheduled, by automation tool

V Involved in the full life cycle development of the software.

Environment: Java Script, JSP, Swings, HTML, CSS, struts, Tomcat Server,

Eclipse, Windows 2000, JAVA, JSP, Servlets, Linux, Perl, PVCS, UML.

Research Asst., Dept. of Plant Soil and General Agriculture, SIUC

Aug 2001 - May 2003

Genomic Research Laboratory at SIUC focused on development and refinement

of genomic sequences. Represented Sequences using GBrowse software and

compared the existing sequences with GenBank database.

Responsibilities:

V Played a key role in organizing and presenting resistant gene data

V Setting up Firewalls on LINUX Systems and Maintenance

V Setting up LAN/WAN and installing various anti-virus software, fixing

old machines and installing software

V Connected the machines to Genetic Sequencers, participated in

troubleshooting the software to produce the results on MAC machines,

design database from the scratch on SQL server

V Involved in maintaining various objects (tables, views, Synonyms,

indexes, Stored Procedures, triggers).

V Designed, developed and maintained various web sites on internet and

intranet.

V Developed Websites on a platform comprising IIS Server, ASP and SQL

Server.

V Used various components of FLASH for adding look and feel to web

pages.

V Two of the sites were built on J2EE Framework, using MVC2

Architecture.

V The presentation layer used HTML, CSS, JavaScript, JSP and Servlets on

Tomcat server.

Environment : SQL, Oracle Forms 3.0/4.5, JDBC, Apache Tomcat 4.x, Jbuilder,

JSP, Java, Perl, Linux/Win 2000, .NET, IIS Server, ASP

Contact this candidate