Thomas L. Forbes

Software Associates, Ltd. **** Darcey Way

**** ******** **** ***** * PMB 492 Fort Mill, SC 29707 Fort Mill, SC 29708 adzs1m@r.postjobfree.com

Career Biography:

Strong, diverse background in systems engineering and software development. Technical development and support of complex systems in the electric/gas utility, banking, discrete manufacturing, healthcare and textile industries utilizing analytical and problem solving skills to achieve best-practice results. Have effectively managed multiple projects and acted as technical lead. Maintain the highest level of professional and personal ethics; well-versed in regulatory requirements. Proficient in use of current technology to support mission-critical business goals and information security. Computer Qualifications:

Database Development: ORACLE Server (9i/11g), PRO*C, ORACLE Forms (6i/10g), PL/SQL, SQL, PostgreSQL, ORACLE Application Server/Portal (10g), ORACLE OUB (Lodestar) Product Suite, ORACLE Data Pump, Netezza Database Development (UDP/UDF), DB2 Fundamentals for ORACLE Developers – IBM Certification Bootcamp Development & Tools: JAVA (J2EEv1.6), JavaScript, UNIX shell scripts, OSI PI Processbook (v3.0), TOAD (v12.0), Websphere (5.1), Informatica, ODBC/OLE, XML, HTML, TCP/IP, GNU C++,ANSI-C, Microsoft C++, perl, Eclipse (v4.4), CORBA, UUCP, Itron MV90Xi, Rogue Wave (h++), Mercury Loadrunner/Test Director, FORTRAN, ANSI-COBOL, BASIC, PASCAL, RPG-II, RS/1, DBMS, FMS, LIMS, CP/M, dBASE-III, DEC C, DBMS, VAX-C, sftp, ftp, Borland C++, python, CA Workload Automation (ESP), Changeman DS, Piccaso, H-P Quality Center, ServiceNow, Remedy, QPasa! CM Manager, TIBCO Spotfire Reports (v3.0), Talend ETL (TIS 4.1), AGILE Methodology, ITIL, SDLC Methodology, JIRA, Autosys, NDM, Subversion, Jenkins, Control-M, AWS Lambda Operating Systems: LINUX, HP-UX, AIX, Windows NT/95/98/XP/2003 Server, Redhat LINUX (E5), UNIX, OSF/1, DG-UX, OpenVMS, OS/2 (v2.11), VAX/VMS, MS-DOS, PICK, RSX-11M+, Windows Server 2008 R2 Hyper-V, MacOSX, Ubuntu LINUX, VMware-ESXi (v5.5) Management, CompTIA LINUX+, CompTIA Cloud+, SUN OS (v5.1) InfoSEC Training: CompTIA Security+, C EH, Computer Forensics, Vulnerability and Penetration Testing, SANS Basic Cyber-Security, Cryptography, Wireshark, Metasploit, OpenVAS, nmap Hardware: SUNSparcStation 1000, HP-9000, IBM RS/6000 series, Compaq-386/20, Everex 386/25, HP Vectra 386/33, DEC 5000, Motorola 88xxx, DG-AViiON 9000, DEC Alpha (RISC) Series, GE kV2 (ANSI 12.19) Meter, VECTRON Meter, VAX 11/780, Rainbow 100+,CYBER-18, mVAX-II, VAX 8800, VAX 6xxx/3xxx series, iMac, SUN SPARC Professional Experience:

May 2022- Software Associates, Ltd. - Winchester, VA March 2023 [Contract] Database Developer [remote]

Development and implementation of C, ORACLE PRO*C, PL/SQL, SQL(ORACLE 19)/UNIX shell script codesets used to support an MMIS (Medicaid Management Information System) for the state of Pennsylvania. Responsible for design, development, documentation and coding of routines to extract/report/manipulate financial, claim, drug rebate and other medical related data for Medicaid recipients. September 2021- Software Associates, Ltd. - Charlotte, NC May 2022 [Contract] ETL Data Engineer [remote]

Development and production support for SAP Data Service routines, BASH shell and SQL scripts (ORACLE 12c & 19). Responsible for daily infrastructure (utility, timekeeping, financial, GIS) dataset management. Datasets involve sourcing encrypted data from flat files, zip files and proprietary/public data feeds with target data transferred to ORACLE databases. March 2021- Software Associates, Ltd. - Charlotte, NC July 2021 [Contract] ETL Developer [remote]

Developing ETL processing library routines (in python v3.5) for standardized ingestion of large datasets (financial files and feeds) for the SEC ODS (Securities and Exchange Commission - Office of Data Science). Responsible for daily, weekly, monthly and ad hoc datasets management. Datasets involve source data from flat files, zip files and proprietary/public data feeds with target data transferred to ORACLE, Netezza and Hadoop databases. Used ServiceNow for defect tracking. February 2020- Software Associates, Ltd. - Charlotte, NC July 2020 [Contract] IT Developer

Responsible for support of an AWS block-chain application for Organic Tracking of P&G cotton products using IFS

(Internet File System), python (v3.8), Lambda and DynamoDB. Supported web-based application for order management of Bed In A Box products. Developed Talend ETL Report monitoring tool to validate long running tasks (using python and MySQL).

February 2018- Software Associates, Ltd. - Charlotte, NC May 2019 [Contract] Systems Engineer

Responsible for production support, development and maintenance of Vanguard Life Insurance/Annuity Record Keeping System (ARK) under LINUX/UNIX operating environments utilizing web-based JAVA, C/C++, ORACLE (v12c) and shell scripts. Used ServiceNow for production software defect tracking. Developed korn shell/SQL scripts to facilitate operational functionality and enhancements in an Agile framework. December 2015- Software Associates, Ltd. - Charlotte, NC May 2017 [Contract] Application Systems Engineer [remote] Responsible for support, development and maintenance of Wells-Fargo Bank Wholesale Risk Control System (RCS) application under LINUX/Solaris UNIX operating environments. Developed csh/bash shell/SQL scripts to facilitate operational functionality. Used/developed Autosys, Remedy (PAC2000), ORACLE and shell scripting for this purpose. Managed IAM interface system feed for Treasury Management Risk Services department business user access. April 2015- Software Associates, Ltd. - Charlotte, NC November 2015 [Contract] Database/ETL Developer

Responsible for support, development and maintenance of ETL framework components within a Netezza Retail Data Warehouse executing under LINUX operating environment. Developed bash shell/SQL scripts to facilitate data functionality in a retail sales environment.

December 2013- LPL Financial - Charlotte, NC

December-2014 [Employee] Senior Database Engineer

Responsible for support and maintenance of various mission-critical ORACLE/Informix based applications executing under UNIX/AIX operating environments. Developed SQL scripts, ORACLE Forms and PL/SQL procedures/packages to enhance the LPL Financial Commission and Registration (COMREG) product functionality (ORACLE 10g/11g). January 2013- Software Associates Ltd. - Charlotte, NC December 2013 [Contract] Consultant-Engineer

Performed LINUX design and development enhancements on a Tire Inspection Portal application (TIP) for the trucking industry. Created and documented data structures, architecture and documented OOP codesets (in C/C++). Developed upstart jobs to launch applications and wrote supporting bash shell scripts. Used OpenCV API code to implement increased functionality.

July 2012- Software Associates Ltd. - Charlotte, NC December 2012 [Contract] Consultant

Performed defect management and enhancements on an ORACLE 10g Forms based internet application for Chemical Management and Inventory Tracking (CMS). Used DoE procedures and security protocols. Created and documented new data structures, re-architected forms from baselined codesets for future porting to a C#/.NET environment using Toshiba tablet PCs and RF transponders.

September 2011- EPI, Inc. - Fort Mill, SC

July 2012 [Contract] Consultant

Designed and developed database application for a Residential Real Estate Property Management firm. Used mySQL and PHP scripting to create intranet application for property tracking and management. Created data repository scripts and GUI usage screens for daily maintenance activities.

October 2010- Bank Of America - Charlotte, NC

June 2011 [Contract] Senior Database Developer

Developed large-scale aggregation modeling PL/SQL routines for use by the web-based, QRT (Quantitative Risk Technology) group application in the bank’s Commercial Loan Forecast division. Developed ORACLE (v10g) analytic routines, as well as, general purpose utility code (written to support the data modeling activities). Developed Talend (ETL) jobs to support file transfer activities (Teradata DW to SQL Server/ORACLE databases). Support for all database related support activities (design, implementation, user support and deployment) involved with the production instance and acted as database team lead, using AGILE methods to achieve project goals (daily stand-ups, 2 week iterations, etc.). March 1997- Siemens Metering AG - Zug, Switzerland Oct. 2010 [Contract] Senior Systems Engineer - Charlotte, NC Utilized C++ framework to refactor/develop enhancements to existing AMS (remote data collection central station) on OpenVMS/LINUX platforms. Developed C++ code to support GUI, data collection and database access. Developed JAVA interfaces (using JDBC/XML/ORACLE/ SQL Server 2000/DB2) to support a field-based Mobile Work Management System (MWMS) using IBM Websphere, bcp and sqlcmd and Meter Laboratory Inventory Control System interface using SWING (JDBC/SQL Server 2005) and TNS Headend DST translation system. Responsible for the design (using MVC model), development and support of several electric utility automated metering systems (AMS) written in C, C++, XMotif and ORACLE Forms using PRO*C (ODBC/OLE), PL/SQL and ORACLE Server (v7.x-9.2). ORACLE (v9.x) Database Adminstrator (DBA) function for application user setup, database backup and upgrades. Oct. 1995- Comprehensive Computer Consulting, Inc. - Charlotte, NC March 1997 [Contract] Process Engineer

Responsible for the design, test, documentation and implementation of multiple operating system platform data interfaces (SCADA/Near Real Time) using C, TCP/IP sockets (AXP OpenVMS, RS/6000 AIX, Windows NT). Implemented ORACLE (v7.x) bi-directional interfaces (using SQL*LOAD, GNU-C, DEC C and SQL scripts). Developed remote serial device data collection routines in UNIXshell, perl and ProComm+ scripts. Aug. 1995- Business Process International, Inc. - Winston-Salem, NC Oct. 1995 [Contract] Business Consultant

Migrated and partially recoded RSA-based C routines from an OS/2 (v2.11) platform to HP-UX (v9.0). Application involved Online Banking (dialup) retail customer remote access for Wachovia Bank (using MVS/CICS data warehouse). April 1995- Computer Task Group - Charlotte, NC

Aug. 1995 [Contract] System Consultant

Responsible for technical support of a commercial bank loan application for First Union Bank using ORACLE

(v7.1) and AmiPro (v3.1) under OS/2 (v2.11) in a Novell Netware (v4.0) TCP/IP LAN environment. Feb. 1995- American Computer Professionals - Columbia, SC April 1995 [Contract] System Analyst

Designed and developed SQL*FORMS(v3.0), PL/SQL scripts and SQL scripts to add, query and update

(OpenVMS/HP-UX, Oracle v6.0/7.0) CIS database.

Clearances: Public Trust (SEC - 2021)

Secret Clearance (DISCO/DoD - Inactive)

Association Memberships:

ACM (Association of Computing Machines) IEEE Computer Society Education:

M.Sc. - Database Systems (Regis University - Honors) PGC - Data Communications Systems (Brunel University) ASc. - Computer Programming Certificate (Control Data Institute) B.Sc. - Biology (University Of Maryland)

Professional References Upon Request

Contact this candidate