Principal Application Developer (Sr.)
Current• Designed and implemented an ETL pipeline to extract, transform, and load USA Spending data, increasing update frequency from monthly to daily, resulting in a 30% reduction in FTE hours for the Federal Government’s DATA Act program.• Led the development of a scalable ETL process to ingest and consolidate data from multiple SharePoint files into a data warehouse, enabling the automation of backend workflows for DHS’s Federal Assistance Program Oversight, enhancing reporting efficiency.• Architected backend systems that unified financial assistance data for DHS, integrating monthly extracts from USA Spending and APIs, streamlining data consumption for analytics teams.• Developed and presented innovative NLP solutions to automate appropriations summaries from Congressional bill text, saving over 100 analyst hours, and driving process automation.• Advocated for best-in-class software engineering workflows by spearheading initiatives for version control, documentation, and project management tools, securing leadership buy-in and ensuring team-wide adoption.• Collaborated with cross-functional teams to establish short- and mid-term visions for integrating the entire data engineering lifecycle, aligning efforts with management and technical teams to streamline processes.• Created a disk profiler utility that sends an email with a report of large files and predicts when the disk space will hit a critical low that aids in resource planning.