.Net Sql Server

SUMMARY

*+ years of experience in all the phases of SDLC including Analysis, Design, Development, Implementation and Testing of Web Based, Client-Server and n-tier architectures

Technically expert in Microsoft .NET Framework such as .NET Framework(4.5.1/4.5/4.0/3.5/3.0), ASP.NET, ADO.NET, C#.NET, VB.NET, Visual Studio.NET 2013/2012/2010/2008

Extensive experience of designing and developing software applications with ASP.NET, ADO.NET, C#.NET, VB.NET, AJAX, LINQ, WCF, WPF, JavaScript, JQuery, XML, CSS, HTML

Expertise in using ADO.NET features and worked extensively with DataAdapter, DataSet, DataReader to access and update SQL and Oracle databases

Experience in developing pages using LINQ feature

Widely used LINQ to SQL for querying the database

Expertise in ASP .NET MVC and developed Views, Partial Views, Areas etc. and also implemented Controllers, Controller Actions, Filters, and Routing

Knowledge in developing and supporting WIN Forms and Web Forms

Worked with n-tier architecture and SOA using WCF

Experience in designing and developing front end web applications using JavaScript, XML, CSS, HTML

Worked with Angular JS and JQuery

Widely used AJAX Control Toolkit for fast and better User Interface

Good experience in database applications using Stored Procedures, Triggers, Joins, Views using T-SQL and PL/SQL in SQL Server and Oracle 10g

Experience in building Web Services using WSDL and SOAP Protocol

Experience in utilizing all Microsoft Data Access Technologies including Entity Framework ORM

Expertise in creating web pages in ASP.NET using C#.NET/VB.NET and AJAX

Involved in designs using service oriented architecture (SOA)

Worked widely with SSRS and crystal reports to generate reports

Good knowledge about Windows Presentation Foundation (WPF) and Silverlight

Sound knowledge in Object Oriented Analysis and Designing (OOA and OOD), Object oriented programming (OOPS)

Experience in working with Agile(SCRUM) methodology and Waterfall methodology

Experience in working with Bug Maintenance system that involved Bug reporting, Bug fixing. Involved in developing Test Cases

Extensively used Visual Source Safe (VSS) and Team Foundation Server (TFS) version controls to update the status of the development

TECHNICAL SKILLS

.Net Technologies

.Net Framework 4.5/4.0/3.5/3.0, ASP.NET, ADO.NET, WCF, Web Services, Web Forms, Win Forms,

Programming Languages

C#.NET, VB.NET, JavaScript, AJAX, C, C++, T- SQL, PL/SQL

Web Technologies

ASP.NET, XML, HTML 5, CSS 4/3, JavaScript, JQuery, AJAX, Angular JS

Databases

MS SQL Server 2012/2008/2005, Oracle 10g/9i,

Design Methodologies

OOPs, OOAD, UML

Protocols

TCP/IP, HTTP, SOAP, WSDL

Reporting Tools

SQL Reporting Services (SSRS), Crystal Reports

Version Control

Visual Source Safe 6.0, Perforce, Team Foundation Server

Development Environments

Visual Studio. Net 2005/2008/2010/2013, MS FrontPage, MS Office

PROFESSIONAL EXPERIENCE

STATE FARM INSURANCE, BLOOMINGTON, IL March 2015 – Present

Position: Sr.Net Developer

Description: The Client is a leading US insurer, one of the 20 largest corporations on the Fortune 500. This project involves data management, which needs several database activities. Our team is responsible for creating test data for the executioners, helping designers to write their test cases, working with DBA to resolve various DB issues, and we own and support test data tools which are developed in ASP.NET, and some in Java.

Responsibilities:

Involved in full life-cycle of the project from requirements gathering to transition

Developed UI, presentation layer using HTML, JavaScript, AJAX Tools and ASP.NET pages in C#

Designed and developed Rich Internet Applications (RIA's) with the help of Angular JS

Developed Business Logic using C#

Used ASP.NET MVC 4.0 design pattern to develop product

Developed ASP.NET MVC 4.0 applications using Code First Approach in Entity Framework.

Implemented Partial views in ASP.NET MVC 4

Extensively used ASP.NET web controls, validation controls, data validation features for the UI.

Experience in LINQ for querying different datasets

Programmed ADO.NET for communication between application and database, used extensively DataSet, DataTable and DataAdapter to render reports.

Wrote SQL queries, views and stored procedures using T-SQL

Designed custom master pages and custom page layouts

Used sessions for security and proper navigation.

Create WCF Service interfaces.

Develop WCF service for export and import of data and exposed them through SOAP, HTTP and XML

Generated downloadable Excel sheet to the browser for reporting

Generated downloadable CSV files to the browser for communicating with external application

Used Team Foundation Server (TFS) for version controlling

Developed reports using SQL Server Reporting Services (SSRS)

Involved in Build, Debug and deployment of the Components

Environment: NET 4.5, C#.NET, ASP.NET, IIS 8.0, Visual Studio 2013, ADO.NET, WCF, XML, JavaScript, CSS 4, Angular JS, MVC 4, Windows Server 2012, SQL Server 2012, TFS

CAPITAL ONE, VIENNA, VA Jan 2014 to Feb 2015

Position: Sr.Net Developer

Description: Configuration management database (CMDB) is a repository of information related to all the components of the information system involving integrations with other systems.

Responsibilities:

Study, understand and analyze the project requirements

Developed Web applications using ASP.NET and application logic using C#.NET

Involved in developing front end using JavaScript, HTML 5, and CSS 4

Used JQuery for validation controls

Implemented Service Oriented Architecture (SOA) using C#.NET and WCF to decouple the User Interface with Business Logic Layer

Developed web applications using ASP .NET MVC 3.0 using Code First Approach in entity framework

Used WPF and WCF to communicate with Data Access Layer

Responsible for communicating and providing real time data from integrated server to Client Application.

Worked on Agile Methodology (Scrum) to meet timelines with quality deliverables.

Created Views and involved in database design, wrote Stored Procedures, Triggers and functions using T-SQL in SQL Server

Designed and developed Web Forms in ASP.NET using .NET framework in C#

Used .NET AJAX controls to dynamically render the content on web pages developed using C#

Used WCF for building service oriented applications.

Used Master Pages and CSS to output a uniform look for the application.

Used ADO.NET and its components DataReader, DataSet, Connection and DataAdapter to access the SQL database.

Used LINQ to Entity for querying the database

Implemented Web Services using WSDL and SOAP

Used Visual Source Safe (VSS) as a version control.

Created test cases using NUnit and performed unit testing using C# and NUnit Framework for the implemented modules.

Used SSIS to load data from source files to target tables.

Environment: .Net Framework 4.0/4.5, Visual Studio 2010/2012, VB.NET, C# .NET, ASP .NET, ADO.Net, MVC 3.0, SQL Server 2008/2012, WCF, WPF, XML, IIS 8.0/7.0, JavaScript, JQuery, HTML 5, CSS 4, Windows Servers 2008, AJAX, and VSS 6.0.

WELLS FARGO, WHITE PLAINS, NY Oct 2012 to Dec 2013

Position: Mid-level.Net Developer

Project: Online Banking

Description: This project was an on-line system where customers could go in and perform online transactions or apply for new loans or open accounts. This project involved complete .NET Framework and implementation of database using MS SQL Server.

Responsibilities:

Involved in the analysis, design, development and testing stages of the project

Rational Modelling was used for the UML diagrams like use case diagrams, object diagrams, class diagrams and sequence diagrams to represent the detail design phase.

Designed Presentation layer using ASP.NET, Ajax Controls, and CSS 3

Implemented Business Logic Layer using C#.NET

Involved in creating rich and interactive UI using WPF and VB.NET components.

Deployed Custom User Controls and Server Controls.

Used Microsoft Enterprise Library as it is a set of tools and programming libraries for the .NET Framework.

Implemented WCF for communication between Business-to-Business (B2B) and Business-to-Consumer (B2C)

Deployed AJAX Server Control and toolkit to asynchronously retrieve data from server for a better performance and an increase in interactive animation on web pages.

Used ASP objects like Request, Response, Query string, Server and Application.

Extensively used XML, XSLT and XSD for data transfer across different systems.

Used ADO.NET for accessing Oracle10g database

Wrote Stored Procedures, Triggers, Packages and Views using PL/SQL in Oracle.

Tested the developed application, unit testing for various use cases and documented the results for getting approval from business users.

Involved in Unit Testing for the developed .NET applications.

Environment: .NET Framework 4.5/4.0, Visual Studio 2010/2012, C#.NET, VB.NET, ASP.NET, WPF, WCF, CSS 3, XML, AJAX, ADO.NET, Oracle 10g, IIS 7.0, Windows Server 2008

APOLLO MUNICH HEALTH INSURANCE, HYD, INDIA Aug 2011 to Sep 2012

Position: Junior .Net developer

Project: Health Insurance Policy system

Description: This web-based application allows authorized users, both inside and outside the organization, manages claims and assignments, and recommends next steps. Also monitors new claims, assignments and rejected claims. Keeps track of all assigned claims until the files are closed. Notify partners via email of new assignments, and reduce their response time through automatic new-claim and next-action alerts.

Responsibilities

All the user interface layers, web pages are created and integrated to maintain the data flow and data integrity using ASP.NET User Controls and Web Controls

Implemented Business Logic in C# using Database Authentication.

Used ADO.NET for database connectivity

Client side and server-side validations were done using JavaScript

Implemented Web Services using WSDL and SOAP.

Used XML to transfer data between the Client and Server

Developed a powerful search functionality, which retrieves results based on search criteria across several datasets.

Developed Stored Procedures, Triggers, Views, and Cursors using PL/SQL to perform the Data retrieval from multiple tables in Oracle 10g

Created the database objects like tables and related table constraints.

Source code maintenance using Visual Source Safe

Environment: .NET Framework 4.0, ASP.NET, C#.NET, ADO.NET, Oracle 10g, Windows Server 2008, IIS 7.0, Java Script, SOAP and XML Web Services, VSS

RAMADEVI SOFTWARE PVT LTD, HYDERABAD, INDIA Sep 2009 – Jul 2011

Position: .Net developer

Project: Financial System for Publishing Companies

Description: SOFIA is a financial system for Publishers, which control all the financial aspects of wholesale and retail publishing. The System is a Web Application developed on ASP.NET Technology and included building a Windows based front-end interface for managing the system and database.

Responsibilities:

Involved in Design, Development and Testing of Windows Forms, Web Forms and Web Services using IIS, ASP.NET, XML Dataset and .NET Framework

Design and developed components using C#.NET

Design and Developed windows UI components using VB.NET

Created Role Based security levels for Windows Forms Authorization.

Implemented server caching techniques, state management, windows and FormsAuthentication in ASP.NET.

Involved in customizing the Windows Forms DataGrid

Developed custom controls for Windows Forms and generating reports.

Involved in the development of SOAP based XML Web Services like financial account management and purchase orders which forms the business logic components of the system.

Used ADO.NET extensively to access the database.

Created Stored Procedures, Functions and Triggers

Used the N-Unit for unit testing of the classes.

Environment: .NET Framework 4.0/3.5, VB.NET, C#.NET, ASP.NET, ADO.NET, Visual Studio .NET 2008/2010, XML, XSL/XSLT, SOAP, SQL Server 2008/2005, IIS 7.0/6.0, Windows Server 2008/2003

Contact this candidate