*

Hamza Belal

Data Analyst

202-***-**** ad1ban@r.postjobfree.com Permanent resident

Career Objective

A dedicated and enthusiastic hard worker looking to improve companies’ performance by utilizing my skills in data analysis and creative problem-solving. Attaining substantial knowledge of SQL and visualization tools such as Power BI & Tableau.

Professional Summary

• Over 3 years of professional experience in data analytics and solutions leading to increased efficiency in organization operations.

• Closely worked with different management levels from Product, Technology, Finance and Marketing Teams to understand the business requirements and analysis needs.

• Attended daily standup meetings to discuss the tasks at hand and weekly meetings to present the status of tasks & reports.

• Expert in writing complex SQL queries, sub-queries, multiple types of JOINs in Oracle, MySQL etc.

• Extensive experience in Extract, Transfer and Load (ETL) processes using MS SQL Server Integration Services (SSIS) for Data migration.

• Experienced in building complex Tableau dashboards with advanced functions to provide insightful analysis.

• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports using Tableau by analyzing sales figures & financial figures.

• Identify growth opportunities and maximize profits.

• Proficient in design and development of various dashboards, reports on Power BI visualizations such as bar graphs, scatter plots, pie charts, maps, funnel charts, lollypop charts, donuts, bubbles, etc. making use of actions and other local and global filters according to the end user requirement.

• Created summary and detail reports with drill down and drills through features using DAX Functions.

• Great leadership qualities and excellent communication skills. Can work independently or within a team, self-motivated, determined, optimistic, and willing to learn new technology. Ability to stay calm in stressful situations and adapt to new surroundings quickly. 2

TECHNICAL SKILLS

Reporting Tools: Power BI & Tableau

Languages: SQL, T-SQL

IDE:SQL Server Management Studio

Databases: MySQL, SQL Server, Oracle

Operating System: Windows & MacOS

Desktop Software: Microsoft Word, Excel, and PowerPoint PROFESSIONAL EXPERIENCE

Target December 2021 – Present Data Analyst

• Worked with Management teams from various departments to translate numbers and facts to inform strategic business decisions.

• Proactively analyze data to answer key questions from stakeholders or out of self-initiated curiosity with an eye for what drives business performance, investigating and communicating areas for improvement in efficiency and productivity

• Proficient in Business Intelligence tools such as Tableau and Power BI for creating dynamic dashboards and reports for various business functions.

• Was able to support management teams with report generation and analysis using visualization on Power BI such as a variety of charts and graphs.

• Expertise in designing and developing filter driven interactive Dashboards, trend based KPIs, summary and detail reports featuring Parameters, Sorting, Expressions, Drill down and Drill through, etc.

• Proficient in design and development of various dashboards and reports on Power BI using Visualizations such as Bar Graphs, Scatter Plots, Pie-charts, Heat Maps, Tree Maps, etc..

• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports using Power BI by analyzing sales figures & financial figures.

• Developed complex calculated measures/columns using DAX languages and Power Query. Proficient in statistics, mathematics, and analytics.

• Used Power BI features to build and configure Hierarchical dimensions, Measure, Calculated Columns, KPI, Filter and Aggregations.

• Created financial reports highlighting areas of sales trends and growth, expenses, and profitability which helped the finance department in making thoughtful decisions.

• Effectively used data blending features in Power BI to connect different databases like Oracle, and SQL Server from primary and secondary sources.

3

• Performed Data Validation, Normalization & Data-Cleansing on multiple data sources to have the highest quality information.

• Used column table expressions (CTE) constraints and complex queries to fetch data servers.

• Experienced in writing SQL and TSQL queries to perform data analysis and data validation.

• Created informative dashboards to showcase the patterns that our customers make purchases in which has helped the marketing team in maintaining all current customers as well as bringing in new customers to the platform.

• Performed yearly analysis and business risks using different line charts.

• Taking existing data from a separate document and inputting it into Excel

• Attended the project review meetings, daily/weekly status meetings and walkthroughs with project managers and leads.

Matson October 2020 – November 2021 Junior Data Analyst

• Worked closely with project managers to understand and maintain focus on their analytical needs, including identifying critical metrics and KPIs, and delivering actionable insights to relevant decision-makers.

• Attended the project review meetings, daily/weekly status meetings and walkthroughs with project managers and leads.

• Utilized Tableau for data intelligence and analysis.

• Effectively used data blending feature in Tableau to connect different databases like Oracle, MS SQL Server

• Great understanding of creating SQL commands such as subqueries, joins, group by etc.

• Established and maintained relationships between tables through the use of Primary and Foreign Keys, ensuring data accuracy and consistency.

• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.

• Built complex Tableau dashboards with advanced functions to provide insightful analysis, identify growth opportunities, and maximize profits.

• Created reports in tableau to understand patterns of successful projects which helped us strategize for upcoming projects.

• Created Financial Reports highlighting areas of Sales growth, Sales Trends, Direct Expenses and Profitability to help the finance department take informed decisions.

• Experienced in creating filters, quick filters, data source filters, global filters, context filters, user filters, actions, and creating Dashboards for key performance indicators. 4

• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to the data that was being analyzed.

• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports using Tableau by analyzing sales figures & financial figures.

• Leveraged Excel to drive data-driven insights for the business. Mueller Industries March 2020 – September 2020 Data Analyst Intern

• Created and maintained rich interactive visualizations through data interpretation and analysis.

• Worked with Management teams from various departments to create departmental KPI reports for marketing, finance, product etc. to translate numbers and facts to inform strategic business decisions.

• Integrating various reporting components from multiple data sources.

• Created reports in Tableau to understand successful project patterns and funding trends.

• Experienced in creating filters, quick filters, data source filters, global filters, context filters, user filters, actions, and creating Dashboards for key performance indicators.

• Created side by side bars, scatter plots, stacked bars, heat maps, filled maps, and symbol maps according to deliverable specifications.

• Used various charts for visualizations like pie charts and line charts, etc.

• Created Financial Reports highlighting areas of Sales growth, Sales Trends, Direct Expenses and Profitability to help the finance department take informed decisions.

• Proficient in design and development of various dashboards and reports on Power BI and Tableau using Visualizations such as Bar Graphs, Scatter Plots, Pie-charts, Heat Maps, Tree Maps, etc..

• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports using Tableau by analyzing sales figures & financial figures.

• Great understanding of creating SQL commands such as subqueries, joins, group by etc.

• Effectively used data blending feature in Tableau to connect different databases like Oracle and SQL Server.

EDUCATION & PROFESSIONAL CERTIFICATIONS

Bachelor of Medicine and Bachelor of Surgery, (MBBS) Khyber Medical College, Pakistan- 2018 Diploma of E-commerce and Digital Marketing, Texas Professional University -2021

Contact this candidate