Roger Aristizabal
Data Analyst & Risk Modeling Professional
Mathematics graduate specializing in data analytics, financial modeling, and business intelligence. Experienced in building data-driven solutions for enterprise clients including PwC and The Juilliard School.
About Me
I'm a Mathematics graduate from Hofstra University with a focus on Actuarial Science, passionate about transforming complex data into actionable insights. My background combines rigorous quantitative training with hands-on experience in data analytics, risk modeling, and business intelligence.
I've had the privilege of working with industry leaders like PricewaterhouseCoopers, where I developed financial models supporting $250M+ lines of business, and The Juilliard School, where I built data pipelines and web dashboards that improved operational efficiency.
Beyond my technical work, I'm committed to giving back—serving as Alumni Chair for Bottom Line's National Alumni Advisory Committee and as a Judge for The Actuarial Foundation's Modeling the Future Challenge.
I'm fluent in Spanish, conversational in French, and have basic Russian skills. Based in New York City, I'm always open to new opportunities in data analytics, financial technology, and risk management.
Professional Experience
Entity Operations Analyst
Middesk
Manhattan, NY
- ▹Built and optimized JavaScript and SQL-driven internal tools to resolve edge cases in automated entity-verification pipelines, improving data accuracy and reducing manual review workload
- ▹Partnered with Product and Engineering to debug data inconsistencies and refine verification logic in production workflows
- ▹Queried and reconciled multi-state entity data across internal databases and third-party systems to support business onboarding at scale
Quality Assurance / Data Collector
Applause
Manhattan, NY
- ▹Collected and validated data from 50+ smart devices daily for confidential MAANG-level technology clients, maintaining 100% data accuracy and integrity
- ▹Trained and mentored 5+ new team members, standardizing data validation procedures and QA workflows that improved team productivity by 25%
Risk Modeling Services: Life Associate
PricewaterhouseCoopers
Manhattan, NY
- ▹Performed data-driven recalculations for a major audit client using SQL and Excel, leveraging QuickSight dashboards to validate accuracy and ensure the integrity of complex financial data
- ▹Built and maintained a VBA-based group reinsurance product model supporting financial projections for a $250M line of business
Web Developer
The Juilliard School
Manhattan, NY
- ▹Designed Excel VBA dashboards to track FY24 grants and donations, improving reporting efficiency and leveraging data analytics to guide strategic fund allocation decisions
- ▹Assisted in the development and maintenance of the school's official website using HTML, CSS, and JavaScript
- ▹Built SQL queries and Python-based data pipelines to extract, clean, and integrate multi-source data into dynamic web dashboards, reducing manual data handling by 30%
Risk Modeling Services: Life Intern
PricewaterhouseCoopers
Manhattan, NY
- ▹Leveraged AWS QuickSight to effectively visualize and present dashboards to a prominent large-scale client
- ▹Automated Variable Annuity UMA testing with Excel VBA, applying Martingale and Black-Scholes models to improve accuracy and reduce processing time by 20%
- ▹Led a SQL-based dashboard project for a life insurer, cutting manual reporting time by 35% and presenting findings in client meetings
- ▹Created interactive Tableau and Power BI dashboards, transforming complex data into clear visual decks for client presentations
Education & Leadership
Bachelor of Science in Mathematics
Hofstra University
Hempstead, NY
Leadership Experience
Alumni Chair
Bottom Line National Alumni Advisory Committee
Oct. 2023 - May 2025
Advised on organizational initiatives, student engagement policies, and strategic growth, ensuring student and alumni perspectives shape key programmatic decisions
Judge
The Actuarial Foundation - Modeling the Future Challenge
Nov. 2023 - May 2024
Evaluated project proposals based on a ski resort scenario, assessing risk factors, financial modeling, and decision-making across three ski resorts over 20 years with varying snowfall conditions
Skills & Technologies
Data Visualization
Data Analysis & Modeling
Web & Data Tools
Languages
Featured Projects
Entity Verification Pipeline Tools
Built and optimized JavaScript and SQL-driven internal tools at Middesk to resolve edge cases in automated entity-verification pipelines, improving data accuracy across multi-state databases.
VBA Reinsurance Product Model
Developed and maintained a VBA-based group reinsurance product model at PwC supporting financial projections for a $250M line of business.
SQL Dashboard for Life Insurance
Led a SQL-based dashboard project for a major life insurer at PwC, cutting manual reporting time by 35% and presenting findings in client meetings.
Juilliard Web Dashboards
Built SQL queries and Python-based data pipelines to extract, clean, and integrate multi-source data into dynamic web dashboards, reducing manual data handling by 30%.
FY24 Grants & Donations Tracker
Designed Excel VBA dashboards at The Juilliard School to track FY24 grants and donations, improving reporting efficiency and guiding strategic fund allocation decisions.
Variable Annuity UMA Testing Automation
Automated Variable Annuity UMA testing with Excel VBA at PwC, applying Martingale and Black-Scholes models to improve accuracy and reduce processing time by 20%.
Get In Touch
I'm currently open to new opportunities in data analytics, risk modeling, and financial technology. Whether you have a question or just want to say hi, feel free to reach out!
© 2026 Roger Aristizabal. All rights reserved.
Built with Next.js & Tailwind CSS