Extern Externship via ExternI am Cesar Bautista, working through early professional experience and focusing on practical projects that grow my abilities.
A collection of practical projects and tasks that reflect my developing skills and the areas I am exploring professionally.
Architected and delivered an end-to-end Alteryx and Power BI reporting solution that replaced manual reporting across 14 product lines, quantified cost savings, and gave senior leadership faster, more reliable performance data.
Led a team through the end-to-end modernization of a legacy reporting system, rebuilding it in Python and consolidating data across 10 global currencies to strengthen data integrity and minimize manual reconciliation.
I am Cesar Bautista, working through early professional experience and focusing on practical projects that grow my abilities.
I am Cesar Bautista. I have some work experience and I am exploring the next steps of my career, building skills and projects as I move toward a clearer professional path.
Externships
Excel & AI Financial-Modeling Sprint
In progress
Experience
Operations Analyst II
Morgan Stanley · Jul 2025 – Present
Lead Journeyman Wireman / On-Site Manager
TLS Electrical Inc · Aug 2015 – Aug 2021
Education
Delaware State University
Bachelor of Science in Computer Science · Class of 2025
Skills
Architected and delivered an end-to-end Alteryx and Power BI reporting solution that replaced manual reporting across 14 product lines, quantified cost savings, and gave senior leadership faster, more reliable performance data.
Led a team through the end-to-end modernization of a legacy reporting system, rebuilding it in Python and consolidating data across 10 global currencies to strengthen data integrity and minimize manual reconciliation.
Led the optimization of a suite of automation functions that empowers both technical and non-technical team members to run automated workflows independently, unlocking capabilities that previously required technical expertise.
Developed complex SQL queries (joins, subqueries, aggregations) and applied database design, referential integrity, constraints, and indexing to strengthen data consistency, query performance, and reliability.
Analyzed 250K+ transaction records in Python using statistical analysis and machine learning to identify fraud patterns, evaluate transaction risk, and support data-driven decisions.
✅ Verified by Extern · ⏱️ In progress
Build a three-statement model, forecast with drivers, run a DCF, and pitch a company like a pro. In this 3-week sprint, GPT helps you work faster—so you can walk away with real valuation skills and a polished investor deck.
The project built a three-statement financial model and used driver-based forecasting to produce a discounted cash flow valuation, then packaged the analysis into an investor-style pitch. Work combined spreadsheet modeling with external financial data sourcing and scenario testing to produce the valuation outputs.
.png)
I built a three-statement model, forecasted key drivers, ran a DCF valuation, and prepared presentation materials that summarized the analysis and assumptions.
