Summary
Overview
Work History
Education
Skills
Timeline
Generic

Iseoluwa Ishola

Dallas,TX

Summary

Results-driven BI Consultant with 5 years of experience in finance and healthcare. Specializing in Power BI, Tableau, and SQL to transform complex data into strategic insights. Skilled in scalable, cloud-based analytics, real-time processing, and compliance reporting (HIPAA, SOX, SEC). Passionate about leveraging BI-driven analytics, self-service BI, and automation to improve financial management and patient care.

Overview

5
5
years of professional experience

Work History

Business Intelligence Consultant

Advocate Health Care
01.2024 - Current
  • Designed and implemented high-performance SQL queries and stored procedures to support financial analytics and risk assessment models.
  • Developed ETL pipelines in SSIS to ingest, clean, and transform data from multiple sources, including Snowflake, SQL Server, and Denodo.
  • Optimized SQL queries to improve execution time for complex financial reports, trade analytics, and regulatory compliance dashboards.
  • Created data models, fact tables, and dimension tables for financial reporting and investment analytics.
  • Implemented real-time data streaming solutions using SQL Server and Azure Synapse for fraud detection and market risk analysis.
  • Remote

Business Intelligence Developer

LPL Financial
07.2023 - 12.2023
  • Developed and implemented enterprise-wide data governance frameworks, ensuring data integrity, security, and consistency across Power BI, Tableau, and SQL-based reporting solutions.
  • Developed and optimized executive dashboards and KPI scorecards in Power BI and Tableau, providing C-suite leaders with AI-driven insights for strategic decision-making.
  • Designed and managed data pipelines between Snowflake, Denodo, SQL Data Lakes, and BI platforms, enabling high-performance data integration for analytics.
  • Implemented Row-Level Security (RLS) and Object-Level Security (OLS) in Power BI and Tableau to maintain strict security controls.
  • Developed Power BI embedded analytics within CRM systems (Salesforce, Dynamics 365), enhancing data accessibility and decision-making.
  • Integrated predictive analytics and machine learning models in Power BI and Tableau using Python and R to support forecasting and risk assessment.
  • Developed enterprise-wide Tableau dashboards to support financial planning, risk management, and regulatory compliance reporting.
  • Designed data visualizations for trade analytics, investment performance tracking, and portfolio risk assessments.
  • Integrated SQL Server, Snowflake, and Denodo data sources with Tableau to create real-time financial reports.
  • Developed custom Tableau calculated fields and complex table calculations for advanced trend analysis.
  • Created heatmaps and geospatial dashboards to analyze customer behavior, branch performance, and investment trends.
  • Designed Tableau extracts and data models to handle large financial datasets efficiently.
  • Automated Tableau Server data refresh schedules, ensuring up-to-date reporting for finance teams and executives.

Business Intelligence Developer

Johns Hopkins Medicine
01.2020 - 02.2023
  • Wrote and optimized complex SQL queries to extract, aggregate, and analyze data from multiple tables using JOIN, GROUP BY, HAVING, and WHERE clauses.
  • Developed and maintained stored procedures, triggers, and functions to automate business logic and improve database performance.
  • Designed and normalized database schemas by defining primary and foreign keys, applying indexing strategies, and ensuring data integrity.
  • Analyzed slow queries using EXPLAIN and QUERY PLAN, implementing indexing and partitioning strategies to enhance performance.
  • Managed database security by configuring user roles and access controls using GRANT and REVOKE to protect sensitive data.
  • Created and optimized ETL processes to extract, transform, and load data from multiple sources into centralized databases.
  • Monitored and maintained database health by updating statistics, rebuilding indexes, and addressing fragmentation issues.
  • Scheduled and automated SQL jobs using SQL Server Agent (or cron jobs) for data imports, backups, and routine maintenance tasks.
  • Implemented error handling and transaction control using TRY...CATCH, ROLLBACK, and COMMIT to ensure data consistency.
  • Developed complex reports utilizing temporary tables, CTEs, and analytical functions like RANK(), ROW_NUMBER(), and PARTITION BY to support business decision-making.
  • Developed Power BI reports and dashboards, enabling data-driven hospital management to improve patient care and operational efficiency.
  • Ensured HIPAA compliance and ITRUST security controls when handling sensitive patient data within Epic and BI environments.
  • Extracted and transformed Epic data to generate actionable insights for hospital operations, patient outcomes, and clinical efficiency.
  • Designed real-time dashboards to help clinical teams track performance metrics and enhance decision-making.
  • Developed reports to monitor patient readmission rates, appointment scheduling efficiency, and hospital resource utilization.
  • Utilized Power BI to track and report on clinical quality measures, ensuring compliance with regulatory and accreditation standards.
  • Developed ETL processes using SSIS to load, transform, and manage data within databases, data warehouses, and data lakes.
  • Extracted data from multiple sources such as databases, flat files, Excel, and web services, ensuring seamless integration.
  • Built interactive dashboards, KPI reports, and data visualizations using Power BI, Looker, and Tableau to drive data-driven decision-making.
  • Implemented row-level security (RLS) in Power BI to control data access based on user roles.
  • Developed LookML models and Looker dashboards, improving data visualization and exploration for key business stakeholders.
  • Led cross-functional teams and managed projects from inception to delivery, ensuring successful execution of BI initiatives.
  • Remote

Education

Bachelor of Science - Computer Science

Babcock University
Ogun State, Nigeria
07-2022

Skills

  • Operating Systems: Windows Server, Linux
  • Business Intelligence Tools: Tableau Desktop, Google Looker Studio, Power BI, Excel, and Power Pivot, SSRS, SSAS, SSIS, & OBIEE, SAP Hana, Genesis, SAS EG-SAS Viya
  • Databases: Google Big Query, (GCP) PostgreSQL 95, SAP HANA 2, Snowflake, MS SQL Server 2012/2016/2017, MongoDB, Denodo, Teradata 12/13, MySQL 52, 57, Oracle 9i, 10g, 11g, Apache Hive, Amazon Redshift, Microsoft Azure, Salesforce CRM
  • ETL/Other Tools: Informatica Power Center 861/9, SAS Enterprise Guide, SSIS (Visual Studio), Erwin Data Modeler, ER Assistant, R
  • Cloud: AWS, AZURE, GCP
  • Querying Tools: SQL Management Studio 2008/2012, Teradata SQL Assistant, SQL Plus, Oracle SQL Developer, Teradata PL/SQL, Google LookML
  • Querying language: SQL, PL/SQL, TSQL
  • Dashboard visualization design
  • Dashboard creation
  • Expertise in Excel modeling techniques
  • Data representation modeling

Timeline

Business Intelligence Consultant

Advocate Health Care
01.2024 - Current

Business Intelligence Developer

LPL Financial
07.2023 - 12.2023

Business Intelligence Developer

Johns Hopkins Medicine
01.2020 - 02.2023

Bachelor of Science - Computer Science

Babcock University

Similar Profiles

CREATE PROFILE
Iseoluwa Ishola