Data Sql Server

MEHUL PATEL Phone: 516-***-**** Email: ***.*.*****@*****.***

PROFESSIONAL SUMMARY

* ***** ** ********* ********** in designing and developing Web Applications, Web Services and Client/Server Applications by using Microsoft .Net technologies.

Strong in the complete Software Development Life Cycle (SDLC) including requirements Definition, Design, Programming / Testing and Implementation of major systems.

Extensive experience in Designing professional UI Web Applications using Front End Technologies like HTML, CSS, JavaScript, jQuery, AJAX, JSON and AngularJS, React JS.

Involved in the design and development of MVC, N Tier Architecture

Excellent experience with develop, design, deploy web service, WCF, web API

Knowledge on developing the Web application using framework like Language Integrated Query (LINQ), Entity framework and LINQ to Entities.

Experience in Database Analysis/Design/Normalization/Manipulation processes using SQL Server, MySQL Database. Data Base programming using PL/SQL, Constraints, Indexes, Views, Stored Procedures, Packages, Triggers and User Defined Functions.

Experience in creating Web Forms, Win Forms, User Controls, Custom controls.

Extensively used various ASP.Net features like Caching and State Management of Web Applications.

EDUCATION

Bachelor of Engineering in Electrical Engineering

Master of Science in Electrical and Computer Engineering

TECHNICAL SKILLS

Web Application

: C#, ASP.NET, MVC 3/4/4.5/5, ADO.NET, Razor Engine View, WCF, Microsoft Silverlight 4.0/3.0, SharePoint 2013, Entity Framework, XML, JSON, FTP/SFTP, UML, HTML5, AJAX, Web Forms, Web Services, ASP.Net.

Development IDE:

: Visual Studio .Net 2003/2005/2010/2012/2017.

Programming Languages:

: C#, C/C++, python.

Scripting

: HTML 4/5, HTML, jQuery, AngularJS, CSS, JavaScript.

Web Servers

: IIS 8.0/7.0/6.0

DBMS

: SQL Server 2014/2012, MS Access, PL/SQL and LINQ to XML.

Version Management Tools

: Team Foundation Server (TFS), Visual Source Safe (VSS), GITHUB, Tortoise SVN.

Operating Systems

: Windows NT/2003Server/2008Server/XP/Vista/7

PROFESSIONAL EXPERIENCE

VinSolutions, Mission, Kansas April 2018 - Present

Full Stack .Net Developer

Project Description: Vin-solution is the CRM Provider Company for the Auto Dealers. It is a leading dealership customer relationship management system. VinSolutions products integrate dealership systems, processes and tools to deliver a single view of the customer across the business – so dealers can focus on building relationships throughout the sales cycle.

Responsibilities:

Involved in various phases of the Software Development Life Cycle (SDLC)

Created Console app service using Tophelf and Quartz.

Created components using React.js.

Consumed JSON/XML data exposed by REST/SOAP.

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.

Involved in the design of the DAL using ASP.NET, Entity Framework and LINQ to Entities.

Created and tuning the database objects like complex Stored Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.

Using GitHub for source control and documented the entire application.

Created test plans and performed unit and regression testing and L&P testing.

Ingalls Memorial Hospital, Harvey, Illinois Jan 2017 - March 2018

Full Stack Net Developer

Project Description: working in all phases of SDLC to design, development, implementation and support of mission-critical enterprise application. It contains several modules such as Application Administration, Patient Information System and Medical Record System to efficiently manage and maintain the inventory and patient records.

.

Responsibilities:

Involved in Software Development Life Cycle process that includes requirement analysis, designing, and deployment and testing.

Developed a web application using ASP.NET MVC 4.5, C#, Bootstrap, ADO.NET, Ajax and Entity Framework.

Designed and developed the user interface for various tools and implemented ASP.NET validation controls, JavaScript, jQuery, CSS for server and client-side validations respectively.

Experienced creating LINQ to Entities Queries for accessing the Entity Framework Model version 5.0

Creating WPF Master Detail UI using Window Object Data source.

Implemented business logic using OOP Concept and SOLID Principles

Extensively used WCF services, thereby achieving complete Service Oriented Architecture.

Leveraged Entity Framework and Repository Pattern to Build Data Access Layer (DAL).

Created and tuning the database objects like complex Stored Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL server 2012/2014 Server.

Worked in Agile SCRUM team environment for developing releases.

NYIT, Old Westbury New York Jan 2016 – Dec 2016

Project Description: Developed a website to where all the medical students can access the video tutorials of the class

Developed website using N-layered architecture.

Created stored procedures, functions and optimized queries for performance using T-SQL in SQL Server 2014.

Used Entity Framework database first approach to develop website.

Used Dependency injection pattern to reduce the dependency between the classes using Ninject.

Implemented Authorization filters, applied Data Annotations and custom validation to validate user input.

YASH Technologies, Hyderabad India Feb 2013 – March 2014

.Net Developer

Project Description: The Application provides access to the client to input different change orders regarding telephone number subscription; perform importing and out porting of Telenor numbers. The project is developed with C#, ASP.NET, Visual Studio, Java Script, Web Services, ADO.NET, XML Suite, Crystal Reports, and SQL Server.

Responsibilities:

Implemented the project using ASP.NET, C# and the back-end database SQL Server. Analyzed client’s requirements and involved in designing the GUI.

Developed use cases and class diagrams for data and business access components of the system.

Developed initial prototypes using HTML, JavaScript, jQuery and CSS.

Implemented input validations using .NET Validation Controls.

Developed personalized views using Themes and Master pages.

Extensively used Data Grid & Data Lists to display data returned from Server.

Effectively used the State Management techniques i.e. Session State, View State, Cookies.

Developed ASP.Net user interfaces. Created user controls for headers and dynamic side menu using ASP.NET and C#.

Created User and Custom controls to enable reusability and used rich server controls of ASP.NET.

Effectively used ADO.NET objects such as Data Reader, Dataset and Data Adapter to access data from MS SQL Server.

Contact this candidate