Sql Server .Net

Sandeep

**.*****@*****.*** 434-***-****

Professional Summary

5+ years of professional experience in developing and deploying the applications utilizing a variety of programming languages and in depth understanding of all the phases of developing and deploying (SDLC-Software Development Life Cycle), Client-Server and N-tier Architecture with Agile, Waterfall, Scrum.

Prodigious working with basic MVC and all the ASP.NET MVC Frameworks like the 6.0/5.0, Implemented the components like the Model, Views, Partial Views, Strongly Typed Views and controller actions.

Working skills in consumption of distributed application using WCF (Windows Communication Foundation) and its designing, development, testing, its security and handling WCF based service, data, fault, and message contracts.

Working knowledge of client-side functionalities with various UI and responsive components which are execution functionalities in the web applications using advanced JavaScript/UI structures like JSON, JQuery, XML, Bootstrap 3.2, AJAX, AngularJS 1.2/2, HTML (5/4), DHTML, XML/XSL/XSLT, CSS (3/2).

Extensive experience with Angular 2, creating custom directives, decorators, and services to interface with both Restful/SOAP based services.

Doyen in Database design (RDBMS), programming, implementation and development using MS SQL Server 2005/2008/2012, Oracle 11g/10g/9i, MS access, analytical and conceptual skills in database related work primarily creating complex Stored Procedure, Views, Triggers, Functions, T-SQL, Indexes, Cursors, Performance Tuning, SQL Profiler.

Proficient in data object models like Language-Integrated Query (LINQ) and Entity Frame Work6.0/5.0 to retrieve and modify data and developed entity data frame work services and designing Entities and Entity Relationships in both Code-first and Database-first approaches using Entity Frame Work and Written Unit tests cases using NUnit and Microsoft Unit Test Framework.

Working background in unit testing and execution testing systems like NUNIT, MS Unit Tests for business rationale.

Experienced working with Team Foundation Server (TFS), VSTS for daily based tracking of work progress and maintaining synchronous with other team members.

Knowledge in working with information serialization, attribute routing, client-based confirmation and token-based verification in WEB API.

Experience working with GitHub as the version control to achieve an effective communication.

Proven ability to work independently and as a part of a team with an ability to deliver within short deadlines, excellent communication and a versatile team player with proven problem-solving skills.

Technical Skills

.Net Technologies

ASP.NET 4.5/4.0/3.5/2.0, MVC 5/4/2, MVVM, Entity Framework, Xamarin, Web forms, Web Services, WCF, RESTful Service, WPF, ADO.NET, Silver light.

Programming Languages

C#.Net (4.0/3.5/3.0), VB.NET (10.0/9.0/8.0), HTML, T-SQL, PL/SQL LINQ, XML, Couchbase.

Scripting and Markup

VBScript, JavaScript, SharePoint, jQuery, Knockout JS, HTML, CSS, XML, WSDL, XSLT, SOAP, AngularJS 1.2/2, JSON, Bootstrap, AJAX.

Framework

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

Databases

SQL Server 2012/2008/2005, No SQL, Oracle 9i/10g/11g, T-SQL, PL/SQL, MS-Access.

Protocols

REST, SOAP, TCP/IP, HTTP, UDP/IP and FTP.

Web Server

IIS 7.0/6.0/5.0

Tools

Visual Studio .NET, Telerik, NUnit, Nlog, SQL Server Reporting Services (SSRS 2008/2005), Crystal Reports (2010/9/8.5/8), Xamarin.

Version Control Tools

TFS, Visual Source Safe, GIT.

PROFESSIONAL EXPERIENCE

Client: Ivalua (Direct works) Pittsburgh, PA Nov 2016 – Till now

Role: Full Stack .Net Developer

Description: Ivalua provides a better way for manufacturers to work across teams and with suppliers to develop, launch and deliver more profitable products. This Application is mainly about product and inventory management through supplier selection and coordinate with executive initiatives to improve the profitability of any active products, buyers can request a Quote for the product listings, simultaneously monitor supplier performance and buyer activities.

Responsibilities:

Created the Controllers using Controller Actions, Action results, views and View Models using ASP.NET MVC.

Implemented C# features like dynamic, Serialization, Multi-threading, reflection, asynchronous methods and named arguments.

Created API controllers in C# which has Web API methods to accept user inputs and return response in JSON format.

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

Responsible for making AJAX Calls for the UI Interactions to the Controller Actions using Angular 2 and getting the Data back as JSON and parsing it onto the UI.

Used Angular 2 to standardize web application structure and responsive using bootstrap and provide a future template for data binding.

Angular 2 HTTP Services were made to communicate with WCF service and data was retrieved in (JavaScript Object Notation) JSON format for display to improve application performance.

Used HTML5, CSS3 and Bootstrap to create UI layout design to get cross-device compatibility and color scheme of the website.

Implemented Data Access Layer using Entity Framework Code First to implement CRUD operations, Performance issues, establishing relationships with Fluent API and migrations.

Developed and consumed Web services using WCF (Http, SOAP and XML) and Web API (RESTFUL services).

Developed tables, stored procedures, views, functions and triggers to perform automated rules, updating to related tables in oracle 11g and 12c.

Developed reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS and SSIS.

Involved in Unit and fixing the issues occurred in the testing process.

Used GitHub as the version control to achieve an effective communication between the teammates.

Environment: Visual Studio 2015, ASP.NET MVC 4.5, C#, VB.NET, WCF, WEB API REST, AngularJS 2, MVVM, Bootstrap, HTML5, CSS3, Entity Framework, IIS 7.5/8/8.5, LINQ, XML, xUnit, Oracle DB, VBA, SSRS, SSIS, Git.

Client: CAPITAL ONE BANK PLANO, TX Oct 2015 – Nov 2016

Role: .Net Developer

Description: The application was for Online Banking. The application provides client account information like account summaries, account details, monthly statements, balance transfers, check ordering, loan application, credit cards and financial services. Transactions were done using batches and web services. This was a conversion project from the legacy application to a more enhanced version.

Responsibilities:

Used advanced knowledge of web technologies, including MVC 5, ASP.Net, C#, CSS, Ajax, Angular JS, HTML, XML, TSQL, database modeling tools and database interactions.

Implemented MVC Architecture on client side and creating Models, Controllers, and Views Scope etc. Using Angular JS.

Used Angular JS to standardize web application structure and responsive using bootstrap and provide a future template for data binding.

Angular JS HTTP Services were made to communicate with WCF service and data was retrieved in (JavaScript Object Notation) JSON format for display to improve application performance.

Implemented WCF SOAP services to facilitate communication between multiple transport protocols.

Developed business logic including Code-behind files and Classes in N-tier.

Developed User Controls, used VB.NET web controls and improved the performance of the application by configuring the caching.

Used Asp.net Web API 1.1/2.0 to migrate the codebase from SOA to RESTful Service.

Worked with WEB API's to make calls to the web services using URLs, which would perform GET, PUT, POST and DELETE operations on the server.

Performed T-SQL tuning and optimization of queries for reports that take longer execution time using SQL Query Analyzer in MS SQL Server 2008.

Developed complex programs in T-SQL, wrote Stored Procedures, Triggers, Views and Queries with best execution plan.

Implemented service methods and SQL queries, PL/SQL to interact with the Oracle DBMS.

SQL Server Reporting Services (SSRS) for both on-demand (pull) and event-based (push) delivery of reports. Users can view reports in a Web-based format.

Utilized Microsoft Team Foundation Server (TFS) for source code repository.

Implemented Unit Testing, Integration Testing and System Testing using NUNIT, JUnit, xUnit.

Followed Scrum and Test-Driven Development Methods in Agile Scrum Methodology to produce high Quality software.

Environment: .NET Version 4.5/3.5, Entity Framework 5.1, Visual Studio 2012, Angular JS, SQL Server 2012, VB.Net, C# 4.0, MVC 4/5, TFS, XML, WCF, CSS3, HTML5, WEB API, MVVM, Twitter Bootstrap, XHTML, Node.js, NUnit, xUnit, LINQ, PL/SQL, SQL-Server 2008, Oracle, SSRS, JavaScript, JQuery, IIS 7.5.

Client: MMS Infotech Hyd, India Feb 2014 – June 2015

Role: Jr .Net Developer

Description: The Loan Monitoring System is intended to deliver a system to support credit management for the bank. The system issued for accepting loan forms, generating reports and tracking the status of loans.

Responsibilities:

Involved in gathering the requirements, created functional specification, analyzed and designed application.

Developed interfaces using the C# program for creation and change of Sales and Purchase order.

Involved in the design and development of the website using Visual Studio 2008 using MS SQL Server 2005.

Used N-tier architecture for presentation layer, Business and Data Access Layers using C#.Net.

Developed web forms using ASP.NET server controls and validated client side using Java Script.

Designed and developed UI using C#.Net, ASP.NET and used Grid view control throughout the application.

Used SQL Server 2005 to populate the data and information about the customers.

Designed and developed user interfaces using VB.Net and ASP.Net.

Worked with tools like Microsoft Front Page, Dream Weaver for developing web interface.

Configured Web.Config files for entire Web Application.

Implemented MVVM (Model View View Model) pattern to create Silverlight user controls.

Developed a Web API for a search engine to access merchant’s details with Ninject as dependency injection, Angular Js within MVVM pattern.

Created various RESTful services using WEB API to return serialized JSON data which are later consumed through Angular2 services.

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

Designed various stored procedures in database and worked on ADO.NET code to connect to SQL Server and extensively worked with LINQ queries.

Created use case and class diagrams in MS Visio using UML notations.

Involved in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services using SSRS and Crystal Report across various environment.

Throughout this project we followed waterfall methodology.

Environment: C#2.0, .NET Framework 2.0/3.5, VB.NET7, ASP.Net 2.0/3.5, HTML4, VSS, WEB API, JSON, ADO.NET, CSS, SSRS, Web Services, JavaScript, SQL Server 2005, Silverlight, MVVM, Team Foundation Server 2008, Visual Studio 2005/2008, MS Unit.

Client: SM Technologies Hyd, India June 2012 – Dec 2013

Role: Junior Web Developer

Description: It’s a windows application providing the industry with enterprise information assurance and IT security, and enables employers to access firm’s educational programs, technical training, marketing consulting and the nation’s leading executive forum for IT Security professionals.

Responsibilities:

Used WinForms GUI to design and develop a Windows application.

Implemented Object-Oriented Programming (OOPS) concepts of interfaces, inheritance, abstraction and polymorphism.

Created multi-layer application using C#, ADO.NET, JavaScript and CSS.

Utilized ADO.Net technology like Data set, Data Table and Data Adapter extensively for data retrieving, querying, storage and manipulation and displaying data from SQL Server 2008 Data Source.

Used Web.config to create connection strings. Used ADO.NET to access SQL database.

Extensively used Silverlight/WPF page layouts, animated transition controls and key-frame animations.

Created and maintained database objects like complex Stored Procedures, Cursors, and Tables, Views, User Defined Functions, in SQL Server 2005 for inserting/Updating/Deleting the data into the relational tables.

Created complex Stored Procedures, triggers, cursors, tables, and views using T-SQL.

Used Team Foundation Server (TFS) for version controlling and assisted in documentation and creating Help files.

Have successfully published various .NET interfaces screens on to the IIS server.

ENVIRONMENT: C#.Net, ADO.NET, ASP.NET, VB.NET, C#, WinForms, Silverlight, JavaScript, SQL Server 2005, HTML, CSS, Win Forms, TFS.

Contact this candidate