DORIS FRANK

Business Analyst | Business Intelligence & Data Analytics Specialist.

CoffeeCo Executive Business Intelligence Report

An end-to-end Business Intelligence project analysing sales performance, operational efficiency, and customer behaviour across a 3-location specialty coffee chain (H1 2023). SQL + Excel + Executive Reporting + Dashboard Design. A full-stack BI project covering data modelling, 42 business queries, three management dashboards, and actionable strategic recommendations built from scratch on real transaction data. Explained a 72.3% revenue growth differential | Identified a 30× staffing inefficiency | Classified 29 products by commercial value | Flagged 34.5% revenue concentration risk.

Synergy Enterprises
Enterprise HR Transformation

Synergy Enterprises HR Transformation case study

An end-to-end Business Analysis engagement evaluating HR technology modernization for a 75,000-employee global FMCG manufacturer operating across five continents. Stakeholder Analysis + Business Case Development + RACI Governance + SDLC Methodology Selection. A full transformation roadmap covering current vs. future state architecture, a phased implementation plan, and a financially justified case for enterprise HRIS adoption. Projected 25% improvement in HR operational efficiency | Projected $5M in annual savings within three years | Agile SDLC recommendation with full rationale | 6 core BA artifacts + board-ready business case.

RevampBank
Mobile Banking Transformation Initiative

RevampBank mobile banking transformation initiative

A Business Analyst consulting engagement leading project initiation and stakeholder analysis for a mid-size UK digital bank's mobile app revamp. BA Artefacts: Stakeholder Register + Power-Interest Matrix + RACI Governance + Performance Measurement Framework. Tools: Microsoft Excel, Word, PowerPoint. A full discovery-phase engagement covering problem framing, governance design, requirements prioritization, proposed solution, and accountability structures built before solution design began. This engagement demonstrates not just knowledge of Business Analysis techniques — but how to apply them to frame problems, guide decisions, and prepare organizations for delivery. 9-role governance framework | $2M annual revenue exposure addressed | 4 structured solution recommendations | Full RACI + Power-Interest stakeholder mapping.