Digital Products Portfolio

Power BI Enterprise Wide Deployment

Unlocking data potential—The Power BI Premium Rollout expands reporting capabilities, streamlines access, and empowers data-driven decision-making agency-wide.

Read More

Major Projects Involvement

Enhancing oversight for high-risk projects—MPIA streamlines data collection, automates risk assessments, and ensures IIJA compliance with real-time insights

Read More

Data FLEx Program

Empowering teams with data-driven skills—this initiative pairs staff to boost Power Platform adoption, streamline projects, and enhance agency-wide collaboration.

Read More

Grants Management System

Transforming grant management with automation and real-time insights—GMS streamlines processes for 3,000+ stakeholders, boosting efficiency and transparency.

Read More

IIJA Product Inventory

Streamlining policy tracking—The Product Inventory App automates management for 200+ policy products, enhancing accuracy, efficiency, and compliance.

Read More

Data Analytics User Group

Fostering a data-driven culture—The Data Analytics User Group (DAUGs) connects advanced data users across FHWA to collaborate, solve challenges, share ideas, and support agency-wide data excellence.

Read More

Tribal SharePoint Site

Centralizing tribal data—The Tribal Resources SharePoint site provides DOT-wide access to tribal profiles, state summaries, and engagement records, streamlining collaboration and data sharing through a custom-built Power Apps tool.

Resource Needs Tool

Optimizing resource planning—The FHWA BIL Unit Resource Needs Assessment Tool streamlines data collection, automates cost estimates, and enhances strategic decision-making.

COVID Protocols

Automating COVID-19 safety—This dashboard integrated CDC data via API, tracking local COVID levels and automating weekly protocol updates for FHWA offices, ensuring timely compliance and communication.

Project Details

Power BI Enterprise-Wide Deployment

Objective: To establish a governed, scalable, and user-friendly enterprise-wide reporting environment using Power BI across FHWA.

Problem Solved: Decentralized reporting practices, lack of governance, and inconsistent access to analytics tools and training across the agency.

Technologies Used: Power BI (Pro & Premium), SharePoint, Power Automate, Microsoft Forms.

Key Features:
Developed FHWA’s agency-wide Power BI Governance Plan to ensure secure, consistent, and effective use of analytics
Led the rollout of Power BI Premium to enable broader report sharing without requiring individual licenses
Built automated solutions for license requests and workspace management using Power Automate
Created a central SharePoint hub for documentation, resources, FAQs, and announcements
Designed and launched a full training program, including tutorials, onboarding guides, and live sessions

Outcome:
Standardized Power BI usage across FHWA through governance and best practices
Expanded access to data insights via shared reports and dashboards
Improved license and workspace management through automation
Fostered user adoption through accessible training and a centralized knowledge base
Awarded the FHWA Corporate Award for Data Analytics Power BI Implementation
Received the FHWA Program and Management Analysis “Leading the Way” Award

Major Project Involvement Application (MPIA)

Objective: To collect, screen, and assess Major Projects and Public-Private Partnership (P3) projects for potential risk and the level of Federal Highway Administration (FHWA) involvement.

Problem Solved: Lack of consistent, centralized data collection and risk screening for high-cost infrastructure projects and P3 initiatives using federal financial assistance.

Technologies Used: SharePoint, Power Apps, Power Automate, Microsoft Word (templating), internal FHWA systems.

Key Features:
Standardized intake form for Major Projects and P3 initiatives
Two-part screening process: project summary and risk characteristic assessment
Corporate screening tool to identify projects with high-risk potential
Automated generation of printable digital risk assessments and oversight plans using Power Automate and Word templates
Built-in compliance tracking with IIJA Section 11508 requirements
Supports resource planning and stewardship oversight for high-risk projects

Outcome:
Enabled consistent, high-level visibility into upcoming Major Projects
Improved FHWA’s ability to assess and respond to project risk
Streamlined compliance with federal mandates related to P3 projects
Increased efficiency through automation and standardized documentation
Informed decisions on resource allocation and oversight planning
Received the FHWA Administrator’s Award for Excellence in Teamwork – Major Projects S&O Procedures & Tools
Awarded the FHWA Office of Infrastructure AA Coin for Major Projects Digital Product Development

Data FLEx Program

Objective: To build internal capacity for data-driven projects by pairing junior and senior staff members.

Problem Solved: Limited internal capacity and uneven adoption of Power Platform tools.

Technologies Used: Power Apps, SharePoint, Power BI, Power Automate.

Key Features:
Simplified intake process for project participation.
Interactive dashboards for tracking progress and participation.
Automated tools for matching staff to projects.

Outcome:
Broader adoption of Power Platform tools across the agency
Expanded collaboration and skill-building through cross-level team pairing
Received the FHWA Administrator’s Award for Excellence in Teamwork – Data FLEx Pilot Program & Projects

Grants Management System

Objective: To establish FHWA’s first centralized system for managing discretionary grants, improving efficiency, compliance, and data visibility across the grant lifecycle.

Problem Solved: FHWA previously lacked a system to manage discretionary grants end-to-end, resulting in fragmented processes, limited transparency, and increased compliance risks.

Technologies Used: GrantSolutions (SaaS), SharePoint, Power Apps, Power Automate.

Key Features:
Led a team in the agency-wide implementation of the GrantSolutions SaaS platform
Conducted extensive stakeholder outreach to identify requirements and drive user-centered design
Customized platform workflows to align with FHWA-specific grant processes and regulatory needs
Designed and deployed a supporting internal data tracker using SharePoint, Power Apps, and Power Automate
Enabled real-time data tracking and reporting
Created a secure, automated workflow to transfer data to a read-only list for visibility and auditability
Developed comprehensive training materials and led cross-office onboarding efforts
Established a post-launch support framework for continuous improvement and user feedback

Outcome:
Digitized and standardized FHWA’s discretionary grant process from application to award and compliance
Reduced processing time and improved compliance tracking
Increased internal transparency through custom-built data dashboards
Positioned the agency for future integration and scalability with other digital tools
Received the U.S. DOT Secretary’s Team Award for Creativity and Innovation
Awarded the FHWA IT Excellence Award by the Information Technology Discipline

IIJA Product Inventory

Objective: To establish a centralized, digital solution for tracking and managing FHWA policy products related to the Infrastructure Investment and Jobs Act (IIJA) and Inflation Reduction Act (IRA).

Problem Solved: Previously, FHWA relied on manual, ad hoc methods to track over 200 required IIJA/IRA policy products—leading to duplicated efforts, data inconsistencies, and frequent last-minute reporting burdens on staff.

Technologies Used: SharePoint, Power Apps, Power Automate, Excel (for export capabilities), internal FHWA systems.

Key Features:
Centralized Master Dataset for managing all IIJA/IRA-related policy products
Role-based user interface allowing Program Offices to update and track their own products
Streamlined data entry processes with built-in validations and automation
Real-time dashboards and exports for agency leadership, OST, and White House reporting
Power Apps + Power Automate workflow for automated user access requests, dynamically updating SharePoint permissions without admin overhead
Supports tracking of key product types: program guidance, FAQs, NOFOs, NPRMs, and more
Scalable framework designed to expand to additional policy products in the future

Outcome:
Eliminated redundant data calls and manual data compilation
Improved visibility and accountability for over 200 FHWA IIJA/IRA products
Freed up Program Office time for content development rather than reporting
Created a “single source of truth” for timely and consistent internal and external reporting
Positioned FHWA for scalable, future-facing policy tracking and performance management
Received the U.S. DOT Secretary’s Team Award for Creativity and Innovation

Data Analytics User Group (DAUG)

Objective: To foster a data-driven culture at FHWA by creating a grassroots community of data users focused on collaboration, accessibility, and continuous learning.

Problem Solved: Siloed data practices, limited access to shared knowledge, and inconsistent support for analytics efforts across the agency.

Technologies Used: Power Platform, SharePoint, Microsoft Teams.

Key Features:
Open-to-all community for staff interested in data and analytics
Monthly meetups with demos, project showcases, and knowledge sharing
Peer support and real-time Q&A via Teams channels
Curated library of best practices, tools, and templates
Led by a volunteer steering committee guiding initiatives and community growth

Outcome:
Established a vibrant peer-led network supporting data accessibility and literacy
Empowered staff to explore and apply analytics tools more effectively
Sparked innovation and cross-office collaboration through shared learning
Strengthened internal capacity for data-driven decision-making.