Lead a team of data engineers to consolidate siloed data sources into a unified data lake and warehouse framework to support digital twin applications focused on part reliability, aircraft configuration, and readiness. (Python, Teradata)Design and implement ETL processes to convert binary vehicle flight sensor and fault data streams into readable formats, reducing a manual process from days to hours and enabling the data science team to develop system fault detection features. (Python)Develop an aircraft part configuration thread to track the full lifecycle of installations, removals, and maintenance actions, using text cleansing techniques on maintenance narratives to improve data accuracy. (Python, Teradata)

Implemented a standardized data model to unify reporting for data center project management activities, replacing disparate SQL views across teams and ensuring consistency in business intelligence reporting. (Oracle, Presto, Tableau)Developed SQL pipelines and Tableau dashboards to enable managers to monitor staff compliance with project management inputs for data center facility engineering efforts, resulting in improved oversight and streamlined project tracking. (Oracle, Presto, Tableau)Conducted ad-hoc analyses on big data warehouses and upstream transaction databases related to facility engineering projects to support decision-making and optimize project management strategies. (Oracle, Presto)

Designed, developed, and maintained a firm-wide headcount warehousing solution and reporting suite to track the status and movement of all firm staff and attorneys, optimizing workforce management. (Cognos Analytics, SQL Server, SSDT)Built SQL pipelines and reporting solutions to generate actionable insights from enterprise financial data, supporting departments such as Firm Accounting, Partner Accounting, Strategic Planning, and Human Resources. (Cognos Analytics, SQL Server, SSDT)Developed metadata model layers from time and billing data warehouses, enabling self-service reporting and reducing reliance on the business intelligence team. (Cognos Framework Manager, Cognos Analytics, SQL Server)Created web applications to facilitate the submission, analysis, and reporting of staffing needs and budget planning across multiple departments. (ASP.NET, SQL Server)