Back to Developers

Pramod Dhakane

Profile Score

Skills & Expertise (30)

Power BI Advanced

8.3/10

2.5

Years Exp

SQL Advanced

8.0/10

2.5

Years Exp

ETL Processes Intermediate

7.8/10

2.5

Years Exp

Data Modeling Intermediate

7.5/10

2.5

Years Exp

DAX Intermediate

7.5/10

2.5

Years Exp

Power Query Report Security Dimensional Modeling Jira MS Office Agile Methodology Requirement gathering stakeholder communication Report Optimization Row Level Security Data Access Control Data Quality Management Data Warehouse Concepts Data Integration Databricks Snowflake SQL Server MS Excel Data Validation Data Transformation Data Cleaning KPI Reporting Data Visualization Dashboard Development Oracle

Work Experience

BI Developer

SOFTTECH CLOUD TECHNOLOGIES

Aug 2023 - Present

Gathered and analyzed business requirements from stakeholders to design data-driven reporting solutions. Developed 10+ interactive Power BI dashboards to monitor healthcare KPIs including claims analysis, member enrollment, and provider performance. Created advanced DAX measures and calculated columns for KPI tracking, trend analysis, and time-intelligence reporting. Wrote optimized SQL queries using joins, subqueries, and aggregations to extract data from multiple databases. Performed data cleaning, transformation, and validation, improving overall data accuracy by 20%. Designed data models using Star Schema to enhance report performance and scalability. Used Power Query and SQL for data extraction, transformation, and loading (ETL) to prepare datasets for Power BI dashboards. Implemented ETL processes to integrate data from multiple healthcare systems into reporting layers. Published reports in Power BI Service and configured automated data refresh schedules. Implemented Row Level Security (RLS) to ensure secure data access based on user roles. Optimized dashboards and datasets, reducing report loading time by 25%.