Summary
Overview
Work History
Education
Skills
Languages
Certification
Microscoft Power BI Certification
Timeline
Generic

EMEKA DANIEL

Calgary,Canada

Summary

Business Intelligence Developer with 8+ years of experience in Business Analysis, Data Modelling, Data Warehousing, Database Development, Data Analysis, Data Migration, Data Reporting and Visualization. 8+ years in-depth experience in using Microsoft BI development tools (SSIS, SSAS, SSRS and Power BI), Data Visualization, Dashboard design and Development using Tableau and Power BI (Experience with advanced Power BI concepts such as Power ON, Paginated Reports, PBRS), etc. 8+ years In-depth experience in Business Intelligence, ETL process, Data architecture, Reporting Analysis with a proven record of improving organizational efficiency and productivity. Experience with Microsoft Fabric. Experience with Alteryx- Data integration, extraction, cleansing and conversion. In-depth knowledge and experience in Database design, Relational, Dimensional. A dedicated and Detail-oriented team player committed to achieving set out objectives of stakeholders. Exceptional presentation, verbal, and written communication skills. Demonstrated strong ability to meeting and quickly finding solutions to new technical challenges.

Overview

8
8
years of professional experience
1
1
Certification

Work History

Senior Business Intelligence Developer

Transmountain
03.2023 - Current
  • Work with Microsoft Fabric environment and stacks
  • Query databases with SQL to extract data for analysis.
  • Writing complex SQL scripts to transform and extract data from database to meet stakeholders requirements.
  • Work with Alteryx to transform data and to produce extracts for Reporting.
  • Involve in gathering requirement from business users on what is needed to either enhance an existing PowerBI report or creating a new one.
  • Ensure effective communication amongst stakeholders and ensuring proper and timely delivery of projects.
  • Ensure proper delivery through product lifecycle- Requirements/Plan/ Design/Develop/ Development/ Testing/Release/ Maintenance
  • Extensive DAX knowledge
  • Managing DevOps task boards, triaging tasks, incidents and bugs
  • Create Dataflows and Datasets from the Datasets for Reporting, as requested for other PowerBI developers.
  • Create automated PowerBI Dashboards from available data to help business users to make informed decisions.
  • Analyse complex business data to give insight to business in making very informed decision
  • Use of power platform like power App and Power Automate to automate reports and processes.
  • Master Data management and administration.
  • Data access, involved in access peice. Managing the process of access management. Giving access to reports and dashboards to individual in the organization.
  • PowerBI Administration, the management of the workspaces and PowerBI App to share reports and dashboards. Also creating and managing PowerBI App.
  • PowerBI support, help other developers to achieve set objectives in reporting and analytics.
  • Provide daily support and maintenance of PowerBI reports, dashboards, datasets and dataflows, Power automate, Power Apps.
  • Collaborate with the whole Data team to solve problems and enhance processes and documentation
  • Data Modeling and Analysis: Designing data models and relationships in Power BI to ensure efficient data retrieval and analysis. Creating DAX formulas to calculate and summarize data for visualizations.
  • Report and Dashboard Development: Creating interactive and visually appealing reports and dashboards in Power BI that provide actionable insights to stakeholders.
  • DAX Formulas and Calculations: Developing complex DAX formulas to perform calculations, aggregations, time intelligence, and other data manipulations within Power BI.
  • Data Integration: Extracting, transforming, and loading data from various sources into Power BI, including databases, spreadsheets, cloud services, and APIs.
  • Performance Optimization: Optimizing Power BI reports and DAX calculations for improved performance and faster query response times.
  • Data Visualization: Select appropriate visualizations (e.g., charts, tables, maps, KPIs) to represent data effectively and enable users to gain insights quickly.
  • Data Security and Governance: Implementing data security measures within Power BI to ensure that sensitive information is accessible only to authorized users. Adhering to data governance policies and regulations.
  • Data Quality and Validation: Ensuring the accuracy and integrity of data by validating and cleansing data during the integration process.
  • Collaboration and Documentation: Collaborating with business stakeholders, data analysts, and other team members to understand requirements and deliver effective solutions. Documenting data models, DAX formulas, and development processes for future reference and knowledge sharing.
  • Troubleshooting and Issue Resolution: Identifying and resolving issues related to data connections, DAX calculations, and report performance.
  • Ability to provide excellent customer support, meticulous quality of work, and work product

Business Intelligence Developer

Novartis
12.2020 - 02.2023
  • Design, develop, implement and maintain business intelligence solutions for client’s projects
  • Participate in requirement gathering and stakeholders brainstorming sessions.
  • Analyse, review, redesign and implement OLTP Database Logical and Physical Data models using SQL Server Database tools to conform to requirements specification.
  • Analyse, design and implement Data Warehouse using Ralph Kimball Dimensional Modelling Approach.
  • Design and produce conceptual and logical diagram, entity-relationship diagram, data flow diagram, process flow diagram using SSMS diagram and oracle data modeller.
  • Produce technologies versus requirements matrix to determine the appropriate technologies and tools for the realization of Project based on users’ requirements and implementation constraints
  • Analyse, design and create de-normalised dimension tables, fact tables and entity- relationship using SQL Server Database Diagram and Star and Snow Flake Schema Dimensional Modeling approach
  • Design SSIS packages to extract, transform and load data (ETL) from CSV files and SSMS DB to Staging and Production SQL Server Databases using OLE DB and Flat file connection managers, For each container, Fuzzy Lookup, Lookup, Merge Join, data flow tasks, File System task, Merge, Conversion and Derived Column
  • Develop, test and deploy Multidimensional Analytic Databases, KPI, calculated measures and dimensions using Microsoft SSAS, MDX, T-SQL
  • Develop, design and deploy complex and enhanced Dashboards and Reports using Microsoft SSRS, SSAS, Tableau, Power BI, Excel 2013, Power Pivot, T-SQL
  • Design and Implement Ralph Kimball Methodologies slowly changing dimension (SCD) Type 1 and 2 using SSIS data flow transformation
  • Create SQL Objects (Tables, Views, Store Procedures, triggers, functions and indexes) using T-SQL scripting and PL/SQL scripting

Business Intelligence Developer

Sanofi
07.2018 - 09.2020
  • Contributed towards the implementation of sales report analysis and dashboards.
  • Liaised with stakeholders in the Sales and Business Operations and Support to identify relevant KPI and data sources (SQL Server, Excel, Google sheet, OData, and CSV)
  • Collaborated with team and other stakeholders to identify source to target Mapping, data extraction and transformation towards project implementation
  • Designed, developed and demonstrated visual modelling and working prototype of sites, dashboards and data visualization using Tableau to management team and stakeholders to ensure the requirements are fully understood and captured
  • Designed, developed and deployed Reports and Dashboards using SSRS, Tableau, Power BI, Excel 2010 Power Pivot, DAX, T-SQL
  • Produced standardised data visualization templates, design patterns and best practices for the development team
  • Provided support to Business users on the use of the dashboards

Business Intelligence Developer

Heritage Bank
01.2017 - 05.2018
  • Participated in requirements gathering, workshop and brainstorming sessions
  • Analysed, designed and implemented Data Warehouse from Conceptual Stage to Production Stage using RALPH KIMBALL Design Approach
  • Designed and produced Dimension and Conformed Dimension tables based on Enterprise Data Warehouse Bus Matrix with SCD Type 1 and 2 and Fact tables using Star and Snow Flake Schema Dimensional Modeling
  • Wrote SSIS packages and T-SQL scripts to extract, transform and load data from Excel, CSV files, Access database to OLTP database or Data Warehouse staging and production databases using connection managers like OLEDB, Excel, Flat file and ADO.NET
  • Created SQL Objects (Tables, Views, Store Procedures, triggers, functions and indexes) and T-SQL scripting
  • Analysed, designed, developed and ensured Source to Target Mapping, Transformation and Data Quality
  • Designed, developed and deployed Reports and Dashboards (for Executive, Employee, Manager), KPI, Cube and Measures using SSRS, SSAS, Power BI, Tableau, DAX, T-SQL
  • Designed, developed and deployed Multidimensional Cubes using SSAS

Education

Bachelor of Science (BSc) - Engineering

Nnamdi Azikiwe University
Awka, Anambra State

Hands on Data Analytics, Business Intelligence and Reporting - undefined

NIIT

Hands on Business intelligence, Data Analytics and Reporting - undefined

Arap Technologies Inc

Master of Science - Computer Science

Nnamdi Azikiwe University Awka
Nigeria
08-2021

Skills

  • RDBMS proficiency in Azure and SQL Server
  • BI/Data Model Tools: SSIS, SSAS, SSRS, Excel PowerPivot, SQL Server Management Studio, SQL Server Data Tools, PgAdmin 4, Tabular Model, Multi-Dimensional Model
  • Data Visualization Tools: Fabric(Power BI), Tableau,Power platform (Power Automate and PowerApps)
  • Data Preparation Tools: Alteryx - Data integration, extraction, cleansing and conversion
  • Database programming expertise
  • Business Model, Analysis and Design Tools: Microsoft Vision and Microsoft Project
  • Operating Systems: Window Operating Systems
  • ETL development
  • Data monitoring
  • SQL expertise
  • Business analysis
  • Data migration
  • Data transformation
  • Data mapping
  • Data governance
  • Requirements gathering
  • API integration
  • Dashboard design
  • Data modeling
  • Performance tuning
  • Big data analytics
  • Data cataloging
  • Data integration
  • Problem-solving
  • Time management
  • Decision-making
  • Team building
  • GitHub collaboration

Languages

English
Full Professional

Certification

PL300 Microsoft Power BI Certification


Microsoft Fabric

Microscoft Power BI Certification

Demonstrate methods and best practices that align with business and technical requirements for modeling, visualization and analyzing data with Microsoft Power BI 

To be subject matter expertise in designing, creating, and deploying enterprise-scale data analytics solutions.

Timeline

Senior Business Intelligence Developer

Transmountain
03.2023 - Current

Business Intelligence Developer

Novartis
12.2020 - 02.2023

Business Intelligence Developer

Sanofi
07.2018 - 09.2020

Business Intelligence Developer

Heritage Bank
01.2017 - 05.2018

Hands on Data Analytics, Business Intelligence and Reporting - undefined

NIIT

Hands on Business intelligence, Data Analytics and Reporting - undefined

Arap Technologies Inc

Bachelor of Science (BSc) - Engineering

Nnamdi Azikiwe University

Master of Science - Computer Science

Nnamdi Azikiwe University Awka

Similar Profiles

  • Liza Garcia

    Liza GarciaLiza Garcia

    Medical Assistant / Front Office Coordinator at Transmountain Primary CareMedical Assistant / Front Office Coordinator at Transmountain Primary Care

  • Cristina Sharp

    Cristina SharpCristina Sharp

    Professor, Teacher Preparation/Child Development at El Paso Community College, Transmountain CampusProfessor, Teacher Preparation/Child Development at El Paso Community College, Transmountain Campus

  • Pamela Apodaca

    Pamela ApodacaPamela Apodaca

    Registered Nurse/Charge Nurse Emergency Room at The Hospitals of Providence-East-Sierra-Transmountain CampusRegistered Nurse/Charge Nurse Emergency Room at The Hospitals of Providence-East-Sierra-Transmountain Campus

  • JULIE LANGLOIS

    JULIE LANGLOISJULIE LANGLOIS

    MEDICAL OFFICE ASSISTANT at West Springs MedicalMEDICAL OFFICE ASSISTANT at West Springs Medical

  • ANNA ZANELA

    ANNA ZANELAANNA ZANELA

    Accountant (Audit & Financial Reporting) at CML PropertiesAccountant (Audit & Financial Reporting) at CML Properties

CREATE PROFILE
EMEKA DANIEL