Sql Server Developer Business Management .Net

William Jones

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

* ********** *******

An IT professional with experience in positions ranging from individual

developer to Director of IT. Performing duties including SQL Server

Database Programming and Administration, Application design and

implementation, Application maintenance and troubleshooting, Business

analysis,, System administration tasks including Windows Networking, ADS

and TCP/IP network design and implementation. Writing application code in

numerous languages including C#/.Net, TransactSQL, Java, JavaScript,

VisualBasic and C/C++. Working with Relational Databases, ETL, Web servers

and services, machine interfaces, simulation and numeric analysis. More

recent work includes C#.Net code to handle aspects of power grid

transmission equipment testing and simulation, TransactSQL stored procedure

creation to perform marketing analysis, and Win32 DLL used to "hook" system

calls in order to modify file manipulation to include seamless

encryption/decryption of data.

2 Technology

Microsoft SQL Server Development and Administration, T/SQL, C#/.Net,

Windows Server and Desktop OS's, IIS, COM+, Unix, Linux, C/C++, Unix shell

scripts, PostgreSQL

Microsoft Developers Studio, Microsoft Project, Microsoft Visio, Microsoft

Outlook, SQL Server, SSIS, SQL Server SSAS, Microsoft Visual Source Safe,

Eclipse, SVN

UML, Coad/Yourden OO Methodology, Booch Methodology

PC and laptop technology, Switches, Routers, VPN Hardware, IBM RS6000,

RocketPort, ADAM

3 Education

M.Sc, June 1994 -University of Denver, Denver, CO, USA-Graduate program in

Physics

B.Sc. June 1991-University of California, Santa Barbara, CA, USA-

Undergraduate program in Physics

4 Previous Experience

1 August 2008 - June 2009

Window's System Level DLL hooks for Inland Technology Group, LLC

General Description-

Developed DLL for system hooking on Windows.

Developed web services handlers to communicate with provisioning servers

Developed Local services to maintain encryption keys

Designed and developed several individual software programs under Windows

XP using Win32 API in C++ and C#.Net Web Services

2 June 2008 - December 2008

Telecommunications equipment testing program for SPG, LLC

General Description-

Developed DLL for system hooking on Windows.

Developed web services handlers to communicate with provisioning servers

Developed Local services to maintain encryption keys

Designed and developed several modules for a larger application under

Windows XP using C#.Net

3 January 2006 - June 2008

Large scale analytics database creation and administration for

BrandInformatics, a marketing start-up business that attempted to quantify

customer brand loyalty and tie that loyalty to fundamental financial

results

General Description -

Designed and implemented database to store and analyse survey data.

Processed raw inbound data into analyse system

Handled all IT related start-up for a new company.

T1 provisioning

Remote hosting contracting and arrangements

Internet presence (DNS, SMTP, TCP/IP networking)

Designed and developed analytic platform on SQL Server 2005, SQL Server

2005 SSIS, SQL Server 2005 SSAS and supported MS Windows Server 2003 and MS

Windows XP Desktops. Involved as the sole IT resource enabling start-up

operations and information management.

4 December 2001 - June 2006

Director of IT at a Manufacturing start-up involved in high precision

machine shops. -Responsible for the IT operations for a business

integrating 5 remote locations running independent ERP systems with a

central corporate IT structure composed of Seibel and Great Plains

Accounting software for Bolt Industries a startup business in high

precision machining.

General Description-

Directed and monitored IT application development based on an Intranet

utilizing web services to manage data collection and reporting.

Designed and implemented SQL Server database to handle intermediate

information for integration with other systems.

Responsible for database administration and user support.

Responsible for network operations including site to site VPNs and

Corporate Web Presence.

TCP/IP networking, design and support.

Designed and implemented equipment monitoring hardware to track and report

on machine utilization.

Designed and developed software, administrated server structure including

several SQL Server deployments under Windows Server 2000/2003.

Additionally provided support for Microsoft Desktop machines including

Microsoft Office. Formulated and documented business process flows in

Microsoft Visio. Designed and participated in the development of a

corporate reporting structure using SQL Server 2000 and C#.Net.

5 March 2000 - November 2001

Designed and Implemented an application for the US Navy to upgrade

technology within submarine periscopes working as contractor for Sonalyst.

General Description -

Designed and oversaw a four person team during the development of a Windows

application used to operate and store information from the submarine along

with integration to digital image storage.

Designed and implemented Win32 C++ front-end application GUI.

Designed and implemented Win32 based services to interact with boat

hardware and digital cameras.

Designed and implemented SQL Server 2000 database to record information

regarding boat functions.

A multi-service application implemented on MS Windows Server 2000 using MS

Developer Studio, C++, Win32 API and MS SQL Server 2000 as the storage

engine. The services interfaced with multiple pieces of hardware used to

acquire data from shipboard systems as well as control and extract images

from a COTS digital camera.

6 June 1999 - March 2000

Designed and implemented a multi-threaded C++ application for the Fire

Department in New York City to replace a legacy DEC Alpha machine used for

handling all messaging between the Central CO to the borough CO's and

interfacing with borough CO hardware used by both the city-wide alarm

system and the dispatcher interfaces as a contractor for PURVIS Systems

General Description-

Analysed and implemented hardware protocols to control and utilize hardware

at the dispatchers stations

Analysed and implemented code to handle inter-borough communication

messages..

Implemented real-time application on MS Windows Server NT using MS

Developer Studio C++, Win32 API interfacing with a RocketPort to handle all

hardware interfaces. Required implementing several serial based protocols

as well as handling a continuous flow of information between remote

borough offices and the central dispatch system

5 Key Competencies & Skills

C#.NET, SQL Server Programming,/TSQL and Administration, JavaScript, Java,

HTML/ASP, HTML, MS ACCESS, UML, Windows Server, Windows Desktop, ADO,

Visual Basic, ASP, VBScript, VB/.NET, Software Engineering, Documentation,

Software Design, Business Analysis, Project Planning and Delivery, Resource

Management, Project Management, Requirement Management, Project Estimation,

Client Interactions, C++, C, Windows NT, Linux, Unix, PASCAL, Defect

Prevention, TCP/IP Networking Design, Implementation and Troubleshooting,

English

6 Personal Details

Date of Birth-07/07/68

Nationality-USA

Contact this candidate