Frank Ouna

• ➢ Questioned initial stakeholder requirements to clarify underlying business questions, leading to more relevant KPIs and over 10 hours of rework saved.

• ➢ Regularly presented analysis findings to management, explaining trends and limitations in non-technical language.

• ➢ Developed interactive Excel dashboards with pivot tables and slicers to provide stakeholders with clear, actionable insights for data-driven decisions in operations and sales.

• ➢ Automated data processing and reporting workflows, reducing manual effort and turnaround time for standard reports, and increasing consistency and efficiency.

• ➢ Questioned existing data logic and proposed a new star schema model, reducing query time by 40%.

• ➢ Extracted and transformed data from various sources (JSON, Excel, operational databases) to ensure high-quality, integrated datasets for accurate reporting and business analysis.

• ➢ Actively improved existing Power BI dashboards based on user feedback, transforming static reports into interactive decision-making tools.

• ➢ Applied advanced DAX formulas for time intelligence (year-over-year comparison, growth, moving averages) to provide stakeholders with deeper insights into revenue trends and support performance tracking against business goals.

• ➢ Developed interactive sales performance dashboards with dynamic filters (branch, product, period), enabling self-service analytics for departments and management.

• ➢ Beyond just dashboard creation, I interpreted fraud patterns and presented actionable recommendations to the risk committee, leading to two policy changes.

• ➢ Developed complex T-SQL scripts for data wrangling: data cleaning (removing duplicates, handling nulls and invalid characters), standardization (date formats, branch codes), and transformation using CASE, PIVOT, MERGE, and CTEs to ensure high-quality, reliable datasets for fraud analysis and reporting.