Sql Server .Net

Purna Chandra

************@*****.*** Ph. 267-***-****

Professional Summary:

7+ years of professional experience in the Analysis, Design, Development, Validation/Testing & Implementation of Web and Windows Applications.

Thorough knowledge & Expertise in ASP.NET & .NET Framework including ASP.NET, .NET Framework, Master Pages, Themes & Style Sheets.

Extensive experience in design & development of applications using .NET Framework VB.NET, ASP. NET, C#, ASP.Net Web Forms, MVC, Web Services, WCF, Web API, Angular JS, Node.JS, JSON and SQL Server.

Developed UI design using HTML, CSS and Bootstrap along with client side scripting using JavaScript, JQuery and AJAX.

Sound understanding of OOD Programming, Software Development Methodologies (Scrum, Water Fall, Agile) & SDLC

Expert level skill of RDBMS concepts, writing T-SQL queries, stored procedures, Triggers,Functions, views, user defined functions

Expertise in creating Views, Partial Views, View Models and Action Filters in MVC.

Implementation of N-Tier Architecture Data Access Layer (DAL), Business Logic Layer (BLL) and User interface (UI), Model View Controller (MVC) and Service Oriented Architecture (SOA).

Experience in working with Windows Presentation Foundation (WPF) & Windows Communication Foundation (WCF).

Prolific working knowledge in various Object Relational Mapping (ORM) technologies such as ADO.NET, Entity Framework and LINQ.

Strong working knowledge in developing applications using MVC architecture.

Adequate knowledge in writing Custom Controls and User Controls, reuse them at various places to provide reusability.

Excellent working experience in REST, SOA related applications using WCF and Web services

Thorough knowledge of Client Side and Server Side Session Management.

Worked on CSS3, Master pages, User Control, Ajax Control Toolkit in ASP.Net Web Forms.

Worked on Team Foundation Server (TFS) for source code management and project management.

Strong experience in deploying the projects through Internet Information Services (IIS).

Worked on SQL Server Integration Services (SSIS) for data integration and transformations.

Worked on SQL Server Reporting administrations (SSRS) for generating reports from the SQL Server databases.

Extensively worked on creating and consuming Web services, WCF, Web API.

Performed testing with N-Unit, have good knowledge in System Integrated Testing (SIT).

Proficient in error logging and performance tuning techniques like Exception Handling, Data Analysis and reusable components for Application tuning.

Pro-active, detail-oriented, self-starter, proficient in organizing with groups and give essential backing to official staff.

Excellent analytical, organizational, interpersonal, written, verbal communication and problem solving skills.

Self-motivated, able to work with minimal supervision, and able to exercise good judgment to keep critical systems operational.

Great desire to learn latest technologies and ready to take up challenges.

Technical Skills

Languages

C,C#,SQL,VB,VB.Net

Web Technologies

HTML, CSS, AJAX, XML, JSON, JavaScript

Frameworks

ASP.NET 3.5/4.0/4.5, MVC, ADO.NET, Web Services, WCF, Web API, LINQ, AngularJS, Node.JS, JQuery, Entity Framework, Bootstrap

Databases

SQL Server 2008/2012/2014

Tools

Visual Studio 2008/2012/2013/2015,SQL Server Management Studio

Web Servers

Internet Information Service (IIS)(6.0,7.0,8.0)

Operating Systems/Servers

Windows XP/7/8/10, Windows Server

Version Control

Team Foundation Server (TFS),,TTD,GITHUB

Testing

N-Unit, SIT

Professional Experience

Client: Health and Human Services Commission, Austin, TX Sep 15 - Present

Role: Sr.Net Developer

Description: Health And Human Services Commission uses a managed health Care Systems, for majority of their health care related processing. This project aims at providing maintenance, enhancement and development for the HHSC systems. Work requirements are basically segregated as issues (Maintenance) and enhancements tasks. Generally, Customer raises issues when problem is found in the system during normal working. These issues are generally batched up and sent to us for resolution. We look at the business perspective of the problem and provide estimates and solution through design, coding, testing and delivery.

Responsibilities:

Participated in requirements gathering, analysis and design of the client requirements.

Designed Web Form application using Visual Studio C#, .Net 4.5 Framework.

Developed the N-tire Application using Visual Studio C#.NET, ASP.NET, MVC 5 and HTML5.

Developed using Web Services, WEB API for exposing Web services, SOAP and used IIS (Internet Information Services).

Designed the Views, Layout pages, and Partial views using ASP.NET, MVC, JQuery, AJAX, CSS3 and BOOTSTRAP.

Extensively used AngularJS, JQuery, and JavaScript to develop dynamic web applications for enhanced user experience.

Developed LINQ, Entity Frame Work to approach code first and Workflow frame works.

Involved in using LINQ to SQL for querying database from business layer.

Involved in developing JavaScript functions to handle Client-Side validations and also used for handling some events.

Involved in SQL Server data modeling, Stored Procedures and customized Microsoft Data Access Application Block for .Net to perform common data access tasks using Microsoft Enterprise Library.

Validations of forms were performed using JavaScript, AJAX and .Net Validation controls.

Used WPF and XML schemas for data exchange.

Used Team Foundation Server (TFS) to automate tracking of the source code, documentation and other file types

Used Twitter Bootstrap for responsive web design of Navigation controls.

Environment:

IIS (8.0), Visual Studio 2015, C#.NET, ADO.NET, ASP.NET 4.5, ASP.NET MVC 5, WCF, SOAP, WPF, LINQ, AJAX, HTML5, XML, CSS3, jQuery, Angular JS, Bootstrap, JavaScript, Web User Controls, Web API, SQL Server 2012 and TFS.

Client: Metro PCS Wireless, Newark-NJ Oct 14 - Aug 15

Role: Net Developer

Description: Metro PCS is one of the leading companies in providing the wireless, internet and Cable services to its customers. The main aim of project was to build and maintain the Customer Portal to manage the customers, profiles, orders, billing, invoicing and discounts.

Responsibilities:

Involved the study of existing process and in requirement analysis & gathering, creating & maintaining documents.

Design & develop application using ASP.NET, C#.NET, HTML, CSS, SQL Server 2012 and MVC design pattern.

Involved in the Software Development Life Cycle (SDLC) including Analysis, Design, Implementation, and testing the application.

Used .NET validation controls on several pages, designed Master pages for consistency & unified look of website.

Used ADO.NET extensively for data retrieving, querying, storing and manipulating.

Developed ASP.NET caching features, configuring ASP.NET optimizations, securing ASP.NET web application.

Used AJAX for partial post back and used XML for read/write data out of system.

Used N-tier architecture for Presentation, Business and Data access layers using C#.

Involved in integration of applications and maintained versions using TFS (Team Foundation Server).

Developed and consumed Restful Services using WEB API.

Created Stored Procedures, Functions, Triggers & Views in SQL and developed complex SQL queries.

Created the CSS style sheets for designing the layout of the GUI screens.

Developed the UI using HTML, CSS, jQuery, JavaScript, AJAX.

Making the application responsive using Bootstrap media queries.

Environment: Visual Studio 2013, C#, VB.NET, ASP.NET, ASP.NET MVC 4.0, ADO.NET, Entity Framework, WCF,T-SQL, JavaScript, CSS, HTML, XML, SQL Server 2012, TFS.

Client: Community Health Choice, Houston-TX Feb 13 – Sep 14

Role: .Net Developer

Description:

CHC is a health and life insurance company with an emphasis on providing broad array of health insurance services. The designed policy system offers various online services to the members holding the insurance. They include information regarding Prescription Drug Plan (PDP) plans, Insurance Policy Processing, Claims Management, Billing, Reinsurance, Information of health care providers and pharmacists etc.

Responsibilities:

Designed and developed a responsive Single-page web application using AngularJS, ASP.NET MVC, Web API, HTML, JavaScript, JQuery, CSS3 and Twitter Bootstrap.

Designed a dynamic User Interface that is populated with data from a Web API with AngularJS and Bootstrap for a better user experience.

Implemented different Controllers and injected AngularJS Built-in Services to deal with the different business operations of the application.

Created Web API to reach a wide range of clients with reusable data and operations.

Implemented a Factory using resource to make Restful communications over HTTP with GET, POST, PUT, DELETE to the Web API.

Implemented routing to allow for the use of a Single-page with different content using route Provider in the AngularJS Module and Views in the HTML.

Implemented Functions for users to create, edit, and delete tasks from the database with AngularJS.

Created and styled Modal Pop ups using Bootstrap and JQuery.

Implemented Client side validations using AngularJS Custom Form Validation.

Integrated AngularJS Filters to format data for searching and ordering.

Implemented Server side validation using Data Annotation.

Used Entity Framework to model and manage data from SQL Server.

Created Stored Procedures for the different data operations on the database.

Environment:

Visual Studio 2012, Microsoft SQL Server 2012, ASP.NET MVC4, Web API, Entity Framework, HTML, CSS, AngularJS, JavaScript, JQuery, Twitter Bootstrap

Client: Ivax Pharmaceuticals, Horsham, PA Dec 11–Jan 13 Role: .Net Developer

Description:

Ivax Pharmaceuticals Inc. is working every day to make quality healthcare accessible. As a manufacturer of specialty and generic pharmaceuticals, Ivax provides both new and innovative therapies and greater access to affordable medicines.

Responsibilities:

Used C#, ASP.NET AJAX Toolkit controls like Script Manager, Update Panel and Modal

Popup Extender within some web pages. Successfully developed different Web Pages using C#,

ASP, HTML, JavaScript, CSS.

Designed & built a WCF services for an Interactive Decision System for loan, implemented multithreading to simulate an Asynchronous Batch Run.

Designed database in MS-SQL and created stored procedures, functions, views to reduce complexity of front-end SQL queries and triggers to enforce entity relationships.

Used Entity Framework to create entities in Data Access Layer.

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

Used Web Services (SOAP, WSDL) for communicating with other application and components.

Responsible for developing WCF Service Libraries to exchange data between Desktop and Central Application and implement business logic.

Developed the WPF application in PRISM framework, thus creating loosely coupled components for the application.

Implemented SSIS packages and jobs to integrate with external third parties and internal databases.

We used TFS (Team Foundation Server) for all the source code maintenance among the whole team members and experience in working with version control tools like Team Foundation Server (TFS), Subversion (SVN), Visual Source Safe (VSS), and GIT.

Used Stored Procedures, Triggers and Cursors in SQL Server.

Involved in all the stages of SDLC. Completely understand the importance of Quality of work in deliverables given to client.

Project is developed based on the agile methodology and conducted and involved in daily SCRUM and responsible for manual testing, Unit testing, Integration testing, System testing for modules coded.

Environment:

Visual Studio 2010, Agile Methodologies,ASP.NET, ADO.NET, C#, .NET framework 3.5, HTML, CSS, JavaScript, WCF, WPF, TFS, SQL Server 2008, Web Services, Entity Framework, AJAX, LINQ.

Client: Samruddhi Industries Ltd, India Dec 08 - Oct 11

Role: ASP.NET Developer:

Description:

It is a shopping cart website which allows the user to buy informational products of their choice. Registered users can also upload products for other users to browse and buy products of their interest.

Responsibilities:

Designed and developed a Graphical User Interface (GUI) using C#, ASP.NET Web Forms, HTML and CSS in Visual Studio 2008.

Modifying the code to accommodate client's requirements.

Design and Implementation of database for shopping cart site.

Writing codes that suit different screen sizes.

UI designed for different device screen size.

Developed a rich user experience using JQuery, JavaScript and AJAX.

Connected the application to the database, retrieved and saved data using ADO.NET.

Created login controls for user authentication using Session variables.

Created a re-usable Master Page for the Layout of all the pages.

Responsible for developing the Logic using C#.NET

Environment:

ASP.NET, ADO.NET, JavaScript, JQuery, HTML, CSS, Web Forms, AJAX, Microsoft SQL Server 2008, Visual Studio 2008.

Contact this candidate