System Integration Engineer

NICHOLAS G. RILEY

Summary:

Skilled technical manager with vast knowledge of public safety workflows and public safety software systems.

SKILLS:

Microsoft Office Suite, Java Scripting, HTML, UNIX, T-SQL, Oracle, Windows Power Shell, Microsoft SQL Server, Microsoft Visio, Microsoft Visual FoxPro, Active Directory, Symantec Ghost 8.0, Public Presentations, System and Business Analysis, Business Process Improvements/Consulting, SaaS

WORK EXPERIENCE:

Hexagon Safety & Infrastructure Madison, AL

Cloud Implementation Engineer 3/2020-9/2023

Consult with the customer to identify appropriate On Call product configurations to meet the customer’s desired workflows.

Coordinate with customer to validate On Call products are implemented and configured to achieve customer’s business goals, making sure the environment is ready for system training, acceptance, and cutover.

Collaborate directly with customers providing firsthand training via remote tele-conferencing & collaboration technologies or to evaluate questions or issues that may be encountered.

Coordinate with customers to resolve issues.

Advocate for overall customer success with the On Call products while working within the framework of COTS products and services with global applicability.

Take clients engagement through the lifecycle.

Improve software to meet customer’s business needs and follow best practices, standards, and documentation.

Render consulting services and act to ensure customer meets deadlines.

Use Windows PowerShell to clone different environments.

Use Windows PowerShell to install specific applications such as chocolatey.

Configure and ensure software changes to system to assist in business organizational changes.

Inspect changes before customer performs UAT.

Tyler Technologies, Moriane, OH

Implementation Consultant 9/2018 - 3/2020

Run and create SQL statements using Oracle SQL Developer (Create DB, alter tables, drop tables, select, insert, delete, update statements, loops, and joins)

Identify and document business/technical requirement specifications for specific software design/development, forms, reports, interfaces, process, configuration, and other relevant changes.

Configure iasworld software to client request.

Consult with users to identify proper data mapping process for the product conversion from existing software to iasworld software.

Creating both clients facing and internal documentation sucks as quick tips and how to’s.

Design and conduct knowledge transfer sessions on site or through webinars.

Provide training in software functionality as well as data entry, system administration, user security, and user permission.

Create custom reports and customize existing reports for clients.

Assist QA staff with product testing or modification testing as required.

Modify HTML forms at customer request to meet business needs.

Modify XML and XSL stylesheets at customer request.

Create business review documents for clients.

Superion (formerly SunGard Public Sector) High Point, NC Systems Integration Consultant 1/2014-9/2018

Implement Records Management System and Mobile System (Police and Sheriff offices nationwide)

Perform routine maintenance checks for optimizations and efficiency on SQL Server 2005/2008. Installed Microsoft Hot Fixes and Patches to keep all servers and databases up to date.

Run basic SQL statement using MS SQL Express (Create DB, alter tables, drop tables, select, insert, delete, update statements)

Installation and support for IIS on Windows server 2003 (ver 6) and 2008 (ver 7) and higher

Performed routine maintenance checks for optimizations and efficiency on SQL Server 2005/2008/2016. Installed Microsoft Hot Fixes and Patches to keep all servers and databases up to date.

Prepare application environments (SQL database creation and initial data population.

Create structure setup with .Net and FoxPro interfaces.

Install and configure end user software.

First point of contact for agency throughout project until they are live.

Review contract with our project management team.

Establish positive client relationship during engagement for high client satisfaction, quick deployment, and adequate training.

Learn client’s requirements and translate them to process changes and solution needs and suggest best client solutions.

Develop configuration notes documentation to deliver to client for sign-off.

Coordinate with functional groups and identify all required enhancement and process changes as per client requirements to resolve all issues and provide onsite support to all clients for implementation process.

Work with internal and external resources to test and resolve implementation and application related issues.

Installation and configuration of third-party interfaces.

Complete installation guides, site readiness and/or quality assurance checklists, and site reports, as well as document configuration details in internal systems to ensure a successful customer transition and support experience.

Flexibility to respond to customer needs both remote and onsite in a timely manner is required.

Participation in ongoing professional development activities including those focusing on OSSI product knowledge.

SunGard Public Sector Lake Mary, FL

System Administrator/Mobile Products Team Lead (5+ employees) 8/2006-1/2014

Developed SQL Queries and Procedures from a SQL Server 2005/2008

Database. Queries were used in reporting of daily law enforcement activities for Internal Investigations.

Used Oracle to query and diagnose client databases for system information. Developed Queries and procedures for Oracle.

Set up Active Directory for outsourcing clients.

Installation and support for IIS on Windows server 2003 (ver 6) and 2008 (ver 7) and higher

Manages two functional teams.

Performed routine maintenance checks for optimizations and efficiency on SQL Server 2005/2008/2016. Installed Microsoft Hot Fixes and Patches to keep all servers and databases up to date.

Detach and attached databases for MS SQL server 2005/2008

Oversaw the development and maintenance of Field Reporting Server and Message Switch Server using VM HyperV

Manage the virtual server for mobile products team, make sure the VM has enough RAM to run, use lab manager to host the VM.

Manage SAN make sure hardware is updated.

Managed team that oversaw the troubleshooting of hardware diagnostic errors and software malfunctions and instruction on corrective measures to resolve issues.

Supervised the troubleshooting of dispatch software installed on an IBM AS400

Trained clients on installation and instruction of several client applications (MDB, Report Manager, Automatic Vehicle Location (AVL) and Mobile Flash)

Supervised the installation and implementation of software at remote locations.

Troubleshoot network connectivity issues for local area network (LAN) and wireless connections.

Maintained and developed HTML code for client applications.

Trained new hires and assisted in hiring process.

Verizon Wireless Philadelphia, PA

Mobile Data Technician 8/2004-8/2006

Installed portable Laptops and Modems into Philadelphia Police Departments vehicles.

Performed IP trace routes and ping test using Cisco Systems to test and configure firewalls.

Managed performance database and troubleshoot problems that arise.

Re-imaged and reconfigure Panasonic hard drives for laptops using Symantec Ghost

Assisted System Engineer in writing and updating security policy for Windows 2000 and XP following Verizon Wireless standards.

Reconfigured laptops basic input/output systems (BIOS) and reset IP addresses.

Built and repaired Panasonic Laptops

Replaced modems with Verizon Wireless 1x Evolution Version Data Only (EVDO) cards.

EDUCATION:

Bachelor of Science – May 2004

North Carolina Agricultural &Technical State University, Greensboro, North Carolina

Bachelor of Science, Electronics Computer Technology,

Concentration: Electronics

Bachelor of Science, Business Administration,

Concentration: Management

CERTIFICATIONS:

Panasonic Certified – Certified Technician to construct, diagnose, and repair Panasonic Toughbook CF19 and CF20

Contact this candidate