Open 

Harold-Wilson Thom-Otuya

Business & Data AnalystThe Alchemist

I turn complex, messy data into decisions businesses can act on. Executive KPI dashboards, automated reporting, and real-time portfolio analytics — built so the number on the screen is the one that moves the business.

Port Harcourt, Nigeria
Harold-Wilson Thom-Otuya profile
Scroll

About

What I do
Analyse
Clean, model, and pressure-test data until the story is undeniable.
Visualise
Executive dashboards that surface the one number that matters.
Communicate
Translate findings into decisions non-analysts can act on.
Automate
Replace manual reporting with pipelines that run themselves.

I'm Harold-Wilson Thom-Otuya, a Business and Data Analyst with over three years spent turning complex, messy data into decisions businesses can act on.

My approach comes from an unusual starting point: physics. Studying Industrial Physics at Covenant University taught me to break complicated systems down to their moving parts and ask the one question I still bring to every dataset — what is actually happening here, and what should we do about it? I've spent the years since answering that question for investment managers, fintech firms, and growing businesses.

At Pareto Funds and Securities, I ran risk and investment analysis on portfolios worth over ₦100M, delivering insights that sharpened asset allocation and reduced portfolio exposure by 8%. I built the real-time dashboards portfolio managers relied on to monitor performance and time their rebalancing, lifting reporting efficiency by 25%, and I automated the data pipelines feeding them, eliminating half of all manual reporting errors so the numbers leadership acted on could finally be trusted.

At Dantown, a fintech business, I now work across four entities as the analyst leadership leans on. I've architected a company-wide performance system that lets every staff member see their own KPIs and monthly scores, engineered research dashboards that cut insight delivery time by 30%, and turned monthly analysis of customer-experience and operational data into recommendations I drive through to execution. In parallel, my freelance work has helped small and mid-sized businesses cut reporting turnaround by up to 40% and recover hours each week through smarter automation.

My toolkit spans SQL, Power BI, Excel, Looker Studio, and Python, but I've learned the tools are the easy part. What matters is the thinking behind them: framing the right question, doubting the data before trusting it, and telling the story clearly enough that a decision actually follows.

I also founded Data Alchemists, a community where I train and mentor aspiring analysts through hands-on projects and workshops in Excel, Power BI, SQL, and Python, guiding many of them into their first analyst roles.

For me, data is only valuable the moment it leads to a decision. That's the standard I hold every project to.

Skills

Skills

Languages & analysis
SQL (MySQL, PostgreSQL)Python (Pandas, NumPy, Matplotlib)
BI & visualisation
Power BI (DAX, Data Modelling, RLS)Excel (Pivot Tables, Power Query, Macros)Google Looker StudioGoogle Sheets
Business analysis
Requirements GatheringProcess MappingKPI DesignStakeholder ManagementData Warehousing
Workflow & tools
Jupyter NotebookGoogle ColabNotionMS OfficeGoogle Workspace
Case studies

Projects

  1. Automated Enterprise Operations & Performance Pipeline

    2026
    Confidential Enterprise Group · HR & Operations Performance Analytics
    Problem
    Manual data entry and broken KPI math caused severe reporting delays and disconnected performance feedback for over 100 employees.
    Approach
    Engineered a custom Google Apps Script ETL pipeline with a strict multi-key validation algorithm to automate complex scoring and feed a centralised cloud database.
    Impact
    Eradicated data duplication and replaced delayed spreadsheet feedback with instant, zero-latency Looker Studio visualisations for both top management and individual staff.
    Looker StudioGoogle SheetsApps Script
    Outcomes
    • Eliminated duplicate records through automated multi-key validation.
    • Reduced feedback latency from weeks to seconds.
    • Enabled self-service dashboards for 100+ individual staff members.
  2. Healthcare Cost & Length-of-Stay Analysis

    2024
    HealthStat (consulting client) · Healthcare operations & cost analysis
    Problem
    Cost and length of stay (LOS) varied significantly across 151 NY hospitals doing elective hip replacements, with no clear cause.
    Approach
    Built a Power BI dashboard benchmarking every hospital against state averages, then ran a Key Influencer root-cause analysis across 8 clinical and operational variables.
    Impact
    Isolated illness severity and mortality risk as the top cost/LOS drivers, giving leadership a prioritised hospital and root-cause list to act on.
    Power BIPower QueryDAXKey InfluencerExcel
    Outcomes
    • Identified illness severity and mortality risk as the primary cost/LOS drivers.
    • Created a prioritised benchmark list of 151 hospitals for leadership action.
    • Delivered a clear, data-backed action plan for cost-reduction initiatives.
  3. Fitness Tracker Dashboard

    2024
    Personal portfolio project · Fitness & wellness tracking
    Problem
    Standard fitness dashboards feel clinical and generic, making it harder for users to stay engaged with their own data.
    Approach
    Designed an app-like, Neumorphism-style Power BI dashboard with a dynamic time-of-day greeting, KPI cards, multi-user slicers, and personalised Unsplash profile images.
    Impact
    Delivered a portfolio-ready, highly visual multi-user fitness dashboard that showcases both Power BI development and custom UI/design skill.
    Power BIPowerPointDAXSlicersUnsplash
    Outcomes
    • Built a portfolio-ready interactive dashboard with app-like UX.
    • Demonstrated advanced Power BI visualisation and UI design skills.
    • Created a reusable multi-user profile template for future projects.
Experience

Experience

  1. Business Analyst

    Feb 2025 – Present
    Thoths Group (Dantown — Fintech / Crypto)
    • Cut insight delivery time by 30% by engineering interactive research dashboards leadership uses to make faster, data-driven calls.
    • Built a company-wide performance system giving every staff member self-service access to their own KPIs and monthly scores.
    • Turn monthly customer-experience and operational analysis into recommendations I drive through to execution, unblocking bottlenecks across four business entities.
  2. Freelance Business / Data Analyst

    May 2024 – Present
    Multiple Clients
    • Slashed client reporting turnaround by 40% through custom Power BI and Excel dashboards built for small and mid-sized businesses.
    • Recover 5–7 hours per client each week by mapping and automating repetitive reporting workflows.
    • Surface patterns in multi-source data that lift client ROI through smarter resource allocation and strategic recommendations.
  3. Data Analyst

    Feb 2023 – May 2024
    Pareto Funds and Securities
    • Reduced portfolio exposure by 8% through risk and investment analysis across ₦100M+ in managed assets.
    • Eliminated 50% of reporting errors by automating end-to-end data collection pipelines.
    • Lifted reporting efficiency by 25% with real-time dashboards portfolio managers used to time rebalancing decisions.
  4. Founder & Project Lead

    Nov 2024 – Present
    Data Alchemists Community
    • Founded and scaled a data analytics community running hands-on projects and workshops in Excel, Power BI, SQL, and Python.
    • Mentor aspiring analysts through building real portfolios, guiding many into their first analyst roles.
Certifications & education

Credentials

  1. MBA, Business Administration

    Expected 2027
    Miva University
  2. M.Tech, Electrical Engineering (Power Option)

    Expected 2026
    Rivers State University
  3. Professional Data Analyst Certificate

    Certified
    DataCamp
  4. B.Sc. Industrial Physics (Renewable Energy)

    Completed
    Covenant University
Contact

Contact

I take on a small number of consulting engagements at a time. If you have messy data and a decision waiting on it, let's talk.