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.

Three Point Turn is a rapidly growing startup in the analytics and IT services space, making its mark in the Canadian small business community.

• Hari served as the lead business and data analyst, with a specialization in Power BI development.
• He led a team of six data and business analysts during his tenure.
• Hari facilitated requirements gathering and project brainstorming sessions with clients' C-suite executives and key stakeholders, leading to project wins exceeding C$500,000.
• Owing to the dynamic nature of the startup, Hari gained experience across multiple domains, including manufacturing, supply chain, healthcare, and employment services, catering to clients with diverse requirements.
• He built and optimized data warehouses, ensuring efficient storage, retrieval, and processing of large datasets for analytical purposes.
• Hari delivered multiple Power BI dashboards, providing real-time data visualization and actionable business intelligence for stakeholders.
• He was highly skilled in documenting requirements and established numerous new processes that improved the company’s operations.

Lava International Ltd is a consumer electronics brand in India which manufactures and markets mobile handsets.

• Hari was part of the product marketing team working in the niche space of Market Intelligence.
• He managed a team of two data analysts working on the project.
• He led, built, and executed a PoS (Point of Sale) reporting project to enhance data accuracy and business insights.
• Designed and implemented the reporting system, ensuring seamless integration with existing PoS infrastructure.
• Collaborated with stakeholders to define key metrics and reporting requirements to meet business needs.
• Insights from Hari's project were new to the industry and the company, defining the team's strategy for the next 2 years.

Lava International Ltd is a consumer electronics brand in India which manufactures and markets mobile handsets.

• Hari was part of the product marketing team working in the niche space of Market Intelligence.

• He executed Market Intelligence projects by collecting and analyzing data to provide actionable insights for business strategy.

• He conducted thorough research to identify market trends, competitor activities, and customer behaviour.

• He delivered detailed reports and presentations to key stakeholders, highlighting key findings and recommendations.

Due to the nature of his findings and the impact it created, Hari was offered a full-time position in the team.

Infosys Technologies is an India-based IT services giant providing multiple IT solutions and services to global clients.

• Hari worked as a Systems Engineer with contributions to requirements elicitation, SQL database management and application development.

• Developed, tested, and optimized C++ applications to ensure high performance and scalability.

• Designed and implemented efficient SQL queries to improve database performance and reduce query execution time.

• Conducted performance profiling and fine-tuning of both C++ applications and SQL queries to identify bottlenecks and optimize resource usage.

• Collaborated with cross-functional teams to integrate database solutions with application logic, ensuring seamless functionality.

• Provided consulting services to clients, offering insights on SQL database architecture and optimization strategies.

• Delivered recommendations for improving database indexing, query structure, and schema design to maximize efficiency.