Open to junior data opportunities

From raw data to
clear business insight.

I’m Mian Arsalan Anwar, a Junior Data Analyst with internship and academic project experience in analysis, reporting, and data quality.

3Academic degrees
5Portfolio projects
A2German level
Mian Arsalan Anwar, Junior Data Analyst
Junior Data Analyst Mian Arsalan Anwar
Germany
↗
Business focusActionable insights
Core toolkitPython · SQL · Power BI
04
Selected workData & software projects
Scroll
POWER BI✦SQL✦PYTHON✦BIGQUERY✦GOOGLE ANALYTICS✦LOOKER STUDIO✦

01 / About

Analytical thinking with a practical business focus.

Mian Arsalan Anwar
ProfileData, reporting and business intelligence

Data Analyst with internship and academic project experience in data analysis, reporting, and data quality. Proficient in Python, SQL, and Power BI, with the ability to identify trends and translate data into actionable business insights.

Based inGermany
Target rolesJunior Data & BI
LanguagesEnglish · German A2
Driving licenceCategory B

02 / Expertise

A focused toolkit for data-driven work.

Core capabilities aligned with Junior Data Analyst, Reporting Analyst, and Business Intelligence roles.

Data Analysis

Preparing, exploring, and interpreting data to support reliable reporting and decision-making.

Data CleaningKPI ReportingData VisualizationFunnel AnalysisEDA

Technical & BI

Using query, programming, database, and business intelligence tools to turn data into reliable analytical outputs.

PythonSQLPower BIBigQuerySQL Server

Analytics Platforms

Working with analytics and reporting platforms to organize information and communicate findings.

Google SheetsGoogle AnalyticsLooker Studio

Workflow Tools

Supporting analysis, documentation, coding, and collaborative work through practical development tools.

GitJupyter NotebookGoogle ColabVS CodeMicrosoft Office

03 / Experience

Practical analytics experience.

Nov 2021 — Jan 2022

Data Analyst Intern — IslamicFinder Team

VaulTech Private Limited · Karachi, Pakistan

Internship
  • Supported analysis of web and mobile-app data to identify user-behaviour, retention, and funnel trends.
  • Prepared KPI reports for paid installs, in-app purchases, and marketing campaign performance.
  • Cleaned and validated datasets and helped improve recurring data-collection and reporting workflows.
  • Communicated actionable findings to product, growth, and technical teams to support decision-making.

04 / Selected work

Projects across analytics, databases, and software engineering.

Selected work combining data analysis, relational database design, SQL, and software engineering capstone experience.

01
Dashboard summarizing the Marketing ROI in German e-commerce study with sample size, ROI findings, regression result, correlations, and SPSS analysis methods Actual thesis findings
M.Sc. Data Analytics Final Project · BSBI2024

Marketing ROI Analysis in German E-commerce

Evaluated how data analytics influences marketing ROI in German e-commerce using survey data, interviews, SPSS analysis, correlation, regression, and thematic analysis.

SPSSDescriptive StatisticsCorrelationRegressionMixed Methods
View on GitHub
02
● Final Year Project School transport management
HomePickupSchool
HVS
Parent & driver coordinationManagement and tracking concept
B.S. Software Engineering Final Year Project · MAJU2021

School Van Mobile Application

Developed a school-van management and tracking application to help parents and van drivers communicate and coordinate.

Final Year ProjectMobile ApplicationTrackingCommunication
03
MAJU logo
ACADEMIC SYSTEM · MAJU · 2019Cafe Management System
C# + SQL Server
MENU ITEMS30Seeded catalogue
DB TABLES4Relational model
AVG. PRICE135.330 seeded items
FK LINKS2Order relationships
Menu price distributionActual seed data
≤ 10017
101–2509
251–5003
> 5001
Median price85Range10–1000
Highest menu pricesSeeded catalogue
01Pizza1000
02Singrice320
03Cake300
04Zingburg300
05Pasta / Chkburg230
tblRegister→tblOrder←tblItemstbladmin
Academic DBMS Project · MAJU2019

Cafe Management Database System

Built a C# Windows Forms cafe application backed by Microsoft SQL Server, covering user registration/login, admin access, a 30-item menu catalogue, price maintenance, order entry, totals, and receipt generation.

C#Windows Forms.NET FrameworkSQL ServerRelational Database
View on GitHub
04
Vue project logo
FULL-STACK DBMSTeam Management System
Vue + Express + SQL
CORE ENTITIES5DB model
REST ENDPOINTS10Express backend
TRACKING FIELDS8Project row
DEFAULT PROGRESS50%New row
Relational workflowFrom backend queries
boards→tables→rows persons→project_members→rows
BoardsPeopleTablesRowsMembers
Task tracking modelActual UI fields
PeoplePriorityDue dateStart dateStatusProgressLast updatedProject name
HighMediumLowWorkingOn HoldStuck
Vue.js / Vuetify→Axios→Express REST API→SQL Server
Full-Stack DBMSVue + Node

Team Management System

Built a Vue/Vuetify project-management interface connected through Axios to an Express REST API and SQL Server data model for boards, project tables, rows, people, assignments, priorities, status, dates, and progress.

Vue.jsVuetifyNode.jsExpress.jsREST APISQL Server
View on GitHub
05
Bilal Motors project logo
FULL-STACK VEHICLE OPERATIONS SYSTEMBilal Motors
Vue + Node + SQL Server
DB TABLES14SQL schema
API ENDPOINTS5942 POST · 17 GET
FRONTEND ROUTES29Vue Router
VIEW COMPONENTS28Vue views
Database module split14 tables
14tables
Rental operations8
Sales / trade6
vehiclecustomerrent_recordreturn_recordadvancebooktradecarSellervehicle_details
Business workflowsRoutes + API coverage
01Vehicle inventoryAdd · update · availability
02Customers & referencesProfiles · balances · records
03Rentals & returnsBooking · rent · penalty · return
04Sales & purchaseSeller · purchaser · trade
05SnapshotsVehicle / booking evidence
06Transaction recordsRental + trade history
Vue.js / Vuetify→29 routes→Express · 59 endpoints→14-table SQL Server DB
Full-Stack Database SystemVehicle Operations

Bilal Motors Management System

Developed a full-stack vehicle operations system with 14 SQL Server tables, 59 active backend endpoints, and 29 frontend routes covering vehicles, customers, references, bookings, rentals, returns, sales/purchases, trade records, and supporting snapshots.

Vue.jsVuetifyNode.jsExpress.jsREST APISQL Server
View on GitHub

05 / Background

Education and continuous learning.

Academic training across data analytics, software engineering, and computer systems research.

Explore certifications
Apr 2026 — Present

M.S. Research in Computer and Systems Engineering

Technische Universität Ilmenau · Ilmenau, Germany

2023 — 2024

M.Sc. Data Analytics

Berlin School of Business and Innovation · Berlin, Germany

2017 — 2021

B.S. Software Engineering

Mohammad Ali Jinnah University · Karachi, Pakistan

Certifications

Three data and BI credentials

Microsoft Power BI, Microsoft Fabric Analytics, and Discover Data Analytics.

↗

06 / Contact

Let’s discuss a data opportunity.

I am interested in Junior Data Analyst, Business Intelligence, reporting, and analytics opportunities in Germany.

Messages are delivered securely through Netlify Forms. You can also contact me directly by email or LinkedIn.