Post Job Free

Resume

Sign in

Sql Server .Net

Location:
Faridabad, HR, India
Posted:
May 05, 2014

Contact this candidate

Resume:

Rohit

DOT NET

Developer

SUMMARY:

. *+ years of experience in Client/Server and Web Application and

Windows Applications development employing Object Oriented Analysis

and Design (OOAD) using Microsoft Technologies and .NET Framework.

. Strong skills on .NET Framework using ASP.NET, C#, VB.NET and ADO.NET.

. Solid experience in creating CSS (Cascading Style Sheets), Themes and

Skins.

. Excellent understanding of Object Oriented Programming Methodology in

the IT industry.

. Strong in Web Technologies like JavaScript, Web Services, HTML, XML,

XSL, XSD, DTD, XML Schemas, CSS, MVC.

. Good experience in developing desktop applications using Windows

Forms.

. Expertise with all phases of System Development Life Cycle (SDLC) and

UML modeling.

. Good knowledge on WCF, WPF, WF, Generics, Silverlight, Web Parts and

AJAX.

. Good understanding of Enterprise technologies like WCF, WPF, Web

Services (SOAP, WSDL) in the areas of performance, security,

scalability and extensibility.

. Strong skills in developing reporting services like SQL Server

Reporting Services (SSRS) and Crystal Reports.

. Have demonstrated ability to leverage High-level Design Documents to

produce Detailed-level Designs.

. Proven experience in writing the SQL Server 2008/2005 stored

procedure, Functions, Views, Triggers and database administrative

tasks like backup, restore and SQL profiling and knowledge in Oracle.

. Expertise in Analysis, Design, Coding, Component and Assembly testing

of all application code.

. Highly adaptable in quickly changing technical environments with very

strong organizational and analytical skills.

. Excellent communication and interpersonal skills with ability to

interact with individuals at all levels and can work as a part of a

team as well as independently.

. Expertise in various development architectures like Desktop, Console

and Web Application.

. Good knowledge in various design patterns like Singleton, MVC, and

MVVM.

. Good knowledge and experience in implementing Entity Frame Work.

. Good experience in Data Extraction transformation and loading (ETL)

with SSIS and a good knowledge of Informatica power center tool.

. Good experience in using .Net remoting for file transfers.

. Expertise in developing models based on Unified Modeling Language

(UML).

. Good experience in developing windows services using Visual studio.

. Expertise in working with .NET 4.2, 3.5, 3.0, 2.0, 1.1, 1.0 Framework.

. Extensive experience in handling IIS 7.0/6.0/5.1/5.0/4.0 in Website

Deployment.

. Proficiency in Microsoft Word, Excel, Access, InfoPath, Power Point

and MS Project.

TECHNICAL SKILLS:

Operating System Windows NT/2000/XP/Vista/7, Windows 2003 Server

Databases SQL Server 2000/2005/2008/2008 R2, MS Access, Oracle

8i/9i/10g

Languages C, C++, VB6.0, C#, VB.NET, ASP3.0, ASP.NET, ADO.NET,

Visual Studio, .NET 1.1/2.0/3.0/3.5/4, Web Services

Scripting Languages JavaScript, VB Script

Web Servers MS IIS 5.0/5.1/6.0/7.0/7.5

Web Technologies XML, XSL, XSLT,MVC, HTML, CSS, DHTML, Silverlight,

jQuery, WSDL, SOAP

Technologies/ UML, Use Cases, Workflow and Dataflow

Methodologies

Reporting Tools Crystal Reports, Data Reports and Actuate

Project Tools Microsoft Visual Source Safe 6.0/8.0, TFS,SVN,VSS

Virginia Department of Health. Richmond, VA

Jan 2013 - Present

Sr. .Net Developer

Client description: Virginia Health Information' is a resource for patients

and consumers looking to learn about and compare options on everything from

obstetrical services, to heart care, to pricing information on commonly

performed medical procedures.

Responsibilities:

. Involved in requirements gathering, design & development and doing

knowledge transfers.

. Designed and developed using MVC Architecture. Used object oriented

programming techniques to build modules.

. Developed User interface (UI) using C#.NET.

. Worked in WCF, Web Services to implement Service Object.

. Implemented controls like Data Grid, Group Box and Tab control.

. Used Update panel of the Ajax Control toolkit to enhance the Usability

of the application.

. Created Custom User Controls for form designing.

. Used AJAX functionality to give asynchronous calls while consuming the

WCF service.

. Developed rich front-end UI using AJAX Controls, Silverlight,

Expression Blend and XAML.

. Developing rich, uniformed User Interface using CSS, Master Pages,

Themes, Silverlight, AJAX Controls, Web parts, jQuery.

. Wrote Test Classes using Microsoft Visual Studio Team System to

perform Unit test for the individual block of code.

. Used SVN as the source control in the entire development life cycle of

the application

. Involved in Database development like writing Queries, Stored

procedures, functions, and triggers using SQL Server.

. Performed Functional Testing to check the stability of the product.

. Performed Integration testing of the modules of the other developers.

. Perform bug fixes based on UAT and provide production support.

Environment:

Razor Environment, C#.NET, MVC 4.0, .Net Framework 4.2, SQL Server 2012,

WCF, WPF, Microsoft Visual Studio 2010, Web Services, JavaScript, JQuery,

Ajax, Silverlight 3.0, Agile methodology, HTML, CSS, SVN.

Aetna. Hartford, CT

April 2012 - Dec 2012

Sr. .Net developer

Client description: Aetna is one of the nation's leading providers of

health care, dental, pharmacy, group life, and disability insurance, and

employee benefits.

Responsibilities:

. Involved in requirements gathering, design & development and doing

knowledge transfers.

. Designed and developed using MVC Architecture. Used object oriented

programming techniques to build modules.

. Developed User interface (UI) using C#.NET.

. Extensively followed agile methodology and Scrum process for software

development.

. Used SOA in the designing of the application.

. Worked in WCF, Web Services to implement Service Object.

. Implemented controls like Data Grid, Group Box and Tab control.

. Used Update panel of the Ajax Control toolkit to enhance the Usability

of the application.

. Created Custom User Controls for form designing.

. Used AJAX functionality to give asynchronous calls while consuming the

WCF service.

. Developed rich front-end UI using AJAX Controls, Silverlight,

Expression Blend and XAML.

. Developing rich, uniformed User Interface using CSS, Masterpages,

Themes, Silverlight, AJAX Controls, Web parts, jQuery.

. Wrote Test Classes using Microsoft Visual Studio Team System to

perform Unit test for the individual block of code.

. Used TFS as the source control in the entire development life cycle of

the application

. Extensively used ADO.NET to communicate with the SQL Server 2005 and

later migrated to SQL Server 2008.

. Created framework and definition for WCF service support (host and

endpoint) for future implementation.

. Involved in Database development like writing Queries, Stored

procedures, functions, and triggers using SQL Server.

. Designed and wrote several medium-size development tools and end-user

applications using the latest .NET UI technologies such as Expression

Blend and WPF.

. Configured App.Config file for the configuration of the entire middle-

tier Application.

. Performed Functional Testing to check the stability of the product.

. Performed Integration testing of the modules of the other developers.

. Perform bug fixes based on UAT and provide production support.

Environment:

ASP.NET, C#.NET, MVC 3.5, .Net Framework 3.5/4.0, SQL Server 2008 R2,

ADO.NET, WCF, WPF, Microsoft Visual Studio 2008/2010, Web Services,

JavaScript, JQuery, Ajax, Silverlight 3.0, Agile methodology, HTML, CSS,

SVN.

State Farm Insurance. Chicago, IL

Jan 2011 - Mar 2012

Sr. Net Developer

Client Description: State Farm Insurance is a group of insurance and

financial services companies in the United States.

Responsibilities:

. Used XML Schemas, XSLT for data transactions.

. Developed web forms using server controls and html controls

. Used List controls like Data grid control and Data List Control for

display of data.

. Creating and Integrating a user controls and Cascading Style Sheets

(CSS) into Web Pages for user customization of page background and

styles.

. Designed and developed Graphical User Interfaces using Silverlight and

ASP.NET/C#.

. Designed responsive and intuitive user interfaces for the web using

CSS and custom AJAX scripts and JQuery.

. Involved in preparing design documents, developing use cases,

identifying classes and objects, drawing class diagrams, sequence

diagrams using Rational Rose and identifying the design patterns,

frameworks to be used during implementation.

. Developed web pages and validated these pages using ASP.NET, VB.NET

and JavaScript.

Used ADO.NET extensively for data retrieving, querying, storage and

manipulation

. Involved in all the phases of SDLC including Requirements Collection,

Design & Analysis of the Customer Specifications, Development and

Customization of the Application.

. Developed an Admin site to add users and their privileges.

. Used and customized the tree view control and also created various

custom controls which were embedded in various Business Applications.

. Created Inbound and outbound WCF, Web Services, MSMQ have been created

to integrate with Email client and support applications.

. Used JQuery to efficiently use the validation, AJAX calls to various

handlers.

. Developed optimized reusable custom User Controls in ASP.Net to reduce

the complexity in user interface coding and provide better look and

feel.

. Creation of stored procedures, transactions, views, functions in SQL

Server 2005/2008 R2.

. Performance tuning of SQL queries and stored procedures.

. Worked directly with Department employees and IT to build code to

specifications to develop web based application.

. Performed Unit, functional and load testing.

. Validating all the User's Inputs through JavaScript and VB Scripts.

. Created and deployed XML Web Services (WCF) using ASP.Net and C#, used

them to generate the proxy class files based on the web services and

consumed in web application

. Used Visual Studio.Net for developing ASP. Net web applications.

. Used ADO.Net for database programming and connection to database.

. Assisted in the designing of database and also created database

Triggers, Functions and Stored Procedures for ensuring data integrity

using SQL Server 2008 R2.

. Created web pages with generic logic to generate web-based forms from

client's database and at client's request, perform all validations and

error handling at the server level.

. Server To Server communication using With SOAP.

Environment:

C#.Net, SVN, Unix, PHP, ASP.Net, ADO.Net, SQL Server 2008 R2, Windows XP,

HTML, CSS, DHTML, Javascript, JQuery, Silverlight, XML, XSLT, Web Services,

Visual Studio .Net 2010.

Verizon Data Services, Irving, TX

Oct' 2009 -

Dec 2010

Role: .Net developer

Client Description: Verizon Data Services is the technical development wing

of the Verizon telecommunications. IOBI is the latest service product from

Verizon assisting Customers to manage their calls irrespective of their

location, using Web, other telephones as well as Client software. With

Verizon IOBI a customer can constantly monitor his calls, keep track of all

the contacts, receive all this voice-mails on web, send messages on Web to

a telephone, get notifications of the events of importance, Search the vast

information in the directory of Verizon. Iobi is the one stop spot of all

the communication management needs of the Customers.

Responsibilities:

. Study, understand and analyze the project requirements. Designed use

cases, class diagrams and sequence diagrams using MS Visio.

. Developed rich user interface (UI) using ASP.NET 2.0, C#, Web Forms,

User Controls, Server Controls along with AJAX Controls Toolkit.

. Designed and developed various interfaces, classes to construct the

business logic using C#, ADO.NET and XML.

. Created XML Web Services using C#, .NET and consumed to perform the

sales forecasting functionality.

. Implemented Caching, Exception and Custom Error Handling using ASP.NET

and C#.

. Developed various reports using Crystal Reports.

. Written Stored Procedures, Functions using PL/SQL in ORACLE 9i.

. Effectively involved in various stages of the development starting

from the project planning till production and maintenance using Agile

Methodology.

. Designed, configured and developed the web application using ASP.NET,

C#, JavaScript, jQuery and CSS.

. Developed various User Controls to use it across the application.

. Used Grid View, Data List and Repeater controls extensively.

. Used CSS to Design and create various templates to get a unified look

and feel of the Web Forms.

. JavaScript was used to do some client side validations and also used

AJAX to improve performance of the web page.

. Implemented data access layer using ADO.NET.

. Created various Stored Procedures, Triggers and Indexes for efficient

data transfer between databases and to create a log of all the

modifications.

. Effectively created and consumed Web Services at various stages of the

development. For Ex, Insertion of data into database, fetching data

from the database.

. Migrated MS Access database to SQL Server database using SSIS.

. Generated reports using SQL Server Reporting Services (SSRS).

. Involved in the project maintenance doing some bug fixing and doing

knowledge transfer session under time constraints.

. Involved in Unit Testing to test the system application process

. Used VSS for Version Control

. Performed unit testing of the modules implemented by using C# and

NUnit testing Framework.

. Actively involved in providing the technical support of the

application by troubleshooting and resolving the issues.

. Provided user support and business activities support to the

management and various stake holders by giving demonstrations and

conducting training sessions.

Environment: : C#, ASP.NET 2.0, ADO.NET, Crystal Reports, AJAX Control

Toolkit, XML, Web Services, Visual Studio .Net 2005, NUnit testing

Framework, Oracle 9i, Visual Source Safe, MS Visio.

Source One Management, Mumbai, India

May 2008 - Sep 2009

Dot NET Developer

Client Description: IBM & Accenture

Responsibilities:

. Designed and developed the application using Visual Studio 2010 and

Win Forms

. Developed HTML prototype of the web pages using CSS, according to

client specifications

. Extensively used .Net inbuilt components like Grid view, Link button

and other ASP.NET server controls, Win Controls in designing the front

end web pages.

. Implemented bound columns in the data grid to display information to

the user.

. Validating all the User's Inputs through Java Script and Visual Basic

Dot Net.

. Created custom controls that provides customization of pages for the

user interface using ASP.NET.

. Assisted in the designing of database and also created database

Triggers, Functions and Stored Procedures in SQL Server 2005 for

ensuring data integrity.

. Utilized LINQ to SQL technology extensively to interact with the

SQL/Server database 2005 for data retrieving, querying, storage and

manipulation using Entity Data Model.

. Developed, deployed and monitored SSIS Packages including upgrading

DTS to SSIS.

. Performed ETL transformations using SSIS (SQL Server Integration

Services) via the Business Integration Development environment in

Visual Studio 2010.

. Created new design and styles for the web pages using AJAX controls

using the Ajax Control Toolkit to enhance the aesthetic value of the

web pages. Some of the features implemented were hover profiles,

dynamic menus, Cascading Drop Downs, Combo Box, Update Panel

Animation, tooltip dialogs, Calendar control, Collapsible Panel and

some animation effects.

. Designed and implemented styling modules in CSS to format the report

parameter pages.

. Built new web applications and update existing applications to aid in

the digitization of Archives collections.

Environment:

ASP.NET, SSIS, SSRS, ADO.NET, ASP.NET 3.0 Forms Authentication, C#.NET, SQL

Server2005, WCF, HTML, JavaScript, CSS

White Snow Software, Pune India

May 2007 - April 2008

Dot NET Developer

Client Description: Epic Engineering (Florida), Repeat system (Utah),

Global Ktech (Florida) Responsibilities

Responsibilities:

. Actively involved in developing different types of components i.e.

transactional, non-transactional by using VB and deployment of

components by creating packages in MTS.

. Development of ASP pages for User Interface.

. ASP-Server side programming using built in objects, in-house developed

COM components.

. VB 6.0- DLL components are developed to perform business, Tax-

calculations and data access

. Coded MTS based stateless COM components and COM+ using Visual Basic

6.0 for implement the business logic.

. Developed various Reports Using Crystal Reports 8.5 and integrated in

Visual Basic application.

Environment: Visual Basic, ASP, HTML, DHTML, JavaScript, VBScript, SQL

Server 7.0, COM, MTS1.0/2.0, Crystal Reports8.5, Windows NT.



Contact this candidate