Kiru Adma
BETHESDA,USA
Summary
- Proactive Power BI Developer with 4+ years of experience in Data Analytics, Business Intelligence, and ETL Development, specializing in SQL Server, SSIS, SSRS, SSAS, and Power BI.
- Expert at designing compelling dashboards and reports using Power BI and SSRS, providing clear insights for business decision-making.
- Strong background in T-SQL programming, developing complex database schemas, stored procedures, functions, and triggers to enhance data management.
- Hands-on experience with Power BI Desktop, Power BI Service, and Power BI Mobile, building cross-platform reporting solutions.
- Adept at requirement gathering, business process analysis, and developing KPIs, ensuring alignment with business objectives.
- Experience in Power BI Dashboards, SSRS Reports, and MDX queries, leveraging SSAS for high-performance analytical processing.
- Developed and maintained automated reports in SQL Server Reporting Services, improving decision-making processes.
- Skilled in data warehousing methodologies, including OLAP cube structures, fact and dimension tables, and schema modeling.
- Designed and implemented database solutions, ensuring data integrity, normalization, and indexing best practices.
- Expertise in data migration and ETL processing, extracting and transforming data between multiple sources using SSIS and Power Query.
- Configured Power BI Gateway, Power Pivot, and Power View, integrating real-time analytics with Microsoft services.
- Advanced skills in data transformation functions, using DAX formulas and calculated measures for real-time reporting.
- Proficiency in merging datasets from various platforms, optimizing performance in Power BI reports.
- Experience using Power Platform tools, automating repetitive reporting tasks through Power Automate workflows.
- Excellent troubleshooting ability, resolving Power BI and SSRS production issues efficiently.
- Collaborative and results-driven, working with cross-functional teams to deliver scalable reporting solutions.
Overview
6
6
years of professional experience
Work History
Data Analytics / Power BI Developer
OneMain Financial
03.2024 - Current
- Designed and optimized Power BI dashboards and reports, integrating data from multiple sources like SQL Server, Oracle, and Excel to provide insightful business intelligence
- Developed T-SQL queries, stored procedures, and views for efficient data extraction, transformation, and reporting
- Created and maintained data models with star and snowflake schemas, ensuring high-performance analytics in Power BI
- Implemented DAX functions and calculated columns to generate dynamic KPIs and data visualizations
- Utilized Power Query to clean, transform, and merge data from disparate sources for enhanced reporting
- Developed interactive reports with Power BI, incorporating various chart types, filters, and drill-through capabilities
- Configured row-level security (RLS) to ensure appropriate data access for different business users
- Optimized Power BI performance by minimizing data refresh times, improving relationships, and leveraging aggregations
- Published and managed reports in Power BI Service, ensuring seamless access and scheduled data refresh
- Collaborated with business stakeholders to gather report requirements, optimize data models, and enhance user experience
SQL / Power BI Developer
PNC
10.2022 - 02.2024
- Designed and implemented ETL workflows to extract, transform, and load data efficiently into data warehouses and data marts
- Developed and optimized SSIS packages, integrating Control Flow Tasks, Data Flow Tasks, and Execute SQL Tasks for automated data processing
- Automated Power Query refreshes in Power BI, improving report accuracy and reducing manual intervention
- Integrated Power BI with SQL Server, Oracle, and cloud databases, ensuring seamless data aggregation and visualization
- Created DAX expressions and calculated columns, optimizing Power BI dashboard performance and analytical insights
- Installed, configured, and maintained Power BI Gateways, enabling secure real-time connectivity to on-premises data sources
- Designed and scheduled automatic data refresh cycles in Power BI Service, ensuring up-to-date analytics
- Optimized SQL stored procedures and queries, improving query execution times for data retrieval and reporting
- Developed role-based access controls (RBAC) and row-level security (RLS), ensuring data protection and controlled access in Power BI
- Provided production support and troubleshooting, ensuring smooth Power BI and SQL Server operations with minimal downtime
SQL / SSIS/ SSRS/ Power BI Developer
Aetna
01.2019 - 09.2022
- Designed and developed interactive reports and dashboards in Power BI and Excel, enabling data-driven insights and improved business decision-making
- Utilized Power Query Editor in Power BI to extract, transform, and load data from multiple file sources, ensuring efficient data integration
- Created and managed user groups and content packs, enhancing data accessibility and collaboration for business teams
- Conducted unit testing and query optimization, troubleshooting database performance issues and ensuring data accuracy
- Performed data validation, analysis, and mapping, ensuring consistency between multiple data sources and reporting structures
- Developed KPI metrics to track and compare actual vs
- Forecasted data, supporting performance monitoring and strategic planning
- Worked with import and DirectQuery modes, designing custom tables and relationships in Power BI for real-time analytics
- Merged and appended queries, applied column transformations, filters, and split operations, optimizing dataset structures
- Built and published dynamic Power BI reports using DAX formulas and expressions, enabling insightful analytics
- Implemented row-level security (RLS) in Power BI, managing user roles and permissions to ensure controlled data access
- Created SSAS tabular models and OLAP cubes, enabling fast query performance and multidimensional analysis
- Designed and deployed Power BI reports from both on-premises and cloud data sources, integrating live data for enhanced business intelligence
Education
Bachelor of Science - Computer Science
University of Maryland Global Campus
Hyattsville, MDSkills
- SQL Server
- Azure SQL Database
- BigQuery
- SSRS
- SSAS
- SSIS
- T-SQL
- PostgreSQL
- Data Lake Storage
- Power BI
- Tableau
- Excel
- Access
- Teams
- OneDrive
- Outlook
- SharePoint Online
- Azure DevOps
- GitHub
- JIRA
- AWS Lambda
- Microsoft Fabric
Technical Skills
SQL Server, Azure SQL Database, BigQuery, SSRS, SSAS, SSIS, T-SQL, PostgreSQL, Data Lake Storage, Power BI, Tableau, Excel Power Pivot, Data Extraction, Business Intelligence, Data Cleansing, Advanced Analytics, SQL, PowerShell, R, M Language for Power Query, Advanced DAX, JSON/XML Parsing, Excel (PivotTables, Power Query, Power Pivot), Access, Teams, OneDrive, Outlook, SharePoint Online, Azure DevOps, GitHub, JIRA, AWS Lambda, Microsoft Fabric
Timeline
Data Analytics / Power BI Developer
OneMain Financial
03.2024 - Current
SQL / Power BI Developer
PNC
10.2022 - 02.2024
SQL / SSIS/ SSRS/ Power BI Developer
Aetna
01.2019 - 09.2022
Bachelor of Science - Computer Science
University of Maryland Global Campus
Similar Profiles
Zach BoulwareZach Boulware
PLS SR. / Branch Manager /District Manager at Onemain Financial Inc. Onemain FinancialPLS SR. / Branch Manager /District Manager at Onemain Financial Inc. Onemain Financial
John RomeroJohn Romero
Branch Manager - Relief District Manager at OneMain FinancialBranch Manager - Relief District Manager at OneMain Financial
Jazmin MillanJazmin Millan
Assistant Manager at OneMain FinancialAssistant Manager at OneMain Financial
Simone JonesSimone Jones
Auto Purchase Program at OneMain FinancialAuto Purchase Program at OneMain Financial
Maria Elena PingloMaria Elena Pinglo
Senior Evaluation Officer of the Finance, Private Sector and Infrastructure and Sustainable Development Group at World Bank GroupSenior Evaluation Officer of the Finance, Private Sector and Infrastructure and Sustainable Development Group at World Bank Group