Sql Server Customer Service

Abhishek Agarwal

Address of Correspondence: - CONTACT: abhishek.agarwal984 (Skype)

*** ****** *****, ********* *****: - ********.*******.***@*****.***

Summary:

• Over 6+ years of experience in MS Stack (C#, ASP.NET, VB.NET, SQL Server, JavaScript, etc.)

• Currently working as freelancer in Telecommute mode.

• Worked as Senior Software Developer at HCL Info systems Ltd, Noida from January 2010 to

July 2013.

• Worked as Software Developer at Comcon Services Pvt. Ltd. from Mar, 2008 to Dec, 2009.

• Worked at PCS Technology Ltd. as Software Developer from March, 2007 to July, 2008

Technical Proficiency:

Technology Microsoft .NET Framework /ASP.NET-1.1/2.0/3.5/4.0, AJAX, MVC4

Languages C#.NET-1.1/2.0/3.5/4.0, VB.NET, XML, JQuery, HTML, CSS, Java Script, PL/SQL

Microsoft Visual Studio 2003 - 2012, WPF, Silverlight, WCF, XAML, HTML, CSS,

Products/Tools

Team Foundation Server (TFS), Windows Media Encoders, Direct Show,

RDBMS SQL Server 2000/2005/2008, My SQL

Reporting Crystal Reports, Dashboards

Tools

Trainings Conducted

Company Subjects Duration

HCL InfoSystems 2 days

.Net 4.0, ADO.Net, C#

Ltd

HCL InfoSystems MVC3, Entity framework 2 days

Ltd

HCL InfoSystems WCF, JQuery 2 days

Ltd

HCL InfoSystems .Net 3.5 including WCF, WPF 3 days

Ltd

Project Information (in reverse chronological order):

1. Mount Sinai - Online Database Application

Environment C#, ASP.NET4, ADO.NET, LINQ, Entity framework, Java Scripts, JQuery, CSS

MVC4, Razor View Engine, Azure

Database MS-SQL Server 2008

Role Technical Consultant

4

Team Size

Project Description

One of the Major Hospital in USA wants to create an online Database application, which will be hosted on

Azure Cloud and to be used by multiple hospitals to create their own customized database based hospital

application. It will help hospital users to create their own database from Scratch and also import data or

Table information from xls, csv files. All the database communication and reports will be HIPPA compliant.

I was responsible for system architecture / design of the whole web based system along with

coding/testing/deployment of the major screens and workflows.

2. On24.com

Environment C#, ASP.NET3.5, ADO.NET, Java Scripts, AJAX, Silver light, WME9

Database MS-SQL Server 2008

Role Technical Consultant

3

Team Size

Project Description

On24.com is one of the largest companies in world that provide a virtual platform for online events. The

platforms enables user to do real time communication with live and on demand facility for events. I was

responsible for designing the Audio and Video encoders using WME9 and Expression Studio that can talk

to Silverlight clients for audio and video display. This application was fully integrated with the on24

platform that already was providing FMS based streaming for FLASH/FLEX clients.

3. CRM

Environment C#, ASP.NET3.5, ADO.NET, Java Scripts, AJAX

Database MS-SQL Server 2005

Role Technical Consultant

Team Size 9

Project Description

The main objective of this CRM is to maintain the Workflow of the various products of “HCL Info systems

Learning Division”. There are N numbers of Product (DigiSchool, Language Lab, Xclerate…) which have

their own Sales Life Cycle. CRM helps in monitoring and maintaining the data at various stages of the life

cycle so that at the later stage business intelligence can be retrieved for decision making by the top

management.

Various module of CRM are:-

a. Presales(Inside Sales Team)

b. Sales (Field Team of Learning Associates)

c. Account Life Cycle( For Boot Model)

d. Delivery and Maintenance(HO team and RAOs)

Work Responsibility:

Analysis, design, development, testing and deployment thorough knowledge of the Business Processes,

Implementation Strategies, Software Methodologies, Project Life Cycle Management, Documentation

Standards and Project Implementation Methodologies.

4. SAMVAD

Environment C#, .NET2.0, ADO.NET, Java Scripts, AJAX, WPF

Database MS-SQL Server 2000

Role As Senior Software Developer

Team Size 5

Project Description:

SAMVAD is designed to be the most powerful prompter available for any telecast studio and suitable

for most demanding requirements of broadcasting. It is easy to use and control even in demanding

environments such as live news, seminars etc. It has these Versions

The Prompter (Teleprompter)

INSTANT (Teleprompter in Field)

LIVE (Teleprompter in Networking)

LIVE PRO (Teleprompter with Multi channel)

Responsibilities: Working as a programmer and analyst

Handling the issues of front-end and apply proper validation.

Lead end-to-end development of various modules.

Bug fixing in the application.

Responsible for doing the self-review at the earlier stages.

Unit and end to end testing and release to the application.

5. OBSERVER ALLOTMENT SYSTEM (Client: “Election Commission of India”)

Environment C#, ASP.NET2.0, ADO.NET, Java Scripts, JQuery, AJAX, WPF

Database MS-SQL Server 2000

Role As Developer

Team Size 5

Project Description:

Observer Allotment System helps in allotment of independent invigilator for the election centers for

parliament constituency, assembly constituency and districts. This allotment can be manual or atomized

through this system for maintaining integrity. This system is operated in two folds- One is window base

application where observer entry, slot creation and observer allotment is performed and another one is

web based application where observer can see the detailed information of constituency, mark their

attendance and navigate various features.

Responsibilities: Worked as a programmer and analyst

Handling the issues of front-end and apply proper validation.

Lead end-to-end development of various modules.

Bug fixing in the application.

Responsible for doing the self-review at the earlier stages.

Unit and end to end testing and release to the application.

Provide Technical Support on Module.

6. Sahyog

Environment C#, NET2.0, ADO.NET, Java Scripts, AJAX

Database MS-SQL Server 2000

Role As Developer

Team Size 3

Scope of the Project:- The sahyog ‘a customer service provider’ is an organization helping people to

save time by managing their billing (Electricity, Water tax, House tax, Telephone, Mobile, School fee etc).

The “Sahyog” performs the following major tasks.

Manage Subscriber Detail

Manage Location, Service Detail

Date, Location vise Due Bill Report

Date, Location and service vise Due Bill Report

yearly subscriber Report

Education:

• B.Tech from Utter Pradesh Technical University, Lucknow College SIET Meerut.

• MCTS (Microsoft Certified Technology specialist)

• 10+2 from Utter Pradesh Board of School Education, Lucknow.

• 10th from Utter Pradesh Board of School Education, Lucknow.

Personal Information

Father’s Name : Mr. Pravesh Kumar Agarwal

Sex : Male

Marital Status : Married

Nationality : Indian

Language Known : English, Hindi

Interests : Listening to Music and Walking

Permanent Address : 392/4 Shashtrinager

Meerut, UP-110014

ABHISHEK AGARWAL

Contact this candidate