Financial Data Analyst · reconciliation, SQL, Python and Excel · building toward Data Engineering
Lahore, Pakistan · open to remote work and relocation · LinkedIn · adnandanish0404@gmail.com
My day job is reconciliation: matching invoices to payments across 20+ retail and marketplace accounts, finding short payments, duplicates and unapplied credits, and helping automate that work with Python, SQL and Excel.
The projects below are built around the same problems. Where it applies, they validate their input, reject bad rows with a reason, handle money in exact decimals and come with tests. They use generated or public sample data, never data from a client or employer. Where a first version of mine had a bug, the README says what it was.
| Area | Tools |
|---|---|
| Data and SQL | SQL (MySQL, PostgreSQL, SQLite), CTEs and window functions, ETL pipelines |
| Python | pandas, pytest, openpyxl, requests, PySpark |
| Analytics and BI | Excel (Power Query, pivot tables, formulas), Power BI, Tableau |
| Tooling | Git, GitHub Actions, Databricks |
| Project | What it does | Tools |
|---|---|---|
| Dropship Reconciliation Engine | Invoice-to-payment reconciliation written twice, in pandas and in SQL, tested to give identical results. 77 tests. | Python, SQL |
| AR Aging & Collections Analyzer | Ages open invoices into buckets, nets credit memos and overpayments against the oldest debt first, computes DSO. Live-formula Excel report. 33 tests. | Python, SQL, Excel |
| Sales Data ETL Pipeline | Merges messy exports from three systems into a SQL database and an Excel report. Every input row is accounted for. 14 tests. | Python, SQL, Excel |
| PySpark Pizza Analytics | Seven business questions in PySpark, every result checked against pandas. Runs locally. 16 tests. | PySpark, Databricks |
| Payout Reconciliation Report | A formula-driven Excel report of what was paid, what is missing and what doesn't add up. 7 tests. | Excel, Python |
| Weather Data ETL Pipeline | REST API to SQL with retries, validation and safe re-runs. Runs with no key or server. 19 tests. | Python, SQLite |
| Project | What it does | Tools |
|---|---|---|
| Bike Shop Sales & Profitability | SQL and Power BI analysis. Fixed a profit formula that gave an impossible 99.7% margin. | SQL, Power BI |
| HR Attrition Dashboard | Excel dashboard. Found that three pivots counted headcount instead of leavers and corrected the conclusions. 11 tests. | Excel, Python |
| Hospital Database: SQL Practice | 33 practice queries with tests. Fixed a script that didn't run and a query that gave the wrong answer. | SQL, Python |
| Sales Performance Dashboard | Two-page Power BI dashboard on a star-schema model with DAX measures. | Power BI, DAX |
A short index of all projects is in Adnan-Data-Portfolio.