Sign in

Sql Server .Net

Hyderabad, Telangana, India
February 05, 2018

Contact this candidate


Hari P

Sr .Net Developer

Phone: 817-***-****


Professional Summary:

About 7 years of extensive experience in complete software life cycle involving Analysis, software development life cycle, design, development, testing, packaging and deploying of Windows Applications, Web Applications and Client/Server Applications on Microsoft platform.

Excellent Knowledge and working experience in Object Oriented programming (OOPS) concepts and using various Design Patterns

Excellent knowledge and proficient working experience in .Net Framework (2/3/3.5/4/4.5),C.NET, ASP.NET MVC 2.0/3.0/4.0/5.0,WCF, Web API

Worked with SQL Server - Writing SQL Scripts, Stored Procedures and triggers, performing query optimization, indexing, Constraints

Experience in Data Querying using LINQ and Entity Framework to model the entities, logic and data manipulation

Intensive knowledge and hands on experience Object Oriented Design Patterns like Dependency Injection, Abstract Factory, Factory Method, Repository, and Singleton.

Having hands on experience on web-based repositories hosting services such as GitHub, Gitlab and Bitbucket with Enterprise Edition as well.

Experience in using build management tools like MAVEN, ANT, NAnt, Make, Cmake and MSBuild for the building of deployable artifacts from source code.

Designing and developing rich application for Windows (WPF, Win forms) and web (Silverlight).

Designing and developing multiple Windows service to collect data from multiple sources

Good knowledge in developing and designing reports through SSRS and Excel

Hands on working experience in using Team Foundation Server, Microsoft Visual SourceSafe and Subversion for Version Controlling.

Experienced in XML Web Services (SOAP, WSDL and UDDI),Service Oriented Architecture [SOA] concepts using .NET Framework and Database Programming using TSQL and PL-SQL

Demonstrated proficiency in development using Microsoft.NET technologies like WCF, WPF, LINQ, ASP.NET, C#, VB.NET and AJAX

Experience with MS SQL Server and Oracle.

Experience in Agile, Scrum methodologies

Experience working with Unit Test Framework, involved in Unit testing and have created unit test cases.

Working experience with HTML, HTML5, CSS, CSS3, XML, XSLT, JavaScript, JQuery,knockoutJS

Good experience in coordinating and working with developers (Offshore and Onsite) and End Users in Team based environment.

Technical Skills:


.Net Framework1.1,2.0,3.5, 4.0,4.5,ASP.NET,MVC3.0/4.0/5.0, ADO.NET, Entity Framework, LINQ, WCF, Web API, Restful Web Services

Programming Languages

C, C++, C#, VB.NET.

Scripting Languages

Java Script, Ajax Script,PL/SQL,AngularJS


Visual Studio .Net 2003/2005/2008/2010/2013


SQL Server 2000/7,2005,2008, Oracle 8i/9i

XML related Technologies

XML, XSLT, SOAP, WSDL, UDDI, Web Services.

Operating Systems

Windows 95/98/2000/NT, XP, Windows 7

Professional Experience:

State of Wisconsin, Wisconsin May 2017 – Till Date

Sr.Net Developer

State of Wisconsin offerings use proven methodology with Industry Best Practices and Information Technology Standards.


Developed the UI using ASP. NET and C#. Used ASP.NET User Controls, Custom Controls and Data Grid Web Control.

Implemented the project using Agile Methodology and SCRUM Implementation

Developed web pages using HTML, Cascading Style Sheets (CSS), JavaScript and ASP.Net controls.

Designed interactive ASP.NET MVC views using JQuery, HTML5, CSS3, AngularJS and AJAX to provide excellent user experience.

Worked with SQL Server 2012 including Transact-SQL, stored procedures, functions, views, triggers, indexes, query tuning, SSIS, and RDBMS.

Responsible for enhancement and maintenance of existing applications and extensively worked in production support.

Developed RESTFUL Web services, APIs, and other back end components.

Used AJAX controls for multi lookup in the forms.

Worked with MVC3.5/4.0/5.0 architecture application using Razor view engine and WebAPI.

Worked in multiple projects like DSPM, Digitaldocs,using .net platform.

Worked with Entity Framework, LINQ and Lambda expressions to query and retrieve selective based information from the collection objects.

Design and implemented ASP.NET MVC AngularJS SPA web solutions with industry best practices and design patterns.

System Designing using Unified Modeling Language (UML) and experience in Design Patterns

Responsible for designing web pages using ASP.NET MVC, C#, JavaScript, JQuery, Angular.JS and HTML controls.

Worked with SQL Server 2012 including Transact-SQL, stored procedures, functions, views, triggers, indexes, query tuning, SSIS, and RDBMS.

Involved in Implementing Service Oriented Architecture (SOA) and used WCF and REST services to expose business logic as services and consumed those services.

Implemented enhancement features for DSPM System in ASP.NET 3.5 (C#) and Windows application.

Various Validation controls are used to validate each and every control on a Web form and client side validations with JavaScript and JQuery.

Design and develop web based solutions through all the SDLC phases including business requirements gathering, front end web page design and implementation, database implementation, testing, prepare technical and release documentation.

Excellent experience in creating & consuming Web services using SOAP, XML, REST, JSON

Developed the server side code using C# and client side code using Java Script with Visual Studio IDE and Team Foundation Server.

Developed and Implemented SOA using WCF in the appropriate scenarios to communicate with other applications.

Designed and developed the required SQL stored procedures, T-SQL, and functions.

Involved in test cases preparation and performed unit testing.

Worked on TFS Environment for Source Code Control and have created Branches to work on different versions of the project.

Developed Data Access Layer Using ADO.NET and accessed Data Using Stored Procedures.

Used SQL Server Reporting Services for creating and managing interactive reports.

Performed End-to-End Testing and troubleshooting, debugging and integration.

Environment:.Net 3.5, 4.0,4.5, C#, MVC 4.0, Win forms, Visual studio 2012/2010, TFS, CSS,CSS3, Ajax, JQuery JavaScript, AngularJS, JSON, WEBAPI, Entity Framework, Xml, LINQ,REST, Web service, WCF, SQL Server 2012, T-SQL

Dell, Austin, TX Feb 2016–Apr 2017

Sr.Net Developer

Dell is a multinational computer technology company that develops, sells, repairs and supports computers and related products and services.


Participated in system specification meetings, analyzed user requirements, coordinated with team.

Followed Agile and Scrum Methodology and to produce high Quality software

Assisted in development of new software solutions in C# domain within .Net development framework.

Worked with Visual Studio 2013/2015 .net Framework3.5/4.0/4.5 to implement Business Logic.

Proficient in Developing Web Applications in ASP.NET with .NET Framework 4.5/4.0/3.5/3.0 using C and technologies like ASP.NET MVC 5.0 ADO.NET WCF HTML5 CSS SQL SERVER LINQ and IIS etc.

Working on developing new applications using C#.Net and ASP.NET MVC 3.0/4.0.

Developed websites using HTML5, CSS3, JavaScript, Bootstrap, JQuery, XML and Ajax.

Used Razor syntax in creating Asp.Net MVC application by reducing the coding aspect.

Working on developing Views, controllers and business logic models using C#.

Designed and documented REST/HTTP APIs, including JSON data formats and API versioning strategy.

Involved in branding, look and feel of SharePoint sites using SharePoint Designer.

Developed HTML and CSS pages by using Mockups, Wireframes and flow diagrams.

Responsible for developing a new receipt based on business required meeting ITD standards.

Used SQL Server 2012 to build stored procedures, tables and functions.

Used visual studio 2013 to build web applications and to update the existing web applications to the company’s standards.

Design and develop web based solutions through all the SDLC phases including business requirements gathering, front end web page design and implementation, database implementation, testing, prepare technical and release documentation.

Integrated the E-Commerce platform with the payment gateways and accounting system

Developed single page applications (SPA) for fast access.

Created wireframes and mockup using various tools to make clear idea for Business.

Used Bootstrap for ResponsiveWeb design.

Working on building the Views using AngularJS and followed various patterns.

Utilized ASP.NET validation controls and JavaScript to perform client side validation.

Created Database Objects like Tables, Stored Procedures and Views using SQL Server 2012.

Implemented Ajax Asynchronous and Asynchronous calls.

Working with Entity Framework to access the data from SQL Server 2012/2008

Worked on TFS for version control, Code Review and for automatic builds and continuous Integration. Framework 3.5/4.0/4.5, C#, Visual studio 2013/15, MVC, ASPX/Razor view engine, Entity Framework, C#, Java Script, JSON, Ajax &JQuery, XML, E-commerce, Web services, WCF, LINQ, MS SQL Server 2012/2008, TFS and Agile Methodology,AngularJS.

ING, NY Mar 2015 – Jan 2016

Net Developer

This Portal/client server Application for ING Insurance Company application was used for creating online account, policies, quotes, find agent. Application help to maintain customer and create/maintain new/existing customer and their policies and to get quote for and process claim for existing customer for car, house, disaster and worker compensation etc.


Designed and developed Software Development Life Cycle (SDLC) from analysis anddesign to implementation with .Net Technologies

Developed project based on the agilemethodology and Involved in Daily SCRUM.

Developed solutions for diverse programming scenarios in C#, employing object oriented Programming (OOP) concepts such as: encapsulation, inheritance, polymorphism, and abstraction.

Used Silverlight and Expression Blend to provide media stream for customers to know more aboutthe policies.

Created and deployed XMLWeb Services(WCF) using C#, used them to generate the proxy classfiles based on the web services and consumed in web application.

Developed and implemented the software release management for the release of web applications.

Wrote ANT Scripts to automate the build process.

Design and develop web based solutions through all the SDLC phases including business requirements gathering, front end web page design and implementation, database implementation, testing, prepare technical and release documentation.

Designed and developed financial and Premium Billing web application and System window form application. These two integrated applications provide total solution for the company to manage members in the financial group.

Create, maintain and administrating GitHub and Subversion repositories as source code managements.

Used CSS, Master Pages, JavaScript, JQuery, Web Parts and various Data controls, which areused for the entire site giving the site a dynamic look.

Utilized Data Grid and Data List to display and manipulate the records.

Developed complex stored procedure, views and functions in SQL 2008 to compute freight chargesand tuned queries for performance improvement and used LINQ queries to filter data set.

Designed and developed the Triggers and stored procedure logic to process the rules coded in thebusiness logic table.

Development of enterprise reports by pulling data from various sources and presenting in SSRS.

Performed Unit Testing (UTC).

Environment:C#. NET 3.5/4.0, Web services, MVVM, Soap, HTTP, ASP.NET, XAML, Xml, .Net Visual studio 2008/2010,SQL server 2010, LINQ, SSRS, SSIS, .Net Web services, .Net 3.5/4.0, WCF, JavaScript, IIS 7.0/7.5, HTML,DHTML, CSS, UML, Expression blend, Telerik controls.

AFS Logistics, Shreveport, LA July 2014 – Feb 2015

.NET Developer

AFS provides customers a single logistics interface for all logistical needs. This project involves in the development of Bill of Loading (BOL) application to transfer all sorts of goods from any location to any location in USA. The user interface collects all the required information like sender and consignee addresses, the type and amount of items to be transferred, includes a special interface for the transferring of hazardous items and also the type of payment. It also includes different types of transportation like Truckload (TL), Less-Than-Truckload (LTL), Parcel, International, and Air Freight/Expedite. The whole process is automated in which a pickup request is automatically generated to the truck driver when a sender submits the BOL.


Creating and maintaining UI prototypes and specifications.

Collaborating with Product Managers and Software Engineers to provide guidelines on solid UI design.

Keeping up to date with the latest industry trends in UI design and usability.

Translating market and product requirements into UI designs in the form of Conceptual models, Wireframes and prototypes.

Used HTML, XML, AJAX, JavaScript, CSS and pure CSS layouts.

Designed the user interfaces using Web Server Controls which are built on ASP.NET Server Controls and Infragistics Controls.

Responsible for designing web pages using ASP.NET MVC, C#, JavaScript, JQuery, Angular.JS and HTML controls

Developed Business Logic Component using Web Services, WSDL.

Implemented SOAP (Simple Object Access Protocol) for communication of application.

LINQ to Objects for WCF service call.

SSRS for SQL Reporting services.

SQL Server (OUTPROC) Session State Management.

AJAX for rich user experience in designing the screens.

GUI was developed using C#.NET and ASP.NET.

Used .NET Framework 3.0 throughout the project and converted existing code from 2.0 to 3.0.

Modifications were made to the existing GUI using WPF for better look and feel.

Developed and implemented the software release management for the release of web applications.

Wrote ANT Scripts to automate the build process.

Create, maintain and administrating GitHub and Subversion repositories as source code managements.

Consumed Web services using WCF and WPF for online transactions using C# and exposed them through HTTP.

Involved in development of UI (User Interface) Pages using the HTML, Master Pages & ASP.NET Controls and ASP classic controls.

Involved in the design of the system architecture using UML and MS Visio, to develop class diagrams, use cases etc.

Implemented SCRUM methodology for project management.

Developed a demo version of the product to solicit and incorporate feedback into the design.

Worked on ADO.NET components Data Reader, Data adapter, Data Set and Data View to provide connection to the database in SQL server 2008.

Implemented client side scripts using JavaScript.

Wrote business logic, lookup list and edits for data table in C#.

Used Singleton, Class factory and Dispatcher Design Pattern.

Environment:NET Framework, VB.NET, C#, ASP.Net, ADO.NET, Visual Studio 2003, Web services, XML, AJAX, HTML, IIS, SQL Server 2000 and Windows XP

Intel Corporation Beaverton, OR Dec 2013–June 2014

.NET Developer

I-Cost Application is a new inventory costing system that provides visibility for keydecision making while mitigating both financial and operational risksThisapplication provides the ability to better capture and analyses large quantities of information andmanages the changes to the process. This application has an ability to solve the financial risks likevaluation issues basing on inventory, capital investments and FIFO valuation.


Involved in Full Software Development Life Cycle (SDLC) and identifying the requirements and

defining the business rules to user requirements.

Developed components in C# using ADO.NET to provide the functionality for the Data Access

Layer and give access to the database for Inserting, Updating, Deleting and getting the information

from the database through Business Logic Layer

Used ASP.NET AJAX Toolkit controls like Script Manager, Update Panel within some existing web

Developed the independent WCF (Windows Communication Foundation) services and defined

Service Contracts for specific functionality.

Designed dynamic DTS Packages to transfer data crossing different platforms, validate data

during transferring, and archived data files for different DBMS.

Responsible for designing web pages using ASP.NET MVC, C#, JavaScript, JQuery, Angular.JS and HTML controls

Communication between Data Access Layer and SQL Server was established by ADO.NET.

Created Stored Procedures to extract data for generating reports by using SQL Server 2005

Reporting Services (SSRS) and deployed them also created Views for retrieval of data.

Performed unit testing of the applications using N-unit for integration and build process.

Actively involved with the team of developers in knowledge transfer, functionality issues, database Issues, best coding practices and standards.

Environment: .NET 3.5, C#, ADO.NET, LINQ, QCF, OOD, HTML, CSS, AJAX, Jquery, JavaScript, Telerik, SQL Server 2008, VS 2008, IIS, ASP.NET, ASP.NET MVC 3.0.

Digital Media Group, India May 2011 – Nov 2013

.Net Developer

Digital Media is a software development and media marketing company, which develops web sites and applications for its clientsand also develops products with very innovative and unique ideas that can cater to a very wide range of users and has potential to attract really high traffics. The project was to work on the social networking website project which is an interactive search engine for the restaurants, nightlife and shopping spots among the popular cities in the country. People are allowed recommend spots, write reviews, add photos to those venues in addition to having their own profile where they can create any kinds of lists. Designed and developed internal windows application to maintain the list of videos.


Involved in User Interface development using HTML and ASP.NET.

Developed the modules in VS 2005 using ASP.NET, C#.NET, JavaScript, HTML, CSS and ADO.NET.

Client side validation of pages done in and JavaScript and validation controls were incorporated for server side validation.

Involved in development and usage of user controls in various web pages.

Involved in writing stored procedures at the database end.

Used Datasets and Data Grids to retrieve and display the data in the required format.

Involved in transferring the data to the new system using DTS.

Created Views and Triggers and Joins to manipulate the data.

Used Crystal Reports for the reporting part of the application.

Visual Source Safe was used as a source control.

Environment:NET Framework 2.0, C# 2.0, ASP.NET (2.0) IIS, Java Script, Crystal Reports, XML, WCF, Web services, SOAP, Visual Studio 2008, 2010. SQL Server2005, 2008 and Visual Source Safe


Bachelors of technology

Contact this candidate