Développeur Microsoft Power BI

Metrolinx Inc. is a Canadian transportation agency that manages and integrates rail and road public transportation projects across Ontario, Canada.

• Conceptualized data architecture, modeled, and implemented end-to-end data solutions for the property acquisitions team at Metrolinx Inc.
• Built comprehensive data pipelines using Azure Data Factory and Microsoft Fabric, automating all manual processes within the team.
• Utilized Python and Pandas to automate data preparation tasks, including cleaning, transformations, and integrating data quality principles.
• Developed multiple Power BI dataflows and automated ETL processes using Fabric pipelines to streamline data integration.
• Created several Power BI reports and dashboards, tracking key metrics such as Net Operating Income, Price per Square Foot, Acquisition Cost, and Process Time.
• Provided analytics and insights to over 150 team members, enhancing decision-making capabilities across the organization.
• Reduced data cleaning time from 1.5 hours to under 10 minutes, significantly improving team productivity and efficiency.

S&P Global is an American financial institution that provides services in financial benchmarking, data, ratings, and other insights to support companies and countries.

• Hari worked as the sole Power BI developer and point of contact (POC) for managing the reporting capabilities of a US$1 billion migration program impacting global businesses.
• He conceptualized requirements and developed data models, pipelines, and Power BI reports and dashboards.
• Hari worked with a wide variety of data sources, including Azure SQL, ServiceNow (via Dremio), Power BI Dataflows, and SharePoint flat files.
• He built Power Apps, and Power Automate workflows which not only streamlined data consumption but also reduced the error rate drastically.
• He also managed data governance, Git repositories, and other Power BI administrative functionalities, streamlining the user experience for over 100 senior program managers and directors.

In addition, he created innovative custom visuals using D3.js (beyond his core competency) and other Python visualization libraries and packages, transforming business perspectives on reporting.

Due to his exceptional performance and expertise, his contract was extended multiple times— a rare occurrence in that domain.

Enbridge is a multinational energy and utilities company specializing in oil and gas transportation through the world’s most complex pipeline network for liquid fuel.

Hari served as the primary data engineer and Power BI developer, overseeing data pipelines as well as data preprocessing and cleaning modules.

• He utilized tools such as Azure SQL, Azure ML, Azure Data Factory, ADLS Gen2, and PySpark on Databricks to manage project and technical requirements.
• Hari developed end-to-end data pipelines to transform complex real-time sensor data, integrating over 40 data sources, including flat files, Parquet files, SQL, and SharePoint.
• He optimized pipeline performance, ensuring scalability and efficiency for the data science project.
• Hari created four organization-level Power BI reports visualizing insights from ML project in-tune of US$4 million in savings on pipeline operations.

Analytics 247 is an analytics consulting firm started by Hari, providing deep insights to small businesses at low costs.

• Developed descriptive and predictive analytics solutions for restaurants using Power BI and SQL to provide actionable insights into business performance.
• Designed and implemented SQL queries to extract, clean, and analyze historical data, identifying trends in sales, customer behaviour, and inventory management.
• Built Power BI dashboards to visualize key metrics such as daily sales, customer visits, menu performance, and operational efficiency.
• Created predictive models using historical data to forecast future sales, customer demand, and inventory needs, enabling proactive decision-making.

Proctor & Gamble (P&G) is a global Consumer Packaged Goods giant dealing in everyday essentials.

• Hari is the single POC for P&G product analytics capabilities for 2500 Loblaws (LCL) and Shopper's Drug Mart locations across Canada.
• He developed comprehensive analytics solutions to track and evaluate product performance across multiple retail channels.
• He designed and implemented data models to analyze sales, inventory, and customer behaviour for P&G products nationally.
• Hari integrated product analytics tools into existing systems, providing real-time insights to key stakeholders in both retail chains.
• He built speciality reporting capabilities in Power BI, Spotfire, and Knime which addressed metrics like Phantom Inventory, marketing spend, predictive customer spend and customer basket analysis.