Business Intelligence Supply Chain

Olabanji Arowolo

Somerset, New Jersey

*****************@*****.*** 732-***-****

Professional Summary

Business Intelligence Analyst with 5+ years of experience supporting day-to-day business operations, ETL development, and analytics reporting across pharmaceutical organizations. Expert in designing and maintaining data pipelines, integrating clinical and commercial data sources, and delivering self-service Power BI dashboards to drive informed decision-making. Proven ability to support business users across operations, supply chain, finance, and sales with actionable insights for strategic and tactical decisions.

Core Competencies

- Operational Analytics & Reporting

- ETL Design & Maintenance (SQL, Power Query)

- Power BI (DAX, Data Modeling, Dataflows)

- Data Warehouse Support (PostgreSQL, T-SQL)

- Master Data & Data Quality Governance

- KPI Monitoring & Business Process Optimization

- Pharmaceutical Commercial & Clinical Operations

- Cross-Functional Collaboration (Sales Ops, Medical Affairs, Supply Chain)

Professional Experience

Business Intelligence Analyst – Pfizer Inc.

Remote Feb 2022 – Dec 2024

Designed and managed daily ETL workflows using SQL to ingest, clean, and transform commercial and operational datasets across multiple systems.

Created Power BI dashboards to monitor inventory, supply chain logistics, and order fulfillment, helping stakeholders react to bottlenecks in real time.

Built daily sales performance reports, allowing business leaders to track product demand and promotional impact across therapeutic areas.

Partnered with IT and business units to align data models with evolving business needs, reducing report change requests by 40%.

Automated reporting processes for business stakeholders, cutting manual spreadsheet work by over 20 hours per week.

• Performed root-cause analysis on data quality issues in internal datasets, contributing to a 30% improvement in reporting accuracy.

Business Intelligence Analyst – Bristol Myers Squibb

Remote Jan 2019 – Dec 2021

Supported day-to-day analytics and reporting needs for operations, finance, and sales enablement teams using Power BI and SQL-based datasets.

Developed and maintained robust ETL processes to consolidate data from SAP, Salesforce, and external vendors for unified reporting.

Delivered interactive dashboards to track product distribution, sales targets, and vendor performance, improving team visibility and accountability.

Worked with operations leadership to develop KPI monitoring systems for manufacturing throughput, cycle time, and deviation management.

Provided ongoing data support to cross-functional users, enabling data-driven business reviews and planning discussions.

Documented and optimized existing SQL queries, reducing load times and improving scalability across BI reports.

Education

B.A. in International Law and Diplomacy

Babcock University – 2015

Certifications

- Microsoft Certified: Power BI Data Analyst Associate (2023)

- SQL for Data Analysis – Coursera

- Business Intelligence for Operations – FutureLearn

Selected Projects

Operations Performance Dashboard – Built an end-to-end BI solution to monitor manufacturing cycle times and inventory turnover, directly impacting procurement planning decisions.

Integrated Sales & Forecast ETL Pipeline – Designed a SQL-based ETL system to merge Salesforce and SAP data, enabling unified product performance analysis across geographies.

Business Health Metrics Portal – Developed a centralized dashboard for senior leadership to track real-time KPIs across departments—finance, sales, and supply chain.

Contact this candidate