Efren Aldrich

Data Portfolio · Biñan, Philippines

Efren Aldrich
Data Analyst

Data Analyst with 13+ years of experience transforming complex datasets into actionable insights. Proficient in SQL, Power BI, Qlik Sense, and Excel automation — I design scalable dashboards, automate reporting workflows, and align data capabilities with business goals.

Open to data-related opportunities

Technical skills

SQL Python Power BI Qlik Sense Excel / VBA Power Query GA4 Databricks Streamlit Power Automate Power Pivot Amazon Redshift AWS S3 Sensors Data Grafana Piwik Omeda HubSpot Cordial Lark Base Lark Docs SharePoint / OneDrive DBeaver Amperity Jira / Confluence Notion ServiceNow FileZilla Claude · ChatGPT
13+ Years experience
4+ Years in SQL & BI
3 Featured projects

Projects

Automation · ETL Featured

Automated Weekly Reporting Pipeline

Databricks OAuth → Python → Excel → Outlook

Built a fully automated end-to-end reporting pipeline that replaces a previously manual weekly workflow. The system authenticates with Databricks via OAuth, queries and exports lead recap data, archives the previous source file, opens and populates the Excel report, then auto-generates and sends a formatted summary email — all in one pipeline run with zero human intervention.

100% Manual steps eliminated
~5 steps Automated per run
Weekly Recurring cadence
Python Databricks OAuth 2.0 Excel (openpyxl) Outlook (win32com) File Archiving
Business Intelligence Power BI

AM Analytics

A multi-page Power BI report for the Audience Team tracking email send volume, opt-out trends, and promo code performance — with drill-down, drill-through, and AI-generated insights across 10+ brands.

8 Pages 1.5M+ Deliveries AI Insights
Power BI DAX Power Query SQL Omeda
View full project →
Business Intelligence Power BI

Editorial Insights

A Power BI report for the Editorial Team tracking website performance, content engagement, audience growth, newsletter analytics, and low-performing articles — powered by GA4 and Omeda via Databricks SQL.

8 Pages 16.6M Users GA4 + Omeda
Power BI DAX GA4 Databricks SQL Omeda
View full project →

Let's work together

Open to data analyst, BI, or analytics manager roles.

📄 Download CV Get in Touch ↗