Data Analyst Power Bi

Maki Ketema

Email: ******.******@*****.*** Phone: 614-***-****

Address: **** ****** ***** **., ********, OH

DATA ANALYST

SUMMARY

Experienced Data Analyst and BI Developer with over 7 years of expertise in data analysis, reporting, and business intelligence. Proven ability to lead the full development life cycle of Power BI projects, including data extraction (ETL), data transformation, and visualization. Skilled in SQL, data warehousing, and data modeling with a strong background in delivering actionable insights to drive business decisions. Adept at working with large datasets, building automated dashboards, and translating complex data into easy-to-understand formats for stakeholders.

TECHNICAL SKILLS

Data Analytics & Visualization Tools: Power BI, Tableau, SSRS, Excel (Advanced), Power Query

ETL Tools & Data Warehousing: SQL Server Integration Services (SSIS), Azure SQL Data Warehouse, Snowflake, and data modeling.

Databases & SQL: T-SQL, MySQL, PostgreSQL, Stored Procedures, Query Optimization, Joins

Programming Languages: Python (Pandas, NumPy), DAX, Data Governance

Cloud Platforms: Azure, Snowflake, AWS

Project Management Tools: Jira, Confluence

Agile Methodologies: Agile, Scrum, Waterfall

Other Tools: Google Analytics, Git, Visual Studio (2012/2016/2019)

PROFESSIONAL EXPERIENCE

Progressive Healthcare Solutions

Data Analyst Power BI Developer

April 2022 – Present

Developed and implemented Power BI dashboards to track key performance indicators (KPIs) and business metrics.

Ensure accurate reporting by verifying data integrity and cross-referencing information from multiple sources.

Prepare and present reports to stakeholders, management, or clients to support their decision-making processes.

Gathered and translated business requirements into data-driven solutions, enhancing operational efficiency and decision-making.

Designed data models and created advanced reports using DAX, ensuring accuracy and data integrity across multiple systems.

Collaborated with stakeholders to align reporting frameworks and provide training to internal teams on Power BI usage.

Migrated data across cloud platforms (Azure, Snowflake, and implemented ETL processes to optimize data pipelines.

Ensured compliance with data security policies by implementing row-level security and managing access control.

Data Storytelling: Interpret complex datasets and effectively communicate insights both in written and verbal format.

BGE (Baltimore Gas and Electric), Baltimore, MD

Data Analyst

February 2020 – March 2022

Designed, developed, and supported enterprise-level dashboards and reports in Power BI to monitor key metrics and performance indicators.

Collaborated with cross-functional teams to gather reporting requirements, ensuring alignment with business objectives and data needs.

Utilized SQL to extract, transform, and load (ETL) data from the company’s data warehouse, improving data accuracy by 15%.

Delivered ad hoc reports and automated dashboards that streamlined data analysis, reducing manual reporting time by 40%.

Provided training and technical support for Power BI end users, improving user adoption and self-service reporting capabilities.

JP Morgan Chase, Columbus, OH

Data Analyst

January 2018 – January 2020

Write and optimize SQL queries to extract data from relational databases.

Use Python, R, or other programming languages to automate data extraction, transformation, and analysis.

Retrieve and manipulate data from multiple data sources (structured and unstructured).

Work closely with business units, IT teams, data scientists, and product managers to understand data needs and objectives.

Translate business requirements into technical specifications for data solutions.

Collaborate with stakeholders to identify their goals, challenges, and how data can address them.

Built and optimized Analysis Services reporting models using Power BI Desktop and SQL, improving reporting efficiency.

Developed visual reports, KPI scorecards, and dashboards, using advanced DAX functions and transforming data from multiple sources.

Created and managed SQL databases, ensuring high availability, security, and disaster recovery.

Worked with business and IT teams to implement BI reporting solutions, resulting in more informed decision-making across departments.

EDUCATION

Bachelor of Science in Computer Science

Addis Ababa University

Graduation Date: May 2017

Contact this candidate