Software Development Sql Server

Nehal H Thakkar 732-***-****

* ******* **., ****** ** 08820 *******.***@*****.***

VISA STATUS: Permanent Resident (Green Card)

Nehal Thakkar is

Bachelor’s in Computer Science Sardar Patel University, India December 2000 Master’s in Information Science Sardar Patel University, India December 2002 Master’s in Computer Engineering Fairleigh Dickinson University, Teaneck, New Jersey 07666

July 2005

Professional Summary

10+ years of software development experience and involvement in various phases of Software Development Life Cycle (SDLC) using Microsoft .NET Technologies.

Analysis, Design, Development, Implementation and Integration, Testing and Deployment of several web applications along with POC creation deployment on premise and/or Azure cloud service.

Experience in development of 3-Tier/N-Tier Architecture implementing OOP and SOLID principles using Waterfall model, onion architecture, micro-service architecture and SOA using Agile practices.

User Interface: MVC.Net, HTML, ASP.Net, Win Forms

Script and Framework: .Net 1.0 to 4.7, .Net Core 2.0, ADO.NET, Entity Framework, EF Core, Kendo UI, CSS, Bootstrap, JavaScript, jQuery, Typescript, React JS, LESS.

Web Services: WebAPI2, WCF, Windows Services, REST Services.

Database: SQL Server (7.0 ~ 2016), Oracle (7i ~12c), MS Access, FoxPro.

Developer and Reporting Tools: Visual Studio 2002(Professional, Ultimate) to 2022(Professional), SQL Server Management studio, SQL Developer for Oracle, Power BI

Languages: C#, C, C++, VB, VB.Net, PASCAL, COBOL

Security and Protocol: OAuth2, Authentication (Windows-based, Forms-based) and Authorization

(Authorizing Users and Roles). Http, HTTPS, TCP, MSMQ, AMQP.

Version Control: Git, TFS (Team Foundation Server) with VS2013/VS2010, Vault Client 2.1.2, and VSS 6.0. Worked as TFS administrator and manage administration.

Roles: Full Stack Developer, Software Architect, Sr. .Net developer, technical lead, team coordinator.

- Ability to write clear, well-documented, well-commented and efficient code for web development.

- Ability to be creative and to take self-initiatives to manage multiple projects in parallel during time critical situations.

Nehal H Thakkar 732-***-****

5 Marcols Ct., Edison NJ 08820 *******.***@*****.*** VISA STATUS: Permanent Resident (Green Card)

PSEG, South Plainfield, NJ (September 2017 to Current Full Stack Developer] Mutual Aid Job Tracker

An application which identifies, maintain and create the job listing parameter during various storm events. It allows application user to create new storm event by adding future days to the same storm events along with task force management.

Various user roles are responsible for maintaining job listing parameter such as Administrator, construction leads, dispatcher and read-only users.

• Architect role

Created software architecture proposal with different alternative along with process associated to retrieve information from GIS oracle server and having all information in to SQL Server back- end for further process using linked server.

Converted Mutual Aid processes which were ms-excel based to software by working directly with client and involved in analysis, requirement gathering and designing.

• Service modules

Developed and coded Dashboard, Jobs listing, Storm, Report and ADMIN module which includes master table records, users and their multiple roles and permissions associated to them, generating new task forces, crews, job status based on inputs provided by the client.

• UI layer

MVC5 with HTML5, jQuery, JavaScript, Kendo UI framework, CSS3.

Implemented kendo grid, perform client-side validation, coded features like copy command, display statistics using kendo pivot grid.

For Dropdown with multiple selections of items, provided dropdown extensions and general extensions for converting data table or data row in to list of items using generics.

• Business layer

Using edmx and model validation that is being performed using partial classes which includes data annotation assembly with metadata type of with Regex other validation attributes

• Data Access layer

Created and coded repository to handle all CRUD operations using entity framework to interact directly with SQL server database.

Only one EXECUTE method will manage all CRUD operations by providing entity state as parameter to function.

• Agile practices

Participated in Scrum while user stories creation, check-in policy and coding standards.

• Publish code on AWS cloud server in Development, staging and Production environment. Environment: Visual Studio 2017/2022, Git Repositories, .Net Framework 4.6.1, C#.NET, MVC 5.0, Kendo UI v2018.2.620, jQuery 1.11.1, IIS 8.0, OOPS (Singleton and Repository Design Pattern), Entity Framework 6.0, CSS 3, HTML 5, SQL Server 13.0.16000.28 for database, ORACLE 12c for data retrieval, SQL Developer Version 17.3.1.279

Nehal H Thakkar 732-***-****

5 Marcols Ct., Edison NJ 08820 *******.***@*****.*** VISA STATUS: Permanent Resident (Green Card)

Positive Discipline Log – PD Log

With PD Log application, MAST employees (Managers and above) can create and manages an event for all Bargaining Unit/Union (BU/UN) employees restricting the access to BU/UN employees. Event creation can be positive or negative and based on those events BU/UN employee performance is being reviewed at the end of every year.

Various user roles such as Super Administrator, Administrator, and Clerk users are responsible for maintaining user parameters (search, create, update, grant/revoke access) and event listing parameter

(search, create, update and delete events) are manage by all MAST employees irrespective of roles.

• Architect role

Created workflow for client side (including main menu, sub-menus, layout pages, and forms) and server-side (controllers, objects, repositories, micro-services) application architecture.

Converted application that was MS Access based to .Net website by working directly with client by involving in analysis, requirement gathering, design and development.

Implemented SOLID principles and POCO database first and repositories using EF6. Creation of user using micro-service architecture with the usage of REST API.

Service modules

Developed and coded Dashboard, Events and Lookups, Reports, Business Admin and System Admin module which includes master table records, users, events and their multiple roles and permissions associated to them.

For storing files in binary format convert content in to byte array for storage in database.

• UI layer

MVC5 with HTML5, jQuery, JavaScript, CSS3, bootstrap.

Implemented bubbling of event using normal grid inside dropdown control.

• Business layer

Using .edmx and model validation that is being performed using partial classes including other validation attributes using Regex.

Perform necessary client-side validation while uploading files.

• Data Access layer

Created and coded repository to handle all CRUD operations using entity framework to interact directly with SQL server database. Implemented Singleton Repository and Unit of Work pattern.

Publish code on AWS cloud server in Development, staging and Production environment. Environment: Visual Studio 2022, Git Repositories, .Net Framework 4.6.1, C#.NET, MVC 5.0, jQuery 1.11.1, IIS 8.0, ASP.NET Core 2.0, Entity Framework 6.0, CSS 3, HTML 5, SQL Server 13.0.16000.28 Roster and Vehicle Management System – RVMS

RVMS application manages resources on their construction site by creating daily ROSTER (a list or plan showing turns of duty) which includes CREWS(has crew member and comments), VEHICLES(having detail parameters), EXCEPTIONS(such as holiday, sick leave) and route sheet based on CREWS, VEHICLES and EXCEPTIONS.

RVMS also expands with MATERIAL REQUISITION & ORDERING along with cart to order from warehouse. Nehal H Thakkar 732-***-****

5 Marcols Ct., Edison NJ 08820 *******.***@*****.*** VISA STATUS: Permanent Resident (Green Card)

• Architect role

Created workflow, application architecture and converted application that was paper and/or ms-excel based to website by working directly with client by involving in analysis, requirement gathering, design, development, testing & deployment.

Develop base framework and implemented OOPS concept with ADO.NET using Oracle connection by configuring oracle 12c 64-bit driver.

• Service modules

Developed and coded modules and menus like Dashboard, Resources, Roster, Vehicles, Vacation, Material and Requisition along with ADMIN module which includes master table records, users multiple roles and permissions associated to them while generating Roster.

PDF generation for Roster

• UI layer

MVC5 with HTML5, jQuery, JavaScript, CSS3, bootstrap.

Coded paging control as partial view and implemented in necessary listing.

Client-side scripting using JavaScript and jQuery that implemented features like dropdown with multiple select and validation scripts for roster, resources, materials and vehicles modules.

Business layer

Implemented using encapsulation and abstraction.

Perform runtime polymorphism using dependency injection.

Overridden base dll (system.web.MVC) for creating extension methods (such as

@Html.ActionLink and provide role parameters in extension methods).

Data Access layer

Designed database data dictionary, tables, created stored procedures, triggers and sequences.

Created packages and call complex stored procedures

Created database Utility using Repository Pattern, used Singleton Pattern for connection, other Helper classes, custom attributes and pagination control.

Publish code on AWS cloud server in Development, staging and Production environment.

Make sure with the testing team and client that system is up & running with needed functionalities. Environment: Visual Studio 2017, Git Repositories, .Net Framework 4.6.1, C#.NET, MVC 5.0, jQuery 1.11.1, OOPS (Singleton and Repository Design Pattern), Kendo UI v2018.2.620 for Generating list of PDF, CSS 3, HTML 5, ORACLE 12c, SQL Developer Version 17.3.1.279 Web Team Corp., Somerset, NJ (January 2013 – September 2017) HRTeamPlus v2.5 – Automation in staffing industry (Human Resource Team Plus - version 2.5) now referred as SOURCEPROS v3.0. https://sourcepros.com/ A web-based application for HR Management having exciting features such as mobility in job search for Candidates, Monster Integration, Career Builder API Integration and facilities to make the recruitment cycle (prospective, submission, interview, offer received and offer accepted) for the staffing industry more efficient in a team environment.

SOURCEPROS v3.0 is a full featured application for small to mid-sized staffing companies and their recruiters can use as a hosted service.

Nehal H Thakkar 732-***-****

5 Marcols Ct., Edison NJ 08820 *******.***@*****.*** VISA STATUS: Permanent Resident (Green Card)

• Project Lead and Senior Developer, TFS Admin

Created whole project from scratch, workflow, and converted ASP.NET HRTeamPlus v2.5 application to SOURCEPROS v3.0 along with 5 team members including 1 business analyst, 2 other developers and 1 database administrator.

Built application platform foundation to support migration from client-server product lines to enterprise architectures and services.

Implemented N-Tier architecture, develop base framework and involved in full SDLC.

Install, configure, administer and manage agile process using TFS 2013 with Visual Studio 2012 includes creating default collection on TFS, giving user access, configuring TFS web access and IIS 7.0 administration.

Also, as Web Team Corporation migrated their repository from VSS to TFS, were involved in with all team members.

• Service modules

SOURCEPROS v 3.0 has several modules like Dashboard, Configuration, Candidate and Requirements, HR, Reports, Client and Vendor, Emails, Checklist, Extension List and Admin. Provided input as needed inclusive of all modules design and development.

Client would get access to the portal with all its facilities such as Requisition Tracking, Marketing Tracking, Centralized Email Communication, Response distribution and management, Submission and Interview Management, employee life cycle management, Daily Performance and Monitoring Reports as well as the database of unlimited of resumes and candidate profile

• UI layer (Client Presentation Layer – Hosted on IIS)

MVC3.0 with HTML5, jQuery, JavaScript, CSS3 with C# coding, Angular JS 1.6.4.

Business layer (Façade layer exposes business operations)

Handles and encapsulates all of business domains and logic; also called domain layer comprises of WCF Host application having 2-tier architecture configuration

Persistence layer (Made decouple business layer from EF)

Created Entity Framework lib, persistence lib and optional WCF data service.

Migrated data of HRTeamPlus v2.5 (.NET Framework 2.0) to SOURCEPROS 3.0 (.NET Framework 4.0, MVC 3.0, EF4.0) using SQL Scripts.

Wrote stored procedure that use full-text search and build catalogs for search functionality.

Admin module developed using NET data objects and ADO.NET Separately. Environment: Visual Studio 2013, TFS 2013, .Net Framework 4.0/4.5, C#.NET, MVC 3.0, SQL Server 2014, jQuery, Angular JS 1.0.

Automation Anywhere (February 2012 – December 2012) Automation Anywhere (AA) and Testing Anywhere (TA) – Process In-vision module A windows based application that support commands like Application Integration, Clipboard, Comment, Database, Delay/Wait, Email Automation, Error Handling, Excel, Files/Folders, FTP/SFTP, If/Else, Image Recognition, Insert Keystrokes, Insert Mouse Click, Insert Mouse Move, Internet Connection, Launch Website, Log to File, Loop, Manage Windows Control, Message Box, Open Program/File, Pause, PDF Integration, Play sound, Printers, Prompt, Read From CSV/Text, Run Script, Run Task, Screen Capture, Nehal H Thakkar 732-***-****

5 Marcols Ct., Edison NJ 08820 *******.***@*****.*** VISA STATUS: Permanent Resident (Green Card)

Send Email, Services, SNMP, Stop task, string operation, system, Terminal Emulator, Variable operation, Web Recorder, Web service, Windows Action, XML.

Involve in analysis and requirement gathering for process in vision module.

• Senior Software Engineer

Created PDF Integration Command, Export to PDF, and Export to PPT functionality and involve in Export module for creating Export to Video functionality for Process in Vision (PI) module of AA Project.

Make usage of threading for asynchronous calls and fix certain bugs and issue for TA project.

Resolve critical issues, validated modules and functionality in time frame for Process in Vision

(PI) and AA project as well.

Provided statuses on regular basis to the project lead and team manager. Environment: Visual Studio 2010, TFS, XML file as database. TekNest Inc - Farmington Hills, MI (September 2010 – December 2011) United Technology Corporation Fire & Security (UTCFS), Sarasota/Bradenton, FL Eddie – An E-Commerce app that allow user to login as a part of their application domain (EST, DUKANE, VIGILENT and SIGNALLING) and based on roles and permissions, user is associated to one company for multiple business partners which include one price lists further associate to multiple price book for different products and its sub-categories.

ESB (BizTalk 2010) - will interact with databases such as ORACLE 11g, SQL Server 2008, and BAAN ERP. Old system that works on Cold Fusion that needs to replace with new .NET Technologies. Involve in analysis, gathering requirements with business analyst and client/customer.

• Application Architect and .NET Lead

Created database, Flow diagram, business process work flow based on requirement gathering which involves user security, Company, Business Partners, Price List, Price Books, Products and its sub-categories.

Created orchestration, publish schema as WCF service using BizTalk WCF wizard tool while working on WsBasicHttp binding with WCF-custom adapter to call stored procedure.

Implemented Role-based security, run scrum master as a part of team for daily status and new user stories.

• UI layer (Client Presentation Layer – Hosted on IIS)

MVC3.0 with HTML5, jQuery, JavaScript

Created UML diagram using MS Visio and workflow with the help of iWay. Environment: Visual Studio 2010, TFS, MVC 3.0(RAZOR), jQuery, SQL Server 2008, MS Visio 2010, BizTalk 2010.

Nehal H Thakkar 732-***-****

5 Marcols Ct., Edison NJ 08820 *******.***@*****.*** VISA STATUS: Permanent Resident (Green Card)

Mylan Labs, Morgantown, WV

Mylan Myportfolio app – provides a search engine for Mylan pharmaceuticals products in different countries such as Australia, Belgium, US, Japan, etc. Products includes medicines, liquid, drops, powder, etc and other drugs/chemicals. Search engine allows us to search for the content, availability and manufacturing information for those drugs/chemicals.

• Senior .NET Application Developer

Created user control to replace the form view and was responsible for UI development.

UI layer

jQuery, JavaScript, CSS

Created all modal dialogs (Action/Delete/Multi modal) with their manipulation of properties and events association.

Provided validation on Modals using registering JavaScript and AjaxHelper class.

Make usage of __dopostback for Asynchronous call with client Id and unique Id association.

Event and error handling with modal dialogs while working in code-behind of Form view.

• Business layer

Used LINQ to SQL in entity framework.

Had agile discussion with team lead and other team members for refactoring the code. Environment: Visual Studio .NET 2010, VB.Net, ASP.NET, IIS 6.0, Java script, jQuery, Sql Server 2008, TFS, PL/SQL, Entity Framework, LINQ

American Family (AFLAC), Columbus, GA

RPM – Report Process Management provides reports for production center, leader’s center, co- ordinate center, etc. it provides weekly, biweekly, monthly, quarterly and annual report for Health insurance customer.

For users, it has dashboard, Reports, Education and Reference module. Main module is Report module includes production center, leader’s center, and coordinate center to provide report for all health insurance customers.

• Senior Application Developer

Created new panel for the report for reference module using RPM architecture and framework using MVC 1.0(nerd dinner) architecture.

Provided links using jQuery and modified css properties using jQuery with required validations.

Make usage of Request.QueryString and Session variables for passing parameter while processing the report from one report module to another.

Wrote KeepAlive and KeepAliveUpdate methods using jQuery and other validations by usage of

$. Ajax asynchronous calling while keeping session alive and update.

Worked on Dashboard using DataReader, Dataset and DataGrid control. Environment: Visual Studio .NET 2010, C#.Net, ASP.NET, IIS 6.0, Java script, jQuery, SQL Server 2008, TFS, PL/SQL, MVC 1.0(nerd dinner)

Nehal H Thakkar 732-***-****

5 Marcols Ct., Edison NJ 08820 *******.***@*****.*** VISA STATUS: Permanent Resident (Green Card)

iTrendz Inc., Edison, NJ (May 2006 – August 2010)

UPMC, Pittsburgh, PA

CCBH (Common Care Behavioral Health) Management – CCBH Survey Center which provides survey information for the Providers, CCA (Community Care Admin) and CCS (Community Care Staff) facilitate them through CCBH management process.

Management process for CCA and CCS users includes user roles and registration, surveys, and Provider information.

• .NET Application Developer

Created database for survey center module, written views and stored procedure based on survey center module requirement.

Created business logic act as survey agent and retrieval of whole survey.

Created survey questions, question block and sections and entered information in database for validation purpose and created test.aspx pages.

• Service module

For CCBH users (CCA and CCS), registration process is the main module which will navigate to all the required process and other validation for users to identify CCBH user.

Module includes Registration of CCBH user, Survey Center module and Provider information.

• UI layer

Created .aspx page for displaying survey information with integration of user controls like matrix, dropdown and radio button and user controls.

• Business layer

Created .aspx page for displaying survey information with integration of user controls like matrix, dropdown and radio button and user controls.

Use getters and setters to encapsulate the information.

• Data Access layer

Created database for survey center module, written views and stored procedure based on survey center module requirement.

Use SQL Connection, Command Text and Data Reader.

Used TFS (Team Foundation Server) for version control in VS 2008 and used C# as a code-behind language with sql server 2008 as back-end to create database, views and stored procedures and access them through code-behind.

Had agile discussion with team lead and other team members for refactoring the code. Environment: Visual Studio .NET 2008, C#.Net, ASP.NET, IIS 6.0, Sql Server 2008, TFS, PL/SQL Deloitte/State of PENN, Pittsburgh, PA

Allegheny County Dept. of Human Services - electronic Client & Provider System (eCAPS) eCAPS –a comprehensive information system that incorporates information about persons who receive services through the Allegheny county Department of Human Services (DHS) and Providers who deliver the services to them.

Nehal H Thakkar 732-***-****

5 Marcols Ct., Edison NJ 08820 *******.***@*****.*** VISA STATUS: Permanent Resident (Green Card)

This application is used for contract administration, client service planning and long term organizational planning and development.

A web enabled application that acts as a central repository of client and service information, eCAPS serves as the “Operating System” for the following: Mental Health/Retardation (MH/MR) – Maximization Participation Project (MPP) Employment and Training (E&T) – Homeless Management Information System (HMIS) Community Connections for Families (CCF) – Psychiatric Hospitalization Tracking System Multi-System Rapid Response Team – Emergency Shelter Programs eCAPS also support collaboration and case management access for all program offices for Allegheny County. Common functions of eCAPS are: Intake, Assessment, Referral, Authorization, Service rendered, and Provider management.

eCAPS has 3 user types: DHS User, Provider, Service Co-ordination Units.

• Senior .NET Consultant

Developed the web Forms, using server controls, used validation controls with C#.Net as code- behind for eCAPS and expose web service using SOAP protocol.

Used VB and ASP for other integrated application like HPRP, CANS which merges with eCAPS.

Set oracle home environment by creating sqlnet.ora and tnsnames.ora file under network\admin folder for oracle connectivity with .net.

Written views, stored procedure, create packages to add, edit or delete information from Oracle database. Also, wrote PL/SQL complex queries for all DML operation.

VSS for version control.

Environment: Visual Studio .NET 2005, C#.Net, ASP.NET, IIS 6.0, VB, ASP, XML, Oracle 10g, Crystal Report 9, HTML/DHTML, TOAD, VSS

EDS, Pontiac MI

https://www.or-medicaid.gov/ProdPortal/default.aspx Oregon/Alabama/Kentucky Medicaid Management Information System (MMIS): Medicaid provides medical assistance for certain individuals and families with low incomes & resources. Mandatory basic services in Medicaid are inpatient hospital services, outpatient hospital services, vaccines for children. The project, InterChange CORE MMIS facilitates the management and administration of government health programs. More than twenty functional areas are supported by interchange CORE brings an open, flexible design to health care service delivery. It is centered on transaction-driven health care, allowing for the fastest, easiest solution available where payment and management of health care claims is a primary function of interchange CORE. Interchange has two main components – a batch processing system that runs on UNIX which is written primarily in C, and an online system that is web-based and is written primarily in C# programming language using .Net framework 2.0 and 3.0 with the concept of DNN modules (Dot Net Nuke 3.0, Content Management module) to build a local portal (site). Nehal H Thakkar 732-***-****

5 Marcols Ct., Edison NJ 08820 *******.***@*****.*** VISA STATUS: Permanent Resident (Green Card)

• Senior .NET Developer (.Net Lead for the state Alabama/Oregon)

N-Tier architecture (UI Components, UI Process Components, Business Components, Data Access Layer, Service Agents, Data Source and Services) used to implement the project.

Involved in developing and using the user interface framework (WEBUI), which provides server and user controls in developing web pages and panels.

Involved in developing and using business entity framework (SODA) which provides database access & object validation for the classes that representing business entities of the application.

Created XML files, factories, components, interfaces, code-behind files and validations.

Responsible for creation of financial modules like Expenditure, Advanced Expenditure, Accounts Receivable, 1099 and Lien for the state of OR.

Current application software can also use as Decision Support System (DSS).

Worked in different functional module areas (Financial, Claims, Reference, Recipient, TPL and Provider) and extensively used Object oriented programming concepts in most of the MMIS.

Followed systematic life cycle for the given Change Order and defects Environment: Visual Studio .NET 2005, C#, ASP.NET, DNN 3.0, IIS 6.0, XML, SQL Server 2005, Oracle 10g, NUnit framework, Open Connect Configure, IBM NASCO, SQL Developer, TOAD, Vault Client 2.1.2, MY SQL, Web Services, PL/SQL

Deloitte/State of PENN, Harrisburg, PA

State of PENN/Department of Health - electronic Client Information System (eCIS) Due to the need for DOH (Department of Health) to improve existing health programs for all commonwealth citizens, who were supported by manual process, the solution was to leverage the DPW

(Department of Welfare Enterprise System Architecture) to support the processes for DOH programs. eCIS is one of the systems within the chain that helps facilitate support for DOH programs e.g. Chronic renal disease, comprehensive specialty, family planning etc. It also facilitates an automatic eligibility determination and benefits calculation for cash, food stamps and Medicaid.

• .NET Developer

Worked on the Representative module of eCIS. 4-Tier architecture.

• UI layer – Develop screens, web forms, and written code-behind using VB.NET

• Business workflow component layer

Create business logic and services with proper validation.

• Data Access layer

Used Microsoft .NET Data provider ADO.NET, which executes the stored procedure and returns the data as Non-query, Scalar, Dataset or Data reader.

• Data container layer – Carrier of data between layers.

Create business logic and services with proper validation. Environment: VB.Net, ASP.Net, ADO.Net, SQL, Toad, PLedit, XML, XML Web Services, CSS, XSL, MS Visual Studio.Net, IIS 6.0, .Net Framework 1.1, 2.0, MS Visual Source Safe 2003, Oracle 10g

Contact this candidate