Data & Automation Analyst | Ph.D. Candidate

Nathan
Schweikart

Ph.D. candidate in International Relations with a decade of experience supporting U.S. diplomatic and defense missions worldwide. Marine Corps combat veteran with combat deployments to Iraq and Afghanistan. Currently building assessment tools and automation systems for the Bureau of Diplomatic Security under the Department of State—through Power BI dashboards, PowerApps workflows, and SharePoint automation. Web Application Designer with a track record of building platforms that reached 100,000+ users. Expanding into AI-powered automation, LLM engineering, and API integration.

Nathan Schweikart

Experience

Data and Automation Analyst
Cherokee Federal | Arlington, Virginia
Mar 2024 - Present
  • Design and maintain automated reporting tools using Power BI, PowerApps, Power Automate
  • Analyze data from secure access systems and field operations for strategic decisions
  • Lead process automation efforts to streamline workflows across regional operations
  • Maintain structured databases and extract insights from multiple data sources
  • Support Bureau of Diplomatic Security with compliance and security objectives
  • Enhance data visibility across regional and post-level operations
Owner | Website and Automations Build
ClearanceOK | Remote
Jul 2023 - Present
  • Founded WatchdogJobs.com, generating $25,000+ in under a year
  • Built The Veteran's Wallet newsletter, generating $140,000+ in ten months
  • Developed and marketed job boards and forums for security professionals
  • Led CRM setup and drove user growth through digital campaigns
  • Currently building ClearanceOK platform for clearance holders
  • Managing multiple WordPress platforms and automation systems
Diplomatic Access and Clearance Control
Cherokee Federal | Baghdad, Iraq
Dec 2021 - Mar 2023
  • Delivered critical security support to U.S. Mission Iraq under ARSO direction
  • Oversaw clearance verifications, ClassNet access, and VARs for thousands
  • Enforced mission-wide access control protocols in high-risk environment
  • Responded to urgent after-hours clearance requests and emergencies
  • Coordinated RSO-led security briefings ensuring U.S. government compliance
  • Maintained security records for personnel entering secure U.S. facilities
Overseas Diplomatic Security (Protection Detail)
Constellis | Baghdad, Iraq
Mar 2017 - Oct 2021
  • Provided protective services for U.S. diplomats under State Department WPS
  • Executed high-risk missions, motorcade operations, and QRF support as PSS
  • Managed live mission tracking in embassy operations center as OSS
  • Maintained real-time visibility of personnel movements using MS Access
  • WPPS I & II certified with DOMSEC, OSS, and PSS approvals
  • Earned Employee of the Month recognition for OSS position excellence
Logistics Security Manager/Guard
Triple Canopy | Beersheba, Israel
Jun 2014 - Oct 2016
  • Secured over $1B in critical assets during Operation Protective Edge
  • Provided armed security in support of Israeli Defense Force operations
  • Managed logistics including housing, transport, gear, and inventory
  • Coordinated visa processing and served as customs liaison
  • Streamlined reporting for protective security and administrative functions
  • Operated in high-risk environment supporting both security and logistics
Department of Defense Security Specialist
United States Department of Defense | Fort Myer & Fort McNair
Jul 2013 - Jun 2014
  • Conducted armed access control at high-security military installations
  • Verified personnel and vehicle credentials enforcing DoD regulations
  • Responded to alarms and security incidents with tactical precision
  • Conducted thorough vehicle and facility inspections
  • Prepared detailed security reports maintaining operational readiness
  • Protected high-profile federal environment from unauthorized access
Force Protection Armed Guard / Radio Transmission Officer
DynCorp International | Ferizaj, Kosovo
Feb 2012 - Feb 2013
  • Provided armed security for U.S. forces under KFOR operations
  • Managed base access and conducted perimeter security patrols
  • Operated ESS surveillance cameras and Rapiscan X-ray scanners
  • Served as RTO dispatching patrols and maintaining situational awareness
  • Assigned communications equipment and produced incident reports
  • Gained proficiency in MS Office and operations center procedures
Artillery/Designated Marksman
United States Marine Corps | Camp Lejeune, Iraq, Afghanistan
Jun 2007 - Aug 2011
  • Led and supervised 50+ Marines in artillery and provisional infantry roles
  • Assistant Chief of M777A2 Howitzer system coordinating fire missions
  • Designated Marksman on 100+ combat/humanitarian patrols in Helmand
  • Executed compound raids targeting IED materials and insurgent activity
  • Expert in multiple weapon systems including .50 cal and MK19
  • Promoted to Sergeant (E-5) and honorably discharged

Education

Doctorate in International Relations (Ph.D. Candidate)
Salve Regina University - Newport, RI
Expected 2026
Master of Arts in Public Policy: Foreign Affairs
Liberty University - Lynchburg, VA
2019
Bachelor of Science in Emergency Management and Homeland Security
National University - La Jolla, CA
2017

Military Service

United States Marine Corps • Active Duty Combat Veteran • Honorably Discharged
Iraq Iraq
Iraq
Camp Baharia | Fallujah | 2008-2009
Artillery Support Operations
Afghanistan Afghanistan
Afghanistan
Kajaki District, Helmand Province | 2010-2011
Provisional Infantry - Designated Marksman
Medals & Awards
• Combat Action Ribbon (Afghanistan)
• Certificate of Commendation (x2)
• Good Conduct Medal
• Iraq Campaign Medal (2 Bronze Stars)
• Afghanistan Campaign Medal (1 Bronze Star)
• National Defense Service Medal
• Global War on Terrorism Expeditionary Medal
• Global War on Terrorism Service Medal
• NATO Medal - ISAF Afghanistan
• Sea Service Deployment Ribbon
• Designated Marksman Course Completion
• Expert Marksmanship Award (x3)

Technical Projects & Skills

Work Projects

HTML / CSS / JavaScript

Facility System Facility System
Facility Deficiency Management System

Built comprehensive web application for tracking security deficiencies across global diplomatic facilities. Features Desk Officer, OBO, and Report views with risk scoring, regional breakdowns, and PDF export capabilities.

JavaScript HTML/CSS Risk Analysis
Click to view
Weighting Tool Weighting Tool
DS Deficiency Weighting System Tool

Developed risk calculator integrating multiple threat indicators, facility criticality, and personnel factors. Generates weighted risk scores and exportable PDF assessment reports for security prioritization.

JavaScript Risk Methodology PDF Generation
Click to view
CAT Tool CAT Tool
CAT Design Approval Tool

Created CAC-compatible PDF processing tool for design approval memos. Enables secure digital signatures with all processing done locally in browser—no server uploads required.

JavaScript PDF Processing CAC Integration
Click to view
HEIC Converter HEIC Converter
HEIC to JPEG Converter

Created JavaScript-based browser tool to batch-convert HEIC images to JPEG, addressing file compatibility issues for Department systems. All processing done locally.

JavaScript File Processing
Click to view

Technical Writing

White Paper White Paper
Deficiency Weighting White Paper

Authored comprehensive 29-page white paper presenting data-driven approach to modernizing the Bureau of Diplomatic Security's Deficiency Prioritization Matrix using industry-standard risk assessment methodology.

Technical Writing Risk Methodology Policy
Click to view

Microsoft Power Platform

PowerBI PowerBI
MyPost Dashboard Modernization

Built Power BI dashboard connected to dozen+ SharePoint libraries to centralize global security data with real-time visibility.

Power BI SharePoint Data Viz
Click to view
PowerApps PowerApps
Analyst Workflow

Developed PowerApp integrated with Power Automate to streamline workflows, reducing task time from over an hour to 5-10 minutes.

PowerApps Power Automate
Click to view
PowerApps PowerApps
ResSec Cable App

PowerApp processing residential security cables, cross-referencing SharePoint libraries, generating AI prompts for StateChat.

PowerApps AI Integration
Click to view

Microsoft Office

Survey Survey
Physical Security Survey System

Led rebuild from Microsoft InfoPath to JavaScript platform. Integrated deficiency database, weighting logic, conditional questions by facility type, and locking feature to prevent post-signoff edits.

InfoPath SharePoint Workflow
Access Access
Diplomatic Security Movement Tracker

Built Microsoft Access and Excel-based system to track diplomatic security movements, integrating metrics such as passenger counts, routes, vehicles, and timelines. Synced live data to embassy operations center monitors.

Microsoft Access Excel Data Integration
Outlook VBA Outlook VBA
Bulk Email Archive Macro

Developed Outlook VBA macro to save emails as PDFs, extract attachments, organize into SharePoint-compatible folders, and create ZIP files for upload.

VBA Outlook Automation

Client Projects

LiberationFT LiberationFT
LiberationFT.com

Built and maintain WordPress site for professional firearms training business serving Redmond, Oregon community.

WordPress Business Active
FoghornGlobal FoghornGlobal
FoghornGlobal.com

Developed WordPress platform for US security federal contracting company focused on government contracts.

WordPress Federal Active
MasadaCorps MasadaCorps
MasadaCorps.com

Created WordPress site for Israeli innovation company specializing in US federal contracting opportunities.

WordPress International Discontinued

Previous Personal Projects

VeteransWallet VeteransWallet
TheVeteransWallet.com

Veteran-focused jobs and startup newsletter that generated $140,000 in revenue in just under a year - with 102,000 subscribers.

Content Newsletter Discontinued
ResearchPanda ResearchPanda
ResearchPanda.io

AI-assisted writing platform for academic researchers with advanced automation capabilities.

AI Platform WordPress Discontinued
WatchdogJobs WatchdogJobs
WatchdogJobs.com

Built WordPress job board platform generating $25,000+ through digital products and strategic marketing campaigns.

WordPress Marketing Discontinued
🌐
Digital Content Network

Built multiple platforms including Lynchburglist.com and Fightforacause.com with integrated analytics.

Website Designer Wordpress SEO & Analytics Facebook Marketing

Technical Skills

📊
Data & Analytics
Power BI
DAX
Excel Advanced
MS Access
Data Modeling
Automation
PowerApps
Power Automate
SharePoint
InfoPath
Workflow Design
💻
Development & Web Design
Python (Learning)
Databricks (Learning)
API Integration (Learning)
HTML/CSS/JavaScript (Learning)
WordPress Design (Professional)

Get In Touch

Let's Connect
🔗 LinkedIn
nathanschweikart
×

Currently Working On

Current Projects
ClearanceOK Platform Development
Building comprehensive job board platform for government professionals, contracting companies, and federal agencies
Current Learning
Ph.D. in International Relations
Completing doctorate at Salve Regina University focusing on U.S. foreign policy and national security
Python for Data Analysis
Coursera specialization in Python, pandas, and data science applications
Deep Learning A-Z 2025
Comprehensive course on neural networks, AI fundamentals, and advanced deep learning techniques
LLM Engineering
Mastering AI, Large Language Models, and building intelligent agents for enterprise applications

Project Screenshot

Project Screenshot