Sql Server .Net

Gurbachan Dhami

Ph. # 917-***-****/ 516-***-****

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

Professional Summary:

Over 17 years of .Net experience in design, development and implementation of different type of large-scale enterprise E-Commerce, Web and Client/Server projects involving complex business case function, data management and web integration with Object Oriented Programming.

Experience in all stages of Software Development Life Cycle (SDLC).

Developed Applications using .NET Framework 1.0/1.1/2.0/3.5/4.0/4.5.

Developed Layouts, Partial Layouts in ASP.NET MVC (Version 4, 5) using Action Filters, Razor Syntax.

IUnity Framework used for Dependency Injection and Inversion of Control.

Developed and utilized AngularJS, JQuery, CSS, ajaxwebtoolkit and JavaScript in ASP.NET and ASP.NET MVC.

Experience working with Windows Communication Foundation (WCF), WCF Data Service (OData), Web Services using with SOAP, .Net Remoting, ASP 2.0/3.5 (Active Server Pages), IIS7/6/5, ActiveX, COM+, COM, XML, XSL, COM, ASP, VBScript, Ajax, JQuery, Java script, Excel VBA, ActiveX objects, and executables. Have used MS Visio, MS Project, UML, ERWIN, Adobe Photoshop, Adobe Acrobat, Flash, MS Power Point tools to design interface of the software.

Developed Static and Drilled Down Reports in SSRS (Sql Server Reporting Services in Tablix and Matrix Forms) using Business Intelligence Developer Studio 2005/2008, SQL Data Tools 2010, Report Builder 2.0

Complete and thorough understanding of relational database design and performance.

Developed packages utilizing SSIS that transferred encrypted flat files via ftp and sftp.

Extensively worked on SQL Server database, involving writing numerous T-SQL scripts, stored procedures, SSIS, DTS services, views, triggers, troubleshoot Sql bottlenecks, testing, data access, data analysis.

Utilizing LINQ, Lambda Expressions with Entity Framework in middle tier code.

Involved in writing Sql statements, stored procedures, Packages and triggers (PL/SQL).

Experience with database access using RDO/DAO/ADO, Oracle objects for OLE and Excel Add-Ins.

Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.

Extensive experience in writing Scripts, Batches and Data Migration using DTS and Sql Server Integration Services in Sql Server 2012/2008/R2/2005. Also, worked on Developer 2000 reports/forms.

Good working knowledge of Microsoft Office (Word, Excel, Access), TFS, VSS and SVN. Operating systems used includes Windows 8/7/ XP/95, Windows NT. Used Agile/SCRUM methodology to solve software development aggressive deadlines with complex requirements.

Technical Skills:

Visual Studio 2013/2012/2010/2008/2005/2003, ASP.Net 4.5/4.0/3.5/2.0/1.1, MVC5/4, Razor, C#, Visual Basic.Net, XML, LINQ, Entity Framework 5/4, Reporting Services (SSRS), Crystal Reports.

Angular JS, Bootstrap, JavaScript, JQuery, HTML5, CSS3, AJAX, JSON, DHTML.

Sql Server 2012/2008/R2, 2008, 2005, 7.0, 6.5. MS Sql Server2010 Data Tools.

Oracle 11/8/7.x and Developer 2000. Third Party Controls: Telerik and Infragistic Controls.

Professional Experience:

DOHMH 03/17 – 12/17 Senior .Net Full Stack Developer

The new Online Electronic Requisition Form (PHL E-Orders) will allow hospitals, private clinics, various DOHMH bureaus and other city agencies to order routine laboratory and new outbreak tests. These test orders will electronically transmitted to the Public health Laboratory LIMS system (STARLIMS). The application will allow end users to track the orders history they send to PHL and receive acknowledgments, results and result history.

Responsibilities:

Have implemented responsive design pages with Asp.Net MVC, C#, Bootstrap, HTML5, CSS, Java script, and jQuery etc. for different devices.

Have used Entity Framework 5.0 an Object-relational mapping (ORM) database first approach to generate model classes and add validation in partial classes.

Creating complex security model with Authentication and Authorization action filters.

Implemented agile best practices, Unit Testing, CI Testing, Test Automation, Pair Programming, etc.

Collaborated on infrastructure and release deployments/instructions in Scrum/Agile environment.

Have demonstrated and implemented complex system functionality for final approval of system tasks for deployment purposes. TFS is used for version control of C# sources code and table creation scripts..

Environment: C#, Asp.net MVC, RAZOR, WEB API, JSON, Bootstrap, HTML5, CSS3, Java Script, JQuery, Visual Studio 2013, Sql Server 2012, TFS, Scrum/Agile.

OUTFRONT Media Inc. 6/16 – 10/16

Senior .Net Full Stack Developer

Involved to enhance and support Contract and Inventory Management system which contains the Contract information and available inventory materials like diverse portfolio of billboard, transit, digital displays, and posters for distinct offering of prime assets impacting select markets reaching mass audiences for advertisement.

Responsibilities:

Have implemented responsive design pages with Angular JS, Bootstrap, HTML5 and CSS for different devices.

Modified and wrote system’s code in AngularJS, Asp.Net MVC, C#, Java script, jQuery, Html and Css to add or improve functionality, scalability and performance.

Wrote and modified complex procedures, TVP’s, functions in Sql server to add functionality and fixed bugs.

Implemented agile best practices, Unit Testing, CI Testing, Test Automation, Pair Programming, etc.

Collaborated on infrastructure and release deployments/instructions in Scrum/Agile environment.

Have demonstrated and implemented complex system functionality for final approval of system tasks for deployment purposes. TFS is used for version control of C# sources code and procedures.

Environment: AngularJS, Bootstrap, HTML5, CSS3, Java Script, JQuery, C#, Asp.net MVC, RAZOR, WEB API, JSON, Visual Studio 2012, Sql Server 2012, TFS, Scrum/Agile.

Geller & Company 8/15 – 05/16

Senior .Net Full Stack Developer

Developed Unified Contact system which consolidates contacts from three major different systems. It facilities to promote master contacts and link to child contacts from different systems to show their Events, Gifts and Requests information etc. for non-profit foundation and developed using AngularJS, C#, MVC Razor, Web Api, Entity Framework.

Create ETL process with multiple SSIS packages to generate encrypt Gift Grant Payment file to put on sftp server from foundation to Geller, decrypt and process, approve payments and send back the check list for successfully paid payment checks and new vendor file added to system through sftp. SSRS is used for complex reports.

Responsibilities:

Have used Angular JS, Bootstrap, HTML5 and CSS to create responsive design web application.

Developed Layouts, Partial Layouts in ASP.NET MVC (Version 5) using Razor Syntax.

Developed Model Classes, Action filters, Controllers etc. using C#, MVC5. Used Dependency Injection.

Developed Web API to interact MVC application transaction to Sql database using C# and JQuery.

Created an object-relational mapping (ORM) in Entity Framework 5.0 connect to SQL Server tables.

Wrote complex stored procedures, functions, trigger, TVPs to update multiple contacts information.

Developed complex SSIS packages which used Script Task, Split Task, File System Task, SMTP Task, Sequence Task etc. to generate Grant Payment File and placed encrypted file to SFTP server and download to database after decrypt and process.

Environment: AngularJS, Bootstrap, HTML5, CSS3, C#, MVC5.0, Web Api, JSON, jQuery, HTML5, Razor, Sql server2012, Sql server2010 Data Tools.

Univision Communications, Inc. 10/14 - 03/15

Senior .Net Full Stack Developer

SIO system managed generating revenue thru advertisements on different media platforms.

System facilities of creating orders, tracking impressions and recognizing revenue thru different modules such as IO creation & its approval, sending data to media server, tracking impression data from servers and finance.

Responsibilities:

Modified system’s code to add or improve functionality, scalability and performance for Asp.Net, C#, Java script, jQuery, Html5 and CSS3.

Wrote and modified packages, stored procedures and functions in Oracle to add functionality and fixed bugs.

Had Unit Testing, CI Testing, Test Automation, Pair Programming etc. in agile best practices environment.

Collaborated on infrastructure and release deployments/instructions in Scrum/Agile environment.

Have demonstrated system functionality tasks for deployment purpose to users and management approval.

SVN is used for version control of sources code, oracle packages and procedures.

Environment: C#, Asp.net, Java Script, JQuery, HTML5, CSS3, VS 2010, TFS, Oracle11.0, SVN, Scrum/Agile.

ASCAP 01/14 - 10/14

Software Engineer BI – Business Intelligence

BI – Business Intelligence

Involved to develop Business Intelligence system which gathers organization’s historical and current statistical data to analyze company’s revenue, profits and cost per quarter and year in in Scrum Agile environment.

The system helps management to make short or long term optimal decisions to reach the company’s strategic goals. SOLR is used to get fast and dynamic data. Also developed packages and procedures to access Oracle database.

Involved in implementing security for ASCAP Licensing Sales Force system.

Developed system to do bulk insert and update operational data based on selected data massage from different sources type in AngularJS, Asp.net, MVC, Razor, C#, WEB API, Java script, jQuery, sql server 2008/R2 and used Telerik controls.

Responsibilities:

Created custom, stored procedures and functions, SSIS Packages to build high performance data integration solutions, including extraction, transformation data in Oracle and Sql Server.

Used ASP.Net MVC, Razor, WEB API, WCF REST and Java Script with Telerik controls for building dynamic Web pages.

Created class library to validate data based on DM Type before run complex process to make database updates.

Designed Class Diagrams, Object Diagrams, and Sequence Diagrams using UML (Visio).

Used Entity Framework 5.0 an Object-relational mapping (ORM) was used for SQL Server database operations.

TFS was used for version control, task assignment and time entry for scrum/agile development.

Environment: Asp.Net, MVC 5, Razor, C#, AngularJS, Java Script, JQuery, Ajax, SOLR, WCF, WEB API, JSON, HTML5, VS 2013, Oracle10, SQL 2008/R2, Entity Framework, TFS, Scrum Agile, Telerik controls.

American Arbitration Association 11/13 - 12/13

Software Engineer

Responsibilities:

Developed system which creates indexes for the large pdf document based on different document types and create xml file for the indexes and document names.

Environment: C#, Oracle11, XML and Visual Studio 2012.

AE Networks 11/12 - 09/13

Senior .Net Developer

Developed Unified Admin Contact system which consolidates user access for multiples system to centralize repository in Scrum Agile environment using third party Telerik controls.

It facilitates admin to give different type of access level to Channel Partners, Sales Sites and International Database system users in one place.

System generates encrypt password and forces user to change his password for certain period of the time.

Developed system in AngularJS, Asp.Net MVC4, Razor, C#, Entity Framework, LINQ, WEB API and SQL Server 2008/R2.

Developed a reporting system that generates financial reports for upper management to review sales and profit for different channels and deals for different countries with C# and Oracle10.

Wrote WCF Service, Web API and WCF REST to update metadata in International database whenever assets and their contents are uploaded to MPX System through watch folder.

Responsibilities:

Imported and converted data from different tables to centralize SQL Server 2008/R2 database with SSIS Packages.

Created complex stored procedures and packages to extract data from SQL Server Database and have created module to search all the information. TFS tool was used for source codes s for version controls of systems.

Created an object-relational mapping (ORM) in Entity Framework 4.0 to SQL Server tables.

Created WCF Data Service (OData), WCF REST, WEB API to manipulate and expose data through EF to application.

Designed and developed web application with MVC 4 framework, Razor and C#, WEB API and Telerik controls.

Implemented Agile best practices, such as Unit Testing, CI, Automation Deployments, Test Automation.

Environment: ASP.Net, MVC 4, Razor, C#, AngularJS JQuery, Ajax, Java Script, WCF REST, WEB API, Web Services, JSON, XML, LINQ, Entity Framework, SQL Server 20008/R2, Oracle10, VS 2010/2012, TFS, Scrum/Agile, Telerik controls.

Guild of the Blind 02/12 - 9/12

Software Engineer

System has allowed broad range information of Clinical Services that address medical, vision, and rehabilitation needs in order to help maintain health and wellness and prevent illness in people who are blind, visually impaired and often multi-disabled.

System allows the Guild members to provide the information of Behavioral Health includes a psychiatric clinic, a mental health day treatment program and a developmental disabilities day treatment program.

Responsibilities:

Created relational database tables for user’s contact information in SQL Server 2008/R2.

Imported data through stored procedures from different tables to relational database tables

Created screens with Asp.Net and C# to add and edit contact information.

Modified system’s code to improve scalability and performance.

Environment: ASP.Net, C#, JQuery, Ajax, XML, LINQ, Entity Framework, WCF, SQL Server 2008/R2.

Sandata Technologies 10/11 - 02/12

Senior .Net Developer/Programmer/Analyst:

System has allowed medical companies to make scheduling, events and billing for patient’s services like charts, appointments and other services etc. by staff.

This System verifies billing claims for insurance companies to approved or denied for payments to prevent fraud for Medicaid and Medicare the clients.

Responsibilities:

Modified and wrote new stored procedures to improve performance for system.

Modified system’s code to improve scalability and performance.

Environment: ASP.Net, C#, Ajax, XML, DHTML, SQL Server 2008/R2, Visual Studio.Net, WCF.

NYC Department of Education 4/03 - 09/11

Senior .Net Developer/Programmer/Analyst:

Elevator Inspection System

Developed an Elevator System for the inspectors to print general inspection Local Law (10/81) and condition monitoring inspection forms.

System facilitates the inspectors to store inspection results in it.

It allows admin to add, edit and dismantle old elevators and their devices.

It also provides details about valid contractors, their contracts and their performance.

System has been designed and developed in C# and Asp.net in Visual studio 2008.

DSF Change Reset Password

Developed system to change and reset the password for all the centralize users based on their security questions with C#3.5, ASP.Net and SQL Server 2008.

It facilities administrator to reset centralize user’s password based on their secret questions for who have locked out their application(s) when they are unsuccessfully to change and reset their password based on their questions.

DSFCMS/ DSF Website System (http://www.opt-osfns.org/)

Convert and completed DSFCMS/DSF system to ASP.Net 3.5 from ASP.Net1.1 that allows entering and editing content information for DSF website.

Contract Finder

Converted and enhanced Contract Finder system to ASP.Net 3.5 from VB6.

They can view the School information and contracts. System has other module for admin to facilitate upload data, contract files, specification and images.

Playground Survey

Playground survey application collects data from custodians about the personnel cost to maintain the schoolyard for playground program along with other information of qualify schools.

Elevator Survey

Developed Elevator Inspection Survey Application for custodians to enter elevator inspection survey data for their respective schools on a monthly basis.

Created an application for the help desk to reset centralize custodian password.

Problem Runs Reported

System allows vendors report any issues with current routes.

Currently, the system permits borough supervisors to review and resolve problems regarding those routes.

In addition, a reporting engine was implemented enabling vendors and supervisors to review specific information depending on a date, route or issue reported.

Project Management System

This is an intranet application built using ASP.Net, ADO.Net, and Visual Studio.Net.

This gives the employees/consultants ability to enter the daily tasks for their projects.

Content Management System

The content of the Portal website is being maintained dynamically by the system.

This Portal Page gives the overview of different departments in Department of Education.

Parking Permits System

The system captures all the required information and gives the ability for Principals/Department Head to approve or denied Permit.

The permits are printed using Crystal Reports which is a Desktop Windows Application.

Window application has capability to search permits by school code, last name and office code.

PSAL Time Charges

Converted system from VB6 to VB.net. The system is being used by Coaches to enter hours for each sport bi-weekly.

The payroll department can approve the hours entered by coaches to generate the pay stub. It also allows admin to increase hours for coaches of different required games and request by schools.

Responsibilities:

Designed Class Diagrams, Object Diagrams, and Sequence Diagrams using UML (Visio).

Designed user interface screens with ASP.Net4.0/3.5/2.0, VB.Net, and ADO.Net.

Have worked with MS Visio, MS Project, UML, ERWIN, Adobe Photoshop, Adobe Acrobat, Flash, MS PowerPoint Tools to design software.

Designed the databases from scratch using SQL Server 2008/2005.

Created custom SSIS Packages to build high performance data integration solutions, including extraction, transformation Sql data.

Created Triggers, complex stored procedures and packages to extract data from SQL Server and Oracle Database and have created module to search all the information.

Created WCF and XML Web Services so that the data can be accessed by different vendors or other organization in DOE.

Web Pages are developed using Server Controls, List view, Grid view, Data grid, Validator, Data List, List box, Repeater Controls and created Interfaces to hide the complexity of classes.

Implemented AJAX using AJAX Extensions and AJAX Controls such as Update Panel, Update Progress to make web pages more dynamic and interactive.

Window Forms are developed using advanced windows controls such as Tabbed, Data Grid, Tree View, List View controls.

Used thirty party infragistic controls for visual appearances and validation.

Used Grid View Controls, Object Data Source Controls, and Net Advantage Controls such as Web Spell Checker Controls, Web Panel, Web Date Chooser, etc. to develop web pages.

Created custom web control and user control to reduce the redundancy of code.

Converted MS-Access Application to Windows VB.Net Application.

Converted actuates report to Crystal Report9.0 and integrates with .net.

Used ASP Objects, XHTML, DHTML, and Java Script for building dynamic web pages.

Wrote module in Sql Server to generate emails for survey application.

Environment: ASP.Net4.0./3.5, C#,VB.Net, IIS 7/0.6.0,C#, LINQ, Entity Framework, ADO.NET, WCF, Web Services, XML, XSLT, SQL Server20008/2005, Oracle9, Visual Studio 2010/2008/2005, Crystal Reports, JavaScript, HTML, ASP2.0, Visual Basic 6.0, Ajax JavaScript, UML(Visio), XML Web Services, Business Objects, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), HTML, infragistic, Adobe Photoshop, Adobe Acrobat, Flash, MS PowerPoint, Window 2000/XP/Vista.

Newcom System Inc. 4/02 - 10/02

Software Engineer

Responsibilities:

Involved in developing a prototype, created Storefront, shopping carts and designed user interface screens with ASP.Net, VB.Net, and ADO.Net.

Have used VB.net to Manipulated and extended the .NET Base Class Libraries, Common Type System, and User Defined Types to effectively create classes, interfaces, and loosely coupled events that are functionally efficient and appropriate for given programming scenarios.

Exploited enterprise Web strategies to address issues involved in creating Web content using ASP .NET Web forms and server controls to display dynamic data obtained through the use of Microsoft ADO.NET.

Designed and Implemented database schema; created physical database objects like tables, views, store procedures, functions, triggers to store the data and implement business rules.

Utilized ADO.net and its new feature of disconnected data source using DataAdapater, dataset and SQLDataReader to manipulate data with high scalability and efficiency.

Created user controls and components to enhance scalability and best performance with VB.Net. Analyzed and decomposed various aspects of HTML and scripting procedures into component.

Environment: ASP.Net/IIS, VB.Net, ADO.Net, DHTML, SQL Server 2000, Visual Studio.Net,

Blue Hypermedia 7/00 - 12/01

Senior Web Developer/Programmer/Analyst:

Reviewed, redesigned and developed a sophisticated, reliable, informative Intranet application to have company-related information like projects, company policies, employee profile, schedule meetings, HR activities, company newsletters, FAQS etc with ASP.Net and VB.Net.

Have utilized technology such as polymorphism, inheritance, overloaded and virtual methods of VB.Net to develop efficient, powerful, scalable web-based application and services.

Wrote a COM object in VB.Net to generate XML files from the database.

(Pfizer Intranet)

Developed Intranet web applications for client such as Pfizer with ASP and MS SQL Server.

It displays news, schedule meetings and shares information about products, sales strategies and group specific topics like market studies budgets etc.

Developed online tools that provide information about tools to promote products to specific target Group.

Responsibilities:

Created XSL and ASP.Net pages to present the information in the XML files.

Have created XML Schema and DTD to validate XML documents. Developed middle tier components for better performance using VB.Net.

Developed, deployed User Controls and Components to optimize the performance of system with VB.Net. Have Utilized ADO.net to its new feature of disconnected data source using DataAdapater, dataset and SQLDataReader to manipulate data with high efficiency.

Build a Search Engine for Intranet to facilitate the users to get a particular keyword and specific employee information ASP.Net. Have configured and deployed virtual directory in IIS Administrator.

Planned and designed web pages in ASP.Net, wrote stored procedures to perform logical business transactions for update, delete, view, search for unread and read, all resumes or search by departments.

Created a functional specification and project plan. Planned, designed and implemented a SQL server 2000 database. Created Store procedures, functions, Indexes and Views in order to implement business rules.

Developed dynamic web pages and presentation layer in ASP 3.0. Had regular meeting with the project members to discuss various issues associated with the project.

Created custom web control and user control to reduce the redundancy of code.

Designed and Implemented database schema; created database from scratch.

Environment: ASP.Net, C#, IIS, VB.Net, ADO.Net, DHTML, HTML, Java Script, XML, XSLT, MS SQL Server 2000, Windows 2000/NT, Visual Studio.Net, ASP3.0, VB Script, VB6.0, ActiveX, Com, Crystal Report 8.0, Interdev 6.0, Cold Fusion 4.5/4.0, HTML, CF Script, Oracle 8.1.5

Computer Associates International 3/98 - 6/00

Programmer/Analyst:

This application is mainly used for adding new clients or updating the existing client information, purchases Computer Associate’s products.

This Intranet application also facilitates the user to search client and product information as well as the name of the employee, who enters or updates above information.

Developed report interface to print all reports with crystal reports.

Automation and Relationship Management System:

Avenue is a sales force (ARMS) system that enables members of an organization to manage information about companies, people, products, appointments and other elements of business.

Avenue uses a database as the repository of the information collected by the system.

Avenue is capable of distributing data to laptop users away from an office and to Local Area Networks (LANs) in locations away from the central database.

Inventory Management and Sales Ordering System:

The system was designed to maintain stock-levels of new and existing items, enter sales orders for Tele-marketing department, and receive orders over communication lines.

The system was developed using VB5.0 as front-end and ORACLE as backend. Implemented VB features like RDO, OLE automation and used OCX like MS Comm., Crystal Report, and also File I/O controls.

Responsibilities:

Involved in design dynamic web pages with ASP2.0.

Involved in the design of database in MS SQL Server7.0 and created relationship and indexes.

Created ActiveX server (COM). Retrieved data using ADO and its objects. Created Data entry

GUI forms using Visual Basic 6.0. Created physical database objects like Tables, Store procedures, functions, Indexes, Views and Synonyms in order to implement business rules.

Migrated data from data General into Oracle database using FTP and SQL loader.

Environment: ASP2.0, HTML, VB Script, Java Script, Visual Basic6.0, Excel/VBA, Com, ActiveX, SQL Server7.0/6.5, Oracle8.i, WinNT, and Crystal Reports Info7.0, Interdev.

Education & Certifications:

MS in Economics

BS in Mathematics/ Economics

Diploma in ASP.Net, VB.Net, C#, ADO.Net, Crystal Report.Net.

Diploma in Client/Server Technology and MS SQL Server.

Diploma in Oracle Database Administration from Columbia University.

Contact this candidate