Daniel Iyayi
Ottawa,Ontario
Summary
Results-driven Business Intelligence Developer with a proven track record at Novartis, skilled in SQL and Power BI. Expert in transforming complex datasets into actionable insights, enhancing operational efficiency by over 50%. Adept at collaborating with stakeholders to align business needs with data-driven solutions, leveraging strong analytical and communication skills.
Overview
6
6
years of professional experience
Work History
Business Intelligence Developer
Novartis
10.2021 - Current
- · 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.
- · Design and produce conceptual and logical diagram, entity-relationship diagram, data flow diagram, process flow diagram using SSMS diagram and oracle data modeller.
- Analyse, design and create de-normalised dimension tables, fact tables and entity- relationship using SQL Server Database Diagram.
- Data modeling, DAX, Dashboard creation, Report automation on Power BI.
Business Intelligence Developer
AstraZeneca PSL
02.2019 - 09.2021
- Analyzed large datasets using Excel (Pivot Tables, VLOOKUP, Power Query) to generate insights for decision-making for stakeholders
- Developed interactive dashboards and reports using Power BI and Excel to visualize key business metrics and trends.
- Wrote SQL queries (JOINs, CTEs, Subqueries) to extract and manipulate data from relational databases for reporting and analysis.
- Used SQL queries to extract, clean, and analyze data from company databases, reducing reporting errors.
- Monitored business KPIs, identified trends, and provided recommendations to improve operational efficiency.
- Automated manual reporting tasks using Excel Macros/VBA, Power Automate, and DAX in Power BI, improving efficiency by over 50%.
- Partnered with stakeholders across departments to translate business needs into actionable insights.
- Conducted trend analysis to identify business opportunities, leading to a revenue increase.
Education
No Degree - Data Analytics- Advanced Microsoft Excel, Power BI
Hallmarkit Technologies INC
01-2025
No Degree - Extract, Transform And Load Power BI
Microsoft
12-2024
Associate of Science - Data Analysis
National Institute of Information Technology
10-2018
Bachelor of Science - Pharmacy
University of Benin
11-2017
Skills
- Microsoft Excel: Pivot Tables, VLOOKUP, Power Query, Macros, VBA
- SQL: Writing complex queries, Joins, CTEs, Subqueries, Indexing
- Power BI: Data modeling, DAX, Dashboard creation, Report automation
- ETL (Extract, Transform, Load): Data cleaning & transformation using SQL and Power Query
- Database Management: MySQL, PostgreSQL, SQL Server
- Data Visualization: Creating interactive dashboards and reports in Power BI
- Statistics & Data Analysis: Hypothesis testing, Regression analysis, Trend forecasting
Languages
English
Full Professional
Timeline
Business Intelligence Developer
Novartis
10.2021 - Current
Business Intelligence Developer
AstraZeneca PSL
02.2019 - 09.2021
No Degree - Data Analytics- Advanced Microsoft Excel, Power BI
Hallmarkit Technologies INC
No Degree - Extract, Transform And Load Power BI
Microsoft
Associate of Science - Data Analysis
National Institute of Information Technology
Bachelor of Science - Pharmacy
University of Benin
Similar Profiles
Ganesh TsavatapalliGanesh Tsavatapalli
Compliance Expert at NOVARTISCompliance Expert at NOVARTIS
Gustavo Caetano CostaGustavo Caetano Costa
Cell Processing Specialist 2 at NovartisCell Processing Specialist 2 at Novartis
Nancy JasgurNancy Jasgur
Executive Territory Account Specialist at NOVARTISExecutive Territory Account Specialist at NOVARTIS