Vandana Shetty

Client: Farmers Insurance - Onshore Lead & Power BI Developer

• Design, develop, and manage Power BI reports, dashboards, datasets, dataflows, and Power BI apps for business stakeholders.
• Lead offshore delivery for Power BI solutions, ensuring timely and high-quality report execution.
• Developed data models using Power BI relationships, star schema design, and normalization to improve reporting performance and scalability.
• Build efficient data models using Power Query and DAX, M query to improve reporting performance and insight generation.
• Performed end-to-end ETL in Power BI, including extraction, transformation, and loading into reusable datasets.
• Integrated data from SQL, SharePoint and cloud platforms to support seamless reporting workflows.
• Managed workspace administration, gateway configurations, and Row-Level Security across reports and applications.
• Optimized ETL processes and data models to improve report refresh efficiency and performance.
• Collaborated with stakeholders to define business requirements, reporting logic, and data transformation rules.
• Monitored data quality and refresh cycles to increase report reliability and reduce failures.
• Standardised and documented reporting processes to enhance governance, promote reuse, and ensure maintainability.
• Designed reusable datasets and user-friendly reporting structures to facilitate self-service analytics.
• Ensured secure data handling and role-based access controls across Power BI workspaces and apps.
• Partner with support and infrastructure teams to troubleshoot access, refresh, and deployment issues.
• Ensured secure data handling and role-based access controls across Power BI workspaces and apps.

• Designed and implemented 15+ interactive Power BI dashboards for Project Quantum using AWS, significantly improving data visibility and enabling faster, data-driven decision-making.
• Collaborated closely with product owners and business stakeholders to gather requirements and deliver scalable reporting solutions aligned with business objectives.
• Developed advanced DAX calculations to support RRP metrics, ensuring accuracy through reconciliation with backend database records.
• Converted legacy Excel-based reports into dynamic Power BI dashboards, enhancing usability, automation, and overall user experience.
• Led the migration of legacy reporting systems to Power BI, reducing report generation time and improving maintainability and scalability.
• Optimized data models by implementing data normalization techniques and best practices, resulting in improved dashboard performance and faster query execution.
• Integrated and analyzed data from AWS sources (Athena, Redshift) to create unified and reliable reporting layers.
• Improved report efficiency by implementing data modeling best practices, reducing redundancy and enhancing processing speed.
• Proactively identified opportunities to enhance user experience and streamline reporting processes, reducing manual effort and increasing adoption.
• Ensured high data quality by implementing validation checks and reconciliation processes across reports and datasets.

• Delivered high-priority business intelligence reports by leveraging SQL, AWS Redshift, Amazon RDS, and complex cross-domain business logic to generate actionable business insights.
• Designed, developed, and optimized interactive Power BI dashboards, KPI scorecards, and self-service reporting solutions using Power Query, DAX, and data modeling techniques to improve decision-making and performance visibility.
• Led offshore delivery across multiple reporting initiatives, managing priorities, tracking progress, and ensuring timely, high-quality execution.
• Partnered with business stakeholders to perform requirements gathering, data analysis, data mapping, solution design, UAT, and data reconciliation, removing delivery blockers and ensuring successful implementation.
• Standardized reporting processes, governance, and dashboard design practices to improve consistency, scalability, and maintainability across enterprise reporting solutions.
• Developed a Power Platform (Power Apps & Power Automate) solution that centralized access to 25+ business reports, improving accessibility, user experience, and operational efficiency.

• Supported FS Insights & Data reporting and analytics initiatives across delivery and stakeholder coordination.
• Partnered with multiple teams to deliver HR, demand, supply, and staff augmentation reports based on client requirements.
• Presented business information through clear data visualization and actionable reporting.
• Facilitated strategic decision-making by delivering findings and recommendations through reporting outputs.
• Created automated reports to improve team productivity and reporting efficiency.
• Analyzed large datasets to identify trends and patterns that informed business best practices.

• Created dashboards and benchmarking reports for the Fin-Pro team in the UK using AWS databases including Redshift and RDS.
• Managed day-to-day client interaction to understand goals, align expectations, and address reporting gaps.
• Developed an Excel-based benchmarking tool for insurers to provide policy-level insights for renewal quote decisions.
• Built dynamic Excel dashboards for claims analysis widely adopted by stakeholders across the group.
• Developed VBA macros for multiple teams to reduce manual effort and turnaround time.
• Created an HR recruitment dashboard in Power BI to analyze reasons for delays in the recruitment process.
• Built a Tableau data quality dashboard spanning over 100 countries to provide a consolidated view of record quality.
• Developed an HR survey dashboard in Tableau for recruitment teams to analyze employee feedback and identify corrective actions.
• Worked with the claims team to implement a Tableau-based descriptive analytics dashboard.