Sql Server Management

Abhinav Arra

SUMMARY OF EXPERIENCE

More than * years of diverse experience in Information Technology, in all phases of software analysis, design, development and deploying N-tier web applications, client / server applications using ASP.Net MVC 4.5/4.0/3.5, ASP.Net Webforms 4.5/4.0/3.5, C#, WCF, Web Services, Web API, AngularJS, jQuery, JSON, SharePoint, HTML5, CSS3, JavaScript and SQL Server 2012/2008, Visual Studio 2015/2012/2010.

Expertise in AngularJS controllers, directives, components, factory and service resources, routings and events.

Experience in SQL Server Database Creating, Database Objects, Stored Procedures and Functions using T-SQL.

Proven ability in creating Views, Partial Views, View Models and Action Filters in ASP .NET MVC.

Experience in developing N-Tier Architecture using Data Access Layer (DAL), Business Logic Layer (BLL) and User interface (UI), Model View Controller (MVC) and Service Oriented Architecture (SOA).

Extensive Experience in accessing and managing data using C#, ADO.NET, Entity Framework, and LINQ.

Good experience using various transforms in SSIS as an ETL tool while transferring the data from various

sources into the destination files.

Proven ability in defining query for generating drill down reports, matrix reports, table reports in SSRS.

Worked on Team Foundation Server (TFS) for source code management and project management.

Experience in deploying the

projects through Internet Information Services (IIS).

Good experience working with Agile development methodologies like Scrum.

Expertise in converting the requirement into the Technical Specifications and developed them using C# and ASP.NET.

Worked on ASP.NET Security features using filters such as Authentication and Authorization using different types like Windows, Forms, Passport and Source Code authentication.

Worked extensively on creating and consuming Web services, WCF, Web API.

Experience in using NUnit to test and detect possible problems for related application, and used fiddler, yslow for checking application performance.

Having basic knowledge of SharePoint Server.

Quick learner, Team player. Able to work independently.

TECHNICAL COMPETENCIES

Languages

C#, HTML5, CSS3, C++, Core Java

Web Technologies

AngularJS, ASP.NET 4.5/4.0/3.5, MVC 4.5/4.0/3.5, WCF, Web Services, Web API, SharePoint, Internet Information Services (IIS).

Database

SQL Server 2012/2008.

Scripting Languages

JavaScript, AJAX, jQuery.

Development Tools

MS Visual Studio 2010/2012/2014/2015, SQL Server Management studio 2012/2008.

Testing tools

Nunit.

Operating System

Windows 98/XP/7/8/10, Windows Server 2008/2012

Version Control Tools

Team Foundation Server (TFS), SharePoint.

Company: - Coyote Logistics, Inc., Jersey City, NJ May 2015-Present

Role: - AngularJS/ C#, ASP .NET Developer

Description: - Coyote Logistics is an air freight shipping company, provides international freight and global logistics services. They are exports in providing their services to wide range of customers systematically. This project is about Warehouse Management System(WMS) which is developed for Coyote Logistics with a central database for allowing multiple warehouses to operate independently with complete access. This system consists of the following main modules like Receiving, Put Away, Location Management, Inventory Management, Picking and Shipping, Reporting. One of the main functionality of the system is to develop the Inventory Management system which is used to provide the availability of any items within the warehouse. The information of inventories is updated automatically once the items are received and shipped. The system has many different features like view Current Inventory status, view Inventory Location within the warehouse, view Inventory Transaction History, Consolidate Inventory based upon the customer, Lock/unlock inventory, Accept Cycle Count orders, Print Cycle Count Reports and Update Cycle Count Status.

Responsibility: -

Designed and developed a responsive single-page web application using AngularJS, ASP.NET MVC, Web API, HTML5, JavaScript, jQuery, CSS3 and Twitter Bootstrap.

Implemented AngularJS Controller functions, service using Controller methods to set up initial state of the object.

Implemented AngularJS Services to bind the data and provide access to the data on the server.

Used AngularJS as the development framework and done CRUD operations with $http service.

Used AngularJS filters for search, sorting, pagination and custom filters.

Designed a Web application using Web API with AngularJS and populated data using ADO.NET entity framework and Used Entity Framework to model and manage data from SQL Server.

Created AngularJS Routing to connect different controller to the view which allows the single-page application.

For better design user experience used Bootstrap for Modal pop-ups, Alerts, etc.

Implemented Client side validations using AngularJS Custom Form Validation and server side validations using Data Annotation.

Created Tables, Stored Procedures, User Defined Functions, Views and Triggers for different data operation on the database using SQL server.

Adapted Agile Mythology named Scrum for all the work performance.

Used Team Foundation Server (TFS) for version control, source control and for better communication between the team members.

Environment: -

Visual Studio 2015, AngularJS Core, Microsoft SQL Server 2012, ASP.NET MVC 4.5, Web API, Entity Framework, Team Foundation Server(TFS), HTML5, JavaScript, jQuery, CSS3, Twitter Bootstrap.

Company: - Shaw Contract Group, NEW YORK, NY. Dec 2013-April 2015

Role: - ASP.NET MVC Developer

Description: - Shaw Contract Group manufactures residential and commercial resilient products which are engineered with state-of-the-art manufacturing equipment and holds numerous patents for novel creations over the years. This project is about Parent Roll Processing (PRP) which is developed for Shaw Contract Group. The system consists of two applications; the first application is on pc based system which is used to communicate with the MU over a serial port, the Second application is on Web based portal which is used run on a Windows based server and SQL database Server for doing actions with mapping. This System includes several models like Admin, Parent Roll, Scheduling, Move Ticket, Reports. The most important functionality in this Applications is Parent Roll File Maintenance. The features of this functionality are; Administrator can create, edit and search for a parent roll. Using the WIP number or Pattern, the user can directly search for a specific PDS. A new roll is being scheduled, if the information doesn’t populate.

Responsibility: -

Designed and Implemented Web Application by using ASP.NET MVC 4.0, Razor, C#, jQuery, Ajax, Html5, CSS3, JSON, LINQ, Lambda Expression, Repository, Custom Action Filter, Bootstrap.

Using ASP.NET MVC 4.0 implemented Controllers for processing incoming requests, handling input, saving data, and sending a response to send back to the client.

Designed User Interface with Razor Views, Partial Views and Twitter Bootstrap for Layout View.

Created Model classes for the different tables of the database on the MVC application.

Used ViewModel in the view, to populate data from different tables on the same view.

Used WebGrid, GridView with jQuery/JSON to provide more flexible, editable and sortable grid view to increase user interaction.

Created multiple partial views and reused them across the application.

Used AJAX Helpers for making asynchronous AJAX calls in Views.

Used Action Filters for implementing user authentications, authorizations and role based security.

Used Exception Filters for handling errors raised by the controller action results.

Used LINQ to SQL and Lambda Expressions to query data from SQL Server.

Used Bootstrap to make web application responsive and user friendly.

Deployed the project through Internet Information Services (IIS).

Implemented Unit testing with NUnit for detecting and solving problems.

Maintaining Version Control of the project in TFS by merging the developed code with the latest version in the TFS.

Environment: -

ASP.NET MVC 4.0, C#, jQuery, Entity Framework, HTML5, CSS3, Razor, Microsoft SQL Server 2012, NUnit, Visual Studio 2012, TFS, JSON, LINQ, IIS.

Company: - Dixon Group Inc, Washington, DC Feb 2012-Nov 2013

Role: - ASP.Net Developer

Description: - The Dixon Group provides management consulting services for federal agencies, government offices, and nonprofit organizations. It offers marketing and materials development services; and meeting and publication support services. This project is about Functional Event Management Tool for Dixon group and the aim is to create an efficient web application replacing the existing system. This application consists of three main phases; Event, Event Management, and Administration. The functionalities of Event Management Are Event Setup, Call for Presentations, Abstract Review, Speaker Management and Session Management. Event Setup is the first logical step of the workflow which has the features like Event Metadata, Venue info, Client into & contact, Event Manager, Sponsored Participants, and Event Services.

Responsibilities:

Designed the Web Application using ASP.NET WebForms.

Designed the N-tier architecture for the application development with Presentation Layer (UI), Data Access Layer (DAL) and Business Logic Layer (BLL).

Graphical User Interface (GUI) was designed using ASP.NET4.0, CSS, and JavaScript. The business logic was coded in C#.

Extensively involved in T-SQL Queries like creating Tables, Stored Procedures, Functions, Triggers.

Created ADO.NET objects like Dataset, Data Reader and Data Adapter to connect to the database in DAL.

Manipulated data using data Bound controls like GridView, Repeater and WebGrid.

Used Dynamic SQL for better filtering operations.

Enforced Validations using ASP. NET validation controls and Custom Validation controls.

Created Modal Popups with Bootstrap and jQuery.

Created and consumed WCF Service to use in the application for important operations.

Environment: -

C#, ASP.NET 4.0, ADO.NET, JavaScript, HTML, CSS, WebForms, Microsoft SQL Server 2008 R2, Visual Studio 2010, WCF.

Company: - KESINENI TOURS AND TRAVELS, Hyd, India. Jan 2011-Feb 2012

Role: - ASP.NET Developer

Description: - KESINENI TOURS & TRAVELS is the largest provider of Inter-City bus transportation, serving more than 75 destinations with about 425 schedules daily across South India. The Aim of the project is to design Ecommerce Web-Application replacing for Kesineni Tours & Travels. The main modules of this application are Home, Schedules Check Fare, Cancellation, and View PNR status. One of the main functionality is Check Availability

Of Seats of a Schedule. The main features of this functionality are Select Source, Select Destination, One Way, Round Trip, Coach Type, No of passengers, Search. If all the information is not provided, the application requests the user to complete them.

Responsibility: -

Developed a server-side web application with ASP.NET 3.5, HTML, CSS, jQuery, JavaScript and AJAX in Visual Studio 2008.

Developed Master Pages, User Controls, and Custom Controls.

Developed code for operations between the application and the database using ADO.NET in C#.

Developed Stored Procedures, Views, User Defined Functions using T-SQL.

Used Visual Studio Business Intelligence Tools to create SSRS reports.

Used SSIS in Visual Studio Business Intelligence Tools to handle different data formats for incoming invoices and automated tasks.

Deployed the application into Internet Information Services (IIS).

Environment: -

C#, T-SQL, ASP.NET 3.5, JavaScript, jQuery, HTML, CSS, IIS, Microsoft SQL Server 2008, Visual Studio 2008.

Contact this candidate