DATA in NARRATIVES.

Decoding data into your growth narrative.
Now that AI is here, it's urgent to prioritize quality and accuracy of your data.

See My Work arrow_forward View Resume open_in_new

The data analytics & automation portfolio

n8n · bank-pipeline

LIVE

RCP_ANALYTICS_DASHBOARD

LIVE

Revenue ₱4.2M ▲ 12.4%

Orders 1,847 ▲ 8.1%

Vendors 142 ● Active

Efficiency 94.2% ▲ 3.2%

Procurement Spend — 12 Months

Top Vendor Manila Concrete Co.

Pipeline Status

Last sync: 2 min ago • 12 models active

All systems operational

obsidian · rcp-vault

200+ NOTES

functionDAX Measure

CALCULATE(SUM(Sales[Amount]), FILTER(...))

account_treen8n Pipeline

PDF

→

✓

Uptime 99.8% All pipelines

table_chartSheets Sync

1,247 rows updated BPI · BDO · UnionBank

Tools & platforms I work with daily

Power BI

Power Automate

n8n

Apps Script

Docker

Obsidian

Mermaid

Notion

Slack

Monday.com

schemaBPMN 2.0

Supabase

Tailscale

Excalidraw

Claude

Gemini

Google Workspace

Microsoft 365

Trello

Who is

Raymond Paredes

Data is more than just numbers, it reveals how you act as a company. Like any company we strategize and execute options differently from the competition landscape. The best way to see improvements is to create customizable workflows that adapt to better outcomes. Metrics that doesn't merely display the now but the motivation for the future progress.

— Key Numbers —

Projects Finished On-Time

Manual Work Hours Saved

Error Reduction

Automation Uptime

Productivity Efficiency

Revenue Growth

Dashboards that drive 40%+ faster decisions

Project Purpose & Business Case

Transform raw data into a competitive advantage. Your company probably spends 15+ hours/month on manual reporting while expenses and performance metrics remain buried in email silos, delaying critical decisions.

Goal & Deliverable

1Goal: Automate reporting cycles and eliminate repetitive stakeholder Q&A loops.
2Deliverable: Live-embedded Power BI, Excel, and Sheets dashboards with automated pipelines.
3System: Star-schema data models tracked in Git for zero-error deployments.

Results & Business Impact

32%

Faster Decisions

Reporting cycles cut from weekly to same-day via automated pipelines

100%

Audit-Ready

TMDL version-controlled exports — zero deployment errors across all models

50%

Q&A Time Saved

Drill-through pages eliminated back-and-forth stakeholder reporting loops

Replaced manual ops work with a Data Model First strategy. Leadership moved from requesting data to acting on it instantly, with 20+ dashboards tracking ₱4.2M+ in procurement value in real-time.

POWER BI · LIVE EMBED

Every company loses 15+ hours/week to tasks a workflow could handle

Project Purpose & Business Case

Eliminate repetitive manual tasks and secure business operations against human error. Teams currently lose 15+ hours/week to manual data entry, PDF parsing, and chasing approvals over chat.

Goal & Deliverable

1Goal: Build robust, containerized pipelines to automate the document-to-database lifecycle.
2Deliverable: A self-hosted n8n engine integrated with any app and the full Google Workspace suite.
3System: Firecrawl-powered web scraping delivering structured JSON data directly to dashboards.

Results & Business Impact

3×

Faster Processing

PDF/OCR extraction vs. manual entry across Philippine banks

50%+

Error Reduction

Automated validation catches mismatches before they reach reporting

99.8%

Pipeline Uptime

Self-hosted Docker stack on Tailscale — zero SaaS dependency or downtime

50+ workflows automated — each one eliminating repetitive ops work. Bank statement parsing alone saved 12+ hours/month with 99.5% accuracy, running securely on containerized infrastructure.

▼ dispatching to integrations

⬇ webscraping pipeline · powered by Firecrawl + n8n

Slack

#ops-alerts

n8n Bot
Report synced ✅

Asana

My Tasks

Review Q2 report

Vendor list updated

Auto-task from n8n

Trello

Ops Board

To Do

In Progress

PO Approval

Done

GR Upload

Vendor Sync

Companies without a knowledge system repeat mistakes that cost millions

Project Purpose & Business Case

Secure institutional information and accelerate team productivity. Critical knowledge walks out the door when employees leave, costing millions in repeated mistakes and slow onboarding.

Goal & Deliverable

1Goal: Centralize process logic using standardized BPMN 2.0 and Mermaid flowcharts in a searchable vault.
2Deliverable: An interactive Obsidian "Maps of Content" (MOC) system with AI-powered retrieval.
3System: D3-powered knowledge graph for visual collaboration and system design.

Results & Business Impact

5×

Faster Answers

Teams find answers in seconds vs. minutes searching shared drives

40%

Faster Onboarding

New hires reach productivity faster with searchable process maps

100%

Process Coverage

BPMN 2.0 logic documented for every critical department

Documentation transformed from static PDFs into a living, searchable graph. Companies using this system eliminated recursive training costs and secured critical logic against employee turnover.

D3 · INTERACTIVE

Knowledge Graph 12 nodes

MOC Hub Workflow Finance Process

Drag · Scroll · Hover

Skills & Tech Stack

The three systems every growing company needs — and the results they deliver

The Data Trifecta: Combining Dashboard, Automation, and Knowledge Management to turn scattered operations into a scalable engine. Together, they eliminate 15+ manual hours/week and cut operational errors by 50%.

OCR Parsing — PDF to Structured Data

Ask me about Raymond's services…

send

smart_toy AI Agent · Portfolio Knowledge Base · Powered by n8n

Graph View Global

MOC Hub Workflow Finance Process

Scroll · Drag · Click to focus

— Case Studies —

Real results every company can learn from.

Each project below solved a problem your company probably has right now.

Procurement Dashboard

IPM Construction

star Featured

Procurement Dashboard

Replaced monthly PDF reports with real-time Power BI tracking ₱4.2M+ in PO value. Result: 32% faster procurement cycles, 50% fewer approval bottlenecks, and leadership visibility from days to seconds with 150+ DAX measures.

Power BI DAX TMDL Drill-Through

Document to Database Pipeline

Workflow Automation

Document to Database Pipeline

Automated bank statement processing across 4 PH banks (BPI, BDO, UnionBank, Robinsons) — eliminated 12+ hours/month of manual data entry with 99.5% extraction accuracy and auto-categorized transactions synced to Google Sheets in real time.

n8n Regex Sheets API play_circleDoc Pipeline

Microsoft Power Platform Workflow

Knowledge Systems

Microsoft Power Platform Workflow

Built an Obsidian vault with 200+ MOC notes and BPMN 2.0 process maps covering every department. Cut new-hire onboarding time by 40% and gave cross-functional teams 100% process visibility — no more tribal knowledge silos.

Obsidian BPMN 2.0 Mermaid play_circlePower Platform

Finance tracker

Personal Project

Finance tracker

A comprehensive Power BI personal finance tracker that provides real-time cash flow visibility and automated expense tracking for smarter financial allocation.

Power BI DAX

Task Management

Analytics

Task Management

A planning-focused Power BI dashboard built for broad accessibility — combining intuitive visuals with structured DAX logic for real-time plan tracking, variance analysis, and actionable insights across teams.

Power BI DAX Planning

Automated Knowledge Base

Infrastructure

Automated Knowledge Base

Docker-composed n8n, MongoDB, Supabase, and Nginx on a Tailscale mesh — achieving 99.8% uptime, zero vendor lock-in, and a self-hosted infrastructure that handles production workloads at a fraction of SaaS costs.

Obsidian Notion Nginx play_circleKnowledge Base

View All Projects arrow_forward

Let's talk and see what we can do for your business

Have a project that needs the data trifecta of dashboards, automation, or knowledge systems? Send me a message.

location_onMetro Manila

linkLinkedIn codeGitHub

auto_awesome

RCP Assistant

Online · AI-powered

waving_hand

Hi! Ask me anything

I know all about Raymond's services, projects, tools, and how to get in touch.