Personal details
Yomi O.
Data Analyst
Based in: 🇨🇦 Canada
Timezone: Eastern Time (US & Canada) (UTC-4)
About
I'm a data analyst with 5+ years of experience using technologies such as DAX, Python, Microsoft Power BI, Excel. I created analytic reporting solutions for several cross-functional teams, most recently I created a risk based testing report with reduced testing time by 17% so effort could be invested elsewhere. I've worked in manufacuring, gaming & e-commerce.
Work Experience
Data Analyst
Electronic Arts (EA) | Sep 2022 - Present
Python
SQL
API
PostgreSQL
Google BigQuery
Transact-SQL
Power Query
DAX
Power BI
Looker
Jira/confluence
- Developed and implemented a risk-based testing report that reduced testing time by 17% by creating and validating metrics, writing DAX formulas, designing and prototyping the report, and supporting the live product through production and live QA support.
- Created a project management report that improved project completion rates from 40% to 60% by gathering requirements, creating metrics, writing SQL queries, building a star schema data model, designing and testing the report, and conducting a roll-out and training for stakeholders.
- Reduced monthly request volume by 30% by developing and implementing a PowerBI report usage tracking dashboard, which involved pulling api data with a Python script, modelling tables and creating DAX measures to track stakeholder engagement.
Business Data Analyst
Cosmetica Labs | Jan 2022 - Sep 2022
SQL
Excel
Transact-SQL
ERP
Microsoft SQL Server
Power Query
Data analytics
DAX
Power BI
- Improved master data quality from 76% to 98% by creating and implementing a live data quality tracking report, analyzing missing data, and collaborating with the manufacturing team to update and verify crucial information.
- Enhanced analytic turnaround time by 20% by creating a standard documentation process for all analytic team products, including implementing a detailed process to capture the required information, setting up a SharePoint page, and presenting the new process to all key stakeholders.
- Reduced data ingestion ETL runtime by 12% by modifying SQL queries, implementing differential load processes, and testing the changes in a controlled environment before pushing them to the live system.
Education
Babcock University
Bachelor's degree・Computer Science
Jun 2008 - Jul 2012
Certifications & Awards
Microsoft Certified: Power BI Data Analyst Associate
Microsoft | Jul 2023