Sign in

Sql Server Web Services

San Francisco, California, United States
May 19, 2017

Contact this candidate

Shravan G

Senior Full Stack .NET Developer

Email id:

Ph No: 908-***-****

Professional Summary:

Around 8 years of professional experiences in all stages of Software Development involving planning, Analysis, Design, Implementation, Integration and Testing, Development, Documentation and Maintenance of various stand –alone, client-server and web-based projects with exposure to diverse business domains including Financial, Healthcare, Telecommunications and Banking.

Extensive experience with Agile/Scrum, Waterfall and Test Driven Development (TTD) Environments.

Expertise in web application development using Visual Studio.NET technologies like C#, ASP.NET, ASP.NET MVC, ADO.NET, XML, Web Services, WCF and WPF

Expertise in developing Client/Server Applications using .Net Framework (2.0/3.0/3.5/4.0) with Three Tier Architecture, N-Tier Architecture, SOA (Service-Oriented Architecture)

Experience in developing Web Applications using AJAX controls, Telerik Controls, Web Services and Cross Browser functionalities.

Proficient in UI development using HTML, CSS, JQuery, JavaScript, Angular JS, JSON, AJAX, Node.JS and Bootstrap.

Experience in Silver light and WPF (Windows Presentation Foundation) including frontend designing with Microsoft Expression Blend and backend programming with Microsoft Visual Studio.

Extensive knowledge of object oriented programming techniques and Microsoft design patterns like MVC, Service Oriented Architecture (SOA), WCF and Web Services.

Experience using LINQ and Entity Framework mapping to interact with other layers

Experience with Azure services with workload requirements

Proficient in database programming to create Joins, Stored Procedures, Functions, Views and Triggers using T-SQL in SQL Server 2005/2008/2012, Oracle SQL developer.

Extensive experience with reporting tools like SSRS and Crystal reports for designing and modifying reports and creating shared and embedded data sources to pull data into reports from the database.

Experience in design, development & analysis of SQL Server 2008/2012 and SQL Server Business Intelligence tools (BIDS) - SSIS, SSRS and SSAS.

Experience in configuring Internet Information Server (IIS), creating virtual directories, mapping them to physical folders and configuring applications for domain authentication

Experience in XML, XSLT, User Controls, Custom Controls, SOAP, WSDL, Web Services, Validation Controls, Authentications like windows authentication and forms authentication.

Experience with Visual Source Safe and GitHub for version control

Experience with JIRA for Bug tracking and work flow consistency

Experience in documenting a Technical Specification Document (TSD) with respect to business requirements and Functional Specification Document (FSD) for that particular project release.

Excellent analytical and programming abilities to create elegant, flexible and maintainable solutions for complex development problems and willingness to work in a highly dynamic environment.

Strong working knowledge in Database Programming using RDBMS databases like SQL Server 2012/2008/2005, Oracle 9i.

Experience in Designing Databases, writing T-SQL Queries, Stored Procedures, Views and Triggers.

Familiar with MongoDB and PostgreSQL databases concepts such as locking, indexes, transactions, replication, and schema design.

Using ADO.NET objects such as SQL Connection Object, Data Command Object, Data Reader Object, Data Set Object and Data Adapter Object to design Data Access Layer.

Good experience in implementing new C# features such as Generics, Iterators, Anonymous methods, Partial classes, Anonymous Types, Lambda expressions, Extension methods.

Experience in developing Web Services, Web Parts, User Controls and Custom Server controls.

Experience with developing web applications by using MVC, MVP architecture and Application Blocks.

Technical Skills:


ASP.NET, ASP, HTML, DHTML, CSS, XML, AJAX, XSD, XSLT, Web Services, WCF, WPF, MVC, Entity Framework, ADO.NET, LINQ, JavaScript, SQL, Win Forms, Web Forms, Web Applications, MS Office.


C, C++, VC++, C#. NET, VB.NET, SQL.

Scripting Languages

JQuery, JavaScript, VBScript, AngularJS, T-SQL, LINQ.


MS SQL Server 2012/2008/2005, Oracle 9i.


Microsoft VisualStudio.NET 2012/2010/2008/2005, SQL Server Management Studio, Toad, Firebug, Browser tools, Office 365, Dreamweaver.



Design Patterns

Service Oriented Architecture (SOA), Model View Controller (MVC), Factory, Singleton, and Object Oriented Design.

Operating Systems

Windows XP/ Vista / 7 / 8, Linux, Windows Server 2012/2008/2003.

Version Control Tools

Team Foundation Server (TFS), GitHub.

Reporting Services

SSRS, Crystal Reports.

Professional Experience:

Client: Social Interest Solutions, Sacramento, CA Jan 2016 - Present

Sr. NET Developer


Developed the user interface using C# .NET and designed UI using CSS, HTML, JavaScript and Angular JS.

Creating cross-browser compatible and standards-compliant CSS-based page layouts.

Implemented Angular JS & JQuery for client side sorting and validations

Closely worked with business system analyst team to understand the requirements to ensure that right set of UI modules been built.

Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.

Created number of standard reports and complex reports to analyze data using Slice & Dice and Drill Down, Drill through using SSRS.

Involved in the creation and deployment of the reports using SSRS and configuring the SQL Server Reporting Server.

Developed and consumed Web Services using XML/SOAP and REST.

Maintain, enhance, and recommend solutions that best suit business and technology needs from UI standpoint.

Developed user and custom controls using C#, Visual Studio 2012 and Expression Blend for WPF application.

Involved in design, coding and testing of multi-tier Windows Form / WPF application.

Involved in enhancing already existed applications, which were written in VB.NET.

Involved in development of the front-end part of the web application using HTML, Java Script & CSS based on client customization.

Developed and Customized Applications using ASP.NET, VB.NET, Web Services, VB Scripts.

Involved in creating rich and interactive UI using CSS, Java Script and Ajax.

Developed web pages and used applications that meet business and user goals through a positive user experience.

Integrated backend services using Rest API’s (web API) with identity Database.

Used Bootstrap carousel to do sliding of the images on screen.

Involved in building a single page and cross browser compatible web application using AngularJS (Angular routing) and Bootstrap.

Developed & maintained Web Forms with ASP.NET, Silver light and C#.

Created and consumed web services and WCF services.

Developing complex Stored procedures, User Defined Function and Triggers in SQL Server.

Actively involved in data modeling and contributed in the designing and creation of SQL Server databases.

Developed the application using C# using Visual Studio 2015and TFS.

Proficient understanding of Kendo UI.

Performed JSON data parsing using Angular JS to render the information on user interface pages.

Automated WCF services for testing using Soap UI tool and N Unit.

Built Rich Prototypes and Applications using HTML5, CSS3, JavaScript, JQuery, Ajax, JSON, AngularJS, Telerik controls and Bootstrap.

Implemented Inversion of Control using Dependency Injection for resolving dependencies.

Used MVC5.0 for Client Web Applications worked on all three modules model, view and controller.

Used SSIS for data transformation.

Effectively created easy to use, reusable controls/ user controls and integrated them into ASP.NET web pages.

Controlled overall look and feel of ASP.NET web site by defining themes and skins and applying them at page level as well as control level.

Effectively used master pages to create consistent layout for the ASP.NET web pages and merged them with content pages.

Effectively used ASP.NET intrinsic state management functionality to store application-specific, session-specific, page-specific and user-specific information between page requests.

Effectively used ASP.NET security infrastructure for authenticating and authorizing user access as well as performing other security related tasks using C#.NET.

Involved in developing front end using MVC .NET, Razor view engine, JavaScript, HTML, and CSS.

Maintaining legacy WinForms application, create new features requested by clients.

Worked on WCF Service, Operation, Data, Fault and Message Contracts.

Written JavaScript functions for client side code to implement different functionalities in events, validation and listeners.

Environment: .NET Framework 4.5, ASP.NET, ADO.NET, HTTP, XML, XSLT, JavaScript, IIS 7.0, HTML5, DHTML, CSS, Angular JavaScript, C#, VB, SQL Server 2012/2008, T-SQL, AJAX, Microsoft Visual Studio 2013/2012, SSRS, SSIS, JQuery.

Client: Western Union, New York City, NY Jan 2014 – Dec 2015

Sr.NET Developer


Involved in Requirements Collection, Design & Analysis of the Customer Specifications, Development and Customization of the Application.

Creating WCF Web services to electronically shares application and enrolment data with state's eligibility systems and county access program systems.

Creating windows services to collect and transfer information and transfer the verification documents faxed/uploaded by the users.

Creating WCF web services for USPS address verification, ZIP code validation and client data verification etc.

Product development is an Agile (SCRUM) methodology, where progress and task assignment is discussed in everyday meetings.

MVC (model-view-controller) architecture and SOA based development.

Designed and Developed Infrastructure Monitoring application using MS .Net 3.5, WPF, Silver Light 2.0, LINQ, REST Service.

Hands on experience in developing GUI Trading applications using C#.Net, WinForms, WPF, WCF, SQL, .Net Framework 4.0/3.0/2.0

Developed View-Models in order to restrict the controllers to control the dataflow between the model and view.

Responsible for designing and developing ASP.NET web pages using ASP.NET, Java script, ADO.Net, SQL, HTML, CSS and AJAX Web services.

Developed Custom User Controls to reduce the Complexity in User Interface Coding and provide better look and feel.

Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).

Generated various reports with drilldowns, drill through, parameterized reports from the cubes by connecting to Analysis server from SSRS.

Used various report items like tables, sub report and charts, Graphs to develop the reports in SSRS.

Designed and formatted SSRS Reports using Parameters and Expressions for the Reports.

Experience in developing applications using ASP.Net MVC 4.0 Framework, HTML5, CSS 3.0, bootstrap CSS and Entity Framework 5.0.

Used AGILE/SCRUM methodology to implement the application

Maintained quality of SOA services like security requirements such as reliable messaging, authentication, authorization and policies associated with it.

Involved in generating the Invoice Report, Export Report and PDF Report.

Designed the application using MVC design patterns.

Used WCF for creating services for the application.

Designed and developed UI using Kendo UI, CSS, bootstrap CSS, JQuery, JSON and AJAX.

Creating and consumed WCF services following SOAP protocol and created WSDL documents to describe web services.

Used AJAX, JavaScript libraries like JQuery for fast and asynchronous communication between page and server without refreshing the page.

Used AngularJS framework for event management for data validation of input forms.

Construct a Restful web service that pinpoints 404 errors with Entity Framework and Web API.

Create a dynamic AngularJS UI for displaying vital reports on server health monitoring.

Dynamically set and retrieve JSON objects in an Asp.NET SPA using the AngularJS.

Worked with XML Serialization to enable the conversion of XML documents to common language runtime objects.

Proficiency in developing XML applications using DTD, Schema, DOM, XSL.

Used LINQ and ADO.NET Entity Framework 5.0 for Database interaction.

Created Stored Procedures, PL/SQL statements, Functions to manipulate the databases.

Developed applications in TDD (Test Driven Development) environment using Unit testing

Performing unit testing on logics that are being built.

Deployed the application and components on the test and production servers.

Used TFS for the purpose of project tracking and Source Control.

Co-ordinate with business for better understanding of functional requirements, Analyze and implement the requirements.

Creating user controls and custom controls for handling generic data and reusable components.

Using JSON and JQuery in client side for managing the controls and data.

Created Business Layer/Data Access Layer using C#, ADO.NET, LINQ, SQL Server 2008

Developed WCF services to save/get the data for Users information, Transactions details, In-detailed users dealings with the company, using C#, LINQ

Worked on highly advanced user interface design and development using AngularJS, HTML and CSS.

Consumed Web API’s (HTTP/REST) Services to implement business logic.

Developed the classes using C#, which incorporate N-tier architecture and SQL server database connectivity.

Implemented Repository Pattern to interact between database and services.

Developed the application Framework in ASP.NET 4.0 primarily using C#.NET with the business logic implemented using .Net Assemblies.

Have written Stored Procedures for better performance and to retrieve data from the backend database.

Environment: .NET Framework 4.5, ASP.NET, ADO.NET, HTTP, XML, XSLT, JavaScript, IIS 7.0, HTML5, DHTML, CSS, AngularJS, JavaScript, C#, VB, SQL Server 2012/2008, T-SQL, AJAX, Microsoft Visual Studio 2013/2012, SSRS, SSIS, JQuery.

Client: Novartis Pharmaceuticals, Dallas, TX May 2012 – Dec 2013

.NET Developer


Implementation of changes in coding as per the client requirement.

Developed UI functionality of Employee Management and Complete Functionality of User Management modules. I used membership API of Dot net for User Management Module and SQL server as Backend.

Business and Database layers were implemented by N-Tier architecture.

Developed the entire user controls and forms using .NET Framework 4.0.

Designed and developed web pages using ASP.NET and C#.NET as business layer language.

Used ADO.NET extensively for retrieving, querying, storage, and data Manipulation for achieving continuous database connectivity.

Involved in developing and deployment of Web Services to communicate with legacy systems.

Involved in portal GUI design using Master Page, Login control and Client side validation is done by AJAX validation extender.

Experience in WCF to simplifies development of connected applications through a new service-oriented programming model

Used XML based procedures for ADO.NET objects, to facilitate the importing of large XML datasets into the SQL Server database.

Implemented UI validation using Validation Controls and JavaScript.

Designed and developed several user controls and custom controls that are used in the entire application using ASP.NET and C#.

Extensively used ADO.NET objects such as Data Set, Data Table, and Data Reader for consistent access to SQL databases.

Used ADO.NET to access database, modify records and update database.

State management was achieved using Session State, View State and Application State.

Involved in Database Design, Creating tables, and Triggers.

Environment: ASP.NET, C#, .NET Framework 3.5, Windows Server 2003, SQL Server 2008, Microsoft Visual studio 2008, Java Script.

Client: Rubicon Red, Hyderabad Jan 2011– April 2012

. NET Developer


Extensively used ASP.NET for UI design, with VB.NET acting as the source of code.

Created various Web Forms & User Interface Screens using C#.NET & ASP.NET.

Implemented complex financial processes by designing data and business layers utilizing C#.NET, ADO.NET and XML.

Worked extensively on designing databases and normalizing tables.

Experienced in the Design and Development of Data Access Layer.

Used Validation Controls. Created various User Controls for the application.

Used AJAX advanced techniques for textbox autosuggest.

Used ADO.NET for the storage and retrieval of data from the database.

Created database tables and implemented SQL Stored Procedures, Triggers, and complex queries in SQL Server.

Used XML based procedures for ADO.NET objects, to facilitate the importing of large XML datasets into the SQL Server database.

Experienced in working with Windows Communication Foundation (WCF).

Used XML Web Services for sharing some important financial calculation functions with all other applications.

Environment: C#.NET, ASP.NET 3.5, VB.NET, WCF, WPF, ADO.NET, XML, SQL Server, AJAX, SQL Server2008, HTML, and Microsoft Visual Studio.NET 2008.

Client: Sunera Technologies, Hyderabad June 2009 – Dec 2010

. NET Developer


Gathered Business Requirement documents for integration.

Used ASP.NET Validation Controls and developed JavaScript to perform various Client side validations.

Involved in support and deployment activities.

Involved in creating Web Pages using CSS, HTML, JavaScript, and AJAX.

Involved in fixing bugs by debugging the application, Found solution for many technical issues in the project.

Worked on IR’s raised by testing team for respective work request

Configuring Web, Config file, for the configuration of the entire Web Application.

Used ADO.NET objects such as data adapter and data set to fetch and handle user data

Used VB.NET as a code behind for Web Services and Windows Services.

Designed/Developed the Stylesheet using CSS in order to provide consistent look and feel for the entire web application.

Specialized in developing applications using XML, XSD Simultaneously involved in unit testing for all the development activities and design phase of the project for requirement analysis.

Experience with agile software development methodologies to validate the software solutions produced by the team.

Created user controls, validation controls and used custom controls like date picker, Custom Validator.

Involved in Back-End Database Design and Implementation using SQL Server 2005

Environment: Visual Studio 2008, .Net Frameworks 2.0, IIS 6.0, VB.NET, SQL server 2005, ASP.Net and SQL.

Contact this candidate