Sara Tesfaye
Coleville,MD
Summary
- Results-driven Data Analytics and Power BI Developer with over 6 years of experience delivering enterprise-grade Business Intelligence solutions across financial, operational, and analytical domains.
- Highly skilled in transforming complex business requirements into scalable data models, interactive dashboards, and automated reporting solutions using Power BI, SQL Server, PostgreSQL, Tableau, R, and Python.
- Proven ability to design and optimize ETL pipelines, develop advanced DAX measures, and implement predictive analytics to support data-driven decision-making.
- Strong collaborator with business stakeholders, operating within Agile environments and modern DevOps/ALM practices, with a deep focus on performance, security, and governance across the BI lifecycle.
Overview
7
7
years of professional experience
Work History
Senior Data Analytics / Power BI Developer
BNY Mellon
06.2023 - Current
- Designed and delivered scalable BI solutions using Power BI, SQL Server, and PostgreSQL, supporting enterprise-wide reporting and analytics initiatives.
- Built and optimized end-to-end ETL pipelines using SSIS, ensuring accurate, timely, and auditable data ingestion from multiple source systems.
- Developed advanced DAX measures and calculations to support complex financial logic, KPIs, variance analysis, and executive reporting.
- Leveraged Power Query (M) for data transformation, cleansing, and shaping to improve performance and reusability of semantic models.
- Implemented predictive analytics and forecasting models using R and Python to analyze financial trends, identify risk patterns, and support strategic planning.
- Created interactive Power BI and Tableau dashboards tailored for executives and business stakeholders, enabling self-service analytics and drill-through insights.
- Authored and optimized SQL queries and stored procedures, significantly improving report performance and reducing query execution time.
- Applied Power BI ALM best practices, managing deployments across Dev/Test/Prod environments using deployment pipelines and Azure DevOps.
- Implemented Power BI security models, including Row-Level Security (RLS), to ensure data confidentiality and role-based access.
- Worked closely with stakeholders to gather requirements, translate business questions into analytical solutions, and deliver actionable insights.
- Actively participated in Agile ceremonies, collaborating with product owners, analysts, and engineers using Jira to track deliverables.
Data Analytics / Power BI Developer
Cigna Corporation
10.2020 - 05.2023
- Partnered with data engineering teams to design and optimize SSAS Tabular models for high-performance analytics.
- Developed complex DAX measures to accurately calculate KPIs, trends, and business metrics across large datasets.
- Built dynamic Power BI dashboards with drill-down, drill-through, and interactive filtering capabilities.
- Designed and maintained SSRS reports, including automated subscriptions for scheduled distribution.
- Contributed to the design and enhancement of a centralized data warehouse, ensuring data consistency and integrity.
- Performed SQL performance tuning, optimizing queries, indexes, and stored procedures to improve reporting efficiency.
- Migrated legacy SSRS reports to modern Power BI solutions, enhancing usability and stakeholder adoption.
- Collaborated directly with business users to refine reporting requirements and deliver timely, high-impact solutions.
- Supported Agile delivery processes, participating in sprint planning, reviews, and retrospectives.
Data Analyst / Power BI Developer
CVS Health
10.2018 - 09.2020
- Optimized SQL queries, views, and indexes, improving database performance and reducing reporting latency.
- Developed SSRS reports and Power BI dashboards to support sales, inventory, and operational analytics.
- Used Power BI, Tableau, and R to analyze trends, uncover patterns, and drive data-informed business decisions.
- Supported data migration initiatives, validating data accuracy during transitions from legacy systems to cloud platforms.
- Conducted statistical analysis using R to provide insights for marketing and sales strategies.
- Assisted in building and maintaining data pipelines to support reliable data extraction and transformation.
- Implemented version control and documentation standards for SQL scripts and BI artifacts.
- Provided production support for SQL Server, PostgreSQL, and Power BI, resolving data and reporting issues.
- Participated in daily stand-ups and Agile workflows to ensure timely project delivery.
Education
Bachelor’s - Computer Science
Skills
- Databases & Querying: SQL Server, PostgreSQL, T-SQL, Stored Procedures, Views, Indexes, Query Optimization, SQL Server Management Studio (SSMS)
- Business Intelligence & Analytics: Power BI (DAX, Power Query, Data Modeling, Row-Level Security), Tableau (Interactive Dashboards, Visual Analytics), SSRS, SSAS (Tabular), SSIS
- ETL & Data Engineering: SSIS, Informatica, Data Warehousing, Star & Snowflake Schemas, Data Quality, Validation, Reconciliation
- Advanced Analytics: R (Statistical Analysis, Trend Analysis, Forecasting), Python (Data Analysis, Automation, Predictive Modeling), Predictive Analytics, Financial Forecasting
- DevOps, ALM & Collaboration: Power BI ALM (Dev/Test/Prod, Deployment Pipelines), Azure DevOps, Git-based Version Control, Agile/Scrum, Jira
- Security & Governance: Power BI Security (Row-Level Security, Object-Level Security), Data Access Controls, Compliance
- Productivity & Platforms: Microsoft Excel, SharePoint, Office 365
Timeline
Senior Data Analytics / Power BI Developer
BNY Mellon
06.2023 - Current
Data Analytics / Power BI Developer
Cigna Corporation
10.2020 - 05.2023
Data Analyst / Power BI Developer
CVS Health
10.2018 - 09.2020