Patrick developed a PySpark-based Regional Population Analysis Script for the BigData2025-Rev/p3 repository, enabling computation of total population per region per decade from ORC-formatted census data. Leveraging Python, PySpark, and SQL, he established an end-to-end data pipeline that ingests ORC data, aggregates regional totals, and exports results to CSV for downstream analytics and reporting. His work included code cleanup to improve maintainability and laid the foundation for future dashboard integration. While the project spanned one month and focused on a single feature, it demonstrated depth in data engineering and provided a scalable component for analytics-driven decision support.