Ade Adeniyi
Calgary,Canada
Summary
An experienced IT professional skilled in bridging the gap between technical and business domains, proficiently analyzing and suggesting improvements to processes, systems, and applications. Capable of evaluating technology solutions, translating business needs into technical specifications, and facilitating user adoption and training.
Overview
7
7
years of professional experience
Work History
Technical Business Analyst
United way of Calgary and Area
05.2022 - Current
- I utilize Power BI to craft dynamic dashboards and reports, enabling stakeholders to visualize crucial performance metrics and derive actionable insights
- This involves designing interactive visuals using Power BI Desktop and Service, implementing ETL processes, and leveraging DAX for intricate calculations
- Additionally, I optimize performance and provide training to ensure effective adoption of Power BI solutions
- I develop custom Canvas Apps, Model-Driven Apps, and portals using Microsoft Power Apps to automate business processes and improve operational efficiency
- These apps were integrated with other Microsoft services such as SharePoint, Office 365, and Dynamics 365 to enhance functionality and data flow
- I focus on designing user-friendly interfaces and optimizing user experiences through responsive design principles
- I design and implement automated workflows with Microsoft Power Automate, integrating with Microsoft 365 apps and external services
- This includes creating UI Flows and Logic Flows to automate tasks and manage complex processes
- I prioritize reliability by implementing error handling mechanisms and offer training and support to ensure user adoption
- I employ Azure Data Factory for seamless integration of diverse data sources, transforming and loading them into specified destinations like data lakes and warehouses
- This includes crafting sophisticated ETL workflows, applying transformations, and managing data transformation tasks for analytical readiness
- Additionally, I specialize in SQL optimization for enhanced performance and reliable data processing
Business Intelligence Developer
Open Planet Technologies
02.2021 - 04.2022
- Company Overview: Calgary, Canada
- Developing high-level test matrix based on business requirements, functions, and technical specifications for assigned projects/applications
- Developing compelling and interactive analysis reports and dashboards for analytics using advanced DAX and Power Query
- Utilizing Power BI (Power View) to create various analytical dashboards that depict critical KPIs along with slicers and dicers to enable end-user to make filters
- Utilizing Power BI gateway to keep dashboards and reports up-to-date with on-premise data sources
- Implementation and delivery of MSBI platform solutions to develop and deploy ETL analysis and reporting on SQL Server using SSAS, SSIS, and SSRS
- Created and supported various SSAS cubes to calculate complex Measures and support reporting solutions
- Defined and specified package and project parameters, environment variables for the deployment of SSIS packages to Integration Service Catalogue
- Provided data warehouse development strategies, BI architecture, and data modelling
- Performed data profiling and linage to ensure the suitability of data for business requirements
- Calgary, Canada
Power BI Developer (remote)
Ikeja Electric
10.2018 - 02.2021
- Project: Design and implementation of a centralized digital public complaint and queries resolution tracker
- Created a company-wide Complaint Resolution Power-BI dashboard to monitor customer complaint resolution
- This is used to ensure compliance to SLA and track both the Company’s performance as well as the performance of individual stakeholders involved in the complaint resolution lifecycle
- Designed and developed an Email Escalation Tracker which assists CCRs to provide prompt responses to customer queries via the email channel, within 24 hours of resolution by 2nd level personnel
- Collaborated in the development a Metering Efficiency dashboard to track the effectiveness of the Metering Partners in a bid to ensure customer satisfaction
- Used Power Query to acquire data and Power BI desktop for designing rich visuals
- Created a VALID PHONE CHECKER BI-report that extracted the contact information of all customers on the CIS Database from several columns for Analysis, Data cleaning/Transformation
- This is used to ensure SMS campaigns to all customers with valid phone and email details on the database
- Created various visualizations like waterfall, funnel, matrix visualization, scatter plots, combo charts, gauges, cards and KPI
- Built metric reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards with Power BI service
- Provided feedback on specific data requests to the regulators within stipulated timelines to avoid regulatory sanctions
- Worked with business stakeholders, application developers and production teams across functional units to identify business needs and discuss solution options
- Worked with cross-functional teams to structure problems, identify appropriate data sources, extract data and develop integrated information delivery solutions
- Participated and provided technical leadership in all phases of BI projects: from discovery and planning through implementation and delivery
Business Intelligence Analyst
Guesttek Interactive Entertainment Ltd
09.2017 - 05.2018
- Company Overview: Canada
- Utilised data modelling techniques in identifying, extracting, and analysing business data then provided the result using data visualization and reporting tools (Tableau, SSRS, and Power BI)
- Designed and produced Dimension and Conformed Dimension tables based on Intermediaries Data Capturing (IDC) Data Warehouse Bus Matrix with SCD Type 1 and 2 and Fact tables using Star and Snowflake Schema Dimensional Modelling approach
- Created queries using T/SQL to support ad hoc requests for data and reports that integrate a full view of the business need into actionable information
- Analysed and produced Source to Target Mapping, Transformation and Data Quality documentation for projects
- Designed and implemented Conceptual, Logical and Physical Data models using SQL Server Database Diagrams, also created the entity-relationship diagram, data flow diagram, process flow diagram using SSMS diagram
- Produced technologies versus requirements matrix to determine the appropriate technologies and tools for the realization of Project based on users’ requirements and implementation constraints
- Elicited business requirements and technical specifications, participated in requirements gathering sessions for new and enhanced Dashboards and Reports with development teams, project managers and business users
- Create SQL Objects (Tables, Views, Stored Procedures, triggers, functions and indexes) using MSQL scripting, and SQL database administration
- Canada
Education
PGD - Infrastructure Analysis
Southern Alberta Institute of Technology (SAIT)
01.2017
BSc - Finance
University of Ilorin
01.2000
Skills
- Power BI (Desktop, Service)
- Data Visualization
- Data Modeling
- DAX (Data Analysis Expressions)
- Data Analysis
- Dashboard Design
- Report Development
- SharePoint
- Microsoft Azure Data Factory
- SQL
- ETL
- Data Integration
- Microsoft Power Automate
- Workflow Automation
- Business Process Automation
- Power Automate Connectors
- UI Flows
- Logic Flows
- Microsoft Power Apps (Canvas Apps, Model-Driven Apps, Portals)
- Common Data Service (CDS)
- UI/UX Design
- Responsive Design
- Collaborating closely with business stakeholders
- Translating requirements into effective visualizations
- Identifying automation opportunities
- Gathering requirements
- Defining project scope
- Delivering solutions aligned with business objectives
- Conducting thorough testing
- Debugging
- Troubleshooting
- Ensuring quality and performance of Power Apps solutions
Businessmanagementskills
- Collaborating closely with business stakeholders to translate their requirements into effective visualizations
- Identifying automation opportunities
- Gathering requirements, defining project scope, and delivering solutions aligned with business objectives
- Conducting thorough testing, debugging, and troubleshooting to ensure quality and performance of Power Apps solutions
Languages
English
Native or Bilingual
Timeline
Technical Business Analyst
United way of Calgary and Area
05.2022 - Current
Business Intelligence Developer
Open Planet Technologies
02.2021 - 04.2022
Power BI Developer (remote)
Ikeja Electric
10.2018 - 02.2021
Business Intelligence Analyst
Guesttek Interactive Entertainment Ltd
09.2017 - 05.2018
BSc - Finance
University of Ilorin
PGD - Infrastructure Analysis
Southern Alberta Institute of Technology (SAIT)
Similar Profiles
Chidiebube ChukwuChidiebube Chukwu
Sales Associate at United West CalgarySales Associate at United West Calgary
JASMINE SANDHUJASMINE SANDHU
Administrative Assistant at UNITED WEST CALGARYAdministrative Assistant at UNITED WEST CALGARY
Talat NawazTalat Nawaz
Driver at Calgary United CabDriver at Calgary United Cab
Craig DicksonCraig Dickson
Heavy Equipment Technician at Element Technical ServicesHeavy Equipment Technician at Element Technical Services
Alla OhanjanyanAlla Ohanjanyan
Administration Assistant at ClaimsProAdministration Assistant at ClaimsPro