PHILIP H. QUARRIER
Systems Designer
CLEARANCE: None current. Lapsed TS/SCI/FS
SPECIALTIES
Systems Design
Database design, particularly with ORACLE 8, 9i, 10g, 11. Access 2007
Data transformation and cleansing
Programming PL/SQL, SQL*Plus, Perl, Informatica
Project management and supervision in commercial and government organizations.
EDUCATION
MS (Finance), Loyola College, Baltimore - MBA University of Chicago - BS U. S. Merchant Marine Academy
PROFESSIONAL EXPERIENCE:
Digital Ministry Coordinator (part time, remote)
Columbia MD 07/2022-
Monitoring, operating and planning improvements in a church website.
Enumerator Lister and Interviewer
Elkridge MD – 07/ 2020 to 11/2020 temporary
Training: Application of Census rules to individual cases. Use of Census laptop logging work onsite.
Daily work: Visit selected locations for Quality Control verification of:
Housing Unit identification.
Interview of residents to determine identity, relation to principal occupant and location at time of Census.
Business Process Analyst Micro Focus COBOL
Washington DC 08/2018 to 12/2018 - Contractor: Select Computing, Inc.
Tested and used Micro Focus Enterprise Analyzer for use by CareFirst (CMMS) in COBOL.
This was to document a suite of 2500 COBOL programs for needed changes and upgrades.
Systems Administrator Windows, Linux and Unix
Herndon VA 7/2016 to 2/2017 Federal government client. Contractor: 3nSolutions
Training: System administrator information security
Systems Operations on AWS –Classification – CI Essentials – Insider threat awareness – Privacy awareness -
Daily work: Preparing systems for deployment on Amazon Classified Cloud
Participation in Agile Scrums, and JIRA. Sprint planning, grooming, retrospective and review.
Helped set up and populate team’s SharePoint website.
Arranged for and assisted in self-scans to prepare for security certification of application systems.
Wrote and presented plans for patch management and installation team within a group supporting 25 applications.
Senior Systems Administrator Solaris (UNIX) and Windows 2003 servers
Adelphi, MD 11/2013 to 5/2014 on contract at National Archives II. Contractor: Phacil Inc.
Create and manage user accounts, debug problems with Oracle Forms 11 and WebLogic.
Plan and execute transition to Oracle 11 on Solaris 11.
Provide customer support by analyzing and solving software-related problems.
Write Perl programs to accommodate unusual data formats quickly.
Trace compatibility and connectivity problems within and between servers and EMC storage.
For servers with insufficient disk space, write plans for backup frequency, content and space allocation.
Database developer Windows
Annapolis Junction, MD 6/2013 to 8/2013 Federal government client. Contractor: Alapko, Inc.
• Improve query performance of a mission critical tracking and reporting system.
• Use custom monitoring and reporting applications
• Create views for individual needs for time frame, points of interest, geography.
• Use SQL Developer to view relation of source data to results.
Senior Staff Systems Analyst and systems administrator. Windows
Annapolis Junction, MD 11/2012 to 4/2013 Federal government client Contractor: Dynamics Research Corporation
Assigned to Logistics operation supporting an Archibus team of planners and designers.
•Write plans and documentation for backing up and rebuilding web applications and their databases.
•Design and write SQL and Perl scripts. Manage multiple virtual Windows servers from remote desktop.
•Trace and debug problems with vendor-supplied inconsistent patch bundles.
•Build lists of required links and pointers between application software, Java and middleware components.
Software Developer Unix
Reston, VA 4/2012 to 8/2012 Federal government client. Contractor: L-3 Stratis
•Use UNIX Korn shell, C-language, SQL, and COBOL.
•Reverse engineer and document an operational Lawson payroll scheduling system.
•Write shell scripts and Perl programs to isolate and analyze intermediate and final products.
•Validate testing of the same product on different servers and software bases.
Software Developer Windows
Annapolis Junction, MD 3/2011 to 8/2011 Federal government client. Contractor: Pangia
Program and maintain web applications using SQL Developer, PL/SQL, HTML, JavaScript.
Create views and sub-queries to simplify the programming of data presentations.
Programming in this environment requires cross-platform knowledge of source data creator intent, which may or may not match current user needs.
Principal Systems Programmer Windows
Washington DC 8/2010 to 2/2011 Federal government client. Contractor: NCI Information Systems Inc.
• Track, audit and consolidate inventory of all computer equipment assigned to a bureau of the agency.
• Develop Access 2007 database application ordering and tracking classified work of a counterintelligence team.
• Systems Administrator on an internal LAN using Windows Server 2003 with Windows 7 and XP workstations.
• Active Directory administration, user support, workstation replacement and deployment, licensing.
Engineer-5 Windows, Unix
Annapolis Junction, MD 2/2009 TO 6/2010 Federal government client. Contractor: Northrop Grumman
Network Software Tools group.
•Develop and install upgrades to network communications software tools.
•Create and populate an Access database of information on servers for which the team is responsible.
•Test server connectivity and health to correct problems. Regular inspections to anticipate problems.
Senior Professional Staff Unix
Annapolis Junction, MD 8/2007 to 2/2009 Federal government client. Contractor: SRA International
• Create and maintain Informatica workflows and UNIX shell scripts for importing applications into data warehouse tables for use by Cognos front-end reporting tools.
• Design ORACLE data warehouse tables to maintain current and historical data in formats suitable for creation of data cubes for query and reporting.
• Write scripts in SQL*Plus, PL/SQL, Perl to analyze and validate quality of imported data.
• Improve data quality with custom functions and Informatica transformations designed to meet observed problems with the actual data as determined by the analysis.
•Create validation and correction tables to bring variations to a common standard representation
Systems engineer and database administrator Unix
Annapolis Junction, MD 7/2003 to 8/2007 Federal government client. Contractor: Keane Federal Systems Inc.
security and administrative applications on Sun UNIX servers.
Develop and maintain web based interfaces to ORACLE 9i databases using Perl, HTML, JavaScript and PL/SQL.
Write programs to migrate data between incompatible databases.
Build HTML web pages the JavaScript project library of reusable routines for team’s online Customer Satisfaction Survey and the management tools to produce survey results,
Build UNIX and Perl scripts to facilitate the testing.
Senior Consultant, Professional Service Micro Focus COBOL. Contractor: Group 1 Softweare
Lanham, MD – 1/2001 to 11/ 2001 Group 1 Software – Commercial and state government clients.
•Software and systems design, programming and installation of customized software.
•Adapt name and address standardization and consolidation software products to customer requirements.
•Build suite of mainframe COBOL/CICS programs to support a web-based inquiry system.
•Write Perl programs to improve and standardize data from multiple sources into combined database tables.
•Use DB2 to build application to identify precise location for local taxes which could vary in zip-code, depending on street addresses, county and city limits. Zip codes can cross state lines.
Limit lines can go through cities, zip-codes and your house or front yard. Program had to distinguish.
Development Engineer, Project Manager, Trainer Micro Focus COBOL
Rockville, MD – 11/1997 to 11/2000 Commercial clients Contractor: Intersolv->Merant->Micro Focus
• As classroom trainer of MERANT (Micro Focus) Net Express, teach client programmers to develop and maintain programs for Internet, server, and UNIX environments.
• As Development Engineer at MERANT Solutions Center using Net Express, convert Wang COBOL subsystems to run as job streams on Windows NT.
• As Project Leader at Philip Morris USA in Richmond, VA, manage a front end team on-site to obtain and package mainframe COBOL programs for Y2K remediation by the Merant Solutions Center in Maryland. On return of the modified software, the team prepares the interim and final deliverable reports to the customer.
• Design and maintain the status tracking system, maintain liaison with the Solutions Center management on schedule, progress and problems, present the weekly status reports and represent Merant in customer meetings.
• As Development Engineer at MCI, write and execute test plans for IBM Mainframe batch and online CICS program using TSO/ISPF, JCL and an online debugger.
• As Development Engineer at a Mexican Bank for Year 2000 remediation of Tandem systems.
• Make major improvements in the client support by building customized tools with Visual Basic 6 to analyze COBOL subsystems to determine completeness and obtain complete subsystems for testing before release to the Intersolv staff for remediation.
• Design, obtain and install changes to the Tandem-to-Micro Focus conversion pre-processor to make it operate on entire subsystems instead of individual programs. Write and present training classes in Spanish to the bank staff in the use of Micro Focus Workbench.
Systems Engineer Mainframe Contractor: EDS
Bethesda, MD – 1/1997 to 11/1997: Client National Flood Insurance Program
•Maintain and upgrade IBM mainframe COBOL/CICS programs. Prepare configuration management upgrades.
•Write new programs to support additional requirements. On-call production support systems engineer.
•Database programming on IBM mainframes with ADABAS and Natural.
PRIOR COMPUTER WORK: McFadden Associates, Jackson Foundation, Applied Physics Laboratory, SMC, General Instrument, Texaco USA, Celsius Energy, Computer Sciences Corporation, Waddell & Reed, TWA, Sears Roebuck, IBM
HARDWARE SKILLS: UNIX and Windows servers, PC, IBM Mainframe, DEC VAX.
SOFTWARE SKILLS:
• Perl, JavaScript, HTML, Visual Basic 6, Paradox, Pascal
• COBOL (Net Express, Mainframe Express, Mainframe, VAX).
• PL/1, FORTRAN, Assemblers.
• UNIX shell scripts, SED, SQL*Plus, ORACLE SQL Developer, PL/SQL.
• Informatica (ETL), Erwin, TOAD. Ingres, Sybase.
• DB2, CICS, TSO/ISPF, CLIST, REXX, XEDIT and KEDIT.
• DCL, RDB (DB2 equivalent)
• MS Access/VBA, Excel, Word,
• Trained on C, C++ and Java.
OPERATING SYSTEMS:
• Solaris, UNIX, Linux
• IBM mainframe MVS JCL, JES II and III, DOS/VSE, VM/CMS, DEC VAX VMS
• Windows 7, XP, 95, 98, ME, NT, 2000, 7,8,10 Windows Server 2003, 2008.
COBOL-specific experience:
• 1962...1965 IBM Systems Engineer, insurance and financial customers in Chicago.
COBOL on IBM 1410, 7010 and 360 computers. Write programs, train users, teach COBOL classes.
• 1997...1997 Developer at EDS. Write and modify mainframe COBOL programs,
prepare configuration management library upgrades.
• 1997...2000 Micro Focus COBOL programming and instructing working for Intersolv/Merant/Micro Focus on Y2K projects. 2001 Mainframe/COBOL and DB2 while working for Merant on a contract at State of Missouri (1999).
• 2001...2001 Micro Focus COBOL at Group 1 Software (2000).
• 2003...2003 Micro Focus on UNIX upgrade work on contract at US Department of Labor.
OTHER EXPERIENCE:
• 2002-2012 full and part time. Andrews International / Vance Security USA Security officer and Lieutenant.
o Patrol, inspections, access control and alarm response at a Defense Department installation.
o Maintain staffing plans and records.
o Issue, control and account for weapons and equipment.
• University adjunct computer science assistant professor. University of Houston Downtown, Towson University
• Navy and Merchant Marine officer, marine insurance underwriter
• Spanish language tested FSI 3+. Teacher, English as a second language.
REFERENCES
Work Email
Current Company
Current Job title
Direct Phone
Julie Jasper
adtzu3@r.postjobfree.com
3nSolutions, Inc.
Business Manger
John Kovach
Alapko Inc
CEO
Richard Greenstreet
adtzu3@r.postjobfree.com
(Was at NCI)
Mike Bowles
Andrews International
Security supervisor
Richard Roberts
CACI
Software Developer