# Data Systems & Analytics

Noah Pettinato

Data Analyst · Applied Mathematics & Computer Science

I am a data analyst with a background in applied mathematics and computer science. I build data pipelines, dashboards, and predictive models that turn complex data into clear, actionable insights through reporting and automated workflows. Skilled in SQL, Python, Power BI, and Tableau, with experience combining multi-source datasets, automating ETL workflows, and visualizing trends for technical and business users.

Get in Touch View Projects Resume

# About

I graduated from Oregon State University with a B.S. in Applied and Computational Mathematics and a minor in Computer Science. At Axos Bank I support commercial lending with SSRS, Tableau, SQL Server, and Power Automate workflows. I have also built Python ETL pipelines, contributed mathematics expertise for AI training at Mercor, and developed numerical solvers in MATLAB during undergraduate research. I focus on reliable data, clear reporting, and tools that help teams make better decisions.

Data Engineering

Automating data extraction, cleaning, and transformation through SQL and Python ETL pipelines.

Analytics & Visualization

Creating reports and dashboards in Power BI, Tableau, and Excel to uncover insights and communicate trends.

Modeling & Research

Applying mathematical models and numerical methods in MATLAB for stability analysis and simulation.

# Experience

* Jr. Data Analyst · Axos Bank

Jan 2026 – Present

Develop and optimize SQL-driven reporting and BI solutions using SSRS, Tableau, and Excel to support commercial lending operations. Partner with stakeholders to deliver custom dashboards and analytical solutions, and automate reporting workflows with Power Automate, SQL Server, and Python. Build SQL queries, stored procedures, and reporting infrastructure, including a natural-language data discovery platform integrating Collibra metadata to accelerate enterprise report development.

SQL Server · SSRS · Tableau · Excel · Power Automate · Python · workflow automation · business intelligence

* Mathematics Expert (Contract) · Mercor

Sept 2025 – Present

Curate and author advanced undergraduate and master’s-level mathematics problems, evaluate and refine AI-generated reasoning for rigor and clarity, and provide subject matter expertise to strengthen datasets powering next-generation large language models.

AI training · dataset curation · solution validation

- Data Operations Intern · Wagner Engineering

Oct 2025 – Jan 2026

Automate extraction, cleaning, and structuring of Texas SmartBuy procurement data using Python, Playwright, and pandas. Develop cloud-ready ETL pipelines integrating web scraping and data transformation so the team can feed clean data directly into BI dashboards and automated workflows.

Python · Playwright · pandas · ETL · automation · AWS

- Undergraduate Research Assistant · Oregon State University

Apr 2025 – Jul 2025

Developed MATLAB solvers for steady-state and time-dependent nonlinear heat transfer problems with flux-based Robin boundary conditions. Implemented Newton solvers with analytic Jacobians and adaptive damping, analyzed convergence behavior, and documented algorithms and assumptions for reproducibility.

MATLAB · PDEs · numerical methods · Newton methods · stability & convergence

- Data and Research Intern · Pettinato & Associates

Jun 2019 – Jul 2025

Extracted, cleaned, and combined claim data in SQL Server using multi-table joins and relational logic. Generated Crystal Reports and SQL queries to streamline reporting, ensure accuracy, and prioritize high-value claims using verified public data.

SQL Server · Crystal Reports · data transformation · workflow automation

# Skills

# Programming & Scripting

PythonMATLABSQLJavaJavaScriptHTMLRC#

# Data & Analytics

NumPypandasTableauPower BIExcelCrystal ReportsData CleaningPredictive Modeling

# Dev & Collaboration

VS CodeGitHubGitLaTeXSalesforcePlaywright

# Technical Focus

ETL pipelinesweb scrapingAWSworkflow automationdata visualizationpredictive analyticsreporting automationmodel tuningruntime benchmarkingdashboard creationquality assurance

# Projects

PSNonlinear Radiation Solver

Nonlinear Radiation Solver

Fully implicit MATLAB solver for one-dimensional heat diffusion with nonlinear radiation (Robin) boundaries. Implements Newton’s method with analytic Jacobians and Backward Euler time-stepping to compare finite difference and ghost-point (CCFD) methods for stability and convergence.

MATLAB · PDEs · numerical methods · Newton solvers · Backward Euler

Source Code

PSFinancial Data Analysis (AAPL Forecasting)

Financial Data Analysis (AAPL Forecasting)

Explores stock market trends and time series forecasting using ARIMA on seven years of AAPL data. Performs exploratory data analysis (EDA), model tuning via AIC/BIC, and residual diagnostics, with results visualized through interactive dashboards in Power BI and Tableau.

Python · pandas · ARIMA · Power BI · Tableau · Excel

Source Code

PSMovie Data Analysis ETL

Movie Data Analysis ETL

End-to-end ETL and exploratory data analysis pipeline for The Movies Dataset (Kaggle). Includes data cleaning, transformation, and insight generation with visual summaries, built to demonstrate automation and reproducible analysis workflows.

Python · pandas · ETL · data cleaning · visualization

Source Code

PSAlgorithms Portfolio

Algorithms Portfolio

Concise Python implementations covering recursion, greedy algorithms, dynamic programming, and regression. Benchmarked for runtime efficiency and scalability.

Python · recursion · dynamic programming · runtime benchmarking

Source Code

Let's Connect

I turn messy data into clear, actionable insights. If you’re building pipelines, dashboards, or automation and need a reliable, detail-oriented collaborator, reach out and let's talk.

Noah Pettinato

Transforming data systems into actionable solutions.

I’m always interested in connecting with others working in data analytics and automation. Whether you’re building ETL pipelines, developing dashboards, or exploring predictive modeling, I’d be happy to connect and exchange ideas.

# Areas I enjoy discussing:

+ New projects or collaborations
+ ETL, dashboards, or analytics engineering
+ Predictive modeling or experimentation

Connect on LinkedIn Check out my GitHub

Noah Pettinato

Where data meets clarity and execution.

Get In Touch

noahpettinato@gmail.com

I built this site from scratch. View the GitHub repo