Sony Budigae
North York,ON
Summary
Senior Power BI Developer with 6+ years of experience in transforming business data into interactive and insightful dashboards and reports. Expert in the Microsoft Power Platform, DAX, Power Query, SQL, and data modeling. Proven ability to gather business requirements, design scalable data models, and deliver real-time analytics solutions that drive data-driven decision-making. Experienced in working with cross-functional teams and delivering enterprise-level BI solutions in Agile environments.
Overview
9
9
years of professional experience
Work History
Senior Power BI Developer
Loblaw Digital
Toronto, Canada
06.2022 - Current
- Developed complex DAX calculations including time intelligence, KPIs, and aggregation formulas, enabling advanced reporting like year-over-year analysis and trend forecasting.
- Created custom Power BI visuals and interactive themes to ensure consistent branding and enhance user experience while displaying critical metrics.
- Built and optimized Power BI dataflows to automate data transformation and centralize data prep logic, reducing redundancy and improving reusability across multiple reports.
- Integrated Power BI with Azure Synapse Analytics and Azure Data Factory pipelines to enable real-time data processing and reporting, enhancing the timeliness and accuracy of business intelligence insights.
- Implemented Row-Level Security (RLS) to ensure that users could only access data relevant to their role, maintaining data confidentiality and compliance with access policies.
- Worked with data engineers to ensure data quality by validating data from source systems, optimizing ETL processes, and integrating data from multiple internal and external sources.
- Optimized Power BI report performance by using techniques such as aggregating data at the source level, optimizing DAX formulas, and creating indexes for large datasets, reducing load times.
- Leveraged Power Query (M Language) for data transformation tasks, such as merging, appending, and filtering data from disparate sources like SQL Server, Excel, and APIs.
- Collaborated with cross-functional teams including analysts and business users to gather reporting requirements, translating them into technical specifications and user-friendly Power BI reports.
- Automated Power BI report refresh schedules to ensure that data remained up to date, leveraging Power BI Service for scheduled refreshes and integration with Azure DevOps for version control and deployment.
- Embedded Power BI reports into internal web applications using Power BI Embedded and JavaScript APIs, providing seamless integration for stakeholders.
- Developed dynamic drill-through features to allow users to explore detailed data in reports with a single click, improving the self-service BI experience.
- Performed regular data audits and applied data validation rules to ensure the integrity and accuracy of data used in Power BI reports, mitigating potential reporting errors.
- Conducted training workshops for business users, educating them on best practices in Power BI report navigation, self-service features, and data-driven decision-making.
Power BI Developer
Winota Softech
Bangalore, India
05.2016 - 05.2020
- Migrated legacy SSRS reports to Power BI, significantly reducing report generation time and improving accessibility through a more interactive interface.
- Designed and built data models using SQL Server and Power BI Desktop, incorporating data for sales, inventory, and customer behavior, providing actionable business insights.
- Developed Power BI dashboards to track key business metrics, such as sales performance, inventory turnover, and customer buying patterns, enabling better decision-making.
- Optimized DAX measures and formulas to enhance query performance and ensure real-time reporting, reducing model size and improving processing times.
- Automated data refresh schedules in Power BI Service to ensure business users always have access to the most up-to-date information without manual intervention.
- Implemented error-handling alerts within Power BI Service to notify stakeholders of any issues with data refreshes or report availability, minimizing downtime.
- Collaborated with stakeholders to define KPIs and developed reporting solutions that align with business goals, ensuring reports delivered relevant and actionable data.
- Worked with business analysts to convert business requirements into technical Power BI solutions, ensuring the final product was tailored to user needs.
- Created custom Power BI visuals and reports tailored to business needs, improving user engagement and presenting complex data in a more digestible format.
- Built custom Power Query transformations to cleanse and prepare data from multiple sources, ensuring accuracy and consistency in reporting.
- Utilized Power Query (M Language) to perform advanced data transformations such as data merging, pivoting, and appending, enabling effective reporting.
- Implemented dynamic drill-through features in Power BI, allowing users to explore detailed data from summary views for deeper analysis.
- Integrated Power BI with Azure SQL Database, enabling seamless access to large datasets for reporting and improving data storage capabilities.
- Optimized report performance by reducing model size, simplifying DAX calculations, and ensuring quicker report load times.
- Leveraged Power Automate to automate the distribution of reports and data update notifications, streamlining workflows and ensuring timely delivery of insights.
- Developed and maintained Row-Level Security (RLS) to ensure users only access data relevant to their roles, maintaining data confidentiality.
- Performed data validation checks to ensure the integrity of the data used in reports, reducing the risk of incorrect analysis and decision-making.
- Worked closely with IT teams to ensure proper data governance and access to data sources, ensuring reports followed company-wide data management practices.
- Created and maintained comprehensive documentation for Power BI report designs, data models, and DAX formulas, ensuring future updates are manageable.
- Trained business users on Power BI best practices, enabling them to create self-service reports and reducing reliance on IT for report creation.
- Continuously refined dashboards and reports based on user feedback, ensuring that reports remained relevant and useful to business stakeholders.
Education
Post Graduate Diploma - Cloud Computing
Loyalist College
Toronto, ON01-2023
Master of Science - Computer Science
Silicon Valley University
San Jose, CA01-2015
Bachelor of Science - Computer Science Engineering
JNTU Hyderabad
Hyderabad,TS01-2011
Skills
- Power BI
- DAX
- Power Query
- Tableau
- SSRS
- SQL
- Python
- SQL Server
- Oracle
- MySQL
- SSIS
- Alteryx
- Star Schema
- Snowflake Schema
- Data Warehousing
- Fact and Dimension tables
- Azure Synapse
- Azure Data Lake
- AWS RDS
References
References available upon request.
Timeline
Senior Power BI Developer
Loblaw Digital
06.2022 - Current
Power BI Developer
Winota Softech
05.2016 - 05.2020
Post Graduate Diploma - Cloud Computing
Loyalist College
Master of Science - Computer Science
Silicon Valley University
Bachelor of Science - Computer Science Engineering
JNTU Hyderabad
Similar Profiles
Hannah BeckfordHannah Beckford
Merchandising E-commerce Analyst- Shoppers Drug Mart at Loblaw DigitalMerchandising E-commerce Analyst- Shoppers Drug Mart at Loblaw Digital
SATYA SAIRAM POTHULASATYA SAIRAM POTHULA
Senior Analyst at Loblaw DigitalSenior Analyst at Loblaw Digital
Gugulami JamelaGugulami Jamela
Sr Site Experience Manager at Loblaw DigitalSr Site Experience Manager at Loblaw Digital
Shahram Asghar ZadehShahram Asghar Zadeh
Cook at MyselfCook at Myself
Jeet P ParmarJeet P Parmar
CAP 3 Associate at Walmart CanadaCAP 3 Associate at Walmart Canada