Derek B. Email & Phone Number

Columbus, Ohio Area

• Enhancement of Ohio State University College of Medicine's web based student testing and records resource for Students, Faculty and Administrative Personnel.• Upgraded ASP.NET 2.0 web-enabled system alert application to ASP.NET MVC 4.5 utilizing C#, AJAX, JQuery and Kendo UI for ASP.NET MVC.• Optimization of database objects, which includes troubleshooting TSQL, SSIS packages, views and stored procedures.• Upgraded data imports, which included debugging existing DTS packages and creating new SSIS packages.• Demonstrated skills:o C#o ASP.NET MVC 5.0o SQL Server 2008 / 2014o SQL Server Business Intelligence Development Studioo SQL Server Data Toolso JQuery / AJAX / HTML 5o Cold Fusion 9 (CFML, CFC)o ColdBox Framework (Model-View-Controller)

Columbus, Ohio Area

• Developed customer relationship management modules using ColdFusion and JQuery as part of a suite of applications to assist automotive dealers manage customers via the internet.• Enhanced a ColdFusion prospect management application that serves over 3000 automotive dealers and manufacturers. This application manages prospects online and also through print, email and phone communication.• Created SQL Server database objects, which includes stored procedures, tables, user-defined functions, views and indexes for tables in excess of 10 million rows.• Integrated agile methodology into our work flow with a team of up to 8 developers by utilizing Sprints and Kanban.• Collaborated with customer support and provided on-site assistance for auto dealerships in order to help clients utilizing our software suite.• Served as the project lead on the project which successfully implemented Do Not Call functionality within our web application for auto dealerships.

Columbus, Ohio Area

• Developed web interface for corporation intranet using Microsoft Active Server Pages, VBScript, HTML, SQL Server and JavaScript.• Constructed SQL Server stored procedures in order to extract data from a SQL Server database and format into recognizable data by the computer systems of three different State agencies• Acted as technical liaison between development team and three State agencies in order to finalize data file formats that were to be transferred through File Transfer Protocol. Data was captured through a web interface.• Wrote programmer development specifications for changes to a new credit scoring application to be used to streamline the loan application process for potential clients.• Performed as the project lead of a team of four developers, including myself, in order to keep management informed of development progress as well as relay management concerns to the team.

Columbus, Ohio Area

• Designed and developed web interfaces for corporation extranets utilizing Cold Fusion.• Developed SQL scripts and stored procedures on the server to access data from a SQL Server database.• Worked in a team environment to assist in the software development of a Cold Fusion web server application with an Oracle and Access database.• Assisted in the design and implementation of a Power Builder data entry application specifically tailored for the health care environment.• Served as database manager for a Sybase database, which is accessed by either the user through Power Builder GUI or back end COBOL programs.• Served as an I/S project manager, as well as technical lead for the Medicaid team.• Utilized the following development tools: SQL, HTML, JavaScript, ColdFusion Studio 4.5, Cold Fusion Server 4.5 and Active Server Pages.

Columbus, Ohio Area

• Evaluated requests for enhancements and development, estimating project timelines and delegating workload to team members.• Designed a COBOL program to validate an insurance customer for home/car discount, based upon selected criteria from an external system’s files.• Provided programming and testing of batch and online programs for state regulatory insurance changes using COBOL, TSO, JCL and ISPF.• Implemented process of correcting insurance data that is reported to the Florida Department of Motor Vehicles.

C# .Net 4.0

C# .NET 4.0 course work

Bachelor'S Degree, Management Information Systems, General

Achieved Bachelor of Science in Management Information Systems.