Sign in

Sql Server .Net

Montgomery, Alabama, 36106, United States
October 25, 2016

Contact this candidate


Vijay Kumar


Professional Summary

7+ Years of professional experience in designing, development and implementation of N-Tier Client/Server Web and Windows based application domains using Microsoft .Net Framework 3.0/3.5/4.0/4.5.

Well Versed in all phases of (SDLC) System Development Life Cycle from investigation of initial requirements through analysis, design, development implementation and documentation Support.

Development Experience on Various Microsoft Technologies like C#.NET, ADO.NET, ASP.NET MVC 3.0/4.0, LINQ, WCF and WPF.

Extensive experience in developing XML Web Services, WCF services and Web API.

Extensive knowledge in web Designing and Development of user interfaces using HTML, HTML5, XHTML, CSS, CSS3, Bootstrap, JavaScript, JQuery.

Extensive experience on working and implementing Object Oriented Programming principles.

Experience on working with Agile, Scrum and Waterfall technologies.

Good Knowledge and experience in using design frameworks like MVC and MVVM and design patterns like Singleton, Observer.

Developed Single Page applications using the AngularJS framework.

Experience in using Team Foundation Server (TFS), GIT source control repository, Tortoise SVN and VisualSourceSafe (VSS).

Proficient in RDBMS concepts including writing Stored procedures and functions using TSQL in MS SQL Server 2005/2008/2008R2/2012 and good experience on PL/SQL in Oracle 8i/9i/11g and also MS Access.

Extensive experience of working in Test driven development (TDD) and Agile development environment.

Good experience in deploying and testing web applications on IIS 5.0/6.0/7.0

Extensive experience in creating tables using PL/SQL, Oracle, reporting solutions like Crystal, RDLC reports.

Worked on .NET third party tools like Telerik data controls and JQuery UI controls.

Extensive experience in OOAD Technology developing Use Cases, Sequence Diagrams and Class Diagrams using Enterprise Architect and MS Visio.

Planned and Organized testing phases including Unit testing(NUnit) & Integration testing, writing test cases, generating test scripts and reviewing test results & taking corrective actions, Bug analysis and fixes in Web-industry standards.

Experience on Windows Azure cloud platform.

Have good experience working in a team and individual environment.

Technical Abilities

Microsoft Technologies

Microsoft .Net Framework, ASP.Net, MVC 4, Web Forms, Win Forms, WPF, WCF, ADO.Net, LINQ

Web Technologies


Web Servers

IIS 5.0, IIS 6.0, IIS 7.5

Programming Languages


Development Tools

Visual Studio .NET 2003/2005/2008/2010/2012/2013/2015, Rational Rose, UML

Client side Technologies

JavaScript,, JQuery, KnockOut.Js, AngularJs


Microsoft .Net 4.5/ 4.0/ 3.5/3.0


SQL Server 2012/2008/2005, Oracle 10g, 11g, PL/SQL

BI Tools


Version Controller

TFS, Microsoft Visual SourceSafe

Database Tools

SQL Server Query Analyzer

Software Packages

MS-Office 2003/ 07/10/13

Operating Systems

Windows Win7/XP/NT/95/98/2000/2008/2012, Windows Azure



Professional Experience:

Client: Centralized Alabama Recipients and Eligibility System (CARES), AL Aug’15 – Till now

Role: Sr. NET Developer

Project Description: Centralized Alabama Recipient Eligibility System (CARES) Program was initiated as a result of the Patient Protection and Affordable Care to handle significant changes to eligibility determination criteria for Medicaid and the Children’s Health Insurance Program (CHIP) programs. CARES solution is an enterprise product developed and configured as web-based portal application. It provides case workers and citizens easy access to submit and analyse insurance eligibility information. This program comprises the State of Alabama’s Medicaid Agency, Department of Public Health (ADPH) Alabama Department of Human Resources (DHR), Department of Mental Health (AFMH), Department of Senior Services (ADSS) and others.

Roles and Responsibilities:

Experience with State Government, Medicaid, Children Health Insurance Program (CHIP) and Department of Human Resources (DHR) business area or healthcare industry.

Responsible for gathering, compiling and synthesizing information with regard to technology processes or systems.

Responsible for performing moderate to highly complex programming and systems analysis work on projects with integrated systems that impact multiple applications to support end-user needs.

Involved in Design, Development, Implementation and Unit testing.

Develop and maintain Cares project, which is based on ASP.NET MVC framework and the backend database is SQL server and uses WEB API for various services.

The front end systems leverage C# .NET and MVC.NET frameworks to create a highly flexible frontend experience.

Experience developing CRM project with Microsoft Dynamics.

Developed a web portal using Node JS, JQuery, HTML, CSS, AngularJS, and Bootstrap 3.

Application Lifecycle Management is tooling with Microsoft Team Foundation Server (TFS).

Middle-tier support for CARES is provided using Web Methods.

Re-programming the existing web methods service modules in WEB API.

Services implementation on Windows Azure.

Automated various SQL scripts to run SSIS packages and used Octopus deployment tool for deploying them to production.

Design and development of business reports using SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

Process knowledge and experience with agile software projects.

Environment: .NET Framework 4.5, C#, ASP.NET MVC 4.0, Web API, Microsoft Dynamics CRM, HTML, CSS, JavaScript, Bootstrap, JQuery, Angular JS, WCF, Azure, SQL Azure, Web Methods, SQL Server 2013, Oracle PL/SQL 11g, TFS, SSIS, SSRS, Unit Testing.

Client: Texas Medicaid and Healthcare Partnership (TMHP), TX Nov’14 – Aug’15

Role: Sr. NET Developer

Project Description: Texas Medicaid and Healthcare Partnership (TMHP) is a group of contractors under the leadership of Accenture. Accenture administers Texas Medicaid and other state health-care programs on behalf of the Texas Health and Human Services Commission. The Texas Medicaid & Healthcare Partnership (TMHP) is committed to assisting providers with enrollment in the Texas Medicaid program and other State Health-Care programs. TMHP has dedicated Provider enrollment coordinators to assist providers with education and training on the TMHP provider enrollment application process and requirements, and to offer hands-on assistance with completing and submitting the TMHP enrollment application.

Roles and Responsibilities:

Involved in Design, Development, Implementation and Unit testing.

Experience working on Medical Claims systems.

Implemented MVC architecture to accomplish task of isolating Business Layer, Presentation Layer and Data Layer.

Responsible for developing Application using ASP.NET MVC 4.5 and C#.

Used HTML, CSS, JSON, JavaScript, JQuery and Angular JS for front end development.

Used WCF for multiple services to interact with the application.

AngularJS was used to make the web applications dynamic and is used for making DOM manipulation.

Created Restful Web APIs using ASP.NET, consumed Web Services from both Windows forms and ASP.NET web applications.

Developed complex SQL queries and stored procedures using SQL Server 2012 for extracting, inserting and deleting the data from database.

Used TFS 2012 for code management.

Experience working on web services both SVC and ASMX.

Developing and configuring SQL Server Integration Services (SSIS) packages

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

Experience developing automated unit tests using Unit test projects.

Environment: .NET Framework 4.5, C#, ASP.NET MVC 4.0, HTML, CSS, JavaScript, JQuery, Angular JS, WCF, SQL Server 2012, Oracle PL/SQL 11g, TFS, SSIS, SSRS, Unit Testing.

Client: CVS Health, RI Jan’14 – Nov’14

Role: .NET Developer

Project Description: This application is for CVS Caremark Retail - Minute Clinic which facilitates practitioners with various patient managements and reporting features including automatic kiosk machines record processing and then records get processed for further processing through SSIS and SSRS systems. This application is a collection of more than 50 different application which deals in Electronic Medical Records processing.

Roles and Responsibilities:

Design and development of Minute Clinic’s custom application suite (practice management/electronic medical record and related systems).

Team Leading/ mentoring and other project tracking tasks.

Arranging status calls and information gathering, involved in interaction with the onsite team for Business requirements gathering.

UTC reviewing & writing, coding/ development, performing Unit testing and reviewing, code reviewing & Defect fixing.

Creating Stored Procedures in SQL Server 2008.

Responsible for writing common controls/ services to communicate with third party service.

Involved in coding with given coding standards. Involved in System testing support, Defect fixing and UAT Support.

Pinpointed and solved several of our most widespread crashing bugs.

Worked on ASP.NET MVC 4 architecture for view, the controller and model layers and were coded using C#.NET.

Developed application using ASP.NET MVC4, JQuery, and JavaScript.

Used GIT source control repository for code management.

Used agile methodology for software development.

Developed and consumed WCF services to search for incidents based on filter attributes.

Implemented SOA architecture using WCF services. Used open source as the dependency injector for the application.

Environment: .NET Framework 4.0, C#, ASP.NET MVC 4.0, WCF, SQL Server, Oracle PL/SQL 10g, GIT, JavaScript, NUnit, Agile.

Client: Anthem INC, OH Oct’12 – Jan’14

Role: .NET Developer

Project Description: Anthem is a health group which provides health insurance for millions of families. One of the department is the finance department where we used to clean the data which comes from the various vendors, clients regarding new accounts, expiry of policy and claims and processing and sending the detailed report about the pending and penalty claims need to be paid to the hospitals sectioned by each region and location wise.

Roles and Responsibilities:

Involved in the complete lifecycle (SDLC) of the project i.e. Design, Development, Implementation, and Unit testing.

Designed and developed Master pages and User controls.

Designed and Developed flexible UI, more user interactive and user-friendly rich front-end pages, reusable classes, functions using, C#, and AJAX for client side validation.

Designed, modelled and architected multi-threaded, enterprise n-tier software agent using Windows Communication Foundation (WCF) web service hosted in a Windows.

Used ADO.Net namespaces and classes and created data access components to access database and used Crystal Reports.

Used the Entity Framework when developers issue queries using LINQ.

Involved to Designed database tables for Technical Specification Document (TSD).

Developed complex stored procedures and complex SQL queries using SQL Server 2005 for extracting, inserting and deleting the data from database and display on data bound controls and dropdown controls and list boxes.

Performed unit testing and system integration testing and created oracle Forms.

Involved in fixing the bugs based on the client requirements and involved in the enhancements in the web forms, class files and stored procedures.

Environment: ASP.NET3.5, C#3.5, ASP,MVC4, MVVM, ADO.NET, HTML, DHTML, JavaScript, XML, IIS 6.0, SQL Server 2005/2008, TSQL, Agile.

Client: Citi Bank, New York, NY. Feb’11 – Oct’12

Role: .NET Developer

Project Description: A Mortgage Backed Security (MBS) is a Security that is based on a POOL underlying Mortgages. MBS can be divided into two types namely Commercial MBS and Residential MBS. The residential mortgage backed securities (RMBS) are special bonds which are supported by private property especially the house of the mortgagor, this private property here serves as the collateral. This also involves the Securitization Process.

Roles and Responsibilities:

Planning, analysing, designing, building, delivering and providing post production support.

Capturing business requirement and CRs (Change Requests).

Coding, testing and implementing the project using C#.NET, ASP.NET, SQL Server, SQL Integration Services and Oracle.

Created Windows Power Shell Scripts for SFTP, TFS, Packages and Autosys Jobs.

Conducting testing of application with different scenarios of the Business.

Client Management and Solution Design.

Addressing queries regarding the software and extending onsite support to the clients including maintenance of hardware/software support.

Utilized kendo grid to display and manipulation of records from SQL database.

Networking with the project team and conducting periodic project progress review meetings to ensure effective delivery of project solutions in line with time and quality parameters.

Ensuring that all technical components are properly designed, tested and documented with primary responsibility for resolving issues.

Troubleshooting problems pertaining to System Performance, Network Administration, Application Conflicts and System Bugs.

Organizing the project support central and managing the project related documents and links to be accessible quickly and efficiently.

Implementing a project deliverable process with a digitized support central Workflow to track component deliverables for the project.

Designing and Implementing Robust processes, error Handling Framework using Rejection, Fatal Handler and Fault Policy.

Writing SQL statements, Views, functions and stored procedure for the database.

Environment: ASP.NET 3.5, C#.NET (3.0), MVC, MS SQL Server 08, Oracle PL/SQL 10g, SSRS, SSIS,WCF, Infragistics, AJAX Toolkit,FTP, SFTP, Team Foundation Server (TFS), Windows Power Shell 1.0, IIS, JavaScript, HTML and CSS.

Client: CliniLabs Inc., NY. Aug’09– Feb’11

Role: .NET Developer

Project Description: CliniLabs is a clinical Research organization, doing research for different types of medicines. Research for sleep study was carried out on several patients for specific time duration. During the time when they are sleeping various observations are recorded in the database.

Role and Responsibilities:

Involved in SDLC for Designing, Developing and Testing of the System.

Gathered user requirements by interacting with users and prepared Software Requirements Specification (SRS) and other supporting documents.

Designed and developed UI (Web Forms), User controls using ASP.NET (C#) after interacting with users for requirements.

Implemented Data access layer (DAL) using ADO.NET to connect and retrieve and manipulate database information.

Implemented Functions, Triggers and Store Procedures using SQL in SQL Server 2005.

Used GIT source control repository for code management.

Implemented GUI using HTML, XML, CSS and Web Form Controls to create web pages, developed Master Pages, classes for reuse.

Environment: .NET Framework 2.0, c#, ASP.NET, ADO.NET, SQL Server 2005, WEB SEVICES, Ajax, XML, JavaScript, HTML, CSS, Unit Testing, GIT, Integration Testing.

Contact this candidate