LEA Attendance Data Reporting

End to end ETL attendance staff data reporting on a weekly, monthly, and quarterly cadence for bond compliance, state reporting, and internal data tracking

LEA Budget Balance Tracking

Data extraction, cleaning, and manipulation to track budget line items, campus, and overall budgets from PDFs exported from accounting software using the tabula-py package to track and analyze month over month spending and overall budget balances

LEA Data Pipeline

Establishing an API connection with LEA SIS to perform ETL and create a data pipeline to BigQuery to automate reporting workflows for finance and academic outcomes

LEA Enrollment Enrollment Calculator

Enrollment calculator developed for an LEA based on enrollment date, transfer date, and non-service days for data management and state reporting that is directly related to per-pupil funding.

LEA Enrollment Enrollment Calculator

Enrollment calculator developed for an LEA based on enrollment date, transfer date, and non-service days for data management and state reporting that is directly related to per-pupil funding.

MAT-PDOA ETL GPRA Reporting

A series of python scripts that code MAT-PDOA outcomes for GPRA submission through SPARS.

STAR ETL GPRA Reporting

Series of python scripts that code STAR outcomes for GPRA submission for the Rutgers Addition Recovery Center

SBIRT ETL GPRA Reporting

End to end ETL of GPRA data generated from via the implementation of the Screening, Brief Intervention, and Referral to Treatment (SBIRT) services at RWJBarnabas facilities in New Jersey from the EHR and uploaded into SPARS.