Sql Server .Net Developer

Arpit Vyas

Email: acxjgs@r.postjobfree.com

Phone: +1-832-***-****

PROFESSIONAL SUMMARY

Microsoft and Kentico CMS Certified developer having 4 Years of experience in developing software applications.

Possess technical expertise in all phases of Software Development Life Cycle (SDLC) that includes requirement study, Analysis, Design, Development, Integration, Re-Engineering, Maintenance, Installation, Implementation and Testing.

Development of projects using C#.NET, ASP, ASP.NET, ADO.NET, VB.Net, Javascript, AJAX, Web Services, HTML, HTML5, Bootstrap CSS, CSS3, Windows Communication Foundation (WCF), Multithreading, IIS and MS SQL Server 2013/2008R2/2008/2005, Application Security, experience with MVC, Angularjs, Kentico CMS 7/8/9, DNN CMS.

Created structure and worked on N-Tier Architecture Project using Inversion of Control (IOC) and Repository pattern along with Dependency Injection.

Build project structure with Code First Method using Entity Framework and created DB Entity classes to migrate database. Applied Code First and Data First approach to create project.

Extensive experience in SQL-Server, Enterprise Manager, SQL (T-SQL), Stored Procedures, Views, Indexes, Cursors, Triggers and Functions, SQL Transactions, SQL Profiler, SQL Dependency, developed and optimized Queries using SQL Query Analyzer.

Experience in creating Web Forms, Windows forms/ User Controls, Custom Controls and familiar with Signal R.

Swift learner with a strong ability of multi-tasking in a high-pressure environment and equally comfortable working on solo or large-scale team projects.

Recognized as an effective and motivational team player with a distinct aptitude in collaborating with cross-functional teams.

PROFESSIONAL EXPERIENCE

Operating Systems

Windows 2003, XP, windows 7, windows 8/8.1, windows 10

Framework:

.Net Framework 2.0/3.0/3.5/4.0/4.5/4.6

Technologies:

C#, ASP.NET, ADO.NET, Kentico CMS 7/8/9, DNN CMS, MVC, Web Services, HTML, HTML5, Signal R, CSS3, XML, C++, VB.Net, Web Services, Bootstrap CSS, SQL Profiler, SQL Dependency WCF, MVC Web API 2, Integrated third party tools and familiar with Signal R.

Database:

MS SQL Server 2005/2008/2008R2/2012/2014

Scripting Languages:

JavaScript and Jquery, Json, Ajax, K# (Kentico CMS)

Development Tools (GUI/IDE):

Visual Studio 2008 to 2015, SQL Server 2008R2 to 2014, Brackets, Visio 2010, Balsamiq Mockups, SVN, IIS 6.0/ 7.0/ 7.5/ 8.0/ 8.5, Bitbucket (Git), GitHub, TFS, Zoho, Jira, Trello.

EDUCATIONAL QUALIFICATION

Bachelor of Engineering (Information Technology), India

CERTIFICATIONS

Microsoft Certification Exam for HTML 5, CSS 3 and JavaScript

Kentico 8 Certification exam

Kentico 9 Certification exam

PROJECT EXPERIENCE

Sr.Net Developer Feb 2016 – Till Date

Client: Marvegos, San Ramon CA USA

Description: Marvegos school for fine arts provides a rich variety of art-making opportunities for students, age 4 - 17 which includes fine art camps, workshops and classes. Marvegos is a customized system created under Kentico CMS 9 using ASP.Net framework.

Roles & Responsibilities:

Coding and designed web forms and created zones to set HTML.

Integration testing, database, handling, designing, deployment, performing productivity & Quality check.

Performed module wise Testing according to the business requirements.

Used Kentico web parts, page Templates and custom web parts.

Managing SVN work items. Under Kentico website used staging and workflow.

Created Transformation in Kentico CMS and created resource file in Kentico CMS to manage application text.

Schedule windows service to update data on daily basis.

Created custom tables and customized user interface.

Environment: Kentico CMS 8/9, ADO.NET, ASP.Net 4.0, Javascript, IIS 7.0, AJAX, ADO.NET, Jquery, XML, SVN, SQL Server 2008 R2, Web parts and custom web parts, Custom table, Page Templates, Zones, CSS3, HTML5, Workflow, Windows Server 2008.

Sr.Net Developer Feb 2015 - Dec 2015

Client: Zephyr Sleep Technologies, Canada

Description: Zephyr’s products and technologies are used world-wide by sleep labs, technicians, physicians, dentists, and leading-edge sleep researchers.

Roles & Responsibilities:

Design database with SQL server as per the website requirement.

Created Individual user accounts application using Visual Studio 2015.

Manage SoureTree for Bitbucket (Git) repository and work items.

Deployment and manage Go-daddy account settings for project hosting.

Implement application role wise permissions and add master page design using bootstrap CSS.

Directly interacting with clients and gathering new requirements.

Analysis of specifications provided by the Client. Performing Productivity & Quality check.

Extensively created ASP.NET MVC Web API 2 for the communication between client and server (NOTUS hardware device).

Involved in Software development life cycle (SDLC) of application from design phase to implementation phase, testing, deployment and maintenance phase.

Environment: ASP.NET4.5, C#, WCF, Javascript, IIS 7.0, AJAX, ADO.NET, Jquery, LINQ, XML, Microsoft Enterprise Library, SQL Server 2008 R2, Jquery Custom Grid, Windows Server 2010, T-SQL, Windows XP, API Authentication Header, Web API2, CSS3, HTML5, Responsive UI, Visual Studio 2015 Community Edition, Bit-bucket (Git), Trello, Go-daddy hosting server, Bootstrap CSS.

Sr.Net Developer Dec 2014 – Jan 2015

Client: 4cliqs, India

Description: The 4cliqs is an Asp.net application designed for companies who wants to keep the list of Employees alongwith their Expense report. This account helps the company‘s admin to manage expense report and functionalities of all the employees.

Roles & Responsibilities:

Requirement Analysis, coding and design using Bootstrap CSS.

Testing on modules of application, deployment and maintenance.

Database handling and Performing Productivity & Quality check.

Developed application using Asp.net Framework 4.5.

Designed Architecture of the project and involved in solving complex problems.

Extensively involved in implementing GPS services by the help of which admin can track the realtime location of the user and can set a regular time interval to pin point on Google map.

Involved in Software development life cycle (SDLC) of application.

Managed SVN work items of project folder for exchange between the team.

Upgraded the performance of the web pages and saved Server Side trip by writing JavaScript code for validating the simple control instead of sending them to the server side.

Designed project mock up screens using XAML, Visio 2010, Balsamiq Mockups.

Used ODBC in order to establish a connection of application with SQL server as well as My SQL server so that admin can change database as per hosting plan.

Authenticated header by designing WCF Services. Implemented classes for data validation to perform edit check on the data.

Involved in developing components for Business and Data tier using C#, ADO.Net.

Developed Stored Procedures, INDEXES, Triggers, and Views in SQL Server 2008 R2 for accessing the database.

Environment: Asp.net, C#.Net, Sql Server 2008 R2/2014 with ODBC connection, Java Script, WPF, IIS 7.0/8.0, AJAX, ADO.NET, Jquery, XML, ASP.NET 4.5, Jquery Grid, CSS3, HTML5, Responsive UI, Microsoft Enterprise Library, Windows Server 2008.1, T-SQL, TFS, Mysql Workbench 6.2 64bit, Restful Web services, SVN, Visual Studio 2012, Visio 2010, Balsamiq Mockups, Dependency Injection.

Sr.Net Developer May 2014 to Nov 2014

Client: Ministry of Food Agriculture (TBS Tarim), Turkey

Description: The TBS built in system was developed with a purpose to manage Livestock with the technical support of the United Nations Development Programme Country Office in order to increase the agricultural productivity and income levels of poor in less-developed parts of Sivas and Erzincan provinces. Under this project, identified the loop holes for delay in page loading by applying cookies, browser cache and leverage browser caching to load all the download links like JS, CSS, Jquery one time only add SQL dependency to load specific table data on server leave to save multiple trips.

Roles & Responsibilities:

Identfied the pitfalls of existing modules using GTMetrix and Google Developers.

Created a testing environment to execute a development plan.

Checked SQL Server queries to improve the execution plan and used SQL Profiler, SQL Dependency to build performance.

Directly interacting with clients and gathering new requirements.

Used agile methodology and created project modules to check performance report and deliver modules in scrum.

Deployed and managed testing server.

Used TFS for versioning and create new testing repository to update changes before moving them to live environment.

Performed Productivity & Quality check for each module before deliver and deployment on live.

Enhanced the application without disturbing the architecture, coding standards.

Environment: Asp.net 3.5/4.0, C#.Net, Sql Server 2008 R2/2012, Web services, ADO.NET, Javascript, IIS 7.0, AJAX, Jquery, LINQ, XML, Microsoft Enterprise Library, Windows Server 2008/8.1, T-SQL, SQL Profiler, SQL Dependency, TFS, Ulakbim server, Use Software AG for web methods, Visual Studio 2013.

Sr.Net Developer Jan 2014 – Apr 2014

Client: Adversitement (GAWBS), Netherland

Description: QMet is a website that maintains the data of Google Ad-words (GAW) accounts based on goals set in the website as well as based on the information like CTR, impressions etc. Created a Task Scheduler which is managed by IIS Server using ASP.Net framework.

Roles & Responsibilities:

Coding and design using bootstrap CSS to create a responsive UI.

Analysis of specifications provided by the Client and create project documentation.

Created secure application by implementing role authentication so that user can access their respective authorized pages only.

Created a Task Scheduler using ASP.Net global.asax file to get the updated data from Ad-word in regular set of intervals.

Database handling, designing and developed Stored Procedures, Triggers, and Views in SQL Server 2008 for accessing the database.

Participated in full development life-cycle using Object Oriented Programming (OOPS) concepts and Agile SCRUM methodology.

Used GitHub to manage work items. Performed Productivity & Quality check (NUnit Testing) for each modules.

Using Jquery grid views managed dynamic grid columns and rows. Also user is able to set layout of the grid view with an option to hide and show required columns.

Create windows service to add and update application dashboard complex data in SQL table to bind application dashboard using this single table.

Managing development, staging and production servers for auto builds and backups.

Involved in Design and Developing components of this application using ASP.NET, C# .NET, JavaScript.

Environment: Asp.net 4.5, C#.Net, Sql Server 2008 R2, SVN, IIS 7.0/8.0, Javascript, AJAX, GitHub, ADO.NET, Jquery, XML, Responsive UI, Dynamic Jquery Grid, Microsoft Enterprise Library, Windows Server 2008, SQL Profiler-Dependency, Google adwords API oauth2, Visual Studio 2012, Visio 2010, Balsamiq Mockups.

Sr.Net Developer Aug 2013 – Dec 2013

Client: Guest for Home, France

Description: Guest for Home (GFH) is a trusted community marketplace for people to list, discover, and book unique accommodations around the world online or from a mobile phone. This application was created in multiple languages using ASP.Net framework.

Roles & Responsibilities:

Involved in coding and design using bootstrap CSS for responsive UI.

Designed Database tables as per project requirements using SQL server 2008R2.

Defined project and database structure as per N-Tier Architecture and Multi-Language (10 languages) web site.

Extensively involved in creating ASP.NET Web API for the communication between client and server.

Managed GitHub work items to update/add changes and managed testing repository prior to deployment.

Created WCF Service for validating the user input. Implemented classes for data validation and performed edit check on the data.

Managed server deployments and settings for web service, windows service and database filestream.

Demonstrated the UI modules to Users in weekly meetings as per the SCRUM.

Database handling and designing and used SQL Profiler to monitor performance of various stored procedures.

Used SQL dependency to monitor application Database for Data Changes to save multiple trips database for same type of data for all users.

Enhanced the application without disturbing the architecture, coding standards.

Environment: C#.Net4.0, Sql Server 2008 R2, Javascript, WPF, IIS 7.0, AJAX, ADO.NET, Jquery, XML, Jquery Grid, CSS3, HTML5, Responsive UI, Microsoft Enterprise Library, Windows Server 2008/8.1, File-streaming, Restful Web services, GitHub, Visual Studio 2012, Bootstrap CSS, Visio 2010, Balsamiq Mockups, Integrated third party tools, SQL Profiler, SQL Dependency.

Asp.Net Developer Mar 2013 - Jul 2013

Project Title/Client: Warehouse Supermarket, Systematix India Pvt Ltd, India

Description: Warehouse supermarket (WSM) is a trusted community marketplace for people to list, discover, and book unique accommodations around the India online. This application is based on ASP.Net framework that enables user to book warehouses as per their requirements.

Roles & Responsibilities:

Created project in ASP.net framework 4.0 using VS 2010.

Involved in coding, deployment and designed using bootstrap CSS for responsive UI.

Participated in full development life-cycle using Object Oriented Programming (OOPS) concepts and Agile SCRUM.

Database handling and designing by managing SQL Stored Procedures, Triggers, Index, Keys, Relationship, Views and tables.

Experience in optimizing queries for performance by looking at Execution plan, creating INDEXES and views using SQL SERVER.

Extensively Involved in Design and Developing components of this application using ASP.NET, C# .NET, JavaScript.

Built a service to perform set of task in given time interval.

Created highly scalable web site with less round trip using HTTP handler classes for all requests so the application response move as a smart navigation.

Managing server deployments and server settings.

Environment: Asp.net, C#.Net, Sql Server 2008 R2, Javascript, WPF, IIS 6.0, AJAX, ADO.NET, JQuery, XML, ASP.NET4.5, Jquery Grid, CSS3, HTML5, Responsive UI, Microsoft Enterprise Library, Windows Server 2008/8.1, TFS, SVN, Restful Web services, Visual Studio 2012, Bootstrap CSS, Visio 2010, Balsamiq Mockups, Integrated third party tools, SQL Profiler, SQL Dependency.

Asp.Net Developer Aug 2012 - Feb 2013

Project Title/Client: HR Reporting Tool, Systematix India Pvt Ltd, India

Description: The HR Reporting Tool is a customized web based application that enables the HR person manage the employee cost (per day and per month), Fees, leave adjustment, holiday, apply leave, half day, pay day.

Roles & Responsibilities:

Managed website designing using CSS files as per master pages.

Involved in Database handling and designing and created DB backup service to take application backup.

Involved in testing, integration testing and deployment of the Test cases.

Experience in optimizing queries for performance by looking at Execution plan, creating INDEXES and triggers, Developed Stored Procedures, views using SQL SERVER 2005/2008.

Created resource file to manage application text.

Added Javascript validation to perform edit check on the data.

Used temp table to calculate encrypted and decrypted amount under SQL USP to show in user interface.

Extensively involved in developing components for Business and Data tier using C#, ADO.Net.

Environment: MS Access, C#3.0, ADO.NET, ASP.Net3.0/3.5, Javascript, IIS 6.0, AJAX, Jquery,XML, Microsoft Enterprise Library, base 64, SQL Server 2008 R2, Windows Server 2005/2008, Windows services.

Contact this candidate