Richard Lee Pierson

Work History

Senior Software Developer

Aetna Health Care

Worked on a contract for Subsystems
Technologies on their FAA (Real Estate Management System)
Completed work to redesign the REMS Website Home page and the REMS website landing page which users are directed to after logging into REMS from the home page
Worked to make home page and landing page both be more 508 compliant
Both the home page and landing page were rewritten using ASP.Net 4.5 with C# used for the code behind and for the data access layer pages
Also worked with Adobe Photoshop to create all new images and buttons for the website redesign
Worked to help convert the REMS existing web pages from classic asp to Dot Net
Conversion involved a complete rewrite of their classic asp pages to 4.5 ASP.Net with C# being used for the code behind and data access layer pages
Rewrite also required me to help to write some new oracle data queries for each new ASP .Net application being converted using oracle 11g
Environment: Visual Studio 2010, 2012, ASP.Net 4.5 with C#, Oracle 11g

Senior Analyst

Fedtec

06.2023 - 06.2024

Worked with the Criminal Investigation Team as a .Net Developer to Help with the Creation of new and help with the Maintenance of existing Reports used by the IRS Criminal Investigation Division
Also help Work on Projects that help track different activities by the CI team
Visual Studio 2013,2019, SQL 2020, C

Mainframe Engineer

Prosigma Partners, State of Illinois, Deloitte, Ann IMS

01.2023 - 06.2023

Department of Child and Family Services, Worked as a DB2 DBA in the Department of Child and Family Services
This job has me helping to maintain DB2 tables and DB2 Stored procedures
Duties also include fixing pointer issues with tables when they occur, along with other DBA duties
Besides working with DB2 duties also include helping to support tables for the IMS database which are still I
Use
From the early 1990’s
DB2, COBOL, CICS IMS, JCL, Endevor

Mainframe Assembler (ALC) Analyst

KMM Technologies, IRS, Deloitte

04.2022 - 01.2023

Worked in an agile environment, helping as a Mainframe Architect, SME with the Assembler (ALC) code for the Individual Master File being modernized into Java
The team at Deloitte splits our support between different parts of the Master file
Like taxpayer data such as refunds, Payments, Delinquent Payments, and Taxpayer audits, are all examples of the Master file
AS part of the Code Integration (CI) team my role essentially means, I am someone who triages defects
Working to find the root cause of an error in data between ALC and Java outputs and then providing a recommended solutions to a Java developer
As CI member(s), we spend our days looking at both ALC and Java code and utilize triage tools to help us isolate defects and decide the root cause of the current issue
We also worked with client to use new IBM Ai to start converting the Assembler code into first readable pseudocode
Then had to review pseudocode to make sure it matched up to all the functions contained within the assembler program
Once this was this was completed, then worked with JAVA programmers to take the pseudocode and generate a new JAVA Program that would do the same process that the assembler program was doing
Environment ASSEMBLER, ECL and Unisys, Z/OS, IBM AI
Environment ALC, VSAM, QSASM, JCL, DB2, Z/OS
MarkPar Washington DC
IRS DATA PERFECTION

Programmer/Analyst

11.2021 - 02.2022

Leading the transition of work from Maximus as a Mainframe Architect, SME analysis/coding was done for the IRS Document Perfection which includes maintaining IDOCs, GMF, GUF, ERS
The transition meetings include the process of how to get a Work Request, how to create the FSP, how to create test cases, and test documents, and how to create the transmittal along with how to create the needed DFD using VISIO
Worked to help Guide the team to come to speed with the tools they will need to do the work for these applications
Created Develop user guide(s) for how to use Micro Focus InfoConnect for Unisys
This includes documentation on how to use the Unisys IPF editor
How to use the FTP function inside InfoConnect to FTP programs that need to be brought down to their local laptop to make the changes and how to FTP changes back to Unisys
The User Guide also has included some basic ECL commands on how to Catalog file and how Copy elements like programs/procs to their own file for modifications for tax year 2022 processing year 2023
Plus looked at data stored in QSAM files (Flat files) and worked to have those flat files rewritten and Stored in VSAM format going from this point Forward
This Required create a VSAM version of the QSAM Flat File
Prepare documentation on how to use the IPF editor fir ending our COBOL programs
Environment COBOL, Assembler ECL, QSAM and Unisys, Z/OS

COBOL/ALC Analyst, analyst

KMM Technologies

08.2019 - 10.2021

IRS PoRa Evaluation Team/Deloitte
Mainframe, on the IRS (PoRa) Portfolio Rationalization Project
As a Mainframe Architect, SME working with Deloitte my role was to help support the IRS in its ongoing work to modernize its IT Technologies in alignment with the IRS’s Strategic goals set by Congress
Lead the discussions with the application developers to understand the applications and gather the vision/requirements for the modernized of several Mainframe applications
Develop the Scoring Framework to help prioritize the applications
Worked as a member of the of Evaluate team, evaluating legacy (COBOL/ALC) applications to determine if an application for the IRS should be Retained, Retired, or Rewritten to another language like JAVA and determining if the DB2 databases should be converted to Postgres or to an Oracle
Work as one of the few technical SMEs on the team playing an instrumental role in helping to develop the design patterns and developing the executable recommendations in collaboration with other IRS Application Development Teams such as EA (Engineering Architects) and SE (System Engineering)
Work as a Member of the Evaluation team to help decide which existing Tier 2 and Tier 3 applications can be made AURE or AWS cloud ready in the next 3, 6, 12, month time frame based on the applications current architecture, and type of current database being used
Also looked at refactoring some items using Informatica and ETL
I bring to the team 30+ years of experience in ALC technology, COBOL, CICS, DB2, VSAM, OS/MVS JCL, ENDEVOR, ASP, C, C++
I also bring my experience having worked on a few projects at IRS in the past and bring to this team a strong legacy technology experience and domain expertise as well
All work done here was did in an agile environment with 3-week sprints
Environment COBOL CICS, DB2, Assembler, Endevor, ALC, SQL Server, AWS, AZURE, JAVA, ECL and Unisys, Z/OS
Leidos
Federal Parent Location Service

Mainframe Developer

08.2018 - 07.2019

High level Security clearance
Worked on new COBOL/ALC Programs to help tract important missing data that
FPLS (Federal Parent Location Services) gets from states to help tract individuals that fail to pay their child support
New applications are working with data we get from Unemployment, New Hire(W4) And Quarterly Wages to tack personal data that maybe missing, such as incomplete SSNs, Full Name Full Addresses And other important Data that should be on records submitted by the states
Help with maintenance of many large-scale COBOL applications
Environment COBOL CICS, DB2, Endevor

Senior System Analyst

Rite Aid Corporation

02.2016 - 08.2018

Worked on a Batch COBOL program to help capture the new Philadelphia Sweetened Tax Rate on Sweetened products sold in are Stores in the Philly Area
The program will also apply new tax to sweetened drinks transferred to stores in Philly and deduct new tax from those sweetened drinks transferred to non-Philly stores
This program uses serval DB2 tables, new program has its own ProcLib member and will be ran as a separate step in an existing Batch JCL job
Worked on New Project to Convent the Current COBOL/CICS RX Inventory Management System Programs to a VB.Net Portal application
This project required understanding about 9 to 12 COBOL/CICS programs and then work to convert them to VB.Net but continue to use the existing DB2 tables that are being used by the COBOL/CICS programs as to creating new tables in SQL Server 2016
Created a new Beauty Care Application (App) for the Rite Aid Beauty Advisor’s iPads
I have been involved in the full life cycle on this project
From initial requirement needs to Application design, Database design, Application coding using Visual Studio 2105 and C#, Database Creation with MS SQL Server 2106, and User Acceptance testing
Currently the New Beauty Advisor iPad App is in Beta testing in about 8 different Rite Aid stores
Have been involved with helping to convert both VB.Net Portal Applications and COBOL programs for the possibility that some of our stores will be sold off to allow us to merge with Walgreens
The coding changes have required us to be able to determine if a user that logs on to the system is a Rite Aid user or a user from one of the diversified stores that we are still supporting
This project has required me to make changes to DB2 table queries and procedure
Then VB.Net applications being modified are using the OleDBConnection so that the portal applications can connect to the DB2 database and not to a SQL Server database
Environment COBOL CICS, DB2, Endevor, C#, ASP.Net, SQL Server, VB.

Senior System Analyst

US Senate

10.2015 - 02.2016

This project had me work with the US Senate Office of Public records
On this project, I supported applications written in VB.Net also with applications written in Django
This project had me working with SQL server 2012 and 2104 as well as the versioning tool GIT and GITHUB
I worked to get programs that were stored in SourceSafe converted to using the GIT versioning Software, which required me to work with about 800 programs that had to be converted to using GIT tools and being able to access them through the GIT repository
I also supported jobs that were involved with getting documents scanned and entered for the 2016 election
I had to make sure scanning programs were functioning correctly and scanning the proper fields that need to be scanned for each member running for the Senate
The scanning software was written using VB.net and had to be updated for new printers that would all office of public records to scan more pages per hour
Each election package contained about 300 pages that had been scanned
Documents also had been created after scanning to show that the packet was received on time and that all pages where scanned
The document then had to be e-mailed to the person running or re-running for the senate and a copy also had to be sent to the DOJ for legal reasons
To record that the person running did get their documents in during the time frame required
Environment: VB.Net, SQL Server 2012,2014, Django, GIT, Python
Apex Systems - subcontracting with Purislove/IRS_SWETRS Project

Senior System Analyst

IRS

09.2014 - 10.2015

Worked with Members of Purisolve to help create a new import/upload process for the SWETRS (Service Wide Employment Tax Research System) as part of their Remote Data Entry (RDE) system
I have worked very closely with members of the SWETRS team to do upfront analysis needed to understand what their needs were for the Import Upload process, including what types of forms they wanted to import and have uploaded to their oracle SWETRS database
I order to help create a while working Import/Upload application, several weeks of analysis meetings with their users were required to research and learn about the Employment applications process and about how tips must be reported to the IRS by Employers and Employees
Worked with the Purisolve team members to help write the requirements document and help make needed changes to current Consolidated Design Document (CCD) to include all changes that were going to be made by our team including new applications being added to their RDE system as well as changes to the existing applications new stored procedures and changes to existing stored procedures
Worked to create new .Net C# modules that would become part of the existing RDE to allow the IRS users to Import several types of excel files
The new process will allow users to select which type of excel file they which to import then allow them to view the import file
Once the import is complete and user(s) have viewed the imported version of the excel file the user can then upload the file
This will then update several different tables in the Oracle SWETRS database
The upload process required the creation of several new stored procedures using Oracle PA/SQL code
Worked to update existing RDE programs to accommodate the new fields that would now be modifiable due to the users being able to upload excel data to the SWETRS Database tables
Helped to develop needed requirements for this new project by working with the IRS SWETRS business Team members
Helped to develop the system test plans that would be used to test all of the changes made by our team
Started new project to help get IRS SWETRS team over to SharePoint 2013
During the first phase of this project, I worked mainly on requirements gathering at this point
Environment: Visual Studio 2012, ASP.Net 4.5 with C#, Oracle 11g and Oracle 12g

Software Developer

04.2014 - 09.2014

I worked for the Pennsylvania Department of State to help them convert their paper license applications to a web-based version
This job only requires me to help convert word document text to HTML for the new web pages for each of the different license types, and to write a little SQL
SQL is needed so that each license type can get their own version of professional and legal questions created for that specific license type, which is then used once that license type goes live on the PA state licensing website
This job requires working closely with the end users, those being the members of the different licensing boards from Health Care, Business, Real Estate and Motor Vehicles, and the Nursing to help them make sure that they get all the important information from their paper application to their new web version of that licensing application
The goal of this current project is to have all 300 of the States Paper Applications on-line by December 31st
As of August 1st, our team had brought 135 of the 275 licenses on-line
With a goal to bring another 41 on-line by September 5th
This Job also requires writing the User Acceptance test scripts that are used by the different Licensing Boards when completing their user testing of the new on-line versions of their board’s licenses
Environment

Senior Software Developer

FAA

11.2013 - 04.2014

Senior Systems Analyst

Lockheed Martin

04.2012 - 08.2013

As a VB .Net Developer of the Actuarial team my responsibilities include maintaining the company’s Debit Tool windows software which is used to determine underwriting factors for new and existing lines of business
The Debit Tool is used by Aetna’s Marketers, Medical Underwriting, and Financial Underwriting staff to help to determine the risk and cost of insuring individual or small/large groups
As the solo developer on the Debit Tool project my duties have included gathering new requirements from the Medical Underwriters and Actuarial team members for enhancements to the existing Debit Tool software
Along with requirement gathering and Design Specification Writing, also handled all of the coding modifications to the Debit Tool using VB .Net and SQL Server 2008, 2012 and LINQ
Worked on major modifications to the Debit Tool
Modifications required me to create addition Windows forms and additional Telerick reports for the Finical and Medical underwriters
These changes to the Debit Tool went live in December 2012
Completed requirements gathering and Design Specification writing for the next Debit Tool project
The new project required additional changes be made to the Debit Tool for a new line of business which allows Aetna to write health insurance for individual and groups in the state of Texas
This change went live in February 2013
VB .Net, SQL Server 2008, 2012 and LINQ

Senior Application Programmer

Ginnie Mae, Lockheed Martin

04.2010 - 04.2012

Involved in ASP.Net and C# maintenance programming on the new RFS (reporting and Feedback System) for Ginnie Mae that went into production January of 2010
Did ASP.Net and C# maintenance programming on the new RFS (reporting and Feedback System) for Ginnie Mae that went into production January of 2010
My role as a .Net developer was helping to resolve defects that were found in the new web applications via C# and ASPX pages, I was also required to make C# coding fixes to the data access layer and help with SQL fixes to the oracle stored procedure
My role as a .Net developer was helping to resolve defects that were found in the new web applications via C# and ASPX pages
I was also required to make C# coding fixes to the data access layer and help with PL/SQL fixes to the oracle stored procedure
Was involved with making sure that unit and system testing of all fixes was completed prior to the .net coding changes going back into production
Environment: ASP.Net 4.0, 4.5 and C# Oracle

Senior Application Programmer

Ginnie Mae

03.2005 - 04.2010

Worked on long term project for Ginnie Mae to web enables all of their current "Mortgage Back Securities Information System" applications
Redesigning was done using ASP.Net and C# along with using ASPX.net for the new screen development work
C# was used to write the applications Data Access layer and Business layer objects; C# was also used to write the ASPX code behind pages
One of my other roles was involved with making sure that unit and system testing of all fixes was completed prior to the .net coding changes going back into production
Helped to create a new web application for Ginnie Mae by converting their old Issuer Information System from a Clipper/Dbase to a VB Web based application
A new VB Web based system was used by Ginnie Mae Issuers to enter their Monthly Reporting data and their Soldiers and Sailors Civil Relief Act data
Was involved in creating using Visual Basic, VBScript, ASP, and JavaScript on the development of a new web site for Ginnie Mae called Your Path to Homeownership using HTML 4.0 and JavaScript.

Senior Application Programmer

Lockheed Martin, Ginnie Mae

06.1998 - 03.2005

Prior to the Development of the new Reporting and Feedback System I worked on creating the new Case and Insurance Matching reports for Ginnie Mae's existing VB web site
New reports were written using XML and XLST style sheets
This project required me to write and maintain XML data and update the XSLT style sheets on monthly basis for Ginnie Mae reporting
Worked with Adabas DBA using Software AGs EntireX Broker products to web enable several of Ginnie Mae's Natural Applications
This project required us to first install EntireX Broker on UNIX and on our Web Server
Once this was completed new Natural applications were written to pass data from Adabas to EntireX
On the web side new data entry screens were created using ASP and XML
By web enabling many of Ginnie Mae's core applications Ginnie Mae was able to move away from having to using the Application Gateway software to access these applications in UNIX
Helped to create a new web application for Ginnie Mae by converting their old Issuer Information System from a Clipper/Dbase to a VB Web based application
A new VB Web based system was used by Ginnie Mae Issuers to enter their Monthly Reporting data and their Soldiers and Sailors Civil Relief Act data
New web-based system was created using Visual Basic, VBScript, ASP, and JavaScript
Performed maintenance and development on the Mortgage Back Securities System, this system was written in Natural/ADABAS
Development was for Loan Level Processing and Soldiers and Sailors Civil Relief Act Processing
Created a new Installation version of Ginnie Mae's “Issuer Information System” which at the time was written in Clipper/ DBASE, Installshield was used to create the Executable for the PC software
Worked on the development of a new web site for Ginnie Mae called Your Path to Homeownership using HTML 4.0 and JavaScript
This new Ginnie Mae web site was used to help inform First Time Homebuyers with what all is involved when purchasing a new or used home
Performed maintenance to the Ginnie Mae web site and helped to make web site ADA compliant
Help to create a new download page for the Ginnie Mae website
The new page will allow Ginnie Mae Issuers to download software from the website to their own PC
Performed modifications and maintenance to five clipper/DBASE systems, the Issuer Information System, Custodian Account Verification System, Loan Level Error Reporting System, and Issuer Exception Display System
Performed Y2K modifications and testing to the Issuer Information System which was a Clipper /DBASE application
Helped to design the MSA and Financial Data Warehouse Systems
HUD's Home Equity Conversion Mortgage System department will use the two new systems
Performed modifications to other HECM programs for Y2K enhancements using COBOL II, MVS/JCL, and VSAM
Performed modifications to programs in the Data Collection Account Management System using EZTRIVE, COBOL II, MVS/JCL, and VSAM
Environment: Natural/Adabas, XML, Clipper/Dbase, COBOL II, MVS/JC

Application Programmer

American Technical Resources, Computer Sciences Corporation

01.1998 - 06.1998

Performed modifications to Medicare's Common Working File Computer System
Made Modifications to Medicare Part A, Part B applications, which handle Inpatient, Outpatient, Home Health, and Hospice claims
Wrote Several New On-Line and batch COBOL applications for Home Health claims Processing Modified Inpatient processing to handle Direct/Indirect Graduate Medical Education Refunds to Hospitals with HMO Medicare Entitled Patients
This project required modifying fourteen applications, plus it required getting a full understanding of Inpatient claims processing
This project required over four hundred man-hours but was not started until the middle of February
Code had to be in BETA by April 22
This deadline was met, and the modification went into production on June 1, 1998
Environment: COBOL II, MVS/JCL

Programmer II

SINAI Hospital

10.1996 - 06.1998

Performed modifications to Clinical and Pharmacy Systems
Wrote several new on-line and batch applications for both systems using ADS, COBOL/CICS, and PC Mainframe
Developed new function for Medical Records
New function was designed to allow users to request medical records on-line using the Clinical System
If the request for a medical record is 24 hours or less the user can now request the record STAT and a STAT Requisition will be produced in Medical Records for processing
All other requests are processed during normal nightly batch processing, whereby a medical record routing card is generated and sent to Medical Records for Processing
Performed coding and testing for New Pharmacy Satellite in Pediatrics
This project required modifying three different Pharmacy applications Unit Dose IV, and Labeling system
Developed new on-line function on Clinical System for scheduling of patients to on-site clinics
This new function will be used by the Emergency Department and several other selected Units to schedule patients for clinics
Environment: COBOL II, MVS/JCL Assembler, Endevor

Programmer II

Blood Systems INC

08.1992 - 09.1996

Performed modifications to blood testing applications written in Natural/Adabas
These applications kept track of Blood donors test results
There also sent out letters to Donors that did not pass the HIV, Hepatitis A, B, C testing or was determine to possible have a type of STD
Also worked with applications that sent out donor certificates to donors that reached different donations
Used REXX to copy files snd to crest functions and to crest done user based macros
Modified some blood testing programs written in assembler and written COBOL
Environment: Natural Adabas, COBOL Assembler, MVS/JCL, Clipper, Dbase, VB, REXX

Summary

Overview

Work History

Senior Software Developer

Senior Analyst

Mainframe Engineer

Mainframe Assembler (ALC) Analyst

Programmer/Analyst

COBOL/ALC Analyst, analyst

Mainframe Developer

Senior System Analyst

Senior System Analyst

Senior System Analyst

Software Developer

Senior Software Developer

Senior Systems Analyst

Senior Application Programmer

Senior Application Programmer

Senior Application Programmer

Application Programmer

Programmer II

Programmer II

Education

BS - Computer Information Systems

Skills

Security Clearance

Career Overview

Timeline

Similar Profiles

Sheela B Sheela B null

Tracy NearmanTracy Nearman

Jalyn DannerJalyn Danner

Richard WomerRichard Womer

ANGELA B. SELLANGELA B. SELL