Project Sql Server

**/*,****** ***** :

Nagar, Delhi +91-995*******

Pin: 110007 +91-11-238*****

E-mail:

rajesh.kapur@yahoo.c

om

Rajesh Kapur

Objective

To become a successful professional in the field of Information Technology

and to work in an innovative and competitive world along with committed and

dedicated people.

Training Cum Work Experience

Sapient Corporation January 2007 to

present

Senior Associate Technology L1

. Gained experience as CMS Expert in terms of SDL Tridion integration with

.net.

. Gained experience as a developer in .NET technology.

. Primarily involved in development of web based applications using

Microsoft Technologies.

. Working on projects using agile methodologies and SDLC waterfall model

Academic Qualification

QUALIFICATION BOARD/UNIVERSITY YEAR PERCENTAGE

MCA CDAC, GGSIPU 2007 78%

B.Sc.(H) Delhi University, 2004 60.4 %

Computer Science Delhi

Class 12th C.B.S.E 2001 81.16%

(Commerce)

Class 10th C.B.S.E 1999 72.4%

Technical Skills/Tools

. Language Known C#.Net, VB.Net.

. Applications Visual Studio 2005, NUnits.

. Frameworks Unity Application Block, Entity Framework

. Design Patterns Singleton, Factory, Proxy

. Operating System DOS, Windows 9x/2K/Me/XP.

. RDBMS Microsoft SQL SERVER2005

. Concepts Operating System, Data Structure, System Programming,

Software Engineering.

. Other software used MS-Office

. Web Development HTML, Java Script, JSP, ASP.NET

. CMS Red Dot CMS,SDL Tridion 2011

Projects

Unilever Avinash Platform (SDL Tridion 2011 +C# Project)

Unilever is well known FMCG company. It has around 2000 brands all over the

world. They run hundreds of campaign (promotional small web application or

Facebook application) in day to day life. Through an initiative jointly led

by Media and IT, Unilever North America is looking to enhance its current

digital strategy by investing in a Common Technology Platform. Currently,

Unilever invests in 77 brand web sites (including microsites) in the US and

44 in Canada. To make all the brand site uniform and reduce its cost,

Sapient form two types of team.

- Unilever Platform team

- Production team

Unilever platform team is doing all the common job like SDL Tridion setup

and create publications for all the production team, develop common

functionality like sign-in, recipe search, comment, poll, voting, WCF

services and many more. As of now this team is maintaining more than 150

publications in the CMS (SDL Tridion).

This is the support and enhancement project for the Unilever. I have played

the following roles in the project:

. Leading .Net team.

. Leading team responsible to complete Infrastructure

support/enhancement for e.g. Environment Upgrade, resolving Tridion

related issues, etc.

. Actively engaged in SDL Tridion Development

. Developing component on Tridion Core Service

. Design and implementation of SOLR

. Design and implementation of components having Tridion Integration

with .Net

. Design and implementation of C# TBB

. Leading team responsible for all sharing user data related to

campaigns.

. Build and release owner

. Resolving TARs

MRM Implementation Support and Enhancement (VB.NET Project)

This is the support and enhancement project for the MRM Implementation. I

have played the following roles in the project:

. Playing offshore lead role.

. Production release owner

. Design and Implementation of web pages.

. Owned Build Process.

. Created Stored Procedures including dynamic ones in SQL Server 2005.

. Created JavaScript functions.

. Resolving TARs.

. Owning KT for the application to be given to Infosys team.

Released the components on Inco QA and Production Server

MRM Implementation (VB.NET Project)

MRM project is a, multi-tier application with an ASP.NET web application

with SQL Server 2005 database. Mineral Resource Management, aka MRM is a

critical application for Vale Inco, Sudbury Operations in order to remove

the inefficiencies caused by reproduction and re-handling of data in

current non integrated legacy systems.

The roles I played in the project were:

. Designing and developing the Units framework

. Implementing the Composite application framework along with the

Factory design pattern

. Development of framework components like logging, Caching, Concurrency

implementation.

. Development of CodeGen - This tool helped the team by generating the

commonly used function for DAL and SQL layer. Also generated the

Stored Procedure for basic CRUD operations.

. Development of web pages.

. Development of Service Agent to consumes the service expose by

external system.

. Created Stored Procedures including dynamic ones in SQL Server 2005.

. Created JavaScript functions.

. Created NUnits for unit testing of the business logic.

. Development of interfaces to interact with external systems used by

Inco People.

. POC for Rad Grid, Logging, MRM Architecture, Seeunity and Hummingbird.

. Lead a track of three people

. Traveled to client site to integrate MRM application with Hummingbird

data Repository.

. Own Build and Release of Application

BREATHING AIR TRACKING SYSTEM MODS (BATS) (VB.NET Project)

This is an enhancement project for the BATS Implementation. I have played

the following roles in the project:

. Design and Implementation of web pages.

. Owned Build Process.

. Created Stored Procedures including dynamic ones in SQL Server 2005.

. Created JavaScript functions.

. Resolving TARs.

. Released the components on Inco QA and Production Server.

Research in Motion CMS Implementation and Design (Red Dot CMS)

. RIM undertook a selection process to choose a new Content Management

System (CMS) vendor. Their current CMS was custom-written by Web

Associates. Some of the business drivers behind the decision to switch

CMS systems included:

. Need for increased flexibility and functionality.

. Need for greater agility, control and avoidance of vendor lock-in.

Red Dot was selected as the vendor of the CMS system. Red Dot is custom

Content Management System, with inbuilt capabilities for Web Content

Management. In this project Red Dot CMS tool has been used to migrate

live sites of RIM (Research in Motion) a leader in wireless

communications. This tool provides complete functionality to create,

deploy and maintain a website with advance features such as dynamic html

generation on the published environment. I have played the following

roles in the project:

. Analyzing and understanding the business requirements and implementing

them on Red Dot.

. Design and Implementation of Web Templates and content classes.

. Development of integration pages to generate dynamic html with the use

of XML and XSLT

. Owned Build Process

. Implementation of Site Search with the use of Verity K2 search engine

on the published site.

. Tested and fixed bugs for the developed pages.

. Performing Reviews and ensuring best practices in the project.

CVRD Inco Chorus Support and Enhancement (VB.NET Project)

. This is the support and enhancement project for the Chorus

Implementation. I have played the following roles in the project:

. Design and Implementation of web pages.

. Owned Build Process.

. Created Stored Procedures including dynamic ones in SQL Server 2005.

. Created JavaScript functions.

. Resolving TARs.

. Released the components on Inco QA and Production Server.

Inco Chorus Design and Implementation (VB.NET Project)

. Chorus is a new application that will increase Acton's ability to remain

competitive while reducing the cost of operations at the refinery. The

associated benefits will be realized through better customer service,

enhanced responsiveness to business changes and operational excellence.

These improvements will also enable Acton to better address challenges in

a rapidly changing and complex market and ensure that the operations can

scale up to the future vision of expansion.

. The roles I played in the project were:

. Development of framework components like logging, Caching, Concurrency

implementation.

. Development of CodeGen - This tool helped the team by generating the

commonly used function for DAL and SQL layer. Also generated the

Stored Procedure for basic CRUD operations.

. Development of web pages.

. Ownerships for the Build Processes.

. Created Stored Procedures including dynamic ones in SQL Server 2005.

. Created JavaScript functions.

. Created NUnits for unit testing of the business logic.

. Development of interfaces to interact with external systems used by

Inco People.

. POC for Rad Grid, Logging, Chorus Architecture.

New Market International

. Meeting Broker puts powerful channel management tools into the hands of

hospitality professionals. A web-based information service that

distributes and manages leads from multiple business channels, Meeting

Broker provides consistent response from anywhere in your organization.

Meeting Broker receives requests for proposals (RFPs) sent by meeting

planners and provides a suite of online tools to more quickly assign,

respond to, and analyze these leads.

. Worked in Meeting Broker 3.7 post production and develop code for

application like GenerateNotification Utility, ETL Purge, and Replay

Tool.

. Visual Studio 2003, Visual Studio 2005, MS SQLSERVER2005.

. Roles performed in the project:

o Developed code for application like Generate Notification Utility, ETL

Purge, and Replay Tool.

o Worked in Meeting Broker 3.7 post production

o Tested and fixed bugs for the developed components.

SapeTel- A Quick Messaging Provisioning System

. Quick Messaging refers to the use of handheld devices for the purpose of

sending short emails. SapeTel provides Quick Messaging service to its

customers via MobiMail's MobiMail Network (customers use old RIM devices

not compatible with GPRS networks) and via Mobi2Net's GPRS Network

(customers use normal GPRS compatible devices like Blackberry etc).

Quick Messaging Provisioning Tool is a solution intended for a message

service operator. The service operator runs text messaging service and

plans to start a new voice messaging service. It needs a provisioning

tool to manage users of new voice messaging service and for migrating

users from earlier service to new service.

. Visual Studio2005(C# and ASP.NET), MS SQLSERVER2005

. Roles performed in the project:

o Was responsible for development of a key track in the application.

o Involved in designing and creating use cases required for the module

owned.

o Developer and active member for the front end and business logic

layer.

o Developer and successfully tested NUnits.

o Tested and fixed bugs for the developed components.

Personal Profile

Father's Name : Mr. R.K. Kapur

Date of birth : 11th May, 1983

Gender : Male

Nationality : Indian

Language Known : English, Hindi.

Awards Received

. Topper In mathematics in class 12th with 96%marks.

. Topper in Commerce Stream.

Interest

Music, Movie, Badminton, Chess, Traveling.

Date: Signature

Contact this candidate