Brindha Devi

Data Analyst

[email protected]

Resume

Hello, I am

Brindha Devi.

1

Excel
Project

1

PowerBI
Project

1

SQL
Project

About Me

As a passionate Data Analyst, I specialize in transforming complex data into actionable insights. With a keen eye for detail and a drive for continuous improvement, I leverage my expertise in Excel, Power BI, and SQL to tackle diverse data challenges.

Core Competencies:

➜ Power BI Dashboards: Crafting visually compelling, interactive dashboards that drive data-driven decisions and maximize user engagement.
➜ Data Quality Assurance: Leveraging advanced data cleaning techniques, including standardization, deduplication, and validation, to ensure accuracy and integrity.
➜ Advanced SQL: Proficient in extracting, manipulating, and analyzing data with complex queries to deliver insightful, actionable results.
➜ Strategic Data Solutions: Delivering innovative, data-driven solutions to solve business challenges, creating value across industries.

Key Skills

PYTHON

SQL

POWER BI

EXCEL

DATA VISUALIZATION

ANALYTICAL THINKING

My Projects

Sales and Finance Report

Domain/Function: FMCG

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Domain/Function: brick & mortar and e-commerce

Sales and Market Insights

Domain/Function: Brick & Mortar

My Experience

Amazon Development Center India, Quality Analyst 08/2022 – present | Bangalore, India

Developed and maintained interactive dashboards in Amazon QuickSight, Tableau, and Power BI, enabling data-driven decision-making.
Extracted, cleaned, and analyzed large datasets using SQL, identifying key trends and insights to enhance operational efficiency.
Designed and implemented dynamic dashboards and real-time KPI tracking systems, streamlining reporting for leadership and operations teams.
Performed data audits and compliance checks, leveraging visualization tools to track performance metrics and optimize processes.
Utilized SQL queries to generate ad hoc reports, supporting business teams in identifying productivity gaps and improvement opportunities.
Designed automated reporting solutions, reducing manual efforts and improving data accuracy for leadership insights.
Implemented LLM-driven automation, streamlining quality analysis processes and enhancing data-driven decision-making.
Curated customized reports and interactive visual narratives, coaching team members on effective data storytelling for stakeholder presentations

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Mail Me

[email protected]

https://www.linkedin.com/in/brindha-devi-analyst/

GitHub

https://github.com/BrindhaDevi31

Excel Project

Sales and Finance Report

Domain/Function: FMCG

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target.

View Project
on GitHUB

Customer Performance Report: Provides net sales performance of each customer across years

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

Project Details

In this project, I created a sales report using excel pivot tables which will enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their sales activities. By leveraging sales data analysis, businesses can unlock new opportunities, drive growth, and stay competitive in the dynamic market landscape.

PowerBI Project

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Domain/Function: brick & mortar and e-commerce

AtliQ Hardware's is a consumer electronics company expanding rapidly but is not able to compete with other companies using data as most of their report still exists in Excel. My goal is to implement an advanced analytics solution using Power BI that will enable the company to get valuable insights.

This is the finance view, which shows the important details of finance such as revenue, profit, cost, budget, variance, and ROI.

This is the executive view, which shows the key indicators of the company’s performance and how it compares to its competitors.

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following
1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

SQL Project

Sales and Market Insights

Domain/Function: Brick & Mortar

I analyzed over 1 million rows of AtliQ Hardware sales data using MySQL, optimizing database objects like views, stored procedures, and functions. By leveraging advanced SQL techniques, I streamlined complex queries to identify top customers, products, and markets.

View Project
on GitHUB

The image displays an SQL query in MySQL Workbench to retrieve the top 10 markets by net sales for the year 2020.

The image shows an SQL project using MySQL Workbench to retrieve the top 10 customers by net sales in India for the year 2021.

Project Details

This project involved analyzing over 1 million rows of Atliq Hardware sales data to extract meaningful insights for business decision-making. By working with MySQL, I performed end-to-end database management and utilized advanced SQL techniques to streamline data analysis and reporting. The project provided hands-on experience in analyzing large datasets, optimizing query performance, and deriving actionable insights to improve sales strategies.
Steps Followed:
1.Data Import and Setup
2.Database Object Management
3.Exploratory Data Analysis
4.Query Optimization
5.Insight Generation
6.Reporting and Visualization
7.Review and Learning

Learning Outcomes:
1.SQL Query Writing
2.Database Management
3.Data Import and Export
4.Query Optimization
5.Data Cleaning and Preparation
6.Generating Business Insights
7.Impactful Reporting