Data pipelines & integration
Incremental extraction, API and application ingestion, staging and repeatable ETL workflows that reduce manual handling.
Open to Pakistan & international opportunities
I engineer reliable data systems—from source to decision.
Muhammad Shayan Shamim · BI & Data Analyst · Data Engineering · Power BI
I connect operational systems, APIs and databases with automated ETL, validated SQL Server models and clear dashboards—so technical teams trust the data and decision-makers know what to do next.
Current workBI & data analysis at Habib University
Core stackSQL Server · SSIS · Python · Power BI
Delivery1+ year · 5+ end-to-end projects
BI / DataPrimary focus
1+Year experience
PK / GlobalAvailability
Selected work
See the interface, understand the problem, then open the detail.
Each card shows what the project is, what the visitor will find inside and why the work matters—without hiding important information behind hover effects.
Scheduling interface previewCASE STUDY 01Application & analytics
Faculty Hour scheduling & analytics platform
A university scheduling application that turns roles, live timetables and venue constraints into a guided booking decision.
- SSO routes Faculty, Students, Admin and RO to dedicated portals.
- Availability percentages are calculated from live timetables.
- Better time alternatives are surfaced before a meeting is confirmed.
SSOScheduling logicRole portalsAnalytics
Open the application case 
ETL architecture previewCASE STUDY 02Production data workflow
Institutional ETL & trusted reporting layer
An automated data flow that centralizes LMS and application data, validates it and publishes reusable SQL Server structures.
- Incremental SSIS and Python ingestion from multiple systems.
- Data-quality checks before records reach reporting models.
- Views, procedures and schemas provide secure departmental access.
SSISPythonSQL ServerData quality
Open the ETL case 
Power BI dashboard previewPUBLIC DEMO 03Simulated data demo
SaaS revenue & cohort analytics
A public Power BI proof of concept showing how KPIs, customer value and 12-month retention cohorts can live in one decision view.
- Executive KPIs lead into trend and segment analysis.
- DAX measures support subscription and customer-value questions.
- A cohort matrix shows where retention weakens over time.
Power BIDAXData modelingCohorts
Open the dashboard case Capabilities
What I can deliver across the data journey.
These are grouped by the outcome a team needs—not presented as an unstructured wall of tools.
SSIS · Python · APIs
SQL Server & reporting architecture
Scalable schemas, reusable views, stored procedures and normalized structures that make data secure and analysis-ready.
Power BI & decision experience
Data models, DAX measures, KPI reporting and interactive dashboards designed around the questions stakeholders actually ask.
Automation & intelligent logic
Python, machine learning and agentic AI or LLM-enabled workflows used thoughtfully to accelerate automation and business logic implementation.
Experience
Working across ingestion, modeling and reporting.
My practical focus is building a dependable path from operational data to useful decisions.
Business Intelligence & Data Analyst Intern
Habib University
- Engineer automated SSIS and Python ETL pipelines for incremental extraction from the LMS and multiple applications.
- Develop SQL views, stored procedures and scalable schemas that provide secure, ready-to-use departmental access.
- Design and deploy Power BI dashboards that support cross-functional planning and data-backed decisions.
Delivery process
A simple path from unclear data to a trusted decision product.
The process keeps business questions, data quality and the final user experience connected from the beginning.
Frame the decision
Clarify who needs the answer and what action should follow.
Map sources
Understand systems, ownership, refresh needs and constraints.
Build & validate
Automate ingestion and stop weak records before publishing.
Model for reuse
Structure SQL and measures around stable business logic.
Design the decision
Present the right level of detail and iterate with users.
About
Technical thinking with visual discipline.
The section heading stands on its own. The story and education cards begin underneath it, so the hierarchy stays clear at every screen width.
I am a BI & Data Analyst based in Karachi, engineering production-grade data systems. My practical expertise lies in building automated ETL pipelines, enterprise SQL architectures, clear reporting, and analytics applications that simplify complex workflows.
My diploma in animation, visual effects and multimedia strengthens how I structure information and communicate systems. The goal is not decoration—it is clarity, hierarchy and a smooth path to the next decision.
I am open to full-time, on-site, hybrid, remote, freelance and defined-project opportunities in Pakistan and internationally.
Full-time rolesRemote / hybridBI & dashboardsData engineering projects
Bachelor in Data Science
Ziauddin University, Karachi
Diploma in Animation, Visual Effects & Multimedia
NED University of Engineering & Technology, Karachi
HEC Equivalency — Pre-Engineering
Board of Intermediate Education, Karachi
Contact
Tell me what needs to move forward.
The complete form and send button are kept in one compact view on common laptop screens.
Send a focused inquiry
Choose the closest intent, add the essential context and send.