Most of my work looks like that: finding the quiet fault underneath the visible problem.
Business first, then the data
Adnan's route into tech was business analytics. He studied it at the University of Central Punjab from 2022 to 2026, and finished with a Grade A. His courses covered business databases, statistics and AI. He did Power BI and SQL projects on sales, HR and industry data. One of his last projects there used BPO data to study burnout and staff turnover.
That route still shapes how he works. In his words: "I start with the business question and work back to the data."
More than lectures
In 2023 he joined UCP's boot camp for data analytics. From October 2024 to July 2025 he was Deputy Director of UCP Bizlytics, a student society. He was also event head for the Business School's annual farewell ceremony.
Outside class, he volunteered with Al Khidmat Foundation in Lahore during Ramadan 2025. He also studied Chinese up to HSK 1, the first level of the standard Chinese test.
A camera that finds parking spaces
From January to May 2025, Adnan worked as an AI engineer on a parking prototype. It watched live camera feeds and spotted which spaces were empty and which were taken. He labelled the training images in Roboflow and trained YOLO models on them. The system read number plates with OpenCV and OCR, and shared out spaces across floors.
That spring he also interned remotely with Excelerate as a data analyst. He analysed customer data with Excel, SQL, Python and Tableau, and built dashboards from the results. In July 2025 he earned a certificate in big data analytics from NAVTTC, Pakistan's national body for skills training.
A year as a freelancer
From August 2025 to July 2026, Adnan worked on Upwork as a freelance data analyst and BI developer. A few jobs from that year:
- The slow import. The XML import at the top of this page, in December 2025. The query plans showed two text types, VARCHAR and NVARCHAR, being compared. That forced the database to scan whole indexes. He matched the data types, rewrote the slow queries and added targeted indexes.
- A sales dashboard. Built in Power BI, it drills down by region, sales rep and period, and tracks each rep against target. It saved the client more than 15 hours of manual reporting a week.
- A budget check. It sets the budget against actual spending for six cost centres, with no sums done by hand. Reporting that took days now takes hours.
- Reports that run themselves. One automated report saved a client about 10 hours of manual work each week.
What he does now
At Noviq IT Solutions, Adnan leads the engineering. He builds websites and web apps, and sets up GA4 so clients can see where enquiries come from. He designs data models in SQL and Power Query, then builds Power BI and Looker Studio reports on top. He also automates Excel workbooks and handles the technical side of SEO and AI search. With Abdullah, he hires and runs the delivery team.
Before any guide or service page goes live here, Adnan checks the technical facts in it. His everyday tools are Power BI (DAX and Power Query), SQL Server, Python, R and Excel.
Guides he reviewed
- How much does website development cost in Pakistan in 2026?Market prices, our prices and the yearly costs to plan for.
- How much does SEO cost in Pakistan in 2026?What a monthly fee should cover, and the offers to avoid.
- Local SEO in Lahore: a step-by-step guide for businessesSeven steps to show up on Google Maps.
- GEO vs SEO vs AEO: what is the difference?Three terms, side by side.
- What is llms.txt, and does your website need one?What the file does, and what it doesn't.
If your reports disagree with each other, or nobody trusts the numbers, Adnan would like to hear about it. You can find him on LinkedIn (opens in a new tab).


