Projects

Coffee Sales Dashboard

In this project I use Excel to create a Dashboard of Coffee Sales and show highlights of Top Countries and Customers. This dataset contained orders, products and customer data.

Data Cleaning in SQL

In this Project I used RAW housing data to transform it in SQL and make it more usable and understandable for analysis.

Currency Converter

In this Project I use Python and a Currency API to convert different currencies and return the converted amount.

New Project Coming Soon!

About Me

Welcome to my portfolio. My name is Mohammed Zubair Omar, I am a dedicated and skilled Business Analyst with a strong background in leveraging data to drive business efficiency and insights. My expertise spans across various industries, where I specialize in data analysis, process automation, and business process improvement.

With a degree in Information Technology and several industry-specific certifications, I have developed a robust understanding of analyzing business processes, optimizing workflows, and creating data-driven strategies. My proficiency in tools like Excel, VBA, and Power Platform enables me to deliver automated reporting systems, custom solutions, and insightful data visualizations.

I am passionate about finding innovative solutions to complex business problems and continuously improving operational efficiency. Whether you're looking to streamline your business processes, automate routine tasks, or gain deeper insights from your data, I am here to help.

Feel free to explore my projects to see some of the work I have done, and don't hesitate to contact me if you have any questions or if you are interested in collaborating on a project.

Thank you for visiting my portfolio.

Skills

Soft Skills:

  • Analytical Thinking
  • Problem-Solving
  • Communication
  • Teamwork
  • Project Management

Technical Skills:

  • Excel (Advanced)
  • VBA (Intermediate)
  • Power Platform (Intermediate)
  • Asset Management
  • Data Visualization (Power BI/Excel Dashboards)
  • SQL (Intermediate)
  • SharePoint
  • Python (Beginner)

Certifications

Certifications:

  • Excel (Beginner - Advanced)
  • Microsoft Certified: PL900 (Power Platform)
  • Microsoft Certified: AZ900 (Azure Fundamentals)

Short Courses:

  • Introduction to Information and Data Management Systems (Regent business School)
  • Introduction to Big Data (Regent business School)

Elements

Text

This is bold and this is strong. This is italic and this is emphasized. This is superscript text and this is subscript text. This is underlined and this is code: for (;;) { ... }. Finally, this is a link.


Heading Level 2

Heading Level 3

Heading Level 4

Heading Level 5
Heading Level 6

Blockquote

Fringilla nisl. Donec accumsan interdum nisi, quis tincidunt felis sagittis eget tempus euismod. Vestibulum ante ipsum primis in faucibus vestibulum. Blandit adipiscing eu felis iaculis volutpat ac adipiscing accumsan faucibus. Vestibulum ante ipsum primis in faucibus lorem ipsum dolor sit amet nullam adipiscing eu felis.

Preformatted

i = 0;

while (!deck.isInOrder()) {
    print 'Iteration ' + i;
    deck.shuffle();
    i++;
}

print 'It took ' + i + ' iterations to sort the deck.';

Lists

Unordered

  • Dolor pulvinar etiam.
  • Sagittis adipiscing.
  • Felis enim feugiat.

Alternate

  • Dolor pulvinar etiam.
  • Sagittis adipiscing.
  • Felis enim feugiat.

Ordered

  1. Dolor pulvinar etiam.
  2. Etiam vel felis viverra.
  3. Felis enim feugiat.
  4. Dolor pulvinar etiam.
  5. Etiam vel felis lorem.
  6. Felis enim et feugiat.

Icons

Actions

Table

Default

Name Description Price
Item One Ante turpis integer aliquet porttitor. 29.99
Item Two Vis ac commodo adipiscing arcu aliquet. 19.99
Item Three Morbi faucibus arcu accumsan lorem. 29.99
Item Four Vitae integer tempus condimentum. 19.99
Item Five Ante turpis integer aliquet porttitor. 29.99
100.00

Alternate

Name Description Price
Item One Ante turpis integer aliquet porttitor. 29.99
Item Two Vis ac commodo adipiscing arcu aliquet. 19.99
Item Three Morbi faucibus arcu accumsan lorem. 29.99
Item Four Vitae integer tempus condimentum. 19.99
Item Five Ante turpis integer aliquet porttitor. 29.99
100.00

Buttons

  • Disabled
  • Disabled

Form