I've worked on aerospace quality and compliance data since 2021, first at Raytheon and now at Collins Aerospace. Most of my work is pulling data out of SAP, SharePoint and SQL Server, modeling it in Snowflake and Azure SQL, and building the Power BI dashboards people use to make decisions. I like replacing manual spreadsheet work with pipelines that run on their own.
Experience
Collins AerospacePrincipal Data Specialist, Business Systems & TransformationSept. 2023 – Present
Remote
I work on quality data for the Mission Systems business. Right now I'm running three separate projects, and they all have the same goal: getting quality reporting off manual spreadsheets and onto pipelines that run on their own.
The biggest one is the Control Tower modernization. The Control Tower is how leadership reviews quality across 37 sites each month, and its numbers came from SharePoint lists, Power Apps, Excel trackers and values copied out of SAP by hand. I'm replacing them with an Azure SQL star schema, where the calculations run in SQL, and an Ignition portal where sites submit their numbers.
Separately, I built a shared Snowflake backend in Power BI dataflows for our quality dashboards: a global dashboard for each of our two SAP systems, plus Defects in FIT and corrective actions from EtQ. I'm also rebuilding our recurring SAP BW reports, starting with Customer PPM, on that same setup so they no longer run through Analysis for Excel. Before that rebuild, I automated the Excel refreshes with Python and VBScript, which saved more than two hours every time the reports ran.
I also co-host a Quality Data Analytics Community of Practice every other month for 30+ analysts and portfolio leads across Mission Systems and other business units in Collins.
Raytheon TechnologiesSenior Compliance Data Analyst, Application AdministratorSept. 2021 – Sept. 2023
Remote
I was on the Mission Assurance Analytics & Tools team, where I had two jobs. As application administrator for Method Park Stages, I supported users, kept the documentation current, and regression tested each new release with the vendor and our server, database and network teams.
On the data side, I built Tableau and Power BI dashboards for regulatory compliance and audits, wrote Python scripts that loaded SharePoint and Jira data into our database, and cleaned up the SQL stored procedures behind it. I also used SAP BEx, Crystal Reports and Python to track the weekend automation of Quality Notification processing, and tried out Power BI Cloud Server and Snowflake early on.
Case studies
Quantum Tax ConsultantsIT EngineerMay 2020 – Feb. 2021
Passaic, NJ
I handled IT for a tax consulting firm as it moved to remote work in 2020. I moved everyone onto Google Workspace and Google Voice, set up Slack, Calendly and Mailchimp, and automated client account reconciliation in Xero. I also helped the firm's business consultants weigh the costs of a rebrand and new technology.
WayfairIT Engineering Co-opJul. – Dec. 2019
Boston, MA
A co-op on Wayfair's IT engineering team. I analyzed the new-hire onboarding process to show engineering where automation would help most, wrote Python and PowerShell scripts for common fixes like remotely resetting a laptop's network adapter, and handled access requests and PC imaging through Active Directory, SCCM and JAMF.
Canary Connect Inc.Test Engineering Co-opJan. – Aug. 2018
New York, NY
My first co-op, on the test engineering team for Canary's home security cameras and app. I got the TeamCity build server running again, which saved developers about 12 hours a week of building the iOS and Android apps on their own machines. I also wrote regression test plans for app and firmware releases, fixed Java test scripts in Cucumber and Appium, and trained the next group of co-ops.
Education
Boston, MA
I studied computer engineering in Northeastern's Honors Program as a National Hispanic Scholar, with a minor in photography. Northeastern's co-op program is how I spent most of 2018 at Canary Connect and the second half of 2019 at Wayfair.
My coursework covered both hardware and software: Software Engineering, Database Design, Fundamentals of Algorithms, Introduction to Machine Learning, Probability and Statistics, Computer Architecture, Embedded Design, Digital Systems Logic and Design, Circuits and Signals, Fundamentals of Networks, Differential Equations and Linear Algebra.
Certifications
I'm working toward the Ignition CORE Professional certification from Inductive Automation, mostly for the Control Tower project. In 2024 I finished the Collins Aerospace CORE Apprentice program, where I set up Kanban boards, Git version control and task tracking for my team.
Skills
Data engineering: Snowflake, Azure SQL, SQL Server, SAP Business Warehouse (BEx, Query Designer, Analysis for Excel), Crystal Reports, Ignition SCADA
Programming: SQL, Python (pandas, SQLAlchemy, Prophet, scikit-learn), VBA and VBScript, PowerShell, TypeScript, Java, C++, MATLAB, Verilog
Analytics and BI: Power BI and Power BI dataflows, Tableau, statistical analysis, forecasting, data modeling, data validation
DevOps and IT: Git, Jira, CI/CD, TeamCity, Docker, Linux, macOS, Windows, SCCM, Active Directory, JAMF
Hardware: Zynq-7000 FPGA, Arduino, sensors, analog filters, oscilloscope, multimeter
Projects
Work projects are listed under each job above. These are the ones I did on my own or in school.
Personal and freelance
Cinema Club DC. A site that collects showtimes from the DC area's repertory and independent theaters so my film club can plan what to see. It has a Python backend and a Discord bot, and it runs in Docker on my Synology NAS behind a Cloudflare Tunnel.
Julian Perez Photography. The site for my photography business. Clients fill out a questionnaire before a shoot, and the site generates a shot list PDF from their answers. It's built with Next.js, Sanity and Supabase and deploys to Vercel.
Home lab. A custom PC and a Synology NAS that handle my storage, backups and self-hosting. Tailscale connects everything when I'm away from home, and Homebridge runs my home automation.
Movie theater scheduler. The script that turned into Cinema Club DC. It scraped showtimes from Suns Cinema and posted them to a Slack channel.
Academic
Des-Cart (Engineering Capstone, 2020 – 2021). My capstone team built a proof-of-concept app that pulled purchase history from POS systems and email receipts and recommended related products through Amazon Personalize. The idea was to give small shops some of the reach of big online stores during the pandemic. I designed the MySQL database behind the Node.js API.
Machine learning coursework (EECE 5644). MATLAB assignments from Northeastern's machine learning course.
CPU on an FPGA (Digital Systems Logic and Design Lab, 2019). I designed a simple CPU in Verilog, simulated it in Vivado and ran it on a ZedBoard Zynq-7000 FPGA.
ECG circuit (Circuits and Signals, 2018). With a lab partner, I built an ECG on a breadboard using op-amps and analog filters, then cleaned up the signal with digital filters in MATLAB.
The Pill Bug (Cornerstone of Engineering, 2017). My first engineering project: an Arduino robot that followed a track and opened its pillbox at set stops to deliver medication.
Leadership at Northeastern
I planned meetings, headshot sessions, speaker panels and resume reviews for Latinx engineering students, kept the board's notes and task tracking, and built a QR code check-in system in Google Sheets for attendance.
I photographed FirstByte's meetings and speaker panels and turned the photos into posts for the club's social media.
I led the newspaper's photo team for a semester, assigned event coverage, and ran training sessions on composition and editing for publication.
Interests
Photography. I've been taking photos since 2012, mostly portraits, headshots, events, engagements and weddings, plus some photojournalism. I minored in photography at Northeastern and have run a freelance business alongside my full-time job ever since.
Home lab and PC building. I built and maintain a custom PC and a Synology NAS that I use for storage, backups and self-hosting. Tailscale lets me reach my files from anywhere, and Homebridge handles home automation.