Data Analyst with 1+ years in SQL, Power BI & Data Cleaning
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Data Analyst with proven experience in data cleaning, SQL querying, Power BI dashboards, and KPI reporting for business decision-making. Adept at analyzing large datasets to identify trends, patterns, and actionable insights to support business decisions. Skilled in developing and maintaining interactive dashboards, automating reports, and collaborating with stakeholders to deliver data-driven solutions.
National University of Modern Languages, Islamabad, Pakistan
Bachelor of Science in Computer Science (BSCS) · Computer Science
August 1, 2019 – June 30, 2023
SOFTOO Pvt.
Junior Software Engineer
October 1, 2023 – February 1, 2025
India
Bytewise Limited
Junior Software Engineer (Remote)
December 1, 2022 – March 1, 2023
India
STOCK MARKET TREND FORECASTING
June 1, 2026 – Present
Developed a stock market trend forecasting model for the Pakistan Stock Exchange (PSX) using Machine Learning (Multiple Linear Regression). Collected and preprocessed stock market historical data including Open, High, Low, Close, Volume, and engineered multiple regressors for prediction. Performed data cleaning and transformation (handling missing values, outlier detection, normalization/scaling) to improve model performance. Conducted Exploratory Data Analysis (EDA) to identify price patterns, volatility trends, and correlations between stock indicators. Built and trained a multiple regression-based forecasting model to predict stock closing prices and market trends. Applied feature selection and multicollinearity checks to enhance model reliability and reduce redundant predictors. Evaluated model performance using statistical metrics such as R² Score, Mean Absolute Error (MAE), and Mean Squared Error (MSE). Visualized actual vs predicted trends using line charts and regression plots for better business understanding. Delivered actionable insights on market trend movement to support investment decision-making and risk analysis.
Healthcare Data Analytics for NHS UK
June 1, 2026 – Present
Gathered and cleaned large volumes of healthcare data from various sources including Electronic Health Records (EHR), hospital management systems, and public health datasets. Performed ETL processes to convert raw datasets into analytical-ready formats using Python (Pandas, NumPy) and SQL. Identified trends in-patient admissions, discharge rates, disease prevalence, and A&E (Accident & Emergency) wait times using statistical and visual techniques. Created interactive dashboards and reports using Tableau and Power BI to communicate KPIs such as bed occupancy rates, treatment outcomes, and staffing efficiency. Assisted in building forecasting models to predict patient influx and resource demand using time-series analysis in Python. Worked closely with data scientists, NHS stakeholders, and clinical staff to translate analytical insights into operational recommendations.
NEW YORK CITY Taxi Trips Dashboard
June 1, 2026 – Present
Collected and analyzed NYC Taxi Trips dataset and identified key business requirements for dashboard reporting. Performed data cleaning and transformation using Power Query, including datatype conversion, null handling, validation of trip duration and coordinate values. Created derived date and time features (Date, Time, Hour, Weekday, Month, Week Number) to enable time-series analysis. Built a structured star schema data model by designing fact and dimension tables (Date, Hour, Vendor) and establishing optimized relationships. Developed calculated columns such as Trip Duration (Minutes), Duration Category, Hour of Day, and Day Type (Weekday/Weekend) for segmentation and analysis. Implemented key DAX measures for KPIs including Total Trips, Total Passengers, Average Trip Duration, Max Daily Trips, and Average Trips per Day. Designed an interactive dashboard with KPI cards, time trend visuals, vendor comparisons, passenger analysis, and trip duration distribution charts. Developed geospatial visualizations (pickup and drop-off maps) to identify location-based trip patterns and hotspots.
Microsoft: Introduction to Python
Microsoft
June 1, 2026 – Present
Microsoft Power BI from Coursera
Coursera
June 1, 2026 – Present
Microsoft Certified: C# Programming for Developers
Microsoft
June 1, 2026 – Present
IBM Data Analyst Certificate (with SQL)
IBM
June 1, 2026 – Present
C++ Certified Professional Programmer
Unknown
June 1, 2026 – Present
Cultural Fit Analysis
The candidate's project diversity, ranging from stock market forecasting to healthcare analytics and taxi trip dashboards, indicates a broad interest in applying data analysis across different domains. Their experience as a Junior Software Engineer, despite the target role being Data Analyst, shows adaptability and a willingness to learn new technologies and roles. The certifications in Python, Power BI, and SQL align well with a data-centric role. However, the C++ and C# certifications seem less relevant to a pure Data Analyst role, potentially indicating a broader but less focused skill set for this specific target role. The experience level (1 year) suggests they are still early in their career, which might require more mentorship in a senior role.
Soft Skills & Operational Fit
The candidate demonstrates strong analytical and problem-solving skills through their project work, particularly in identifying data quality issues and implementing solutions. Their experience in collaborating with stakeholders and translating insights into recommendations suggests good communication and teamwork abilities. The automation of reporting tasks indicates an efficiency-oriented mindset. However, the resume does not provide explicit details on stress handling or direct team collaboration experiences beyond 'working closely with' or 'collaborating with', which limits a deeper assessment of operational fit.