Data Architect It Specialist

Mark Pennock

San Antonio, TX *****

210-***-**** ️ ***********@*****.*** Open to Remote/Hybrid

Professional Summary

Results-driven Data Architect and IT Specialist with 15+ years of experience in database management, ETL, QA/QC, and workflow automation across healthcare and federal projects. Proven ability to design and optimize relational database systems, ensure data integrity and governance, and deliver accurate reporting solutions that improve decision-making. Skilled in SQL, Oracle, SSIS, ETL, and BI tools with a track record of implementing efficient data workflows and ensuring compliance with federal data standards.

Core Skills

Relational Database Management (SQL Server, Oracle, SSIS, ETL)

Data Extraction, Transformation & Loading (ETL)

Data Governance, Integrity & Stewardship

Data Quality Assurance (QA/QC) & Validation

Workflow Automation & Process Improvement

Business Intelligence & Data Visualization (QlikView, Actuate)

Technical Documentation & Data Workflow Mapping

IT Systems Administration (Windows Server, Security+, Patch Management)

Professional Experience

Kapili Services, LLC – Remote

Data Architect 05/2025 – 06/2025

Reviewed and analyzed organizational data infrastructure, planned improvements, and implemented solutions for efficient relational database management.

Performed data cleanup and optimization, ensuring consistency and accuracy in enterprise systems.

Developed technical workflows to streamline data management processes.

CGI / Aeyon / FAA (Contractor) – Remote

Sr. Project Manager / Sr. Business Consultant 04/2022 – 03/2025

Oversaw data-driven federal projects for FAA, ATF, and Bureau of Prisons, ensuring proper data integration and reporting.

Coordinated data processing and performed QA reviews on project deliverables to maintain compliance with standards.

Produced technical documentation and PMO reporting on project data workflows and system integrations.

Aeyon / Defense Health Agency (DHA) – Hybrid

Data Analyst / SME III 05/2021 – 04/2022

Managed SQL Agent tasks, SSIS package deployments, and ETL pipelines to support monthly data updates.

Performed data validation and QA/QC on large healthcare datasets (DMHRSi, MHS Genesis).

Documented data workflows, sources, and limitations, delivering insights through executive summaries and reports.

Assisted in automation of data processes to increase efficiency and reliability.

Regional Health Command – Central (RHC-C) – Fort Sam Houston, TX

IT Specialist (System Administrator), GS-12 07/2011 – 05/2021

Designed and maintained SQL databases, ETL jobs, and a regional data warehouse, improving data availability and accuracy.

Led EHR integration efforts, ensuring system compliance and improved data quality across medical facilities.

Conducted QA/QC reviews, patch management, and risk mitigation on 30+ enterprise servers.

Administered QlikView BI environment, enabling data visualization and reporting across the command.

Intellica LLC / Regional Health Command – Central – Fort Sam Houston, TX

Oracle DB Developer & Reports Specialist (Contractor) 07/2004 – 07/2011

Built ETL processes, stored procedures, and web apps to support healthcare readiness tracking.

Developed custom tools (PatientTrak, PrimeCare-Plus) to enhance data workflows, improve reporting accuracy, and reduce manual processing.

Extracted and processed data from multiple sources, creating reports for compliance and operational efficiency.

Education & Certifications

CompTIA Security+ Certification

Additional Professional Training: SQL Server, Oracle Development, Data Warehousing

Contact this candidate