Data Engineer Power Bi

ADEOLA ONI

**** * *********** ******, ********* *, Champaign, Illinois, 61821

Phone: +1-780-***-**** Email: *********@*****.*** LinkedIn: linkedin.com/in/adeola-oni

SSIS/ETL ENGINEER

BI SSIS Developer ETL Developer Data Warehouse Specialist Cloud Data Solutions Azure Certified

PROFESSIONAL SUMMARY

Experienced and certified Data Engineer with over 7 years of experience in designing scalable ETL pipelines, data modeling, and delivering analytics-ready datasets across diverse industries, including finance, healthcare, and manufacturing. Proven expertise in Python, SQL, SSIS, and Azure technologies, with a strong focus on data quality, governance, and stakeholder collaboration. Adept at delivering measurable results, such as a 40% improvement in data processing speed and 99.6% pipeline uptime, while aligning with business goals and compliance standards.

TECHNICAL SKILLS

ETL/BI Tools: Azure Data Factory (ADF), SSIS, Power BI, MS Fabric

Cloud Platforms: Azure Synapse Analytics, Microsoft Fabric, Snowflake, Databricks

Data Modelling: Star Schema, Fact/Dimension Tables, Data Governance, Metadata Management

Languages: SQL, T-SQL, Python, PowerShell, C#

DevOps & Agile: Azure DevOps (CI/CD), Git, YAML Pipelines, Scrum

PROFESSIONAL EXPERIENCE

CGI, Edmonton, AB April 2022 – Present

Senior SSIS / ETL Engineer

Tools: Azure Data Factory, Snowflake, SSIS, SAP HANA, SQL Server, Power BI, Python, Agile

Project: SAP ERP Data Migration (Sphere Project)

Led migration of 8+ financial data domains using SSIS and Python, reducing manual effort by 40% and ensuring 99.9% accuracy across 500K+ records weekly.

Engineered 100+ SSIS pipelines with automated validation scripts, achieving 95% test coverage within 2 months.

Designed normalized and star schema models for data warehousing, enhancing reporting performance by 45%.

Reduced ETL load time by 30% via reusable PowerShell components and parameterized configurations.

Ensured compliance with data governance policies through validation rules, achieving 98% data quality threshold.

Project: MERA – Modernization Enhancement Regulatory Applications

Modernized legacy ETL with SQL and SSIS, reducing query run time by 35% and transformation time by 25%.

Designed scalable data models and implemented indexing strategies, improving cloud readiness by 20%.

Delivered cross-functional collaboration with 3 teams, achieving milestone deliverables 1 week ahead of schedule.

Applied data validation logic to enforce governance, reducing anomalies by 30%.

Optimized pipeline runtime by 20% through parallelization and incremental load strategies.

Project: Liquor Warehouse Enhancement

Built SSIS pipelines to handle 1M+ daily transactions, achieving 99.6% uptime and zero data loss incidents.

Designed dimensional models with fact and slowly changing dimension (SCD) tables, improving reporting by 50%.

Integrated Informatica APIs for standardized data ingestion, ensuring 100% consistency across systems.

Applied data profiling techniques and cleansing routines using Python, reducing rejection rate by 35%.

Delivered change data capture (CDC) logic, enabling real-time updates for downstream analytics.

Achieved 30% reduction in development time using prebuilt C# transformation libraries.

Pagnotta Inc., Edmonton, AB Feb 2022 – May 2022

ETL Developer

Built SSIS workflows to migrate 1.5M+ records per week, maintaining 0% data loss and 99.9% accuracy.

Conducted data cleansing and profiling across 12 source systems, ensuring 100% compliance with business rules.

Modeled and implemented Star Schema, improving report load times by 40%.

Collaborated with 4+ stakeholders during agile sprints to deliver actionable insights 2 weeks ahead of deadline.

Arap Technologies, Remote Jan 2019 – Feb 2022

Business Intelligence Architect

Delivered 22 SSAS cubes and 100+ calculated measures, accelerating analytics delivery by 40% for 6 departments.

Developed 28 dashboards and 126 Power BI/SSRS reports, improving executive visibility by 60% within 4 months.

Built and maintained 200+ version-controlled SQL and SSIS artifacts in TFS, reducing rework by 35%.

Automated 8 high-impact ETL workflows, reducing manual processing by 50% in under 6 months.

Designed Snowflake-based data pipelines with Python and SQL, reducing data refresh time by 40%.

Maintained 99.9% data accuracy through rigorous data profiling and governance enforcement.

Zenith Bank Plc June 2012– Jan 2019

Business Intelligence Analyst

Tools: SQL Server, Tableau, Power BI, SSIS

Designed and deployed 10+ SSIS workflows processing 5M+ monthly records with 99% success rate.

Implemented SQL Server Agent jobs for ETL scheduling, ensuring 99% SLA compliance over 24/7 operations.

Modeled 12+ analytical schemas, improving data query performance by 60% and reducing reporting lags.

Delivered 20+ Tableau and Power BI dashboards used by 6+ departments for decision-making.

Led production support for 10+ executives, resolving critical issues with 95% SLA adherence.

Applied ETL best practices and error handling, reducing data reprocessing by 25%.

.

EDUCATION

Ladoke Akintola University of Technology

Bachelor of Technology in Chemical Engineering

CERTIFICATIONS

Microsoft Azure Data Engineer Associate (DP-203) — 2024

Microsoft AI Fundamentals (AI-900) — 2023

Microsoft Azure Fundamentals (AZ-900) — 2022

Microsoft Azure Data Fundamentals (DP-900) — 2022

Google Data Analytics Professional Certificate — 2021

Google IT Support Professional Certificate — 2020

ITIL v4 Foundation Certificate — 2019

Contact this candidate