Sql Server Software Engineer

SUMMARY

Nitin P. Kushe

Email: ac0e4u@r.postjobfree.com 703- 598 5398

US citizen with active DOD Secret Clearance

EDUCATION

B.S. Computer Science, 1991, College of Engineering, Badnera (India)

** ***** of experience in the software industry. Extensive experience in analysis, Functional requirements specifications(FRS), development and testing of various applications across diverse hardware and software platforms. Significant expertise in building web applications using SQL Server relational database with.Net Framework, Active Server Pages and Internet Information Server. Special strengths also include multi-user Client/Server Environment using GUI tools such as Visual Basic/SQL Server and PowerBuilder/Sybase

PRODUCT EXPERIENCE

Hardware: IBM PC's and Compatibles

Operating Systems: Windows XP, NT, Windows 95, Windows 2000, DOS, SCO Unix

Languages: ASP, ASP.Net, VB.Net, C#, Com Objects, C, XML, XSD, HTML, VB Script, Java Script, PowerScript, APEX SQL, SQL (stored procedures, triggers DTS packages), Pascal

Databases: MS-SQL Server 2008, SQL Server 2008 Reporting Services, ADO.Net, Oracle (9i), DB2, Sybase (10, 11), SQL AnyWhere5.5, Watcom(4), APEX, dBase, FoxPro

Software: Internet Information Server IIS, Visual Studio.Net, PowerBuilder/PFC, S-Designer, Oracle Forms3.0, Visual Basic 6.0, Crystal Reports, Star Team, Visual SourceSafe, Team Foundation Server.

COTS Product - PRISM-Procurement, Employee Health Care Benefits.

Enterprise applications - eDATA Financial Application, E-Bill, TOPMIS II (DOD), Preventative Maintenance System.

02/2016 - Present Defense Health Agency (DHA)

SQL Server 2012, Asp.Net, C#, LINQ, MVC, J Query, Java script.

Worked on JPC application to enter Human and animals' medical records and process them through a various approval process. Application also keep track of various forms of materials such as slides, blocks & tissues. iText Sharper and Telerik Kendo Rich Text editor are used to create on-line letter and digital signature to sign the letter electronically.

08/2014 – 01/2016 US Secret Service. (USSS)

SQL Server 2012, Oracle 11g, Asp.Net, C#, LINQ, MVC – Code First approach, J Query, Java script.

Worked on eCheck application that involves background checks processing and various types of USSS checks conducted by USSS agents. Project includes file upload features to upload an excel sheet and populate SQL Server data which will be ready for background check processing. Background Check results are displayed in MVC razor view which helps USSS agents to clear people who will be attending the events takes place in the united states. The system has capability to restrict the groups using security features.

System is developed using Visual studio 2012 MVC .Net with C# and razor view. Extensive use of J query, Java script through out the application. SSRS reports are developed for reporting purpose.

07/01/2012 – 07/2014 - LMI. SQL Server 2012, VB.Net, LINQ, MVC – Code First approach with REST API calls and Test driven approach.

The Centers for Medicare & Medicaid Services (CMS) had launched open enrollment in October 2013.A Federally-Facilitated Marketplace (FFM) operated in states that have chosen not to build their own Marketplace. The Marketplace developed by CMS will be easily adapted to meet the needs of any state that chooses to utilize this model on a temporary or permanent basis.

Worked on back-end activities such as data migration, writing store procedures for generating SSRS reports, HL7 messaging in XML format, triggers, views, database design. Also worked in front end development in C#, MVC with AJAX call to MVC controller methods using code first .net entity framework, data seed, incremental migration and deployment.

07/10- 07/12 – US Marine Corps

Asp.Net MVC, 6.0 Framework, C#, SSRS, SQL Server 2008, SSIS Packages, Crystal Report, Java script, JQuery, CSS, Ajax Controls, MVC – Code First Entity Framework (6.0) with REST API calls and Test driven development(TDD).

Designed and developed IT Procurement Tool that have been used by US Marine Corps all over the world. The system consists of 10 different Work Flow for Request/ Approval process. The system also interfaces with other applications through .Net web services developed in asp.net MVC and C#. This application is divided into Privacy, Security and availability matrix forms. Each matrix provides summary, details and graphical views of organizational data. Charts are developed using SSRS reporting tools. Also monitor daily activities of SQL Server database such as back up, restore, writing store procedures, transaction logs, tuning and performance logs, Jobs and creating SSIS, DTS packages to schedule jobs, Importing and exporting files to populate SQL tables and SSIS packages. Creating SSRS reports through store procedures.

Front end application uses REST services controller's call and tested using Dev tool for RESTful API calls using google crome app to test GET, POST, PUT methods. Team Foundation Server (TFS) for the objects checkin and check out process. Combination of LINQ and lambda expression for ORM - Entity Framework. Extensive use of Repository pattern with REST API controller calls. Extensive use of Asembler, DTOs, generic objects, and .Net collection classes. Nuget Packages has been used for adding third party libraries and upgrades.

07/08-07/10 - DEA

Asp.Net, C#, SSRS, JQuery, Oracle 11g

HUMIS – Currently working in HUMIS web based application that keeps track of health related records for DEA employees and applicants. It is a fully object oriented .Net web application with 3.5 .Net frame using C# and extensive use of AJAX controls for client validations with Oracle 11g database. Application involves User Administration, Employee and Applicant exams modules, Process Exams, generating packages; various reports developed using SSRS reporting tools.

07/2007- 07/01/08 Spherion

Federal Reserve Board – Lead Developer

The Electronic Data Analysis Toolkit Application (eDATA) Asp.Net, C#, SQL Server 2008

EDATA project is a major change in how the FSA processes data series. One of the major functions of the Financial Systems Analyst (FSA) in the Information Technology Division (IT) is to process data series information. eDATA project will provide the standard and ad hoc reports that satisfy the needs of the FSAs in the IT Division. Designed .Net framework, design pattern, and involved in database architecture..

eDATA is a Microsoft .NET 2.0 based application with C# as the programming language. Additional components will include Microsoft SQL Server 2005 as the primary application database, IBM DB2 version 7 as the primary data store and SQL Server 2005 Reporting Services as the reporting engine and server.

The ASP.NET programming framework is built on the Microsoft common language runtime. It is comprised of libraries providing functionality to build Web-based applications. ASP.NET provides several controls and classes that implement the Page Controller pattern. Additionally, many included controls provide robust patterns for site navigation, user management, security and other common application services.

08/05 – 06/07 Washington Metropolitan Area Transit Authority(WMATA) - Lead Developer

Worked on Rail Performance Monitoring (RPM) - This system keep track of yard and terminal activities management. Main feature includes car consists movements,

Search and locate the trainid on the terminals and yard tracks, rail operator updates, mileage reports and daily mileage calculations. The mileage reports and weekly/monthly maintenance reports.

Application interface developed in ASP.Net, XML, HTM, VB.Net, C# and Java script by Visual Studio.Net tool with SQL Server 2000, Reports are developed in Crystal reports.

05/1998-07/2005 - SI International, Reston Virginia.

Worked in the following government contracts.

3/2001 - 7/2004 Dept. Of State Rosslyn

Senior Software Engineer - ASP, VB script, SQL Server 2000-DTS Packages

System keeps track of refugee people who want to settle in the United States.

As a member of the WRAPS software development team, develops Visual InterDev

code (ASP, VB, DTS, VB Script, Java Script) according to contract specifications. The StarTeam is used for version control and new builds and Crystal reports used for web-based reports through XML File andASP.Net pages. worked closely with other software developers to comply with WRAPS coding standards and practices.

5/2000 - 2/2001 Dept.Of Defense Alexandria VA

Senior Software Engineer/Analyst

Microsoft's Active Server Pages (ASP) and Internet Information Server (IIS 4.0) power this application. VB objects were registered as ActiveX server components in the web server and were used in the Microsoft's Component Object Mode (COM) architecture.

Extensive VB scripting and Java scripting were used in Active Server Pages to activate and call the COM components. In addition, Microsoft Transaction Server was used for load balancing and database transaction pooling.

Worked on TOPMIS II, a joint development project with the OPMD, to improve access and manipulation of officer management data.

8/1999 - 3/2000 Dept. Of Interior Washington D.C.

Senior Software Engineer

Department of Interior (DOI)-Office of Inspector General (OIG) provides policy direction and products, supervises, and coordinates all audits, investigations and other activities in the department designed to promote economy and efficiency or prevent and detect fraud, waste and abuse. The Audit Tracking System will help department to maintain information regarding different type of audit performed by them.

The system was designed and developed using ERWin 3.5,ASP and Power Builder, Oracle 8i database, SQL*Plus and PL/SQL Stored Procedures.

5/1998 - 7/1999 Federal Reserve Board Washington D.C.

Software Engineer

The Federal Reserve Board, Building Maintenance System Involved in the design and development of a Building Maintenance System. The system was developed using ASP with Microsoft SQL Server 6.5 and Win Batch S/Withies system keeps track of the generation of basic work orders and automatically generates the Preventive Maintenance Work Order.

The Basic Work Order involves task details, maintenance people work hour schedule and Work Order notes.

The Federal Reserve Board

Involved in the development and maintenance of Examiner Workstation Examiner Workstation was developed using PowerBuilder 5.0, the Object Cycle feature with SQL Anywhere as the database. The Federal Reserve banks provide banking services to depository institutions and to the federal government. This system keeps track of data migration, credit analysis, loan review, pre-exam planning and coverage. The system supports object oriented features of Inheritance, Encapsulation and Polymorphism.

8/1996 - 8/1997 American Postal Worker Union Washington D.C.

Programmer - PowerBuilder, SQL Anywhere

Designed and developed a grievance tracking system. The system aims at automating the grievance lodging process. Extensive use of Object Oriented Technology - Inheritance, encapsulation, function overloading, various user objects, data windows, and PB controls.

It provides work-in-flow process to the organization and maintains information regarding

all the grievances lodged and all the resolutions provided. It provides a scheduling capability for cases scheduled for arbitration.

11/1991 - 8/1996 Birla Global Finance Limited

Programmer- PowerBuilder, Sybase

Designed and developed a Foreign Exchange System. The system was used to maintain and handle all transactions for foreign exchange deals and traveler's cheques. It has extensive security and transaction logging features. Modules of the system are Purchase Sales T.C., Settlements T.C., Travel Agent Commissions and Cashier report writer. The application is developed using Visual Basic 3.0 and Microsoft Access

11/1994 - 7/1995 Cricket Club Of India

Software Engineer Visual Basic, SQL Server

This system maintained all club management activities; Room Management, Membership Management, Kitchen Management, Billing, Inventory, Payroll System, Accounting.

Developed the Payroll System module, which dealt with generation of pay slip for the employees of Cricket Club of India, indicating the net salary drawn by tile employee.

Contact this candidate