
Muhammad Ali Saleem
Based in: Lahore, PakistanMost recently: Intern – Data Analytics, Systems Limited
Experience

Intern – Data Analytics
Summary
What I did
- Engineered SQL queries and stored procedures using SQL Server Management Studio (SSMS) for advanced data extraction, transformation, and performance tuning
- Designed robust ETL pipelines, enabling seamless integration of data from multiple heterogeneous sources
- Gained hands-on experience with Snowflake AI Data Cloud
- Built a scalable data warehouse architecture to support centralized reporting, historical data analysis, and improved data governance
- Developed interactive Power BI dashboards to deliver actionable insights and visual analytics to stakeholders
- Utilized Azure Data Studio, DAX, and Microsoft Excel for data modeling, profiling, and cleansing to ensure data accuracy and reliability
- Participated in performance optimization, pipeline debugging, and real-time issue resolution across large datasets
Results
- Resolved critical data inconsistency issues across enterprise reporting workflows by identifying and fixing mismatched filtering logic and duplicate records in ETL pipelines.
- Optimized SQL query performance for datasets exceeding 1M+ records, reducing execution times from several minutes to near-instant responsiveness.
- Ensured 100% data alignment across downstream Power BI dashboards, restoring stakeholder trust in analytics outputs for critical decision-making.
Skills
Technical
Areas of expertise
Projects
Career Assistance Platform
Real-time Speed Detector
Scalable Data Engineering & BI Solution for Retail Analytics
Upwork Job Scoring Chrome Extension
Education

Bachelor of Science - BS Data Science
Recognition
Awards
Galactic Problem Solver
Certifications
IBM AI Developer Specialization
Fundamentals of Machine Learning
Google Data Analytics Specialization
Feature Engineering for Machine Learning
Google Business Intelligence Specialization
Intro. to Deep Learning with PyTorch
Python for Data Science, AI and Development
Working with the OpenAI API
SQL
Introduction to AI Agents
Prompt Engineering with the OpenAI API
Q&A
In Muhammad’s own words.
What's the most counterintuitive lesson you've learned as a Data Engineer?
That not all bugs are structural. I once spent hours debugging a logically perfect ETL pipeline only to realize the issue was temporal—a mismatch between event-time and processing-time. It taught me that in data systems, understanding the 'when' is just as critical as the 'how'.
How do you approach architecting real-time decision systems?
I start by identifying bottlenecks in the data ingestion and freshness pipeline. Before looking at models or dashboards, I inspect latency, transformation layer efficiency, and the trade-offs between data consistency and speed. My goal is to ensure the system is making decisions on fresh reality, not stale data.
How do you balance event-time vs processing-time in data architecture?
It's a trade-off between correctness and responsiveness. Event-time is the source of truth for analytics and reporting, ensuring late-arriving data doesn't distort historical reality. Processing-time is for operational triggers like fraud detection, where acting on the current system state is more critical than waiting for perfect synchronization. A mature architecture separates these layers to serve both needs.
How do you handle conflicts between statistical signals and business intuition?
I view 'intuition' as context-rich system knowledge. When a statistical signal conflicts with intuition, I follow a layered validation process: trust the signal as a detection of change, then verify it against business context (campaigns, deployments, upstream logs). The goal is to classify the event as a true anomaly, expected behavior, or a known change, rather than just reacting to a binary alert. This prevents both alert fatigue and silent failures.
How do you decide when a system should act autonomously versus when it should involve a human?
I draw the line using a framework of risk, reversibility, and observability. A system should act autonomously when the risk is low, confidence is high, and the action is easily reversible (e.g., auto-scaling or reranking recommendations). It should 'flash a yellow light' when there is moderate risk or missing context, surfacing the issue for human interpretation. Finally, for high-consequence, low-reversibility actions like clinical interventions or financial transfers, the system should never act alone, as accountability and context are paramount. The ultimate deciding factor is 'expected regret'—if being wrong is catastrophic, a human must be in the loop.
Social impact & activities
Community Engagement Volunteer
Supported planning and execution of community events, coordinating volunteers, logistics, and sponsor interactions to foster collaboration and learning.
Deputy Head – Line Following Robot
Co-led the launch and management of SOFTEC’s robotics competition, overseeing planning, track design, participant coordination, and event execution.
What drives the work
Motivations
- Designing end-to-end intelligent systems where data, infrastructure, and AI work as a unified architecture
- Creating 10x value through system-level leverage rather than local performance gains
- Solving high-stakes, context-dependent problems in domains like healthcare operations
Objectives
- AI / Data Solution Architect
- Designing unified architectures for data, infrastructure, and AI models
- Moving from building components to designing entire AI-powered systems
Muhammad's twin is AI, it can make mistakes.
More people on Kanvis
Wasif Ahmed
Lahore
Electrical Engineering Student at LUMS | AI Research & Leadership
Python · PyTorch · Quantization · QAT/PTQ
kanvis.me/wasif-ahmed
Muhammad Safwan Ahmad Saffi
Lahore
AI Engineer | Agentic Systems Specialist | 4x Hackathon Winner
Python · GitHub · LangChain · RAG
kanvis.me/muhammad-safwan-ahmad-saffi
Ayesh
Karachi
Agentic AI Engineer | Building Production-Grade, Reliable LLM Systems
Agentic LLM Systems · Python · Claude Code · Cursor
kanvis.me/ayesh
Muhammad Wali Ahmad
Lahore
High-achieving Software Engineer and Microsoft Gold Student Ambassador specializing in .NET and AI-driven platforms.
C# · HTML/CSS · Web API · Git
kanvis.me/muhammad-wali-ahmad



