Roger Aristizabal

Entity Operations Analyst

Middesk · Manhattan, NY

Nov. 2025 - Dec. 2025

• 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

Sep. 2025 - Oct. 2025

• 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

Sep. 2024 - Oct. 2024

• Performed data-driven recalculations for a major audit client using SQL and Excel, leveraging QuickSight dashboards to validate accuracy and ensure data integrity.
• 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

June 2024 - Aug. 2024

• Designed Excel VBA dashboards to track FY24 grants and donations, improving reporting efficiency.
• 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.

Risk Modeling Services: Life Intern

PricewaterhouseCoopers · Manhattan, NY

June 2023 - Aug. 2023

• Leveraged AWS QuickSight to visualize and present dashboards to a 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%.
• Created Tableau and Power BI dashboards for executive and client-facing reporting.

Marketing & Development Intern

Bloomberg Philanthropies & Studio Institute · Manhattan, NY

June 2019 - Aug. 2019

• Collaborated on a grant proposal that secured $150,000 in funding from M&T Bank.
• Supported budgeting and timeline development for 5+ active grant proposals under the Director of Development.