Developed an end-to-end Power BI solution to analyse sales performance, product demand, customer behaviour, market distribution and discount exposure across OmniStep’s global footwear operations. Using the CRISP-DM framework, the project transformed 30,000 transaction records into a structured data model, three interactive dashboards and a management-focused key insights page.

Project Highlights
• Gross Sales: $10.48M
• Net Revenue: $9.08M
• Orders: 30,000 across six countries
• Units Sold: 75,006
• Discount Exposure: $1.40M
• Discounted Orders: 83.43% of all orders
• Key Insight: Higher average discounts did not guarantee stronger category revenue

Technologies
Power BI • Power Query • DAX • CRISP-DM • Star Schema • Business Intelligence

• View Project

Developed an end-to-end Power BI solution to analyse loan operations, borrower outcomes, credit risk and financial performance across Finovia Global Finance's ten markets. The project transformed two years of fragmented lending data into a structured star schema and three interactive dashboards covering Loan Operations, Loan Outcomes and Finance.

Project Highlights
• Total Loans: 4,000 across 2,000 unique borrowers
• Repayment Rate: 67.93% against a 75% target
• Default Rate: 6.03% across 241 defaulted loans
• Collection Rate: 85.9%
• Net Income: $124M
• Profit Margin: 18.2%
• Data Model: Star schema with a dedicated Calendar table and 17 DAX measures

Technologies
Power BI • Power Query • DAX • Star Schema • Financial Analytics • Data Visualisation

• View Project

Developed an end-to-end Power BI solution analysing public health performance across 10 ASEAN countries between 2000 and 2023. The project transformed complex health data into interactive dashboards that reveal regional progress, country-level disparities, disease burden, mortality trends, and health system capacity.

Project Highlights
• Coverage: 10 ASEAN Countries
• Period: 2000–2023
• Focus Areas: Health Outcomes, Disease Burden, and Health System Capacity
• Data Model: Star Schema with Power Query ETL and DAX
• Objective: Support evidence-based decision-making aligned with SDG 3

Technologies
Power BI • Power Query • DAX • Star Schema • Data Modelling • Executive Reporting

• View Project

Developed an end-to-end Power BI solution analysing energy access and sustainable development across 49 Sub-Saharan African countries between 2001 and 2023. Using World Bank data, the project combines interactive dashboards, dimensional data modelling, and business intelligence techniques to uncover regional disparities in electricity access, clean cooking, renewable energy adoption, economic development, and environmental sustainability.

Project Highlights
• Coverage: 49 Sub-Saharan African Countries
• Period: 2001–2023
• Indicators: 10 Sustainable Development Metrics
• Data Model: Star Schema with Power Query ETL & DAX
• Objective: Support evidence-based decision making for SDG 7
Technologies
Power BI • Power Query • DAX • Star Schema • World Bank Data

• View Project

Developed an end-to-end Business Intelligence solution using Microsoft Power BI to transform transactional sales data into actionable business insights. The project combined Power Query, Star Schema data modeling, DAX, and interactive dashboard development to evaluate product performance, customer profitability, regional trends, and operational efficiency.

Project Highlights
• Revenue: $15M
• Profit: $1.52M
• Profit Margin: 10.33%
• Top Product Category: Office Supplies (65% of total profit)
• Most Profitable Customer Segment: Corporate

Technologies
Power BI • Power Query • DAX • Star Schema Data Modeling

• View Project

Developed an end-to-end business performance dashboard using Microsoft Excel to evaluate Salient Ventures' Q4 recovery strategy. The project analyzed product profitability, customer behavior, regional performance, and sales personnel effectiveness to assess the impact of strategic business initiatives.

Project Highlights
• Revenue: $115M
• Profit: $17M
• Profit Margin: 15%
• Highest Performing Region: Texas
• Top Product Category: Accessories

Technologies
Microsoft Excel • Pivot Tables • Pivot Charts • XLOOKUP • Dashboard Design

• View Project

Developed an interactive retail performance dashboard using Microsoft Excel to evaluate sales performance, customer purchasing behavior, product demand, and regional distribution. The project transformed transactional data into actionable insights to support strategic business planning.

Project Highlights
• Revenue: $264K
• Orders: 2,000
• Products Sold: 4,179
• Top Categories: Fashion, Home & Furniture, Electronics (63% of revenue)
• Highest Revenue Month: September (+30%)

Technologies
Microsoft Excel • Pivot Tables • Pivot Charts • XLOOKUP • Dashboard Design

• View Project

Built a sales performance dashboard using Microsoft Excel to evaluate revenue growth, profitability, product margins, and operational efficiency across the furniture market.

Project Highlights
• Revenue: $742K
• Profit: $18.5K
• Year-over-Year Profit Change: -57%
• Largest Loss Drivers: Tables & Bookcases
• Primary Markets: New York City & Los Angeles

Technologies
Microsoft Excel • Pivot Tables • Dashboard Design

• View Project

Developed an interactive retail analytics dashboard using Microsoft Excel to evaluate sales performance, customer purchasing behavior, product returns, and geographic sales concentration.

Project Highlights
• Revenue: $13.2M
• Revenue Lost to Returns: $896.8K
• Return Rate: 6.78%
• Largest Market: United Kingdom (88% of revenue)
• Business Risk: Heavy dependence on a single geographic market

Technologies
Microsoft Excel • Pivot Tables • Dashboard Design

• View Project

Built a content intelligence dashboard using Microsoft Excel to analyze Netflix's global content library, acquisition strategy, audience targeting, and geographic expansion.

Project Highlights
• Total Titles: 8,796
• Movies: 69.7% of the catalogue
• Largest Genre: International Movies
• Largest Content Market: United States
• Recent Content: 63.1% added within two years of release

Technologies
Microsoft Excel • Pivot Tables • Dashboard Design

• View Project

An analytical evaluation of the evolving role of Layer 2 solutions within a modular blockchain framework. This research, originally developed for the Mitosis ecosystem, explores whether L2s remain a necessity in 2025 or if the industry shift toward unified interoperability and alternative scaling layers is rendering them obsolete. I break down the technical trade-offs between fragmented liquidity and sovereign execution environments.

Key insights:
Modular Standard: L2s are the new baseline for execution, but their success now hinges on seamless interoperability.
Ecosystem Specialization: Networks are evolving from "general purpose" to specialized roles like RWA tokenization and high-speed trading.
The UX Barrier: Gas token fragmentation and bridging friction remain the final hurdles to mainstream L2 adoption.

• Check it out

A deep dive into the architecture of exchange safety nets. I explain the flow of money during liquidations and why understanding these "zero-sum" mechanics is critical for assessing protocol-level risk and systemic stability in decentralized markets.

Key insight:
The Zero-Sum Dynamic: Explains that for every long, there is a short, highlighting that futures markets are a transfer of value based on risk appetite rather than asset creation.
Insurance Fund Architecture: Details how exchanges use insurance funds as a first line of defense to prevent "socialized losses," ensuring that winning traders are paid even when losers are liquidated beyond their collateral.
Liquidation as a Safety Valve: Reframes liquidations not as a failure, but as a necessary automated mechanism to protect the overall system's solvency and liquidity.
Risk Management Education: Advocates for data-driven trading by simplifying complex concepts like funding rates and maintenance margins for a broader audience.

• Check it out

A long-form educational commentary exploring Bitcoin's origin, the structural flaws of traditional financial systems, and why blockchain technology continues to represent a major shift toward decentralized infrastructure, transparency, and global accessibility.

Key insights:
Market Maturity Gap: Contrasts the $7.5 trillion daily Forex volume against crypto's current scale to demonstrate the massive potential for institutional expansion.
Financial Exit Velocity: Reframes Bitcoin as a "Freedom Tech" protest born from the 2008 banking crisis, designed to provide a trustless alternative to centralized bailouts.
The Scarcity Standard: Explores the logical long-term value of a 21-million hard cap in a world of endless currency printing and third-party intermediaries.

• Check it out