Resume

Sign in

Sql Server Developer

Location:
State College, Pennsylvania, United States
Posted:
February 27, 2019

Contact this candidate

Resume:

JITENKUMAR PRAJAPATI

Senior Application Developer

E: ac8ml6@r.postjobfree.com

P: 704-***-****

Summary:

Over 8 years of professional experience in Software Application Analysis, Design, Development and maintenance of Internet, Intranet, Implementation of Client/Server,N-tier architecture and Web applications in various domains like Corporations, Financial and Insurance, Dealership, Customer relationship.

Hands-on experience in UI Design using Win Forms, Web Forms, and programming ASP.NET, VB 6.0,C#.NET, ADO.NET, JavaScript, LINQ, AJAX, JSON, jQuery by using .Net Framework 3.5/4.0/4.5.

Extensive experience in XML, XML Web Services, XSLT & Security in ASP .NET.

Good knowledge in Object Oriented Analysis/Design and implemented Design Patterns across the applications.

Worked Implemented UI-routing using AngularJS and good knowledge on Node.js, ExtJS.

Experience in reporting and analysis using Crystal Reports, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) with the .net environment.

Designed and developed Use Cases, Class diagrams and Sequence diagrams using UML.

Knowledge of Azure Cloud Storage.

Experience in using Team Foundation Server (TFS) and VSTS.

Experience in analytical and technical skills and developing systems using different software methodologies like Agile and Waterfall.

Extensive database designing and programming skills using SQL Server 2012R2/2012/2008, XML data source, RDBMS and MS Access.

Hands of experience in SQL Server in writing database queries using joins, Indexes and in creating Tables, Views, Indexes, writing Stored Procedures, Functions and Triggers using T-SQL, Maintaining Database, Experience in Query Optimization.

Well acquainted with SLDC: System Analysis, Design, Development, Testing, and Deployment & Documentation.

Technical Experience:

Programming Languages

C, C++, C# .NET (4.5/4.0/3.5/3.0), VB, HTML, T-SQL, PL/SQL

Web Technologies:

ASP.NET 4.5/4.0/3.5/3.0/2.0, MVC 5.0/4.0/3.0,

Ajax 3.0/2.0, Javascript, Jquery, VB Script, AngularJS, Node.js, ExtJS.

Xml Technologies:

XML, XSLT, XPath

UI Technologies:

WinForms,WebForm, Telerik Reporting Tool

IDE Tools:

Visual Studio 2017/2012/2010, SQL Server Management Studio, Fiddler

.Net Frameworks:

.Net Framework 4.5/.4.0/3.5/3.0

DevOps Tools:

Jenkins, VSTS

Databases:

MS SQL SERVER 2016/2014/2012/2010,MS Access,Azure

Modeling Tools:

UML,MS Visio 2019/2016

Version Control Tools:

Team Foundation Server,Git,VSTS

Middleware:

WCF, ADO.NET 4.5/4.0/3.5/3.0/2.0, Web Services,

Web API

Servers:

Windows Server 2012/2008/NT, Microsoft IIS(7.0/6.0/5.0/4.0)

Education:

Master in Information System and Management

Devry University, New York.

Professional Experience:

Pennsylvania State University, State College, PA Apr’18-Present

Role: Senior Application Developer

Project Description: Involved in to develop multiple web applications which is ACMS (Alternative Course Material System), Student itemized Receipt, UBEEPS and Program Matrix.

Environment: Microsoft Visual Studio 2017, C#, VB, SQL SERVER 2012, TFS & Git, Fiddler, WCF, ASP.Net Web API, AngularJs, JSON, XML, Telerik Ajax Controls, Test Driven Development (TDD), Microsoft Azure

Responsibilities:

Involved in Code Development using ASP.NET 4.5,4.0, 3.5, MVC 5/4, Telerik Controls, Entity Framework, WCF, jQuery, Visual Studio .Net, C#, .NET Framework, Angular Js, React JS Technologies

Proven ability to gather client requirements and implement them as high-quality designs that offer enhanced functionality and meet client objectives.

Experience in Object Oriented design and implementation using C#, VB, .Net Framework, Visual Studio.NET.

Strong RDBMS experience on PL/SQL and T-SQL, Stored procedures, Views with SQL Server. Accessed and queried SQL Server database through .NET using SQL Connection, SQL Command, SQL Data Reader, and Dataset.

Strong Reporting experience in developing web/client server reports using Microsoft SSRS (SQL reporting services).

Developed the application using ASP.NET concepts like Master Pages, Sessions, and Post backs etc. using C# and VB.

Migrated Legacy Code to ASP.Net Web Applications using both ASP.Net Web Forms & MVC.

Experience developing UI layers including MVC, web forms and desktop applications

Developed various operations for the above service to call stored procedures from the Data Access Layer to Look Up the required data and orchestrate it when necessary.

Experience in Build Automation and Release Automation and Deployment Automation with CI/CD.

Experienced with automating release process using Jenkins, and VSTS as tools in diversified project environment.

Developed .NET Web Application and WCF service in VS 2017 environment and deployed in Azure Cloud Services to invoke data from Azure Blob Storage.

Deployed Web Application using windows Azure Management Portal.

Involved in deploying desktop application, web application, websites and console application to Microsoft Azure Cloud.

Documented each operation in the services precisely with all necessary details to help the users.

Involved in refactoring as suggested by Business.

United Airlines, Houston, TX Nov’15-Mar’18

Role: Senior Software Developer

Project Description:

Played a key role in development, testing and maintenance of business services in CSL (Common Services Layer). Worked with multiple teams (Payment, Authentication, Flight shopping etc.) to implement WCF services using the CSL framework and helped other teams to integrate services into enterprise channels.

Environment: App Dynamics, Microsoft Visual Studio 2013 4 2015, C#, SQL SERVER 2008 and 2012, TFS (Source Control), Fiddler, WCF, ASP .Net Web API, RESTful Web Services, JSON, XML, Fiddler, Oracle, Resharper, Code Contracts, AutoMapper, PowerShell,Dependency Injection, Test Driven Development (TDD), Azure Cloud Storage

Responsibilities:

Developed, tested, documented and maintaining Reference Data service. This provides a reference data repository. Any application that needs data such as Airports, Countries, Weather and so forth can call this service as needed. The intent is to have all the data in a common area so that applications do not have to maintain their own copy and provide consistency across applications.

Development experience with designing and building WCF SOAP and RESTful web services as well as Web API layers.

Experience developing UI layers including MVC, web forms and desktop applications

Developed various operations for the above service to call stored procedures from the Data Access Layer to Look Up the required data and orchestrate it when necessary.

Was involved in the development of Shopping Cart Service which was developed to manage the shopping cart, checkout process and the payment service.

Implemented the PayPal Express Checkout (Merchant SDK) Module in the Shopping Cart service to provide users with additional payment options.

Worked with different teams from PayPal as well as United to understand the Business and technical requirements in order to implement as per the latest CSL framework and integrate it with the Front End.

Wrote Unit Tests and Monitor Test to test every method locally and then used Fiddler to test the service calls after deployment.

Documented each and every operation in the services precisely with all necessary details to help the users.

Involved in refactoring as suggested by Business.

Prysmian Group, Claremont, NC Jun’15-0ct’15

Role: .Net Developer

Project Description:

The application “My Prysmian” is designed for helping improve their Stock Finder (inventory lookup) where by customers can lookup inventory. “My Prysmian” also generate report for daily production of Telecom cable, Energy cable and data cable where data SAP system. “My Prysmian” displaying all reports through SSRS and SSIS.

Environment: ASP.NET, ADO.NET, VB.Net, SQL SERVER, IIS, BIDS, ASP.NET data binding, HTML, CSS, SAP

Responsibilities:

Developed ASP.NET web pages using C#, HTML, CSS and JavaScript.

Worked with SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) with the .net environment.

Provided session management to preserve the state of key variables.

Created Web forms using ASP.Net /. NET Framework for Logon, account information, Category plans using Server controls and C#.

Supported and developed both web-based applications using ASP.NET as well as client-server applications written in VB.NET.

Created SQL LINQ queries for Business class functions to access databases.

Create interface between testing system and smart Client Program.

Worked with the database using ADO.NET library Data source events and binding.

Developed forms to view data and store data to SQL server 2008 database.

Designed and developed several SQL server stored procedures, Triggers, Views, User defined functions for all the DML functionally for the website.

Jefferies Group, New York City, NY May’13-Mar’15

Role: .Net Developer

Project Description:

This application is designed using 3-tier architecture; the presentation layer is developed using ASP.NET, C#, and ADO.NET on Visual Studio.NET. Encapsulation is made by coding all the business logic writing in code behind file, data layer is coded in a data layer class, and database connection logic is coded in a common data layer class, which is used for the other applications too.

Environment: .Net Framework 3.5, Visual Studio 2012, MVC, C#, AngularJS, HTML5, CSS3, JavaScript, Entity Framework, ASP.NET, ADO.NET, WCF, SSIS, JQuery, Ajax, MSSQL Server 2008, T-SQL, LINQ, IIS, Windows 2008 Server.

Responsibilities:

Developed application using ASP.NET, Razor, AngularJS, HTML5, CSS 3, JQuery, Ajax, Bootstrap and JavaScript.

Used AngularJS expressions and directives to display data dynamically using 2-way binding.

Implemented UI-routing using AngularJS .

Designed and implemented master, child master and content pages using ASP.NET and C#.Net as per the new design to maintain consistency across all Web forms.

Used ASP.NET validation controls as well as JavaScript validations in the front end forms.

Created re-usable nodes on multiple pages which can be used throughout a site.

Created, deployed and consumed web services using WCF.

Provided session management to preserve the state of key variables.

Involved in developing web services using WCF, Web API and data access layer using entity framework and testing .

Designed databases and developed stored procedures for SQL Server 2008 database.

Co-developed a CMS interface for non-programmers and QA's to easily manage and modify content using MVC framework.

Created MVC 4/5 razor JQuery, Ajax, Entity Framework views to design HTML based multiple pages of the Application.

SSIS used to development and maintenance of integration services package and SSRS to create the reports using interface

Helping team members in technical issues related with design and development.

Co-ordinate several software releases from Developer to QA & then to UAT & then to production.

HRP Software, India Jan’12-Feb’13

Role: .NET 4.0, C# Developer

Project Description:

DMS (Dealership Management System) project provides master data management and user management systems with defined access permissions/role management for each user group and each of the functionalities. This software is used to keep track of your orders, manage inventory, print shipping labels and manage suppliers. It also provides solution for organization to create Purchase orders, billing and receipting, labor efforts and other service features. It also provides facilities for bookkeeping simply by entering your sales and expenses, organizing your finances, doing payroll and taxes.

Environment: Visual Studio 2010, SQL Server 2008, Telerik Control, Telerik Reporting, C#.NET, SOAP, Stored Procedure

Responsibilities:

Followed and developed the N-Tier architecture for the business, presentation and data access layers using WPF, Telerik Controls with C#.

Gathering requirement from client or business user. Analysis of the specifications/requirements provided by the business user.

Used Telerik Controls to build a rich User Interface and for advanced functionality within the application.

Implement Class Library for the ease of coding.

Used Team Foundation Server (TFS) to develop application.

Developed Database Queries using joins, Indexes and also Tables, Views, Indexes, Stored Procedures, Functions and Triggers using T-SQL.

Designed and developed Report for the data from database using Telerik Reporting Tool.

Manage integrity and calculation among all modules of Projects which are Accounting, Sales, Services, Parts, Payroll.

Efficient use of Telerik RadGridView, Radwindow to Insert,Update, Delete and Search data with Filter option and also used Validation Controls to validate Data in entire Project.

Reviewed code to ensure that all the Processes and Standards are being adhered i.e. ensuring correct implementation of requirements, coding standard, project architecture, efficient code writing techniques etc.

Rishabh Software Pvt Ltd, India Jan’11-Dec’11

Role: .Net Developer

Project Description:

This is a CRM project with master data management and customized access permissions/role management for each of the functionalities. The sales executives will contact all customers in their list. This will keep track of all the information from the point of generation of a business lead to the point that lead becomes an actual customer.

Environment: Visual Studio 2010, SQL Server 2008, SQL Profiler, C#.NET, SOAP, Stored Procedure, Entity Framework, LINQ, Telerik AJAX RadControls, HTML, JavaScript, CSS

Responsibilities:

Developed UI page and development using ASP.NET 4.0, HTML5, Telerik Ajax RadControls, AJAX, User Controls and Web Forms with C# using N-tier architecture.

Worked closely with clients in gathering and analyzing requirements and providing solutions that meet the client’s requirements.

Used Telerik Ajax RadControls to build a rich User Interface and for advanced functionality within the application.

Designed and developed class library for Domain entities using entity framework.

Implemented Data access layer using ADO.NET to connect, retrieve or manipulate data from SQL Server 2008.

Wrote SQL queries with Joins on multiple tables, Stored Procedures, Functions, Triggers, Indexes using T-SQL and LINQ in SQL Server 2008.

Used Master Page and User Controls to increase code reusability.

JavaScript functions are used to provide easiness to user on application.

LINQ functions written for data access.

Implemented Web Services using SOAP to manipulate information of customers.

Used Session Management and specified controls to prevent unauthenticated/unauthorized access.

Participated in meetings with Business users and with other project teams to ensure that the volatile business requirements reflect in the project development.



Contact this candidate