About Me
Education
Hi, I am Jaime Rios, Industrial Engineer ranked in the top 20% of my class, from Universidad Nacional del Callao of Perú. Certified in Business Intelligence with advanced skills in Power BI, SQL, and Excel. Completed a specialization in Business Intelligence at Microsoft Partner Network and a professional Excel program at Universidad Nacional de Ingeniería. Fluent in English and basic knowledge of Quechua.
Work Experience
I had the opportunity to work as a Commercial Intelligence Analyst for Colgate Palmolive at XPLORA TECHNOLOGY S.A.C., where I developed and maintained Power BI dashboards to monitor KPIs, visibility, and coverage, and built PowerApps for real-time data validation. At UNACEM, I managed databases and visualizations in Power BI to support the Progresol network. In my role at GRUAS EMEMCA, I was a Commercial Analyst, negotiating and coordinating high-tonnage transport services, achieving significant monthly sales and capturing new clients through effective market analysis.
Me and Data
Me and Data
I’m a passionate data and business intelligence enthusiast with a love for uncovering insights that drive impactful decisions. Outside of work, I enjoy playing soccer and basketball, exploring new places, and capturing breathtaking moments with my DJI drone. Traveling and discovering the world’s diverse cultures inspire me, fueling my creativity and perspective in both my personal and professional life.
My Python and Automation Projects
Banking Margin Insights in Python
An exploratory analysis of monthly banking profit margins using Python, including visualization and automated reporting.
Geocoding with Google Apps Script
A custom script that automates the conversion of address data into geographic coordinates using the Google Maps API.
Pricing for Growth in Python
A strategic pricing analysis that identifies high-margin, high-volume products and simulates pricing adjustments using data visualization.
My BI Dashboards & Power Apps
Sales Dashboard – Self-Service Stores
Interactive Power BI dashboard that analyzes historical sales data across categories and regions in self-service retail stores.
Power App - Point-of-Sale Pricing
Mobile app built with Power Apps for field data collection of product prices at retail points of sale, improving accuracy and speed of pricing updates.
Financial Indicators Dashboard
Dynamic dashboard that visualizes key financial and customer loyalty metrics, allowing for real-time business performance monitoring.