AI-enabled project controls and workflow automation

Building practical tools that turn project controls workflows into repeatable, decision-ready systems.

This portfolio showcases automation projects for schedule analysis, Smartsheet workflow support, project reporting, and AI-assisted process improvement.

View Projects GitHub Profile

Portfolio Projects

Project controls tools built with Python, GitHub, and AI-assisted development.

Project #1

Schedule Movement Analyzer

A Python tool that compares original and updated milestone dates, calculates schedule movement, and produces a variance report for project controls review.

  • Business problem: Schedule changes are hard to summarize consistently across milestones.
  • Automation solution: Read a schedule CSV and calculate calendar-day and workday movement.
  • Skills shown: Python, CSV processing, date logic, validation, testing, GitHub documentation.
View Repository

Project #2

Smartsheet Formula Helper

A Python tool that converts structured Smartsheet formula examples into a reusable Markdown reference guide organized by formula type and business use case.

  • Business problem: Smartsheet formulas are easy to break and hard to standardize across teams.
  • Automation solution: Store formula patterns in a CSV and generate a clean reference guide.
  • Skills shown: Python, Markdown generation, Smartsheet workflow logic, validation, unit tests.
View Repository

Project #3

AI Portfolio Site

A static portfolio website that presents project controls automation work in a business-facing, web-accessible format.

  • Business problem: GitHub repositories alone are not always easy for non-technical viewers to evaluate.
  • Automation solution: Create a central site with project summaries, demos, and repository links.
  • Skills shown: HTML, CSS, JavaScript, GitHub Pages, portfolio storytelling.
View Demo Sections

Portfolio Approach

Each project is built around practical business value.

The goal of this portfolio is not just to demonstrate code. Each project starts from a real workflow problem, defines a repeatable process, and produces an output that would help a project manager, project controls team, or operations leader make better decisions.

Interactive Demo

Sample schedule movement analysis

This tool is being expanded into a browser-based analyzer for exported Smartsheet .xlsx schedules. It will use only the columns mapped below and ignore unrelated columns that may exist in the export.

Files are intended to be processed locally in the browser from a Smartsheet export, not through a Smartsheet API integration.

Phase 2 Workbook Preview

Uploaded Smartsheet schedule analyzer

Choose a Smartsheet .xlsx schedule export and map the columns the analyzer should use. Extra columns in the file will be ignored.

Phase 2 validates mapped columns and previews normalized rows only.

Column Mapping

Enter column names exactly as they appear in the exported schedule.

Map the required columns and choose a Smartsheet .xlsx export to prepare the analyzer.

Placeholder

Executive Summary

Future high-level counts, date movement totals, and schedule health indicators will appear here.

Placeholder

Task Movement Detail

Future task-by-task baseline versus current start and finish movement results will appear here.

Placeholder

Estimated Critical Path

Future predecessor-based critical path estimates and driving task notes will appear here.

Placeholder

Dependency / Data Quality Warnings

Future missing dates, unmapped required fields, broken predecessor links, and other data issues will appear here.

Future Option

Future Download .xlsx Summary

A later phase can add a generated workbook summary for sharing the schedule movement analysis.

Sample Demo

Hardcoded schedule movement sample

This small sample keeps the original demo logic available until uploaded workbook parsing is added.

Click the button to calculate sample schedule movement results.
Milestone Original Date New Date Calendar Days Moved Workdays Moved Movement Direction

Interactive Demo

Smartsheet formula builder

Choose a formula pattern, enter the relevant Smartsheet columns, and generate a copy/paste-ready formula with setup notes for any cross-sheet references.

What this formula does

Generated Formula


            
            

            

          

        

      

    


    

      

        
About This Portfolio

        
Built around real project controls workflows.

        

          This portfolio focuses on practical automation: schedule analysis, Smartsheet formula logic,
          project reporting, workflow standardization, and AI-assisted process improvement.
        

        

          Each project is designed to show both technical growth and business value: clear inputs,
          repeatable logic, useful outputs, documentation, testing, and version control.