Data Engineering · Business Systems · Enterprise Architecture

I unify the systems, data, and people that drive enterprise decisions.

A decade of making complex financial systems, payment platforms, and data architectures work together — with a growing focus on data engineering: building the pipelines, warehouses, and reporting platforms that turn fragmented data into decisions.

10+
Years in Enterprise Tech
4
Industries
SQL
Data Engineering Focus
CSUN
B.A. Economics

What I Do

Core Capabilities

Data Engineering

My core focus today. SQL Server, Databricks, PostgreSQL, ETL pipelines, and lakehouse architecture — building the data foundations that turn fragmented sources into trusted, decision-ready intelligence.

Analytics & Reporting

Power BI, Tableau, SSRS dashboards and reporting platforms. Transparent, actionable intelligence delivered to leadership where they need it.

Business Systems Architecture

Unifying CRMs, payment platforms, portfolio systems, and ERPs into cohesive operations.

Enterprise Integration

Payment processing, banking APIs, processor middleware, settlement and refund orchestration.

Financial Technology

Hedge fund operations, portfolio accounting, NAV validation, GIPS compliance, and brokerage integrations.

Execution Leadership

Cross-functional delivery across engineering, compliance, finance, and product teams.

About

The Bridge Between Business and Systems

I started at Investor's Business Daily learning that data only matters when it reaches the right person in the right format. That principle guides every system I build.

From there I moved into hedge fund operations at O'Neil Global Advisors, leading GIPS compliance certification, administering portfolio management systems, and designing data flows connecting performance metrics and investor reporting across SQL Server and PostgreSQL.

Today at Viking River Cruises I lead Apple Pay integration, migrate financial reporting from SSRS to Power BI, build Databricks pipelines, and bridge third-party bank processors with internal development teams.

Outside my day role, I am building AI agent systems, local LLM infrastructure, and knowledge architectures for the next era of enterprise operations.

How I Think

Systems first, tools second

Data you cannot trust is worse than no data

Every integration is a business decision

Reporting only matters if leadership acts on it

Modernize with purpose, not for its own sake

Education

California State University, Northridge

B.A. Economics, Certificate of Distinction in Economics

Certifications

Lean Six Sigma Yellow Belt

Tableau Desktop Certificate

Experience

Professional Timeline

Business Solutions Manager III

May 2023 – Present

Former Senior Business Analyst

Viking River Cruises — Los Angeles, CA

  • Lead Apple Pay integration; paved the way for Samsung Pay and Chase Pay
  • Liaise between third-party development teams and bank processors for payment initiatives
  • Build and optimize SQL Server tables, stored procedures, views, and functions
  • Build Databricks notebooks and dashboards in Python and SQL with automated alerting
  • Lead migration of financial SSRS reports to Power BI
  • Debug VB.NET and C# applications impacting payment processing
  • Deploy Canvas Apps, Model Driven Apps, Power Automate Flows, and Dataverse tables
SQL ServerDatabricksPower BIPythonC#VB.NETApple Pay

Senior Business Systems Analyst

June 2020 – May 2023

O'Neil Global Advisors (Subsidiary of Data Analysis Inc.) — Los Angeles, CA

  • Led and obtained GIPS Compliance Certification for the firm
  • Liaised with executives and prime brokerages for public-facing hedge fund operations
  • Implemented and administered SS&C Eze Castle OMS and SS&C Advent Portfolio Exchange
  • Designed capital account attribution reporting and fund revenue data flows from SQL Server to PostgreSQL
  • Built real-time database monitoring for data quality and efficiency
  • Managed offshore teams in India and China for overnight operations
SQL ServerPostgreSQLTableauSSRSGIPSSS&C Advent

Business Analyst II

June 2017 – June 2020

Data Analysis Inc. (Parent of Investor's Business Daily) — Los Angeles, CA

  • SME integrating business requirements with third-party portfolio applications
  • Administered implementation, reporting, accounting, and training of Advent Portfolio Exchange
  • Managed ETL data processes from Advent libraries to create business intelligence
  • Cross-functional collaboration with stakeholders, DBAs, and developers
SQL ServerETLAdvent APXPowerShell

Business Analyst I

Aug 2016 – June 2017

Investor's Business Daily — Los Angeles, CA

  • Built data extracts for reporting and automation of recurring analysis
  • Delivered front-end and back-end reports using PowerShell, Excel, SSMS, and VBA
  • Led DocuSign API integration across compliance, manufacturing, and HR departments
PowerShellVBASSMSDocuSign API

Projects

What I Have Built

Payments

Apple Pay Integration

End-to-end Apple Pay implementation across Viking's booking platform with bank processor integration.

Digital payments live across booking platform
VB.NETC#APIs
Analytics

SSRS to Power BI Migration

Modernizing legacy financial reports into interactive Power BI dashboards with real-time connectivity.

Modern executive dashboards replacing legacy reports
Power BISSRSSQL
Data Engineering

Databricks Monitoring

Notebooks and dashboards in Python and SQL for pipeline monitoring with automated alerting.

Automated monitoring across data pipelines
DatabricksPython
Finance

GIPS Compliance

Led full GIPS Compliance Certification. Designed data flows, reporting, and audit procedures.

Firm-wide GIPS certification achieved
GIPSSQL ServerSSRS
Enterprise

Portfolio System Platform

Implemented SS&C Eze OMS and Advent APX with real-time monitoring and brokerage integrations.

End-to-end portfolio operations
SS&C EzeAdvent APXPostgreSQL
Data Engineering

Fund Revenue Architecture

Revenue data flows from SQL Server to PostgreSQL, capital attribution, and performance metric integration.

Unified fund revenue pipeline
SQL ServerPostgreSQLETL
AI

AI Agent Research System

Multi-agent research system on local LLMs with RAG retrieval and n8n orchestration.

Operational AI research on local infra
LM Studion8nRAG
AI

Knowledge Architecture

Obsidian-based knowledge system connected to AI agents for institutional retrieval.

Queryable knowledge with AI interfaces
ObsidianRAGLLMs

Technical

Proficiencies

Languages

Python

C#

VB.NET

SQL

PowerShell

VBA

Databases

SQL Server

PostgreSQL

Databricks

Dataverse

Cloud

Azure

GCP

Windows Server

Reporting

Power BI

Tableau

SSRS

Looker

Platforms

SS&C Advent

SS&C Eze OMS

n8n

JIRA

AI

Local LLMs

LM Studio

Gemma

RAG

Obsidian

AI and Automation

What I Am Building Next

Beyond my enterprise role, I am actively building AI agent systems, local LLM infrastructure, and agentic workflows.

Thoughts

Writing and Thinking

Data

Why Financial Reporting Migrations Fail

Lessons from SSRS to Power BI. The hard part is never the tool.

Enterprise

The Integration Problem Nobody Talks About

Systems that don't talk cost you decision latency, not just tech debt.

Finance

What GIPS Taught Me About Data Trust

Institutional-grade data standards applied to every system since.

Vision

The Next Operating System for Business

Agent workforces and knowledge systems will replace departments and licenses.

Strategy

Modernize With Purpose

Not every legacy system needs replacing. How to decide what to modernize.

Contact

Get in Touch

Technology Leadership

Business Solutions, Data Engineering, or Architecture roles.

Enterprise Consulting

Systems integration, data platforms, payment systems, reporting.

AI Transformation

Agent systems, automation, knowledge architecture.

Advisory

Technical due diligence and fintech consulting.

Walter L. Roby Jr.

Walter.Roby.Jr@Gmail.com

(818) 536-8267 · Los Angeles, CA

www.linkedin.com/in/walterroby