Sudharsan P

Seasoned Data Analyst and Power BI Developer with over 4 years of hands-on experience in designing and developing business intelligence solutions. Proven expertise in Power BI, SQL, DAX, Power Query Editor, and Tableau for creating insightful dashboards and interactive reports. Skilled in data modeling, data transformation, and integrating data from multiple sources to drive strategic decision-making. Strong analytical mindset, with a solid understanding of business requirements, and the ability to translate them into effective, data-driven solutions.

Sales & Finance Analytics

QSC Client: QSC – Costa Mesa, Canada

Role: Power BI Developer

Environment: Power BI, Azure Data Factory, Python, SQL

Project Description:

QSC is a U.S.-based manufacturer specializing in audio, video, and control solutions, known for its Q-SYS networked AV platform. The objective was to develop a BI solution to analyze sales and financial performance data across regions

Responsibilities:

Collaborated with business stakeholders to analyze requirements and define business rules

Designed entity-relationship (ER) diagrams to model the data architecture

Developed robust semantic data models in Power BI, enabling dynamic reporting.

Created calculated columns, measures, and KPIs using complex DAX logic.

Performed end-to-end ETL processes including data cleansing, transformation, and loading using Azure Data Factory.

Utilized SQL and Python for data integration, advanced joins, and custom transformations

Delivered visually compelling and interactive dashboards to monitor sales trends and financial metrics

Online Store Analysis

Client: One Kings Lane – San Francisco

Role: Power BI Developer

Environment: Power BI (Desktop & Service), Oracle

Project Description:

One Kings Lane is a premier online home décor retailer offering exclusive designer pieces, vintage finds, and curated home goods. The goal was to develop a reporting solution to analyze customer behavior, product performance, and sales trends.

Responsibilities:

Connected Power BI to Oracle databases to extract and analyze large volumes of sales and product data

Developed interactive dashboards and reports to track KPIs, such as revenue, conversion rates, and top-performing product categories

Designed intuitive report visuals using Power BI Desktop and published dashboards to Power BI Service for business users

Created data models using star schema, and implemented calculated columns and measures with DAX

Utilized Power Query for data transformation, filtering, and merging multiple datasets, and collaborated with business teams to gather requirements and deliver actionable insights for marketing and inventory strategies

Sales Analytics and Reporting

Client: Farmfoods – United Kingdom

Role: Power BI Developer

Enviroment: Power BI, SQL, Oracle

Project Description:

Farmfoods is a British frozen food and grocery supermarket chain headquartered in Cumbernauld, Scotland, with over 300 stores across the UK. The project aimed to develop an end-to-end sales analytics solution to enhance performance tracking and business decision-making

Responsibilities:

Developed and deployed interactive Power BI dashboards and visualizations for daily sales, store-wise performance, product trends, and inventory tracking

Performed data extraction, transformation, and loading (ETL) using Oracle SQL to consolidate large volumes of sales data

Designed efficient data models and relationships to support real-time reporting

Created DAX measures for key performance indicators (KPIs), such as total sales, average basket value, and sales growth

Collaborated with business stakeholders to gather requirements and deliver customized reporting solutions

Conducted performance optimization of SQL queries and Power BI reports for faster loading times