PRIYANKA SAMAL

BI LEAD

Group One Automotive

09.2018 - Current

Company Overview: formerly Inchcape PLC, UK
Led the end-to-end delivery of Business Intelligence solutions using Power BI, from requirements gathering to dashboard deployment and user training across onshore and offshore teams
Managed a cross-functional team of data analysts, BI developers, and data engineers across onshore and offshore locations, ensuring consistent delivery and resource optimization.
Partnered with business stakeholders to define KPIs, reporting needs, and performance metrics aligned with strategic objectives.
Delivered enterprise-grade Power BI dashboards that improved visibility into sales performance, operational efficiency, and financial reporting.
Oversaw data modeling, DAX development, and integration with Azure, SQL Server, Excel, and other enterprise data sources.
Defined and enforced BI delivery frameworks, standards, and governance processes to ensure high-quality and scalable reporting.
Improved report delivery timelines by 30% through automation, Agile project management, and prioritization workflows.
Managed stakeholder expectations and provided regular status updates, risk mitigation plans, and post-delivery support.
Drove user adoption through training sessions, documentation, and Power BI Center of Excellence initiatives.
Designed 40+ SSIS packages to automate data integration from various sources including SQL Server, Oracle, ODBC Data sources, MySQL, flat files, APIs, 3rd Party groups, Internal File server folders, Internal FTP and SFTP, Outlook 365 using OAuth, RPA and Azure databases.
Solely responsible to import 20+ email attachments and hyperlinks using OAuth by registering and Application in Azure and calling it through Graph API.
Led in the migration from on-premises SQL Server to Azure VM.
Developed 50+ Power BI dashboards and paginated reports, improving decision-making in Operations, Marketing, OEM departments with automated data refresh via gateways.
Created semantic models using Power BI Dataflows and Shared Datasets.
Wrote advanced DAX measures for custom metrics (various Year based calculations, rolling averages, RANKX-based KPIs etc).
Implemented Bookmarks, Slicers, Filters, page navigation, Drill-through, Drill-down, Tooltips.
Used Power Query for Data cleansing, merge and append queries and conditional columns.
Publish Power BI reports as an APP and sharing it with users who have the appropriate access permissions to view its content from the Power BI service or the Power BI mobile app.
Set up row-level security (RLS), Workspace roles and Permissions for user-specific report access.
Responsible for Gateway configuration, Scheduled refresh setup, Workspace publishing, dashboard sharing and Version control (SharePoint).
Solely responsible for implementing automation or trigger Power BI Dataset and Dataflow refresh by calling it from SQL server agent job allowing a Service Principle to access the Power BI Api’s through PowerShell scripts.
Developed SSRS reports used across Health & Safety, Enquiries and Customer Complaints departments.
Developed paginated reports, sub reports, automated report subscriptions (both email and File share) called by SQL server agent jobs and in SSIS packages.
Also, a Microsoft 365 admin to grant Power BI Group access to the new users as required.
Created thorough documentation and conducted training sessions for internal teams.
Formerly Inchcape PLC, UK