Hoor Ismail

Hoor Ismail Gulshan-e-Iqbal, Karachi Phone: - | Email:-LinkedIn: https://www.linkedin.com/in/hoor-ismail/ Professional Summary Results-driven Data Analyst with hands-on experience in Excel, SQL, Power BI, and Python. Proven ability to deliver actionable insights through data visualization, data cleaning, and analytical techniques. Passionate about using data to solve real-world problems and support strategic business decisions. Strong project portfolio demonstrating practical expertise in business intelligence and analytics. Completed a specialization in Data Analytics from DIGITAL HUSTLERS PAKISTAN. Skills - Data Analysis: Excel, SQL, Power BI, Python (Pandas, NumPy, Matplotlib) - Data Visualization: Power BI, Excel Dashboards - Database Management: SQL querying, relational database concepts - Programming: Python (data cleaning, analysis, and visualization) - Reporting & BI: KPIs, Variance Analysis, Cost Analysis - Soft Skills: Critical thinking, problem-solving, communication, attention to detail Project Portfolio Microsoft Excel Projects • EU SuperStore Analysis – Analyzed sales patterns, customer behaviors, and product performance. • Zomato Company Analysis – Analyzed geographical cuisine popularity, top-rated restaurants, and city-wise trends. • Sales Dashboard (Supermarket) – Monitored KPIs, top products/categories, and payment methods over two years. • UK Road Accident Analysis – Assessed accident trends by location, severity, surface type, and vehicle involvement. • Bank Loan Report Analysis – Built dashboards to track loan KPIs, distinguish good/bad loans, and evaluate trends. • Ecommerce Sales Analysis – Visualized total sales, profits, quantities sold, and profit margins for e-commerce. Power BI Projects • IT Spend Analysis (2 Projects) – Tracked actual vs. forecasted IT spend across departments and regions. • ATM Transaction Analysis – Evaluated ATM network performance, revenue, costs, and uptime analysis. • Mobile Sales Data Analysis – Analyzed sales trends, customer reviews, and top-performing brands/models. Python Project • Customer Churn Analysis (Telecom) – Identified churn factors using customer data. Highlighted churn rate of 26.54% with deep dive into demographics and services. SQL + Power BI Projects • OLA Ride Data Analysis – Extracted and visualized data for bookings, cancellations, revenue, and feedback. • Pizza Sales Dashboard – Identified best-selling pizzas, peak sale periods, and order trends by category and size. Education Masters in Islamic History Karachi University, Karachi Relevant Courses: Data Analysis, Python Programming Certifications Available on LinkedIn: https://www.linkedin.com/in/hoor-ismail/details/certifications/