Data Analytics · Financial Analytics · BI

Mohammad Ammar Building Analytics Systems That Transform Data Into Decisions

Data Analytics · Financial Analytics · Business Intelligence · Dashboard Architecture

Engineering student building analytics systems focused on financial analytics, business intelligence, dashboard architecture, and institutional-style data workflows.

Mohammad Ammar

An Engineering Student Who Thinks Like An Analyst

Self-driven learner focused on building institutional-grade analytics capabilities across data, finance, and business intelligence.

  • Data Analytics
  • Financial Analytics
  • Business Intelligence
  • Dashboard Systems
  • Customer Analytics
  • Risk Analytics
01

Started with Python & SQL

02

Built exploratory analytics projects

03

Developed dashboards

04

Explored financial analytics

05

Built GitHub portfolio

06

Preparing for analytics internships

07

Moving toward advanced analytics and data science

Analytics Toolkit

</>

Programming

PythonSQLPandasNumPy

Analytics

EDAKPI AnalysisFinancial AnalyticsRisk AnalyticsCustomer AnalyticsBusiness Intelligence

Visualization

TableauPlotlyStreamlitPower BI Concepts

Tools

GitGitHubVS CodeJupyter Notebook

Analytics Projects

End-to-end analytics work with real datasets, SQL pipelines, and business insights.

Olist E-Commerce Sales Analysis Dashboard

Olist E-Commerce Sales Analysis

End-to-end e-commerce analytics on the Olist dataset using SQL and Tableau. Uncovered revenue trends, customer behavior, and regional sales performance across 95K+ orders.

Business Impact: Identified top product categories driving 80% of revenue and seasonal patterns for inventory planning.
SQLPythonTableauPandas
View on GitHub
E-Commerce Cohort Retention Analysis Dashboard

E-Commerce Cohort Retention Analysis

Cohort analysis on Olist e-commerce data to measure customer return rates over time. Built retention heatmaps and analyzed monthly cohort behavior patterns.

Business Impact: Revealed sharp retention drop after first month, highlighting critical one-time buyer problem for marketing strategy.
SQLTableauCohort AnalysisWindow Functions
View on GitHub
E-Commerce RFM Customer Segmentation Dashboard

E-Commerce RFM Customer Segmentation

RFM segmentation analysis identifying Loyal, Champions, At-Risk, and Lost customer segments. Delivered actionable insights for retention and revenue optimization.

Business Impact: Loyal customers contribute 32% of revenue; At-Risk segment flagged for early intervention campaigns.
SQLPythonTableauRFM Analysis
View on GitHub
Daily Reflection Tree Application

Daily Reflection Tree

Deterministic end-of-day reflection system using decision tree logic. Demonstrates knowledge engineering, system design, and psychology-to-data translation without LLM dependency.

Business Impact: Showcases structured decision systems, auditability, and user-centered analytics workflow design.
PythonFastAPIDecision TreesSystem Design
View on GitHub

Financial Risk & Securitisation Analytics

Confidential Work

Selected work remains confidential due to project restrictions. Never exposing confidential project content.

Delinquency Analytics Vintage Analysis Stress Testing Risk Monitoring Dashboard Architecture Investor Reporting IFRS9 Concepts

Current Focus

Data Analytics
Financial Analytics
Dashboard Systems
Business Intelligence
SQL
Python
Analytics Engineering
Internship Preparation

Why I'm Internship Ready

01

Real SQL Projects

30+ SQL queries across e-commerce analytics with production-style data pipelines.

02

Business Problem Solving

Every project connects analysis to actionable business recommendations.

03

Dashboard Development

Interactive Tableau dashboards deployed for stakeholder-ready insights.

04

GitHub Portfolio

Documented repositories with README insights, SQL scripts, and visualizations.

05

Financial Analytics Exposure

Experience with delinquency, vintage analysis, stress testing, and IFRS9 concepts.

06

Self-Driven Learning

Continuous upskilling through projects, datasets, and analytics exploration.

07

Analytical Thinking

Structured approach to KPI definition, hypothesis testing, and insight generation.

08

Consistency & Execution

Sustained project delivery demonstrating reliability and follow-through.

Analytics Lab

Current areas of active exploration and skill development.

Customer Analytics

Segmentation, cohort analysis, and behavioral pattern recognition.

Financial Analytics

Risk metrics, delinquency trends, and portfolio performance analysis.

Retention Analytics

Cohort retention, churn signals, and lifecycle value modeling.

Risk Analytics

Stress testing frameworks, vintage curves, and monitoring dashboards.

Dashboard Systems

Institutional-grade BI architecture and interactive reporting layers.

Data Storytelling

Translating complex analytics into clear, decision-ready narratives.

Career Mission

Engineering Student
Data Analytics Intern
Data Analyst
Financial Analytics
Data Scientist

Professional Profile

Get In Touch

Open to Data Analytics, Business Intelligence, and Financial Analytics Internship Opportunities.