.Net Sql Server

Pankaj Kumar Sharma

PROFESSIONAL SUMMARY:

. Over 8

years of professional experience in all stages of the SDLC (Software De

velopment Life Cycle) involving requirements gathering,

analyzing, designing, implementation, testing, deployment,

documentation and maintenance of various stand-

alone, intranet, client-server and web-based projects with

exposure to diverse business domains including Banking, Telecom

and Retailing.

.

Strong Experience in developing web application using C#.NET, VB.NET, AS

P.NET, ADO.NET and Visual Studio 2012-2005.

. Fair Experience in developing Mobile application using C#.NET, ASP.NET

MVC, Entity framework Angular JS and Visual Studio 2012-2005

.

Excellent working knowledge in developing web application using technolo

gies like ASP.NET, C#.NET, ADO.Net, IIS 7.0/6.0, JavaScript,

JQuery, HTML, CSS XML, XAML, AJAX, WCF, WebAPI,Entity framework and

awareness and strong understanding of WCF, LINQ.

.

Experience with OOP/OOD (Object Oriented Programming and Design)

like Inheritance,

Polymorphism, Encapsulation and Design patterns like factory, fa ade,Singleton, MVC, MVP,MVVM,Object pool standard solution

to common problems in software design Patterns in 3-Tier, N-

Tier and Service-oriented architecture (SOA) applications.

.

Extensive experience of designing and developing software applications w

ith Microsoft Visual studio 2013/2012

/2010/2008 and .Net Framework 4.5/4.0/3.5/3.0/2.0/1.1 using C#.Net and

ASP.NET.

.

Extensively worked with business analysis and requirements in Agile Meth

odologies such as SCRUM, Test Driven Methodologies.

.

Strong abilities in Database Programming using RDBMS databases like SQL

Server 2012/2008/ 2005, Oracle 10g and MS Access.

.

Extensively worked on writing Stored Procedures, Triggers, Functions, Vi

ews and Database Design.

. Experience in using Language - Integrated Query (LINQ) to query

and retrieve data from different data

sources (LINQ to Objects, LINQ to XML, and LINQ to SQL).

.

Good command over Query Optimization using SQL Server Query Execution Pl

an Analysis.

. Experience on working with Windows Communication Foundation (WCF) and

WebAPI.

.

Understanding and implementation of Silverlight with rich graphics, user

interaction.

.

Experience with Data Accessing including using DataAdapter, DataReader a

nd DataSet in ADO.NET

and LINQ (Language Integrated Query) Providers for data manipulation.

.

Experience in manipulating XML, Converting Data between ADO.NET and XML

and ProvenKnowledge

in DTD, Schema, XSL (XSLT, XPath, and XQuery) and LINQ.

. Experience in .NET security features such as Authentication (Windows-

based Authentication, Forms-based

Authentication) and Authorization (Authorizing Users and Roles)

.

Experience includes Design, Development, Integration testing and Impleme

ntation of Enterprise Distributed systems

.

Great Team Player with excellent communication, analytical, verbal and w

riting skills along with strong management, organizational

and mentoring skills.

TECHNICAL SKILLS:

Programming Languages C, C++, Visual C#, VB.NET

Web Technologies ASP.NET, ASP, HTML, AJAX, XML Web Services,

WCF, WPF, WebAPI

Scripting Languages & JavaScript, JQuery,Angular JS

Framework

Markup Languages HTML, DHTML, XML, XAML

.NET Technologies .NET Framework (1.1/2.0, 3.5, 4.0), ADO.NET,

Web Services

Software Engineering SDLC, UML, Agile Programming

Database Development SQL Server (2000/2005/2008), T-SQL, DTS, and MS

Access

XML Altova XML Spy 2007, XML, XSL, XSLT, XSD, SOAP,

WSDL

Operating Systems Windows XP/2000/NT/Vista

RAD/IDE Visual Studio 2003/2005/2008/2012/2013, Visual

Basic 6.0

Version Control Visual SourceSafe, Team Foundation Server

(TFS)

Modeling and Testing Microsoft Visio 2003, nUnit.

Tools

EDUCATION:

. Master In Computer Application, UP technical University,2004

. Bachelor of Science in Physics and Math, Kanpur University,2000

PROFESSIONAL EXPERIENCE:

Sprint, USA

Ericson

Jan 12 - Jan 15

Senior .Net Developer

Responsibilities:

. Involved in understanding user requirements, designing and developing

web application and back end applications.

. Interacted with business analysts, end users and worked on the

application specifications to develop detailed functional, technical

design, and test specifications that fully satisfy business

requirements.

. Design web application wireframe as per business requirement

. Designed and develop user interface for public web application and

intranet application using Visual Studio 2012, ASP.NET, C #.NET, and

ASP.NET MVC5, Entity Framework, AJAX, XML and CSS with object oriented

programming techniques. Used various features of C# and Asp.Net (e.g.

reflections, generics, partial classes, LINQ, ASP.NET MVC5, Entity

framework, JQuery etc.).

. Develop views in .cshtml razor for responsive UI used in Web and

Mobile Application.

. Developed validations using JavaScript, JQuery and Angular JS.

. Developed MVC architecture by using Asp.net MVC application.

. Developer presentation layer of both public and intranet application

. Build technical architecture of application and document design in

high level and low level design document.

. Managed authorization using windows groups and using ASP.NET roles.

. Developed, configured and consumed Web Services in C#.net using WCF.

. Used C# extensively for creating Business Object and data access

object and XML based data entities.

. Developed UI, presentation layer using HTML, JavaScript, Angular,AJAX

Tools and ASP.NET pages in C#, HTML

. Develop application infrastructure component like logging, exception

handling, data access, caching and cryptographic application block.

. Demonstrating the architectural implementation through code and design

. Design application architecture, design and code reviews

. Develop systems using .NET components and implemented the Data Access

layers using Entity framework. Used Repository and Unit of work

pattern for consistent access of the data from data layer.

. Develop stored procedures, functions, triggers using SQL and T-SQL in

SQL Server 2008 for fetching data and binding.

. Develop .rdl reports using MSBI (SSRS, SSIS).

Environment: Visual Studio.Net 2010, C#.NET 4.0, ASP.NET MVC5, Ajax,

Entity framework, HTML, LINQ, XML, SQL Server 2008,, TFS, CSS, JavaScript,

JQuery, Angular, webAPI, MSBI(SSRS,SSIS)

Citi Bank, USA

TCS

Nov 10 - Dec 11

Senior .Net Developer

Responsibilities:

. Designed GUI using ASP.NET controls, Master Pages, WCF, HTML, CSS and

JavaScript.

. Used XAML to design the front end in Windows

Presentation Foundation (WPF).

. Designed and developed various abstract classes, classes to construct

the business logic using ADO.NET MVC.

. Coding the presentation layer using WPF and silver light and service

layer using Windows Communication foundation technology.

. Created User Controls using ASP.NET 3.5 and C#.Net 3.5 and Applied CSS

for the controls that are used in different modules of case compass.

. Designed and developed application using 3-tier architecture.

. Extensively used ASP.NET Grid View, Data List and Repeater controls

for displaying the data in a clear format.

. Parsing, querying, scraping, and transforming XML and HTML.

. Developed Validating transactions using XML.

. Worked on integration of code behind web forms development in C#.NET

with Data Access layer using ADO.NETSQL Server.

. Designed and Developed User Interfaces using Visual Studio 2005/2008,

WCF, LINQ, UML, HTML and XML

. Optimized Application using jQuery, JavaScript, AJAX, Caching and CSS/

JavaScript

. Created Silverlight User controls for Add/Remove functionality in Grid

display.

. Used WCF to upload time records and to maintain up-to-date budget

information.

. Worked with SQL Server to create tables, indexes, stored procedures,

functions and views based on user requirements.

. Achieved database connectivity and data processing using ADO.NET.

. Used jQuery for client side validations.

. Used SQL Server Integration Services to upload data from Excel, Flat,

Xml files into database.

. Used Silverlight to provide media stream for customers to know more

about the policies.

. Worked on SQL server reporting services to generate reports.

. Used Visual Source Safe control for sharing and editing of data.

Environment: .NET Framework 3.5, C#.Net, ASP.NET, ADO.NET, XML,

JavaScript, Ajax, HTML, Visual Studio 2005/2008, XAML, WCF, WPF, jQuery,

SQL Server 2005, IIS 6.0, VSS.

University of California (UCOP)

Eforce Pvt. Limited

June 06 - Sep 10

Dotnet Developer

Responsibilities:

. Involved in Analysis, Design and Development of the application.

. Developed the user interface in ASP.NET using Webforms.

. Created new Database Structure based on the requirements

. Created various types of class libraries/assemblies using object-

oriented programming implemented on top of C#.Net

. Used Microsoft Visual Studio 2008, Linq to SQL, and ADO.net for back-

end; ASP.NET 3.5 and jQuery for front-end development.

. Built a heavy front end using HTML/CSS/JavaScript.

. Used Editable Data Grid Controls to generate responses based on client

requests.

. Used DLLs to implement business logic and to integrate the

application.

. Used ADO.NET for data querying, storage and manipulation. Designed and

Implemented Data Access Layer (DAL) using ADO.NET to

communicate with SQL Server 2008.

. Used Custom Validators, Validation Controls and performed validations

both on client side and server side.

. Created applications using C#, ADO.NET, ASP.NET, Web Services, CSS,

XML, AJAX, HTML and MS SQL Server.

. Implemented Remote Validation using unobtrusive JavaScript

. Extensively developed components using C# .NET.

. Used ASP .NET Validation controls.

. Used ADO.Net to pull data out of the database and use it in the

application.

. Made use of Grid View, Data List and Repeater Controls to display

data in a customized format in the ASP.NET web pages.

. Configured the Web.Config file for authentication, session, trace.

. Created various Tables, custom views, indexes and relations using SQL

Server Enterprise Manager

. Written Stored Procedures and SQL queries with Joins on multiple

tables.

. Involved in unit testing on the application.

Environment: : ASP.NET 3.5, C#, SQL Server 2005,Web Services, Ajax,

JavaScript, HTML, Visual Studio.NET 2008, Windows XP, UML, XML, CSS,

Crystal Reports, Visual Source safe.

Docuglobal, USA

Praxis Softek Solution.

May 05 - May 06

Dotnet Developer

Responsibilities:

. Modified the existing logic by separating the business logic and

application logic.

. Made some enhancements for VB.net winform provided by business users.

. Developed the business logic and code behind with C#.NET.

. Prewritten stored procedures were executed using the SQL Command

objects.

. Used Data Grid, Data List, Repeater controls to show detailed

information.

. Developed the Data Layer using Microsoft Enterprise Library

. Authentication is performed using Form based Authentication.

. Involved in developing, business objects layer, business logic layer,

Services Layer, Data Access layer and written methods C# using Visual

Studio-2005

. Developed custom controls and user controls for reuse as per

requirements in C#.Net

. Used Session Management and ASP.NET validate controls for validating

the information provided by the user.

. Used XML intensively to bind the data to the Web Controls, Data

manipulation to store data.

. Implemented Java script to create plug-ins on top of the JavaScript

library

. Used caching technique, which dramatically improved web application

performance like throughput and scalability.

. Developed the user interfaces of the application using ASP.NET Server

Controls, HTML Controls, XHTML, Java Script and CSS

. Created SQL scripts, stored procedures, triggers and views in MS SQL

Server 2005.

. Used ADO.NET classes provided by the .NET Framework for database

connectivity.

. Designed and created tables, views and stored procedures for SQL

Server database

Environment: : .Net Framework 2.0, C#, SQL Server 2005, JavaScript, XML,

Visual Studio 2005, ASP.NET, ADO.NET, Crystal Enterprise.

Contact this candidate