Data Analyst

MICHAEL O. OMIDIRAN

Houston, TX • 832-***-**** • *******.*****@*****.***

Data Analyst BI Developer Data Management Specialist

PROFESSIONAL SUMMARY

Data Analyst with deep expertise in SQL, Power BI, Python, ETL pipelines, and enterprise data systems. Proven ability to transform complex datasets into actionable insights, automate reporting workflows, and build scalable dashboards that drive strategic decisionmaking. Strong background in data governance, database management, and crossfunctional project leadership across energy, government, and consulting environments.

CORE SKILLS

Data Analytics & BI: Power BI, DAX, M-Code, Python, Power Query, Power Pivot, Data Modeling, KPI Development

Databases & ETL: SQL Server, Oracle, SAP BW/BI, ETL Pipelines, Data Mapping

Tools & Platforms: Azure Cloud, SharePoint, Alere ERP, DocuXplorer, APIs

Project & Process: Agile, Jira, Asana, Data Governance, UAT, Documentation

Other: MS Excel (Advanced), Primavera P6, MS Project

PROFESSIONAL EXPERIENCE

Financial Data Solutions Specialist Creative Financial Staffing 07/25 – Present

DCCM, Houston, TX

oAutomated recurring reports using Power Query and PivotTables, reducing manual data prep time from several hours to under 30 minutes per cycle.

oDeveloped a scalable Power Query-driven ETL framework to consolidate 88 Excel data sources into a unified semantic model, enabling downstream Power BI reporting and reducing data entry defects by 40%.

oBuilt interactive PivotTable dashboards that improved visibility into KPIs across multiple business units, accelerating leadership reporting by 25–30%.

oStandardized spreadsheet templates and transformation steps, improving data consistency across teams by 35%.

oStreamlined project tracking and reporting workflows, reducing update time for project managers by 50%.

oIntroduced automated data cleaning logic in Power Query that eliminated recurring formatting issues and projected to save 8–10 hours per month.

Alpha Measurement Inc., Houston, TX

oBuilt a centralized tariff database consolidating import/export records, duty payments, and cost data from 2021 onward.

oExtracted, reconciled, and validated financial data from Alere ERP, Excel, and DocuXplorer to support U.S. Customs drawback claims.

oConducted forensic analysis of import documentation to identify eligible recoverable tariff costs.

oMapped export destinations and productlevel data to optimize drawback recovery opportunities.

oCoordinated with accounting and compliance teams to ensure alignment with U.S. Customs requirements.

Data Analytics/Business Intelligence ERIF Consulting Inc., Mississauga 09/2020 – 01/2025

Suncor Energy

oSupported deployment of a cloudbased SQL Server DBaaS environment with Power BI as the reporting layer.

oDeveloped advanced DAX measures and Python models for timeintelligence analytics (YTD, QTD, MTD, YoY) and sales forecasting.

oBuilt automated ETL workflows using Power Query and SQL to integrate data from Flatfiles, Excel, Azure, APIs, and SharePoint.

oDesigned interactive Power BI dashboards that revealed customer trends and improved forecasting accuracy.

oCreated a data governance framework ensuring compliance with privacy and protection standards.

Husky Energy -

oExecuted SAP BW ETL processes to extract and transform data from Oracle sources.

oConfigured InfoObjects/InfoProviders and built BEx queries for enterprise reporting.

oDesigned KPI dashboards for operational and financial stakeholders.

oManaged metadata, archiving, backup, and system performance optimization.

SAP BW/BI Analyst

Shell Petroleum Development Company, The Hague, NL 06/2004 – 09/2020

oImplemented enterprisewide SAP BW systems enabling datadriven decisionmaking across business units.

oBuilt automated ETL processes and performed QA/QC for monthend reporting.

oDeveloped interactive dashboards using SAP BEx Explorer for performance monitoring and operational insights.

oCollaborated with E&P teams to resolve BI issues and enhance data reliability.

oLed data governance initiatives and optimized data warehouse performance.

oDelivered UAT, GoLive support, and staff training.

Technical Support Analyst

U.S. Department of the Interior, Washington, D.C. 11/1995 – 06/2002

oMigrated environmental datasets into a normalized MS Access RDBMS and built SQL queries and Crystal Reports for analysis.

oDeployed a nationwide ColdFusionbased PMIS for unified budget data processing.

oManaged IT infrastructure upgrades, consistently delivering projects ahead of schedule and under budget.

oUsed MS Project to optimize schedules, resource allocation, and risk mitigation, improving project delivery efficiency by 20–30%.

EDUCATION

oPost Graduate Certificate, Legal Studies (Hons) – Adelphi University

oB.Sc. Geology (Hons), Minors in Mathematics & Computer Science – Univ. of Ife

CERTIFICATIONS

oMicrosoft Power BI Data Analyst Professional Certificate

oGoogle Project Management Certificate

oCertified SAP BW/BI Consultant

oCertified Oracle 8i Database Administrator

Contact this candidate