Data & Automation Analyst | Ph.D. Candidate

Nathan
Schweikart

Ph.D. candidate specializing in U.S. foreign policy and national security. Marine Corps veteran with Iraq and Afghanistan deployments. Eight years of experience transforming government operations through data analysis and automation. Expert in Power BI, PowerApps, Power Automate, and SharePoint, delivering integrated solutions that streamline reporting and drive decision-making. Building secure, scalable tools while expanding into Databricks, APIs, and AI-powered automation. Active Secret clearance.

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

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 Live Monitoring
InfoPath InfoPath
Survey Tracker System

Built 30+ survey templates using Microsoft InfoPath to replace manual PDF processes, creating automated system with SharePoint Designer workflows.

InfoPath SharePoint Automation
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 full dashboard
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 application
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 interface
Databricks Databricks
HEIC File Conversion Tool

Created Databricks-based automation to batch-convert HEIC images to JPEG, reducing manual processing by 90%.

Databricks Python

Client Projects

LiberationFT LiberationFT
LiberationFT.com

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

WordPress Business Current Build
FoghornGlobal FoghornGlobal
FoghornGlobal.com

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

WordPress Federal Current Build
MasadaCorps MasadaCorps
MasadaCorps.com

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

WordPress International Previous Build

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 Finance
ResearchPanda ResearchPanda
ResearchPanda.io

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

AI Platform WordPress SaaS
WatchdogJobs WatchdogJobs
WatchdogJobs.com

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

WordPress Marketing Web Scraping
🌐
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