Edric Kilimann - City/County Technology Resource Available to assist in City/County Information Technology projects including Technical Analysis, Migration, Integration, Configuration, Custom Database & Web Development & Reporting and System & Application Security. Also able to assist with R&D of AI, Blockchain, Crypto, Data Science, FinTech, Machine Learning.

City Technology Project

Assisted with various internal Application Migration projects including, analysis, documentation and recommendations. Review Windows Tasks, IIS App Code, permissions, bindings, ODBC DSN, Email functionality and settings on each server. Communicate with vendors about Application Migration prerequisites and configurations. Create Windows 2016 and 2019 Virtual Machines with HyperV for development & testing. Project management, plans & documentation with MS Teams, SharePoint, OneDrive and Office 360.

Environment

Install KeePass, Avaya Workplace, and SQL Server & Management Studio for testing. Remote connectivity via Global Protect VPN, Remote Desktop & Screen Connect. Research patches and upgrades needed for various servers and Applications, such as Oracle RMAN Binaries, Cayenta & Tomcat. General review of Log Files, Events and Network Connectivity Issues.

Security

Research various TLS 1.0, TLS 1.1 & SSL Email & Application support issues. Make sure migrations comply with Data Security Policy in regard to PII, Firewall & IP Addresses. Review various MS-ISAC Cybersecurity Vulnerability Advisory Bulletins and PRTG Monitors.

PowerShell

Use PowerShell Scripts for various server level reporting and configuration such as; add Windows Features & Functionality for Migrations, Windows Tasks, ODBC, and list installed Apps, Services & Permissions. Scripts for IIS to create Websites, Apps, Pools, Hostname Bindings, retrieve various settings and set values.

Database

Review Database Migrations and track down TempDB file growth & hard drive space issues. Review DB connectivity on servers for migrations, review queries for active user sessions and connections.

Applications

Track down various issues with Applications and Services such as Granicus Civica websites, Phoenix Petro Vend, Laserfiche Service, CrimeNtel 503 Error. Review various Application info for migrations and setup such as DocuSign, HubSpot, HDL, Housing Pro Upgrade, Crystal Reports Runtime, CryWolf, CodeStat, Cayenta, Trackit Change Management.

MobileOnQ Migration

Migrate and configure IIS, DNS ODBC, test Web Services, review client configurations.

ArcGIS Omega Migration

Review ArcGIS Desktop / Omega Desktop / CrimeView and VBA install and migration for any potential conflicts.

Harris NorthStar Upgrade

Facilitate Digital Escort for vendor to perform upgrades to NorthStar, including review of live and test databases and existing documentation and support tickets, discussing details about relevant prerequisites and items ahead of upgrade, installing ftp apps for remote access, be available during upgrade. Review task scripts, track down issue with tasks not running after upgrade.

mCare & eCare Migration

Research and review mCare and eCare documentation and existing install items, discuss prerequisites with vendor to prepare for migration, such as, VBScript requirements, User permissions, Task schedules, Email functionality, IIS settings. Migrate all application functionality to new server and document.

Meter Reader Mobile Laptops

Review documentation, code files and client configuration. Schedule changes with laptop clients, replace old desktop icons, and update configuration files. Fix Issues with MapPoint, GPS & G2/T2 connectivity, test SSL, firewall rules, test new URLS, turn off old App Pools.

Payment Processing

Communicate with vendors about migrating various payment processing pipelines, Paymentus, Infosend, NorthStar, CryWolf, and Central Square. Change and test DNS and NAT for new Web Service URL API Endpoints. Test connectivity and run Payment Processing. Track down various errors including, ASP Timeout, 500 Internal Error, Recording Payment Error, Autopay Process Error, Validation Service Down, Real Time Notification Error.

Honeywell WinPak-Pro Reporting

Install Crystal Reports and create Tracking Reports for Buildings and Badges from WinPak-Pro data. Review decrypt functions for reading encrypted field data. Create SQL to analyze table data and find correct columns for final output, badge counts with custom day range, averages & totals, grouping & sorting, including pivot tables with dates to columns. Calculations for overlapping badge and location, and methods of retrieving nested linked records for location and device hierarchy. Create output and clean up formatting to for live Crystal Reports Server and exporting as csv.