Sql Server Web Services

Maharshi Kondapaneni

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

Ph: 510-***-****

Professional Summary:

7+ years of experience in all stages of Software Development Life Cycle (SDLC), Systems Analysis, Design, Development,Testing and Implementation of Client/Server applications using Microsoft .NET Framework, C#. NET, VB.NET and ASP.NET and SQL Server with N-tier and MVC development environment.

Expertise in development of N-Tier/MVC Architecture and implementing OOP paradigmusing Waterfall and Agile/Scrum, TDD, Iterative methodologies.

Extensive Knowledge in Design and Development of User Interfaces usingHTML5, DHTML, CSS, XML, XSL, VB Script, JavaScript, jQuery, Bootstrap and Angular JS.

Strong work experience with .NET Framework (4.6.1/4.5/4.0/3.5/2.0) and experience with Web API, SOA, SOAP and RESTful web services.

Proficient in using .Net technologies such as C#, ASP.Net, VB.Net, ADO.Net, WCF, Web Services, Http Handlers and modules, XML/XSL/XSLT.

Having good hands on experience on developing using OOPS concepts and Design Patterns.

Very good knowledge on Solid implementation process

Thorough understanding and experience using UML modeling. (Use Cases, activity diagrams, class diagrams collaboration diagrams, etc.)

Experience with ADO.NET for database connectivity having SQL Server in the back end.

Hands-on experience on AJAX Technology on the client side development.

Extensive knowledge of .NET security features such as Authentication & Authorization, Windows-based Authentication, Forms-based Authentication, Authorizing Users and Roles.

Extensive knowledge in Crystal Reports, SSIS and SSRS.

Extensive experience in SQL Server 2005/2008/2008R2/2012 and MS-Access. Proficient in database development, including stored procedures and Views using Transact SQL and PL/SQLand familiar with Oracle 10g/11g.

Used Version Controlling tools such as Subversion (SVN), Source Safe (6.0) and Team Foundation Server (TFS), GIT.

Expertise with service oriented architectures, C#, ASP.Net, Microsoft SQL Server and deploying them in Windows platforms.

Detail oriented with excellent communication and presentation skills.

Excellent work ethics, self-motivated, quick learner, team player and good at multitasking.

TECHNICAL SKILLS

Programming Languages

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

DatabaseManagement Systems

MS SQL Server 2014/2012/2008R2, MS Access, Oracle 10g/11i.

Development Tools

ASP.NET 5.0/4.5/4.0/3.5/3.0, AJAX, XML, Classic ASP,HTML, CSS, JavaScript, IIS 6.0/7.0/7.5, Web Services, SOAP, WSDL, XSD, UDDI, XML, HTTP, JSON, REST services,WCF

Version Control

MS Visual SourceSafe 6.0, Team Foundation Server, SVN, GIT

Business Intelligence Tools

SSRS, SSIS, Crystal Reports 7.0

Operating System

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

Web Frameworks

.Net Framework 4.5,4.0, 3.5, 3.0, 2.0

Additional Tools

LINQ to SQL, Entity Framework, Enterprise Library.

User Interface Controls

Telerik, Dev Express.

Scripting Languages

Java script, JQuery, AngularJS

Work Experience

Duke Energy, Raleigh, NC Jan 2017 - Till Date

Project: COA

C# .Net Application Developer

Main aim of the project is about managing power related devices in power plants throughout the country owned by Duke Energy. Our software solution allows employees of the company to manage those devices and track them so they know what they are doing and how they function.

Responsibilities:

Designed and developed various abstract classes, interfaces, classes to construct the business logic using C#

Developed the reusable framework for the application using the ASP.NET, MVC Framework 5.0

Designed and developed Graphical user interfaces using DEV Express and C#.

Extensively used Dev Express Data Grid, Items Control and many other controls with Paging and Sorting for displaying various data on to the page.

Used JQuery to perform validations and catch the events on client's browser.

Involved in developing web Pages with rich UI, AJAX, and JQuery using ASP.NET.

Worked with WCF Services, Caching features, Configuring optimizations and securing the web application.

Developed system services SOA for use by all web applications utilizing WCF services and the ASP.NET provider model.

Involved in Development using Linq and SQL Server.

Used Data Contract as the standard mechanism in the WCF for serializing .NET object types into XML.

Developed and consumed web services through Ajax, JQuery, SOAP, and XML.

Extensively used technologies like AJAX for a rich UI experience.

Effectively used JQuery a concise JavaScript Library for traversing HTML document, event handling and AJAX interactions.

Extensively used Third Party tools like Dev Express for developing rich user interfaces.

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

Implemented Data Access Layer using Entity Framework (EDMX) and LINQ.

Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS.

Created different chart reports helped in analyzing perform counters using SSRS.

Implemented Unit Testing using VSTS and also involved in Integration Testing and Regression Testing.

Used Github for the purpose of version Control and source code maintenance needs.

Environment: .NET Framework 4.5.2, MVC 5, AJAX Toolkit, Agile, Web Methods, WCF Service, API, T-SQL, ADO.NET, SQL Server 2012, C#, HTML, CSS, JavaScript, IIS 8.0, JQuery, JSON, LINQ to SQL, Github 1.4, SSRS Reports, Dev Express, Angular JS, Log4net, Nuget Package Manger.

Mayo Clinic, Rochester, MN Mar 2015 to Dec 2016

Project: Smart Space

.NET Developer

The goal of Smart Space is to create an overall vision of spaces, tools and services that benefit providers. It mainly concentrates on data and knowledge feedback and the ability to complete many tasks without the intrusion of a desk-top computer will help to optimize provider’s time with patients.

Responsibilities:

Involved in all stages of SDLC started from requirements gathering to Analysis, Design, Implementation, Testing and Deployment of entire project.

Prepared design documents and tasks and user stories for Sprint planning.

Developed Web application and mobile web-app using C#, HTML5, JQUERY, WEB-API and AngularJS.

Developed Rich UI interfaces for Web using HTML5, AngularJS to do data binding.

Created different Action Attributes for decorating across various Action Results in MVC 5.0 controller. The Action Attributes used include the ones used for Handling errors and Caching.

Used ADO.NET objects, Dataset, DataTable and DataAdapter for manipulating, retrieving, storing and displaying data from SQL Server 2008.

Implemented Data Access Layer using Entity Framework Code First and extensively for data querying, storage and manipulation using LINQ

Used LINQ to XML and LINQ to Object at service level to communicate between different applications.

Used Ado.net Entity Framework, LINQ to XML to pull the data into web services.

Developed and consumed WCF Services to achieve Service Oriented Architecture (SOA) and communication between heterogeneous applications.

Performed T-SQL tuning and optimization of queries for reports that take longer execution time using SQL Query Analyzer in MS SQL Server 2008.

Developed complex programs in T-SQL, wrote Stored Procedures, Triggers, Views and Queries with best execution plan.

Used TFS (Team Foundation Server) for version Controlling and source code sharing and also used MSBuild.

Modified the web services written for generic data retrieval for explicit use of Smart Space.

Used Mango DB for Caching, to improve the performance of web Services.

Responsible for troubleshooting, deployment and preparing technical documentation for defects tracking.

Proficient in Web Services creating, testing (WSDL, SOAP), discovering (DISCO), remote and security.

Extensively used TFS for versioning.

Environment: Visual Studio 2013, C#.Net,ASP.NET 4.5/5, MVC, JavaScript, HTML5, jQuery, Angular JS, WCF Web services,SOA, Data-Driven Development, Web API, Sql Server 2014, TFS, Mango DB, Post Sharp, Log4net, Nuget Package Manger.

State of Nebraska, Omaha, NE Nov 2013 – Feb 2015

.Net Developer

Responsibilities:

Involved in Requirement Analysis, gathering, Low Level Design, Coding and Integration.

Involved in complete design and development of the application using C#. NET, ASP.NET, ADO.NET.

Developed Web forms for the most part of the application.

Attended daily standup meetings to provide task status (agile pattern).

Involved in developing views and controllers as part of MVC pattern within the application.

Responsible for developing the Data Access Layer (Model) using ADO.Net Entity Framework Model, and C#.

Implemented CRUD functionality with Entity framework in ASP.NET MVC and implemented sorting, filtering and paging with Entity framework in MVC.

Created components in C#.NET that can be reused on several pages.

Used AngularJS as the development framework to build a single page application.

Participated in scrum sessions in analyzing the requirements with group members.

Involved in creating daily, weekly, monthly transaction reports.

Wrote complex stored procedures and SQL queries using SQL Server for extracting, inserting and manipulating the data and display on Grid view controls and dropdown list boxes and User controls.

Performed unit testing and system integration testing.

Involved in Production support and Maintenance for this application.

Designed, Developed and tested performance-oriented stored procedures for creating data Files.

Designed and developed the database using SQL Server 2012.

Used ADO.NET to communicate the database, wrote complex Queries, Stored Procedures and Triggers.

Used Data Adapter, Data Command, Data Set, Data Table, Data Relations and constraints for Database access.

Worked with ASP.NET MVC model binding that allows mapping HTTP request data with a model.

Extensively used Html helpers for writing views.

Responsible for designing and developing the database objects like Tables, Views, and Complex T-SQL Store Procedures involving Joins and using Temporary Tables, UDF (User Defined Functions).

Developed loosely coupled application using WPF, C#.

Involved in changes to WCF Web Services, to handle request from POS server and responded back with the required information by getting the information from the Database.

Prepared support documentation for all the activities undertaken at regular intervals for the Project management review and update.

Deployed the application in both LINUX and Windows platforms.

Environment: NET Framework 4.0, C#, ASP.NET, ADO.NET, Tortoise SVN, Visual Studio 2010, SQL Server 2012, Windows 7, Windows Server 2008, AngularJS.

First National Bank, Dallas, Texas July 2012 – Oct 2013

C#/ .Net Developer

First National provides wide range of services that can make banking easier and more convenient than other finance related services to its customers. The online banking system development helps customers in accessing their accounts and provides online transaction services. The system allows users to trace account history, pay bills and apply for loans. Customers can also change their personal information and order checks online through this service.

Responsibilities:

Involved in all phases of Project life cycle (SDLC).

Developed business layer components in C#.NET.

Involved in front end design and controls using ASP.NET.

Developed web pages using JavaScript, JSON for Client side Validation.

Developed architecture for this web-based application using ASP.NET, C#, MVC3, WCF Web services and REST.

Developed the web pages with MVC3 framework using JavaScript and jQuery.

Worked on WCF Web Services using C#.net to authenticate lookup and retrieve the data from database

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

Used LINQ to SQL in C# to retrieve the data from database.

XSLT (XML/XSL) been used for Data Transformation and Parsing.

Involved in database design and writing stored procedures, functions using SQL Server 2008 and R2.

Generated reports using stored procedures through SQL Server Reporting Services (SSRS).

Used agile methodology to emphasize on face-to-face communication over written documents.

Used AJAX features to avoid page post-back and to improve the performance.

TFS was used to maintain the version and source control.

Involved in writing the installation documents for the application.

Involved in fixing the bugs in the web applications.

Environment: Visual Studio 2010, ASP.NET, HTML, XSLT, TFS, CSS, AJAX, WCF Web Services, Test Driven methodology.

Camino Medical Group, San Jose, CA Oct 2011–June 2012

.Net Developer

Description: The project was created to keep track of patient details with creating web pages using .Net Technology. The Intranet/Internet project was developed to maintain various departments of hospital. The web interface was developed to search pages for patient information, adding and deleting patient information. This web interface was developed for various departments of the hospital like patient registration, create appointments, consultation, message board, and billing and follow up, Nursing Notes. It also includes reports, which makes physicians refer the patients.

Responsibilities:

Participated in enhancements, design reviews, and ensured design meets functional and operational needs.

Designed and developed the C# components for implementing business logic in 3-tier application interacting with SQL Server database using Managed provider using ADO.NET.

Developed complete Data access layer Component using C#.

Developed Crystal Reports to generate various reports like consultation follow up, Nursing Notes and integrated with ASP. Net.

Used Get Patients, Get Physicians web methods in Xml Web Services to retrieve information in a particular city.

Implemented Form Based authentication and Role based authorization to authenticate users.

Used ADO.Net Technology to connect the web forms to data sources such as MS SQL Server and Xml files for manipulating data in database.

Developed SQL queries, T-SQL procedures, Functions, triggers to handle the business rules data integrity and for various data transactions.

Used Data Transformation Services to import the data in SQL server from heterogeneous data sources like excel Access and Oracle.

Environment:Visual Studio 2008, C#, VB.NET, ASP.NET, ADO.NET,MVC, HTML, CSS, Web Forms JavaScript, Microsoft, XML Web Services, IIS 6.0, SQL Server 2010.

ValueLabs LLP, Hyderabad,India Jun 2009 to Sep 2011

.Net Developer

Project: Real Time Update System

Description:

This was one important system ValueLabs LLP . All the foreign exchange transactions were done using this web application. This application was build in ASP.Net. Foreign exchange rates were automatically updated to the system in real time, hence named Real Time.

Responsibilities:

Involved in design and Development of Web pages using ASP.net

Developed the application in ASP.net and involved in writing C#.net classes

Build user Interface that separated Application Logic from Presentation code

Pioneer activities in Web related Technologies

Wrote Queries and stored procedures to extract data from SQL Server and also update Server

Used ADO.NET to interact withSQL Server databases

Used ASP.NET Validation controls to validate user inputs

Used ASP.NET Control Data grid to display profiles

Troubleshoot the application in production environment without scarifying the up-time and Services

Environment:Visual Studio.NET, C#.net,ADO.Net,ASP.Net, Microsoft Visual Studio, XML, IIS 5.0, Windows 2000, JavaScript, HTML, Visual Source Safe (VSS), Web Services.

Education:

Bachelor of Technology in Information Technology, JNTU, India

Contact this candidate