Open to Data Analyst / BI opportunities

Mohammed Yaseen Jakati

Data Analyst · SQL · Power BI · DOMO · Business Intelligence

Data Analyst with 4+ years of experience building SQL reporting, Power BI dashboards and DOMO analytics for operational and client-facing reporting. My focus is turning messy data into reliable metrics, clear models and useful dashboards.

Bengaluru, India · Insurance analytics · Reporting & BI

0+
Years in BI
0
BI case studies
0–40%
Dashboard load improvement
0
Reporting time saved
// Case studies

Selected analytics case studies.

Each project shows the business question, data preparation, analytical approach and dashboard output. The datasets are synthetic case-study data, so the methods can be reproduced without exposing client information.

Supply ChainCS-01

Supply Chain Performance & Inventory Analytics

Business question: How can operations teams monitor delivery reliability and inventory risk in one view? I modelled orders, products, suppliers and inventory snapshots and built an OTIF, turnover and stockout dashboard.

SQL Server → ETL · Data Modeling → Power BI
target
96.1%
OTIF in sample
2,093
orders
198
stockout flags
SQL ServerETLData ModelingDAXKPI Cards
ProcurementCS-02

Vendor Performance Analysis

Business question: How can procurement compare suppliers consistently? I created a weighted score using delivery reliability, quality and cost, then ranked vendors and surfaced suppliers needing review.

SQL → Weighted scoring · CTEs → Power BI
120
vendors
50/35/15
weighted model
3,481
purchase orders
SQLCTEsRANK()DAX MeasuresPower Query
Finance · ForecastingCS-03

Stock Forecasting Application

Business question: How should a time-series forecast communicate both direction and uncertainty? I prepared daily price data in SQL and built an interactive 30-day exponential-smoothing forecast with a 95% confidence band.

SQL → Time-series prep → Power BI Forecast
now
4
tickers
30-day
forecast horizon
95%
confidence band
SQLTime IntelligencePower BI ForecastDAXSlicers
AviationCS-04

Airlines Data Analysis Project

Business question: Which operating factors are most associated with arrival delays? I cleaned a 15,000-flight sample in SQL and analysed delay patterns by carrier and departure hour in an interactive dashboard.

SQL → Cleaning · Aggregation → Power BI
On-time Delayed Cancelled
15,000
flight records
70.0%
on-time in sample
144
routes
SQLData CleaningAggregationPower BIDrill-through
// What I bring

Useful across the reporting lifecycle.

Reporting & BI

Build operational and management dashboards in Power BI and DOMO, from KPI definition through publishing and refresh.

SQL & Data

Transform, validate and analyse relational data using T-SQL, CTEs, window functions, views and stored procedures.

Automation

Reduce repetitive reporting with reusable SQL logic, ETL workflows and Python where it adds practical value.

Data Quality

Reconcile source data, investigate discrepancies and make reporting logic consistent enough for stakeholders to trust.

// Toolkit

Tools I use in production and in case studies.

My strongest areas are SQL, Power BI and DOMO, with supporting experience across data modelling, ETL, Python and reporting workflows.

01SQL & Databases
SQL ServerMySQLPostgreSQLCTEsRecursive CTEsWindow FunctionsStored ProceduresQuery OptimizationData Modeling
02Visualization
Power BIDOMODAXPower Query (M)Beast ModeApp StudioKPI ReportingCustom Cards
03ETL & Analytics
ETL PipelinesSSISData WranglingData ValidationTrend AnalysisForecastingData Governance
04Programming & Tools
PythonPandasExcelPower BI ServiceDOMO WorkbenchSSMSGit
// Track record

Professional experience.

APR 2022 — PRESENT
Data Analyst / SQL Developer
Elpis Systems · Bengaluru, KA
  • Built Power BI and DOMO dashboards for operational KPIs, performance trends and client reporting across insurance analytics workflows.
  • Built data models, relationships and DAX measures; improved dashboard performance by 30–40% through query and model tuning.
  • Wrote and optimised complex T-SQL daily — joins, subqueries, CTEs and window functions over large relational datasets.
  • Developed reusable stored procedures and views that reduced roughly 5 hours of manual reporting work per week.
  • Built custom DOMO dashboards with Beast Mode metrics and App Studio layouts for polished, client-facing self-service reporting.
  • Managed Power BI Service workspaces — refresh schedules, permissions and governance.
2016
Master of Arts (M.A.) in English
Kuvempu University · Vijayapura, KA
Strong written communication that carries straight into clear documentation, stakeholder reporting and dashboards non-technical users can read at a glance.
// Certifications

Kept sharp on purpose.

SQL Development & Data Analysis

LinkedIn Learning
2022 · Completed

Advanced Power BI

LinkedIn Learning
2023 · Completed

Microsoft Power BI Data Analyst (PL-300)

Microsoft
In progress
// Let's talk data

Open to the right Data Analyst or BI role.

I'm interested in roles where I can work with SQL, Power BI, DOMO and business reporting. If you're hiring for Data Analyst, BI Analyst or SQL-focused roles, I'd be happy to connect.

LinkedIn ↗ GitHub ↗ 📍 Bengaluru, India