Muhammad Abdullah Janjua | Data & AI Professional

About Me

I build end-to-end data solutions, spanning data engineering, analytics, machine learning, and AI-powered applications. My foundation is designing scalable, reliable data systems that make data accessible, trustworthy, and ready for any downstream use, whether that is a dashboard, a predictive model, or an intelligent application.

My work covers the full data lifecycle. I design and build ETL/ELT pipelines, model data for analytics, perform exploratory analysis, and develop and deploy machine learning models. I deliver insights through dashboards and APIs, working comfortably across the roles of data engineer, data analyst, data scientist, and AI engineer depending on what the problem demands.

I have hands-on experience with Generative AI and AI engineering, including LLM-based applications, LangChain pipelines, vector databases, and agentic AI workflows integrated with both structured and unstructured data sources. This allows me to connect traditional data infrastructure with modern AI systems in ways that are practical and production ready.

I am proficient in Python, SQL, cloud data platforms, machine learning workflows, and data visualization. Across every engagement, my focus is the same: building solutions that are scalable, maintainable, and aligned with real business and research outcomes.

View Projects My Skills

My Projects

MedAssist Insight

Built an end-to-end Generative & Agentic AI pipeline in Python to process unstructured medical lab reports using OCR, NLP, and ETL workflows. Designed a RAG-based knowledge retrieval system and deployed an interactive Streamlit app for real-time insights.

Demo GitHub

End-to-End News Analytics ETL Pipeline

Designed a complete ETL pipeline to extract news articles, clean & normalize text, generate embeddings, perform clustering and classification, and create analytics-ready datasets for sentiment, keywords, and locations.

GitHub

Media Sentiment & Regional Insights Dashboard

Built interactive Power BI dashboards on top of the NLP data pipeline to analyze news sentiment trends by category, location, and time, enabling exploratory and comparative analysis.

Demo GitHub

Company Atlas

Built an end-to-end data & ML pipeline in Python with scalable ETL workflows using Polars & PySpark. Applied NLP and unsupervised learning to generate company clusters and deployed an interactive Streamlit app for cluster visualization & analytics.

Demo GitHub

Data Science Analysis on Factors Affecting 1st SGPA

Collected real-world data from students via Google Forms and performed cleaning and preprocessing using Python, Pandas, and NumPy. Conducted statistical analysis and EDA with Seaborn and Matplotlib in python to extract insights, then trained a Machine Learning model to predict student GPA. Built a dashboard based on insights extracted from data analysis on tableau. Developed and deployed a Flask-based web app on Vercel, enabling real-time GPA predictions through an interactive user interface.

Demo GitHub

Sales Dashboard

Designed professional sales dashboards in Google Looker Studio, Tableau and IBM Cognos to visualize key metrics, enabling data-driven business insights and reporting.

Demo Github

Maze AI

Utilized and implemented different AI search strategies in python, so a computer could solve a Maze, blindly.

GitHub

Classic Game Arcade

Designed and implemented a modular gaming arcade in Python, developing multiple Python-based games and integrating them into a unified system with a menu-driven interface for seamless gameplay selection.

GitHub

Skills & Expertise

Data Engineering

Expertise in designing scalable ETL pipelines, data warehousing, data integration, and big data processing. Skilled in handling large datasets, ensuring data quality, and building analytics-ready pipelines.

ETL Data Pipelines SQL NoSQL Polars PySpark Pandas Data Modeling

AI Engineering

Skilled in building end-to-end AI pipelines, generative AI, agentic AI, and LLM-based solutions. Experienced in NLP, embeddings, RAG systems, and deploying interactive AI applications.

LangChain LLMs Generative AI Agentic AI NLP PyTorch Transformers RAG Streamlit

Python Programming

Advanced Python development with expertise in data manipulation, statistical analysis, and automation. Proficient in comprehensive data science libraries and big data processing frameworks.

Pandas Polars PySpark NumPy SciPy Matplotlib Seaborn Plotly Scikit-learn

Machine Learning

Comprehensive ML expertise using Scikit-learn library. Building and deploying predictive models with advanced algorithms for classification, regression, and clustering.

Scikit-learn Classification Regression

SQL

Expert in SQL for complex data extraction, transformation, and analysis. Experience with data warehousing, ETL processes, and database optimization.

MySQL PostgreSQL ETL

Data Visualization

Creating interactive dashboards and compelling visualizations using Power BI, Looker Studio, and Python libraries (Matplotlib, Seaborn, Plotly).

Matplotlib Seaborn Power BI Google Looker Studio Tableau IBM Cognos

Excel & Analytics

Advanced Excel skills for data analysis, pivot tables, VBA automation, and business intelligence. Creating dynamic reports and dashboards.

Pivot Tables VBA Power Query

Statistical Analysis

Strong foundation in statistical methods, hypothesis testing, A/B testing, and experimental design. Translating data insights into actionable recommendations.

Hypothesis Testing A/B Testing Regression

Exploratory Data Analysis

Comprehensive EDA skills for uncovering patterns, detecting anomalies, and understanding data distributions. Creating insightful visualizations and statistical summaries.

Data Profiling Correlation Analysis Outlier Detection

Data Science Tools

Proficient in industry-standard tools and platforms including Google Colab, Kaggle, Jupyter Notebooks, and Git for collaborative data science projects.

Google Colab Kaggle Jupyter Git Github

Hello, I'm
M. Abdullah Janjua

About Me