Umar's Portfolio

About Me

"I'm Umar, a data analyst and business strategist passionate about turning raw data into meaningful insights. With hands-on experience in tools like Python, SQL, Power BI, and Excel, I’ve solved real-world problems across domains like e-commerce, sales, finance, and healthcare. I integrate AI tools like ChatGPT, Claude, Gemini, Deepseek, QuadraticHQ and Copilot into my daily workflow to work smarter and faster—whether it’s generating ideas, accelerating reporting, or streamlining code. Earlier in my journey, I strengthened my problem-solving mindset by consistently practicing data structures and algorithms in Java, which helped build my logical foundation."

Before diving deep into data, I began by exploring frontend web development—building projects with HTML, CSS, JavaScript, Bootstrap, and Tailwind. That phase taught me the value of structure, usability, and design, which now help me create user-friendly dashboards and reports in analytics.

Since then, I’ve developed full-fledged analytics solutions, automated ETL processes, built dynamic dashboards, and shared data-driven recommendations with measurable business impact.I'm deeply curious, continuously improving, and committed to making a meaningful impact through data.
-> I may not know everything, but I’m relentless when it comes to learning, growing, and improving every day.
-> Outside the data world, you’ll often find me exploring new places, sipping on a warm cup of tea, and staying curious about how technology continues to reshape our lives.

Data Analytics Projects

Vendor Performance Analysis

Retail/wholesale company was struggling with unsold inventory and vendor inefficiencies. I built a full analytics pipeline where I analyzed vendor purchases, sales, inventory & profitability to support strategic purchasing & inventory decisions. (Python, SQL, Power BI)

Click to see

Walmart Sales Insights

I explored Walmart’s sales data to uncover trends in customer behavior, top-selling products, and peak sales hours. From building a SQL-backed database to creating new features and visual insights, the project answers key questions that help optimize marketing, inventory, and profit strategies.

Click to see

Personal Expense Tracker — Automated Excel Dashboard

Solves the problem of manual, fragmented personal finance tracking by centralizing income/expense logs, automating calculations, and providing interactive visual dashboards for better budgeting.

Click to see

Real-Time Weather & Air Quality Intelligence System

Built a real-time, API-powered Power BI solution to integrate multi-city weather and air-quality data, delivering live KPIs and predictive trends for analysts, students, and operational monitoring..

Click to see

Credit Card Financial Reports

Developed a real-time Power BI dashboard for a multi-card financial services provider, unifying weekly insights on customer behavior, revenue, and card performance. Enabled data-driven decisions to boost revenue growth, reduce delinquency, and optimize geographic strategies.

Click to see

Coffee Startup Sales Analysis

Used MS Excel to analyze sales trends and customer behavior from a coffee shop dataset. The dashboard highlights peak hours, best-selling products, and revenue trends—helping store owners make smarter decisions on timing, pricing, and product focus.

Click to see

MGH Hospital Boston: Healthcare Analytics

Delivered a high-level KPI dashboard using synthetic data ( 1K patients, 28K encounters, 48K procedures) to enable MGH leadership to track admissions, insurance coverage, LOS, and financial metrics for strategic decision-making

Click to see

Target E-commerce Analytics (U.S. Retail Giant)

Target Brazil needed clarity on customer behavior and sales trends. I built a complete analytical solution using SQL, Python, and Power BI by unifying fragmented data, delivering actionable insights on customers, sales, products, and operations to drive strategic decisions.

Click to see

Frontend Projects

Currency Converter

A dynamic currency converter using HTML, CSS, and JavaScript, leveraging an API to provide real-time exchange rates.

Click to see

Tic Tac Toe

Interactive Tic Tac Toe game implemented with HTML, CSS, and JavaScript for a fun and engaging user experience.

Click to see

Amazon Clone

Replica of Amazon.in website created with HTML and CSS, showcasing product listings and a user-friendly interface

Click to see

Calculator

Functional calculator application built with HTML, CSS, and JavaScript for basic arithmetic operations.

Click to see

Certifications

Data Analytics with Python || IIT Roorkee (Elite + Silver Badge)

Completed this government-recognized online course with an offline proctored exam, earning Elite + Silver certification by excelling in data wrangling, visualization, and statistical analysis using Python.

Credentials

Data Analytics || {30}DaysCoding

I've successfully completed certification in data analytics from {30}DayaCoding mentored by Aryan Singh (Google) & Deepanshu Udhwani (ex-MakeMyTrip). We focused on Python, SQL, Excel, Power BI, Prompt engineering and AI tools along with their implementation through projects.

Credentials

Certified in Database Systems || IIT Madras (Elite + Silver Badge)

Completed this rigorous course with an offline proctored exam and ranked among the top 1% nationwide. Gained expertise in SQL, ER modeling, relational algebra, normalization, and transaction management.

Credentials

Fundamentals of OOPs || IIT Roorkee

Successfully cleared this government-accredited course with offline evaluation. Demonstrated strong grasp of OOP principles such as inheritance, polymorphism, abstraction, and encapsulation mainly using C++/Java.

Credentials