Security Clearance Human Resources

Résumé of Thomas E. Costigan Jr.

*

Thomas E. Costigan Jr. Clearance: Top Secret

Residence: Falls Church, VA % Willing to Travel: 50% Email: ***@******.*** Home: 703-***-****

Cell: 703-***-**** Facsimile: 703-***-****

EXPERIENCE SUMMARY

Over forty years of experience in information systems to support practical business and organizational management processes. Functional experience in the field of accounting & financial management, human resources (HR) / payroll / time & expense reporting, contact relationship management (CRM), healthcare records management, housing and community development planning, national and international health care, online banking & bill payment services, depository account management and analysis, international trade compliance analysis, and disaster planning and response. COMPETENCIES

• Database Design and Development (25 yrs) • Systems Integration (40 yrs)

• ETL Development and Management (20 yrs)

• Business Intelligence (BI) Tools (5 yrs)

• AWS Technologies (8 years)

• Data Analysis (10 yrs)

• Agile Development (10 yrs)

• Reporting and related analysis (30 yrs)

SUMMARY OF SKILLS, TOOLS, AND TECHNOLOGIES:

Operating Systems: Windows (30yrs); Windows Server (20yrs) Languages: SQL, Java Script, Python, Visual Basic for Databases ETL Tools: Talend, SSIS, Data Connect (formerly Pervasive Data Integrator) Reporting/Analysis Tools: SSRS, Tableau, Power BI, SAS Studio Foreign Languages: Spanish (proficient); Brazilian Portuguese: (adequate) EXPERIENCE DETAILS

Booz Allen Hamilton, Inc.

McLean, VA 2/2023 – 09/2025

New hire awaiting first assignment. 2/2023 – 10/2023 Training classes; participation in proposal preparation. U.S. Department of Justice, Justice Management Division (JMD) 10/2023 – 2/2024 Data Architect. Assistance with JMDs efforts to manage database repositories and systems that are available to DOJ staff and for the dispersal of data to the public via data.gov. Key person on the revision of a system to track the Commercially Available Information (CAI) used by the 40+ Components within the DOJ (including the FBI, DEA, ATF, BOP, and others). The DOJ Components are responsible for identifying the CAI that they use in order to meet Congressional reporting requirements. I worked to finalize the development of a web-based intake form that allowed the Components to enter the required information, I managed access, and I assisted Component users with their work. I worked to Résumé of Thomas E. Costigan Jr.

2

QA the data entered by the Components to make sure they did not reveal any proprietary information. I managed the process of projecting-forward the data into a publication file that is analyzed by a pair of Power BI Dashboards: one (generic) available to all DOJ employees and one (more detailed) available to qualified restricted DOJ employees.

Computer Scientist. Assigned to the Drug Enforcement Agency (DEA) of the US Department of Justice

(DOJ) to work on the National Forensic Laboratory Information System (NFLIS): https://www.nflis.deadiversion.usdoj.gov/

that tracks the results of drug seizures by approximately 150 federal, state, and local laboratories that perform testing action for their respective law enforcement agency. The system was developed 25 years ago in MS SQL Server by another firm and Booz Allend took over the contract in January of 2024. I was part of a team of four developers who manage and revise the process of ingesting and validating data from the 150 agencies. While there are certain required data components in each data file submission, none of the agencies sends the exact same format of data file (most are in Excel format, others in XML format, and some in MS Access), therefore there are 150-plus ingestion and validation programs developed in SSIS. Often there were issues with a given submission that required revision, validation, or correction (e.g.,, the spelling of a county in the state of the submission). There is a data review and revision program that allows data managers to correct some of these issues. This program was developed in Visual Basic and I was the only member of the team who can program in this language, so all changes to this program since Booz took over this contract were done by me. I was otherwise assigned tasks to develop new or corrected versions of the ingestion process, to make changes to the MS SQL Stored Procedures that validate and summarize the data, or to create extended documentation of procedures and methods.

Spin Systems, Inc. (DBA Spinsys) 2/2021 to 2/2023

Falls Church, VA

ETL Developer. Database migration and modernization projects for the US Department of Defense

(DoD), Defense Health Administration (DHA) to migrate DoD healthcare data from legacy systems (DB2, Oracle, MS SQL Server, others) to the AWS environment using Redshift for database management, AWS S3 for file management, and Talend for ETL processing. Principal staff-member responsible for the daily data transfer of files prepared for the Military Health System (MHS) Data Repository (MDR) collection system that feeds into the MHS Mart (M2) data analysis system (where healthcare data analysis is available to over 5,000 data analysts world-wide) using a granular-yet-simple Talend Server application that loads the collected data from AWS S3 "Buckets" into Redshift AWS Staging and Pre-Production Tables where they are validated before being promoted in a nightly Talend Job to the final M2 Production database that is used by the functional analysts. Trained subcontract organization (manager and four analysts) to take over the daily operation of data loading that I had been doing by myself for the prior six months, while I transition to other tasks and projects. Résumé of Thomas E. Costigan Jr.

3

IntraFi Network (formally Promontory Interfinancial Network) 2/2013 to 11/2020 Arlington, VA

Senior Developer. Responsible for the data mart that analyzes the company’s IND product. IND provides cash account “sweep” services for major brokerage firms and investment companies so that their clients’ cash account reserves obtain maximum interest return and FDIC insurance protection. IND manages accounts for over 20 million accounts from individual and corporate depositors and over $178 billion in cash deposits. My initial responsibility was to reorganize and extend the ETL system developed in SSIS that is used to process the data from the system’s service bureau via an FTP data feed; this allowed the system (developed in MS SQL Server 2008) to be promoted from a development environment into a more powerful and secure production environment. I have made simple yet effective improvements to the data mart by creating numerous stored procedures and functions. I standardized and economized the data structure of all tables. I worked with the IND business analysts to re-write all the reports that are currently created in MS Access into the SSRS reporting system that are thereafter available via a web portal; all reports were improved by allowing users to select any valid report date and other parameterized values that are not available in the MS Access reports. I created new SSRS reports that allow the IND balances to be compared to the movements of the S&P 500 stock index that help to prove the hypothesis that IND balances and the stock market move in opposition. I am currently working on a migration of the in-house SQL Server system to a system hosted on the Amazon Web Services (AWS) environment that will utilize a “dual database” system, one hosted on the EC2 Windows Server uses primarily for calculations and a mirror system hosted on a RDS system. I re- engineered the ETL required to make this system work from SSIS to Talend and I added an Event Tracking System that allows for a granular means of knowing the current status of the entire system. I created several one-time and on-going (daily / weekly) data extract procedures to copy selected data from the IND database to Sharepoint, Saleforce, and other data repositories U.S. Department of Homeland Security 2/2012 to 12/2012 Customs and Border Protection Agency

Washington, DC

Business Integration Analyst Engineer. Employed by TDB Communications, Lenexa, KS via subcontract to clearAvenue, LLC of Clarksville, MD. Through this arrangement, I was a contract employee of the US Dept. of Homeland Security, Customs and Border Protection Agency; assignment location in Washington, DC for the development of a data warehouse dealing with international trade compliance issues. The system was developed in MS SQL Server 2008 and SSIS for back-end data construction and SSRS and the .NET Framework (Visual Basic) for the front-end GUI. I was the primary author of the database design and in addition to the standard dimensional and fact tables, to meet the evolving requirements of the trade analysts, I came up with the idea of “analysis” tables that summarize hundreds of millions of trade transaction data between an importer and one (or several) other combinations of dimensional data elements (e.g. foreign manufacturers, ports of entry, product categories, etc.). I wrote approximately 90% of the ETL code that is in use today to populate the system on a daily and monthly basis. I also worked on several dashboard-like reports in SSRS that summarized both daily and monthly data that were integrated into the GUI. I passed a background investigation that granted clearance to work will all confidential international trade data. While my primary role on this project was that of data architect / data transformation specialist, I needed to acquire a functional understanding of the terminology and procedures of international trade in order to work effectively Résumé of Thomas E. Costigan Jr.

4

with the US government trade specialists to assure that the business analysis results of the system met the requirements of the client.

Deltek 11/2010 to 12/2011

Reston, VA

Senior Consultant. Responsible for data conversion, transformation and load projects related to Deltek’s Costpoint line of accounting systems (including GCS/System 1 and Time & Expense) primarily using the Pervasive Data Integrator program and MS SQL Server (including SSIS). On-site coordinator of a group of developers who was assigned to a complex Pervasive application that uses web portal technologies to tie together several ERP systems with Costpoint; briefed new members onto the project, launched them into productivity and got out of the way to let them be successful. Developed interfaces from Costpoint to the PayChex payroll and Vanguard benefits systems. Worked diplomatically but effectively to manage client project managers to engage their staff to provide timely and qualitative data submissions. Created formal estimates for new business opportunities that were accepted and successfully implemented. Helped to write the technical aspects of marketing materials for new products and services.

Online Resources Corporation (no longer in business) 4/2002 to 11/2010 Chantilly, VA

Configuration System Analyst. Completed over 140 data conversion projects that converted customers, payees and payments using the Pervasive Data Integrator program and related SQL Server technologies that became part of ORCC’s online banking and bill payment system. Mentored and managed other staff members to enable them to perform data conversion projects using the same procedures and techniques that I developed. Provided business analysis reports for all projects that identified exception data that could not be loaded to the system. Engaged with ORCCs development team to design, test and manage the XML-based data load program to SQL Server. Served as the technical support coordinator for ORCC’s cash management system and directed other ORCC colleagues and client staff on how to avoid, identify and resolve invalid and fraudulent activities. Technical manager of ORCC’s internal sales force automation program deployed on the GoldMine CRM system; managed and mentored others to engage the day-to-day operations of the system. Served as the back-up administrator of the Remedy trouble-ticket tracking system and as a member of the application support group responsible for system performance monitoring, invalid / fraud activity detection and related problem / issue identification and resolution. In my role as the in-house CRM system manager, I had to work as an effective business analyst to engage with the corporate management, marketing, sales, and account management teams to identify prospects, create marketing / sales campaign efforts and to analyze historical sales and account retention data. Vertical Marketing, Inc. (no longer in business) 8/1996 to 2/2002 Manassas, VA

Senior Consultant & Systems Analyst for sales force automation / contact relationship management system projects (08/1996 to 04/2002) deployed using the GoldMine CRM product. Managed remotely a team of ten developers who were located in Vishakhapatnam, India. Résumé of Thomas E. Costigan Jr.

5

Pan American Health Organization (PAHO) / World Health Organization (WHO) 9/1989 to 0/1996 Washington, DC

Programmer / Analyst and member of a small development team of a multi-user, multi-lingual, multi- currency fund-based accounting system that was installed in PAHO’s 35 field offices throughout the Americas. Over 20 trips to PAHO’s field offices to perform system installation and support services. The software was developed in FoxPro and deployed on a Novell Netware network for multi-user installations. Responsible for managing the change from paper-oriented accounting systems to standardized, networked systems that engaged electronic data exchange back to Washington; overcame concern and resistance by local staff to make these necessary changes. Member of the PAHO disaster response team: sent on a mission with the International Red Cross to St. Maarten to provide emergency satellite telephone technology and training following hurricane Luis in September of 1995. Microcomputer Technologies Consultant 2/1982 to 9/1989 Northern Virginia, VA and Washington, DC

Co-founder of Washington Programming Team, Washington, DC, the first company to be listed in the Washington Yellow Pages under “Microcomputer Consulting.” Managed up to 15 employees for the sales, installation and support of accounting systems from CYMA and NewViews. Sold and managed the installation of one of the first 3Com networks on the East Coast. Managed the development process of a software program for the Alliance To Save Energy that performed return on investment analysis of energy efficiency investment projects.

EDUCATION

Master of Information Systems Management (MISM), The Keller Graduate School of Management

(06/2003)

Certified Information Systems Specialist (CISS), George Washington University, Washington, DC

(05/1988)

Master of Arts (MA), Latin American Studies, Georgetown University, Washington, DC (05/1981) Bachelor of Arts (BA), Economics, Columbia College, Columbia University, New York, NY (05/1979) Certified Soccer Referee by the United States Soccer Federation (USSF) and the Virginia High School League (VHSL); 44 years of experience. In semi-retirement, I serve as a trained Referee Mentor for new referees. Being a soccer referee is the hardest job on planet Earth; trust me on this one.

Contact this candidate