Sunday Luke Ayobami

Email: adwklc@r.postjobfree.com, Phone Number: 925-***-****

PROFILE SUMMARY

Luke Ayobami is a Power BI developer and a data analyst with over four years of IT experience in various industries such as Pharmaceuticals, Retail, Banking, Finance and Healthcare. He has proficiency in data warehouse management, database design, and visual analytics development using Microsoft SQL Server and Power BI. Luke has Microsoft certifications in Power BI as a Microsoft Certified Data Analyst Associate and a certification in Microsoft Power Platform Fundamentals. He is experienced with data analysis, data modelling, data preparation and importing data from SQL Server and Oracle DB into Power BI to generate insightful reports. He has participated in software solutions deployment from the beginning to the end based on software development life cycle. EXPERIENCE

Capgemini 10/2021 – 03/2023

Power BI Developer/Data Analyst

• Developed and maintained two MVP Power BI dashboards and reports for the upper management team.

• Designed reports based on business requirements and deployed the reports to workspaces to create dashboards for end users.

• Coordinated with business users in analyzing business requirements and translating them to technical specifications.

• Designed and scheduled Power BI Data refresh for updated live data.

• Analyzed and queried Data from backend within the Azure Databricks Environment.

• Plan, design and implement application database code objects, such as stored procedures and views.

• Build and maintain SQL Scripts, indexes and complex queries for data analysis and extraction.

• Designed reports based on business requirements and deployed the reports to workspaces to create dashboards for end users.

• Coordinated with business users in analyzing business requirements and translating them to technical specifications

Dash Technology 08/2020 – 08/2021

Data Analyst

• Coordinated with business users in analyzing business requirements and translating them to technical specifications.

• Used Power BI desktop to directly connect to database tables (Direct Query Mode).

• Participated in using R to collect the data in Power BI Desktop.

• Used Python for details analysis of data that are necessary to be presented.

• Connected to Azure Analysis services and made a live connection possible to work with the tabular models of Analysis services.

• Utilized Query Editor to clean and format data and eliminate redundant information and append and merge tables from various data sources.

• Worked on all types of transformations that are available in Power BI Query editor.

• Designed reports based on business requirements and deployed the reports to workspaces to create dashboards for end user.

Indiana University of Pennsylvania 01/2018 – 05/2020 Graduate Assistant

• Oversaw groups of students and assisted with academic projects in statistics and data science.

• Assisted with data collection to be used for potential academic publications.

• Mined data, perform statistical analysis and predictive modeling.

• Used Power BI and Python for details analysis of data that are necessary to be presented. GT Bank Nigeria 06/2015 – 10/2017

Data Analyst/BI Developer

• Migrated existing reports to Power BI

• Review SQL codes and recommend optimization while enforcing best practices.

• Extensively made use of the T-SQL in creating and altering stored procedures, tables, views, and other SQL joins.

• Developed and used joins and sub queries for complex queries involving multiple tables.

• Configured Power BI enterprise gateway to keep the dashboards and reports up to date.

• Created static and dynamic row level security in Power BI desktop and assigned roles to users in Power BI Service.

• Integrated custom visualizations as per business requirements. EDUCATION

Master’s Degree 01/2018 – 05/2020 Indiana University of Pennsylvania, PA Bachelor’s Degree 11/2009 – 10/2014 Federal University of Technology, Minna, Nigeria CERTIFICATIONS

• Microsoft Certified: Power BI Data Analyst Associate (DA-100)

• Microsoft Certified: Power Platform App Maker Associate (PL-100)

• Microsoft Certified: Microsoft Azure Fundamentals (AZ-900)

• Microsoft Power Platform Certified: Power Platform Fundamentals (PL-900)

• Certified ThoughtSpot Professional: ThoughtSpot Professional Certification

• AWS QuickSight Training

• Snowflake Training

• Google Data Analytics Certification

• Data Cleaning and Analysis Course

• Machine Learning Fundamental Course

• Tableau Essential Training Course

Contact this candidate