PRAMOD SHINDE
Mumbai
Summary
Results-driven Business Intelligence Developer with 8+ years of experience designing, developing, and optimizing data visualization and analytics solutions using Power BI, Qlik Sense, SQL, and Databricks. Proven expertise in building scalable dashboards, complex data models, and high-performance ETL pipelines that transform raw data into actionable business insights.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Lead
HTC GLOBAL SERVICES
Mumbai
01.2023 - Current
- Led migration of Qlik Sense dashboards and reports to Power BI, improving scalability, maintainability, and report performance.
- Developed Power BI datasets, reports, and dashboards using DAX, Power Query (M), and advanced data modeling (star/snowflake schemas, calculated columns, measures, hierarchies).
- Built and maintained SQL views, stored procedures, and complex queries to support accurate, timely insurance reporting.
- Designed interactive dashboards with drill-throughs, slicers, filters, and visualizations, including mobile-friendly views for end users.
- Implemented row-level security (RLS) and OLS, user roles, and access controls to ensure secure handling of sensitive insurance data.
- Streamlined report distribution, alerts, and notifications via Power BI Service and Power Automate, improving operational efficiency.
- Conducted data validation, reconciliation, and testing to ensure accuracy during migration from Qlik Sense and integration with multiple data sources (SQL Server, Excel, APIs).
- Optimized dashboard performance, DAX calculations, and data refresh schedules, reducing load times and enhancing user experience.
- Collaborated with stakeholders to translate insurance KPIs, claims, and policy metrics into actionable insights for decision-making.
- Created documentation, training materials, and conducted end-user sessions to support Power BI adoption across business units.
- Developed and managed scalable data pipelines in Databricks leveraging PySpark to efficiently cleanse, transform, and process large-scale datasets.
- Wrote PySpark code and SQL queries to process and analyze data.
- Followed the Bronze-Silver-Gold data model to keep data organized and easy to use.
- Explored Microsoft Fabric tools for data ingestion, transformation, and visualization as part of ongoing skill development.
- Implemented bookmarks to enable users to save personalized views and quickly switch between key insights, significantly improving report usability and user efficiency.
- Optimized Power BI reports by refining DAX formulas and data models, resulting in faster load times and smoother user experience.
- Developed end-to-end Power BI reports, handling everything from data extraction and transformation to designing interactive dashboards and visualizations.
- Used Git for version control.
Senior Business Analyst
TEAM COMPUTERS
Mumbai
01.2017 - 08.2023
- Developed Qlik Sense, QlikView, and Power BI dashboards with advanced visualizations, KPIs, and DAX measures for data-driven insights.
- Created interactive mashups using HTML, JavaScript, and CSS for embedding Qlik visualizations in web portals.
- Automated data extraction, transformation, and loading (ETL) using Qlik scripting and incremental load processes.
- Designed SQL stored procedures, views, and queries to support complex reporting and data modeling.
- Implemented row-level and section access security in Qlik Sense and Power BI for data governance.
- Executed migration projects from QlikView to Qlik Sense and from Qlik to Power BI, improving usability and performance.
- Utilized N-Printing to distribute report snippets and data, and leveraged the integrated EDX framework for task triggering and monitoring database timing within QMC to ensure timely execution.
- Managed Qlik Management Console (QMC) tasks, server monitoring, and performance tuning.
- Utilized Set Analysis, DAX functions, and data modeling to enable dynamic, high-performance analytics.
- Used Vizlib tools in Qlik Sense to add extra charts and make reports more interactive.
- Set up security rules to control who can see what data, based on their role.
- Built dashboards with clickable filters and drill-down options so users can explore data on their own.
- Streamlined Qlik Sense data scripts and expressions to reduce data load times and speed up calculations.
Education
MASTER IN COMPUTER APPLICATION -
University of Mumbai
Mumbai01.2016
BACHELOR OF SCIENCE - INFORMATION TECHNOLOGY
University of Mumbai
Mumbai01.2012
Skills
- Power BI
- QlikView
- Qlik Sense
- N-printing
- Mashup
- SQL Server
- Oracle
- Azure
- Databricks
- DAX programming
- ETL processes
- Data visualization
Awards
- Power BI (PL-300) Certification
- Outstanding Achievement Award (Team Computers)
Certification
PL 300
Timeline
Lead
HTC GLOBAL SERVICES
01.2023 - Current
Senior Business Analyst
TEAM COMPUTERS
01.2017 - 08.2023
MASTER IN COMPUTER APPLICATION -
University of Mumbai
BACHELOR OF SCIENCE - INFORMATION TECHNOLOGY
University of Mumbai