×
Philip Nelson

Philip Nelson

Data Analyst & IT Specialist

South Carolina, US

Background


About

About

Results-driven Data Analyst and IT Specialist with expertise in automation, data analysis, and cloud technologies. Proven ability to streamline workflows, improve data accessibility, and drive data-driven decision-making.

Work Experience

Work Experience

  • IT Specialist, HHS-OIG

    Jul, 2024 - Present

    Develops automation solutions to optimize data workflows and reduce manual toil. Conducts data analysis and cloud-based data processing to support decision-making processes.

    • Partcipates in initiatives to transition analysts from legacy SAS workflows to modern Python and cloud based solutions.

    • Conducts testing and validation for various systems that will be used by analysts as the organziation transitions.

    • Tests emerging technologies within the federal space while working with customers to make sure these solutions meet their needs.

    • Liases between developers and analysts to gather requirements for an object oriented library for analysts.

    • Conducts agency related work using both documented and undocumented REST APIs to allow OIG to expand its capabilities beyond typically used data sources.

  • Data Science Fellow, Pandemic Response Accountability Committee

    May, 2022 - Jul, 20242 years 2 months

    Conducted data extraction and analysis projects related to pandemic relief programs, ensuring transparency and oversight.

    • Optimized Python scripts, reducing execution time from hours to minutes, improving efficiency in data processing.

    • Maintained a dashboard for monitoring COVID-19 test kit billing, which contributed to fraud investigations.

    • Performed over 100 data extractions and analyses to support oversight efforts on pandemic-related relief programs.

    • Developed SQL-based fraud detection queries, identifying anomalies in relief program spending and leading to case referrals.

    • Led training sessions on Jupyter Notebooks to orient fellow analysts towards a more modern data analytics workflow.

Projects Experience

Projects Experience

  • Every Census Place (twitter bot)

    Oct, 2021 - 2022-11-31

    A bot that fetched Google Maps imagery of US Census Places and posted them to twitter. Utilized rasterio and geopandas in order to mask the images so only imagery within the place boundary were displayed.

Skills

Skills

  • Programming Languages

    Python

    SQL

  • Data Tools & Software

    AWS Textract

    DuckDB

    DBeaver

    Jupyter Notebooks

    Microsoft Suite

Education

Education

  • Computer Science, Bachelor, Winthrop University

    Aug, 2017 - Dec, 2021

Certificates

Certificates

  • Healthcare 101, HHS-OIG

    Issued on: Sep 20, 2023

  • SAS EBI Level I Training, One PI

    Issued on: Jan 27, 2023

  • COVID Fraud Training, HHS-OIG

    Issued on: Feb 15, 2024

References

References

  • Jennifer Wagner

    PLACEHOLDER (need to lookup title)

  • Mandy Brooks

    Senior Program Analyst, HHS Office of Inspector General

  • Karen Lowe

    Program Analyst, HHS Office of Inspector General