Pick programmer/ IT programmer

KEENER MEREDITH

e-mail: **-*******@*******.***

Mobile: 214/714-1523

Programmer, Integrator & IT Consultant

Zumasys OpenQM Multivalue database systems

Zumasys “GUI Designer” (AccuTerm 7 & AccuTerm 8)

Zumasys “PhiReports” (AccuTerm 7 & AccuTerm 8)

Multivalue databases – R77 (Ultimate), R83, Advanced Revelation

Microsoft Access 2007 thru Access 2019 / Access 365 - Visual Basic for Applications

Microsoft Office 2007 thru Office 2016 - Visual Basic for Applications Access

& Excel VBA

Microsoft Visual Studio Code

VB6 (Visual Studio) & later

InterSystems Caché B-tree

Multivalue / Pick Databases & Coding

40+ years Pick & Pick-like database coding experience Zumasys OpenQM Zumasys GUI Designer

Zumasys AccuTerm 7 & 8 Zumasys “PhiReports” Pick R83 Advanced Revelation Ultimate (Pick R77) Caché 2008.2.2 Most Recent Employment

Used OpenQM to maintain an existing light manufacturing database at company that employs 180 people in a database environment with over 5000 Pick programs

Used Zumasys “GUI Designer” to modernize older Pick code Used Zumasys “PhiReports” to modernize older Pick reporting system Spearheaded an evaluation of iGrafx “Process” BPMN software for this company

* REFERENCES FROM THIS COMPANY'S CEO, IT DIRECTOR, & CFO AVAILABLE ON REQUEST. KEENER MEREDITH

e-mail: **-*******@*******.***

Mobile: 214/714-1523

Projects at Most Recent Employer

Trade Show project:

Designed improved cross-referencing front end for collection of contact information obtained via both the web and at trade shows.

Business Process re-engineering project:

Authorized by owner to do a 3 month preliminary analysis & proposal for using ERP diagrams to build “Process & database relationship blueprints”. The project goals were to diagram, analyze & propose alterations based on ERP diagrams. Used iGrafx “Process” software on Microsoft SQL Server on a virtual server running on Redhat Linux.

Zumasys “PhiReports” project:

Put in charge of proving that Zumasys “PhiReports” reporting software could replace MITS reporting software in a Pick/multivalue environment. Demonstrated feasibility of “PhiReports”, confirming that it could be used to replace MITS.

Phantoms/crontabs project:

A full systems crash happened in November & it was determined that there were over 80 crontabs & Pick “phantoms” that were part of the root cause of the crash. Was tasked with examining & documenting all of these to remove deadwood and streamline.

Zumasys “GUI Designer” project:

Learned to generate no-code/low-code Windows front-end programs using Zumasys “GUI Designer” because the plan that was put in place after the systems crash was to move from 100% on-premises Pick programs to 80% cloud-based Pick programs. Was tasked with the 20% involved in re-design on-premises programs. Programmed new GUI/Windows data display & data entry screens to begin the process of migrating to the new IT infrastructure. Management Experience

MIS director of operations, 32 users consulting firm. Designed & delivered custom coded tax compliance records management database system. System was used by consulting firm for 17+ years.

Systems analysis & Database design

Hardware & software purchasing

Project management

Custom programming & User Training

KEENER MEREDITH

e-mail: **-*******@*******.***

Mobile: 214/714-1523

Other Expertise

Algorithmic Trading Systems

Programmed a real-time pattern recognition engine; a pattern recognition processor that reads real-time streaming data & finds patterns that enable automated trades to be triggered. Pattern ID routines can be customized. This algorithmic trading system uses InterSystem’s Cache B-tree architecture & can track real-time tick data for 500 of the highest volume stock instruments. Sales: Document Imaging Hardware & Software

Owned and operated a full service computer consulting firm specializing in sales, installation and support of document management systems.

DataGold - Key-on-Image software

Eyes & Hands for Forms - High Volume Forms Recognition software & Data Capture & OCR/ICR & Mark-Sense

FileMagic - Scanning, imaging database, OCR, key-on-image

Scanner system and DVD Jukebox systems - sales & deployment

Custom programming to integrate document imaging products into existing client databases (Oracle, SQL Server, ODBC compliant back-ends)

Redesign & streamline records management in corporate environments

Migration of microfilm & microfiche systems into DVD jukebox based archival systems

Education & Awards

1973 – 1978 Texas A&M University - BA in History, minor in Anthropology 1972 1st Place, National Essay Contest, Valley Forge Freedoms Foundation

References available on request

KEENER MEREDITH

e-mail: **-*******@*******.***

Mobile: 214/714-1523

Business & Employment History

May 2019 –

June 2020

2003 - 2018

1992 – 2003

1989 -1992

1982 – 1989

1978 – 1982

DETAILS:

OpenQM Multivalue programmer – Applied Concepts, Inc. Active Trader & Algorithmic trading systems

Owned & operated Document & Database Computer Group Owned & operated Kayemco Enterprises

Director of Computer Operations - Meredith, Cochran & Parks Ad Valorem Tax Consultant - Meredith, Cochran & Parks Applied Concepts, Inc. - Support & maintenance of existing OpenQM database with over 5000 older Pick programs requiring maintenance. Worked on a project to implement new GUI user interface for Pick programs using Zumasys's

“GUI Designer” & Zumasys's “PhiReports”

Active Trader & Algorithmic trading systems: Designed & programmed real-time automated trading database using InterSystems Caché's high-performance B-tree to parse streaming datafeed delivered over internet. Tracked for trading purposes 400 high volume / high volatility stocks & ETFs using custom built computers running Microsoft O/S's. Coded trading system front-ends using Microsoft Office VBA, Access & Excel RTD). Wrote over 250 screening systems for active traders. Day traded 16 years.

Document & Database Computer Group: A full service computer consulting firm specializing in sales, installation and support of document imaging databases, records

management systems, forms recognition systems, and OCR/ICR/OMR/Mark-Sense systems. Database

programming for integrating document management systems into existing client databases. Sold & installed scanners and jukeboxes. Authorized reseller of FileMagic, Eyes & Hands for Forms, and DataGOLD software.

KEENER MEREDITH

e-mail: **-*******@*******.***

Mobile: 214/714-1523

Kayemco Enterprises: Pick consultant, systems analysis & programming: Ultimate, Pick R83, Advanced Revelation Meredith, Cochran & Parks: A 32 person tax consulting firm with offices in Dallas & Houston. Responsible for over 700,000 individual properties in the database. Designed & coded in as a multivalue Pick database.

Work History Example Projects

ZUMASYS “GUI DESIGNER” & “PHI REPORTS” EXPERIENCE / CASE: 2020 & 2019 - Programmed a new set of GUI/Windows data display & data entry screens to begin the process of migrating older Pick “Green Screen” data display / data entry screens on a mature database system for ACI in Richardson, Texas. There are approximately 180 employees & the database is 26 years old. The current data entry / data presentation layer is “Green Screen” and a custom Delphi Windows code set. The database and the Delphi code was all hand-written and proprietary. It had evolved rather than being designed and this “GUI Designer” / “Phi Reports” projects was the front end of an attempt to migrate to a Windows-based Zumasys solution.

INTERSYSTEMS CACHE EXPERIENCE / CASE:

Programmed a high performance real time algorithmic trading system, using Intersystems Cache's b-tree database. This is a near-real-time pattern recognition engine & event processor that reads streaming data and finds patterns in the data that can be used to make trading decisions. This program can handle real time tick data for 400 high volatility, high volume stocks AND perform pattern recognition in near real time on commercially available Intel based PCs.

ORACLE DATABASE EXPERIENCE / CASE:

Custom integration & programming for building construction company that used high performance forms recognition software, high speed scanners, jukeboxes for DVD archiving & a custom coded Microsoft Access front-end that was integrated via VBA & ODBC to the company’s existing Oracle back- end database. The system employed ICR (Intelligent Character Recognition) to eliminate key-punch operators entirely. The images were stored on DVDs in a jukebox that was connected to a local PC that had a custom Access VBA program on it that was used to query and retrieve documents. KEENER MEREDITH

e-mail: **-*******@*******.***

Mobile: 214/714-1523

MULTI VALUE / ULTIMATE (R77) PICK DATABASE EXPERIENCE / CASE: Designed, programmed, & managed an oil & gas tax compliance database for a consulting firm specializing in oil & gas tax consulting. Responsible for systems analysis, database design, purchase of hardware & software, programming, code testing, oversight of other programmers, user training, and code support. The database managed over 700,000 properties, coordinating compliance with filing obligations and deadlines for over 1300 property owners.

AS/400 EXPERIENCE / CASE:

Custom integration & programming that used high performance forms recognition software, high speed scanners, a proprietary back-end database, and Microsoft Office Access programming done in VBA. The system used ICR to read data off of appraisal documents & send it to a proprietary database on the client's AS/400. This system allowed data to populate the back-end database without having to be key-punched by data entry operators. The images of the scanned documents were stored on DVDs in a jukebox that was connected to a local PC that had a custom Access VBA program on it that was used to query and retrieve images of the documents. The client was a large professional appraisal firm.

Contact this candidate