Information Technology Sql Server

Steven P. DuBois

**** **** ***, *** *********, CA 603-***-**** ******.******@*******.***

SUMMARY OF QUALIFICATIONS

Senior .Net/SQL developer with strong Oracle/MS SQL Server database SQL skills, with over 20 years experience with Microsoft technologies and 15 years management experience as an Information Technology Geographic Information Systems manager (ESRI based GIS).

PROFESSIONAL EMPLOYMENT

Information Technology Contractor, Boston Data Group, June 2014 – Present

Responsibilities

Lead ETL process group to bring legacy data into new database environment

Lead Database Developer

Develop and maintain SQL Server Database

Develop MVC web application with C#, JQuery, Entity Framework

Applications

Converting Insurance Management system from Mainframe to SQL Server 2008 R2/MVC C# application. Responsible for ETL process to bring legacy data into new database environment via SSIS. Created tables, triggers, sequences, stored procedures, functions, and views in SQL Server 2008 R2. Developing specification translating legacy COBOL and VBA to SQL Server and C#

NH Department of Transportation Concord, NH, June 1987 – June 2014

Responsibilities

Hands on Software Development VB.net, C#

Project Management

Manage Information Technology Geographic Information Systems (GIS), Asset Data Management, and Systems Analysis groups.

Develop implement, and administer multi-million dollar biennial program and budget – authorized computer and software purchases

Applications

Led ASP.Net MVC application converting project financial tracking application from desktop application. Development environment: Visual Studio 2010, C# and MS SQL Server 2008 R2 as database. Web Application replacing desktop system.

Developed project financial tracking application using Visual Studio 2010 VB.NET for front end, C# for web service, and Oracle 11g as database. Application replaces paper system and multiple entry points with electronic transmission to oversight agency. Creating custom controls, custom classes, and interfaces. Created tables, triggers, sequences, stored procedures, functions, and views in Oracle. Using TortoiseSVN for source and version control. Developed business requirements documents.

Translating financial project tracking system Oracle 11g database tables and views to SQL Server 2008 R2 using Microsoft SQL Server 2008 Management Studio.

Oracle - Developed and wrote complex views, stored procedures, functions, sequences, triggers, and created tables, primary and foreign keys, and constraints using PL/SQL Developer. Developed training course and provided training to subordinates in Oracle how to create SQL statements and use Oracle native functions in PL/SQL Developer.

Developed Asset Management collection application using VB.NET for Dell Axim X50/X51 using Windows Mobile 2003 SE and Windows Mobile 5.0, allowing field personnel to collect highway asset data including guardrail, sign inventory, roadway attributes, and GPS data, used Microsoft Access database.

Created Accident Records Management System for State of NH Division of State Police with Visual Basic 6.0 and MS Access running on Windows 95. Data entry performed in disconnected environment on ruggedized Panasonic ToughBook CF-27. Created proprietary file format for data transmission/download to desktop. Supported and updated application to run on Windows 2000/Windows XP when new laptops were purchased. Collected data from barcode scanners and GPS data from GPS units in vehicles.

Developed ASP.Net/VB.NET application replacing mainframe crash reporting system.

Development MS Access applications for fleet management and construction management with remote transmission of field data quantities.

Information Technology Contractor, August 1997 – December 2000 and April 2012 – July 2012

Responsibilities

Authorized to sign contracts, purchase equipment, software, software development tools, system platforms

Administer, plan, develop, & evaluate business program and direction.

Develop the scope of services and the services provided and projects undertaken. Work with other IT related organizations to enter into business relations.

Develop information technology solutions for small businesses.

Applications

Developed a Sign Inventory Management System using Visual Basic 6.0 and MS Access. The application collects and stores sign condition data storing data to laptop computers. Features included capturing traffic sign retroreflectivity with hand held retroreflectometer (similar to Delta RetroSign GR-1).

Developed Windows Mobile 6.5.3 application for Motorola MC75A, web application, and web service. Application provided routed job locations for utility company and provide directions from job to job displayed on map using Google Maps API. Web application developed in C#, VB.Net for mobile app, and VB.net for web service. Used SQL Server for database storage.

Developed Android OS application with Java, SQLite, and OpenGL on Eclipse Indigo IDE.

Converted the Municipal Equipment Management System software from dBaseIII/DOS to Windows platform. Application was written for the University of New Hampshire for distribution to municipalities. Application tracks work order, costs, and maintenance activity. System is written in Visual Basic 5.0 using a Microsoft Access database.

PROFESSIONAL CERTIFICATIONS

Professional Engineer, State of New Hampshire

EDUCATION

BS Civil Engineering, June 1987 – University of New Hampshire

MS Civil Engineering, Graduate level GPA 3.84, Fall semester 1994 – University of New Hampshire

Masters of Business Administration (course work 2004), GPA 3.84, Franklin Pierce College

COMPUTER TECHNICAL SKILLS

Contact this candidate