Data Science Intern
· Mortenson
Delivered end-to-end data science solutions at Mortenson, building machine learning pipelines, a Flask app for executives, and Fabric and Power BI analytics to improve labor forecasting and financial decisions.
- Engineered an adaptive ML pipeline that cleans/normalizes construction task data, performs advanced feature engineering (transformations, encoding, outlier handling, synthetic rows), and systematically evaluates preprocessing/modeling “lever” combinations across NNs/GBMs/regularized linear models with nested cross-validation—outperforming estimator baselines.
- Benchmarked and diagnosed model performance vs. human estimators; exported deployable bundles (scalers/encoders/hyperparameters) to streamline inference and reproducibility.
- Built a Flask-based web app (Plotly + DataTables) that lets estimators input project details, generate hour/productivity predictions, visualize results against historical benchmarks, and explore most-similar past projects—demoed to Mortenson’s President.
- Automated ETL to scrape and consolidate hundreds of semi-structured financial documents into structured Excel (representing billions of dollars), then produced Python-driven graphs/tables across projects, years, and teams.
- Integrated Microsoft Fabric dataflows with Power BI semantic models and built multi-page dashboards comparing solar/renewables project KPIs for exec-ready insights.