About

I'm Ayo Mosanya. I build the pipelines and reporting systems that regulated, high-stakes environments run on — these days as a software engineer on the AI & Automation team within Corporate Risk Management at Charles Schwab.

Nine years in data engineering and analytics taught me where systems quietly break. Lately I've been closing that gap faster with AI doing a lot of the heavy lifting: my last major pipeline rebuild cut processing time 85% and held error rates under 1%, and the most recent Federal Reserve exam closed clean with zero material findings.

This site is the same idea turned on myself — zero Elixir knowledge to a deployed, production app in two weeks, with AI doing a lot of the pair programming.

Read the full resume →

How I work

I work best when I can go deep on a problem and stay close to the implementation. I care about systems that actually get used — not just built and handed off. The work only counts if the people on the other side can trust what they're looking at.

That doesn't mean I insist on doing everything myself. I've managed and mentored analysts and sat on hiring panels, and I know the difference between a problem that needs a second pair of hands, one that needs a room full of stakeholders aligned, and one that just needs me to sit down and build it. I delegate when someone else is better positioned to own it, collaborate when the problem is bigger than one person, and build it myself when speed and precision matter more than spreading the work around.

A blueprint is not a building. I'd rather be the contractor who still answers the phone after the house is built than the architect who just drew it and left.

Build it, delegate it, or coordinate a team on it — either way, I make sure the people running the system afterward understand what they have.

Experience

Software Engineer, AI & Automation

Mar 2022 – Present

Charles Schwab & Co. — Corporate Risk Management

  • Built a production Python pipeline that extracts, validates, and reports on enterprise risk data — cutting processing time 85% and holding error rates under 1%
  • Embedded AI-assisted workflows using GitHub Copilot and frontier language models across the analytics pipeline, enabling one person to produce board- and Federal Reserve-ready reporting at the velocity of a team
Show full scope of the role
  • Author and own procedural standards for the risk analytics function, running the adherence and oversight program that governs how data, reporting, and AI-driven processes comply with those standards
  • Delivered the final reporting dataset for the most recent Federal Reserve examination cycle — the exam closed clean with zero material findings
  • Built and maintained Tableau & Power BI dashboards for enterprise risk reporting, with training and documentation for risk managers and issue owners
  • Mentored analysts toward promotion and sat on technical interview panels

Data Analyst

Jun 2021 – Jan 2022

2ndWatch (AWS Premier Consulting Partner)

  • Cloud data warehouse optimization analyses on Oracle DB for Fortune 500 enterprise clients
Show full scope of the role
  • Developed unified Excel modeling framework integrated with Oracle DB SQL queries
  • Redesigned cost analysis processes to enhance data reliability and streamline client reporting

M&A Analyst

Jul 2019 – Jun 2021

Salesforce

  • Automated executive reporting pipelines using Tableau and Google Sheets, reducing manual effort by 60%
Show full scope of the role
  • Led analytics integration for technology acquisitions, consolidating data from disparate sources
  • Partnered with Corporate Development, IT, and Operations to align technology integration strategies

Technical Advisor

Jun 2017 – Jul 2019

Apple Inc.

  • Ranked top 5% globally for customer satisfaction
  • Analyzed support interaction data to identify product improvement opportunities

Technical skills

Python SQL DuckDB Polars Tableau Power BI Oracle DB Git Collibra Informatica Parquet ETL Data governance Frontier models Open-source LLMs GitHub Copilot Prompt engineering Elixir Phoenix LiveView

Education

University of Texas at Tyler

B.S., Computer Information Systems

If you're working on something where precision matters and the stakes are high, I'd be glad to hear about it.

Get in touch

Admin Access