Summary
Overview
Work History
Education
Skills
Timeline
Generic

Antex Asratu

Summary

Results-driven Power BI Developer with over four years of experience in data modeling, analytics, and visualization using Microsoft BI and Power Platform tools. Skilled in designing interactive dashboards and analytical reports with Power BI and SSRS to support data-driven business strategies. Expertise in writing performant T-SQL scripts, including stored procedures, views, and functions for optimized data access. Proven track record in developing cross-platform reporting solutions using Power BI Desktop, Service, and Mobile versions. Adept at gathering business requirements and translating them into robust data models and actionable visual insights. Experienced in delivering analytical reports using MDX, Crystal Reports, and SSRS for multi-dimensional business scenarios. Automated recurring and ad hoc reporting schedules with SSRS to reduce manual tasks and improve delivery speed. Proficient in applying dimensional modeling techniques, such as star schemas and OLAP cubes, to support business intelligence. Capable of developing normalized databases that ensure efficient querying and minimize data redundancy.

Overview

7
7
years of professional experience

Work History

Data Analytics / Power BI Developer

Stripe
01.2024 - Current
  • Created business-ready data models using Power BI with calculated fields, KPIs, and optimized aggregations.
  • Designed modular stored procedures and parameterized SQL logic to feed high-performing reports.
  • Developed compelling Power BI dashboards using visual elements such as slicers, cards, charts, and map visuals.
  • Leveraged Power Query to build ETL workflows that clean, transform, and join data from diverse sources.
  • Published dashboards to Power BI Service, implementing refresh strategies to ensure data accuracy.
  • Balanced real-time access and performance using Import mode and DirectQuery where appropriate.
  • Integrated SSRS datasets with Power BI to extend enterprise reporting capabilities.
  • Delivered training sessions and how-to documentation to drive report adoption across teams.
  • Collaborated with business leaders to design metrics, define KPIs, and finalize report requirements.
  • Automated report distribution and triggered alerts using Power Automate to support time-sensitive reporting.

Data Analytics / SQL / SSIS / SSRS / Power BI Developer

Edward Jones
03.2021 - 12.2023
  • Built intuitive Power BI reports featuring drill-throughs, filters, and conditional formatting for dynamic analysis.
  • Developed SSIS-based ETL flows to transform source data and prepare it for structured reporting.
  • Applied DAX expressions for time-based logic, ratio analysis, and trend comparisons across reports.
  • Structured data using fact-dimension relationships and normalized views for optimal model performance.
  • Configured Power BI Gateways and scheduled refreshes for on-premises and cloud-based data connections.
  • Sourced and consolidated data from SQL Server, Azure SQL, and Excel for unified reporting.
  • Improved data readiness with Power Query transformations for consistency and usability.
  • Enhanced dashboard responsiveness by minimizing model size, reducing cardinality, and optimizing visuals.
  • Delivered SSRS-based reports using advanced features like parameters, charts, and matrix visualizations.
  • Engaged business users to validate report accuracy and align deliverables with key operational goals.

SQL / Power BI Developer

Medtronic
06.2018 - 02.2021
  • Automated ETL routines using SSIS, SQL Agent, and PowerShell for consistent daily data processing.
  • Created KPI-focused Power BI dashboards using DAX measures, dynamic visuals, and tooltips for context.
  • Deployed and configured Power BI Dataflows and Gateways to support secure hybrid access models.
  • Developed complex SQL stored procedures and reusable functions for centralized reporting logic.
  • Built reusable Power Query scripts to streamline transformations such as pivoting, splitting, and merging.
  • Maintained refresh schedules and published dashboards on Power BI Service for timely data delivery.
  • Designed robust dimensional models using fact/dimension structures to support consistent analytics.
  • Implemented Row-Level Security (RLS) and workspace roles to manage access and enforce data confidentiality.
  • Led database upgrade initiatives, migrating legacy SQL environments to SQL Server 2019.
  • Troubleshoot Power BI and SQL reporting issues, delivering resolution plans and documentation.

Education

Bachelor of Science - Computer Science

Bluffton University
Bluffton, OH

Skills

  • Databases & ETL: SQL Server, T-SQL, Oracle, Azure SQL, Cosmos DB, MariaDB, SSIS, SSRS, SSAS
  • BI & Analytics: Power BI, Tableau, Qlik Sense, DAX, Power Query, Data Modeling, Business Intelligence
  • Programming & Automation: Python, JavaScript, R, PowerShell, M (Power Query), REST API
  • Productivity & Collaboration: Excel (Power Pivot, Power Query, Macros), Access, Outlook, OneDrive, SharePoint, Microsoft 365
  • Other Tools: Power Automate, Git, JIRA, Snowflake, Azure Data Lake

Timeline

Data Analytics / Power BI Developer

Stripe
01.2024 - Current

Data Analytics / SQL / SSIS / SSRS / Power BI Developer

Edward Jones
03.2021 - 12.2023

SQL / Power BI Developer

Medtronic
06.2018 - 02.2021

Bachelor of Science - Computer Science

Bluffton University

Similar Profiles

CREATE PROFILE
Antex Asratu