Post Job Free

Resume

Sign in

Sql Server .Net

Location:
Dulles, VA
Posted:
February 22, 2017

Contact this candidate

Resume:

PROFESSIONAL SUMMARY:

*+ years of experience in designing, developing, and maintaining web applications using Microsoft Technologies.

Proficient with Software Development Life Cycle (SDLC), including business requirements, analysis, design, development, testing, and implementation of application.

Extensive experience in developing various applications using MS Visual Studio 2008/2010/2013 technologies like .NET 3.5/4.0/4.5, ASP.NET MVC 4.0/5.0, HTML5, CSS3, Web Services, WCF, IIS 6.0/7.0 and Crystal Reports.

Good experience in implementing C# features such as Generics, Anonymous methods, Anonymous Types, Lambda expressions and Extension methods.

Worked extensively with ADO.NET objects such as Data Adapter, Dataset, and Data Reader to interact with databases like SQL Server 2005/2008.

Experience in building complex and critical web based applications. Experience in both developing new applications and maintaining existed .Net applications.

Strong experience in design patterns like Model View Controller (MVC).

Good Knowledge of Windows Communication Foundation (WCF) and Service Oriented Architecture (SOA).

Strong experience in writing SQL Queries, Joins, Stored procedures, Triggers, Indexes and Views in SQL Server.

Strong experience working with AJAX controls, Java Script, JQuery and LINQ.

Used Language-Integrated Query (LINQ) query to retrieve data from different data sources LINQ TO ENTITIES.

Strong knowledge of working in Agile and waterfall methodologies.

Experience in Agile methodologies, daily stand up meetings, client meetings to better understand all the requirements.

Hands on experience in (SQL SERVER) Database Design and Development, Writing Constraints, Indexes, Views, Stored Procedures, Triggers, and User Defined Functions using T-SQL.

Experienced in using Configuration Management, setting up company Version policies, build schedule using Team Foundation Server (TFS) and SVN.

Ability to handle multiple tasks and demonstrates initiative and adaptability and capable of handling responsibilities independently as well as a proactive team member.

Strong communication skills and the ability to work with cross-functional teams.

TECHNICAL SKILL SET:

Programming Languages C++, Java, C# 3.5/4.0/4.5, C, T-SQL, PL/SQL, Python

.NET & Web Technologies ASP.NET,C#.NET, ADO.NET, VB.net, Web Services, WCF, LINQ, MVC Entity Framework, jQuery, JQuery UI, JavaScript, Angular JS, HTML5, CSS3

Database Servers SQL Server 2005 /2008/2012 and Oracle 9i

Reporting Tools SQL Server Reporting Services

IDE Microsoft Visual Studio 2008/2010/2013, SSMS

Others Visual Source Safe, Team Foundation Server, SVN, JIRA and IIS, Microsoft Azure

PROFESSIONAL EXPERIENCE:

South Carolina Department of Juvenile Justice

May 2015 - 2016

Role: .Net Developer

Project: System of Risk Assessment

Description: This project is to develop a risk score system to assist the police officers to determine what action should be taken for the juveniles according to their records.

Responsibilities:

Participated the design review meeting and ensured the design meets the requirement and contains all the needed functions.

Reconstructed the legacy system by using C# to develop the business logic according to its stored procedures.

Developed the business logic for the risk assessment system and its user interface using C#.

Used C# and Linq to develop the program to back up the legacy system, general all the old records into PDF files and upload to the server.

Developed the program to periodically backup the juveniles’ pictures in C#.

Used Database first EDMX and Linq queries to generate data from the database.

Used MVC, JSON to created report portal to allow users to download customized report.

Use JQuery and AJAX to create dynamic dropdown list.

Create and maintained the database objects, modified stored procedures to meet the requirement.

Used SVN to share source codes with other team members.

Support and debugged the web service maintenance.

Developed the user login portal by using ASP.NET to validate the login information in the database

Environment: Visual Studio 2015, C# 4.5, MVC 5.0, Entity Framework 4.1, WCF, JQuery, JQuery UI, LINQ, AJAX, SQL Server 2012, SSRS, and SVN

InTouch Health Care – Overland Park, KS Jan 2014-2015

Role: Dot Net Developer

Project: Health Center.

Description: InTouch Health offers the industry's only complete end-to-end products and service solution specifically designed to facilitate improvements in patient care and increase hospital revenue in acute care settings. The project involved in creation of an application for users to conduct online services. It involved building an application for users to create account, manage account from remote sources. Users included the students, professors, staff, and local community. The project involved wide range of services dealing with appointments, insurance, check-ups, payment plans.

Responsibilities:

Involved in all phases of SDLC along with requirements gathering.

Developed dynamic web pages for Application using ASP.NET MVC (4.0), C#.NET, HTML5, JavaScript, JQuery.

Extensively used MVC using Html5 with razor syntax.

Utilized Entity Framework technology extensively for data retrieving, querying, storage and manipulation using LINQ Statements, views, User Defined Functions, Stored Procedures for inserting/updating/Deleting the data into the relational tables.

Implemented Database First EDMX and used LINQ to Entities to massage the Data and optimized the Query Expressions.

Project core framework was architected WCF (Windows Communication Foundation) instead regular web services due to performance gain offered by WCF.

Design and developed WCF web service and configured the web service with appropriate endpoints for consuming them in web application.

Used AJAX for rich user interface operations and avoiding post back to the server.

Writing the JavaScript, JQuery, JQuery UI, JSON and Ajax to handling the Client side validations and dynamic page updates.

Created and maintained database objects like complex Stored Procedures, Triggers, and Tables, Views and SQL Joins.

Installed, managed reports using SQL Server 2008 Reporting Services.

Used SVN for all the source code maintenance among the whole team members.

Implemented test driven development by integration and unit testing.

Environment: Visual Studio 2013, C# 4.5, MVC 4.0, Entity Framework 4.1, WCF, JQuery, JQuery UI, LINQ, AJAX, SQL Server 2012, SSRS, and SVN

MASSMutual Financial Group - Salem, VA June 2012- Dec 2013

Role: Web Developer

Project: ACLAIM - Automated Claim System (Property and Casualty Insurance)

Description: The Main objective of the ACLAIM is to create and maintain Claim Information. It provides multiple subsystems include Policy maintenance, Policy report, CAR (Centralized Auto Reporting), OAR (Order and Receiving System), Precede and Appraisal assignment system which makes the system more robust flexible in maintaining claims. ACLAIM system interfaces with both internal and vendor system. Some of the external vendor's subsystems include Bank of America, Bank of New York, Metro police report and Scene Genesis.

Responsibilities:

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

Used ADO.NET technology extensively for data retrieving, querying, storage and manipulation of interface screens developed using ASP.NET.

Implemented DAL using ADO.NET components like Data Set, Data Provider, and Data Reader to store and retrieve database information.

Used JavaScript, JQuery and .NET Validation Controls for performing client-side validations.

Designed Master Page and used CSS to provide a consistent look and feel of inherited web pages.

Implemented and Consumed WCF Services.

Implemented Cascading style sheets (CSS), Master pages, and HTML for maintaining uniformity among all Web pages in GUI

State Management Techniques are used to maintain state at control level using View State and at application level using Sessions.

Wrote SQL queries, views and stored procedures using T-SQL.

Involved in Writing SQL, TSQL queries, functions, Stored Procedure, and packages.

Worked on .NET Security features such as Authentication & Authorization, Forms-based Authentication, Authorizing Users, Roles and User Account Impersonation, tracing.

Used Microsoft Team Foundation Server (TFS) for version control and file sharing.

Performed Unit Testing (Mocking objects) on data access and business access layers.

Environment: Visual Studio 2010, C#, ASP.NET, ADO.NET, HTML, CSS, Web Forms, JavaScript, JQuery, WCF Services, IIS, SQL Server 2008, SSRS, NUNIT and TFS.

Client: Nationwide Insurance, Columbus, OH Feb 2011- June 2012

Role: .NET Developer

Project: Claims Automated Payments

Claims Automated Payments Project, developed for Nationwide Insurance. This application enables the representative to online claim tracking, make a payment for estimated payments and to allow the representative to view or find the payment. It provides the representative with a worksheet that can be used more intuitively and effectively to setup information to make payment, save it and return later. Also while making a payment a mechanism is provided to create, process and resolve issues preventing the issuing of the payment.

Responsibilities:

Working in an agile Environment to deliver higher-quality software far more rapidly

Involved in development of Web Forms, Classes using C#.NET that incorporates both N-tier architecture and database connectivity

Developed ASP.Net pages using ASP.NET 3.5 web form controls, Controls, HTML server controls in C#.

Used Visual Studio.NET 2008 IDE to design the forms, develop and debug the application.

Wrote T-SQL and SQL Queries to create tables, stored procedures, triggers, creating DTS Packages using SQL server, LINQ and Oracle.

Used Tab strip, dropdown, menus controls.

Used SOAP to Implement Web Services.

Implemented version controlling using Visual Source Safe.

Deployed web application on Internet Information Server for production.

Created event driven Web Forms using ASP.NET and implemented form validation using Validation controls using both Custom validation and JavaScript was written for Client side validations and also used the new validation controls in VS 2008.

Enhanced and developed UI functionality using ASP.NET, HTML, and XM, XAML.

Created CSS files to be applied to various web forms on the web pages.

Used Ajax tool kit, regular expressions, regular expression validates, user search controls

Make checks if the server is returning errors and do the necessary exceptions.

Created Crystal reports on the web page by accessing the database.

Created stored procedures for application data access and manipulation.

Creating Customs Tool to transforming data XML data provided by various systems in user defined format-using XSL/MSXML.

Environment: Visual Studio.NET 2008,COM, Active PDF,ASP.Net 3.5, WCF, ADO.Net, LINQ, XML, XAML, SQL Server2005, VSS, IIS 6.0, Windows Server 2003, Web Services, Web Forms, CSS, SOAP.

Citizens Bank Cranston, RI Feb 2009 to Dec 2010

Project: Educational Loan Financial Management System

Role: Junior .Net Developer

Description: Educational Loan Financial Management System is a web based comprehensive software package supporting Student Financial Aid Administration, Loans and Reports. The system is modular and organized to support all of the functions of the Financial Aid Office like analysis, evaluation, packaging, notification, disbursement, funds management, tracking, verification and reporting. This application completely enables the process of loan applying to loan repayment of a customer over the World Wide Web

Responsibilities:

Participated in daily scrums and weekly meetings with the project sponsors to meet expectations and deadlines.

•Developed Presentation layer (Web Forms) using ASP.NET, HTML, and JavaScript.

•Implemented 3-Tier architecture.

•Implemented CSS, and various web controls to present interface to users in a much comfortable environment.

•Involved in portal GUI design using Master page, Login control, Site map, Microsoft menu control and client side validation is done by Ajax validation extenders.

•Used Grid Views and custom paging for displaying huge amounts of data.

•Created Stored Procedures, Indexes, Views and Triggers using SQL Server 2008.

•Modified web services using C# to interact with the other applications and exposed them using SOAP and HTTP.

Environment: Visual Studio 2008, C#, ASP.NET, ADO.NET, Web Services, AJAX, HTML, CSS, MS SQL Server 2005



Contact this candidate