ASHLESHA BIJAGARE
Pune
Summary
Results-driven Business Intelligence Developer with 5+ years of experience in designing, developing, and delivering enterprise Business Intelligence solutions using Power BI, Tableau, SQL, DAX, Power Query, SSIS, Dataverse (Dynamics 365 CRM), Snowflake, Amazon Redshift, and BigQuery. Experienced across the complete Business Intelligence lifecycle, including requirement analysis, data extraction, data transformation, data modeling, dashboard development, KPI reporting, report optimization, data validation, deployment, and production support. Strong exposure to Insurance, Finance, Healthcare, Retail, and Customer Experience domains with hands-on experience delivering scalable reporting solutions in Agile environments.
Overview
1
1
Certification
8
8
years of professional experience
Work History
Business Intelligence Developer
Xoriant Solutions Pvt. Ltd.
07.2025 - Current
- Designed and developed enterprise Power BI dashboards for Insurance Finance reporting using Microsoft Dynamics 365 CRM (Dataverse) as the primary data source.
- Developed interactive dashboards that delivered financial KPIs, operational metrics, trend analysis, and executive reporting to enhance decision-making.
- Performed end-to-end ETL activities including data extraction, cleansing, transformation, and loading using Power Query.
- Designed Star Schema data models and established optimized relationships for efficient reporting.
- Developed advanced DAX measures and calculated columns using CALCULATE, FILTER, SWITCH, SUMX, TREATAS, Time Intelligence functions, and other analytical calculations.
- Published reports to Power BI Service and configured Scheduled Refresh for automated report updates.
- Implemented Row-Level Security (RLS) to ensure secure role-based access.
- Collaborated with business stakeholders to gather reporting requirements and translate them into scalable BI solutions that aligned with business objectives.
- Optimized dashboard performance using efficient DAX calculations, Power Query transformations, and data model enhancements, resulting in improved report responsiveness.
Software Engineer
BCT Consulting Pvt. Ltd.
Pune
07.2024 - 03.2025
- Reviewed Business Requirement Documents (BRD) and Functional Requirement Documents (FRD) to understand reporting requirements.
- Gathered and integrated data from Excel, CSV, JSON, folders, and Snowflake Database.
- Performed data cleansing, transformation, and preparation using Power Query.
- Designed and developed interactive Power BI dashboards using standard and custom visualizations.
- Created reusable reports for business users to support decision-making.
- Developed PowerShell scripts to automate reporting processes.
- Migrated reporting processes from Teradata to BigQuery.
- Collaborated with business users for report validation and requirement clarification.
- Published dashboards through Power BI Service.
- Performed data validation to ensure reporting accuracy.
Software Engineer
CitiusTech Healthcare Technology Pvt. Ltd.
04.2022 - 06.2023
- Designed and developed Tableau and Power BI dashboards for Healthcare Analytics.
- Gathered business requirements through BRD and FRD analysis.
- Developed SQL queries for data extraction and reporting.
- Performed ETL activities including data transformation and validation.
- Designed interactive dashboards with KPI visualizations and drill-down capabilities.
- Optimized SQL queries and report performance.
- Worked closely with stakeholders during testing, validation, and deployment.
- Supported production issues and dashboard enhancements.
Software Engineer
Tata Consultancy Services (TCS)
11.2021 - 03.2022
- Led migration of Power BI reports from Vertica Database to Amazon Redshift.
- Recreated SQL queries in Amazon Redshift.
- Performed extensive query validation to ensure data consistency.
- Updated existing reports to new database architecture.
- Supported production deployment and testing activities.
- Worked with technical teams to resolve migration issues.
BI Developer
Cybage Software Pvt. Ltd.
08.2018 - 07.2020
- Developed ETL workflows using SQL Server and SSIS.
- Designed enterprise dashboards using Tableau and Power BI.
- Developed SQL stored procedures, views, functions, and complex queries.
- Built .NET-based reporting utilities to improve report validation.
- Maintained reporting frameworks and production support activities.
- Collaborated with cross-functional teams to deliver reporting solutions.
- Performed troubleshooting and performance optimization.
Education
Post Graduate Diploma -
CDAC – Institute of Emerging Technology
Pune01-2018
Bachelor of Engineering - Computer Science & Engineering
Prof. Ram Meghe College of Engineering & Management
01-2017
Skills
- Business Intelligence
- Microsoft Power BI Desktop
- Power BI Service
- Tableau
- Spotfire
- Amazon QuickSight
- Databases
- SQL Server
- Snowflake
- Amazon Redshift
- BigQuery
- Dataverse (Dynamics 365 CRM)
- ETL & Data Integration
- Power Query
- SSIS
- Data Cleansing
- Data Transformation
- ETL Development
- Programming
- SQL
- DAX
- PowerShell
- Data Modeling (Star Schema)
- Dashboard Development
- KPI Reporting
- Executive Dashboards
- Data Validation
- Report Optimization
- Requirement Gathering
- Business Analysis
- Agile Scrum
- UAT
- Production Deployment
- Row-Level Security (RLS)
- Scheduled Refresh
Certification
Microsoft Certified: Power BI Data Analyst Associate (PL-300)
Projects
- Insurance Finance Reporting Dashboard, Power BI, Dataverse, SQL Server, Power Query, DAX, Designed executive dashboards for Insurance Finance reporting., Developed advanced DAX calculations for financial KPIs., Created interactive reports with drill-through navigation and bookmarks., Configured Scheduled Refresh and Row-Level Security., Performed KPI validation and production deployment support.
- Healthcare Analytics Dashboard, Tableau, Power BI, Snowflake, Developed dashboards for healthcare performance monitoring., Designed KPI reports and interactive visualizations., Improved reporting efficiency through optimized SQL queries.
- Dashboard Migration Project, Power BI, Amazon Redshift, SQL Server, Successfully migrated enterprise reports from Vertica to Amazon Redshift., Validated SQL queries and ensured reporting consistency.
Personal Information
Title: Business Intelligence Developer | Power BI Developer | Data Analyst
Timeline
Business Intelligence Developer
Xoriant Solutions Pvt. Ltd.
07.2025 - Current
Software Engineer
BCT Consulting Pvt. Ltd.
07.2024 - 03.2025
Software Engineer
CitiusTech Healthcare Technology Pvt. Ltd.
04.2022 - 06.2023
Software Engineer
Tata Consultancy Services (TCS)
11.2021 - 03.2022
BI Developer
Cybage Software Pvt. Ltd.
08.2018 - 07.2020
Post Graduate Diploma -
CDAC – Institute of Emerging Technology
Bachelor of Engineering - Computer Science & Engineering
Prof. Ram Meghe College of Engineering & Management