# Mary Vaatyough

Mary Vaatyough is a remote worker on Himalayas, Lead Data Analyst at Automated Performance Ledger, based in Nigeria.

Source: https://himalayas.app/@maryvaatyough

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

| Detail | Value |
| --- | --- |
| Availability | Open to opportunities |
| Location | Nigeria |
| Authorized to work in | Nigeria |
| Job categories | Data Analyst, Business Intelligence Analyst, Data Analyst, Data Analytics Specialist, Data Visualization Analyst, SQL Analyst, Associate Data Analyst |
| Skills | Data Analysis, Business Intelligence, Power BI, Excel, Tableau, MySQL, Data Extraction, Data Visualization, Data Cleaning, Data Modeling, ETL, Data Quality Assurance, Dashboard Development, Pivot Tables, XLOOKUP, Conditional Formatting, SQL, Technical Translation, Strategic Collaboration, GitHub, Instantly |

## What I'm looking for

```text
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.
```

## About

```text
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

### Lead Data Analyst

Automated Performance Ledger

```text
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%.
```

Skills: Data-Modeling, Data-Cleaning, Conditional-Formatting

### Principal Business Intelligence Analyst

Enterprise Data Validation and Business Intelligence

```text
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.
```

Skills: Power-BI, Data-Visualization, Dashboard-Design, Data-Analysis, Business-Intelligence

### Data Analytics Specialist

FleetOps

```text
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.
```

Skills: MySQL, SQL, ETL, Data-Quality, Data-Analysis

## Education

### Oloye Comprehensive College

High School Diploma, General Studies

Activities and societies: Secretary of the Arts and Drama Club

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

## Tech stack

- GitHub
- MySQL
- Microsoft Excel
- SQL
- Instantly

To contact Mary, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [David Ocholi](https://himalayas.app/@davidocholi): Data Analyst Intern, TechCrush
- [Olashile Busari](https://himalayas.app/@Olashile): Power BI Analyst, FirstBank of Nigeria
- [Daniella Adagbon](https://himalayas.app/@daniellaadagbon): Data Analyst, 10Alytics
- [ABIODUN OGUNTUASE](https://himalayas.app/@abiodunoguntuase): Operations Team Lead, BitAfrica
- [Cynthia Muorah](https://himalayas.app/@cynthiamuorah): Data Analyst Intern, NSDIC
- [Egbeobauwaye Nagbons](https://himalayas.app/@egbeobauwayenagbons): Freelance Data Analyst, Freelance
- [Balogun Vincent Omomeje](https://himalayas.app/@balogunvincentomomej): Senior Data Analyst, Acuity Insurance
- [Gafar Olajide](https://himalayas.app/@gafarolajide): Data Analyst / Business Intelligence Analyst, Upwork
- [Rukewe Azumurana](https://himalayas.app/@rukeweazumurana): AI Data Analyst Intern, Excelerate
- [David Olatunji-Aguda](https://himalayas.app/@davidolatunji-aguda): Data Analyst / BI Analyst, 10Alytics
