Post Job Free
Sign in

Sql Server .Net

Location:
Kansas City, MO
Posted:
December 11, 2017

Contact this candidate

Resume:

Bhargav B

Kansas City, MO

Ph. 469-***-**** E Mail: *.**********@*****.***

Summary:

Around 8+ years of application Development & Support experience that includes Analysis, Design, Development and Enhancements of applications built on Microsoft Technologies

Experience in diverse business sectors including Financial, Telecommunications and IT Services

Extensive experience of designing and developing software applications with the C#, .NET Framework 3.0/3.5/4.0/4.5, MVC4.0/5.0/6.0 ADO.NET, AngularJS, ENTITY FRAME WORK, AJAX, LINQ, WCF, WPF, LINQ, CSS, SOAP, C#.Net with backend as SQL Server

Experience in working with Web Forms, User Controls, and Web Controls using HTML5, DHTML, CSS, CSS3, `, JavaScript, jQuery, Angular JS in Visual Studio

Strong experience in Systems Analysis, Design, Development and Implementation in developing Web and Windows using N-tier Architecture in all stages of Software Development Life Cycle (SDLC)

Extensively developed applications in WinForms, Web Forms, MVC6.0, MVVM and Single Page Application Architectural patterns

Industry experience developing Single Page Application AngularJS projects with Web API

Experience with all phases of SDLC in the Waterfall model and Agile (SCRUM) methodologies.

Used Multi-threading to set different execution paths

Involved in developing RESTful APIs/Web API and task based asynchronous programming.

Use LINQ to retrieve the data from the backend through Entity framework

Experience using Silver Light in creating and using interactive user experiences for Web Application

Experienced in building sophisticated distributed systems using REST/hypermedia web APIs (SOA)

Proficient experience in developing Queries, Stored Procedures, Triggers and Functions

Implemented VB 6.0code in module Windows operating-system functions

ANGULARJS, KnockOut.JS and used Bootstrap for Responsive Web Design(RWD)

Used REST software architecture style for creating scalable Web Services

Experience in building and consuming .NET Web Services using SOAP and REST

Implemented Web Forms to build Dynamic Websites and powerful User Interface (UI) driven sites with Data Access

Implemented MVC on server side for handling GUI elements and service layer between front end and data layer.

Worked with BSA to provide a TDD environment

Design and developed Enterprise Eligibility business objects and domain objects with Object Relational Mapping framework such as Hibernate

Expertise in implementing Object Oriented Programming(OOP) concepts including Inheritance, Abstraction and Polymorphism

Experienced in Database Design and Development using MS SQL Server, MS Access, and My SQL & Oracle

Proficient in developing systems built on SQL Server 2005, 2008, 2008 R2&Oracle using Tables, Triggers, Views, Packages and Stored Procedures in T-SQL & PL-SQL

Used versioning tools Microsoft Team Foundation Server (TFS), Visual Source Safe (VSS), Visual Studio Team System (VSTS) and Tortoise Sub Versioning System (SVN) for version controlling of the Application. Experience in versioning of assemblies and working with GIU

Technical Qualifications/Skills List

.Net Technologies

.NET Framework 4.6/4.5/4.0/3.5, Web Forms, Win Forms, ADO.NET,

WCF, WCF, ASP.NET 4.6/4.5/4.0/3.5, VB.NET, Web Services, Windows

Services, Silverlight 4/3.0/2.0/1.1, WPF 4/3.5/3.0, Entity

Framework 4, LINQ, SSIS, SSRS.

Web Based

HTML5, CSS3, Bootstrap, XML, XSL, XSD, XHTML, SOAP, JSON, JavaScript, VB Script, toolkit, Silver Light, AngularJS, Angular2.

Program Languages

C#, VB.Net 11.0/10.0/9.0, XAML, XML, SQL, PL/SQL,

T-SQL.

Database

SQL Server 2014/2012/2010/2008/(T-SQL),

MS Access 2013/2010, Oracle 12c/11g/10g/9i (PL/SQL).

Versioning Tools

Visual Source Safe and Team Foundation Server (TFS)

Reporting Tools

SQL Server Reporting Service (SSRS), SQL Server Integrated Service (SSIS),

Crystal Reports ss

Operating Systems

Windows, Linux

Testing Tools

N-Unit Testing, SOAP UI (Web-Service Testing)

Employment History

Company Name – Location

Job Title

Dates

Cerner Corporation, Kansas City, Mo

Sr.Net / UI developer

May '16 - Till date

Description of achievements and duties

Responsibilities:

Experience working on Agile (Scrum Framework) Methodologies to meet timelines with quality deliverables

Expertise in developing applications using Microsoft technologies such as .NET Framework […] Web Applications using ASP.NET MVC6.0, ASP.NET WEB API, Win Forms using Microsoft Visual C#.NET and VB.NET, Database Access using ADO.NET, Entity Framework, LINQ and distributed applications using WCF

Created stored procedure, trigger on the database to provide/insert specific data from multiple tables for Web API services

Designed the application as 3-tier architecture with extensive use of Object Oriented programming techniques

Implemented multithreading to improve the performance of the job

Used VB.NET to develop code for business and repository layer

Helped migrate from SOA to RESTful services using ASP.NET Web API

Implemented VB code in modeling Windows operating-system functions

Developed Test-driven development (TDD) strategy guiding use of the N unit testing framework.

Implemented MVC6.0 on server side for handling GUI elements and service layer between front end and data layer

Experience in using AngularJS ability to test views and able to do end to end unit testing. Also, using continuous integration

Used AngularJS HTTP (post and get) to retrieve data through Web API from entity frame work.

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

Used List, Trees, Toolbars, Menus and Context Menus for navigating between pages in Windows Presentation Foundation (WPF)

Involved in coding member validation business functionality using WCF and client front end layers using WPF

Experience in Working on MVVM (Model View, View Model) in applications

Worked on Microsoft Azure (Public) Cloud to provide IaaS support to client. Create Virtual Machines through Power Shell Script and Azure Portal.

Manage and Create Storage Account and Affinity Group in Azure Portal.

Capture an image of a Virtual Machine. Attaching a Disk to a Virtual Machine. Manage and create Virtual Network and End Points in Azure Portal.

Deploying VM's, Storage, Network and Affinity Group through PowerShell Script.

Creating Storage Pool and Stripping of Disk for Azure Virtual Machines. Backup, Configure and Restore Azure Virtual Machine using Azure Backup.

Excellent knowledge in Azure compute services, Azure Web apps, Azure Data Factory & Storage, Azure Media & Content delivery, Azure Networking, Azure Hybrid Integration, and Azure Identity & Access Management.

Expertise in Azure infrastructure management (Azure Web Roles, Worker Roles, SQL Azure, Azure Storage, Azure AD Licenses, Office365)

Created and executed SQL Server Integration Service (SSIS) packages to populate data from the various data sources, created packages for different data loading operations for many applications

Created SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB Source, Excel Spreadsheets to SQL Server

Well-versed knowledge in SQL, T-SQL. Stored procedures, functions, cursors, triggers, views, joins, using SQL Server

Deploy web applications using tools like Visual Studio .NET 2013, Visual Studio Team Foundation Server 2013, Ajax, MVC6.0, Bootstrap, JavaScript, jQuery, AngularJS, HTML

Extensive use of MVVM (MVC) and WPF for a unified user interface

Developed Stored Procedures using T-SQL in relational database MS-SQL Server and knowledge of PL/SQL commands in DDL, DCL, DML and TCL

Developed C# Classes, Web Services, MVC and Line to SQL

Used SQL Server 2008,2012 Standard Edition for database

Involved in writing test plans and test scripts for Unit Testing

Experience in Versioning Tools like Team Foundation Server(TFS)

Environment: ASP.NET 4.5/4.0, ASP.NET MVC6.0, C#.Net, AJAX, HTML5, LINQ, JavaScript, bootstrap.js, AngularJS, jQuery, Silver Light, N-unit, Entity Framework, ADO.NET, REST AND SOAP WCF, WPF, WEBAPI, JSON6, VB.Net, VB 6.0, SQL SERVER 2012, T-SQL, Visual Studio 2015/13, IIS8.

Company Name – Location

Job Title

Dates

UHG, Eden Prairie, MN

Sr.Net/UI Developer

Mar'15 - Mar'16

Description of achievements and duties

Responsibilities:

Experience on web technologies likeASP.NET, C#.NET, VB.NET, Silver Light, HTML, CSS, Web API, JAVASCRIPT, J-Query, AngularJS, Knockout, Bootstrap and AJAX in designing and developing the web projects

Understanding and exposure to the Software Development Life Cycle (SDLC), Agile Methodologies and extreme Programming techniques (Unit testing and Build Automation)

Creating applications usingVB.NET and enhancing projects for .NET applications

Created Front-end Applications using HTML5, CSS3, JavaScript, J-Query, Angular JS, Node.js, OOP, DOM, Twitter Bootstrap, AJAX, XML and JSON

Used jQuery and AJAX to make asynchronous calls to the Controllers to validate business logic and load partial views in MVC 4.0/5.0.

Used Packages, Stored Procedures, SQL Queries, and Views for retrieving the User details and the events information from the Oracle Database

GUI Design and Development. (Page Layout Design, HTML5 Design, JavaScript, jQuery and CSS3 Styles)

Utilized multithreading and parallel programming, and interfaced between optimization tool and geographic information system

Maintained and updated server and client software in multithreading environment

Create and Consume WCF service in ASP.NET web application

Designed several modules using WPF, MVVM pattern

Used J-Query in designing and to navigate a document, DOM elements, create animations, handle events, and develop AJAX Applications

Used MVC 4, MVC 5 for separating the application object model from GUI

Created and utilized Web API methods for database operations(CURD) through Entity Framework

Responsible for handling advance data querying capabilities with LINQ to SQL/Objects/XML and Object Relational Mapping using Entity Framework

Proficient in developing and consuming WCF Services, Web Services (REST and SOAP) and Windows Services

Experience with Traditional Methodologies (Waterfall, RAD), Agile Software Development Methodology and Test-Driven Development (TDD)

Used LINQ to retrieve the data from the backend through N Hibernate

Optimized NHibernate queries by looking at raw SQL generated

Implemented VB 6.0code in modeling Windows operating-system functions

Used WCF services for communicating with Microsoft SCCM (System Center Configuration Manager) server. One of the purposes was for license management

Used List, Trees, Toolbars, Menus and Context Menus for navigating between pages in Windows Presentation Foundation (WPF)

Created multiple reports (SSRS) in Drill mode using tables, financial tables, cross stabs and chart

Design, deployment, and maintenance of various SSRS Reports in SQL Server

Designed and implemented Parameterized and cascading parameterized reports using SSRS

Experience Working on MVVM (Model View, View Model) in applications

Used SQL Server 2012 Standard Edition for database

Creating databases and logins with permissions in MS SQL server as per the developer's request.

Used ASP.NET MVC 4.0 Data annotations to enforce data validation

Used Team Foundation Server (TFS) for version control

Environment: ASP.NET Framework 4.0, C#.NET, ASP.NET MVC 4.0, VB.Net, XML, Silver Light, NHibernate, SOA, AJAX, HTML5, CSS3, LINQ, JavaScript, bootstrap.js, AngularJS, jQuery, N-unit, Entity Framework,ADO.NET, WCF, WPF, REST AND SOAP, WEB API, Oracle12c, JSON6, SQL SERVER 2012, Visual Studio 2012, IIS.

Company Name – Location

Job Title

Dates

Premier Health Care, New York, NY

.Net /UI Developer

Dec’13 – Jan’15

Description of achievements and duties

Responsibilities:

Involved in gathering of requirements and creation of functional specifications for the project, based on the existing use cases and new use cases proposed by the client

Involved in Software Development Life Cycle (SDLC) through the process

Developed Web Services to identify employee hierarchy and contact info for budget approval process and consumed them in front end to auto-populate hierarchy for better user experience

Used Packages, Stored Procedures, SQL Queries, and Views for retrieving the User details and the events information from the Oracle Database

Utilized Master pages, Themes, Navigation controls, Authentication to design secure web pages using ASP.NET MVC 3.0 and built highly responsive and interactive AJAX -enabled Web applications using AJAX Tool kit

Involved in testing applications using dot net built in technologies and prepare unit test cases

Used jQuery, AJAX to call Web API service methods

Experience in using SOAP for creating web services

Used collections, interfaces, abstract classes to implement the project and also worked with the Exception Handling

Worked on CRYSTAL REPORTS for managing business intelligence applications

Involved in the development of the Web Forms and Web Pages according to the specifications. Extensive experience on AJAX, HTML, XHTML

Have used Service Oriented Architecture (SOA) to develop web services

Building SOA, MVC and MVVM applications using .NET and AngularJS technologies

Used LINQ to retrieve the data from the backend through Entity framework

Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables

Loaded Data into Oracle Tables using SQL Loader

Coordinated physical changes to computer databases; and codes, tested and implemented Oracle

SQL database, applying knowledge of database management system

Wrote application using Web API to talk to external applications and also involved in writing small ASP.NET Web Forms applications with VB.NET, C# as programming languages

Coded Oracle and SQL database descriptions and specified identifiers of Oracle database to

management system or directs others in coding database descriptions

Used SSIS to create ETL packages to validate, extract, transform and load data to Data warehouse and data marts

Created Stored Procedures, Triggers and view Tables and other SQL Joins and Statements for Applications by using T-SQL.

Responsible for standardizing the MS SQL Server Team Backup policy and back process re - engineering to new windows boxes from Linux boxes

Created SSIS packages to load data to SQL Server using various transformations in SSIS

Calculated optimum values for Oracle and SQL database parameters, such as amount of computer memory to be used by database, following manuals and using calculator

Proficient in writing stored procedures, Functions, Cursors, Packages, and Database Triggers using SQL Server and Oracle

Used Visual Source Safe (VSS) for source control

Used Team Foundation Server (TFS) for version control

Provided Production Support to troubleshoot and debug the issues during migration

Environment: C#, ASP.NET MVC 3.0, AJAX, boot strap, WPF, WEB Services, VB.Net, LINQ, JSON, Web API, Visual Studio 2010, Oracle11g, Oracle PL-SQL, HTML5, XHTML, jQuery, AngularJS framework, VSS, IIS, Web Services, SOAP, Rapid Application Development (RAD).

Company Name – Location

Job Title

Dates

Tele paradigm Networks Limited, Hyderabad, India

.Net Developer

Oct’11–Sep’13

Description of achievements and duties

Responsibilities:

Designed and developed web forms with ASP.NET, JavaScript, jQuery, JSON, HTML, XHTML, CSS, and Firebug

Designing of the Module, which contains the list of all the users and consumption history

Used N-tier Architecture for Presentation Layer, Business and Data Access Layers

Have to create New Forms depends upon User Requirement

Development of new requirements in C#http://vb.net/ 3.0, using Visual Studio 2008

Writing Stored Procedures/Adding Tables/Functions in SQL Server 2008

Developed Web-based Medical Software using C#, and SQL Server

Good in creating stored procedures, Triggers, Functions and Optimizing Queries for performance by looking at execution plan using MS-SQL Server […] 2005, Oracle, DB2

Created Tables, Stored Procedures, Triggers and Views in Oracle database

Involved in writing PL/SQL Queries, Views and Stored Procedures

Contact testing team whenever required and resolving issues

Involved in migration from MS SQL Server 2000/2005 to MS SQL Server 2008

Followed TDD (Test Driven Development) when implementing Web Service for budget approval process

Responsible for creating complex SSRS Reports based on HR specifications

Environment: .NET Framework 3.0 C#, HTML, CSS, JavaScript, Visual Studio 2008, LINQ, Entity Framework, J-Query, Ajax, Unit Testing, Windows Forms, Oracle, Oracle PL-SQL, SQL Server 2005.

Company Name – Location

Job Title

Dates

Access It Solutions, Hyderabad, India

Software developer

July’09–Sep’11

Description of achievements and duties

Responsibilities:

Involved in designing and coding for web forms of the application with ASP.NET 2.0

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

Involved in developing UI, Business Layer and Data Access Layer and used C#.NET as code behind to implement the Business Logic of the Web Forms

SQL Server 2005 is used as the back-end database which stores all the data used in entire application and implemented Stored Procedures, Database Triggers, Views, and Indexes with SQL programming

Used ADO.NET to implement the data layer to help communicate with data base

Used Visual Source Safe for version control and Participated in Unit Testing of the application to ensure quality

Used AJAX for better usability and implemented input validation using the ASP.NET Input Validation Control

Implemented Web Forms to Build Dynamic websites and powerful User Interface (UI) driven sites with data access and used HTML, CSS

Used jQuery in designing and to navigate a document, DOM elements, create animations, handle events, and develop AJAX Applications.

Environment: Visual Studio.NET 2005, C#.Net, ASP.NET 2.0, ADO.NET, VB.Net, HTML, CSS, jQuery, AJAX, HTML, SQL Server.



Contact this candidate