Project Sql Server

Anshudeep Bajpai

Email ID: abnv5w@r.postjobfree.com Cell: 614-***-****

Summary

Having 6+ years of I.T. experience in Software Solution Development, Web Applications, Client/Server Technology,

Distributed Applications and other Custom-built Applications on Windows.

Strong experience in Java/J2EE technologies like Java Server Pages (JSP), Java Servlets, STRUTS, JSF, JAVA

Script, AJAX with DWR framework, Enterprise Java Beans (EJB), JDBC, JNDI, XML, XSL/XSLT, JDBC, XML

Parsers like JAXP, Web Services.

Worked in Multi-tier architecture environment with working experience of both application side technologies like

EJB and web side technologies.

Hands on experience in different MVC Frameworks like Struts, Java Server Faces (JSF).

Experience in JSR 168 portal development using WebSphere Portal Server 5.1.

Experience in SOA, Web Services and Apache Axis.

Experience in Hibernate OR Mapping framework.

Experience in performance optimization using profiling tool JProbe.

Hands on development experience in OO Design Patterns and J2EE Design Patterns.

Knowledge of Oracle, SQL Server and DB2 databases.

Excellent team player with problem solving and trouble shooting capabilities.

Professional Qualification

Master of Computer Applications (MCA) from Birla Institute of Technology (BIT), Mesra (Ranchi), India with 80.7% marks.

Professional Certification

IBM WebSphere Portal V5.1, Application Development.

Technical Proficiency

Languages: Java, C, C++.

Technologies: J2EE, AJAX, Portal.

Framework: JSF, Struts 1.1, DWR.

OR Mapping Framework: Hibernate 3.0.

Application Servers: WebSphere 5.1 Application Server, WebSphere Portal Server 5.1.

Web Servers: Tomcat 6.x.

Scripts: JavaScript, HTML.

Operating Systems: Windows 2000, Windows NT, Linux, MS DOS.

Tools: Rational Application Developer 6.0, WebSphere Application Dev,

JProbe, VSS, ClearCase, CVS.

Databases: SQL Server, Oracle 9i, DB2.

Business Domain: Financial.

Trainings

Attended WebSphere portal development external training from IBM. Duration 5 days.

Professional Experience

Organization: Ness USA, Inc., Hackensack, NJ

Project: FTC Integrated Point of Sales (IPOS)

Client: Farmers Telephone Cooperative, Inc., Kingstree, SC

Duration: Sep, 08 – Till date

Project Description: The objective of IPOS is to provide a set of intranet applications for automating and integrating the

work of various departments like sales, billing, installation and providing a web application for the customers with features

like monthly reports related to their connections, online billing, requesting online for new features.

Environment: J2EE, Rational Application Developer (Server, IDE), WebSphere Application Server, WebSphere Portal, DB2

UDB for AS/400, iSeries.

Role: As a senior developer, I am performing the following activities:

Planning and Designing new modules and enhancements.

Providing estimates for new modules and enhancements.

Involved with coding of Complete Tiers of J2EE.

Analyzing production issues and fixing.

Responsible for defect fixing during Integration Testing and User Acceptance Testing.

Organization: Saber Corp, Columbus, OH

Project: ERIC

Client: Department of Job and Family Services, the state of Ohio

Duration: Mar, 08 – Sep, 08

Project Description: The objective of ERIC is to provide a modernized system for processing unemployment compensation

taxes to effectively and efficiently accept reporting, bill employers, accept payments and process refunds, collect monetary

dues, track employer records, assure employer compliance with the law, and provide customer support to assist employers

in meeting their legal obligations.

Environment: J2EE, JSF, Rational Application Developer (Server, IDE), WebSphere Application Server, WebSphere Portal

Server, JSR 168 Portals, JProbe, DB2, Windows-2000.

Role: As a senior developer, I was performing the following activities:

Implemented various J2EE Design Patterns.

Developed JSF portlets in WebSphere Portal Server.

Performance tuning using JProbe, optimizing queries for large volume of data.

Designing Sequence Diagrams using Rational Rose for Detailed Designing & Analysis Model.

Used ClearCase for source code management and ClearQuest for defect tracking and fixing.

Responsible for defect fixing during Integration Testing and User Acceptance Testing.

Organization: Dow Jones & Company Inc., South Brunswick, New Jersey.

Project: MetLife WorkBench

Client: MetLife

Duration: Nov, 07 – Mar, 08

Project Description: Factiva®, from Dow Jones, provides essential business news and information together with the

content delivery tools and services that enable professionals to make better decisions faster. Factiva’s innovative, XML-

based and Web services-enabled technology platform provides access to this rich content collection via Factiva’s role-

specific products or through customized enterprise, group or personal solutions.

Environment: J2EE, JSP, Servlets, Tomcat, SQL Server, Web Services, Apache Axis2.

Role: As a Senior Programmer, I am performing the following activities.

Involved in finalizing the design for the application based on the requirements.

Used web services (SOAP, WSDL) extensively for data exchange.

Involved with coding of Complete Tiers of J2EE.

Used JSPs, Servlets and JSTL for the web user interface.

Involved in the packaging and deployment of the application on TomCat Server.

Responsible for defect fixing during Integration Testing and User Acceptance Testing.

Developed and maintained the database tables, views, synonyms and stored procedures in SQL Server.

Used JDBC for database connectivity and wrote SQL queries to get the requested data from Service database.

Organization: Globallogic (I) Pvt. Ltd., India.

Project: Prolifics, Avista

Client: Prolifics

Duration: Nov, 06 – Nov, 07

Project Description: Avista Decision Support Service provides marketers with an easy-to-use toolset that delivers on-

demand insights about the effectiveness of marketing efforts. It combines the insights from MMA marketing mix models with

the real time analytic power of industry-leading business intelligence to support fact-driven decisions – all drawn from a

company’s integrated marketing data

Environment: J2EE, WebSphere Application Server, WebSphere Portal Server, Hibernate 3.0, JSR 168 Portals, Struts,

Oracle 9i, Windows XP.

Role: As a Senior Programmer, I was performing the following activities in the role of a member of Development Team.

Involved with coding of Complete Tiers of J2EE.

Developed Struts JSR 168 portlets in WebSphere Portal Server.

Used Hibernate Persistence API to provide Object Relational mapping for persisting POJOs to tables and vice

versa.

Created XML files to configure the mapping of POJO entities to the corresponding database tables.

Providing estimates for the enhancements which involves interaction with the client and design efforts.

Responsible for defect fixing during Integration Testing and User Acceptance Testing.

Involved in the packaging and deployment of the application on Web Sphere Server.

Wrote SQL queries, Stored Procedures to grab the data from Oracle database using JDBC Statements,

Preparation and analysis of the results.

Organization: CSC India, Hyderabad

Project: CSC.COM

Client: CSC Global

Duration: Jul, 06 – Nov, 06

Project Description: The CSC countries CMS adheres to 3-tier client server architecture. Currently in the maintenance

stage it requires timely and efficient fixing and enhancement of the existing code.

Role: As a Senior Programmer, I was performing the following activities in the role of a member of Development Team.

Providing estimates for the enhancements.

Coding and fixing bugs.

Preparation and analysis of the results.

Environment: J2EE, WebLogic, UNIX.

Organization: Covansys India Pvt. Ltd., Bangalore (India).

Project: ERIC

Client: Department of Job and Family Services, the state of Ohio

Duration: Oct, 05 – Jul, 06

Project Description: The objective of ERIC is to provide a modernized system for processing unemployment compensation

taxes to effectively and efficiently accept reporting, bill employers, accept payments and process refunds, collect monies

due, track employer records, assure employer compliance with the law, and provide customer support to assist employers in

meeting their legal obligations.

Environment: J2EE, JSF, Rational Application Developer (Server, IDE), DB2, Windows-2000.

Role: As an Associate, I was performing the following activities in the role of a member of Development Team.

Involved with coding of Complete Tiers of J2EE.

Developed JSF portlets in WebSphere Portal Server.

Provided training for Java Server Faces

Analyzed the functional specifications of the products and implemented the business logic for different modules in

Java.

Designing Sequence Diagrams for Detailed Designing & Analysis Model.

Organization: Covansys India Pvt. Ltd., Bangalore (India).

Project: JClarety

Client: New Mexico State Government, USA.

Duration: Jun, 04 – Oct, 05

Project Description: The aim of this project is to automate the Retirement System thus making it a suitable plug in

application, which takes care of the total functionality and scope, which a state retirement system follows. The Clarety

Retirement Framework supports the primary business functions of public pension plan administration. Each retirement

organization is unique in the implementation of its pension plan structure, administration and operating environment. But

despite the differences, there are also many similarities because the basic business of retirement is the same across public

entities. Clarety provides framework components made of sound process and data structures with which to build the unique

systems that can meet the needs of your organization

Environment: Struts, JSP, Servlets, JDBC, WebSphere Studio Application Developer (Server, IDE), MS SQL Server,

Windows-2000.

Role: As an Associate, I was performing the following activities in the role of a member of Development Team.

Involved with coding of Complete Tiers of J2EE.

Involved in coding the components and fixing bugs.

Organization: Covansys India Pvt. Ltd., Bangalore (India).

Project: Common Portal (CPP)

Client: PacifiCare Health Systems, USA.

Duration: Jul, 03 – May, 04

Project Description: PacifiCare is one of the largest Consumer Health Organizations in USA, offering individuals,

Employers and Medicare beneficiaries a variety of consumer-driven Health Care and insurance products and offers different

Plans to suit the needs of the Consumer. Specialty operations include Behavioral Health, Dental and Vision, Life Insurance,

and complete Pharmacy and Medical Management through its wholly owned subsidiary www.pacificare.com and

www.securehorizons.com.

Role: As an Associate, I was performing the following activities in the role of a member of Development Team.

Developing JSPs, Servlets, Java Beans.

Involved in content development for the Portal.

Interacting with the client for understanding and fulfilling the testing needs of client.

Performed Functional Testing, Regression Testing to ensure quality using automated testing tool.

Environment: Struts, JSP, Servlets, JDBC, WebSphere Studio Application Developer (Server, IDE), Winrunner7.5, MS

SQL Server, Windows-2000.

Industrial Training

Organization: Electronics Research & Development Centre of India, Noida.

Project: HRMS

Client: ITDC

Duration: July, 2002 – Dec, 2002

Project Description: It entails all the activities regarding an employee right from his joining till he leaves the organization. My

role in the project was to develop the front end, coding and generating reports using crystal reports.

Environment: Visual Basic 6.0, Crystal Reports 6.0 & MS SQL Server.

Contact this candidate