Stephen John
- Assistant Vice President, Financial Risk Analyst
- Axos Bank
School Information
School: Arizona State University
College Major: Business
Years at College Works: 2009
Career Information
Working For: Axos Bank
Title: Assistant Vice President, Financial Risk Analyst
Industry: Finance
Brief Description of Duties / Responsibilities:
• Engineered enterprise-scale data pipelines at a $23BN financial institution using Python (pandas, SQLAlchemy) and SQL, processing 600K+ monthly records across deposit and loan portfolios, reducing manual workload by 83% while enabling seamless integration into the QRM Analytical Framework for ALM and liquidity analyses • Architected end-to-end data pipeline for institutional deposit study, processing 60M+ historical records using SQL and Python for extraction and preprocessing, enabling a comprehensive QRM analysis of non-maturity deposit behavior • Leveraged Python and QRM to perform complex financial analyses, generating actionable visualizations and executive summaries that drove C-level decision-making on critical issues, including a strategic response to a 50 basis point change in interest rates affecting EVE and NII forecasts • Optimized prepayment analysis workflow by consolidating 12 SQL queries and 7 Excel workbooks into an automated Python pipeline, reducing processing time from 1.5 business days to 15 minutes while improving accuracy and reliability of prepayment metric calculations • Developed and maintained 15+ production-grade Python/Jupyter notebooks with auditor approval, creating reusable analytics frameworks that streamlined ALM, Liquidity, FP&A, and Credit workflows across teams
What Has Been Your Proudest Accomplishment Post-CWP?I recorded the third largest bookings week. And obviously, I will always remember my first sell.
College Works Career Impact
In one sentence, what has CW meant to you?
College Works Painting means hard work and dedication applied with business acumen.
How did your CW experience impact your career? Immediately after graduation? Now?
I was more disciplined and eager to finish things quickly. The procrastination habit was greatly minimized.
What do you want to tell your clients about what it meant to work with them and how it has helped you get to where you are today?
Thanks for everything! I’ve enjoyed the stories that you have shared with me and wisdom that you provided.
What was the greatest lesson you learned from your CW experience?
Owning a business is one of the hardest things to do, but it is so satisfying.
If you had to come up with a one line slogan for CW, what would it be?
College Works Painting – where leaders are developed.
Advice
What advice do you have for potential CW participants? Current CW participants?
Keep working and keep focused. The hours are long and the work is tough, but keep pushing and you’ll find a breakthrough.
Many college students struggle to choose between an internship specific to their target industry or doing CW. What advice would you give them on this subject if they wanted to enter your career field?
Learning how to sell is a very important skill. A communication is key during my time at College Works Painting. Developing those skills will go a long way in the operations industry.
What’s your best advice for someone interested in entering your career field?
Stay on top of things and be open minded. Find a coach and learn about the business. It’s very fast pace.
What’s your favorite memory from CW?
Booking my first sell. I still remember the neighborhood and clients’ faces. Such a great feeling.
Last words of wisdom?
Success is a collection of habits. Waking up early, communicating with clients/colleagues, and finding time for coaching are all very important habits during college.