Business Intelligence Power Bi

Razak Yusuf

T*H*C* Calgary, Canada 368-***-****

**********@*****.*** linkedin.com/in/rasak-yusuf

PROFILE SUMMARY

Experienced Business Intelligence Analyst with a strong background in data-driven industries. Skilled in managing BI projects, modernizing legacy systems, and improving data quality to drive business insights. Proficient in designing and deploying interactive dashboards and reports, enabling informed decision- making. Expertise in data migration, consolidation, and process optimization, delivering measurable business improvements, seeking to apply my analytical and project management skills to develop impactful BI solutions and support data-driven strategies.

SKILLS

T-SQL, Power BI, Excel PowerPivot, Tableau, SSIS, SSAS, SSRS, Python, DAX, Power Query KEY PROJECTS

• Legacy Database Migration: Successfully migrated Conoil Plc.’s Supply Chain Management System and related data sources to an on-premises SQL Server, optimizing query performance, data availability, and system scalability.

• Dashboard Training: Delivered comprehensive Power BI dashboard design and development training to business clients.

• Service Analytics Migration: Executed the migration of service analytic databases from MicroStrategy to the Microsoft BI Platform, optimizing data accessibility. PROFESSIONAL EXPERIENCE

Business Intelligence Consultant – Arap Technology Inc, Calgary, Canada Sept 2024 – Present Project: Migration of Service Analytic Databases from Micro Strategy to Microsoft BI Platform

• Analysed and reviewed Micro Strategy analytic databases, cubes, and reports to produce enhanced and cost-saving Microsoft analytic databases using Microsoft Business Intelligence and SharePoint platforms

• Design and implement ETL pipelines using SSIS and Azure Data Factory, reducing data processing time by 40%.

• Establish data validation and cleansing workflows, enhancing data accuracy by 30% through proactive anomaly detection.

• Partner with Data Governance teams to develop data quality standards, leading to a 25% reduction in data inconsistencies.

• Achieve accurate data analysis as measured by insights provided to business stakeholders by analyzing and interpreting complex data sets.

• Delivered well-defined data context as measured by business understanding and decision-making improvements by refining data models and processes.

• Educated cross-functional teams as measured by enhanced data literacy across the organization by providing data-driven workshops and training sessions.

• Collaborated with business teams to improve data models, increasing query performance by 50% in Power BI dashboards.

Data Analyst - EECOL Electric, Calgary Jun 2024 – Aug 2024

• Developed comprehensive project plans, cost estimates, and status reports, ensuring clear communication with stakeholders.

• Conducted requirements gathering and workshops to define project scope and objectives.

• Created and configured staging and production databases on SQL Server 2008, enhancing data integration processes.

• Conducted training for Business users on the use of the dashboards

• Integrated diverse datasets into Power BI to build comprehensive dashboards, minimizing data silos and improving operational reporting.

• Utilized SQL scripts to query and prepare large datasets for analysis, optimizing query performance to improve data processing efficiency by 25%.

Business Intelligence Developer – Conoil Plc, Lagos, Nigeria Aug 2018 – Sept 2023 Project: Legacy Database Migration

• Participated in requirements gathering and brainstorming sessions

• Analysed, reviewed, re-designed, and implemented the OLTP Database Logical and Physical Data models to conform to requirements specification

• Analysed, designed, and developed Source to Target Mapping, Transformation, and Data Quality documentation

• Wrote SSIS packages and T-SQL scripts to Extract, Transform, and Load (ETL) data from Excel into staging database, from staging database into EHS data mart based on the design approach using Sql server database and data tools

• Designed and implemented a Data Warehouse using Ralph Kimball’s approach, improving data management and analysis.

• Analysed and designed EHS Data Warehouse using Star Schema Dimensional Modelling Approach

• Designed, developed, and deployed reports and KPI, Cube, and Measures using SSRS, SSAS, Power BI, Excel Power Pivot, DAX, T-SQL, and SharePoint

• Designed and deployed SSAS Cubes and implemented SCD Type 1 and 2, improving data accuracy and reporting efficiency.

• Produced and maintained detailed user and technical documentation, providing training and support to end- users.

• Wrote optimized SQL queries, and data extraction scripts across multiple data sources (CSV, Excel, SQL Server backup)

• Design, developed, tested, and deployed Multidimensional EDW Analytic Service Cubes using SSAS, MDX, T-SQL

EDUCATION

Master of Science in Management

Bayero University, Nigeria (Certified by WES) 2021 Bachelor of Science in Business Administration

University of Ilorin, Nigeria 2006

Certificates In Information Technology Fundamentals Southern Alberta Institute of Technology (SAIT) 2024 CERTIFICATIONS

Microsoft Certified: Power BI Data Analyst Associate 2024 Project Management Professional (PMP) 2024

Contact this candidate