DATA in NARRATIVES.

No need to Overthink when dashboards are done right. Produce insights your team actually uses — Automated workflows are the future. Now that AI is here, it's more important now to prioritize quality and accuracy of your data.

The data analytics & automation portfolio

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
functionDAX Measure
CALCULATE(SUM(Sales[Amount]), FILTER(...))
account_treen8n Pipeline
PDF
JS
Uptime 99.8% All pipelines
table_chartSheets Sync
1,247 rows updated BPI · BDO · UnionBank

Tools & platforms I work with daily

Power BIPower BI
DAXDAX
n8nn8n
Google Apps ScriptApps Script
DockerDocker
ObsidianObsidian
schemaBPMN 2.0
MermaidMermaid
Notion
Slack
mMonday.com
SupabaseSupabase
MongoDBMongoDB
TailscaleTailscale
PythonPython
searchRegex
ExcalidrawExcalidraw
TMDLTMDL
Google Workspace
Microsoft 365
Trello
Raymond Paredes
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 —
0
DAX Measures Authored
0
Workflows Automated
0
Dashboards Built
0
Pipeline Uptime
0
Active Data Models
0
Linked Obsidian Notes
Tech Preview

Live results that keep you competitive and ahead

Dashboards don't live in isolation — they're the output of everything upstream. I build Power BI reports that pull from automated n8n pipelines and structured knowledge vaults, transforming procurement spend, vendor performance, and budget variance into real-time visuals your team can trust and act on.

  • check_circleDAX optimization: Sub-second loading on 100K+ row datasets with custom measures
  • check_circleTMDL exports: Version-controlled data models for structured deployment
  • check_circleDrill-through pages: Bookmark navigation with dynamic cross-filtering
20+
Dashboards built for creating effective operational action
POWER BI · LIVE EMBED
Automation Engine

Automation that's actually smart.

Automation is the connective tissue between raw data and meaningful insight. I design n8n workflows that extract bank statements, trigger Gmail actions, and sync spreadsheets — feeding clean, structured data directly into your dashboards and knowledge systems, all containerized with Docker and secured via Tailscale.

  • check_circleParsing Document Data to Structured Format: PDF/OCR extraction Financial Statements, Invoices, Receipts, and more
  • check_circleGoogle Apps Script integrations: Gmail analysis, Calendar export, Tasks auto-sync to Sheets
  • check_circleWebscrape anything you need Using Firecrawl to scrape any information needed to get those leads or product research
50+
Workflows automated across operations to all department data to keep everything up-to-date
▼ dispatching to integrations
⬇ webscraping pipeline · powered by Firecrawl + n8n
firecrawl · scraping target
SCANNING
target page
Company Name
📧 [email protected]
₱ 4,200 / unit
High-grade construction aggregate for
commercial and residential projects…
extracted data 0 fields
Initializing Firecrawl… powered by Firecrawl + n8n
Slack
#ops-alerts
+1
n8
n8n Bot
Report synced ✅
Asana
My Tasks
+1
Review Q2 report
Vendor list updated
Trello
Ops Board
+1
To Do
In Progress
PO Approval
Done
GR Upload
Vendor Sync

Knowledge systems that make institutional know-how searchable and actionable

Knowledge systems are what give automation context and dashboards direction. A better way to understand knowledge is to structure it in the best way your org can leverage it. Using Obsidian vaults with BPMN process maps, Mermaid diagrams, and AI-powered retrieval layers — so the processes your workflows automate and your reports measure are documented, findable, and understood by the whole team. The Second Brain in your process

  • check_circleObsidian vault architecture: Adapting your own Maps of Content to manage context and organization of each department and ensure standardization of documentation and find insights
  • check_circleProcess documentation: BPMN 2.0 or Mermaid to visualize workflow diagrams, Excalidraw to share a whiteboard to edit with the team
  • check_circleRAG prototyping: LLM-powered retrieval with vector search over documentation
12
Proactive knowledge management and documentation to maintain Standardized Practices in any business workflow
D3 · INTERACTIVE
Knowledge Graph 12 nodes
MOC Hub Workflow Finance Process
Drag · Scroll · Hover
Skills & Tech Stack

Every data point, workflow, and knowledge node — in one stack

Understand your operations, your pipelines, and the gaps between them. Then automate.

bar_chart

Analytics Dashboards:

Build enterprise Power BI reports with DAX optimization, TMDL modeling, and drill-through KPIs — sub-second on large datasets.

sync_alt

Workflow Automation:

Design n8n pipelines ranging from OCR document parsing, complex RAG architectures, to autonomous AI agent messaging. Fully containerized.

hub

Knowledge Systems:

Structure Obsidian vaults with BPMN process maps, Mermaid diagrams, and AI-powered retrieval — so your team finds answers, not documents.

150+
DAX measures authored across projects
50+
n8n workflows automated
12
Active Obsidian data models
₱4.2M
Total PO Value
+12.4%
93%
On-Time Delivery
+3.1%
18d
Avg Lead Time
-2.3d
bar_chart PO Value by Supplier — Q1 2026
Jollibee Supplies
₱1.2M
SM Trading
₱960K
Meralco Parts
₱760K
PLDT Corp
₱590K
Others
₱420K
PO #SupplierStatusAmount
PO-2026-0041Jollibee SuppliesDelivered₱248,000
PO-2026-0042SM Trading Co.In Transit₱115,500
PO-2026-0043Meralco PartsApproved₱320,750
PO-2026-0044PLDT Corp.Pending₱89,200
code DAX · TMDL · Drill-Through
OCR Parsing — PDF to Structured Data
bolt Live · send a message to trigger the workflow
play_arrow Webhook → Read PDF → AI Extraction → Format → Sheets
Graph View Global
search
MOC Hub Workflow Finance Process
Scroll · Drag · Click to focus
— Portfolio —

Some Projects done so far.

Bank Statement Pipeline
Bank Statement Extraction
n8n · Regex · Google Sheets
Workflow Automation
Bank Statement Extraction
n8n pipeline parsing PH bank PDFs (BPI, BDO, UnionBank) via OCR into structured JSON, auto-categorised and synced to Google Sheets.
n8n Regex Sheets API
Knowledge Management
Knowledge Management
Obsidian · BPMN · Mermaid
Knowledge Systems
Knowledge Management
Obsidian vault with 200+ MOC notes, BPMN 2.0 procurement process maps, and Mermaid documentation diagrams.
Obsidian BPMN 2.0 Mermaid
Gmail & Calendar Sync
Gmail & Calendar Sync
Google Apps Script
Automation
Gmail & Calendar Sync
Google Apps Script suite for Gmail sender analysis, Calendar export to per-calendar sheets, and Google Tasks auto-sync.
GAS Gmail API Calendar
Personal Finance Dashboard
Personal Finance Dashboard
Excel · Power Query
Personal Project
Personal Finance Dashboard
Excel dashboard with PH bank data (BPI, BDO, Metrobank), Power Query transformations, and automated categorisation.
Excel Power Query
Self-Hosted Stack
Self-Hosted Stack
Docker · Tailscale · Nginx
Infrastructure
Self-Hosted Stack
Docker-composed n8n, MongoDB, Supabase, and Nginx reverse proxy on a Tailscale mesh network with 99.8% uptime.
Docker Tailscale Nginx

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.