Daniel Johnston Email & Phone Number

Woodland Park, Colorado, United States

Colorado Springs, Colorado Area

Widefield, Colorado

Sadly I am out of contract as of November 1st, 2018.Although the only developer working on this project, I did work very close with educators, and testing companies to determine requirements, design, development and deployment plans.During this process I was:Responsible for all aspects of managing student testing data. Design, create and test student load processes to various testing platforms.Using available technologies, read data from various sources, create upload files, and process to testing sites.Designed and developed MSSql database to capture, retain testing results for all students for all testing platforms.Design and create a deployable desktop application (.Net C#) to be used for viewing testing results and teacherevaluations in accordance with Colorado HB191.The entire process takes advantage of MSSQL server database, SSIS for many various ETL processes, Powershell as the scripting engine for many of the non-GUI based processes, and SSRS for reporting and generation of PDF output files.Application created in .Net C# for data access and PDF manipulation using PDFSharp.

Colorado Springs, Colorado Area

Contracted to analyze and assist in correcting serious problems with operation of MS SQLServer 2014 Integration Server. Analyze process flow, optimize current database, and ensureaccuracy of data reporting. Based on analysis report, was retained to correct flaws found inSSIS installation, as well as data process flow. This required creation of new SSIS packages,data schema creation, and new procedure coding. Changes to their system relied extensivelyon my skills as a database architect and developer. Working very close with SRS staff, and ITto document and train on new order processing.

Denver, Colorado

Conversion of PostGreSQL database to MSSQL database. Created new MSSQL database library for connection to new converted MSSQL database in C++ and C#.

Sole Database person for software company responsible for all aspects of client managementsoftware. Responsible for maintenance, upgrades, support, enhancements of proprietary CRMsoftware. Filter application modification requests, prioritize and make changes to softwarebased on user and management requests. Project task tracking, design and integration intoexisting software. Including client management, problem call tracking, inventory, point of salecredit card charge, billing including monthly subscription renewals, client notification emails, andall aspects of reporting.

Colorado Springs, Colorado Area

Responsible for design and development of very high throughput database structure to supportclient credit card processing needs.

Colorado Springs, Colorado Area

Designed, developed, tested and implemented vertical table structure to store all data used byCIGI custom applications. Vertical table structure provides total independent applicationdevelopment without structure changes by the database developer.

Colorado Springs, Colorado Area

Administration of corporate databases; maintain security, consistency, backups, and ensuredOnyx System Administrator; Responsible for all aspects of Onyx and JD Edwards accountingsoftware JD Edwards Application Administrator; Designed and developed the integration systembetween Maintain, upgrade, path corporate cluster SQL server farm.

Served proudly with C Company, 321st Engineers; 994th Engineering Company; D Company, 16th Engineers.

English, Computer Science

Mathmatics, Engineering

Education record

Activities and Societies: ROTC, Rifle Team

Education record