Developer Sql Server .Net Project Application

Devendra Kumar

Chicago, IL

Summary:

. * Years of experience in complete life cycle of Software Development that

includes requirements gathering, analysis, design, development, testing

and deployment using Visual Studio 2003/2005/2008.

. Adapt in project life cycle processes spanning from requirements

consolidation, code development, user reviews, and application deployment

. Five + years of .NET experience including ASP.NET, VB.NET and ADO.NET.

Have been involved in development of multiple internet/intranet and

windows applications using .NET platform.

. Worked with ASP, JavaScript, VBScript, XML, Microsoft Visual InterDev 6.0

and Microsoft Visual Studio.net, JQuery.

. Significant knowledge of various database application including SQL

Server 2000/2005/2008, Oracle, MS Access.

. Vast experience in GUI Development and Web Application Development using

VB, VBA, ASP, VB.NET, ASP.NET, ADO.NET, XSL, XSLT, XPATH, CSS, HTML,

DHTML, XHTML, JavaScript, JQuery and AJAX.

. Specialized in designing and building Conceptual, Logical and Physical

Databases using Database Normalization Techniques SQL Server

7.0/2000/2005/2008 and MS-Access. Successfully implemented Database

Normalization Techniques, OLAP, ETL, Entity Relationship Modeling, Object

- Relational Database Mapping Techniques, Data Serialization and Data

Migration. Created backend Stored Procedures, User defined functions and

Views using Oracle PL/SQL and SQL Server T-SQL

. Proficient at developing .NET applications using Web Forms, Windows Forms

. Proficient in Telerik Suite 1.0, 2.0, 3.0 for ASP.NET AJAX, Windows

Forms.

. Extensively worked on Database objects like Stored Procedures, DTS

packages, SQL Server Integration Services (SSIS), Creating & Scheduling

SQL Server jobs, Creating & Restoring backups.

. Experienced in working with multiple projects/assignments and managing

them efficiently and also to work under high pressure to meet the

deadlines.

Technical Skills:

Software & Languages

. Operating Systems: Windows XP/NT, DOS, UNIX, Windows 7

. Programming Languages: VB.NET, VB 6.0, SQL and PL/SQL.

. Designing Tools: Microsoft Visio

. Web Skills: ASP.NET, ASP, IIS, HTML/DHTML, VBScript, JavaScript, XML,

CSS, Flash,

FrontPage, Telerik Suite ASP.NET AJAX 1.0, 2.0 & 3.0.

. Web Server: IIS

. Distributed Technologies: COM, Web Services, and Remoting

. Relational Databases: SQL Server 2000/2005/2008, MS Access and Oracle

8.0/9.0

. Reporting Tools: Crystal Reports, Telerik Reporting 1.0/2.0./3.0,

SSRS

. Version Control Tools: VSS 6.0, SourceSafe

Certification:

Microsoft Certified Application Developer (MCAD)

Professional Experience:

Client: Health Care Service Corp, Chicago, IL

Duration: July 10- Till Date

Project: Out Bound Subscriber Application

Role: Contract Programmer

Description : Out Bound data application is to search and manage the

Members information and assign group of members to the examiners and

technicians to work on. Coordinators and Administrative level users have

different access according to the roles implement in the application.

Implement the complete application from scratch using the Agile

Methodology.

Responsibilities:

. Designed and Developed Windows Interface using VB.NET

. Developed Business Logic Components using VB.NET

. Developed Data Access layer using VB.NET

. Developing Technical Design document and unit test cases

. Designed the interfaces needed for exposing the Business Components

. Modified the existing SSIS packages and perform data tuning.

. Handled production issues involving real-time application problems

Environment : VB.NET, ADO.NET, SQL Server 2005, Crystal Reports, SSIS

Client: Community Care, Milwaukee, WI

Duration: March 07- June 10

Project: Provider Enterprises System

Role: Sr. Dot Net Developer/Architect

Description : No similar application exists on the market. PES was designed

and constructed to allow tracking contracts, affiliates, locations and

individuals in the health care market. An enormous amount of meta data is

required to provide detail information at multiple data tiers based on

needs. A single individual may be part of several affiliates at different

locations, and may be under multiple contracts. The entire state of WI

health care system is kept within PES and updated regularly as doctors

move, changes specialties, are dropped etc. The Wisconsin Department of

Health Services (DHS) examined the PES system and recommended it become a

commercial application to benefit all health care Organisation.

Project: Encounter Data Reporting Application

Role: Sr. Dot Net Developer/Architect

Description: Encounter Data and Reporting application is used to collect

all the data from different data sources and create XML reports for

different programs (PACE/Partnership/Family Care) for Wisconsin State.

Previously data was captured by an asp.net 1.0 application with MS Access

database. All the work is done under Access database using manual queries.

The submission and creation of report is done by the ASP.NET 1.0

Application. Migrate the whole application into Net 3.0 Win form

application with SQL Server 2008 Database.

Project: Dental Scheduler Web Application

Role: Sr. Dot Net Developer

Description: Dental scheduling application tied to team meeting data.

Includes dashboard and reports to provide Doctors and staff information on

seen, not seen, reused and other appointments. Doctors added a new

appointment with all the team information and client information with in

the scheduler. Different types of dental reports are produced using the

system to show the patient information.

Project: Team Meeting Web Application

Role: Sr. Dot Net Developer

Description: Team Meeting encounters information. This application has all

Pace and Partnership clients, teams, and team assignments included. It is

the source for any other system requiring this data. In this system we

record the team meeting minutes per day used by different team including

the staff and clients information in every team. A summary report is

automatically generated when the team is recorded.

Responsibilities:

. Involved in designing the Conceptual, Logical and Physical data models

for the application.

. Designed and Developed User Interface using ASP.NET, Javascript, AJAX

& Windows Form.

. Developed Business Logic Components using VB.NET

. Implemented Data Access Layer using Microsoft Application blocks.

. Developing Technical Design document and unit test cases.

. Written simple and complex stored procedures and functions.

. Created SQL Server Functions using CLR.

. Created User Controls on the Web Forms.

. Designed the interfaces needed for exposing the Business Components.

. Creating reports using SQL Server Reporting Services & Telerik

Reporting.

. Created Css Stylesheets to make sure all the web pages uses the same

theme.

. Created web services to get the data from different data sources

database.

. This application was a data driven application. Every attribute in the

data model is uniquely identified.

. The extraction of data is done by using dynamic SQL, stored procedures

and user defined functions to produce uniquely identified Data

Dictionary

Environment : ASP.NET 2.0, VB.NET 2.0, ASP.NET, ADO.NET, JavaScript, CSS,

SQL SERVER 2005,

Telerik Suite for ASP.NET AJAX 2.0/3.0, Telerik Reporting 1.0/2.0.

Client: Bluko Information Group, Las Vegas, NV

Duration: Oct 06 - Feb 07

Title: US Pay card

Role: Dot Net Developer

Description: This project is about Payment Cards. This company is one the

leading companies in Payment Card Industry. The project is based on totally

new concept i.e., their targeted customers are employers or companies. The

main idea behind this is to provide pay cards to employers for payroll

purpose. The benefit for employers is very less paper work for payroll.

This card can be used as debit and credit card for purchase, can be used to

withdraw money from ATM machines. This is Master Card and the development

is totally secured as per PCI rules and regulations. There are many

different programs available for employers.

Responsibilities:

. Designed and Developed User Interface using ASP.NET

. Developed Business Logic Components using VB.NET

. Developing Technical Design document and unit test cases

. Written stored procedures and triggers

. Used extensively User Controls on the Web Forms

. Designed the interfaces needed for exposing the Business Components

. Handled production issues involving real-time application problems

Environment : ASP.NET 2.0, VB.Net, ASP.NET, ADO.NET, Web Services,

JavaScript, CSS, Flash,

SQL Server 2005, Crystal Reports

Client: Net Decisions, New Delhi, India

Duration: Jul 03- Aug 06

Project: Proposal Builder

Description: Proposal Builder is a web-based tool that allows a salesperson

to quickly build a customer-ready proposal in just minutes. Users can

tailor the proposal to their audience by selecting appropriate needs,

issues, value propositions and customer industry. Over 30 industries are

represented. A salesperson can include product information for up to four

of over 200 available products. Product descriptions explain what the

product is, how it works, and what benefits it provides. The product

descriptions are maintained in Liquid Content format (XML). Once all needed

selections are made, Proposal Builder creates and returns a Microsoft Word-

based proposal that the user can edit and print. Proposal Builder is

available in three different versions: Wizard Warehouse, Horizon and SCP.

The Wizard Warehouse is the stand-alone version and is accessed via the

Sales One website.

Responsibilities:

. Designed the architecture and developed libraries

. Designed and Developed ASP.Net pages

. Involved in writing integrated Test Plans

. Implemented the Change Request Management

. Used VSS for version control

Environment: ASP.NET, VB.Net, JavaScript, XML, HTML, MSAccess

Client: Net Decisions, New Delhi, India

Duration: Nov 02 - Jun 03

Project: CR-Tracking

Description: CR Tracking is a change request management system, used for

managing change requests for the projects. The system allocates resources,

assigns teams and also used for storing documents for the given change

requests. Our clients can check the status of the projects, can access it.

It has role-based access for the system. It has features for approving the

request/rejecting the request used as a CR in the system

Responsibilities:

. Involved in Analysis and designee of the project

. Developed the ASP pages

. Written Stored Procedures and triggers

. Validations done in Javascript

. Writing and Executing Unit Test cases for the developed Pages

. Involved in production support

Environment: Classic ASP, VB 6.0, VBScript, JavaScript, HTML, SQL Server

2000.

Client: Agriculture Department, Punjab

Duration: Feb 01 - Oct 02

Project: Personal Management Portal

Description: Personal Management System is designed to create and maintain

the database of all employees working in a Department. All information of

employees is collected through an application form given to employees. This

information is stored in database so that required information for the

employee and management is available.

Responsibilities:

. Designed and Developed ASP pages

. Validations done in JavaScript

. Writing and Executing Unit Test cases for the developed Pages

. Involved production support and maintenance of the project

. Involved in Change Request process

Environment: Classic ASP, VB 6.0, VBScript, JavaScript, HTML, MS Access

Education:

Bachelor of Computer Science, Gurukul Kangri University, Haridwar, India

Contact this candidate