Tesfa Nrea
Silver Spring,Maryland
Summary
Experienced Power BI professional with proven expertise in leveraging data visualization, analytics, and reporting tools to drive business insights and decision-making. Proficient in designing and implementing Power BI solutions tailored to diverse business needs, optimizing data models, and creating intuitive dashboards. Demonstrated success in collaborating with cross-functional teams to deliver impactful data-driven solutions. Passionate about continuously exploring new features and best practices in the field of business intelligence. Strong experience in using Microsoft Suite (SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Full System Development Life Cycle (SDLC) experience and well versed in Agile Methodology. Ability to prioritize multiple tasks. Excellent communication skills, proactive, self-managing, and teamwork spirit, goal-oriented highly motivated Personality. Experienced Developer with 7 years of experience in creating programs based on specific requirements. Adaptable, diligent and knowledgeable.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Power Bi Report & Dashboard Developer
Envu | Innovative Environment Solutions
04.2023 - Current
- Gathering business requirements and prepare documentation for analysis.
- Working on require analysis, design and development of modules using Power BI.
- Translating end user's requirements into effective reports and dashboard.
- Working with Marketing teams in various areas of field sales (T&O, PMPH, VM and Price steering) as well as with the global teams to develop reports or address data needs to provide reporting solutions.
- Guided design and development of data management and business intelligence projects to drive strategic decisions through data driven actionable metrics and insights.
• Prepared complete data cleansing, mapping all integrated jobs using power Query Editor. - Designed BI data model layer to support analytic needs.
- Performed detail data analysis to derive insights and deliver operational mechanism such as dashboards or ad-hoc reports.
- Utilized Power BI (Power View) to create various analytical reports and dashboards that depicts KPIs along with slicers and dicers enabling end-user to make filters.
- Utilized Power BI to create dynamic reports and dashboards with Drill down and Drill through. Work with stakeholders to define and develop key metrics for new visualizations.
- Secured reports using Row-Level Security on data in Power BI Desktop. Deploy and share reports to Power BI Service, and setup gateways, low level security for end user interaction.
- Add clarity to business requirements, translate functional requirements into technical requirement, develop and testing all backend programs, Data Pipeline development.
- Work on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
- Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
- Support ETL and Data Warehouse production, development & test environment
- Skills: DAX · Data Visualization · R (Programming Language) · Business Analysis · SQL Server Integration Services (SSIS) · Data Modeling · Microsoft Office · Data Analysis · SQL · Business Intelligence (BI) · Extract, Transform, Load (ETL) · Microsoft Azure · Software as Service (SaaS) · Microsoft Power BI
Power Bi Developer/Business Analyst
Travelers
07.2018 - 02.2023
- Meet with Product Owner, Scrum Master, and business users, gathered business requirements and
- Prepare documentation for analysis and Data Models, Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
- Implement row level security on data and application security layer models in Power BI
- Work on require analysis, design and development of modules using Power BI
- Write calculated columns, measures query in power BI desktop using DAX
- Presentation to business users about reports and their changes as required.
- Add clarity to business requirements, translate functional requirements into technical requirement,
- Develop and testing all backend programs, Data Pipeline development
- Design power BI data visualization using cross tabs, maps, scatters plots, density charts
- Adept in developing, publishing and scheduling Power BI reports as per business requirements.
- Support ETL and Data Warehouse production, development & test environment
- Developing data links and data loading scripts, including data transformations, and creating multidimensional and tabular CUBE.
- Work on client problem understanding their requirement, building, documentation, and translation of requirements into dashboard solutions.
- Building, publishing customized interactive reports and dashboards, report scheduling using Power BI and Develop Unit testing of modules.
- Review and resolve issues that arise in current reporting, including and not limited to debugging and fixing current and new reports.
- Create stored procedures and SQL queries to pull data into power pivot model.
Power BI Developer
Wells Fargo
08.2017 - 03.2018
- Collaborated with cross-functional teams to ensure seamless integration of new features.
- Adapted quickly to new technologies and programming languages, enhancing overall team productivity.
- Debugged complex software issues, leading to more stable product release.
- Continuously updated skills through training courses, workshops, and self-study—staying current on industry trends and emerging technologies.
Power Bi Developer/Business Analyst
Alaska Airlines
06.2016 - 07.2017
- Prepared complete data cleansing, mapping all migrated jobs using power Query Editor.
- Designed BI data model layer to support analytic needs.
- Implemented DAX functions of company KPI sales, revenue, yoy, purchasing, lead time and inventory, production, cycle time, production cost, Rework and Reject cost, profit, sales performance of Agents based on geography and like, and dashboards using Power BI desktop so that create interactive visual reports using BI tools, and present fact calculations for efficient data visualization in Power BI.
- Performed detail data analysis to derive insights and deliver operational mechanism such as dashboards or ad-hoc reports
- Utilized Power BI (Power View) to create various analytical reports and dashboards that depicts KPIs along with slicers and dicers enabling end-user to make filters.
- Utilized Power BI to create dynamic reports and dashboards with Drill down and Drill through. Work with stakeholders to define and develop key metrics for new visualizations.
- Secured reports using Row-Level Security on data in Power BI Desktop. Deploy and share reports to Power BI Service, Mobile Apps and SharePoint server and setup gateways, low level security for end user interaction.
- Review and resolve issues that arise in current reporting, including and not limited to debugging and fixing current and new reports.
Education
Bachelor of Arts - Business Management
Arbaminch University
Ethiopia Arbaminch07.2006
Skills
- Microsoft Power BI
- DAX
- Data Visualization
- R (Programming Language)
- Business Analysis
- SQL Server Business Intelligence Studio (SSIS, SSRS, SSAS, DTS)
- Data Modeling
- Microsoft Office
- Data Analysis
- Business Intelligence (BI)
- Extract, Transform, Load (ETL)
- Microsoft Azure
- MS Word, MS Excel, MS Access, MS Project, Visio
Certification
- Microsoft Power BI-UP & Running with Power Bi service.
- SQL & Power BI Data Analytics & Visualization
Timeline
Power Bi Report & Dashboard Developer
Envu | Innovative Environment Solutions
04.2023 - Current
Power Bi Developer/Business Analyst
Travelers
07.2018 - 02.2023
Power BI Developer
Wells Fargo
08.2017 - 03.2018
Power Bi Developer/Business Analyst
Alaska Airlines
06.2016 - 07.2017
Bachelor of Arts - Business Management
Arbaminch University
Similar Profiles
Janis D. OliverJanis D. Oliver
Customer Service Agent at EnVUCustomer Service Agent at EnVU
Vusumuzi NkiwaneVusumuzi Nkiwane
Head of Sales at Qualitative Innovative Solutions (QI Solutions)Head of Sales at Qualitative Innovative Solutions (QI Solutions)
Lucas TelariLucas Telari
Demand and Production Planner at EnvuDemand and Production Planner at Envu