Sign in

Sql Server .Net

Hyderabad, Telangana, India
February 01, 2018

Contact this candidate



Phone: 732*******-514


Over 8+ years of extensive experience in all phases of Software Development Life Cycle (SDLC), including Analysis, Design, Development and Testing of Client-Server and Web-based n-tier Architecture for windows and web applications with exposure to diverse business domains.

Strong hands on the Microsoft .Net Framework2.0/3.0/3.5/4.0/4.5 developing Win Forms, Web Services, Win Services, Web Pages using ASP.Net 4.5/4.0/3.5/2.0/1.0, VB.Net, Visual Studio VB Script C#.Net, ADO.NET, ASP, JavaScript, jQuery, Angular JS, CSS, Master pages, HTML, DHTML,XML,XSLT, Silverlight, LINQ, Ajax, and SQL Server SSRS.

Experience with an agile software development methodology and Test-Driven Development including SCRUM

Experience with developing GUI using web technologies like HTML, CSS, Angular JS, jQuery, JavaScript and XML.

Extensive experience in architecture, design and development of Client-Server and Distributed Web Applications with ASP.NET, MVC 3.0, 3-Tire and N-Tire Architecture.

Experience in SOA (Service Oriented Architecture) using Web Services, WCF Services, WEB-API and Restful Services, Windows Services.

Expert in developing Dot Net WinForms/Web applications using C#/Asp.Net.

Extensively worked on Windows Presentation Foundation (WPF) which provides developers with a unified programming model for building rich Windows smart client user experiences that incorporate UI, media and documents in Windows using XAML.

Experience in using Windows Communication Foundation (WCF) in a self-hosting mechanism, implementing the Service-Oriented Architecture (SOA) using the REST methodology to SOAP messages between metadata endpoints, extensively worked on WCF RIA Services.

Extensive usage of Delegates and Events to establish communication between the Win Forms.

Strong in Object Oriented Analysis and UML concepts, Designed Applications using UML and Use Cases and Design Patterns, Agile Methodologies.

Expertise in building Web Services using WSDL, UDDI and SOAP Protocol and consuming/publishing Web Services.

Extensively Used LINQ to SQL, LINQ to XML and LINQ to Objects for retrieving the data efficiently and Just in Time manner.

Developed User Interface in Razor Pages.

Worked on Grid view using ADO.NET and retrieved data from SQL server using quires.

Experience with ASP.NET, Web Forms, win forms, Web Services and State Management, caching features, configuring optimizations and securing the web application.

Experience with AJAX Control Toolkit and XMLHttpRequest object, which is the heart of AJAX in providing asynchronous Post back.

Designed and Implemented application using ADO.NET objects like Dataset, Data Table and Data Adapter for manipulating, retrieving, storing and displaying data from SQL Server.

Extensive knowledge of applying Object Oriented Analysis and Design (OOAD) for modeling a system.

Integrated disparate technologies with Microsoft PowerShell - Entity Framework, MongoDB, ASP.NET Membership, SQLite, OData, etc.

Experience in SQL Server and SSIS (Integration Service) package design, constructing and deployment.

Building web applications with ASP.NET MVC/Web Forms, JavaScript, jQuery, JSON, HTML, XHTML, CSS

RDBMS Experience with Stored Procedures, Functions, Views and Triggers and imports & exports of Data in SQL Server (2012/2008/2005/2000) and Oracle (10g/9i).

Experienced in using Configuration Management, setting up company Version policies, build schedule using Team Foundation Server (TFS) and Visual Source Safe (VSS).

Hands on Experience in developing programs including Unit testing with NUnit for ASP.NET Web Forms.

Worked on cloud computing using Windows Azure and SQL Server Azure.

Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.

Strong experience in design patterns WCSF, WSSF, MVC and MVPC patterns.

Worked on leveraging TFS build tools for building a custom automated build and deployment tools (Octopus, Urban Code) which enabled feature teams to comply with continuous integration process and to generate the release manifest.

Experience with Application Blocks such as User Interface Application Blocks, Log4Net and Database Application Blocks, Entity framework, MVVM design Pattern.

Experience in ORM Tools along with implementing IBATIS framework.

Worked with ASP.NET AJAX to create rich UI web applications and to improve performance.

Good experience in developing, implementing and maintaining applications under UNIX Operating System using SQL, SQL Server, Unix Shell Script, Oracle 10g/9i database.

Good team player with excellent communication and interpersonal skills, ability to work individually or as part of a team.

Fast learner and quickly adapt to new technologies that help improve the business.


.NET Technologies

ASP.NET 1.1/2.0/3.5/4.0/4.5, ADO.NET, AJAX, Classic ASP, LINQ, ADO.Net Entity Framework


C# .NET, VB.NET, Visual Basic, C, C++, Java, PL/SQL, T-SQL

Web Technologies

HTML, HTML5, XML, XSLT, XSD, WSDL, XAML, JSON, SOAP, Angular JS, CSS 3, Web Forms, Web Services, Win Forms, WCF, WPF, MVC, Silverlight 2.0/3.0, XSLT, WSDL, UML

Scripting Languages

JavaScript, jQuery, Visual Basic Script


SQL SERVER 2008/2005/2000, Oracle11g/10g/9i/8i


Microsoft.Net Framework 1.0/1.1/2.0/3.0/3.5/4.0/4.5,4.5.1

Operating Systems

Windows 98/NT/2000/XP/Vista/Windows7/ Windows 8/8.1.


Visual Studio 2003/2005/2008/2010/2012/2013, Visio

Web Servers

IIS (Internet Information Server)5.0/6.0/7.5

Testing Tools

Microsoft Visio 2003, NUnit

Reporting Tools

SQL Server Reporting Services (SSRS) 2008/2005/2000

Version Control

Visual Source Safe,Team Foundation Server, Tortoise SVN, GIT


Client: SEI, Oaks, PA June 2017 – Till Date

Role: Sr.Net Developer


Using Microsoft technologies like C#, ASP.NET, SQL, MVC, MVVM and Microsoft Workflow to develop technical solutions for complex problems.

Involved in using MVC pattern for both UI development with Angular JS and application development with C#.

Involved in parsing JSON and XML files to obtain data to be used by Content Manager and Download Manager.

Creating controllers and views and passing the models to controllers from WCF.

Design, code, test, debug and document software according to the functional requirements.

Design, develop and implement critical in a .Net environment.

Involved in the design and development of application on ASP.Net, MVC, MVVM frameworks while building WPF application.

Writing and Modifying stored procedures, triggers and user defined functions in SQL to carryout database operations.

Mainly focused on the internal project using the VB.Net for code modifications as per the user requirement. Maintained day-to-day production data and reporting the workflow in the daily Stand-up meetings.

Handled all the production based issues by providing the database scripts for updating the data in the prod database.

Built Web pages that are more user-interactive using AJAX, JavaScript.

Involved in development of a responsive single page application using JavaScript framework and JavaScript in conjunction with HTML5, CSS3 standards with front end UI team.

A Continuous integration server called Jenkins has been used for pushing the code changes to the repository by build & deploying the code.

Have good control on the Database scripts to check the new production data and their record state.

Used VDI server to access the production server to monitoring the log files of the applications when the tasks were executed.

Used Postman Rest Client for HTTP Request composer that makes it easy to call web services.

Kept up high level of competency over the Microsoft Application Platform, concentrating on .NET Framework, WCF and Windows Azure.

Engaged with building up the prerequisite with C#, ASP.NET, WCF and Web benefits in .Net Technologies, SSIS bundles and unit testing, framework testing and discharge administration

Utilized SQL Server Standard Edition for database.

Composed put away systems with complex SQL inquiries.

Associated with composing test designs and composing test contents for Unit Testing.

Settled QA bugs for front end and back end.

Rehearsed Agile Methodology with a specific end goal.

Imported information from level records to SQL Server database utilizing SSIS.

Utilized VB.NET to create code for business and vault layer.

Involvement in doing specialized level help, perusing code and SQL Running SQL content to confirm/approve information.

Extensive use of Web Services, SOAP, XML, XSL to expose the reports to facilitate information sharing.

Expertise in using ADO.Net objects such as SQL command, Data Reader, Data Set and Data Adapter.

Used LINQ to build set of operations, parameters and expressions (Binary, Unary, Lambda) during execution (aimed at “Querying”) a set of data from SQL Server.

Utilized Entity Framework Code First approach for the Data Access Layer for the ASP.NET MVC 5 application using HTML5.

Developed stored procedures, Triggers, Views and Cursors using PL/SQL in Oracle Database.

Developed client side code using Angular JS, jQuery and JavaScript.

Responsible for understanding the user requirements and converting them into the coding by implementing the business rules using C#.

Responsible for developing and consuming Windows Communication Foundation (WCF).

Leveraging Visual Studio to track Work Items, carry continuous integration builds, Unit Testing.

Participating in code review session for efficient and effective communication and knowledge-share between teammates.

Involved in Testing like Unit Testing, Integration testing, Acceptance testing and Regression testing using NUnit and responsible for writing test scripts and scenarios.

Resolve and troubleshoot problems and complex issues, run tests and fix bugs.

Involved in Deployment and Maintenance of the project between various environments such as development, production and testing.

Worked with Agile Environment to meet the timelines and interaction with the team and followed Agile Software development methodology to develop the projects.

Environment: ASP.NET, C#, MVC5, MVVM, Visual studio 2015/2017, XML, XAML, JSON, IIS, JavaScript, jQuery, CSS3, Web API, MS SQL Server, Win Forms, WCF, WPF, LINQ, NUnit, Angular JS, ADO.NET Entity Framework, Stored Procedures, GIT, HTML5, SSRS, PL/SQL, Oracle 11g/10g, JIRA, Agile Methodology, SVN.

Generac Systems, Milwaukee, WI Oct 2016 - May 2017

Role: .Net Developer


●Developed the project based on the .Net Framework architecture.

●Preparation of project plan by identifying the tasks & milestones involved in the application.

●UI design based on HTML5, CSS3, ASP.Net MVC 5, JavaScript, jQuery, KendoUI, Bootstrap, Angular JS.

●Implemented client-side data-binding (MVVM pattern)

●Cutting edge UI development using various tools such as Telerik and Bootstrap

●Involved in debugging and troubleshooting user interface screens.

●Responsible for developing and consuming Windows Communication Foundation (WCF).

●Used LINQ for data exchange.

●Extensive use of Web Services, SOAP, XML, XSL to expose the reports to facilitate information sharing.

●Responsible for writing SQL Queries and Stored Procedures.

●Developed and consumed RESTful Services using WEB API.

●Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio (SSMS) for Developers.

●Designed Frontend with in object oriented JavaScript Framework like Angular.js

●Responsible for understanding the user requirements and converting them into the coding by implementing the business rules using C#.

●Worked on SOAP and RESTFUL Service API using WCF which return JSON data using WCF attributes.

●Worked on Agile environment using Team Foundation Server.

●Implemented O Data on ASP.NET Web API for convenient querying and changing data

●Exposing the ASP.Net by creating WCF Services over SOAP/HTTP.

●Involved in the code review and assignment of tasks with team members.

●Designed and developed scalable enterprise RESTful web services.

●Involved in providing Unit Test for each of the task and also perform code review for the team.

●Involved in pre-testing the application and bug fixing.

●Using PL/SQL in Oracle Database Developed Stored procedures & Cursors in the application.

●Involved in Deployment and Maintenance of the project in various environments such as development, production and testing.

●Developed reports using complex formulas and queries in the database to generate different types of ad-hoc reports using SSRS.

●Utilized Team Foundation Server (TFS) for the purpose of version Control and source code maintenance needs.

Environment: Visual Studio .Net, C#, MS SQL Server, IIS, Microsoft Team Foundation Server, ASP.NET MVC 5, HTML5, CSS3, ReST API, SVN, PSQL, Cognos, JavaScript, JSON, jQuery, O Data, Stored Procedures, XML, Data stage, Bootstrap.

Sentry Insurance, Madison, WI Aug 2015 – Sep 2016

Role: .Net Developer


Designed and developed Web Pages using ASP.NET, C#.NET, HTML, JavaScript, AJAX, jQuery CSS and server controls.

Developed secure login interfaces with ASP.NET Server controls.

Used various server controls like Multi View and Grid View with extensive data binding to display, page and sort multiple records.

Used validation controls for corresponding validations required for business logic in Web Forms.

Designed and developed user interfaces using ASP.NET.

Coding the presentation layer using WPF and service layer using Windows Communication foundation technology.

Used Angular JS to build web applications adhering to modern web design principles like browser portability.

Designed custom e-commerce Single-page responsive Web Application using Angular JS framework.

Developed modules to load, convert, and dynamically display API information in a Single page.

Extensively used MVC for the designing User interfaces on multiple devices.

Developed Custom Controls and User controls for reusable part of the web pages using C# with ASP.NET.

Involved in testing like Unit test, Integration test, Acceptance test and Regression testing using NUnit and responsible for writing test scripts and scenarios.

Created Rest full API’s using MVC4 Web API’s.

Created Database(s) on SQL AZURE by Setting up SQL Azure Firewall.

Used Bootstrap CSS for developing responsive front end.

Written the business logic in classes using VB.NET / C#.Net language and used in WebForms.

Worked on jQuery/JSON for the retrieval of data.

Worked with AJAX enabled WCF services using C# and ASP.NET.

Maintained and enhanced existing software by analyzing and identifying areas for optimization and refactoring.

Integrated Gateway O Data/ JSON Services

Developed test driven development (TDD) strategy guiding use of the NUnit unit testing framework.

Utilized C# generics, delegates, events, extension methods, anonymous types and lambda expressions.

Used LINQ to retrieve the data from the backend through Entity framework.

Created and deployed Web Services using ASP.NET and C#.Net and generated the proxy class files based on the web services to consume in the web application.

Extensively used ADO.NET objects like SQL Data Access, SQL Data Reader and DB2 SQL.

Developing reports on SSRS on SQL Server (2000/2005/2008) and excellent in SSIS packages for integrating data.

Developed Server side and Client side code using ASP.Net, jQuery and JavaScript.

Created Views by applying complex queries on multiple tables to create the virtual tables and implemented Cursors in Stored Procedures using SQL Server, Implemented joins in Stored Procedures to get the desired data by joining multiple tables.

Used TFS (Team Foundation Server) for source code control, project related document sharing and team collaboration.

Developed parameterized SQL queries and stored procedures to query database tables in T-SQL.

Designed and developed applications using VB.NET, ASP.NET with ADO.NET and SQL 2008.

Responsible for testing, fixing the bugs and troubleshooting the technical problems.

Environment: ASP.NET, C#.Net, ADO.NET, JavaScript, Angular JS, CSS, Bootstrap, HTML, IIS, LINQ,OOP, XML, VB.NET, SVN, TDD, NUnit, AJAX, WCF, WPF, O Data, Entity Framework, jQuery, JSON, MVC, SOA, SQL Server 2008, SSRS, SSIS, WinForms, HTML and DHTML, TFS.

Mayo Clinic, Minneapolis, MN Oct 2014 - July 2015

Role: .Net Developer


Developed application using ASP.NET MVC, C# framework.

Created application using HTML5, Angular JS, Bootstrap, CSS3 for responsive design.

Successfully designed and implemented XML API dealer information, order processing with ASP.NET Web API / REST Services (secured over https).

Implemented business logic/rules using WCF services and integrated with the UI components.

Developed Entity framework based database access layer using ADO.Net and Entity Framework.

Written stored procedures, triggers using T-SQL for data access from SQL Server 2008 R2 when applicable.

Have developed WCF and RESTful Services by using C# and Web API

Project Data importing/exporting using serialization/de-serialization

Create, manage SQL Server AZURE Databases.

Developed module which deals with validating user, changing passwords and searching of information depending upon priority of user in site using ASP.NET

Developed WCF service to be used by the ASP.NET applications

Used User Control, Ajax Toolkit to develop the application

Developed Business logic layer using ASP.Net with C# under Visual Studio

Used Master pages, User controls, Custom controls to suit user’s needs

Publishing the web site on IIS server

Used Team Foundation Server (TFS) for Version Control

Generated reports using the SQL Server Reporting services (SSRS)

Performed unit testing and functional testing using NUnit.

Designed and developed business components and data components using C# and ADO.NET.

Designed and Developed Web Forms using ASP.NET, C#, XML, XSLT.

Created Web Service in ASP.Net to serialize XML data over HTTP where the third party uses XML for the query and transferring the data.

Environment: Visual Studio C#, Angular JS, Bootstrap, ASP.NET, WCF, JavaScript, MVC 4, HTML5, CSS3, Entity Framework, IIS, AJAX, XML, SQL Server, jQuery, Business objects, Team Foundation Server.

Netripples, Hyderabad, India Feb 2012 – July 2014

Role: .Net Developer


●Requirements understanding, validating and realizing them to design documents and in turn will be converted to software components.

●Involved in the full life cycle of the project development (Analysis, Design, Implementation and Testing).

●Designed and studied the use case diagrams to gather functional requirements. During the design phase participated in discussions with the client regarding system requirements and contributed for the preparation of flow document.

●Worked on N-tier architecture consisting Presentation, Business, Entity and Data Access Layers.

●Involved in POC (Proof of Concept) phase for design WCF service for connecting frontend interface and backend database and redesign SQL server database.

●Designed/Developed Desktop Application using WPF, XAML and Expression blend.

●Used LINQ, WPF to communicate between DAL and other business components.

●Designed and developed SSIS packages to extract data from flat files.

●Built new version of the module on Silver light frame work.

●Experienced in the use of agile approaches, including Extreme Programming, Test-Driven Development and Scrum.

●Designed and developed xml web services for distributed architecture.

●Interacted with the quality assurance, customer support and operations technicians to troubleshoot all application level issues.

●Writing and modifying Stored-Procedures, Triggers and user defined functions in SQL to carryout database operations.

●Working with version controller Team Foundation Server (TFS) for maintaining history of source-code and project documents.

●Designed and developed ad hoc reports for business users using Crystal Reports.

●Used Grandview control extensively for data display, dynamic generation of rows, and user input inside template columns. Used Edit Item Templates and Footer Templates extensively for editing and adding rows.

●Created OOPs objects like Collections, Interfaces implementations using C# Generics for extracting data from database.

●Created setup and the user manual with installation guide of the application.

Environment: C#. Net, ASP.NET, Visual Studio 2005, ADO.NET, Windows Services, Web-Services, JavaScript, VBScript, XML, XSD, HTML, SQL Server2005, IIS, Team Foundation Server (TFS), CSS, Windows XP.

Client: Equinox, Hyderabad, India Aug 2009 – Jan 2012

Role: Junior Developer


Analyzed the requirements and prepared the analysis report.

Used ADO.NET objects such as Data Reader, Dataset and Data Adapter.

Involved in Writing, modifying complex Queries, Stored Procedures and Triggers Designed and developed applications using VB.NET, ASP.NET with ADO.NET.

Designed and developed the User Interface using Win-forms.

Source Code implemented using C#.Net

Developed Win Forms and integrated these forms with Windows Services.

Developing User Control for Common Functionality in the ASP.NET.

Involved in using all the best features of ASP.NET including Dataset, Data View and Data Adapter.

Performed validations using Validation Controls.

Familiar with several design patterns such as Iterator, Single Responsibility, Dependency Injection, etc.

Developed the UI panels using HTML, CSS 3 and jQuery.

Familiar with JavaScript libraries.

Good team player with excellent communication and interpersonal skills, ability to work individually or as part of a team.

Fast learner and quickly adapt to new technologies that help improve the business.

Environment: Visual Studio.Net, SQL Server, ASP.Net, JavaScript, XML, Web Services, HTML, CSS, Visual Source Safe, C#.NET

Contact this candidate