Data pipelines & integration
Incremental ETL, APIs, staging and repeatable automation.
SSISPythonAPIs
Open to Pakistan & international opportunities
Muhammad Shayan Shamim
BI & Data Analyst · Data Engineering · Power BI
I build automated ETL pipelines, reliable SQL Server models and clear Power BI experiences that turn scattered operational data into useful decisions.
1+Year
5+Projects
PK / GlobalOpen
Selected work
Images first. Clear proof next.
Each card immediately shows the kind of system inside, then explains what the case study contains.
Scheduling interface previewCASE 01Application
Faculty Hour scheduling & analytics platform
A role-based university scheduling application.
- SSO role routing
- Live timetable availability scores
- Alternative slots and portals
SSOLogicAnalytics
Open 2-minute case →
ETL architecture previewCASE 02Production ETL
Institutional ETL & reporting layer
A trusted path from LMS and application data to departmental reporting.
- Incremental SSIS/Python ingestion
- Quality checks before publish
- SQL Server views and procedures
SSISPythonSQL Server
Open pipeline case →
Power BI dashboard previewDEMO 03Simulated data
SaaS revenue & cohort analytics
A public Power BI proof of concept for KPIs and retention.
- Executive KPI summary
- Revenue and segment trends
- 12-month cohort matrix
Power BIDAXCohorts
Open dashboard case →Capabilities
What I can build across the data journey.
SQL Server architecture
Views, stored procedures, schemas and reusable reporting logic.
T-SQLModelsQuality
Power BI decision experience
DAX, data models, KPIs and clear dashboard journeys.
Power BIDAXUX
Automation & intelligent logic
Python, ML and LLM-enabled workflows for practical automation.
PythonMLLLM workflows
Experience
Building the path from ingestion to reporting.
BI & Data Analyst Intern
Habib University
- Automated incremental ETL with SSIS and Python.
- Developed SQL views, procedures and scalable schemas.
- Built Power BI reporting for departmental planning.
Process
A clear delivery path.
Frame the decision
Define the user, question and action.
Map sources
Understand systems and refresh needs.
Build & validate
Automate ingestion and check quality.
Model for reuse
Structure SQL and measures.
Design the decision
Present the right detail, then iterate.
About
Technical thinking with visual discipline.
The heading comes first; the story and education begin below it.
I am a Data Science student and working BI & Data Analyst based in Karachi, focused on reliable pipelines, SQL structures, reporting and analytics applications.
My animation and multimedia background helps me communicate complex systems with stronger hierarchy and clarity.
Bachelor in Data Science
Ziauddin University, Karachi
Diploma in Animation, VFX & Multimedia
NED University, Karachi
HEC Equivalency — Pre-Engineering
Board of Intermediate Education, Karachi