Open to opportunities

Mary Vaatyough

@maryvaatyough

Message

I build BI dashboards and automated data pipelines that uncover operational losses and speed decisions.

Nigeria

Message

What I'm looking for

I'm looking to apply Power BI, Excel, and MySQL to solve operational problems, automate repetitive reporting, improve data quality, and help leadership make faster strategic decisions.

I've built Power BI dashboards that turn operational data into fast, actionable decisions, including fleet reporting that tracked $263 million in gross earnings and isolated $21 million in capital drain from delayed loads and facility bottlenecks.

In sales analysis, I created an interactive Power BI dashboard covering 3 million Naira in revenue, 932 thousand Naira in profit, and purchasing behavior across more than 1,700 monthly customers. I also developed a global travel dashboard analyzing over $115M in spending to make high-cost trends easier to identify.

Using MySQL, I transformed 15 source tables into four BI-ready views, reducing reporting time by 60%. I build data-quality checks, resolve SQL issues, and automate cleaning work that saves teams more than 10 hours each week.

In Excel, I've optimized formulas, modeled connected reporting sheets, and created automated visualization layers that improved calculation efficiency by 40% and accelerated performance analysis by 35%.

Experience

Work history, roles, and key accomplishments

Lead Data Analyst

Automated Performance Ledger

Refactored spreadsheet logic by replacing resource-heavy nested conditions with optimized lookup formulas, achieving a 40% improvement in calculation efficiency. Created automated visualization layers with conditional formatting to surface anomalies and accelerate performance analysis by 35%.

Data Modeling Data Cleaning Conditional Formatting

Principal Business Intelligence Analyst

Enterprise Data Validation and Business Intelligence

Architected a fleet operations dashboard tracking $263 million in gross earnings, isolating $21 million capital drain through delayed loads and facility bottlenecks. Designed an interactive Sales Dashboard analyzing 3 million Naira in revenue and 932 thousand Naira in profit, tracking purchasing shifts of over 1,700 monthly customers.

Power BI Data Visualization Dashboard Design Data Analysis Business Intelligence

Data Analytics Specialist

FleetOps

Built an SQL reporting pipeline by transforming 15 source tables into 4 BI-ready views, improving query efficiency and reducing reporting time by 60%. Developed SQL-based data-quality checks using conditional logic and cleaning functions to standardize operational data, reducing manual correction by 10+ hours weekly.

MySQL SQL ETL Data Quality Data Analysis

Education

Degrees, certifications, and relevant coursework

Oloye Comprehensive College

High School Diploma, General Studies

Activities and societies: Secretary of the Arts and Drama Club

Secretary of the Arts and Drama Club, maintained records for 60+ members and documented 72+ meetings over 2 years, improving organizational efficiency and communication.