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.

years of professional experience

One Main Finanical

Baltimore, MD

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.

Aetna

Hartford, CT

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.

PNC

Pittsburgh, PA

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.

The University of Texas At Dallas

Richardson, TX

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