John H Ho

Database Analyst and IT Professional

jho888@gmail.com
Chicago, Illinois, 60656

Summary

A Highly experienced Database Analyst and IT Professional seeking a challenging role in Database Analysis, Computer Programming, or related IT fields to leverage extensive knowledge and experience in web application development, database management, and technical supports. Over 20 years of comprehensive experience in database design and web application development. Extensive experience in system administration, resolving complex hardware, software, and network issues.

Experience

Principal Database Analyst, City of Chicago, Department of Finance

2018 – 2025

Administer IBM DB2, perform backup and restore operations, query and report design, data population, and data transfers. Manage IBM i series system, oversee Time and Attendance systems and biometric hand punch systems, and coordinate IT tasks.

Administer IBM DB2, perform backup and restore operations, query and report design, data population, and data transfers
Manage IBM i series system, including system upgrades, user management, firewall access, and SFTP server access
Oversee Time and Attendance systems and biometric hand punch systems, resolving issues for 700+ time clocks
Coordinate IT tasks such as software installation, firewall access, troubleshooting, and user training.

Senior Programmer / Analyst, City of Chicago, Department of Fleet and Facility Management

2003 – 2018

Developed, implemented, and maintained web applications, and managed PC upgrades, software application rollout, and troubleshooting software and hardware issues.

Developed, implemented, and maintained web applications, including Facility Work Order System, Overtime Management System, Project Tracking System, Facilities Inspection Application, and Energy Tracking System
Managed PC upgrades, software application rollout, troubleshooting software, and hardware issues

Computer Application Analyst III, City of Chicago, Department of General Services

1993 – 2003

Managed Oracle application and database administration, developed and supported MS Access and Paradox database applications, and provided technical support.

Managed Oracle application and database administration, including database application implementation and development.
Developed and supported MS Access and Paradox database applications, developed reports
Developed Overtime Tracking System (Paradox) and CIP Tracking System (Access)
Technical Support and troubleshooting software, hardware, and network issues

Education

B. S. Computer Science, University of Illinois at Chicago

1991

Skills

Programming Languages: PHP, SQL, Python, ASP.NET, VBA, JAVA, JavaScript, C, C++
Databases: MYSQL, DB2, Oracle, SQL Server, MS Access, Paradox, PowerBuilder, FoxPro
Web/File Servers: Apache, Windows server, IBM iSeries, LINUX, UNIX
Software: MS Office Suites, Business Objects, Tableau, Power BI, ArcGIS, Photoshop