Sql Server .Net

Summary:

* ***** ** ********* ********** in developing various applications in Technologies like C#, ASP.NET, ADO.NET, VB.NET, COM, XML, Web Forms, Win Forms, Visual Studio.NET 2005/2008/2010/2012/2013, IIS.

Experienced in several phases of Software Development Life Cycle (SDLC) and Agile methodologies of design, development, analysis, and implementation, testing and client training of enterprise web applications, stand alone and distributed applications.

Expertise in developing Client/Server Applications on Three Tier Architecture, N-Tier Architecture, SOA (Service-oriented Architecture) and MVC (Model View Controller).

Experience in using HTML, DHTML, XML, C, C++, Java, Web Services, CDMA, UMTS, and LTE, ORM Tool, LINQ, JavaScript, JSON, REST, AJAX, CSS, WCF, Web Application, SQL Server 2005/2008/2010/2012 and SQL Server Management Studio and MS Access.

Working knowledge of single page applications (SPA) using current JavaScript frameworks & tooling such as MVC, AngularJS.

5 years of experience as UI Developer and web development with emphasis on HTML/HTML5, CSS/CSS3, DHTML, XML, JavaScript, JQuery, AJAX, DOM, BOOTSTRAP, AngularJS & BackboneJS

Experience in creating use case diagrams, class diagrams, activity diagrams, sequence diagrams, page flow diagrams using UML technology.

Expert in using various grids like Angular UI Grid, Kendo UI Grid for populating the data

Expertise in HTML5, XHTML, CSS2/CSS3, responsive design, Bootstrap, Backbone JS and visualization tools

Extensively worked on WCF and Web Services to provide SOA architecture and Configuration based activation applications on SOAP and RESTFUL services

Used WCF Data Services to easily expose and work with data from remote clients.

Involved in designing of WCF based Service, Data, Fault, Message Contracts as well as providing security for WCF service endpoints.

Proficient in using XML related concepts such as XPATH and XQUERY.

Experience in writing Silverlight and WPF custom controls and also created custom in memory data store for on demand dynamic data queries using different .NET data structures.

Experienced in database related work mainly creating complex stored procedure, DTS packages, Views, Triggers, Functions, using PL/SQL, T-SQL.

Experienced in .NET security features such as Authentication (Windows-based Authentication, Forms-based Authentication) and Authorization (Authorizing Users and Roles).

Expertise in using ADO.NET objects such as SQL Connection Object and Data Command Object, DataReader Object, Data Set Object and Data Adapter Object to design data access layer.

Strong debugging skills in n-tiered ASP.Net/C# web application.

Extensive experience in creating reports using Crystal Reports and SQL Server Reporting Services (SSRS).

Experienced in Documenting, Preparing Test Plans, developing test cases and Testing (Unit, System, Integration, User Acceptance testing and Regression testing).

Working experience with source control tools like Microsoft Visual Source Safe (VSS), Team foundation Server (TFS).

Experience in performing Unit and Integration Testing in the Development, User Acceptance Testing (UAT) including Bug Reporting and Fixing.

Excellent communication, analytical, management and interpersonal skills coupled with proven ability to test with software specification limitations and resource constraints.

Educational Qualification:

Engineering from Bachelor of Technology in Computer Science JNTU Hyderabad.

Technical Expertise & Skills:

Languages : C# 6.0, T-SQL, PL/SQL, Angular 4, Java Script, jQuery.

Microsoft Technologies : .NET Framework 3.0/3.5/4.0/4.5, C#.NET, ADO.NET, ASP.NET, Windows

Forms, Web Forms, ASP.NET MVC, WCF, MSF, SCSF CAB

Web Technologies : XML, HTML5, JavaScript, Angular.JS 1.5, Web API 2. 0 for Restful Services

Entity Framework : Entity Framework 6.0, Lambda Expressions, Query Expressions

Development Tools : Visual Studio 2003, 2005, 2008, 2010, 2012, 2013, 2015

Tools : FxCop, SandCastle, UML, VSTS, SSIS, SSRS

Web Servers : IIS6

Databases : MS-SQL Server 2005/2008/2012

Methodology : SDLC, Waterfall Model and Agile and Scrum

Software Design Tool : Microsoft Visio

Reports : SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)

Platforms : Windows 2000, Windows XP and Vista/7.

Source Control : Team Foundation Server (TFS), Visual Source Safe (VSS), Rational Team Concert(RTC)

Microsoft Office Suite : Word, Excel, PowerPoint, Access, Outlook

Professional Experience:

VISA – Denver, CO August 2015 – Present

Senior .Net Developer

Description: This system is involved in fixing bugs with the existing EBPM (Enterprise Business Process Management) application. In this project, I was involved in developing a web portal for the online personal banking modules or the clients. The client provides different services like personal banking, business banking, International banking, credit card, brokerage, Home loans, POS and Insurance plans.

Responsibilities:

Worked on Agile development environment

Worked on Model View Controller (MVC) framework for achieving test driven development approach

Worked on ASP.NET language for the application

Worked on JQuery for Client side Validation and display UI controls

Used MS SQL Server 2012 as backend.

Designing and developing rich application for Web (ASPX/Silverlight) and Windows (WPF).

Creating applications using VB.NET and enhancing projects for .NET applications.

Creating WPF/Silverlight applications using MVVM architecture

Analyzed and designed new WPF application using MVVM and Repository pattern, from design to completion.

Programming in Intersystems Cache Objectscript and Cache SQL for reporting and monitoring using Intersystems Ensemble Studio.

Implemented DB first approach using EF 6.0, EF extras, T4 templates.

Implemented GPS using Google Maps API.

Integrated data from various legacy sources like UCCEL, WMS, and Tableau by implementing SSIS

Implemented authentication in Web API using OWIN middleware.

Developed handy version applications using Bootstrap Framework, HTML5 and CSS3

Involved in creating Stored Procedures and Functions using PL/SQL Developer

Worked on designing the UI in Razor view engine and referring to the model for basic validation

Maintained the Web UI compatibility in all major Browsers (IE7 and above, Firefox and chrome).

Worked extensively on CSS for making the application responsive over all screen sizes

Successfully integrated Controllers, mappers and Models and mapped the mapper with service layer.

Used WCF for Data services and for connecting to the carrier services for getting the final quote

Built REST full services for handling A-sync responses from ISO

Involved in daily scrum meetings and weekly release meetings for status updates

Implemented rest services using MEF and .Net for Silverlight client.

Worked on few utilities in WPF for maintain the database validation scripts.

Responsible for developing Portfolios views using Microsoft WPF Prism Framework/MVVM model and Mef Extensions frameworks

Migrating ageing applications to new .NET platforms using C#, WCF, WPF and Entity Frameworks

Implementation of Dependency Injection using Spring.NET files for developing the project

Maintained the source code versions using Team Foundation Server (TFS)

Developed various stored procedures for the data retrieval from the database and generation of different types of reports using SQL reporting services (SSRS).

Developed Technical Design Documentation using TDD.

Environment: Visual Studio 2013, ASP.NET, MVC, C#.NET, C++, spring.net, .Net Framework 4.5, WCF, WPF, MVVM, Entity Framework, JQuery, XML, XSLT, TFS, SQL Server 2012, HTML5, CSS3, SSRS, Silverlight, TDD.

DOLLAR GENERAL CORPORATION June 2014 - July 2015

Senior .NET DEVELOPER

Description: Dollar General is the nation’s largest small Box Retail Corporation. It is the largest retailer of the America's most trusted brands. It operates in 35 states and has employee strength of 89,500.

Responsibilities:

Involved in Software Development Life Cycle (SDLC) of Analysis and Design of all the modules within the application, and developed UI components using ASP.NET and C#.

Implemented changes in coding and designs using knowledge of VB .NET

Created ASP.NET Web forms and server controls to display dynamic data obtained with Microsoft ADO.NET and Data binding.

Used CSS (Cascading Style Sheets) with XML for branding purposes and user look and feel

Used AJAX to trade data with a web server, without reloading the page

Margin Center was developed using XAML (WPF 4.0) with MVVM as Architectural Pattern, Prism 4.0

Developed module for exporting snapshots into Excel from WPF application

Designed and developed the booking and contracting engine using C#, multithreading, serializations to transfer and persists data xml datasets. Used caching feature to increase the user response

Used State Management techniques cookies, Sessions and View state to store user information

Used extensively typed datasets as a common data source for the Win forms view and used data grids extensively to present the data bind with the dataset defined and linked with the view.

Used ADO.NET objects such as Data Adapter, Data Reader, Data Tables, Dataset and Data View, for consistent access to the data store

Developed system services SOA application platform for use by all web applications utilizing WCF services and used SOAP, XML and WSDL.

Enhancement and Support for internal Office Automation tools and applications using development tools WPF, WCF, MVC 5.0 and C#.

Created error reports in Excel spreadsheets from a Powerbuilder 9 application

Developed advanced WPF client navigation controls using Infragistics and Photon controls.

Imported data from MS-Access to SQL Server using Stored Procedure, triggers, cursor, Join and other statements

Worked on creating different types of charts for representing the data using Kendo UI Java Script Chart widget

Worked on bug fixing for the total product during post production

Experience in creating multiple reports in Drill mode and Cross Tab Reports by using Crystal Reports

Created and modified master pages and developed workflow for document libraries.

Developed custom web parts for the 'Events Calendar' and the 'Surveys' sections of the site.

Developed and implemented custom workflow forms using SharePoint Designer.

Environment: Microsoft Office SharePoint Server 2007/2010 (MOSS), SharePoint Designer 2010, WSS 3.0, Visual Studio.NET 2012, .NET Framework 4.5, VB, ASP.NET 2.0, Win forms, C#.Net, ADO.Net, Java Script, C++, CSS, WCF, WPF, Infragistics, Photon control, power Builder, SQL Server 2008, DTS Packages, Crystal Reports, Unit Testing, SQL Scripts, Windows XP, SOAP.

Senior .Net developer March 2013 - May 2014

Target Corporation

Project: PLM OBF (Own Brand Food)

Description: PLM OBF is an application that is used for the development of Owned Brand Food (OBF). It facilitates the communication of Project Details for the creation, evaluation and approval of Owned Brand Food Products. This application supports the core OBF process from Project Definition through Production and allows for the consolidation of all information into one application. It has the modules for defining the product specification and product labeling.

Responsibilities:

Worked on Agile development environment

Performed R & D on Asp.net MVC and Jquery, Ajax, Entity Framework

Involved in Requirement gathering, Data Modeling and Technical Design specification

Implemented Data Access Layer using MS Enterprise Library

Automated the process of signed certificate generation process using Power Shell scripting

Developed Power Shell script to parse XML for service deployment status Developed Power Shell script to parse log files to check for test run timeouts and send email if test run timed out

Worked on the modernization of a legacy and outsourced UI. Technologies used were Backbone.js, Require.js, and Jquery.

Single point of contact for all user related issues.

Deploy issue fixes to the lower environments before pushing them to the production environment.

Analyzed, created database objects such as stored procedures, functions etc. using T-sql in SQL Server 2012.

Used ClosedXML to read data from excel file and perform import/export of the business objects.

NoSQL and data analytics expert to help develop the next generation diagnostic tools

Performed code analysis and code review using Static code analysis

Implemented various design patterns and Dependency Injection

Designed and implemented various custom controls and other reusable components

Implemented MS Enterprise Library for Exception handling and Logging

Generated various reports using SSRS.

Experienced in LINQ (Language Integrated Query), LINQ to SQL

Used Model View View-Model (MVVM) Pattern.

Performed unit testing and system integration testing.

Used Rational Team Concert (RTC) for integration, maintenance and Security of code.

Environment: .NET Framework 4.5, Visual Studio 2012, ASP.Net MVC, C++, C#, AJAX, ADO.NET, ODP.NET, Web Services, WCF, XML, Java Script, Jquery, backbone.js, require.js, IIS 6.0, NOSQL, SQL Server 2008, Oracle 10g, Windows 2003, MS Visio, Enterprise Library.

McKesson - San Francisco, CA January 2012 - February 2013

Senior .Net Developer

Description: McKesson is a leading provider of software, automation, services and consulting to hospitals, physician offices, imaging centers, home health care agencies and payers. They provide interactive connectivity services that streamline clinical, financial and administrative communication between patients, providers, payers, pharmacies and financial institutions.

Responsibilities:

Worked on Agile development environment

Involved in requirement gathering, n-Tier Application development, User Interface, Application Layer, Business Layer, Web Service, system integration, Deployment and configuration management

Conducted system architecture studies of new and existing IT systems to permit development of integrated systems that operate at low cost levels.

Conversion of data-driven Microsoft Access application to VB.NET Windows/Web forms application.

The data access layer was designed on the middle tier, which would connect to various databases for various groups using ADO.NET.

Worked onsite 3-tier support for configuring and upgrading the Layer 7 application

Set up Policies for the initial set of the application after the install on layer 7

Applied patching and migrated customers to newer versions of Layer 7

Designed dynamic and multi-browser compatible pages using HTML, CSS, JQuery, JavaScript, Angular Js, Require Js and Kendo UI

Used ADO.NET objects such as Data Reader, Dataset and Data Adapter, for consistent access to SQL Server data sources

Developed Power Shell script to automate the creation, deployment

Created new database objects like Store Procedures, Triggers, Indexes and Views using T-SQL in

Development and Production environment for SQL Server

Designed and developed Web Applications using ASP.NET & .NET 4.0/3.5 Framework.

Performed application level tracing, debugging, and state maintenance through web configuration file under the root directory of the root directory of the application.

Developed dynamic ASPX web pages for Application using ASP.NET, C#.NET, XML, HTML and JavaScript.

Used Team Foundation Server for source control, reporting, check-in policies, build schedule and project tracking

Responsible for creating the .NET builds and making sure the builds are migrated all the way up to the Production Environment

Involved in Unit, Integration testing of the modules developed

Environment: .NET Framework 4.0/3.5, Visual Studio 2010/2008, VB, ASP.NET, C++, C#, JavaScript, T-SQL, SQL Server 2008, Team Foundation Server

Harmony Infotech, Visakhapatnam, India October 2010 - December 2011

.NET Developer

This Project is to develop a Pharmacy application with multitier architecture, which includes six subsystems to implement the pharmacy operations like drug inventory, order management, billing, Health Physics operations, customer management and Scheduler. This enhancement is to provide new functions and business rules to the application.

Responsibilities:

Designed and implemented a 3-Tier application architecture including the Presentation, Business and Data Access Layer.

Developed the reporting application in VB.NET, while JavaScript is used for client side validations.

Designed the layout of User interface using Visio and Class diagrams using UML

The Presentation Layer is implemented in ASP.Net with HTML, Cascading Style Sheets (CSS) and Web Controls. The Web Forms are developed utilizing the C#.

Used Ajax Controls to reduce the client-server turnaround time, hence enhancing the performance of the application

Used JavaScript for client-side validations

Implemented Data Access Layer using ADO.NET to connect and retrieve or manipulate database information.

Utilized Linq extensively for data querying, storage and manipulations in Data Access Layer.

Developed the independent WCF (Windows Communication Foundation) services and defined Service Contracts for specific functionality in project search module.

Used bindings to control the construction of the WCF channel stack at runtime

Used the latest WPF/XAML vector based UI framework for the front end and WCF to implement the various services such as the QA Services.

Developed different WPF controls and customized the appearance of list box and list box items.

Used Grid View, Data List and Repeater controls with Paging and Sorting for displaying various data on to the page

Developed many T-SQL queries to fetch data as per the business requirements with proper tuning techniques

Used XML intensively to bind the data to the web controls, data manipulation and to store data and sent as parameter to the stored procedures.

Implemented Serialization and Deseralization of objects

Design responsive and intuitive user interface for the web using XHTML/CSS and both custom AJAX scripts as well as MS Ajax for ASP.NET library

Used Ajax enabled grid to display the data to display the data fetched and also used AJAX Toolkit to develop the controls.

Developed light-weight rich UI via extensive usage of JQuery

Intensive use of CSS and XHTML to design look and feel of the web pages

Worked on Performance Tuning and Optimization using T-SQL, Execution Plan, Index Tuning wizard, system stored procedures and Tables.

Worked extensively on web forms and data binding controls like Grid View, Data List and drop down boxes and Mapping page fields to the database fields

Utilized Studio 2008 as the IDE tool for the management of the project and controls as they are developed and deployed. Version control for the source code and scripts are managed using Ms Visual Source Safe.

Implemented unit testing, integration testing and system testing using NUnit

Environment: MS-Visual Studio 2008, ASP.NET, VB, C++, C#.Net, SOAP, XML, HTML, XSLT, XPath, Jquery, IIS 6.0, NUNIT, Visual Source Safe, SSRS, WCF, WPF, T-SQL, ADO.NET, Linq, Oracle 10g,TFS, IIS and MS SQL Server 2005.

3Edge Software Solutions, Chennai, India August 2009 - September 2010

.Net Developer

Description: Building a room scheduling website for a college, it allows clients from outside to request for rooms in the college for their events and also allows scheduling courses going on campus. Developed this website in ASP.NET and used error-logging techniques to capture exceptions and handle it.

Responsibilities:

Interacted with end users and Business Analyst to create low-level technical design document

Involved in Database Design, System Analysis, design and development

Used the ADO.NET for the Data Access from the Database

Created UI screens using ASP.NET web forms and user controls

Created the Queries to access the data from the SQL server as the backend

Coordinated with offshore for the multiple version releases for this product

Created the Patch (C#) for the unsupported product errors. Fixed three main production bugs using this patch

Wrote PL-SQL queries with Joins on multiple tables, Stored Procedures, Functions, Triggers, Indexes using T-SQL and LINQ using Oracle

Interacted with the client-Support team, and clarified their queries about the product.

Created the FAQ document for the client support team

Involved in the Install shield Creation and fixed the production issues.

Responsible for the Deployment and Delivery of the product in the client environment

Used VSS for Version Control

Environment: C#, C++, ASP.NET 3.0, Visual Studio 2005, ADO.NET, Oracle 9i, MS SQL Server 2005

Contact this candidate