Sql Server Manager

Rajesh Nair

*** ****** **, *** # ***

Charleston, WV – 25301

abnj5w@r.postjobfree.com

(cell) 732-***-****

Skills Summary:

• Over ten years of strong experience in IT development and production support

environment.

• Develop innovative ideas and making improvements with existing processes.

• Excellent interpersonal skills with all team members and outside groups.

• Excellent verbal and written communication skills.

• Sun Certified Java Programmer with good hands-on experience in designing &

development using Java/J2EE technologies such as Servlets, JSP, XML, XSLT,

Hibernate, Spring & EJB.

• Experience in Designing and writing webservices in J2EE on IBM Websphere.

• Experience with Software Development Lifecycle (SDLC) of a project using Agile, Test-

driven etc.

• Experience with various J2EE design patterns, Rational Unified Process (RUP) and

Object oriented Analysis and Design.

• Worked in the core Group for Project Management through entire Software Development

Life Cycle and Process Definition for SEI-CMM Level-3 certification.

• Experience in writing test cases for System, GUI, and Performance testing.

Technical Skills:

• WEB/Java Technologies: XML, XSLT, JSP, JSTL, Servlets, AJAX, JDBC, Swing.

• Web Services: WSDL based Web services, Restful Webservice, SOA architecture.

• Java Frameworks: Spring, Hibernate, Struts.

• Web Application Server: Jrun 4, IBM WebSphere 6.1, WebLogic 8, JBoss 4.2.

• Frameworks: Dojo, GWT, Jquery UI, JIBX, JUnit, Ant.

• RDBMS: ORACLE 8/9i, MS SQL Server 2000/2005

• Middleware Products: EJB 3.0, SwiftMQ(proprietary s/w implementing JMS)

• Analysis/Design Tools: Rational Rose, Visio, MS-Project, Crystal Reports

• Concepts: UML, OOAD, Database Design, Test Driven Development

Visa Status/Position:

Permanent Resident (Green Card) seeking FullTime Employee/ Contract positions.

Educational Qualifications:

Academic

• Master’s in Computer Application (MCA) from MKU, Mumbai, India.

• MBA (Systems) from ITM, Mumbai, India. (Affiliated to Southern New Hampshire

University, US)

• Bachelor‘s Degree in Science, Mumbai University, India.

Professional

• Advance Java Programming using CORBA & EJB, Mar. 2001 from NIIT, Mumbai, India.

• Diploma in Advance Computing, CDAC(A Govt. Of India Enterprise) June 1999, from

SIST Computer Education, Thane, Maharashtra.

• Higher Diploma in Software Engineering (1994-1996) from Aptech Computer

Education, Mumbai, India.

Page 1 of 6

Citi Private Equity

New Port, NJ

October 07– Present

Environment: Business Objects XI, Web Business Intelligence api's, WSDL based

Webservices, JExcel apis, Java 1.5, Hibernate, XML, XSLT, JSP, JSTL, Servlets, EJB 3.0,

SOAP, AJAX, JQuery UI, JSON, MyEclipse 6.3, MSSQL 2000/2005.

Wrote Webservice application (which integrates with existing application) to upload data like

investor, contacts, investments information from Excel sheet provided by Business Users to

central database. Developed module to handle client transaction using EJB 3.0. Re-designed and

developed Web based Intranet and Client facing reporting portal, to generate existing and new

Financial reports for the Customers and partners. Currently working on integrating existing

Business Object reports using Web Business Intelligence apis.

Role & Responsibility: Analyst/Programmer

i) Developed a Webservice application which extract Customer specific information from

the Excel sheet using the JExcel Apis and feeds to legacy application.

ii) Developed module to handle client transaction using EJB 3.0

iii) Develop and rewrite from ground-up the present Client facing Coldfusion based

application including its intranet and client facing reporting tool for various reports.

Potential reworking for this reporting portal is to gain performance and scaling advantage

over existing reporting tool.

iv) My responsibility included redesigning application to use Hibernate for persistence Layer,

writing Business-specific java Objects, JSP, Xml and XSLT for screen rendering and

servlet for server-side processing.

v) For same project, worked on rendering reports screens using Jquery UI framework.

vi) Also involved in Application migration from Jrun 4.0 to Jboss 4.2 in development

environment and to IBM Websphere 6.1 in UAT/Production.

vii) Currently working on integrating Business Objects reports into the application using

Business Object Api’s for added flexibility to power users.

AOL

Manhattan(mid-town), NY

July 07– October 07

Environment: : Java 1.5, Servlets, JSP, XML, JSLT,XML, JIBX, XStream, EJB 3.0, SOAP,

AJAX, DOJO, JSON, Eclipse 5.3, My-SQL on HTTP.

Transition project for AOL website from existing legacy framework to a new custom framework

with latest Java technologies with few additional features and webpages using AJAX, dojo,

webservices etc.

Role & Responsibility: Analyst & Programmer

i) Develop the dashboard webpage business components and JSP pages with information

from various webservices and providing this information to the user. Professional

Designers provided the html, css files which are we used in these JSP pages.

ii) Developed parts of profile pages for various information from webservices about Artist,

AIMFriends, Tastemaker etc with addition, deletion, comparison algorithm since profile

page stores a lot of stats information from various webservices.

iii) Wrote EJB component to log user activities to central server and other subsystems.

iv) Implemented few Design Patterns including Observer, Factory, Decorative and Adaptive .

v) Used JSTL for various JSP pages, hence separation of task with Page designers,

maintenance and enhancements were trivial.

vi) Used JIBX for various XML to Java Beans binding for communicating through

webservices.

vii) Used Xstream to work with XML pages and various application utilities like JSON to Java

etc.

Page 2 of 6

viii) Created AJAX scripts and Dojo libraries to dynamically call/upload various components in

the page without a page refresh.

Prudential Financials

Roseland, NJ

May 05– June 07

Environment: : Java 1.3, Servlets, JSP, XML, XSLT, Crystal Reports 9.0, IBM Identity

Manager(ITIM), IBM's Tivoli Access Manager(TAM), SunOne LDAP, IBM Rational

Application Developer 6.0, Oracle 9.2., SQL Server 2005.

In our work environment, various Applications are integrated to IBM's Identity Manager (ITIM)

which is implemented as a Rule Engine for authentication and authorization. As a programmer

and support from security Group, I write/support integration program for legacy applications to

talk to ITIM using multiple tools including IBM's WBI MQ for messaging, Tivoli Access

Manager(TAM) API’s, querying LDAP or Parsing XML data into Oracle/SQL RDBMS.

Role & Responsibility: Analyst & Programmer

i) Develop the System Requirement and Design specification based on the discussion with

Business Analyst and Client.

ii) In some projects, involved in development of the Technical SRS doc and Project Plan

and present it to management and Client for approval.

iii) Implemented few Design Patterns including Observer, Factory, Decorative and Adaptive.

iv) Java program using TAM api’s, accessing LDAP data for Business continuation reports

project.

v) Servlet and JSP (including custom tags) for few web applications.

vi) Wrote stored procedures using PL/SQL in Oracle.

vii) Participate in End-to-End testing.

viii) Creating various Crystal reports as per the requirement of these new applications and

publishing it.

ix) Since it's a small group, was involved in the entire SDLC of these integration programs.

Metlife Insurance

Bridgewater, NJ

June 04– April 05

Environment: : Java 1.3, Servlets, JSP, XML, XSLT, SOAP, DB2 with IBM Websphere

webserver 5.0 & WebServices for integration with their legacy systems.

Wrote 2 webservices based on the clients requirement for real time integration to another

services. Project also involved implementing WS-Security, Encrypting sensitive data and PKI

interface implementation.

Role & Responsibility: Analyst & Programmer

i) Develop the System Requirement and Design specification based on the discussion with

Business Analyst and Client.

ii) Develop the SRS doc and Project Plan and get approval from management and Client.

iii) Used MS Project for managing the SDP of the project/Documentation with CMM level 3

standard while Test Director for Bug tracking and fixing.

iv) Implemented the WS-Security protocol for Web security with the PKI interface between

multiple system.

v) Developed Servlets and JSP’s and Stored procedures using PL/SQL.

vi) Involved in development of Common Framework for Webservices to be used within the

organization and followed self-documented version control for the Webservice.

Affymetrix Ltd

Santa Clara, CA

April 04– June 04

Page 3 of 6

Environment: : Java 1.3, Servlets, JSP, XML, XSLT, SOAP, SQL Server 2000 with IBM

Websphere webserver 5.0 & WebServices for integration with SAP and Maximizer CRM.

Based on Client related data in Maximizer CRM, Affymetrix has developed a support tool for its

Field Agents(FAS). This is basically a portal which tracks all CRM activities in a customized way

and allows its Sales Force and management with updated information. Furthur enhancement

includes integrating Peoplesoft ERP.

Role & Responsibility: Analyst & Programmer

i) Developed the System Requirement and Design specification based on the prior

knowledge with Maximizer.

ii) Developed Interface based design for scalability and easy maintenance of software.

iii) Involved in development of User Interface Design and Database Design.

iv) Used Rational Rose for Document specification.

v) Developed modules in Java to interface with Resource Toolkit of Maximizer.

Siemens Corporate Research(E-Spares)

Princeston, NJ

Jan 04– Mar 04

Environment: Java 1.3, Servlets, JSP, XML, XSLT, Diagram viewer, SOAP, Oracle 8i/ DB2

with IBM Websphere webserver 5.0 & WebServices for integration with SAP.

E-Spares is a Multilanguage online system for browsing and navigating spare parts information,

and for requesting quotes and ordering of spare parts for machines manufactured by Siemens

Power Generation (PG).Project involves mechanical diagrams using diagram viewer, linked using

hotspots to Xml page, dynamic generation of orders or quotation into PDF files using Xml/XSLT

based on the selection in the shopping cart.

Role & Responsibility: Programmer.

i) Developed User Interface using JSP.

ii) Wrote Java script to provide GUI validations.

iii) Developed servlets for most of the Business Logic.

iv) Generated dynamically PDF file for order/quotation using XML/XSLT

v) Generated hotspots in Diagram, which is linked to the xml file that can be used to

generated order/quotation.

vi) Involved in all activities related to managing the shopping cart.

vii) Context based database driven Help module was developed by dynamically generating xml

help files based on the chosen language.

Neterwala Group of companies

Mumbai, India

May 02 – Sep 03

Environment: Java 1.3, Servlets, JSP, Struts, XML, XSLT, XML Spy, Oracle 8i with IBM

Websphere webserver 4.0

An Intranet site for connecting group companies where the focus is on sharing Data (Customer,

Vendor, Projects, Products) and Resources (Facilities, Skills, Licenses, Techno-logical Advances)

or Information (Govt. Notification, Bulletin Board, Group HR Policies) etc

Role & Responsibility: System Designer & Programmer.

i) Developed administrative screens for entering new policies, editing the privileges and to

edit improper user approvals and names using JSP, Struts & Java script

ii) Created XSLT scripts to transform XML into HTML formats

iii) Developed the System Requirement Specification after interacting with clients

iv) Developed Interface based design for scalability and easy maintenance of software.

v) Developed customized programs to extract data from Legacy system in Heterogeneous

environment to be uploaded into Standardized Database.

vi) Used JDBC-ODBC bridge for Incremental data upload programs in Central Data

Repository

vii) Customized the propriety CRM tool Maximizer for capturing the Customer related data

and integrated it with the standardized Database in Oracle.

Page 4 of 6

Milton Exports

Mumbai, India

Jul 01 – Apr 02

Environment: Java 1.2, Servlets, JSP, MS-SQL server, IBM Websphere webserver 3.5.6

An integrated Enterprise application with the following functionality: Sales, Purchase, Logistics,

Inventory, Excise, Export documentation, Financial Accounting, Export Benefits and Material.

Role & Responsibility: Team Leader (for Implementation)

i) Designed & developed the GUI for additional functionalities using JSP with custom Tag

libraries.

ii) Refined the Database for Optimal performance.

iii) Integrated the product with the Legacy Database using Data Migration tools and wrote

small application programs for the same.

iv) Technical Trouble Shooting and Debugging

v) Involved in Software Quality Assurance, Black Box Testing/Functional testing/Regression

testing Usability testing, System testing, Compatibility testing.

Milton Group

Mumbai, India

Feb 01 – Jun 01

Environment: Java 1.2, SwiftMQ 1.2, MS-SQL Server, Weblogic webserver.

A module for Replication of Data in Distributed Environment in an integrated Enterprise

Application Database using a dialup connection. Modular architecture for seamless integration

with any database for achieving Asynchronous Data Replication for Distributed Architecture.

Role & Responsibility: Senior Developer

i) Developed the Push-Pull based Architectural Design and System Requirements

Specification

ii) Developed Database Design and Normalization for Optimal Database performance.

iii) Customized the propriety software Swift MQ (which implements JMS) for the publish –

subscribe router implementation.

iv) Wrote a small program to extract data from Legacy Database of heterogeneous

environment into Standardized Databases.

v) Did Data Encryption and tunneling to save data from being accessed using hacking

programs during transactions.

vi) Wrote a program which converts the data into queues uploads the data into the mail server

of specific user in Web server from where it can be downloaded by the user periodically.

vii) Managed the entire transaction from end to end for correct transfer of data even during line

dropout, corrupted data or incomplete transaction.

viii) Was responsible for Project Planning, Managing & Execution

ix) Was responsible for Technical Trouble Shooting and Debugging

x) Involved in Installing, Configuring at client location.

Pantaloon Retail Technologies Ltd.

Mumbai, India

Jul 99 – Jan 01

Environment: VB 6.0, Crystal Reports 7.0, SQL Server 7.0, Rational Rose 2000 Enterprise

Edition, JavaScript and Windows 2000.

An integrated Retail Enterprise application with modular architectural design with the following

functionality; Point of Sale(POS), Purchase, Logistics, Inventory, Excise, with interface for

integrating external Financial Accounting and Materials modules.

Role & Responsibility: System Analyst & Programmer

i) Performed Business Process Analysis and Requirements Specification

ii) Developed Database Design and Normalization for Optimal Database performance.

iii) Developed User Interface Design after interacting with all concerned parties including the

end user.

iv) Developed use cases using Rational Rose as system specs for development

v) Involved in Technical Trouble Shooting and Debugging

Page 5 of 6

vi) Developed administrative screens for entering new policies, editing the privileges and to

edit improper user approvals and names using VB with SQL Server.

vii) Developed MIS reports for management using Crystal Reports 7.0

viii) Created stored procedures using T-SQL and triggers in SQL server.

ix) Involved in giving training to the client at client place.

Maharashtra Industrial Development Corporation

Mumbai, India

Jul 98 – Jun 99

Environment: Java 1.2, Oracle 7.3, Java Web Server

Uploading of Regional Management Information System, Financial Accounting data for review by

the Head office developed for MIDC Modules involved uploading/retrieval of incremental data,

Data for consolidation of Financial Accounts, Exception report etc.

Role & Responsibility: Developer and played active role in module testing.

i) Developed customized programs to extract data from Legacy system in Heterogeneous

environment to be uploaded into Standardized Database.

ii) Used JDBC-ODBC bridge for Incremental data upload programs in Central Data

Repository

iii) Technical Trouble Shooting and Debugging

iv) Developed administrative screens for entering/editing the privileges using Java Swing.

v) Created stored procedures using PL-SQL in Oracle server for faster Database activity.

vi) Involved in Black Box Testing/Functional testing/Regression testing etc.

Oriental Bank of Commerce(OBC)

Mumbai, India

Feb 97 – Jun 98

Environment: Java 1.2, C++, HTML, Oracle 7.3

IPM is a support tool for Bank’s Portfolio Managers. Since optimal combination for each portfolio

depends on a client's investment mandates and risk tolerance, this tool uses a complex algorithm

to determine the optimal amount of each asset to hold within a portfolio. Simulation techniques

are used to forecast risk and return, calculate expected outcomes for the future with a standard

deviation of returns.

Role & Responsibility: System Designer & Programmer.

i) Developed the System Requirement and Design specification

ii) Developed Interface based design for scalability and easy maintenance of software.

iii) Developed User Interface Design and Database Design

iv) Developed module using Encryption for maximum security of Data.

Page 6 of 6

Contact this candidate