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, TXSkills
- 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