I build dashboards, SQL reports, data validation solutions, and reporting workflows. I also develop practical AI automation projects that demonstrate how CRM, scheduling, knowledge management, and customer support processes can be automated.
Practical solutions for businesses that need reliable reporting, clean data, automated workflows, and faster decision making.
Executive dashboards, KPI reporting, financial reporting, mortgage analytics, operational dashboards, Power BI Service deployment, refresh troubleshooting, and business intelligence solutions.
PostgreSQL, SQL Server, complex CTEs, performance tuning, stored procedures, JSON outputs, ETL, and reporting automation.
Portfolio-built AI automation systems using n8n, APIs, AI models, webhooks, and business platforms. Projects include CRM follow-ups, appointment scheduling, knowledge assistants, and customer messaging.
Power BI reports and dashboards managed
End-to-end builds across analytics, reporting, and automation
Years of analytics experience
Certified Power BI Data Analyst
Selected dashboards covering finance, mortgage, banking, sales, operations, and customer analytics.
SQL and data engineering work focused on database design, data cleaning, exploration, ETL, API pulls, reporting logic, and validation.
Hands-on portfolio systems designed around realistic business processes, including lead management, document search, appointment scheduling, customer support, and reporting automation.
Asana CRM Automation
Automates lead follow ups, client onboarding, stage routing, and retention communication.
RAG Knowledge Base Agent
Answers questions using approved documents and automatically updates its searchable knowledge base.
AI Receptionist
Handles appointment availability, booking, rescheduling, cancellation, and call records through a voice assistant.
Messenger AI Assistant
Responds to customer inquiries using approved FAQ information and conversation context.
Automates client follow ups, onboarding tasks, project stage routing, and personalized communication throughout the customer journey.
Designed Benefits
Uses approved business documents to provide grounded answers while automatically keeping the searchable knowledge base current.
Designed Benefits
Processes customer inquiries through Messenger, uses approved FAQ information and conversation context, then sends a consistent response back to the customer.
Designed Benefits
Uses a voice assistant to check availability, book appointments, manage changes, and keep calendar and client records synchronized.
Designed Benefits
Portfolio projects demonstrating hands-on use of Tableau, Looker Studio, Excel, and Python across dashboarding, analysis, reporting, and automation.
Allen Arorong is a Microsoft Certified Power BI Data Analyst based in Iloilo City, Philippines. I have practical experience supporting Power BI dashboards, SQL reporting, data validation, report refreshes, and business reporting workflows.
My professional background includes Power BI development, PostgreSQL reporting, mortgage and financial services reporting, dashboard refresh support, UAT and production troubleshooting, SQL data validation, and Excel reporting. I have also developed hands-on portfolio projects using Tableau, Looker Studio, Python, and AI automation, with n8n as my primary workflow automation platform.
Through n8n, I have designed end-to-end solutions for CRM follow-ups, client onboarding, knowledge-base assistance, appointment scheduling, customer messaging, and automated reporting. These projects have given me practical experience with workflow logic, data mapping, branching, webhooks, APIs, AI models, integrations, and error handling.
I focus on n8n because its flexibility allows me to understand automation at a deeper technical level. While n8n, Zapier, and Make are different platforms, they share the same core automation concepts: triggers, actions, branching, data mapping, webhooks, and API integrations. My n8n experience therefore provides a strong foundation for building in Zapier and Make, which I am continuing to explore and plan to demonstrate through future projects. My goal is to help businesses improve dashboards, automate repetitive work, and connect data analytics with practical AI automation.
Core tools I use today, plus supporting platforms from previous analytics projects.
Open to Power BI dashboards, SQL reporting, dashboard support, and AI automation projects.
Philippines, Iloilo City
