Mark Ewing Email & Phone Number

Westerville, Ohio

Designed and implemented enhancements to the Windows Forms client-server system that gathered biometric and personal data for background checks. Investigated and resolved hardware, database, and software issues to keep the company's software solution performing optimally. Performed database optimization to resolve system stability issues. Updated software to remain in compliance with changing FBI and BCI regulations. Updated ASP.Net website as required by marketing and management. Provided tier 3 customer support. Assisted in QA testing of releases. Researched and resolved software issues.Managed IT activities, directing and coordinating actions across hardware, software, and security policies. Managed various technology-related business components, CJIS security compliance, and FBI contracts. Worked with the staff to help maintain and create solutions to operational tasks, ensuring that the right policies were followed. Communicated with the heads of various departments to ensure company compliance across the board and to develop security plans for each department and the company.

Columbus, Ohio Area

Work with customers to guide their design and implementation work when creating interfaces to Pacejet cloud software using various APIs. Developed a toolset that consists of configurable modules that allow non-programmers to create plug-ins that manipulate the content of XML data as it is imported to obtain the desired custom behavior of the application. Trained co-workers on creating configurations for configurable modules to manipulate XML data. Work with customers to define and document changes needed in our product to meet the customer's existing business model. Designed and created modules and scripts that modify the behavior of our product to better fit a customer's business model. Visual Studio 2015, C#, LINQ, MS SQL Server 2014, SQL, and T-SQL are the tools used.Analyzed various API documentation, mostly Web APIs, and created modules that interacted with APIs to transform our data for transmission and then transform the returned data for import into the system. Work with a team to maintain and enhance Pacejet's software. Participate in special projects as required, analyzing changes needed, documenting, designing, and implementing new features. Debug and fix general software bugs. Develop scripts for automating QA testing. Develop queries as needed for troubleshooting software issues. Write technical documentation on the use of our features of Pacejet applications. Help maintain internal development environments. The tools used are Visual Studio 2008, VB.NET, C#, LINQ, MS SQL Server 2008 R2, SQL, and T-SQL.

Developed and designed an ERP system in the internal C++ framework using Microsoft technologies. Developed new UI and data-processing features using Visual Studio, C++, database schema changes, trigger, and stored procedure maintenance and creation to update or define business logic maintenance or creation to deliver ERP data across the enterprise.Developed reports conversion strategies and methodology for migration of reports from Crystal to Microsoft SQL Server Reporting Services.Development of an e-commerce solution with a UI based on ClearUX (ExtJS variant), using JSON via Spring. The middle tier was initially generated via Ant scripts but later hand-rolled for better flexibility. Hibernate ORM defined the back-end data structures. Other integral components consisted of MDM (Master Data Management), ESB (Enterprise Service Bus), BODs (Business Object Document), and Inventory, Pricing, and Unit of Measure engines. The e-commerce solution was developed using a RAD/Agile application development methodology.

Developed and enhanced an enterprise-wide college management and CRM/POS/Scheduling system from requirements using JScript, ASP, VB.NET, ADO, MS SQL, JavaScript, HTML, IIS, and CSS. This web-based application provides school administrators and student services associates a common interface to enter and maintain all student information, including admissions, scheduling, payment, attendance, and state certification. Also implemented major enhancements to the VB.NET XML interface between the CRM application and the accounting system.

Developed and tested a custom Career Management Services web application for a top MBA school using Visual Basic 6.0, ASP, ADO, MS SQL, VBScript, JavaScript, HTML, IIS, and CSS. This web-based application provides custom interfaces for school administrators, students, and potential employers running in a distributed environment to provide exceptional performance for hundreds of simultaneous users. The functionality developed included automatic scheduling of interviews and appointments, job posting boards, office reports, and system administration.

Developed custom applications built around an internet-based enterprise knowledge management application using JavaScript, HTML, SQL, VSS Visual C++, MS Project, and OScript to enhance functionality and a custom UI. Played a key role in all phases of SDLC. Trained other employees to familiarize them with the coding environment and proprietary tools.Managed the release of four enterprise internet-based enterprise knowledge management application modules. Analyzed high-level requirements, wrote detailed requirements, worked with developers on design, and reviewed and approved resulting code and code changes. Worked closely with the QA group to develop, record, run, and evaluate the results of new automated tests. Worked with release engineering to facilitate the building and delivery of the modules.Analyzed and solved problems reported by internal and external customers. Participated in code reviews of solutions. Developed documentation and online help pages for the new functionality.Designed and implemented major enhancements to the API of an enterprise web application to add the ability for customers to interface custom applications written in VB.Net and C#. Modified an existing web-based system to allow data access by PCs, handheld computers, and a variety of display devices