Summary
Overview
Work History
Education
Skills
Timeline
Generic

Dagi Girmiti

Bethesda

Summary

  • Data Analytics & Power BI Developer with 4+ years of experience in Business Intelligence, Data Warehousing, and Advanced Analytics.
  • Expertise in Power BI, SQL Server, Tableau, and SSRS for building interactive dashboards, reports, and predictive models.
  • Skilled in data modeling (Star & Snowflake schemas), ETL processes (SSIS, Power Query, Python, R, PySpark), and OLAP cubes (SSAS).
  • Proficient in SQL (PostgreSQL, MySQL, SQL Server) for developing stored procedures, views, triggers, and optimizing queries.
  • Strong knowledge of DAX and M language for calculated columns, measures, and advanced data transformations.
  • Hands-on experience in machine learning & predictive analytics using Python, R, Scikit-learn, TensorFlow to deliver insights beyond descriptive BI.
  • Experienced in enterprise BI deployments, including Power BI Gateway, Report Server, and scheduling refreshes for live/DirectQuery datasets.
  • Adept in integrating diverse data sources including SQL, Oracle, Cosmos DB, Excel, SharePoint, and cloud services (Azure).
  • Collaborative professional with proven ability to work across teams—developers, testers, PMs, and business stakeholders—to deliver scalable solutions.
  • Passionate about AI-driven insights, automation, and self-service BI to improve business decision-making.

Overview

7
7
years of professional experience

Work History

Data Analytics/SQL/Power BI Developer

One Main Finanical
08.2018 - 08.2021
  • Designed and optimized data models using star/snowflake schema, fact/dimension tables, and tabular models (SSAS).
  • Built end-to-end Power BI dashboards and SSRS reports for executive-level decision making.
  • Developed predictive models in Python/R to forecast trends, integrated with Power BI for advanced analytics.
  • Designed and tuned complex T-SQL queries, stored procedures, triggers, and indexing to ensure high-performance reporting.
  • Implemented DAX measures for KPIs, variance analysis, rolling averages, and time intelligence functions.
  • Automated ETL processes using SSIS, Power Query, and Python scripts for data cleansing and transformation.
  • Created role-based security and row-level access in Power BI to secure sensitive business data.
  • Integrated multiple data sources (SQL Server, Oracle, Cosmos DB, Excel, SharePoint) into consolidated BI solutions.
  • Deployed and maintained Power BI Gateway, report subscriptions, and automated refreshes for business continuity.
  • Collaborated with stakeholders to capture business requirements, design prototypes, and deliver insights-driven BI solutions.

Data Analytics/SQL/Power BI Developer

Aetna
09.2021 - 09.2024
  • Designed and maintained relational and dimensional models (fact/dimension tables, star & snowflake schemas) to support analytics.
  • Developed SSRS and Power BI reports including KPI dashboards, drillthrough reports, and executive summaries.
  • Built and optimized T-SQL queries, stored procedures, views, and triggers for data processing and reporting.
  • Used Power Query for advanced ETL transformations (merge, append, unpivot, cleansing, enrichment).
  • Created calculated columns and DAX measures for variance, forecasting, and performance analysis.
  • Automated data refresh schedules and configured Power BI Gateways for real-time reporting.
  • Applied row-level security in Power BI to manage user-specific access and compliance.
  • Collaborated with business users to translate requirements into actionable dashboards.
  • Supported data validation, mapping, and reconciliation between source systems and BI models.
  • Conducted unit testing, performance tuning, and production support for BI solutions.

Data Analytics/SQL/Power BI Developer

PNC
10.2024 - Current
  • Performed data wrangling and cleansing using SQL, Python (Pandas, NumPy), and Power Query.
  • Built interactive dashboards in Power BI and Tableau to visualize KPIs, trends, and financial/operational data.
  • Conducted predictive analytics and forecasting using Python/R and integrated results into BI reports.
  • Designed and deployed SSIS packages for ETL, moving data across heterogeneous systems.
  • Created business metrics and KPIs for executive reporting and departmental scorecards.
  • Implemented machine learning workflows (classification, regression, clustering) to support data-driven insights.
  • Delivered self-service BI enablement, training business users on Power BI dashboards and ad-hoc analysis.
  • Developed ad-hoc SQL queries to support urgent business questions and exploratory analysis.
  • Ensured data governance and quality standards by documenting metadata and validation rules.
  • Partnered with cross-functional teams to align BI solutions with strategic business goals.

Education

Bachelor of Science - Computer Science

The University of Texas At Dallas
Richardson, TX

Skills

  • Databases: SQL Server, PostgreSQL, MySQL, Azure SQL DB, Cosmos DB, MongoDB
  • BI & Data Visualization: Power BI (Desktop, Service, Mobile, Gateway), Tableau, SSRS, Crystal Reports, Excel (VLOOKUP, VBA, Pivot Tables)
  • ETL & Data Processing: SSIS, Power Query, PySpark, Dataflows, Tabular Models (SSAS)
  • Programming & Analytics: Python, R, T-SQL, DAX, M Language, PowerShell, SQLAlchemy
  • Python/R Libraries: Pandas, NumPy, Matplotlib, Seaborn, Scikit-learn, TensorFlow, Flask, Jupyter Notebook
  • Data Science & ML: Predictive Modeling, Machine Learning, AI-based Forecasting, Data Wrangling, Feature Engineering
  • Web/Visualization Tools: JavaScript, HTML, Chartjs, D3js, Leafletjs, LangChain for AI/LLM integrations
  • Microsoft & Cloud Tools: Office 365 Suite, SharePoint, Azure Data Factory, Azure DevOps, Jira
  • Reporting & Analytics: Dashboard Development, KPI Design, Drillthrough, Row-Level Security, Self-Service BI
  • Other Skills: Data Governance, Data Quality, Performance Optimization, Documentation & User Training

Timeline

Data Analytics/SQL/Power BI Developer

PNC
10.2024 - Current

Data Analytics/SQL/Power BI Developer

Aetna
09.2021 - 09.2024

Data Analytics/SQL/Power BI Developer

One Main Finanical
08.2018 - 08.2021

Bachelor of Science - Computer Science

The University of Texas At Dallas

Similar Profiles

CREATE PROFILE
Dagi Girmiti