Power BI Data Analytics Professional

Menbere Worku

Power BI Data Analyst Microsoft Certified

702-***-**** *********@*****.*** www.linkedin.com/in/menbere-worku-06071a2a8 Summary

Detail-oriented Data Analyst with over 6 years of experience in Collecting data, transforming data, data modeling, and advanced analytics into actionable insights. Proficient in statistical analysis, data visualization and predictive modeling. Skilled in SQL and Tableau with a proven ability to collaborate with cross-functional teams to drive business decisions. Strong expertise in DAX, Power Query, SQL and data warehousing with a track record of improving reporting efficiency and supporting data-driven decision making.

Skills

• Programming Languages: SQL, Python (Pandas, NumPy, Statistical model), API

• Data Analytics: Tableau, Power BI, Looker, Snowflake, Advanced Excel (VLOOKUP, if statements, DAX, Pivot Table, Sorting, Power query editor).

• Databases: Microsoft SQL Server, MySQL, Relational and Hierarchical.

• Data Integration & ETL (SQL Server Integration Services, Power Query (M Language))

• Cloud Platforms: Google Cloud Platform (Big Query, Dataflow, Cloud SQL, Cloud Storage), Azure.

• Statistical Methods: Predictive Analysis, Hypothesis Testing, Chi Square Test.

• Other Software and Tools: SSMS, SSRS, GitHub, SharePoint, Microsoft Word, PowerPoint, Microsoft Office, Agile and Jira.

Professional Experience

BNY Mellon New York city

Data Analyst June 2024 -Present

• Worked with business stakeholders to understand their business needs and define metrics

• Worked with Data Engineers to develop ETL pipelines, collect required datasets, and solve business problems using various data sources (Database, Datawarehouse, API, flat files)

• Cleaned messy datasets in Excel and reduced data errors by 30%

• Analyzed current state SQL queries that generates current reports, documented that logic in pseudo codes to make better understanding to technical folks for documentation

• Involved in querying data using SQL and creation of database objects like tables, views, procedures, triggers, and functions to provide definition, structure and to maintain data efficiently.

• Collaborated with cross-functional teams to define KPIs, set up tracking codes, implemented A/B testing, resulting in improved conversion rates and enhanced user experience.

• Developed and optimized data processing pipelines using Apache Spark, significantly reducing data processing time from hours to minutes.

• Utilized Spark for executing SQL queries on Spark data frames, ensuring smooth integration of SQL with Spark for comprehensive data analysis and manipulation. Menbere Worku

Power BI Data Analyst Microsoft Certified

702-***-**** *********@*****.*** www.linkedin.com/in/menbere-worku-06071a2a8

• Cleaned and transformed raw datasets in Microsoft Excel and SQL, improving data accuracy by 30%

• Removed duplicates, handled missing values, and standardized data formats to ensure reliable analysis

• Conducted data/statistical analysis, developed tableau workbooks on monthly and quarterly basis for all the transactional data from U.S, UK and Ireland Markets using Tableau and Power Bi

• Worked extensively with Calculations using Actions, Parameters, Background images and Maps. Created trend lines, Groups, Hierarchies and sets to create detail level summary Dashboard / Reports using both Tableau & Power BI. Ford Motor Company Detroit, MI, USA

Data Analyst September 2021 - April 2024

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional workflow of information from source systems to destination systems

• Built a Sales Performance Dashboard tracking revenue, profit, and top products using Power BI

• Worked with elicit requirements, facilitated and coordinated discussion between business and technical team to clarify business, functional, non-functional and Data requirements.

• Worked with Data Management team to analyze sales Data using tools like SQL, Access, Excel (Lookups, Pivot tables) and predicting any future impacts on business.

• Collected large financial data sets in Microsoft Excel and Access and created reporting for senior management.

• Analyzed current state SQL queries that generates current reports, documented that logic in pseudo codes to make better understanding to technical folks for their technical requirement documentation.

• Performed root cause analysis on product shortages by analyzing supply trends, inventory, and demand data using Spark SQL and Databricks notebooks.

• Utilized Tableau to create various analytical dashboards that helps business users to get quick insight of the data.

• Leveraged Spark Data Frames and RDDs for distributed data processing, ensuring efficient data manipulation and analysis.

• Spearheaded the implementation of Apache Hadoop ecosystems for large-scale data processing and storage. Achieved a 30% improvement in data processing speed, optimizing performance for vast datasets.

• Worked extensively with Calculations using Actions, Parameters, Background images and Maps. Created trend lines, Groups, Hierarchies and sets to create detail level summary Dashboard / Reports using both Tableau & Power BI.

• Designed and developed advance analytics dashboards to showcase KPI’s and various Key metrics for the Business Development departments by working closely with both internal and external Data Science teams

Menbere Worku

Power BI Data Analyst Microsoft Certified

702-***-**** *********@*****.*** www.linkedin.com/in/menbere-worku-06071a2a8

• Implemented Key Performance Indicator (KPI) Objects, Actions, Hierarchies and Attribute Relationships to measure the performance of an organization, department and project

Sephora San Francisco, California, USA

Data analyst / BI analyst June 2019- March 2021

• Collecting Data: Collating and cleaning structured and unstructured data and organizing data into usable formats in relational databases like Snowflake and SQL Server.

• Building Predictive Models: Applying prediction techniques like Regression Analysis, Time Series Modelling to forecast revenue and generate relevant insights for executive use.

• Creating clustering models to identify customer segments, revenue classes, and campaign buckets for improving spending strategies.

• Verifying integrity of data: Conducted weekly review of data ingestion pipelines to ensure accuracy, validity, and format of incoming data to enable accurate downstream analysis.

• Preparing Reports: Created reports with engaging and informative visualizations with Tableau to present analysis conclusions to executive teams, enabling data driven decision making at all levels.

Education

• Bachelor of Science in Computer Science

Unity University, Ethiopia

Certifications

• Microsoft Certified: Power BI Data Analyst Associate

• Issued: 2026

• Credential ID: 8A401DD55CA3EB59

Contact this candidate