Sql Server .Net

Kalpana G

Sr. Net Developer / Full Stack Developer

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

Phone: 669-***-****

PROFESSIONAL SUMMARY:

Over8 years of extensive experience in designing and developing software applications with the .NET Framework, ASP.NET MVC 5.0/4.0, ADO.NET, AJAX, LINQ, WCF, WPF, CSS, Web Services, SOAP, HTTP.

Experienced in Microsoft Visual Studio 2008-2015, TFS 2008-2015, .NET Framework 3.5-4.5, Entity Framework 5 and 6, hibernate.

Extensively worked with database tables, Stored Procedures, Functions, Triggers and cursors T- SQL using SQL Server, MYSQL along with Creating Databases and database objects, creating and managing users and roles

Experience in using UI components like HTML, CSS, XML, JQuery, JavaScript, Web Services, ASP.Net, AJAX, and Angular JS.

Technical expertise in Microsoft Technologies, such as ASP.NET Web Forms, ASP.NET MVC, C#, VB.NET, Web Services, Web API, WCF, WPF, LINQ, IIS, SOAP, XML, XSL, XSLT, .NET Remoting, VB Script, ADO.NET, Entity Framework, RESTful Web Services and RDLC Reports.

Extensive experience in Designing professional UI Web Applications using Front End Technologies like HTML, CSS, JavaScript, JQuery, AJAX, JSON, AngularJS and Bootstrap.

Good experience in Web services, Windows Communication Foundation (WCF) and Windows Presentation Foundation (WPF).

Proficient in using XML related technologies includingXSL, XSLT, XPathand XQuery.

Knowledge on developing the Web application using framework like Language Integrated Query (LINQ), Entity Framework and LINQ to Entities.

Proficiency in development using Microsoft.Net technologies like C#, ASP.Net, AJAX, MVC, Web Services, Data Structures, Windows Azure (Cloud Computing), N-hibernate and Entity Frame Work

Experience in Database Analysis/Design/Normalization/Manipulation processes using SQL ServerandOracleData Base.

Experience in developing both front and back end for cross-browser Web Portals, highly interactive AJAX based applications.

Experience developing presentation layer using Web Forms, Windows Forms, Windows Presentation Foundation (WPF) and Expression Blend 3.0, Web API

Familiar with new C# 5.0/4.0/3.0 features such as Asynchronous methods, Lambda expressions, Anonymous types, Query expressions, Named and optional arguments.

Solid knowledge of Object Oriented Programming, OOAD, UML, SOA, Scrum, Agile methodologies, Software Development Life Cycle (SDLC)

Experience in developing several client side validation scripts using JQuery and server side validation scripts in VB.Net

Experience in generating reports using SQL Server Reporting Services (SSRS), creating packages using SQL Server Integration Services(SSIS)

Working experience in SDLC, methodologies like Agile and Waterfall.

Excellent verbal and interpersonal skills; good analytical and debugging skills; systematic approach to system architecture design and programming tasks; Excellent Problem solving skills.

TECHNICAL SKILLS:

Development Tools

.NET Framework 4.5/4.0/3.5/3.0/2.0/1.1,

ASP.NET, ADO.NET,MicrosoftVisualStudio2005/2008/2010/2012/2013/2014/2015,WPF, WCF, LINQ, Visual Studio Team Foundation Server

Languages

C, C++, VB, C#, VB.NET, T-SQL, PL-SQL, JQUERY, Java Script,AJAX, HTML, DHTML, XML, XSLT, CSS.

Services

Web services, Windows Services, SOAP, UDDI, WSDL, WCF, Web API

Databases

SQL Server 2012/2008/2005, Oracle10g, MS Access, DB2

Web Servers

MS IIS 5.0, 6.0, 7.0, 7.5.

Modelling Tools

UML, Microsoft Visio 12.0,Infragistics Suite

Reporting Tools

Crystal Reports 9.0/10.0, MS Reporting Services,Business Objects

MS Packages

MS Office 2003/2007, MS Visio

Operating Systems

Windows 7/vista/2003/2008/2010, MS-DOS

PROFESSIONAL EXPERIENCE:

Client: Wells Fargo Bank, Phoenix, AZ Sep 2015 to Present

Role: .NET Developer/ Full Stack developer

Roles and Responsibilities:

Refactored and re-Architecture and enhanced an existing Angular JS application to follow strict MVC patterns for improved source code maintenance, 40% code reduced, ease of upgrade, Scalability, ease of developer spins up, enhanced performance and offline with client caching.

Worked in Agile Methodologies for Rapid development and regular adoption to the varying requirements and delivery of the working software.

Involved in the Design of ASP.NET User Interface Layer/Web forms

Developed Business Logic Layer Object Oriented Programming Languages (OOPS) Concepts abstraction, encapsulation, inheritance, polymorphism in C#.

Experienced in Developing and Enhancing MVC, Layouts, Partial Views by using HTML, CSS, and ASP.Net Controls.

Implementation of the UI using HTML, CSS, JavaScript, JQuery and Bootstrap.

Implemented Reports Functionality using modules UI (MVC and Kendo UI), Service (Web API)

Designed MVC design pattern for ASP.Net application development using the ASP.Net MVC framework.

Used Code first approach and Entity Framework for Data Access Layer (DAL).

Developing the services of the application usingASP.NetMVCandWeb API.

Performed validations using .Net Validation Controls and AngularJS

Implemented Server and Client side validations using ASP.Net validation controls Established communication between different applications running on different platforms.

Designed Webpages using HTML, CSS, JavaScript, JQuery and responsible for designing of Web pages using Ajax controls XML.

Designing many different modules like data parsing which developed using C#.

Used ADO.NET strongly typed datasets to insert, update and retrieve data from an SQL Server Database.

Created and deployed SSIS packages using various transformations such as Multi-Cast, Look-up, Check-sum, Union all and Derived column.

Worked Extensively with Query Optimization Techniques to Fetch Data with better Performance Tuning.

Used Http Response Exception to handle the exceptions in Web API and also customized the Exceptions using Exception Filters and registered them at the Action Level.

Working Knowledge of Rich UI applications based on latest UI Technologies, libraries and frameworks like Angular JS and Bootstrap.

Implemented WEB API Services for CRUD operations with HTTP verbs GET, POST, PUT, and DELETE.

Involved in the optimization of the product by effectively using the tools like SOAP UI, SQL Profiler, and Fiddler.

Involved in requirement analysis and design of module and Involved in implementing and consuming ASMX Web Service.

Implemented partial page update using AJAX, Minimized the page refreshes and eliminated the Post Backs.

Developed Database Stored Procedures, User defined functions and Triggers using T-SQL.

Performed Coding/Programming tasks to specifications and in accordance with Development Standards.

Development Cascading Style Sheets (CSS) for user interface uniformly throughout the application.

Supported Operations team during the deployment, troubleshooting the production issues during deployment and on a regular basis, and involved in Daily Scrum meetings for Project management.

Environment: Web Services, Web API, JQuery, Bootstrap, C# .Net, ASP.Net, MVC, .Net Framework 4.0, Visual Studio 2013,2012 Entity Framework, XML, XSL, JavaScript, SSRS, SQL Server 2014, TFS, IIS, Team Foundation Server.

Client: World Bank Group, Washington, DC Sept 2014 to Sep 2015

Role: .Net Developer

Roles and Responsibilities:

Designed Presentation layer using Web forms, HTML 5, JavaScript, J Query and CSS

Responsible for requirement gathering and preparing the Requirement Specification Document

Worked on Agile Methodology to meet timelines with quality deliverables

Used MVC design pattern for developing the application in ASP.NET 4.0

Created views, controllers and models using ASP.NET MVC 4, C# within MS Visual Studio 2013

Worked on creating Responsive web pages using Angular JS

Developed Desktop Applications using Visual Basic, JavaScript,AngularJS, XML, UDDI, WSDL, WS-I, SOAP, COM, DCOM, Visual Studio.Net.

Worked extensively in implementing Fault contract, security, performance tuning and Web Services Callbacks.

Developed the Control Module Web Pages from ground up using MVC, HTML, JQuery, Angular JS, CSS

Developed HTML helpers, custom filters, developed Views and partial views using Razor syntax

Developed Web API services and hosted with Asp.net MVC 4 application.

Worked in different phases of SDLC from requirements, implementations to testing

Utilized validation controls for server-side validation and JavaScript for client-side validation.

Writing T-SQL queries, stored procedures, functions, views to perform the data retrieval from SQL 2012.

Used JQUERY, AJAX toolkit controls to give better performance and richness to the user interface

Implemented Entity Framework, which enables to work with relational data using domain specific objects

Developed test strategies, test plans and test cases and performed Unit Testing to identify and resolve integration, functional and usability issues before deployment.

Actively managed the role of Production Support to fix the application issues on time

Wrote complex Stored Procedures and called them from code-behind code to prevent sensitive data tampering. Involved in writing SQL queries and query optimization for improving performance

Implemented SQL Server Integration (SSIL) packages in the application for connections, control flow elements, data flow elements, event handlers, variables, parameters, and configurations.

Worked in MSSQL Reporting Services (SSRS) to generate reports and charts

Used Team Foundation Server (TFS) for Source Code Control, project related document sharing and team collaboration.

Developed n unit test cases for all enhancements/ new requirements and executed the tests.

Environment: C# 4.0, Razor View engine, Windows Communication Foundation (WCF), Visual Studio 2013, AJAX, Angular JS, SQL Server2012 R2, TFS, JavaScript, JQuery, SSIL, SSRS, IIS 7.0.

Client: American International Group (AIG),Charlotte, NC Feb 2013 to Sept2014

Role: .Net Developer

Roles and Responsibilities:

Preparing Dashboard’s for the initial establishment of the new screens.

Developed the application using ASP.NET 4.0

Experience in designing and branding Master Pages utilizing Server Controls, User Controls, Data Grid control, Form Validation controls, Custom controls.

Used html 5 and bootstrap CSS to give better performance and richness to the user interface

Creating stored procedures triggers functions, OraclePL/SQL database and integrating them with the frontend Web application.

Worked on creating Responsive web pages using Angular JS.

Implemented Client and server side validations by using Java Script and ASP.Net validation controls.

Generated entity classes based on the database schema and improved the development of N-tier architecture using LINQ.

Extensively used Angular JS in the front end in developing some of the web pages.

Developed Data Model Classes with LINQ to SQL and business rules that implemented within model layer using C#.

Interaction with the stakeholders of the screens and features; and transforming the functional points into low-level technical details.

Provide technical leadership to the junior team member.

Performed extensive x unit testing and developed Test Plans, Test Cases.

Giving PROD Support during the Warranty Support period also played a role of onsite coordinator for my project.

Played a crucial role to solve various functional and technical PROD issues quickly within the given timeline.

I have also involved in designing, developing and deployment of WCF services and consuming the web services in the user Interface layer.

Responsible for providing appropriate test environments and test programs.

Worked in Agile methodology to meet timelines with quality deliverables.

Worked with Team foundation server (TFS) as source control.

Environment: C#.NET, Microsoft Visual Studio .Net 2012, ASP.net 4.0, Entity framework 4, XML, XSL, HTML 5, JavaScript, JQuery,Angular JS,AJAX, SSIL, PL-SQL, Team Foundation Server (TFS), RESTful Web services.

Client: Time Warner Cable,Charlotte, NC Nov 2011 to Jan 2013

Role: .Net Developer

Roles and Responsibilities:

Developed using Agile Methodology- Extreme Programming

Build upgrade Matrix to show upgrade plans based on existing plans.

Design technical requirements and help define and review technical requirements for other engineer.

Used Cascading Style Sheets (CSS) to maintain design consistency across all web forms

Built on a custom framework using C#, win Forms, Web Services, .Net, ASP.NET, and SQL Server 2005.

Created Custom Validation Controls for validating the data in the User Control and used ASP.NET.

Validation Controls for server side validation and Java Script for client side validation.

Used XML for transferring and retrieving data

Extensive use of T-SQL Queries, Stored Procedures, Views, Triggers to perform the data retrieval from SQL Server.

Created and used Win forms to create functionality in networking module.

Developed services using WCF to design a service-oriented framework

Used ADO.NET components like SQL Connection SQLCommand, DataAdapter, Dataset, DataReader, Grid View and Details View for database connection and database communication

Used AJAX coding techniques to update parts of a web page

Designing of various database objects that include Tables, Stored procedures, Triggers etc.

Developed this application from scratch using ASP.NET, C#,ADO.NET, Web Service etc.

Created Tables, Views, Triggers and Stored Procedures for application backend

Wrote Client Side Java Script for validation

Design Data Access layer through Store procedure and Class structure.

Involved with clients and business teams to provide technical support and measure the scalability, consistency and accuracy of the application.

Environment: ASP.NET 2.0, C#, ADO.NET, T-SQL, Web Services, WinForms, XML, XSL, JavaScript, SQL Server 2005, VSS, MS Visual Studio 2003, CSS, Perl Scripting, SQL Reporting Services 2000.

Technical Strategies India PVT Limited, Hyderabad, India. Aug 2009 to Oct 2011

Role:ASP.NET Developer

Roles and Responsibilities:

Analyzed the specifications provided by the clients.

Involved in Requirement gathering, Functional and technical specifications.

Used N-tier architecture for presentation layer, the Business and Data Access Layers and were coded using C#

Coding and debugging using ASP.NET and C#.NET.

Developed Web forms using ASP.Net server controls and validated input using Java Script.

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

Wrote Database routines, stored procedures and fixing up standard specifications

Created Reports using the Crystal Report for the reports needed by Middle Office, Back Office users.

Identified, researched, investigated, analyzed, defined and documented business processes

Enhanced the Business Layer to provide more interfaces and functions needed for the system

Used a hybrid of waterfall and incremental as the SDLC.

Environment: .NET Framework 2.0, ASP.NET, Web Services, SOAP Messages, C#.NET, Visual Studio .NET 2005, JavaScript, IIS 5.0, SQL Server Integration Services (SSIS), HTML, DHTML, Crystal Reports, SQL Server

EDUCATION:

Bachelor of Technology, India

Contact this candidate