Summary
Overview
Work History
Education
Skills
Certification
Work Availability
Quote
Timeline
Key projects and achievements
Generic

Birhane Shewangzaw

West Henrietta,NY

Summary

Results-oriented Power BI Developer with a strong history at Collabera and Flower City Medical Transportation Inc., driving data-driven decisions through advanced dashboard creation and comprehensive data analysis. Achieved a 90% reduction in manual errors while enhancing operational efficiency through expert DAX and SQL Server integration. Proficient in agile methodologies and collaboration, consistently transforming complex data into actionable insights.

Overview

8
8
years of professional experience
1
1
Certificate

Work History

Power BI Developer

MedCare | Flower City Medical Transportation
Rochester, NY
11.2021 - Current
  • Designed and developed 17+ interactive Power BI reports to improve operational efficiency, covering scheduling, payroll, and cost analysis.
  • Automated driver payroll reports, reducing manual errors by 90% and ensuring accurate, timely payments.
  • Built dashboards for vehicle maintenance, leading to a 30% reduction in unplanned downtime.
  • Analyzed fuel usage and operational costs, achieving a 15% annual savings on fuel expenses through data-driven optimizations.
  • Delivered insights into high-demand routes, increasing revenue through optimized pricing strategies.
  • Created robust data models and implemented advanced DAX calculations to provide dynamic, actionable insights for decision-making.
  • Integrated and transformed data from various sources using Power Query, and automated report refresh processes.
  • Collaborated with stakeholders to define KPIs and design intuitive dashboards aligned with business goals.
  • Established and managed Row-Level Security (RLS) to ensure data confidentiality and compliance.
  • Optimized Power BI report performance by employing data modeling best practices, indexing, and pre-aggregated datasets.
  • Conducted training sessions for teams to drive the adoption of Power BI solutions and enhance data literacy across the organization.

Power BI Developer

Collabera
01.2020 - 12.2021
  • Designed and optimized 10+ Power BI dashboards accessed by cross-functional teams, reducing data retrieval times and improving reporting efficiency
  • Built dynamic visualizations with live connections to Azure Analysis Services, enabling real-time insights
  • Created custom DAX measures to highlight trends, KPIs, and actionable insights
  • Secured sensitive data access using Row-Level Security (RLS) and managed deployments via Power BI Service
  • Collaborated with stakeholders to define reporting needs, enhancing data-driven decision-making capabilities

Junior SQL Database Administrator

Boeing
10.2018 - 02.2020
  • Managed and maintained SQL Server databases to ensure high availability and performance.
  • Implemented backup, recovery, and disaster recovery solutions to protect critical data.
  • Optimized database performance through query tuning and configuration improvements.
  • Ensured database security with role-based access controls and compliance with standards.
  • Collaborated with development teams to design efficient database schemas and processes.
  • Provided technical assistance in troubleshooting issues related to database performance, replication setup or any other issue that may arise during development or production phases.

Data Entry & Billing Analyst

TAPS (Technical Professional Services)
03.2017 - 09.2018
  • Streamlined data entry and billing workflows, achieving 100% accuracy and reducing discrepancies by 95%
  • Analyzed fuel consumption trends, implementing cost-saving measures that cut operational expenses by 15%
  • Generated error-free invoices and reports to support financial decision-making and regulatory compliance
  • trained on time tracking and reporting tools; ERP systems with billing modules

Education

Bachelor of Arts - Chemistry

University At Buffalo
Buffalo, NY

Skills

Core Expertise

  • Power BI Desktop: Advanced proficiency in building interactive dashboards
  • SQL Server: Database integration and query optimization
  • DAX (Data Analysis Expressions): Advanced calculations and custom measures
  • Data Modeling: Star schema, snowflake, and handling large datasets
  • ETL Processes: Data transformation using Power Query
  • Performance tuning using calculated tables, aggregations, and optimized relationships

Advanced Proficiency

  • Power BI Service: Gateway configuration, workspace management
  • Row-Level Security (RLS): Implementation for secure data access
  • Visualization Best Practices: UI/UX Design Principles in Power BI
  • Power Automate: Automation of workflows and data refreshes
  • Incremental Data Refresh: Performance optimization for large datasets
  • Agile Methodology: Sprint planning, collaboration with cross-functional teams

Certification

  • Certifications and Training
     Microsoft Power BI Desktop for Business- @Udemy in 2018
     Microsoft Power BI Service for Business and Advanced DAX - @Udemy in 2018
     Microsoft BI Stack (SQL, SSIS, SSRS) -@ Data Art in 2016

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Quote

"Numbers have an important story to tell. They rely on you to give them a clear and convincing voice."
Stephen Few

Timeline

Power BI Developer

MedCare | Flower City Medical Transportation
11.2021 - Current

Power BI Developer

Collabera
01.2020 - 12.2021

Junior SQL Database Administrator

Boeing
10.2018 - 02.2020

Data Entry & Billing Analyst

TAPS (Technical Professional Services)
03.2017 - 09.2018

Bachelor of Arts - Chemistry

University At Buffalo

Key projects and achievements

  • Retail Sales Dashboard: Designed a multi-store sales performance dashboard with KPIs such as gross sales, inventory levels, and stale percentages, supporting decision-making for over 50 retail locations.
  • Finance Insights: Created financial trend reports that uncovered revenue opportunities, driving a 10% increase in profitability.
  • Automation in Reporting: Automated data refreshes and workflows in Power BI, saving 20+ hours per week for operational teams.
  • Cross-Domain Expertise: Delivered impactful dashboards for Logistics, manufacturing, retail, finance, and service delivery domains, ensuring alignment with business goals.

Similar Profiles

CREATE PROFILE
Birhane Shewangzaw