Business Intelligence Data Analyst

BOB KAYODE

Email: ***.*.******@*****.*** Phone: 443-***-**** Location: Maryland

PROFESSIONAL SUMMARY

Highly skilled Senior Business Intelligence (BI) Consultant & Advanced Data Analyst with 10+ years of experience in data analytics, business intelligence, and data visualization. Proven expertise in Power BI, Tableau, Looker, SQL, Python, and R, leveraging AI-driven analytics, predictive modeling, and real-time data processing to transform complex datasets into actionable insights that drive business growth.

Proficient in data governance, security models (RLS/OLS), and cloud-based BI solutions (Azure, AWS, GCP) with a strong background in machine learning, embedded analytics, and automation. Adept at statistical modeling, data mining, A/B testing, and forecasting, ensuring data-driven decision-making and operational efficiency.

Experienced in ETL processes, data engineering, and data integration, optimizing performance for large-scale datasets while ensuring data accuracy and integrity. Skilled in automating workflows, building interactive dashboards, and developing self-service analytics solutions for business users.

Strong ability to lead BI teams, implement enterprise-wide data strategies, and train stakeholders in BI adoption. Passionate about bridging the gap between data science and business intelligence, delivering innovative solutions that enhance strategic planning, efficiency, and competitive advantage

TECHNICAL SKILLS

BI & Data Visualization: Power BI, Tableau, Looker, SSRS, SSAS, OBIEE, SAP Hana

Databases & Cloud Platforms: Google BigQuery, PostgreSQL, Snowflake, MS SQL Server, MySQL, Redshift, SAP HANA, Azure, Salesforce CRM

ETL & Data Engineering: SSIS, Informatica PowerCenter, SAS Enterprise Guide, Erwin Data Modeler, Data Integration (SQL, Python, R)

Security & Governance: Row-Level Security (RLS), Object-Level Security (OLS), Data Governance Strategies

Querying & Scripting: SQL, T-SQL, PL/SQL, LookML, Python, DAX, PowerShell

Tools & Platforms: GitLab, Visual Studio, AI-driven Analytics, NLP, AWS

PROFESSIONAL EXPERIENCE

Senior BI Consultant Data Analyst

DAI Global, Maryland (Aug 2023 – Present)

Designed and implemented enterprise-wide data governance frameworks, ensuring data integrity, security, and accessibility across all business functions.

Developed executive-level dashboards, KPI scorecards, and interactive BI reports, enabling C-suite and senior leadership to make data-driven strategic decisions.

Designed and developed SSRS-based paginated reports, ensuring pixel-perfect, printable reports for operational and executive reporting needs.

Built and optimized UI/UX components for BI dashboards, enhancing usability, accessibility, and interactive user experience for business users.

Performed advanced SQL-based data analysis, including complex joins, window functions, CTEs, and stored procedures, to extract actionable insights and optimize reporting performance.

Built and optimized ETL workflows using SQL, Python, and cloud-based tools, ensuring efficient data extraction, transformation, and loading from multiple sources.

Implemented AI-driven analytics and NLP-powered insights, enabling automated anomaly detection, sentiment analysis, and predictive intelligence for proactive decision-making.

Developed and deployed machine learning models for business forecasting, demand planning, churn analysis, and risk mitigation, leveraging SQL, Python, Power BI, and cloud-based ML frameworks.

Led the automation of reporting workflows, reducing manual efforts by 60%, improving data accuracy and efficiency using ETL automation, SQL scripting, and Power Query.

Optimized SQL queries for high-performance analytics, improving query execution time by 50%, ensuring fast and reliable business intelligence reporting.

Integrated BI dashboards and analytics solutions into Salesforce, ERP systems, cloud platforms, and web applications, ensuring seamless cross-platform accessibility and real-time data updates.

Implemented advanced security frameworks (OLS/RLS), ensuring role-based access control (RBAC) and compliance with GDPR, HIPAA, and SOC-2 standards.

Designed data warehousing solutions in SQL-based environments (Azure Synapse, Snowflake, Redshift, BigQuery), optimizing data storage, retrieval, and processing efficiency.

Developed SSRS-based paginated reports with interactive filtering, dynamic data visualization, and parameterized datasets for high-volume reporting needs.

Performed exploratory data analysis (EDA) and statistical modeling, using SQL, Python, and R to uncover hidden trends, correlations, and business insights.

Executed A/B testing and hypothesis testing using SQL and statistical techniques, driving data-driven product and business decisions.

Built complex SQL queries to detect anomalies, validate data integrity, and ensure accurate business reporting.

Developed predictive analytics models using SQL-based machine learning tools (BigQuery ML, Azure ML, AWS SageMaker) to support business forecasting and trend analysis.

Led cross-functional collaborations between IT, business strategy, operations, and finance teams to drive data transformation initiatives, streamline decision-making, and enhance reporting accuracy.

Trained analysts, business users, and executives in SQL best practices, BI tools, SSRS reporting, UI/UX principles for BI, data literacy, and self-service analytics, fostering a data-driven culture and increasing BI adoption across the organization.

.

Senior BI Consultant/Data Analyst

Social Security Administration (SSA), Maryland (Mar 2023 – Aug 2023)

Led a team of BI developers and data analysts in designing, developing, and deploying multiple interactive dashboards using Power BI, Tableau, and Looker.

Achieved a 25% increase in operational efficiency by optimizing reporting processes, automating workflows, and reducing manual intervention using SQL, Python, and Power Query.

Spearheaded the creation of an internal BI framework, establishing best practices, governance standards, and data quality controls to enhance BI adoption and efficiency.

Developed real-time monitoring dashboards, integrating SQL-based data pipelines, API connections, and cloud storage solutions, enabling senior leadership to track critical performance metrics with real-time insights.

Automated data extraction and transformation from SQL databases, REST APIs, cloud platforms (Azure, AWS, GCP), and Excel, reducing data refresh times by 50% and improving report accuracy.

Optimized complex SQL queries and stored procedures, improving data processing speed by 40% and enabling faster decision-making across business units.

Designed custom visuals and advanced data storytelling techniques in Power BI, Tableau, and Python, enhancing report accuracy, user engagement, and business insights.

Managed end-to-end BI development projects, from planning and data modeling to dashboard deployment and user training, ensuring timely and high-quality delivery.

Developed advanced DAX calculations and SQL-driven measures, creating dynamic and interactive reports that adjust in real-time based on user selections.

Implemented AI-powered anomaly detection and machine learning-driven insights, enabling proactive risk identification and predictive analytics for business strategy.

Built and optimized ETL processes, ensuring seamless data integration from multiple sources, while maintaining data integrity and governance best practices.

Executed A/B testing, statistical modeling, and regression analysis, leveraging SQL and Python-based analytics techniques to support data-driven decision-making.

Facilitated hands-on training sessions for over 100 employees, increasing organization-wide adoption of BI solutions and self-service analytics capabilities.

Collaborated with cross-functional teams, including IT, finance, operations, and executive leadership, to align data strategies with business objectives and drive digital transformation initiatives.

Business Intelligence Developer/Data Analyst

Verizon, Ashburn, VA (Nov 2020 – Feb 2023)

Developed and deployed interactive Power BI, Tableau, and Looker dashboards, providing real-time insights into sales, marketing, operations, and finance, enabling data-driven decision-making at Verizon.

Optimized ETL processes using SSIS, SQL, and Python, reducing data load times by 40%, enhancing data integration across Verizon’s enterprise systems.

Implemented advanced Row-Level Security (RLS) and Object-Level Security (OLS), ensuring secure access control and compliance with Verizon’s data governance policies.

Designed and executed cloud-based BI solutions leveraging Azure Synapse, Google BigQuery, and AWS Redshift, supporting scalable, real-time analytics and Verizon’s 5G & IoT initiatives.

Developed LookML models in Looker, enabling self-service analytics across Verizon’s business units, enhancing customer insights and operational efficiencies.

Integrated Power BI dashboards into enterprise applications, CRMs (Salesforce, Dynamics 365), and Verizon’s ERP systems, ensuring seamless, real-time data access for key stakeholders.

Created and maintained a centralized data repository, consolidating data across multiple departments (Network Operations, Customer Experience, Finance, Sales & Marketing) to improve cross-functional reporting and strategic decision-making.

Optimized complex SQL queries, stored procedures, and indexing strategies, improving BI report performance by 35%, ensuring efficient data retrieval for high-volume Verizon datasets.

Developed and automated data pipelines, integrating structured and unstructured data from APIs, cloud storage, SQL databases, and IoT device data for advanced analytics and predictive modeling.

Designed and deployed machine learning models for sales forecasting, customer segmentation, fraud detection, and network optimization, leveraging SQL, Python, and Verizon’s cloud ML frameworks.

Executed A/B testing, regression analysis, and statistical modeling, supporting Verizon’s customer retention, marketing strategy, and service optimization initiatives.

Led the development of AI-powered anomaly detection models, identifying network performance issues and fraud risks in real-time.

Established and enforced best practices for BI platform governance, ensuring data consistency, quality, and compliance with industry regulations (GDPR, CCPA, FCC, SOC-2, HIPAA).

Led BI and analytics training programs for Verizon business analysts, executives, and stakeholders, empowering teams to leverage BI tools and develop self-service analytics capabilities.

Collaborated with cross-functional teams, including engineering, finance, operations, and product development, to align Verizon’s BI strategy with business objectives, digital transformation, and customer experience enhancement

Business Intelligence Developer/Data Analyst

Amazon, Baltimore, MD (Aug 2018 – Sep 2020)

Developed real-time Power BI dashboards to track supply chain performance, logistics KPIs, and warehouse operations, enhancing efficiency and operational visibility across Amazon’s fulfillment network.

Designed interactive Tableau reports with data blending, filtering, and advanced calculations, enabling data-driven decision-making in Amazon’s logistics and inventory management teams.

Implemented automated data pipelines using SQL, Python, AWS Glue, and Redshift, reducing manual reporting efforts by 60% and improving data refresh efficiency for large-scale datasets.

Developed role-based security models (RLS/OLS) in Power BI and Tableau, ensuring classified business intelligence data is accessible only to authorized Amazon stakeholders.

Integrated BI dashboards with Amazon’s Warehouse Management System (WMS), Transportation Management System (TMS), and Inventory Control Platforms, improving real-time tracking and operational decision-making.

Created machine learning-driven forecasting models for demand planning, inventory optimization, and supply chain risk management, using AWS SageMaker, SQL, and Python.

Built DAX-driven financial reports to help Amazon’s finance and accounting teams optimize revenue tracking, expense forecasting, and profit margin analysis.

Enhanced ETL pipelines using AWS Redshift, Snowflake, and Amazon S3, implementing incremental and real-time data loading strategies for large-scale logistics and e-commerce datasets.

Developed anomaly detection algorithms to identify supply chain disruptions, fraudulent activities, and inefficiencies in logistics operations, leveraging SQL, Python, and AWS AI/ML services.

Trained over 50 business analysts, supply chain managers, and logistics teams on BI tools, data visualization best practices, and Amazon’s data governance policies.

Built executive dashboards for Amazon’s senior leadership, providing real-time operational insights on fulfillment center performance, order processing efficiency, and last-mile delivery optimization.

Optimized SQL queries and indexing strategies to enhance the performance of complex BI reports, reducing query execution time by 40% and supporting high-volume data processing.

Led cross-functional collaborations with Amazon’s supply chain, finance, logistics, and data science teams, ensuring BI solutions align with business objectives and operational efficiency goals.

Established and enforced best practices for BI governance, ensuring data integrity, compliance with AWS security standards, and adherence to Amazon’s global reporting policies.

Business Intelligence Developer/Data Analyst

St. Jude Medical Center, Baltimore, MD (Oct 2016 – June 2018)

Developed Power BI dashboards to track patient care performance, hospital efficiency, and operational effectiveness, providing real-time insights for clinical and administrative leadership.

Designed and implemented Tableau dashboards to analyze hospital quality measures, regulatory compliance (CMS, Joint Commission), and patient outcomes, improving decision-making in patient care.

Automated reporting workflows using SQL, Python, and Power Query, reducing manual data processing by 50%, enhancing report accuracy and efficiency.

Integrated BI tools with St. Jude’s hospital data systems, including Epic Caboodle, Clarity, Cerner, and other EHR platforms, ensuring real-time data access and streamlined clinical operations.

Created AI-driven predictive models to assess patient readmission risks, identify operational inefficiencies, and improve care delivery, leveraging machine learning (Python, TensorFlow, Azure ML).

Designed and enforced role-based access models (RLS/OLS) to ensure HIPAA compliance, data security, and controlled access to sensitive healthcare data.

Developed financial analytics dashboards for budgeting, resource allocation, and revenue cycle optimization, supporting cost-effective decision-making in hospital management.

Optimized SQL queries and indexing strategies, improving reporting efficiency and database performance, enabling faster access to critical healthcare insights.

Led training programs for clinical and administrative staff, empowering teams to utilize BI tools for data-driven decision-making and patient outcome improvements.

Enhanced data governance policies by implementing data validation, anomaly detection, and automated data quality checks, ensuring accuracy, consistency, and compliance.

Developed interactive dashboards to monitor patient experience metrics, staff productivity, and emergency department (ED) throughput, supporting continuous hospital performance improvement.

Collaborated with cross-functional teams, including physicians, nurses, finance, IT, and operations, to align BI solutions with patient care objectives and hospital strategic initiatives.

Implemented machine learning-driven anomaly detection systems to identify potential fraud, billing errors, and compliance risks, ensuring regulatory adherence and financial accuracy.

Established best practices for BI governance and self-service analytics, enabling departmental leaders to make data-driven decisions while maintaining security and compliance.

EDUCATION & CERTIFICATIONS

•B.Sc. Information Management – AAUA, 2010

•Certified Information Systems Auditor (CISA) – 2023

•Level 2 Health, Safety & Environment – Chartered Institute of Environmental Health, UK

CLEARANCE

•Public Trust

Contact this candidate