Security Clearance Pharmacy Benefit

Thomas B. Burrows

Mobile #’s 469-***-****

Email: ******.*******.****@*****.***

LinkedIn: Thomas Burrows LinkedIn

Job Title: Information Analyst / Programmer Analyst

Career Summary:

Senior Programmer/Analyst with 10 Plus years of experience in various disciplines as Banking, Pharmacy Benefit Management, retail,warehousing and Architect experience with IBM Power Servers “iSeries” with Free Format RPG and Production Support on the IBM iSeries.

Security Clearance: Top Secret E.B.I. (Extensive Background Investigation)(inactive)

Certifications: Certified Oracle DBA

Programming Languages:

IBM iSeries Stored Procedures, ILE RPG/400 Free Format with embedded SQL, ILE COBOL 400, CL/400 ILE, Java, C#.NET, VB.NET, PL/SQL & Oracle 11g, PHP, Microsoft AZURE, SYNON Development, DB2 Administration Support. LINUX

Operating Systems:

OS/400 – V7R5, UNIX, Linux, Windows 2012 Professional, Windows 10 & 11.

Software Utilities:

DB2, DBU, Rational Developer for I, ALDON, TURNOVER, IMPLEMENTOR, MKS, Visio, EXCEL, WORD, RxClaim, SYNON, & PATHFINDER/HAWKEYE, HMC, and iSeries API’s

Applications:

Mortgage Banking Support using Stored Procedures – Bank of America, Healthcare - Health Smart – medical insurance, Retail Grocery Warehousing, Telephony, Life & Auto Insurance, Systems Programming - IBM Rochester, Defense Communications NORAD/Cheyenne Mountain - Colorado, Data Warehousing and iSeries Security, insurance, Pharmacy Benefit Management – CVS Caremark & Prime Therapeutics, RxClaim. RETAIL with major grocery store chain and SYSCO at Houston corp HQ.

In 2004 worked with Republic Services to implement container management using USPS and GPS data.

Employment Summary:

September 2020 – Prresent Collins Computer Technology – Contractor/Programmer

Production support of existing systems PBM “Pharmacy Benefit Managerment” handling via calls from operations on IBM Mainframe and AS400 platforms in RPG Free Format.

Supported both RPG – FREE FORMAT – and iSeries COBOL code.

Created/updated programs using SYNON for PBM systems.

iSeries Administration

Heavy use of embedded SQL in RPG ILE programs.

Used the RPG-XML suite to compose and parse XML and JSON objects.

Stored procedures and use of TRIGGERS

Application of API’s to improve program performance.

Amazon Web Services..

RxClaiim support.

Developed and supported Web Services on IBM I Power Server.

C#.Net frontend “internet” connecting to an IBM iSeries.

August 2018 to August 2020 – Infosys LTD – Contractor/Programmer

Design, programming, and installation of RPG-ILE and COBOL-ILE programs to support credit card protest system using IBM Image 400 system via IBM i Java based API’s.

Using the AGILE environment to work with other team members in transitioning core Sysco AS400 functionality to CLOUD service providers.

WMS support and upgrades.

Used REST via JSON to invoke web service messages via ILE.

Embedded SQL work inside RPG ILE programs.

JavaScript

IBM WebSphere Application Server

Developed and supported Web Services on IBM I Power Server

Retail support per sales tax systems for SYSCO at Houston HQ.

CICS support in banking system while using MQ to handle communications between different platforms at Bank of America.

December 2017 to August 2018 – Collins Computer Technology – Contractor/Programmer

Analysis support of PBM “pharmacy benefit management” loading of new files.

Designed test plans and procedures

Supported both RPG – Free Format – and iSeries COBOL code.

Updated programs using SYNON for Pharmacy Benefit Management systems.

iSeries Administration – Storage based Replication. Independent Auxiliary Stoarage Pools.

Used API to help develop user profile authority resets for system operators.

Developed and supported Web Services on IBM I Power Server

August 2017 to December 2017 – Bank of America – Contractor/Programmer – Addison, TX

support of Bank of America LAMPS – mortgage – system – using IBM iSeries AS400 RPG ILE Free Format and iSeries COBOL with change control TURNOVER.

Development of Java programs.

Development of C#.Net programs

Supported credit card applications.

April 2017 to August 2017 – IBM – Programmer – Eagan, MN

Analysis support of new PBM “pharmacy benefit management” share on share plan for Walgreens RX project.

Client representative for five offshore IBM iSeries RPG and COBOL resources.

QA check for code quality and requirements.

Supported iSeries COBOL systems.

Created and updated programs using SYNON for Pharmacy Benefit Management systems.

MAY 2016 to March 2017 – Collins Computer Technology- Programmer

Programming support of Financial systems utilizing embedded SQL in COBOL on the IBM AS400/iSeries platform supporting credit card operations.

used change control tool TURNOVER.

Maintaining and development of existing service programs.

iSeries administration

OCTOBER 2015 to April 2016 – Bank of AMERICA - Programmer – Addison TX

Programming support of mortgage auditing project utilizing embedded SQL in RPG and service programs on the IBM AS400/iSeries platform for credit card operations.

Extensive use of change control tool TURNOVER.

Debugging and modifing existing programs.

November 2014 to September 2015 – Collins Computer Technology – Programmer

Rewrite Legacy election billing System using RPG ILE on the IBM AS400 Power 7.

Support existing election software system with modifications and bug fixes.

New RPG development using RPG ILE and COBOL ILE using embedded SQL on the AS400/iSeries.

July 2014 to October 2014 – Frontier Communications – Contractor/Programmer- Addison, TX

Support conversion of land line data from AT&T to Frontier Communications using RPG and COBOL based programs with heavy embedded SQL on the AS400/iSeries.

FTP to transfer Files from AT&T to Frontier systems.

Modifications to CL & RPG programs to unload EXCEL files received from AT&T.

Ran conversion progress “12 to 15 hours” in test mode.

March 2014 to June 2014 – CVS Caremark – Contractor/Programmer – Richardson TX

Develop ETL system for large non-iSeries pharmacy files to RxClaim database system on the AS400/iSeries using:

Updated programs using SYNON for Pharmacy Benefit Management systems.

RPGIV and CL with the iSeries ILE environment.

March 2013 to February 2014 – Collins Computer Technology

Support and enhancement of iSeries/AS400 ERP system using RPG and CL within the AS400 ILE environment.

Support of interface to SAP systems:

Support of C#.Net programs interfacing with iSeries/AS400.

Classes from HP University on various part of SAP.

August 2012 to March 2013 – CVS Caremark – RICHARDSON TX

Administration support of iSeries development platforms. DASD space management, operating system updates, and informal helpdesk support for developers.

AS400/iSeries support position managing testing environments in RxClaim.

Studied and performed analysis of SYNON programs.

Analyzed Business Requirement for Test Strategies, Test Plans, and Test Cases.

Automated environment build and Testing tools.

Triaging of Environment build Problems in RxClaim.

Fully versed in SDLC “software development Life Cycle”.

knowledgeable of iSeries SQL for data analysis for environment builds and problem analysis.

Understand how the offshore and on site model works.

Managed environment builds from programmers using QC “Quality Center” Tool

Managing Job descriptions, user profiles, DASD space usage by developers.

Set up FTP processes to move data from external sources to RxClaim iSeries files/tables.

Handle change control process that determined what files got pushed to what particular production platforms. Updated control files that were used by internally written process to determine what data was put in testing files for developers.

Investigated user profile provisioning to report back to security teams per what profiles lacked so programmers could do their job.

Updated programs using SYNON for Pharmacy Benefit Management systems.

Used API to help develop user profile authority resets for system operators.

February 2012 to June 2012 – Health SMART – Contractor/Programmer – Irving, TX

iSeries ILE RPG and COBOL programming supporting health insurance processes on the AS400/iSeries.

Protyping C#.Net & VB.NET front iSeries programs to replace traditional iSeries Green Screen data entry.

System administration supporting worked with operations to handle user profile provisioning.

Updates to Billing systems as needed.

February 2011 to October 2011 – Bank of America – Contractor/Programmer – Addison, TX

AS400/iSeries ILE RPG and Stored Procedures interfacing with SQL SERVER Java program calls supporting credit card operations.

Developed RPG and JAVA programs to test stored procedures on the iSeries. Worked closed with Java developers to ensure successful interfaces between Java programs and stored Procedures.

Complete understanding of the Bank of America development environment, such authority issues within the different testing levels of the change control system.

Education:

Bachelor of Science in Computer Science, minors in Geology & Business

Stephen F. Austin State University - Nacogdoches, TX

Member in Good Standing – Phi Theta Kappa Honor Society

Continuing Education:

Java Gateway Technical college 2025

C#.net front to IBM iSeries

Gateway Technical College 2024

Python Collin College 2023

SQL Collin College 2021

Java Collin College 2020

C#.Net Collin College 2015

SAP Classes HP University 2013

PHP on iSeries Dallas College 2013

PL/SQL – 10G Dallas College 2008

Contact this candidate