Sql Server Web Services

L Polsani

Email: ********.***@*****.***

Phone: 571-***-****

Professional Summary:

Around 2+ Years of Experience in Analysis, Design, Development, Management and Implementation of various stand-alone, Intranets, Client-Server and Web Based Software applications using Microsoft Technologies including primary skills ASP.NET 4.5/3.5/2.0, .NET Framework 4.5/3.5/2.0, Ajax, C#.NET, VB.NET, Java Script, VB Script, IIS 5.0/6.0/7.0, Web services, HTML, XML, Database queries, Stored Procedures, Views, Functions, SQL server tuning, and Triggers Using SQL 2012/2008/2005 and Oracle10g.

Experience in developing ‘Distributed Components’ using .NET Remoting, Web Services and WCF.

Strong knowledge in Relational Database Management Systems and experience in writing SQL scripts, Stored Procedures, User Defined Functions and Triggers for SQL Server 2012/2008/2005.

Extensive design and programming experience with web technologies like HTML, DHTML, Java Script and Style Sheets.

Hands-on experience in Testing/QA Life Cycle, includes preparing the Test Cases and Testing the developed programs (Unit testing, Sanity Testing, Integration testing, Regression testing, System testing).

Strong knowledge of Design Patterns, Object Oriented Analysis and Design Methodologies (OOA and OOD), Object Oriented Programming (OOPS), UML design methodologies and well versed with component-based architecture and design on Microsoft technologies.

Collaboration and conferencing technology and applications.

Software architecture design, software process, system implementation.

Internet applications, network protocols, standards and utilities.

Proficient in UML designing.

Expertise in development of Web Forms using C# and VB.Net.

Involved with MVC architectural design pattern and used MVC in integration with JavaScript framework.

Very good experience with agile/SCRUM development.

Strong knowledge in .Net Frame Work Unit Testing, Integration testing for modules coded.

Experience in writing SSIS Packages/SSRS in SQL Server

Experience with Microsoft TEAM Foundation Server for Code Repository, Deployment and Version control.

Experience with IBM Clear Quest/HP Quality Center for issue management and bug tracking.

Proficient in using XML related technologies including XSD, XPATH and XAML.

Good Experience and knowledge in using XML, SOAP, Web Services, XSL and XSLT for inter operable software applications.

Developed web services (.asmx/WCF) based on SOAP/JSON.

Experience in creating web user controls and web custom controls to enable reuse of common UI functionalities.

Effective problem-solving, analytical and interpersonal skills, besides being a valuable team player.

Technical Skills:

Languages:

C#.NET, VB.NET, C, Visual C++, Visual Basic 6.0,PL/SQL

Web Technologies:

ASP.Net, JavaScript, WPF, WCF, HTML, XML, XSL, JQuery and IIS/5.0/6.0/7.0. Site Core.

Business & Portal Technologies:

WSS 3.0,Sharepoint Server 2007,MS Office 2007

Databases:

MS-SQL Server 7.0/2012/2008/2005, Oracle 10g, PL/SQL, MS Access, MySQL

Middle Ware:

COM, DCOM, ActiveX, Remoting

Internet Technologies:

VB Script, JavaScript, HTML, DHTML, Front Page, VB InterDev, CSS, and XML, XSL, XHTML, Microsoft AJAX and XSD.

IDE:

Visual Studio.Net, Visual Studio 6.0, Visual InterDev 6

Reporting Tools:

Crystal Reports 9.0/11.0, SQL Reporting services 2005(SSRS), Ad Hoc Reporting Model, Dundas Chart.

Version Control:

MS Visual Source Safe 6.0,Team Foundation Server.

Networking Protocols:

SOAP, HTTP and TCP/IP

Design Tools:

VisualStudio.Net, Microsoft Visio

Operating Systems:

Windows 98/2000/XP/7/2003/7/8 Server

Professional Experience:

Accelosir,Herndon,VA Jan 2016 to Till now

Responsibilities:

Involve in complete software development life cycle(SDLC)

Coordinate with business users in gathering business requirements, designing and programming the application according to the requirements and translating them into technical specifications.

Demonstrate a strong understanding of object oriented design patterns, principles, and frameworks used for web application development.

Using Microsoft Technologies for the project development such as Visual Studio 2013, .Net framework 4.6, C#, SQL Server 2012.

Created a custom, single-page, responsive web application to replace a legacy line-of-business web application.

Working on Browser to construct the UI dynamically, client-side.

Created user access control to restrict users based on user roles and assigned security permissions using WCF Services.

Involve in Unit Testing, Integration Testing and System Testing.

Created Store Procedures and User Defined functions using Transaction SQL.

Used SQL Server Integration Services (SSIS) for Data Integration.

Wrote the T-SQL Database Triggers, Views, and Indexes.

Expertise in Database creation (DDL, DML, DCL), Database Tuning, SQL Tuning, Performance planning.

Kendo UI Grid Controls, splitter & dropdown used with dynamic data.

Developed Bar chart, Pie chart using Kendo UI controls in ASP.Net view pages.

Responsible for designing kendo grid controls with dynamic data load with appropriate data available in the database.

Working extensively against DB which has millions of rows.

Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.

Developed tabular queries for efficient analysis of report using Pivot/Un-Pivot in T-SQL.

Transformed complex business logic into Database design and maintaining it by using SQL objects like Store Procedures, User Defined Functions, Views, T-SQL Scripting, and Jobs.

Created Web Application using ASP.NET, C#, JavaScript, Jquery, HTML, SQL Server.

Development and Deployment using ASP.NET, C#.NET, HTML, CSS and JavaScript/ JQuery.

DEGA SOFTWARE TECHNOLOGIES Sep 2014 –july 2015

.Net Developer

The project is developed for ParMed Pharmaceuticals. The goal of this project is to allow ParMed to use Credit Cards without recording card numbers by any physical or electronic means within any facility. This is served by developing the solution as an integrated component of existing software and exposing the principal product as a web service to serve a suite (Goliath) of applications.

Responsibilities:

Windows forms were designed and developed in C#.Net.

Business logic layer classes are developed in C#.Net.

Various enhancements were developed in C#.Net by reengineering the existing VB6 code.

Various typed Datasets and data adapters were developed to handle data base interactions.

Involved in designing of User Interface with CSS, HTML, and DHTML.

Developed presentation layer using server-controls, HTML5 controls and user and custom controls.

Collaborated with architects, developers and business stakeholders to design and enhance large scale, customer-facing web applications developed on the existing e-Business platform framework, which is built on the Microsoft technology stack (ASP.Net/C#/MVC, SQL Server) with Sitecore CMS

Spanish module – customized the Sitecore pipelines to override Http Request Processor and Link Provider to resolve Spanish and English URLs, created Spanish workflow module for third party translation team, converted non-translatable content to translatable for content editors.

Sitecore Personalization – customized personalization rules to handle geolocation active pages to be Served based on geolocation city, state, zip and Time Zones by overriding Sitecore Rule Context.

Optimizing, debugging and creating T-SQL stored procedures in SQL 2012 R2.

Web services were developed in C#.Net and consumed for communication between multiple applications.

Windows services were developed to achieve scheduled payments processing.

Implemented 3rd party web services for credit card payments and various web services to expose business functionality to various applications.

Incorporated regular expressions (HTML) to capture the 3rd party website generated tokens.

Involved in database objects creation like tables, triggers. Developed complex T-SQL stored procedures in SQL-Server 2012.

Various stored procedures, functions and database scripts were developed in SQL Server 2005.

Involved in test harness development using NUnit framework and developed NUnit classes for unit testing.

Involved in development of test plans and helped testing team in developing test scripts.

Manual tested the application according to the business requirements.

Code version controlling and documentation is maintained using SVN.

Environment: Visual Studio .NET 2012, C# 5.0, ADO.NET, SVN, SQL Server 2012R2, T-SQL, Windows 2012.

Education:California university of management of science(M.Sc)

Mahaveer institute of science and technology(B.tech)

Contact this candidate