Professional headshot

Mohamad Abdullghani

Data Analyst | Turning Numbers into Insights

I'm a Senior Data Analyst with over 8 years of experience, fueled by a passion for transforming data into solutions that drive impact. Armed with expertise in SQL, R, and Python, I uncover insights that power data-driven decision-making, enhance operational efficiency, and optimize processes. From building dynamic dashboards to automating workflows with Python scripts, I thrive on delivering actionable strategies that improve performance—whether it's refining risk frameworks or empowering operational teams with clear, practical insights. My knack for collaboration ensures complex findings resonate with diverse stakeholders, bridging the gap between technical depth and real-world results.

Outside of data, I'm an active enthusiast who loves smashing it on the tennis court, cutting through the water with a swim, or crafting something new as a woodworking beginner. I'm fascinated by AI's transformative potential, often digging into its technical intricacies. You'll also find me cheering for FC Barcelona, where I blend my love for soccer with a technical eye—analyzing plays and strategies like a game within a game. That same curiosity, precision, and energy drives everything I do, from boosting operational performance to perfecting my next woodworking project.

Experience

11/2021 — 03/2025

Senior Audit Risk Analyst

·Fannie Mae
  • Utilized SQL to extract and analyze large-scale datasets, delivering actionable insights that strengthened audit planning, fieldwork, and 100% population control testing across diverse risk areas.
  • Applied advanced statistical modeling and process mining using R to identify trends and risks, enhancing hypothesis testing and risk-focused audit strategies.
  • Designed and developed dashboards to track Key Risk Indicators (KRIs) and pre-planning audit trends, enabling proactive risk identification and visualization of insights for auditors and senior management.
  • Automated manual processes and administrative tasks with R scripts, driving efficiency and freeing resources for high-value risk analysis.
  • Collaborated with cross-functional stakeholders, communicating complex analytical findings to auditors and senior management, bridging technical and non-technical audiences.
  • Proactively tackled diverse analytics projects, mastering tools like SQL and R, and continuously expanded expertise to address evolving risk and audit challenges.
Data VisualizationProcess MiningLinear RegressionLogistic RegressionCluster AnalysisFull Population TestingProcess AutomationData ETL ProcessingData Extraction & InsightKRI DevelopmentSentiment Analysis
11/2018 — 11/2021

Audit Business Analyst

·Blue Cross Blue Shield of Michigan
  • Assisted management to establish and improve the data analytics department program that supports internal auditors.
  • Trained internal auditors on data literacy and analyzing tools.
  • Created audit DA plan for controls tests using various data analytics tools.
  • Documented and communicated finding, results, and DA performed to stakeholders and management.
  • Execute data analysis related ad-hoc projects as assigned.
Data VisualizationData Extraction & InsightsAnalysis Requirement GatheringFull Population TestingData Strategy DevelopmentData Trainings
1/2017 — 11/2018
  • Evaluated design and operating effectiveness of audit areas, including efficiency, effectiveness, and mitigating controls.
  • Prepared workpapers, reports and supporting documentation for audits.
  • Develop risk testing programs in ACL and IDEA according to the risk matrix.
  • Conducts issue remediation follow-ups with the client.
Audit PlanningRisk Identification & TestingCompliance TestingIssues Follow up

Education

Wayne State University

2015 - 2017

Detroit, MI

Bachelor of Science: Accounting & Information Systems Management

Oakland Community College

2012 - 2015

Bloomfield Hills, MI

Associate of Science: Business Administration

Technologies

SQL logo
SQL
R logo
R
Python logo
Python
JIRA logo
JIRA
Bitbucket logo
Bitbucket
GitHub logo
GitHub
Tableau logo
Tableau
Alteryx logo
Alteryx
VS Code logo
VS Code
AWS SageMaker logo
AWS SageMaker
Oracle logo
Oracle
SQL Server logo
SQL Server
PostgreSQL logo
PostgreSQL