A detail-driven Data Strategist and Systems Engineer with a rigorous foundation in corporate finance. I specialize in translating complex operational datasets into actionable intelligence, building high-performance local data engineering utilities, and securing software workflows.
- π What I Do: Data Analyst & Analytics Specialist specializing in Python, SQL, Power BI, and local-first data engineering tools.
- β‘ Currently Building: Automated data pipelines, issue-tracking scrapers, and SQL performance benchmarks (
data-engine-benchmarks,duck-diff). - π Open Source: Active contributor to data parsing and transformation ecosystems (
sqlglot,ibis-project,scikit-learn). - π± Currently Exploring: Advanced DuckDB optimizations and high-performance local data tooling.
- π€ Open to: Roles in Data Analytics, Analytics Engineering, or Open-Source collaborations.
I actively contribute to the core infrastructure of major Python data ecosystems and machine learning frameworks:
| π Project | π― Domain | π‘ Highlight & Contribution |
|---|---|---|
scikit-learn/scikit-learn |
Machine Learning | Contributed core algorithmic and numerical enhancements to Python's premier ML library (PR #34800). |
tobymao/sqlglot |
SQL Transpiler | Enhanced multi-dialect SQL parsing logic, AST validation, and query transformations. |
ibis-project/ibis |
Portable Dataframes | Resolved complex data manipulation bugs and optimized unified dataframe backend conversions. |
scitex-ai/scitex-io |
AI Infrastructure | Improved AI-driven analytical data pipelines and core developer tooling (PR #166). |
π‘οΈ Adexa | Unit Testing & Security (PR #10)
Context: The AI engine lacked coverage to verify if its automated repair strategies were successfully mitigating SQL injection vulnerabilities.
What I Built: Engineered over 300 lines of comprehensive unit tests intest_repair_strategies.py. Validated the engine's behavior against standard SQL injection patterns to ensure generated code patches meet strict security standards. (Stack: Python, Pytest)
βοΈ py-simple-wrap | Core Implementation & Mocking (PR #199)
Context: The repository required tests for aneasy_sqlutility, but the base module itself was missing from the core directory.
What I Built: Developed the coreeasy_sql.pyexecution module to handlesqlite3connections. Concurrently built the testing suite (test_easy_sql.py), utilizingunittest.mock.patchandMagicMockto isolate the database connection and validate query execution flows without requiring a live local database. (Stack: Python, SQLite3, Pytest, Unittest.mock)
| π Project | βοΈ Stack | π‘ Core Impact & Scope |
|---|---|---|
| KSE-100 Financial Sentiment Analysis | Python (NLTK), Pandas, APIs, Tableau | Built an automated news-scraping pipeline and used NLP sentiment analysis to correlate public news trends with KSE-100 stock price movements. |
| Predictive Modeling of Employee Turnover | Python, Scikit-learn, Random Forest, Tableau | Analyzed HR metrics, engineered classification features, and deployed a tuned Random Forest model to flag employee attrition risk factors. |
| SpaceX Falcon 9 Landing Prediction | Python, SQL, REST APIs, Plotly Dash | Executed end-to-end data collection, wrangling, and multi-model classification (SVM, Logistic Regression) visualized via an interactive web dashboard. |
| Ames Housing Real Estate Valuation | Python, Pandas, XGBoost, Feature Engineering | Trained high-performance regression models handling 80+ features, utilizing log transformations and feature creation to minimize pricing error bounds. |
| Instacart Market Basket Analysis | Pandas, Seaborn, EDA | Processed over 1M records using heavy groupby aggregations to map multi-product associations and user reorder frequencies. |
I design and build high-performance, air-gapped local-first tools for developers and data teams:
- π‘οΈ
repo-doctorβ Automated codebase diagnostic and health-check runner auditing secrets, licenses, and AI-readiness. - π
duck-diffβ High-speed data schema and table diffing utility leveraging embedded DuckDB for massive file reconciliation. - π§Ή
sqlean-lintβ Lightweight local-first SQL static analysis and rule validation engine targeting performance traps. - π
dbt-optimizerβ Compilation analyzer and cost auditor toolkit for dbt core models and DAG dependencies. - β‘
data-engine-benchmarksβ Benchmarking framework evaluating speed, memory efficiency, and throughput across local vs. distributed engines (DuckDB, Polars, Pandas). - π
github-issue-hunterβ Automated search engine and dashboard designed to query, tag, and track high-priority GitHub issues across open-source ecosystems.
- π« Power BI Developer & Instructor | PNY Trainings (NAVTTC) (Feb 2026 β May 2026)
- Engineered and delivered comprehensive technical curriculum in Power BI, SQL, and Python; established best practices for ETL pipelines and advanced data modeling.
- π Junior Data Scientist | Timmy's Pizza (Nov 2023 β Dec 2025)
- Optimized local delivery routes, staffing schedules, and supply chain visibility using Pandas and interactive Power BI dashboards.
- π» Data Analyst Intern | PNY Trainings (Jun 2025 β Present)
- Spearheaded a data-driven marketing analysis for a key e-commerce client, leveraging Power BI and Advanced Excel to project a 15% increase in customer engagement.
- Automated a reporting pipeline using Python (Pandas) and SQL, reducing manual data processing for weekly sales reports by 10 hours per month and improving efficiency by 30%.
- β½ Procurement Intern | Sui Northern Gas Pipelines Limited (SNGPL)
- Analyzed vendor performance metrics for a portfolio of 50+ suppliers, creating KPI dashboards in Excel that contributed to an estimated 5% reduction in procurement costs.
- Streamlined the digital record-keeping process for Purchase Orders, designing a new workflow that reduced document retrieval times by over 50%.
- π Bachelor of Science in Accounting and Finance β Hailey College of Commerce, University of the Punjab
- π IBM Data Analyst Professional Certificate
- π Google Advanced Data Analytics Professional Certificate
- π IBM Data Science Professional Certificate
- π IBM Data Engineering Professional Certificate
- π Google Digital Marketing & E-commerce Professional Certificate
[ Git Push / PR ] βββΊ [ GitHub Actions ] βββΊ [ Linting & PyTest Matrix ] βββΊ [ Deploy / Publish ]
