Julian Perez

I'm a principal data specialist at Collins Aerospace, working on quality data for the Mission Systems business. Most of my time goes to data pipelines, data models and Power BI dashboards. Right now I'm leading the modernization of our Control Tower, which leadership uses to review quality across 37 sites each month.

I live in the Washington, DC area. Outside of work I run a photography business and build web projects that I host on my own server.

Work projects

Projects from my jobs at Collins Aerospace and Raytheon. I can't share company data, so the charts in these write-ups use made-up sample data.

Collins Aerospace

Sept. 2023 – Present

These are three separate projects. They're all aimed at getting quality reporting off manual spreadsheets and onto automated pipelines.

In progress

Control Tower modernization

Replacing the SharePoint lists, Power Apps and Excel trackers behind the Control Tower with an Azure SQL star schema and an Ignition portal for monthly site submissions. 21 metrics across 37 sites.

Azure SQL, T-SQL, Ignition, Power BI

Read the case study: Control Tower modernization

In progress

Quality dashboards on Snowflake

One shared Snowflake backend for quality reporting: a global quality dashboard for each SAP system, plus Defects in FIT and corrective actions from EtQ.

Snowflake, Power BI dataflows, DAX, scikit-learn

Read the case study: Quality dashboards on Snowflake

In progress

SAP BW reports out of Excel

Moving Customer PPM, DPPM and DPMO, Defects, Product Acceptance, Task Data and RCAT from Excel workbooks on BW queries to Snowflake and Power BI, after automating their refreshes first.

SAP BW, Python, VBScript, Snowflake, Power BI

Read the case study: SAP BW reports out of Excel

Raytheon Technologies

Sept. 2021 – Sept. 2023

Completed

Compliance and audit dashboards

Mission Assurance dashboards in Tableau and Power BI that tracked aging, delinquent and at-risk compliance items. Python scripts loaded the data from SharePoint lists and Jira.

Tableau, Power BI, Python, SQL Server, Jira

Read the case study: Compliance and audit dashboards

Personal and freelance projects

Sites I've built and run on my own time. They're live, and the code is on my GitHub.

Personal project

Cinema Club DC

Showtimes from the DC area's repertory and independent theaters, all in one place. Friends use it to plan movie nights and talk about what they've seen. It runs on my Synology NAS.

Python, Docker, Discord bot, Cloudflare Tunnel

Personal project

Home lab

A custom PC and a Synology NAS for storage, backups and hosting. Tailscale connects my devices, and Homebridge runs the home automation.

Synology DSM, Docker, Tailscale, Homebridge, Cloudflare

Collins Aerospace
Principal Data Specialist, Business Systems & Transformation
Sept. 2023 – Present
Raytheon Technologies
Senior Compliance Data Analyst, Application Administrator
Sept. 2021 – Sept. 2023
Quantum Tax Consultants
IT Engineer
May 2020 – Feb. 2021
Wayfair
IT Engineering Co-op
Jul. – Dec. 2019
Canary Connect
Test Engineering Co-op
Jan. – Aug. 2018
Northeastern University
B.S. in Computer Engineering, minor in Photography
2016 – 2021

I've been taking photos since 2012, mostly portraits, headshots, events and weddings. At Northeastern I minored in photography and was chief photo editor at The Huntington News.