Management Sql Server

NILESH BUTANI

{Email: acrmwi@r.postjobfree.com Phone: 215-***-****}

PROFESSIONAL SUMMERY

Microsoft professional with around 6+years of professional experience in analysis, design and development of software solutions in the IT industry. Experience in all phases of SDLC (Software Development Life Cycle),with emphasis on OOD process. Proficient in client-server applications, N-tier applications and web based applications.

Professional experience in analysis, design and development of Web applications with .NET framework using ASP.NET, MVC, VB.NET,C#, AJAX, ADO.NET, Entity Framework, XML, SOAP, Web Services, WCF, WCF REST, Web API, JSON.

Extensive experience in design &development of N-tier architecture web applications with ASP.NET MVC4.0.Experience with Service Oriented Architecture (SOA)

Experience in designing applications using OOAD(Object Oriented Analysis and Design) and Design Patterns (like Factory, Singleton, Façade, MVC, Dependency Injection …).

Experience with scripting languages like JavaScript, JQuery, and AJAX (Asynchronous java Script and XML).

Experience in writing Data Access Layers using ADO.NET Entity Framework and LINQ to SQL.

Deep understanding of Relational Database Management System (RDBMS) and hands on experience in database Analysis, Architecture, Design and Development using MS SQL Server and Oracle.

Experienced with Sitecore CMS (Web Content Management System) design and development (Information Architecture, Template, Layout, Renderings (View Rendering and Controller Rendering), Sitecore APIs)

Experience with Agile Scrum(using Agile Tool like Rally) and Test Driven Development methodology.

Solid experience with Test Automation Frameworks (NUnit, MS Test, Moq Framework (Mocking Library))

Experience with Code Review and Code Refactor using tools like ReSharper. Experience in leading junior developers team.

Strong analytical skills with proficiency in debugging and problem solving.

TECHNICAL SKILLS

Languages& Frameworks: C# 4.0/5.0,VB.NET, C, C++, .Net Framework 3.5/4.0/4.5, T-SQL

Web Technology: ASP.NET, MVC, ASP,AJAX,XML, JSON, JQuery, JavaScript, HTML, CSS, Web API, WebServices,WCF,ADO.Net, XML

Development Environments: Visual Studio 2012, SQL Server Management Studio

Web Servers: IIS6.0/7.0

Databases: SQL Server2005/2008 R2

Automation Test Framework: Unit, MS Test, Moq Framework (Mocking Library)

Processes and Methodologies: SDLC, Waterfall, Agile Scrum

Version Tools: Team Foundation Server, Visual Source Safe (VSS), Subversion (SVN)

Utility Tools: Fiddler, SOPA UI, ReSharper, NuGet

PROFESSIONAL EXPERIENCE

The Fidelis Group, New Jersey July 2014 – Present

Role: Sr. .NET Software Developer

Project Title: www.1800AnyLens.com

An E-commerce responsive website, being used nation-wide by customers, for purchasing contact lens

Responsibilities:

Involved in full SDLC, Analysis, Design, Implementation, Testing, Troubleshooting and Deployment of applications targeting MVC4.0 and .Net Framework 4.5 in VS 2013.

Involved in design and development of N-Tier architecture application using MVC Framework, Entity Framework, C#, JQuery in Visual Studio 2013

Involved in Front-End development using MVC Framework, JQuery, AJAX, and HTML

Involved in design and development of View, Controller, and Model.

Implemented ASP.NET MVC Custom Filters (Action filters, Exception filters)

Implemented Dependency Injection (DI) pattern using Unity Framework and adhered to SOLID principles

Design and developed Service Agent layer as an interface between .Com application and external services

Involved in design and development of Data Access Layer using Entity Framework

Involved in Database Design, writing T-SQL queries, Stored Proc., UDF in SQL Server 2008 R2

Accountable for writing Unit Test and Integration Test using MS Test Framework and Moq Framework (Mocking Framework)and practiced TDD (Test Driven Development)

Accountable for Code Review, Code Refactor, and Code Quality Assurance

Practiced Agile (SCRUM) using Rally Tool in development of various projects

Environment:ASP.NET MVC 4.0, C#, .NET Framework 4.5, Entity Framework, Sitecore 7.1(WCMS), Unity Framework, Moq Framework,NUnit, MS SQL,WCF,Web Api, JQuery, HTML, CSS, AJAX, NuGet Package, TFS 2013, Visual Studio 2013, Rally Agile Tool

Maven Automation Ahmedabad, India Jan 2014 –JuLy 2014

Role:Sr. Software Developer

Project Title: Gate Pass Management System

GatePass is an application for Visitor Management (VMS), Contract & Labor worker Management (CLMS), Vehicle Management and Returnable & non-returnable material inward/outward. The software manages activities at the entry points of an organization. The software validates and maintains record of entry and exit of visitors, contract workers, vehicles and material. The authorization work-flow validates and allows permissions for all transactions in the application.

The software generates passes for authorized entry & exit of visitors, vehicles and material. These passes can be designed with photographs and barcodes. Gate pass uses advanced technologies and devices like face recognition, finger prints, GSM modem, and visiting card scanner with OCR, digital pen, Time & attendance device and HID tags to give an integrated & technologically futuristic solution.

Responsibilities:

Involved in full SDLC, Analysis, Design, Implementation, Testing, Troubleshooting and Deployment of applications targeting MVC and .Net Framework 4.5in VS 2012.

Estimated timeframe for development, testing and deployment against BRD and successfully delivered on time.

Involved in Design and Development of N-Tier architecture application using MVC Framework, Entity Framework, C#, JQuery, WCF Rest Service in Visual Studio 2012.

Involved in design and development of View, Controller, and Model. Developed complex MVC Controller, View Models and Helper methods linked to backend database.

Involved in design and development of Data Access Layer using Entity Framework.

Involved in Database Design, writing T-SQL queries, Stored Proc., UDF in SQL Server 2008 R2

Design and develop Unit Test Library to perform common functionalities and accountable for writing automated Unit tests using MS TestFramework.

Interacted with developers and team members to understand the business process.

Accountable for Code Review, Code Refactor, and Code Quality Assurance

Environment:ASP.NET, MVC 4.0, C#, .NET 4.5, MS SQL, jQuery, HTML, CSS, AJAX, LINQ,WCF Rest, MS Test Framework, Visual Studio 2012,WEB Api.

Embedded Precision Technologies,Gandhinagar,India April 2009 – Dec 2013

Role: Software Engineer

Project Title:Cinematix - Software for Ticketing System

Cinematix is a modern, affordable and flexible ticketing application for cinemas, theatres, arenas, stadiums and concert venues. Theatres Ticketing System is a generalized program designed for theatre owners of India. Program helps in managing operations of ticketing and allotment of seats to buyers for current show or for advance booking. The specification were developed jointly with the customer and a state government nominated expert for compliance with the entertainment tax rules, however, it could be customized according to the needs of other government rules, Multiplexes for multiple screen etc.

Responsibilities:

Involved in Design, Development, Unit testing, Integrated Testing and UAT/Production Deployment.

Involved in front-end development using MVC framework, jQuery, CSS, Ajax,Excelexporting.

Involved in creating Models, View and Controllers.

Involved in creating common Extension methods.

Implemented most for the common JavaScript and jQuery functions.

Effectively used Lambda expressions of LINQ in the middle tier of the application.

Extensively used Entity Frame work to communicate with the SQL Server 2008

Created some important backend SQL Stored Procedures

Environment: Visual Studio 2012, ASP.NET MVC 4, jQuery, AJAX, Web API, C# 4.0, XML, JSON, SQL Server 2008.

Project Title: Dental & Laboratory Management System [Phase 2]

This is USA Dental & Laboratory Service Portal. It is paperless information Exchange for the dental industry. This Portal used by USA Dental Practices and Laboratory offices. All Dental and Laboratories can register in this portal to use this Application. Doctors can take advantage of Electronic Prescription (E- Prescription) software solutions to replace written prescriptions.

After completion of Phase-1, subsequent release of the Build-1 adds some new modules to the previous release. The Modules involved in this Build-2 are:

Dental/Lab Dashboard

National Dental/Lab Search

My Groups & Calendar Event

My Labs/My Dentist

Patient Appointment Schedule

My Price Sheet

My Catalog/ Coupon

E- Prescription Creation (Four Types)

Responsibilities:

Actively participated in the preparation of Detail Design documents and object identification.

Involved in coding using ASP.NET, C#, MVC 3.0.

Responsible for User Interface design using Razor view. Developed and used user defined namespaces along with system-defined namespaces.

Developed business logic and code behind using C# for paperless discount and education rating.

In WCF Used ADO.NET objects such as Data Adapter, Data Reader, Data Set and Data View for consistent access of data.

Involved in high level designing of interfaces turning mobile device alerts.

Involved in client interaction, handling change requests and implementing the application on the client side.

Implemented Routing, URl, Security, Action Filter techniques for application development.

Implemented role based security that determines user access based on their associated role.

Created stored procedures, cursors and indexed views for data manipulation and retrieval.

Involved in writing stored procedures and performed fine-tuning on the stored procedures

Involved in unit testing, module testing and integration testing.

Environment: Visual Studio 2010,ASP.NET 4.0, ASP.NET MVC 3, jQuery, AJAX, WCF 4.0, ADO.NET, C# 4.0, XML, JSON, SQL Server 2008

Project Title: Dental & Laboratory Management System [Phase 1]

Description: This is a very large project so whole project is divided in to various builds. Depending on the project aims and goals, software development models or methodology selected for the development of this project is “Incremental Model”. Whole requirement is divided into various builds. Each subsequent release of the build adds function to the previous release. The process continues till the complete system is achieved.

Working on various module:

Dentist/Laboratory Registration

Profile Manager

Lab/Dentist Search

Article Creation & Search

Lab/Dentist User Management

Admin Interface (User Management, Lab/Dentist Creation, Lab/Dentist Search etc)

Responsibilities:

Understanding &Analysing the business requirements and client specifications.

Studied and analysed the business requirements and transformed them into system inputs.

Involved in complete SDLC of project (Analysis/Design/Development/Testing).

Coding for user interface based on functional Requirement.

Implemented ASP.NET MVC pattern mechanism to display using Razor view.

Developed the services using WCF to access Database related functionalities using ADO.net.

Implemented jQuery for client side sorting and validations.

Implemented Data Annotations attributes for model validation on both client and server sides

Implementing AJAX functionalities for partial page rendering through JSONP.

Developed the necessary stored procedures and created complex views using joins for robust and fast retrieval of data.

Environment:Visual Studio 2010,ASP.NET 4.0, ASP.NET MVC 3, jQuery, AJAX, WCF 4.0, ADO.NET, JQuery, C#, XML, JSON, SQL Server 2008

Project Title: Employee Management System (EIS)

Description: This is internal Information system, manages all records like Attendance, Projects, Business Developments Records, NWD (Non-Working Days), Holidays, Company Policies, News, Reports etc.

Responsibilities:

Involved in development of several modules like Employee Records, Employees leave management, Resource Allocation Management, Employee Schedule management and Automated E-mail Alerts,in a team environment.

Involved in identification of entities and in establishing relationships among various entities.

Implemented Business logic using .Net framework and developed Win Forms with C# as code behind.

Used various Win Forms controls like Menu bar, Data Grid, Dataset, Binding Source, Group Box, Split Container for data display, formatting and designing layout of the form.

Developed an export module which exports data into XML file format.

Involved in creating .NET Reportsto present the data in different views.

Wrote triggers and Stored procedure using T-SQL.

Environment:ASP.NET, C#, MS SQL.

EDUCATION

Bachelor of Engineering in Electronics&Communication North Gujarat University

Contact this candidate