Senior Business Intelligence & Analytics Leader

DELE ALO

SUMMARY

Senior Business Intelligence and Analytics specialist with 10+ years of experience designing enterprise- scale analytics solutions across energy, healthcare, and life sciences. Proven ability to architect cloud data platforms, build governed semantic models, and deliver 100+ executive and operational dashboards supporting $100M+ revenue environments. Deep expertise in SQL, Power BI/Fabric, Oracle NSAW, ERP analytics, and data governance, with a strong record of mentoring teams, optimizing pipelines, and translating complex data into business outcomes.

SKILLS

Technical & Querying: SQL (T-SQL, Oracle, MySQL) DAX Power Query (M) Python (pandas, NumPy) Azure Data Factory SQL Server Integration Snowflake Azure Synapse Git Business Intelligence & Visualization: Power BI (including Fabric semantic models) Tableau NetSuite Analytics Warehouse (NSAW) KPI Design Data Storytelling Forecasting & Trend Analysis Cloud & Data Platforms: Microsoft Azure Oracle Cloud Infrastructure (OCI) Oracle Autonomous Data Warehouse (ADW) Azure Data Lake Power Platform (Apps, Automate) ERP & Business Systems: Oracle NetSuite NSPB (Planning & Budgeting) Tipalti Epic (Clinical, Billing, Revenue) Veeva (Clinical Research) SAP BusinessObjects Domain & Analytics: Physician Compensation (wRVU/cRVU) Medicaid Billing & Reimbursement ICD-10/CPT/DRG Financial & SaaS Spend Analytics Budget vs. Actuals Governance & Delivery: Data Governance & Cataloging KPI Standardization Row-Level Security

(RLS) Data Quality & Validation QA Testing Documentation & Training Tools & Development: Microsoft Excel (PowerPivot, VBA, Advanced Formulas) Azure Data Studio Visual Studio Code

EXPERIENCE

Business Process Analyst (Contract)

Williams Petroleum Services Houston, TX Mar 2026 – Present

• Led enterprise supply chain analytics initiatives supporting capital projects and operations, analyzing over $1.5B in procurement transactions to identify sourcing opportunities, pricing variances, supplier performance trends, and contract compliance risks.

• Designed and implemented governed Power BI semantic models and KPI frameworks supporting Procurement, Supply Chain, Finance, and Operations teams, standardizing 30+ enterprise metrics and improving reporting consistency by 35%.

• Developed predictive forecasting models using Databricks, SQL, and Power BI to forecast material demand, optimize inventory planning, and proactively mitigate supply chain disruptions across critical equipment and infrastructure projects.

• Built executive dashboards and scorecards tracking Blanket Pricing Agreement (BPA) utilization, supplier performance, spend trends, contract compliance, and realized savings opportunities, reducing manual reporting effort by 40%.

• Integrated and transformed data from ERP, procurement, inventory, and vendor management systems within Databricks, creating scalable analytics datasets supporting more than 75 business stakeholders.

• Performed advanced spend analytics and supplier benchmarking across $1.5B+ in procurement activity, identifying multi-million-dollar cost optimization opportunities through sourcing strategy improvements and contract adherence.

• Partnered with procurement, project management, finance, and operations leadership to document future-state business processes, delivering 15+ process improvement initiatives that increased operational efficiency and reporting transparency.

• Established reporting governance, KPI definitions, and data quality validation standards that improved trust in enterprise reporting and reduced reporting discrepancies by 25%. Senior Business Intelligence Analyst / Data Migration Lead Cordia Energy (Houston, TX) Apr 2024 – Jan 2026

• Architected analytics workloads on Oracle Cloud Infrastructure (OCI), consolidating 100% of enterprise financial data into Oracle Autonomous Data Warehouse (ADW/OADW) to support analytics for $100M+ annual revenue.

• Designed Oracle-native ETL and transformation pipelines ingesting NetSuite GL, AP, revenue, and operational data into OADW, processing 5M+ rows monthly while improving query performance by 35%.

• Built and optimized NSAW semantic models and subject areas powering 15+ executive dashboards (P&L, cash flow, margin), eliminating 40% of manual financial reporting effort.

• Developed a Budget vs. Actuals analytical framework using Oracle SQL and ADW automated tuning features, accelerating reconciliation cycles by 30% and improving forecast accuracy.

• Implemented data governance, validation rules, and KPI monitoring within OCI, increasing financial data accuracy by 25% and strengthening audit readiness for SOX-aligned reporting.

• Owned Oracle NetSuite ERP analytics integration, modeling 50+ core financial tables and dimensions in OADW and NSAW, reducing close-cycle analysis time by 30% and supporting 100+ finance and operations users.

Data Analytics / Power BI Developer

CSAT Solutions (Houston, TX) Nov 2020 – Mar 2024

• Directed a Microsoft-centric analytics ecosystem (Power BI, Fabric, Power Apps, Power Automate, ADF, Snowflake, SQL Server) supporting 150+ users across 6 business functions

• Delivered 50+ enterprise Power BI dashboards, reducing time-to-insight by 25% and replacing 12+ manual Excel-based operational reports

• Standardized analytical models using Star Schema and Fabric semantic layers, governing 30+ KPIs and reducing cross-department metric variance by 20%

• Engineered ETL pipelines with ADF, SQL, and Snowflake, processing 1M+ rows daily while improving refresh reliability and performance by 25%

• Automated operational workflows and API ingestion via Power Automate and Power Apps, handling 10,000+ records weekly and cutting manual effort by 35%

• Applied statistical and predictive methods (regression, forecasting, trend analysis) to 10,000+ records, contributing to a 20% improvement in customer satisfaction

• Mentored 5+ analysts and developers, instituting governance, code reviews, and delivery standards that increased team throughput by 20%

• Established data cataloging and metadata management practices, documenting 100+ datasets and metrics, improving data discoverability by 40% and strengthening enterprise analytics governance

Senior Business Data Analyst

Harris Health System (Houston, TX) Feb 2017 – Oct 2020

• Delivered board-level and regulatory analytics in Tableau, improving reporting accuracy by 25% across physician compensation, payer mix, and Medicaid performance

• Engineered an end-to-end Epic Snowflake Tableau data pipeline, enabling self-service analytics for 100+ clinical and finance users and reducing manual extracts by 40%

• Modeled wRVU/cRVU-based physician compensation analytics using CPT, DRG, and encounter-level data, supporting productivity and compensation planning for 120+ providers

• Analyzed 500K+ annual Medicaid claims using ICD-9, ICD-10, CPT, and DRG groupers, identifying denial and reimbursement trends that improved revenue visibility

• Developed 50+ Tableau dashboards tracking patient in/out volumes, LOS, case mix index, and utilization, improving operational decisions across 8+ departments Data Analyst

Otonomy (San Diego, CA) Jan 2013 – Jan 2017

• Supported 20+ clinical and translational research initiatives, delivering analytical outputs for peer-reviewed publications, executive reviews, and scientific presentations

• Streamlined 10+ R&D data workflows, improving reproducibility, regulatory compliance, and turnaround time for research deliverables

• Enforced data management, validation, and quality control standards across research datasets, reducing data inconsistencies by 20%

CERTIFICATIONS

Microsoft Certified: Power BI Data Analyst Associate Microsoft Certified: Azure Fundamentals

EDUCATION

Bachelor of Science – Information System Management York College, City University of New York, NY – 2011 Associate of Applied Science – Telecommunications

LaGuardia Community College, City University of New York, NY – 2009

Contact this candidate