Andrew McRae
Ashburn
Summary
Accomplished Senior Consultant with expertise in data analysis and visualization, having led tech-driven solutions at the Office of the Assistant Secretary of Defense for Readiness. Proficient in Python and Excel, adept at strategic communication and stakeholder engagement, enhancing operational efficiency and delivering critical defense metrics.
Overview
6
6
years of professional experience
Work History
Senior Consultant
Office of the Assistant Secretary of Defense for Readiness (OASD(R) Force Readiness)
05.2024 - 05.2025
- Led the development of tech-driven solutions, overseeing the implementation of system changes, and the creation of dynamic dashboards to enhance operational efficiency.
- Provided a high-level readiness analysis, integrating and interpreting complex data sets to assess force readiness, inform senior leadership decisions, and evaluate near- and long-term readiness impacts.
- Designed and maintained strategic methodologies, leveraging classified databases and stakeholder insights to develop tools that deliver critical defense metrics, and readiness assessments.
Senior Consultant
Cybersecurity and Infrastructure Security Agency
09.2022 - 05.2024
- Leads the technical development for upcoming capabilities, to include automated workflows, documentation of finished work, creation of dashboards, process requirement standards, and all government requirements for applications.
- Client-facing meetings as the lead developer include answering any questions posed by the client, providing a detailed outline of all capabilities, and creating a standard operating procedure for the usage of present and future capabilities.
- Lead the efforts for a Sensitive Compartmented Information Facility (SCIF) presence while conducting the stand-up for SCIF-related work. This included all scheduling for the contractors, created a training document for all feds and contractors, and led the training for Request for Information intake, triage, response, and distribution.
Senior Consultant
Immigration and Customs Enforcement
04.2022 - 09.2022
- Supported the IHSC analytics workstream to gather requirements, map processes, and create critical documentation and SOPs to improve office collaboration and efficiency.
- Directed and assisted team members in cross-office communications to reduce office redundancies and maximize team member utilization.
Federal Advisory Consultant
Department of Homeland Security (DHS) DSAD Project
05.2021 - 04.2022
- Performed analysis and tests for potential data repository systems prior to onboarding. These systems included Immuta and Collibra.
- Assisted in the data enrichment process for the client by testing APIs and processes to better enrich and clean the data. Also assisted in building the briefs for the client, showing total enrichment potential, and determining candidates based on available information.
Data Analyst
Industry: Data Science and Data analysis
08.2020 - 05.2021
- Use data visualization tools such as SAS, Tableau, and Excel Pivot tables to present and inform leadership of trends and changes in compensation data.
- Provide weekly updates of policy changes to leadership, and monitor government updates for compensation information.
- Overhauling the Excel workbook used to monitor bonus compensation to remove all macros and implement a process in which to track organizational awards and bonuses.
Data Scientist
Industry: Data Science and Analysis
10.2019 - 08.2020
- Explain mathematical formulas and statistical findings to non-technical users, and decision makers.
- Create and diagnose Python scripts to use in the processing and analysis of different sources of quantitative and qualitative data.
- Extract business insights from the analysis of data, and communicate and relay information using Excel.
Research Analyst
Industry: Counter Intelligence
12.2018 - 10.2019
- Identify intelligence gaps, and assist in the development of intelligence collection programs.
- Brief intelligence assessments and positions for senior civilian and Army personnel.
- Research and analyze military, political, economic, technical, and other developments within assigned areas to conduct valid threat assessments.
Education
Certification - Data Analysis
eCornell
11.2019
Skills
- Software / Products:
- Python: Experienced
- SQL: Experienced
- AWS (S3, EC2): intermediate
- General Tools:
- Microsoft Excel: Expert
- Microsoft Word: Expert
- Microsoft PowerPoint: Expert
- Data analysis
- Data visualization
References
Spencer, Conley, Sr. Consultant – Team lead, spconley@deloitte.com, Deloitte
Security Clearance
Top Secret SCI w/ CI Polygraph
Timeline
Senior Consultant
Office of the Assistant Secretary of Defense for Readiness (OASD(R) Force Readiness)
05.2024 - 05.2025
Senior Consultant
Cybersecurity and Infrastructure Security Agency
09.2022 - 05.2024
Senior Consultant
Immigration and Customs Enforcement
04.2022 - 09.2022
Federal Advisory Consultant
Department of Homeland Security (DHS) DSAD Project
05.2021 - 04.2022
Data Analyst
Industry: Data Science and Data analysis
08.2020 - 05.2021
Data Scientist
Industry: Data Science and Analysis
10.2019 - 08.2020
Research Analyst
Industry: Counter Intelligence
12.2018 - 10.2019
Certification - Data Analysis
eCornell
Similar Profiles
Chenshi LiChenshi Li
Squadron Commander Secretary at US Air Force, 354th Logistics Readiness SquadronSquadron Commander Secretary at US Air Force, 354th Logistics Readiness Squadron
Saphronia BradfordSaphronia Bradford
Senior IT Program Manager at HHS, Office of the Secretary, Assistant Secretary of Health, Office of the Surgeon General, Commissioned Corps Headquarters (CCHQ)Senior IT Program Manager at HHS, Office of the Secretary, Assistant Secretary of Health, Office of the Surgeon General, Commissioned Corps Headquarters (CCHQ)
Donald WynnDonald Wynn
Lead Contractor, Electronic Health Records, Program/Project Manager at Air Force Medical Readiness AgencyLead Contractor, Electronic Health Records, Program/Project Manager at Air Force Medical Readiness Agency
Tyler F. SmithTyler F. Smith
Cypress Developer at ICF International, Inc.Cypress Developer at ICF International, Inc.
Alaq HameedAlaq Hameed
Dental Assistant at Ashburn Pediatric Dental CenterDental Assistant at Ashburn Pediatric Dental Center