Sql Server Project

Avnish Kumar

RZF-***, Raj Nagar, Part-II, Netaji Subash Marg,

Palam Colony, New Delhi-110077.

Phone No. : 011-******** Mobile- +91-901*******, +91-921*******

E-mail: **************@*****.***, *************@**********.***

OBJECTIVE:

Looking for bright future and challenging environment, which will help

me to enhance my personal knowledge and make best use of my technical

and managerial skills. I would like to grow with the growth of the

organization.

Technical Skills :

. .Net Platform [C#, ASP.Net] 2.0, 3.5

- Web Application, Web services, HTML and XML.

- Desktop/Win Applications (Win forms), windows services, WCF, WCF

Rest, Smart Client Software Factory (SCSF). Knowledge of Cloud

Storage

- Patterns and practices : Enterprise library

- Packaging and deployment.

. Databases: - MS SQL Server, Sybase

. New Technology : SCSF (Smart Client Software Factory), WCF

. Operating System: - DOS, Windows 98, Windows 2000 Server, Windows XP.

. Others: - MS Office, Computer Organization, Computer Graphics using

C/C++, Analysis and Design of Algorithms. Having knowledge of Systems

Analysis and Design, MIS, Computer Networks, Object Oriented

Programming and Technologies, Data Structures, and DBMS.

EXPERIENCE: Have 6 plus years of Experience in Web (web applications and

web services) & windows applications (winforms and Win services)

development using ASP.NET with C# & SQL Server 2000/2005.

On Site Experience:

I have around 6 months on site experience (in Glasgow, United Kingdom) with

our client V-Ships, which is the world's biggest Shipping Management

organization. I developed two applications for them as an employee of

"Globrin Systems & Solutions Ltd.". One is for Import & another is for

Export in Dot Net using C#, SQL Server 2000, Sybase.

1. Working with "Core Competency pvt. Ltd." as a Senior Software

Developer from Jan 2013 to till date.

2. Worked with "Globrin Systems & Solutions Ltd." as a Sr. Software

Engineer from 1st May 2008 to 18th Jan 2013.

CURRENT PROJECT:

VSHIPS SHIPSURE: The project includes the complete details of the shipping

organization.

Tools Used ASP.NET, C#, SQL Server, AJAX, Smart Client Software

Factory, XML, MTML, VSS, VPN, Agile Methodology

Application web applications, web services, win (winforms)

Types applications, win services

Team Size 7

Responsibility Member of the Development Team.

Client Interaction.

Create/Review on SRS, Statement of Work.

Impact Analysis, Estimations, and Design Documents.

Coding for the assigned module.

Execution/Review of the Coding.

Supporting the Testing Team.

Project Deployment.

Modules I am handling include:

a. B2B: This is a Business-to-Business website developed for VSHIPS which

includes the online requisition processing system, invoice details

etc. Basically it is being used for the purchasing system. in which

VSHIPS sends a RFQ (Request for Quote) to the Supplier and in return

Supplier sends the Quotation to VSHIPS. After receiving the Quotation,

VSHIPS places an order. WCF service is being used to get rid of the

delay problem of data replication from different sites. The order is

delivered by the Supplier and hence supplier generates an invoice.

Front-End : ASP.NET, C#,

Back-End : SQL Server 2000

b. VSB: This website is used to get the complete details of the ships

(vessels) with their status etc. It helps the crew members/management

to know that which ship is moving with their starting point and

destination point, which ships are busy and which are not.

Accident/Incident details of the ships can also be know through this

application etc.

Front-End : ASP.NET, C#

Back-End : SQL Server 2000

c. Company Maintainer: This is a stand alone application. It includes the

details to maintain (Add, Edit, Save, Cancel) the companies details

etc. Using this, user can see the address details of the Vessel

selected, an invoice can be generated, User can see the different

reports like B2B user (users who all are having the access to B2B

application). Also, User can see the delivery details, currency

details, related companies in tree structure etc by entering the

company name.

Front-End : C#, winforms

Back-End : SQL Server 2000

d. Requisition Wizard: This is a windows application. It includes the

wizard to generate a requisition from any office.

Front-End : C#, winforms

Back-End : SQL Server 2000

e. Purchase Order Copy: This is a windows application. It includes the

copy of purchase order generated from one vessel to another vessel.

Front-End : C#, winforms

Back-End : SQL Server 2000

f. AMOSD: Developed the AMOSD (import - export application) on site for

around 4

months. This application include interacting with the customers of

VSHIPS, understanding their requirements, getting it implemented, &

interacting with them for providing regular professional support.

Front-End : C#

Back-End : SQL Server 2000, Sybase

g. PMI (Private Medical Insurance): This Application is to provide the

medical insurance to seafarers. There can be a number of potential

policy providers. Seafarers are required to sign the Preferred

Seafarers Agreement (PSA) prior to receiving the PMI cover.

Front-End : Smart Client Software Factory, C#

Back-End : SQL Server 2000

h. TEOMAKI: This is the Import-Export routine which includes the

importing the data into the database using the xml come to the Inbox

folder and in return generating the xml export files. This procedure

is basically shows that requisitions are coming then they become

purchase orders by attaching the supplier to them and hence xml export

files are generated.

Front-End : C#

Back-End : SQL Server 2000

i. Purchasing Chase: This is a win service to chase the enquiries,

invoices, purchase orders, freights, etc.. It is acting as a reminder

to the admin. Department.

Front-End : C#

Back-End : SQL Server 2000

It also includes the interaction with the client to solve their problems

regarding the use of software & their new requirements. The communication

type includes audio conferences, mails or face to face by visiting client

personally.

2. Worked with "HCL Infosystems Ltd." as a "Software Developer" from 25th

April 2006 to April 2008.

Tools Used ASP.NET, C#, SQL Server, AJAX, Agile Methodology

Application web applications, web services, win (winforms)

Types applications, win services

Team Size 4

Responsibility Member of the Development Team.

Client Interaction.

Create/Review on SRS, Statement of Work.

Impact Analysis, Estimations, and Design Documents.

Coding for the assigned module.

Execution/Review of the Coding.

Supporting the Testing Team.

Project Deployment.

PROJECTS DESCRIPTION :

1. Computerization of Gram sabha Land

Client : Delhi Government

Front-End : ASP.NET, C#

Back-End : SQL Server 2000

Duration : 15 months

Description: This project will work for Director (P) office. It provide

spatial representation to ascertain the exact status of GS Land with

respect to location, litigation, encroachments, and various other allied

like acquisition etc. It provides Internet connectivity at the Panchayat

(HQ) to five BDO offices. Keeping and monitoring data regarding demolition

including Photos and Videos. The scanning of various kinds of

documents/Photos including Shijra maps of GS Land by A3 colored scanner

along with editing of the scanned maps /images. It also includes the

interaction with the client, to understand their problems & providing the

professional support.

2. Personnel Information System

Front-End : ASP.NET, C#

Back-End : SQL Server 2000

Duration : 9 months

Description: Personal Information System keeps record of employees who are

working in Delhi government. It helps to maintain all the personnel

information about employee. We can add new employee details, transfer

employee from one Branch Office to another. View details of any employee by

entering its employee code. With this Software we manage all the work of

Payroll as well as any official work.

PROJECT WORK:

> USER'S PERCEPTION OF E-GOVERNANCE

This is a mini project in which I tried to estimate the percentage of

people who are using the government websites to seek for some

information, for billing etc. using the primary data as well as

secondary data and finally to know the reasons.

> MARKETING STRATEGIES FOLLOWED BY JYSKE BANK

Complete analysis and interpretation of the marketing strategies

followed by the JYSKE Bank.

> SWOT ANALYSIS IN BISLERI

Marketing research of Bisleri using SWOT analysis considering the 4

p's of marketing into consideration.

> MIS (as a term paper)

> MMPO MONITORING SYSTEM

This is a live project undertaken at N.I.C for the ICAR (Indian

Council of Agricultural & Research) at Krishi Bhawan, New Delhi, in

"ASP" language using the Operating System "Windows 2000 Server" and

the Database used is "SQL Server 7.0".The duration was of 6 weeks with

a team size of two members.

> NETWORKING

The duration was of 6 weeks with a team size of two members.

> TEXT EDITOR

This is a project, which was carried out in the college in 7th

semester as a mini-project. It is just like a Notepad having some

special features. The Operating System Used is Window 98 and developed

in "C" language with a team of four members in the period of 5 weeks.

> DATA SECURITY SYSTEM

This is a project, which was carried out in the college in 8th

semester as a major-project. It contains the concept of Steganography

(Encryption & Decryption) and Cryptography (Hiding & Retrieving). The

Operating System Used is Window 98/any Windows Version and developed

in "C++" language with a team of four members in the period of 5

weeks.

QUALIFICATION:

. MBA(IT + Marketing) from "Guru Gobind Singh Indraprastha University",

Delhi, with aggregate marks of 75% in Year 2008.

. B.E. (I.T.) from "P. D. M. College of Engg." affiliated to "M.D.

University" and approved by AICTE, with aggregate marks of 74% in Year

2005.

. A first Division in XIIth from Delhi Jain Public Sr. Sec. School

(approved by C.B.S.E.).

. A first division in Xth from Delhi Jain Public Sr. Sec. School

(approved by C.B.S.E.).

PERSONAL DETAILS :

Name : Avnish Kumar

Father's Name : Sh. Dilbagh Singh

Date of Birth : 15th, sept., 1984

Marital Status : Single

Languages : English & Hindi

Strength : Confident & Hard Working

Hobbies : Traveling and Meeting different types

of people

OTHER ACTIVITIES & SKILLS :

. Good Communication Skills with Knowledge of English & Hindi (Written &

Spoken)

. Acknowledged by the school certificate for brilliant performance in

"School Science Fair".

. Got a Merit Scholarship of Rs.1200 in School time.

. Participated in Modeling in College. Date

Signature

Contact this candidate