Data and BI Services - JACL Enterprises

Strategic Data Architect with proven success in designing scalable, compliant data systems that drive business intelligence and operational efficiency across retail, finance, and nonprofit sectors. Adept at translating complex business requirements into actionable technical specifications, bridging cross-functional teams, and delivering intuitive, stakeholder-ready solutions.

Data Architecture & Systems Design

Scalable, compliant data systems and enterprise reconciliation platforms supporting high-volume transaction environments.

Business Intelligence & Reporting

Power BI dashboards, custom analytics, and reporting solutions that transform data into actionable insights.

System Integration & Migration

Cloud migration, system consolidation, and data warehouse implementations with minimal disruption.

Technical Documentation & Training

User guides, technical specifications, and customized training programs for diverse audiences.

Professional Experience

Lead Architect

7-Eleven | February 2017 – Present

Lead architect and technical owner for enterprise reconciliation systems supporting 20,000+ retail sites across North America
Designed ReconNET Data Warehouse processing 10–20M daily transactions; defined migration paths to Databricks (Azure) and Oracle Cloud DB
Successfully split 2.2B row ReconNET application into two distinct installations on time and under budget
Architected cloud migration of ReconNET platform to Trintech Cloud, defining infrastructure changes and development scope
Developed ReconNET Toolkit using PowerShell and open-source tools to extend automation and reporting capabilities

Business Owner / Consultant

JACL Enterprises | June 2000 – Present

Deliver consulting and contracting services focused on business intelligence, system integration, data migration, and end-user enablement
Developed Power BI executive dashboard integrating QuickBooks and Zoho data via Zoho Analytics API and Power Query M
Authored technical documentation and user guides for AI-driven data preparation tools, defining integration specs and reporting standards
Founded and operate a successful Etsy shop featuring original 3D-printed Catholic Mass Sets

Subject Matter Expert / Sales Engineer

Kyvos Insights (Intellicus) | October 2013 – October 2019

Spearheaded adoption of Kyvos OLAP-on-Hadoop platform across Fortune 500 clients including Verizon Wireless, Walgreens, CVS, Adobe, and Barclays
Defined UX requirements and identified usability gaps to align product features with real-world enterprise needs
Designed and delivered hundreds of product demos via webinars, analyst briefings, and tradeshows
Managed multiple POC and implementation projects, acting as technical liaison between clients and internal teams

Data and Information Architect / Reporting Services Manager

Trintech | June 2000 – October 2012

Led reporting architecture and client enablement for finance reconciliation solutions across global enterprises
Designed unified reporting interface and style guide across multiple applications, enhancing usability and consistency
Created Gift Card Liability system enabling in-house reporting, saving clients up to $15K/month by eliminating vendor dependency
Trained and presented globally at customer sites and user conferences on SQL, Crystal Reports, and enterprise applications

Skills & Technologies

Data Management & Toolchains

Microsoft SQL Server (T-SQL)
Oracle PL/SQL
Power Query M and DAX
OLAP and MDX
Apache Pig
Aparavi Data Suite

Reporting & Visualization

Power BI
Tableau
SAP Crystal Reports
Kyvos and Intellicus
SSRS and Report Builder
Zoho Analytics

Financial & Donor Systems

Trintech ReconNET
Trintech Cadency (AssureNET)
Blackbaud Raiser's Edge
Total Community Manager

Programming & Scripting

PowerShell
Python
Delphi/Pascal
HTML, CSS, ASP, PHP
VBA Macros

Jason Lord