Data Analyst - SQL, Python, Power BI, Excel

Muhammad Asaad Areeb

Lahore, Punjab, Pakistan

*************@*****.*** +92-322-******* LinkedIn GitHub PROFESSIONAL SUMMARY

Data Analyst with hands-on experience in SQL, Python, Excel, and Power BI across manufacturing, sales, and mar- keting reporting environments. Skilled in consolidating data from ERP systems, CRM platforms, spreadsheets, and databases to build dashboards, automate reporting, and support forecasting for operational and commercial decision- making.

TECHNICAL SKILLS

Languages: SQL, Python, R

Visualization & BI: Power BI, Tableau, Excel, Power Query, SPSS Big Data: Hadoop, Spark

Databases & Systems: SQL Server, PostgreSQL, ERP systems, Zoho CRM, Odoo, QuickBooks Analytics & Methods: Data cleaning, data transformation, exploratory data analysis, dashboarding, forecasting, time-series analysis

Libraries: Pandas, NumPy, Matplotlib, Seaborn, Scikit-learn Tools: Git, GitHub, AWS, GCP

PROFESSIONAL EXPERIENCE

Data Analyst - Denim Loom Jan 2025 – Present

Lahore, Punjab, Pakistan

• Built and maintained internal dashboards for HR, procurement, warehouse, production, and sales functions, im- proving visibility into operational performance across the business

• Consolidated data from Excel sheets, ERP records, CRM data, and internal databases into structured reporting datasets for recurring analysis and dashboard delivery

• Developed Power BI dashboards to monitor production output, inventory movement, procurement activity, employee metrics, and sales trends across denim and garment operations

• Cleaned, validated, and reconciled multi-source data from manually maintained procurement sheets, customer records, employee databases, and operational systems to improve reporting reliability

• Automated recurring weekly and monthly reporting workflows using SQL and Power Query, reducing manual prepa- ration effort and improving consistency in internal reporting

• Built Python-based forecasting workflows to estimate sales and demand trends, supporting planning decisions for production and inventory management

Data Scientist - Technoventures Oct 2023 – May 2024 Lahore, Punjab, Pakistan

• Built internal marketing and sales dashboards for a USA-based education business targeting European students, tracking ad spend, leads, user acquisition, conversions, and revenue performance

• Consolidated campaign and sales data from Facebook, Instagram, WhatsApp, spreadsheets, and internal reporting sources into analysis-ready datasets for recurring business reporting

• Developed reporting views to monitor advertising spend, clicks, new users, client conversions, and sales trends, helping internal teams and client stakeholders evaluate campaign performance

• Performed exploratory analysis on campaign and sales data to identify patterns in user acquisition, conversion behavior, and revenue trends across reporting periods

• Built forecasting workflows in Python and SQL to estimate future revenue and sales trends for upcoming months and quarters, supporting planning and budgeting decisions

• Improved reporting efficiency by automating recurring data preparation and dashboard update processes for internal marketing and sales reporting

PROJECTS

HR Analytics Dashboard GitHub

• Built a Power BI dashboard to analyze workforce composition, promotion readiness, layoff risk, severance eligibility, performance ratings, and employee service years

• Added drill-down views for department-level trends in overtime, job satisfaction, promotion patterns, and rating distribution to support workforce analysis and reporting Shopify Sales & Customer Funnel Dashboard GitHub

• Developed a Shopify analytics dashboard to track net sales, average order value, customer retention, repeat pur- chases, and customer lifetime value

• Created interactive filters by city, province, and payment gateway to analyze regional performance, transaction behavior, and customer funnel trends

Traffic Analysis Dashboard GitHub

• Created a road accident dashboard to monitor casualties, accident trends, vehicle categories, road types, and urban- rural differences

• Enabled comparison of current versus previous year casualty patterns using filters for weather and road surface conditions to highlight high-risk segments

ADDITIONAL EXPERIENCE

Web Developer - Minisoft Sep 2022 – Sep 2023

Remote

• Built web applications using Django, HTML, CSS, and JavaScript for international clients, including API integra- tions and production-ready features

Mobile Application Developer Intern - Hello World Technologies Apr 2022 – Jun 2022 Rahim Yar Khan, Punjab, Pakistan

• Supported mobile application development in React Native with work in UI implementation and API integration EDUCATION

Master’s in Data Science - Information Technology University, Lahore 2024 – 2026 Bachelor’s in Software Engineering - KFUEIT, Rahim Yar Khan 2018 – 2022 CERTIFICATIONS

Mathematics for Machine Learning Specialization - Imperial College London (Coursera) Deep Learning Specialization - DeepLearning.AI (Coursera) Machine Learning - Stanford Online (Coursera)

Contact this candidate