Analytics & dashboards
Decision-ready KPI systems in Power BI, Looker Studio, Excel, Streamlit, and Plotly.
Explore capability Available for select projects
I turn business problems into practical systems.
I’m Rey, a Data Analyst and Automation Builder. I create dashboards, data pipelines, and web tools that make work faster, clearer, and easier to scale.
250-300payroll records automated
10K+CRM contacts processed
5web applications created
1SaaS created
Reynaldo LorenzoData Analyst · Automation Builder
Open to workAI-assisted problem solving
Built for real operations
01
What I build
Less manual work.
More useful information.
I connect the technical pieces to the business outcome, so your system is not only impressive, but genuinely useful.
Automation & ETL
Python, SQL, APIs, Zapier, and n8n workflows that replace repetitive manual work.
Explore capabilityWeb applications
Practical React and Python tools built around real business processes and data.
Explore capability02
Selected work
Systems shaped around the work, not the other way around.
01
Roofing operations
A connected analytics system, not another spreadsheet.
Integrated Google LSA, Angi, and JobNimbus data into automated pipelines and reporting for sales, marketing, revenue, conversion, gross profit, and production KPIs.
PythonJobNimbus APIZapierGoogle SheetsLooker Studio
Multi-sourcereporting pipeline
02
Payroll automation
From repeated calculations to one reliable run.
Automated commission calculations and personalized PDF payroll statements, creating a repeatable process for a workforce of 250-300 employees.
PythonPandasHTML/CSSPDF automation
250-300employees supported
03
Network intelligence
Mindanao-wide data made useful for decisions.
Processed cellular network data with SQL and Python, built KPI dashboards, and translated performance analysis into recommendations for network optimization.
SQLMySQLPythonPower BIStreamlit
Region-widenetwork analysis
03
Test Rey’s skills
Give me the business problem.
I’ll show you the systems thinking.
Your challenge
“Our CRM, ads, and spreadsheets never agree.”
Rey’s approach
Rey would map each source, define shared keys and KPI rules, then build a validated ETL layer before the dashboard. The goal: one reliable reporting flow instead of another disconnected report.
Python · SQL · APIs · Google Sheets · BI
A practical partner
Engineering discipline.
Business-first thinking.
My background spans computer engineering, cellular network analytics, business intelligence, payroll operations, and web development. That range helps me see the complete workflow, not just one tool.
Book a discovery call
Let’s find the highest-leverage fix.
Choose a preferred time for a focused 30-minute conversation about the process, data, or tool you want to improve.
30 minutes Philippine time (GMT+8) Directly with Rey
Request a timeRey will confirm by email
Prefer email?
Let’s turn it into a system.
Start a conversation Davao City, Philippines · Remote worldwide