Patricio Rios

Built AI-powered traffic analytics platform integrating Google Analytics 4 API, Power BI, and OpenAI GPT RAG system, eliminating 95% of manual reporting effort. Engineered 6 insurance vertical data pipelines processing 5.7M+ PostgreSQL records with Python ETL automation, achieving 100% production uptime.

Delivered 10% labor-cost savings by surfacing ETF-granular spend and initiative-level variances through DAX-powered visuals in the automated Labor Strategy executive deck. Achieved 35% cut in monthly finance-report cycle time by scripting Python (pandas) ETL from Clarity ERP into a parameterized Power BI dashboard.

Orchestrated 20+ live sessions, 2 data analytics bootcamps (SQL, Power BI) and 10 internal projects, improving analytics efficiency across the organization. Spearheaded HR AI chat tool using OpenAI API (GPT-4o mini), Python, pandas, matplotlib, and Streamlit.

Delivered firm's first Python-driven due-diligence engine automating checklist scoring and PDF output, reducing review time to under 10 minutes and increasing throughput by 50%. Re-engineered monthly cash-flow close with Excel Power Query transforms and scheduled refreshes, reducing analysis effort by 30%.

Designed Python scripts automating monthly KPI analysis from ServiceNow metadata, delivering accurate weekly team metrics via live reporting. Optimized monthly cash-flow analyses with Excel and Power Query, achieving 30% reduction in analysis time and improving forecast accuracy by 10%.

Built Power Automate request database halving client-inquiry response time. Developed data-visualization newsletter that raised satisfaction-survey rate by 20% and implemented new data management system that lifted operational efficiency by 30%.

Led development of company's first digital due-diligence product, enabling massive online assessments in under 10 minutes for clients in Peru and Brazil, reducing evaluation time by 50% and increasing throughput by 30%.

Completed the LLM Applications with LangChain course in 2024.

Completed the Multi AI Agents with crewAI course in 2024.

Earned the Business Intelligence Foundation certification in 2023.

Completed the Neural Networks and Deep Learning course in 2022.

Completed the Foundations of Project Management course in 2021.

Earned the Scrum Fundamentals Certified credential in 2021.

Bachelor of Science in Economics from Universidad de Lima, completed in 2019.

Completed the Bloomberg Market Concepts course in 2018.