App. database Support Engineer

Several Years of experience as Application Support Engineer, Developer and tester on small and large applications
Strong Experience in Software Development Life Cycle (SDLC)
Excellent experience in writing data queries using SQL's and also stored procesure and functions using PL/SQL.
Good experience in supporting the end users of business applications.
Good experience in functional testing using various techniques and also tracked test plans, cases and defects using HP-Quality Center.
Good inter-personal communication and analytical skills
Good experience using Weblogic and Websphere Application Servers
Results-oriented, self-motivated, and willing to assume responsibility
Good Testing Experience in Internet, Intranet, Distributed Systems and Messaging Middleware

RELEVANT EXPERIENCE/TECHNOLOGIES/SKILL SETS:-
1.Java, J2EE, Servlets, JSP, JMS, RMI, JDBC, Applets, JTA, and JNDI
2.MQ Series, MQSI, MQ Workflow, C++, VC++, VB, ASP, COM/DCOM, ADO, Rouge wave tools.
3.JavaScript, XML, SOAP, HTTP, Weblogic Server, WebSphere Server, AXIS Framework for Web services, ASP, VBScript, IIS and Apache Server.
4.Oracle 8/7.x, Sybase, MS-SQL Server, T-SQL, PL/SQL, Pro*C, DB2
5.Methodologies, Object Oriented Programming, OOD, Multi-Threaded programming, Rational Unified Process (RUP) UML, Rational Rose, Requisite Pro, Erwin, Visio, and Power Designer
6.Unix 10.2, Solaris 2.5, 2.6,O.S.F. Ver. 1, and Windows NT/2000.

PROFESSIONAL EXPERIENCE:

Employer\'s Name: Confidential, NJ.
U.S. based Co. with 70 staff members consisting of: Software Engineers, Programmers, and Architects. Confidential provides Software Development Services to investment banks such as Citigroup, JPMC, Morgan Stanley, Bank of America etc. We specialize in fixed income, equities, derivatives, brokerage account opening and servicing systems.
Confidential is in the business of building and maintaining Technology Solutions, in using technology to solve day to day business problems, using technology for day to day business operations especially in the investment banking space. Company helps clients grow, reduce operational costs and increase operational efficiencies.

June 2003 to December 2010.
Role:Consultant/Application Support Engineer
Client:Confidential
Environment: Java, JSP, Servlets, EJB, Struts, Spring, Hibernate, AJAX, JavaScript, JavaBean(JB),AXIS Framework for WebServices , C++, SOAP, WSAD, IBM-Websphere, iPlanet Web Server, HTML, DHTML, XML, Oracle, DB2, SQL/PL-SQL, Unix, Perl, ksh, vi Editor, Windows NT, Rational Rose, UML, MS project, PlanView, PVCS, HP Quality Center , and SCCS.

Description Confidential is a web based brokerage new account opening and servicing system. It supports varies types of brokerage accounts such as personal, trust, partnership, corporation, retirement, 529 plan, retirement or pension plans and also managed or advisory flavors.
Responsibilities:

• Involved in Requirements gathering, Requirement analysis, defining scope for application support methodology, Design analysis, impact analysis, development, Integration and deployment.
• Supported web based applications using JSP, Servlets, JavaScript, AJAX, Struts Framework, HTML, XML, and DHTML.
• Designed and wrote stored procedures and functions using PL/SQL
• Coded dynamic SQLs to retrieve data from Oracle and DB2 for reporting purpose.
• Interacted with End Users to answer their questions in day to day operation of brokerage Account Opening and Maintenance Work Flows.
• Wrote scripts using PERL and Korn shell ( Ksh).
• Optimized logging system using Log4J to log all kind of information, debug and critical errors to help production support personnel.
• Involved in creating traceability Matrix from Requirement analysis to High Level design (Use cases) to low level design to Code to Test Case.
• Planning and tracking using MS Project Plan.
• Involved in project portfolio management using PlanView.
• Supported integration testing and UAT on various small and big initiatives for number of users.
• Coordinated with Off Shore team and got the work done.

Employer\'s Name:Confidential
DurationMarch 2002 to June 2003
Role:Enterprise Application Developer/Software Engineer
Client:Confidential
Environment: JDK 1.2, J2EE, JSP/ Servlets, C++, CORBA, EJB, PL-SQL Procedures, Weblogic, Jbuilder , Rational Rose, RUP, UML, MS Project. Oracle, SAP, Sybase & UNIX.

Description Confidential was developed for Investment Banking Institute. This application provides Funding/Risk Analysis, Fixed Income Investments, Fixed Income Securities, Fixed Income Instruments, Derivatives, and Asset Securitization and guides the client to achieve their various financial goals. This is a 3-tier application based on J2EE architectural specifications. The presentation layer consists of GUI, which is built using JSP/Servlets/XML/HTML. The business tier consists of Java, CORBA code servers, which are hosted on Unix. The back end is Sybase and Oracle.
Responsibilities with functional Description

• Designed, developed and implemented code using Java, CORBA, Oracle and JDBC for Four major modules.
• Worked on Full Software Development Life Cycle (SDLC) using Rational Unified Process (RUP) Methodology
• Each module has approximately 10 to 15 sub-modules.

Fixed Income Investments: developed modules for Provincial Bonds, Corporate Bonds, Stripped Bonds, and Term Deposits.
Various sub-modules under Fixed Income Department: Asset Management, Stock Research, IPO Center, Mutual Funds, IRA Accounts.
Financial services: Institutional Services, Broker/Dealer/Banks.
Also implemented modules involving Fixed Income securities serving the needs of Broker/Dealer/Registered Representatives:
Fixed Income Securities (FIS), provides comprehensive services related to Bond Market investment including, preparation of custom bonds, portfolios, analyzing and purchasing Bond market investments.
FIS, is a large database providing Municipal Bonds, Corporate Bonds, Government Bonds, agency Bonds.
Various sub modules: Bond Offerings, CD Offerings, Daily Rates, B/D Services.
Involved with groups that implementing modules for Fixed Income Instruments: includes Zero coupon bonds, Yield to maturity, Treasure security and markets, Treasure Bill quotations and pricing, Bond equivalent yield, Treasury bond pricing, Interest accrual.
Contributed to modules for Derivatives:
Various sub-modules for risk management procedures for Foreign Exchange forward Contract, Financial future contracts, First Swap contract like , Interest Rate Swaps (Fixed / floating rate swaps), Current Swaps etc.,
And Asset Securitization involves different modules for credit card receivable, medical receivables, trade receivable and student loans.
Used JavaServlets, Applets and HTML for the modules to interact with other dependency applications like Mutual Funds, Market Data, Money Market etc.
All the above business objects are developed using Java and C++, Corba Technology

• Oracle back-end development which included writing stored procedures, SQL scripts, triggers, views, and database designs

Employer Name:Confidential
DurationSep 2000 to March 2002
PROJECT :Inventory Support System
Technologies:Borland C++, C ,Oracle 7.1 RDBMS Unix .
Role : Programmer
The company was providing and maintaining inventory support to many different companies who subscribe magazines. Designed inventory reports system product, which produce, required report for the clients who subscribe magazines to maintain their inventory by writing code in C and C++. Enhanced and modify C, C++, and COBOL source codes of the company related programs using Borland C++ and Visual C++ on the Windows platform, and using UNISYS operation system on the mainframe platform. To replace existing old tape converter job of putting diskette data on the tape, designed front end product using Visual C++ and back end product using C++. The front end product was keep requesting client diskette until the job is done, and the back end product was responsible for uploading that whole job from that client PC to the UNISYS mainframe server.
Assisted System Manager with small-scale enhancements using C, and to set up peer-to-peer based LAN among the users inside the company. Troubleshoot software and hardware problems submitted by the users. Provide software training and installationsu pport to the system users.

Educational Qualification
BS: Bachelors degree with mathematics
MS.: Masters in computer application (MCA)