Thomas G Sherer

760-***-****

ad4cc9@r.postjobfree.com

Objective: IT Project Architect, Prompt Engineer, Analyst, or Implementer Summary: Over 20 years’ experience in IS Development, Implementation, and Management. Roles have included:

IT Manager, Project Manager, Special Events Producer, System Architect, Progress/OpenEdge DBA, Sys Admin, Systems Analyst, Developer, QAD, and Trainer

Principal/Co-Principal of 8 Start-ups

Personally Developed/Launched six software products on national market

Co-Developed/Launched four software products & two peripherals

Created/Co-created 2 Nationally ranked Fine Arts and Quality Crafts festivals

Managed and plead a successful USPTO Court challenge and CA State Court suit

Proficient in Project Management (“Adaptive”), Systems Analysis & Design, Implementations and Conversions

Hands-on development with numerous languages on numerous platforms

Proficient with Progress / OpenEdge Database systems, especially w/ QAD

Practiced w/ Agile and Scrum methodologies and managed team resources

Knowledge of numerous business sectors, including: accounting, financial, insurance, legal, manufacturing, mortgage, retail, telecom, and utilities

Experienced Adjunct Lecturer, Trainer and Teacher Project Management:

Successfully implemented QAD 6 times, replaced 2, and upgraded 5

Successfully saved a QAD Mfg/Pro implementation in 6 weeks

Successfully implemented specialty software many times

Successfully created & launched 4 major spec software systems nationally

Successfully launched 2 major nationally recognized, annual Arts Festivals

Teacher/Adjunct Professor

QAD:

Implemented Mfg/Pro V7.2 thru QAD 2016 EE (usually alone) for Telecom, Hi- Tech, Electrical, Aerospace, Food Supply, & Pharma, and 2016EE with large team for Auto components.

Distribution Area: Heavily modified for AT&T (custom Logistics and Specialty Mfg, Hi-Tech Mfg, Auto Supply Chain, AeroSpace, Heavy Equipment Reman

Manufacturing Area: Modified MRP for AT&T, Auto Supply Chain, AeroSpace

Financial Area: Modified for AT&T adding Continuing Property Record sub-system from legacy data, implemented International Accounting for Pharma Technical

Languages: Progress 4GL / OpenEdge ABL, BASIC (several), FORTRAN, COBOL, RPG II, Assemblers (NCR, IBM, 8080, Z-80)

Page 1 of 9

Operating Systems: UNIX/*NIX/Linux/Coherent, Windows, DOSes, IBM MVS

(JCL), UniSys (Sperry) OS, Oasis/TheOS, Qantel, NCR (several)

Databases: Progress / OpenEdge (V5 thru V11.3), SQL, Snowflake

ChatGPT and GPT4 with add-ons

Certificates

Lean Six Sigma – course completed, candidate

Federal Individual Income Tax 2017 – H&R Block

Salesforce ADM 201 Certification – course completed, candidate

PMP – in progress; Member PMI-CIC, 14.75 PDUs

ITIL Foundation – in progress

Systems Analyst – American Management Association

Indiana Teaching License

Experience:

TEK Systems Apr 2022 – June 2022

Contracted to Autoliv, Sweden

Contracted to provide QAD ERP file & system information resources for several different QAD versions into a Snowflake Datalake project that is to pool all data from the firm’s various ERP systems within their operations. Project had to be curtailed because of the financial / resources contraints for EU countries caused by the Russian Invasion of Ukraine.

Kelly Educational Services Apr 2017 – Mar 11, 2020 Sep 2021 – Today

Indianapolis, IN

Title: Guest Teacher (Substitute)

Contracted to backfill daily teacher vacancies in the Metropolitan School Districts of Washington and Lawrence townships of Marion County, IN; and Clark-Pleasant Community Schools of Johnson County.

Predominantly, I have filled vacancies for High Schools and Middle Schools in English, STEM, Social Studies, foreign language classes, Arts classes including Orchestra, and Ag. Yash Technologies Jan 2021 – Nov 2021

Contracted to Caterpillar, Inc.

Title: Sr QAD Business Analyst

Attached to Center of Excellence (COE) in the UK to assist in their global QAD ERP

“lift & shift” upgrade of 15 yo onsite Mfg/Pro implementation into the QAD Cloud. My primary responsibilities were Analysis and Specification of User customization requests from 2 plants in the States, and shepherding those requests between an off-shore Development team of 1 and the Requesters; the COE liason to architect and drive the launch of QAD data into a Snowflake Datalake; and COE liason to a global ERP Master Data Management Change Control and Security project. Team for launch of 1st plant. Page 2 of 9

Critical River Apr 2020 – Jun 2020

Title: Senior QAD Technical Consultant

Project: Viavi Solutions ERP systems consolidation Contracted to augment ETL effort required to move data of an UK plant from its QAD ERP system to Oracle 12 as part of a internal reorganization. Worked with/for UK staff for the needs of the San Jose HQ’s timeline.

Yash Technologies Dec 2017 - Oct 2018

Title: Senior QAD Technical Consultant

Contracted to QAD

Project: Phoenix Project for Yanfeng Automotive Interiors (YFAI) Member of QAD Augmented Resources Team of Business Process Analysts Johnson Controls, Inc divested much of its automotive manufacturing business to a consortium of Adient and YFAI (China) about 2016. The two firms decided to focus on separate areas, but were united by their highly-customized QAD Mfg/Pro ERP system, a mix of eB/eB2 versions circa 2000 along with a variety of special purpose software and spreadsheets. YFAI opted to move forward with QAD’s Cloud 2016 offering and separate itself from the Adient system. Phoenix Project was to perform that Siamese twin software systems separation and upgrade/migration for more than 40 plants around the World. Our team of 5 was charged with performing business process surveys, systems analysis with Gap analysis studies between each Plant’s “Needs” and

‘core model’ offerings, staff re-training, UAT signoffs, migration guidance and management, followed by post-migration on-site support. Our team completed studies on 7 of 24 North American plants, training and support at 5 and UAT at 3. My analysis and training focus were Customer Scheduling and MSW/PSW. Bentley Global Resources / Bartech Group Feb 2017 - Aug 2017 Contracted to Eaton

Project: UNIFY Project augmentation

Title: Sr QAD Consultant

Supported QAD enhancements for Aerospace and Hydraulics division during implementation of corporate wide unified ledger system

140+ QAD instances from V8 thru eB2.1 2007

Created full MRP ATP calculator for Aerospace division

Implemented ASN EDI redesign for Hydralics division

Implemented urgent changes for Aerospace and Hydraulics Divsions in US, EU and India

Smith Anderson, LLC Indianapolis, IN Dec 2014 – Feb 2017 Contracted to 1st Tek, subcontracted to Wipro

Client Nationwide Mortgage, Columbus, OH Aug 2015 – May 2016 Project: Data Center Relocation / Platform Upgrade / CFPB Mandate Implementation Title: DBA / Developer

Supported Fiserv UniFi Pro Mortgage Origination system through relocation of system from out of State with attendant departure of knowledgeable staff and documentation

Implementation of new Dodd-Frank CPFB regulations

Preparations for upgrade from Windows Server 2003 to Server 2008 Page 3 of 9

Subcontracted to Strategic Systems

Client: Sherwin-Williams Co Dec 2014 – Jun 2015

Senior Technical Consultant - Developed programming to allow the elimination of Sherwin Williams's corporate mainframe by transferring Store Sales data from 4300 Progress-based POS systems via MQ to Data Warehouse. QAD, Inc. Mount Laurel, NJ Feb 2014 – Dec 2014

Sr Cloud On-boarding Manager – Project Manager/Developer

Plan, install, and customize ERP systems for new sales of QAD Cloud

Convert / Load Client’s legacy data into QAD ‘Cloud’ 2014EE environment

Responsible for installation/setup of all specialty add-on and bolt-on software packages sold (e.g. barcode, CRM, Dynasys, and Mobile Browse) Smith Anderson, LLC Indianapolis, IN Dec 2012 – Oct 2013 Contracted to Vaco Sep 2013 – Oct 2013

Client: International Paper, Memphis, TN

Sr Mfg/Pro Consultant – Contracted to support data merger/conversion for an acquisition that was called off on the eve of project start. Contracted to Oxford International Dec 2012 – Mar 2013 Client: Hansen Medical, Mountain View, CA

Sr Technical Consultant – Contracted to provide emergency DBA support for QAD Mfg/Pro implementation during contract negotiations. Palm Springs Arts Festival, Palm Desert, CA Sep 2007 – Aug 2013 Producer of this series of three Fine Arts and Quality Crafts festivals featuring nationally and internationally regarded juried artists and artisans. With a part-time staff of 4, these festivals achieved national attendance and high critical acclaim. My responsibilities included management, production & staging, finance & accounting, special events planning, artist relations & recruitment, venue acquisition, advertising & marketing, site logistics & info systems development Comcepts Systems, Palm Desert, CA Nov 1989 - Jan 2014 Principal Enterprise Systems Consultant

Roles included: Acting IS Manager, Project Manager, DBA, Progress Developer, QAD Technical Consultant, UNIX and/or QAD Systems Administrator, and QAD Trouble- shooter.

Contracted with Smith-Anderson Corp, Indian Wells, CA Sep 2012 – Mar 2013 Client: Eastern Municipal Water District, Perris, CA Sr Technical Consultant - Implemented extensive reusable code changes to simplify ongoing enhancements to COINS Customer Service and Utility Billing System. Contracted with Smith-Anderson Corp to Aug 2005 – Apr 2009 Client: Eastern Municipal Water District, Perris, CA

Member of Development Team devising a new concept for User-based water conservation, the “Water Budget-based Tier Billing” algorithm, to encourage Customers to save water during California’s ongoing Drought. (2008 -09) Page 4 of 9

Performed conversion of Progress-based COINS Customer Service System to an Oracle system for an attempt to change platforms. After sufficient data was populated, the Water District realized Progress & COINS were a better solution and abandoned the project. (2006-7)

Developed Data Exchange from COINS into Oracle Data Warehouse (2005) Contracted by Oxford Consulting, Indianapolis, IN Oct 2003 – Aug 2004 Client: Superior Essex, Ft Wayne, IN

Installation of a new Sarbanes-Oxley-compliant QAD Mfg/Pro EB2 to replace a custom mainframe system - following a failed SAP implementation for the firm that invented “mag wire” and auto wiring harnesses

Developed custom modifications to Mfg/Pro’s Picklist including transformation to PDF from standard and bar-coded Picking Labels

Developed data exchange of QAD data into the XML printer sub-system I created Client: Irwin Mortgage Fishers, IN

Member of Fannie Mae award-winning project team that brought email transmission of documents and closing checklists to Lakewood Mortgage Origination system thereby saving Buyers countless days and $Millions in expenses. Indian Wells Arts Festival, Palm Desert, CA May 2002 – Aug 2007 Producer/Co-Director of this juried and judged Fine Arts and Quality Crafts festival.

The 5th Festival (2007) featured over 9000 paid attendees, 215 nationally and internationally recognized Artists, with in excess of $900,000 in sales.

2007 show included star-studded JazzTrax “smooth Jazz” concert.

Festival was awarded Sunshine Artist's 200 Best festival national award. My responsibilities included management, production & staging, finance & accounting, special events planning, artist relations & recruitment, venue acquisition, advertising & marketing, site logistics & info systems development. Simultaneously, I successfully managed and plead pro se a 6 year challenge action in the USPTO Court to the obtaining of a TM and SM for Southwest Arts Festival by way of fraudulent application, and managed a successful concurrent State Court suit action. Southwest Arts Festival, Palm Desert, CA Sep 1999 – Aug 2007

Assistant Director of this national award-winning, juried and judged Fine Arts and Quality Crafts festival

Acting Director for the 13th festival in 2001 owing to incapacitation of Director

2001 Festival enjoyed 11,000 paid attendees, 195 nationally and internationally recognized artists with sales of $950,000

2001 Festival was awarded a Sunshine Artist's 200 Best festival national award My responsibilities included management, production & staging, finance & accounting, special events planning, artist relations & recruitment, venue acquisition, advertising & marketing, site logistics & info systems development. Page 5 of 9

Comcepts Systems, Palm Desert, CA (cont) 1999 - 2002 Client: AT&T at new acquisition AT&T Alascom Anchorage, AK Title: Complex Systems Engineer

Performed roles of IS Manager, Project Manager, DBA, SysAdmin & Developer

Managed AT&T’s Alaska Logistics data center for Alaska and DOD

Converted Western Electric's (now Lucent) highly customized proprietary GISA version of Mfg/Pro V7.4F to “vanilla” Mfg/Pro 8.6e, along with the Db modifications, proprietary “Foreign System Interfaces” & special functionality necessary for AT&T

Re-interfaced Mfg/Pro S/O and P/O functions with AT&T legacy warehouse & ordering systems.

Subsequently re-interfaced the S/O and P/O function to AT&T’s new Oracle systems.

Contracted by Smith-Anderson Corporation, Indian Wells, CA Aug 1998 – Oct 1998 Client: Eastern Municipal Water District Perris, CA Sr Technical Consultant

Developed major changes to the business logic for water conservation and billing of the Progress-based RUBS II Customer Servicea and Billing system Contracted by White Star Software Jan 1998 – July 1998 Client: Auspex Systems, Santa Clara, CA

Title: Project Manager / Progress DBA

Righted a sinking QAD Mfg/Pro implementation. The prior PM of which had walked off the job with his documentation six weeks before Go-Live leaving the implementation leader-less and ready to fail

Succeeded hitting the Go-Live with a re-structured implementation plan and the yeoman effort by our team of 3.

Performed trouble-shooting for problems with corporate intranet and programming errors within Mfg/Pro's V8’s "best pricing" feature and tran_hist

Installed Intersolv and OpenLink ODBC software for testing with Business Objects report writer software

Contracted by Analysts Express, Houston, TX to NCR Corp Aug 1995 – Dec 1997 Client: Siemens Business Communications

Title: Senior Technical Consultant

Provided administrative and programming support for Siemen’s Order Entry / Logistics interface between Astea's Progress-based Dispatch-1 running on AS- 400s and their AMAPS manufacturing system on an IBM MVS S/390 system Client: AT&T Alascom Anchorage, AK

Title: Complex Systems Engineer

(Functioned as IS Manager, Project Manager, UNIX SysAdmin, Progress DBA, Analyst/Programmer) and Sole Support for Alascom Logistics Dept. Alascom provided DOD communication line and hardware support for the Pacific Theater, DEW Line, ARAPA-Net, and NORAD, as well as carrying Consumer long-distance traffic in Alaska through the period of simultaneous AT&T acquisition of Alascom and AT&T’s "tri-vestiture"

Page 6 of 9

Installed and implemented the Western Electric-enhanced "GISA" version of QAD's Mfg/Pro V7.2 system utilized for Logistics/Distribution

Installed, tuned, administered and upgraded AT&T / NCR UNIX OS (MP- RAS) multiple times

Converted 3 legacy systems into Mfg/Pro

Customized, supported and upgraded Mfg/Pro from V 7.2 thru 7.4D

Customized Mfg/Pro shipping module and numerous add-on programs to Mfg/Pro to accommodate special needs with a simplified, consolidated user interface

Performed software upgrades for Progress V6 to V7 and NCR UNIX

Developed custom Continuing Property Record (CPR) system (Fixed Assets) and implemented G/L accounting for division.

Provided front-line (and the last-line) end-user application support and systems technical support

Developed all daily, nightly, and weekend batch jobs

Operating Environments: Progress 4GL, Unix V.4.3, NCR 3455, AIX, RS6000, COBOL, DB2, MVS, JCL, WFW 3.11, Windows 95, Windows 98, Windows NT

Joint Venture with Smith-Anderson Corporation

Co-Developed RUBS II, a spec Progress-based Water Utility Customer Service & Billing system. First sale was to one the largest Southern California water districts. I converted 20 years of legacy data from COBOL into Progress Db. Prior IT Positions and Projects

These experiences are some of my most important work. Employers / Clients ranged from school districts, quasi-governmental agencies, state government to S/W houses, mid-sized retailers, large grower/packers to small, service & professional offices.

Titles: IS Manager, DBA, *NIX Administrator, Package Software Developer, National Marketing, President, Lead Systems Analyst, Systems Integrator, Programmer

o Developed a “Workers Comp” cost recovery system for State of California to ensure MediCal Healthcare would be repaid from Workers Comp settlements o Developed a Progress/UNIX-based hospital cost recovery system for 100 hospitals, and performed a conversion of functionality and data from a 70's legacy 8-bit multi-user system

o System support of FAMOUS grower/packer accounting system o Beta-tester for Seiko Computer for their implementation of TheOS o Software Support for multiple Southern California school districts o Conceptualized, Developed, Marketed and Supported PakMaster, a Inventory, Sales, Shipping and Accounting system for Produce growers/packers o IS Manager for Western Region of Tarmac Roadstone, LLC, the multinational heavy construction and aggregates firm

o IS Manager for City of Palm Springs

o Charter bus reservation/billing system

o Conceptualized, Developed, Launched, Marketed, Supported nationally advertised software packages: AdvanTax 1040, Advantax 1065, Advantax Page 7 of 9

1120, and General Ledger Client-Writeup for Tax Preparers and Accountants, and Office Manager, a BICARSA system for small businesses. o Co-developed and Marketed Plant Manager MRP II system. o Support of banking and credit union systems (NCR) o Support of International charity payroll and accounting system (NCR) o Co-developed and Marketed Passage, 1st color screen cash register (POS) with online pricing, inventory and sales info

o Retailer/Distributor accounts receivable system

o Support of bank mortgage loan system

o Precision gear engineering programs

o Co-developed Universal Data Entry (UDE), a BASIC database management system with interactive user-operated screen generator and report writer o Co-developed target-triangulation location software used by DOD for targeting o Co-developed Vidiet*Stik, programming and marketing for patented lightpen o Supported and extended payroll system for a multi-national charitable organization o Cash management systems for Wheel Horse Products, Div. of AM General Think Snow Ski Shops, Inc., South Bend, IN

President: Operated specialty sports stores featuring skiing in 3 shops in IN, MI & Vt for 7 years

Associates Finance Co of North America, Div of Gulf & Western, South Bend, IN

Senior Analyst/Programmer for multi-national Payroll, USAC and Montgomery Ward Auto Clubs, several Insurance systems and multiple Banking systems for 1st Source Bank.

Operating Environments: NCR and IBM mainfraimes, NCR minis, MVS, S3/36, DEC, RS/6000, COBOL, IBM JCL, Windows 3.11/95/98/7/10, BASICs, OASIS / TheOS, Qantel, Xenix

College-level Computer/Business Adjunct Lecturer:

College of the Desert Palm Desert, CA

National University Palm Springs, CA

Indiana University at South Bend South Bend, IN

Indiana Vocational Technical College South Bend, IN Michiana College South Bend, IN

Instructor: English, Introduction to Computers; Introduction to Retailing, Introduction to Mini/Micro Computer Concepts, Introduction to BASIC Programming, and Business Programming Practicum.

Page 8 of 9

EDUCATION

Undergraduate: B.A. – University of Notre Dame

Major: Sociology – Sociometrics; Minor: English

Graduate: M.A.T. 6 hrs - Chicago State University

M.B.A. 9 hrs - Indiana University at South Bend

ACTIVITIES and AFFILIATIONS

PMI – Central Indiana Chapter – member

Ohio Progress Users Group - member

Bay Area Progress Users Group - member

Southern California Progress Users Group - member and treasurer (past). Event Planning & Management Association – member

Other SIGs – Event Managers, Event Planning & Event Management, Database Experts, QAD Community, Cloud Computing

Personal and professional references available on request. Page 9 of 9

Contact this candidate