C# Sql Server

Zafar Merchant

Katy, TX *****

Phone- 346-***-****

Email: *************@*****.***

CAREER PROFILE

** ***** ** ********** ** designing, development, implementation, testing and documentation for both internet and desktop applications.

Proven track record of building applications on time and within budget and strong work ethics, taking ownership of all duties and responsibilities and meeting management \ development skills.

Full stack experience in Object Oriented Programming (OOP ), in all phases of software analysis, design, development and deploying N - tier web applications, client / server

applications using ASP.NET 4.0/4.5, MVC 4/5, C#, WCF, Web Services, jQuery, JSON, SharePoint 2013, HTML5, CSS3, JavaScript, SQL Server 2012 and Oracle 10g, Visual Studio 2005/2008/2010/2012/2015, XML with intimate knowledge of the .NET Framework ( 2.0 / 3.5 / 4.0 / 4.5 )

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

Developed and maintained computer programs or software packages to handle specific jobs, user interfaces, business logic tier and database elements for custom applications.

Performed or direct revision, repair, or expansion of existing programs to increase operating efficiency or adapt to new requirements.

Experienced in reporting tools such as SSRS. Power BI, Oracle Application Express 3.1/3.2, and Active Reports 3.0 / 2.5.

Experience of working in a busy office\ stressful environment and strong interpersonal skills.

SKILL SET

Languages

C# 2012/2010/2008/2005, VB6/VB.Net/ VB 2012/2010/2008/2005, SQL, PL/SQL, T-SQL, HTML, CSS, XML, VB Script, JavaScript, JQuery

GUI

C# 2012/2010/2008/2005, Visual Basic .NET 2012/2010/2008/2005 ASP.NET 2012/2010/2008/2005/, Visual Studio 2012/2010/2008/2005/2003, Windows Forms, SQL Server Management Studio 2012/2010, TFS, Visual Source Safe, Active Reports 3 / 2, Crystal Reports 7.0/8.0, SSRS, SSIS, Power BI, Oracle Application Express 3.2/3.1, TOAD Oracle 11.6/ 10.6/ 9.5/ 9, SharePoint 2013

Frame Works

Net Framework 4.5 / 4.0 / 3.5 / 3.0 / 2.0 / 1.0, ADO.NET/ ADO

Entity Framework 6.0

Database

SQL Server 2012 / 2010 / 2008, Oracle 11.6 / 10g / 9,Access 2013 / 2010

Operating Systems

Windows 10 / 7 / 2008 / 2000, XP/ 2003

Web Servers

IIS 7.5 / 7.0 / 6.0 / 5.0 / 4.0

PROFESSIONAL EXPERIENCE

Commonwealth of Massachusetts

Executive Office of Administration and Finance, MA

Massachusetts Group Insurance Commission (MAGIC) System, Mar 2018 to July 2022

The Group Insurance Commission system provides and administers health insurance and other benefits to the Commonwealth's employees and retirees. The project uses MVC 5, C#, Entity Framework, JQuery, JavaScript, CSS, TFS, IIS 7.5 and SQL Server 2012 database as a backend

Dot Net Developer

Successfully utilized code-first approach to design the database in the .NET environment by using, C# in the ASP.Net MVC5 environment.

Wrote LINQ queries and lambda expressions to perform CRUD operations.

Used CSS3 and HTML5 to design fully responsive user interface.

Created robust Stored Procedures having custom error handling try-catch blocks with transactions for planned error handling rollbacks to recent commits and save points.

Used Power BI, MS Excel, and SSRS to create for applications and ad-hoc reports

Responsible for the coding of database objects as Stored Procedures, Stored Functions, and Triggers in SQL Server 2012.

Used SSIS for scheduled job creation.

Communicated with Users on a daily basis to improve the application and product support.

Attended weekly developers meeting.

MassBuys System, Mar 2014 to Feb 2018

MassBuys Data Entry System is a data repository application that allows users to view, update, delete, and swap booths. The application can also insert a row and column to accommodate new booths in a row. MassBuys Application is built using ASP.Net 4.0 and CSharp technology. Its user facing web form contains a Gridview control which is the main focus of the application. The gridview control displays all the rows and columns in an excel spreadsheet style. The user can visually locate and pick up any Booth number easily by just clicking it with a mouse. The application is housed on the server ‘OSD-APPS’ on IIS 7.0 The application uses the C# Classes, Ajax, JavaScript, CSS, TFS, IIS 7.5 and SQL Server 2010 database as a backend.

Dot Net Developer

Designed and developed MassBuys Data Entry System

Tested, code changed and retested ASP.Net code with CSharp classes

Heavily coded database objects as Views, Stored Procedures, Stored Functions, Triggers in SQL Server 2012

Interacted heavily with end-users, throughout the development life-cycle, including: requirements gathering, testing, implementation and production support

Performed updates and post documents to the OSD Intranet site using SharePoint 2013

Participated in MIS knowledge transfer activities

IT Support using BMC tracking software

Ran ad hoc SQL query reports against Commonwealth Information Warehouse on demand

Commonwealth of Massachusetts

Executive Office of Energy and Environmental Affairs, MA

Wetlands Information Redesign (WIRE) Enhancement Project Jan 2012 to Feb 2014

WIRE is a browser based application that allows internal DEP users to access the data from permitting, compliance, enforcement, and mitigation activities and including wetland change mapping at a particular geographic location. The project uses the C Sharp Classes, The Microsoft Enterprise Library Data Access Application Block, Infragistics Controls, Ajax, JavaScript, CSS, XML, Web Services, TFS, and Oracle 10g database as a backend

Application Developer

Developer for the Wetlands Information Redesign (WIRE) Enhancement Project

Tested, code changed and retested ASP.Net code with CSharp classes

Frequently used Infragistics controls including Ultra Web Grid and Microsoft Ajax Server Controls

Used Toad 9.1/9.5/10.5 frequently

Efficiently performed code change and coordinated with DBAs regarding Tables, Views, Stored Procedures, Triggers in Oracle 10g

Communicated with data managers and QA team on a daily basis

Mass Air / QA Tools July 2009 to Dec 2011

Air Quality Data Management Website under ENN4 Project is a public website to enable the sharing of real-time airs quality data and other air quality related information with the general public. It integrates with Quality Assurance tools to streamline the process of air quality data review performed by state staff. The hourly data feed from Air Monitors across MA is ported from internal DB to Website in XML format, which is also used to drive graphs and downloads. The project uses the VB.Net Classes, Web Forms, Windows Forms, Infragistics Controls, Ajax, XML, TFS, Web Services and Oracle 10g database

Application Developer

Developer for the external Mass Air (internet) and Air Monitoring QA tools (intranet) applications

Experience with the AQS Node Flow plugin process which is implemented with Air Quality QA tools

Maintained Reports using Active Reports 3.0 / 2.5.

Used third party tool toad 9.1/9.5.10.5 extensively

Coded efficiently database objects as Views, Stored Procedures, Stored Functions, Triggers under Oracle 10g Server environment

FMF Actor Maintenance Dec 2007 to Jun 2009

The FMF-Actor enhancement project will allow FMF to create and maintain Actors and associate them to Facilities. By linking successive Actors that own or control a Facility, FMF will accumulate the ownership history of the Facility. The project uses the VB.Net Classes, Infragistics Controls, Ajax, XML, Web Services, TFS, Oracle Forms, and Oracle 10g database.

Lead Developer

Developed FMF Actor Maintenance Application

Used Heavily client side development including JavaScripts, HTML, and CSS

Involved in AJAX technology used in the Infragistics Grid and with Microsoft Controls to build the project more productive

Heavy use of Oracle 10g database, Stored Procedures, Stored Functions, Triggers PL/SQL and SQL Plus

Extensive use of Infragistics Grid, Infragistics Ultra Web Tab and Edit Controls.

Maintained FMF Actor project to enhance performance, bug fixes, and unit testing

Developed excellent reports using Oracle Application Express 3.2 / 3.1

Business related issues were discussed on a periodic basis, any issues or problems were discussed and resolved efficiently

Air Quality Source Registration, Boston Mar 2007 to Nov 2007

An Internet Filing System which consists of Air Quality Source Registration (AQSR) Application that uses a bunch of forms that interacts with user to get information online. The application uses Adobe Acrobat PDF forms as the first layer of UI embedded into VB.Net Web Forms Asp.Net. The user information received through Adobe FDF toolkit, transformed into XML data, validated through VB.Net Classes, and saved back into Oracle database. DRTS a Windows Forms application used as an admin portal for the AQSR application developed in VB.Net and Oracle.

Application Developer

Heavy use of Oracle 10g database, stored procedures, PL/SQL and SQL Plus.

Used third party tool Toad 9.0/9.1/9.5 extensively

Responsible for the Air Quality Source Registration application including, GUI, client side validation through Adobe JavaScript, server side validation of data through VB classes as form engine, Oracle SQL and PL/SQL scripting to make sure the data saved and returned by the application is consistent with the business rules

Involved in the heavy bug fixing, code change and unit testing.

Interface with business personnel to discuss the status of bug fixing, application enhancements and resolved business related issues to accomplish the tasks on a periodic basis

Extensive use of Adobe Acrobat 5.0 professional as a Mass Dep requirement of online form filing

EDUCATION

Northeastern Illinois University, Chicago, IL May 2006

Bachelors in Computer Science

Contact this candidate