Ethan Smith
Richmond,VA
Summary
Experienced DoD Project Officer with expertise in wage surveys and federal pay systems, establishing accurate Federal Wage System (FWS) schedules and supporting Non-Appropriated Fund (NAF) payband administration. Proficient in SQL and HRIS management, overseeing database operations operations across Appropriated and Non-Appropriated Funds. Skilled in data analysis, system modernization, and large-scale project execution, delivering efficiency and strategic impact.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Project Officer
Department of Defense, DCPAS
05.2019 - Current
- Plans, coordinates, monitors, processes Full Scale and Wage Change surveys.
- Analyzes wage data in order to propose paylines and present exhibits to supervisor.
- Successfully gains management acceptance for HR recommendations affecting DOD components, establishing precedents and new program requirements.
- Reviews and assesses new legislation and regulations; recommends legislative needs in assigned program areas.
- Evaluates and recommends plans for HR projects impacting DOD directives; develops policies, and interpretive guidance, and conducts data analysis using SQL, Excel, and Access.
Data Collecting Agent
Department of Defense, DCPAS
05.2017 - 06.2019
- Work as a Data Collecting Agent for the Department of Defense collecting and analyzing data to set Non-Appropriated Fund wage schedules.
- Use MS Excel and Access to analyze multiple sets of data, identify key findings, and create wage pay lines.
- Prepare and present exhibits of trendlines and pay schedule proposals to be reviewed by the DoD Wage Committee.
- Use strong communication skills to interview contacts and gather data in wage localities across CONUS.
- Exemplify project management, and coordinate logistics with base commands and local HR officials.
Education
Bachelor of Arts - Sociology, Naval Sciences
University of North Carolina At Chapel Hill
Chapel Hill, NC05.2017
Skills
- Expert in SQL
- Compensation Analysis
- Data Analysis
- Leadership Briefings
- Microsoft Access
- Microsoft Excel
- Power BI
- Project Management
- Atlassian Jira
- Technical Writing
Certification
- Associate Data Analyst in SQL-DataCamp - 2025-05 to Present
- The Complete SQL Bootcamp - Udemy - 2022-03 to Present
- Statistics with R - Duke University Online - 2019-01 to Present
- Position Classification for Supervisors and Administrative Staff - Graduate School USA - 2017-11 to Present
Timeline
Project Officer
Department of Defense, DCPAS
05.2019 - Current
Data Collecting Agent
Department of Defense, DCPAS
05.2017 - 06.2019
Bachelor of Arts - Sociology, Naval Sciences
University of North Carolina At Chapel Hill
Similar Profiles
Kori D. EarleyKori D. Earley
Priority Placement Support Branch Assistant at DoD-Defense Human Resources Activity/DCPASPriority Placement Support Branch Assistant at DoD-Defense Human Resources Activity/DCPAS
Amber TomaszewskiAmber Tomaszewski
Administrative Assistant at Department of Defense - Defense Contract Management AgencyAdministrative Assistant at Department of Defense - Defense Contract Management Agency
Isabella Manzione DearbornIsabella Manzione Dearborn
Student Intern at Department of Defense - Defense Counterintelligence and Security AgencyStudent Intern at Department of Defense - Defense Counterintelligence and Security Agency
Aashna BoolchandaniAashna Boolchandani
Shift Leader at Nautical BowlsShift Leader at Nautical Bowls
Jack HarperJack Harper
Intern at IndiviorIntern at Indivior