Sarishma Paudel

• Implemented earmarked forecast tracking within the Contract Capacity Power App to centralize projected commitments and provide real-time visibility into remaining contract capacity.

•Developed a Contract View Model-Driven application with department based access controls that enabled operational users to manage contract data while providing leadership with visibility into expiring contracts for proactive oversight and renewal planning.

• Created Power Automate flows to streamline workflows, automate repetitive tasks, and synchronize data across SharePoint, and Excel for accurate and efficient record updates.

• Built interactive Power BI dashboards and KPI models to support burn rate analysis, capacity utilization tracking, and leadership decision-making.

• Optimized performance of large datasets (30,000+ records) through indexing, pagination, and batch processing, improving load times by over 50%.

• Developed Microsoft Access databases, interfaces, and VBA automation to support procurement tracking, billing management, milestone monitoring, and data synchronization across 80+ active solicitations.

• Conducted cost and schedule variance analysis, collaborating with project teams to implement corrective actions and strengthen budget oversight.

•Developed a multi-metric Workload Report consolidating capacity, assignment, and utilization data, enabling leadership to proactively balance workloads and optimize resource allocation across programs.

• Automated QA data extraction from Autodesk PDFs using Workato, reducing manual data entry and improving quantity tracking accuracy.