Hi, I'm Edwin Santos Business Analyst & Data Scientist
I turn data into profitable business decisions. Specialized in SQL, Power Platform (Power BI, Power Apps, Power Automate) and Python. Working remotely from Lima for companies in the US and Canada.
About me
I'm a Business Analyst based in Lima, Peru, with a dual background: Mechanical Engineering and Analytics for Business. That mix gives me a particular take on data: rigorous like an engineer, strategic like a business analyst.
I currently work remotely for CQ Fluency (New Jersey) building Power BI dashboards and Power Platform automations. Before that I led business intelligence at Valia (Delaware) and product analytics at Ove Decors (Montreal).
What I love most: simplifying the complex. Turning big problems into manageable steps, clear metrics and decisions that drive impact. Winner of the HEAD Competition (Mohawk College, 2024) and the NASA Space Apps Lima (2021).
Power Platform end-to-end
Power BI, Power Apps and Power Automate integrated to enterprise sources.
Data at scale
Advanced SQL in PostgreSQL, BigQuery and MySQL. AWS → BigQuery transformations.
AI-powered automation
OCR + Power Automate (-95% processing time). LLM and API integrations.
Skills & Stack
Databases
BI & Visualization
Power Platform
Cloud & Data
ML / AI
Featured projects
HEAD Competition Winner · Mohawk College 2024
Team lead in charge of data strategy and storytelling. We won 1st place out of 40 teams from different Ontario colleges, presenting an analysis poster and a Machine Learning model on the effects of climate change on buildings in Hamilton.
- Power BI
- Looker Studio
- Python (ML)
- Storytelling
Environmental Impact Dashboard · Critical Infrastructure
Interactive Looker Studio dashboard to assess the impact of extreme weather on critical infrastructure in Hamilton. Core project of the HEAD competition that took my team to first place.
- Looker Studio
- BigQuery
- SQL
DAX Query Automation · Deepseek + Power Automate
Automation that takes a natural-language prompt and returns DAX queries ready for Power BI, using Deepseek API orchestrated via Power Automate. Speeds up measure development and reduces syntax errors.
- Power Automate
- Deepseek API
- DAX
- LLMs
Invoice OCR Automation · Power Automate
Invoice processing solution with OCR + AI Builder in Power Automate. 95% reduction in manual processing time during my time at Ove Decors. Integrated with MySQL to feed Power BI dashboards.
- Power Automate
- AI Builder OCR
- MySQL
- Power BI
NASA Space Apps Lima 2021 · SPACE ROOTS
Lead of team SPACE ROOTS, winner among 1600 participants and 200 teams. Designed the mechanical systems of an agricultural module and integrated sensors (humidity, mold, pressure) visualized in Grafana in real time. Global Nominee.
- Grafana
- IoT Sensors
- Mech. Engineering
- Data Viz
Extreme Weather Risk · Facility Maintenance
Climate data analysis and predictive Machine Learning model on the impact of extreme weather on facility maintenance infrastructure. Paired with an LLM-powered conversational assistant.
- Python
- scikit-learn
- LLMs
- Power BI
More projects & experiments
BI Animations · Repositorio
8 HTML/CSS animations to teach BI concepts: BI cycle, data layers, terminals and comparisons.
- HTML
- CSS
- Storytelling
Apache Airflow Lab
DAGs, sensors, XComs, branching, monitoring and a real satellite project deployed with Docker.
- Airflow
- Docker
- Python
Plataforma de Becas
End-to-end system: scholarship scraper + SQLite + Streamlit app with search and filters.
- Python
- SQLite
- Streamlit
Movies DB · PostgreSQL
Relational database with entity-relationship modeling, documented ERD and advanced analytical queries.
- PostgreSQL
- SQL
- ERD
Bootcamp Power BI · USMP
Branded educational site for the Power BI bootcamp at Universidad San Martín de Porres.
- HTML/CSS
- Power BI
- Edu
Table Joins en Power Automate
Pattern to perform JOINs between tables from different sources within a Power Automate flow.
- Power Automate
- SharePoint
Experience
Business Analyst
CQ Fluency · New Jersey, EE.UU.
Extensive tracking of databases to support operations, Python automations (Pandas, MySQL, NumPy) and Power BI dashboards for various teams and Project Managers. Power Automate flows (project hours notifications, comparison vs projected hours) and stakeholder meetings to translate needs into data requirements.
Business Intelligence Engineer
Valia · Delaware, EE.UU.
Over 60 visualization reports in Looker Studio, complex PostgreSQL queries and AWS → BigQuery data transformation. Took part in LLM implementations for tools like Valia's Copilot and integrated HubSpot and Google Analytics APIs for marketing reports.
Product Analyst
Ove Decors · Montreal, Canadá
Power BI dashboards connected to MySQL, OCR automation in Power Automate for invoice processing (−95% time), advanced Excel analyses with pivot tables and web scraping projects on Amazon and Overstock for competitive analysis.
Graduate Certificate · Analytics for Business Decision Making
Mohawk College · Hamilton, Canadá
Coursework: Applied Machine Learning, CRISP-DM, Data Mining, Web Development, Statistics, Advanced Database Concepts. Graduated with honors (94.2% GPA). 1st place in the HEAD Competition among 80 teams from different colleges.
Diploma · Business Intelligence
Pontificia Universidad Católica del Perú (PUCP)
Power Apps Development, Predictive Analytics, SQL Database Management and Data Visualization with Power BI. House pricing predictive model (+20% vs baseline) and a maintenance app in Power Apps (−15% downtime).
Bachelor of Science · Mechanical Engineering
Pontificia Universidad Católica del Perú (PUCP)
Strong foundation in calculus, statistics and applied physics. Research assistant on 3D printing mechanics simulation and teaching assistant in mechanics for over 100 engineering students.
Want to see the full CV?
Download CV (PDF)Awards & Recognition
Higher Education Analytics Data Competition (HEAD)
Mohawk College · Hamilton, Canadá
Team lead in charge of data strategy, management and storytelling. We built an analysis poster and a Machine Learning model on the effects of climate change on buildings in Hamilton.
NASA International Space Apps Challenge · Lima
Equipo SPACE ROOTS
Team lead among 1600 participants and 200 teams. In charge of the engineering of the module\
Let's talk
Got a project in mind?
I'm open to collaborate on Business Intelligence, Power Platform automation, data analytics or consulting projects. Tell me what you need and I'll get back to you in less than 24 hours.