\

Yalalem Tegenie

Power BI Developer

SUMMARY

• 5 years of experience in creating reports, and dashboards using Power BI Desktop and Server and maintaining Power BI dashboards on servers.

• Strong understanding of project life cycle and SDLC methodologies including Waterfall and Agile.

• Implement data modeling, relationships, and DAX calculations for accurate reporting.

• Extract, Transform and load data from various sources into power BI

• Experience in using SQL Server tools like SQL Server Management Studio, SQL Server Data Tools, and SQL Server Visual Studio.

• Experience in Tools like SQL Server Enterprise Manager, Management Studio, SSDT Power BI Desktop, Power Query, and KPI.

• Extensive experience in MySQL and MS SQL Server with creating, managing, and optimizing queries.

• Experience in SSIS, SSRS and SSAS.

• Knowledge in python especially python libraries like Pandas, NumPy. Seaborn and Matplotlib.

CONTACT

380-***-****

ad15f9@r.postjobfree.com

OH

EXPERIENCE

Targeted Technology Consulting, OH Feb 2019 - Current Power BI Developer

• Designed and developed interactive power bi reports and dashboards for business stakeholders.

• Gather and transform data from various sources into meaningful insights.

• Collaborate with business units to understand reporting requirements and data needs.

• Develop ad-hoc reports and visualizations to support decision making.

• Publish Power BI reports from Power BI desktop to service and manage reports in power bi service.

• Create Data gateways and Row level securities.

• Create analytical reports and dashboards with Power View to identify critical KPIs.

• Maintain various daily, weekly, and monthly ETL packages and scheduled jobs through SQL Server.

• Develop data queries using SQL and other tools for data preparation.

• Implement data modeling, relationships, and DAX calculations for accurate and interactive reporting.

SKILLS

- Power BI Report Development

- Data Modeling

- DAX (Data Analysis Expression)

- Data Integration

- SQL Query Writing

- Data Visualization

- ETL Process

- Business Intelligence Concepts

- Data Warehousing

- Excel and Power Query

- Data Analysis

- Programing with Python

EDUCATION

Bachelors in Economics

Addis Ababa University, Ethiopia

Ab ay Bank SC, Oct 2017 - Oct 2019

BI Developer

• Develop interactive reports and visuals in power bi desktop.

• Extract, Transform and Load data using Power query.

• Data modeling, relationships using Power pivot and make DAX calculations for reports.

• Created a new SSIS package to extract data from legacy to SQL Server Objects using Business Intelligence Development Studio (BIDS) and Visual studio.

• Configured and maintained Report Manager and Report Server for SSRS.

• Deployed SSIS packages with package/project deployment models for testing and production.

• Automated Power Query refresh using power shell script and windows task scheduler.

• Generated periodic reports based on the statistical analysis of the data using SQL server Reporting Service (SSRS).

• Write SQL queries to retrieve data from the server using joins and subqueries.

Contact this candidate