# Ratchagan Ranganathan

Ratchagan Ranganathan is a remote worker on Himalayas, Data Analyst Intern at BDREAMS GLOBAL SOLUTIONS, based in India.

Source: https://himalayas.app/@ratchaganranganathan

```text
Data Analyst Intern at BDREAMS GLOBAL SOLUTIONS, turning pharmacy sales and customer data into dashboards and business insights.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | India |
| Authorized to work in | India |
| Salary expectations | 70k+ INR |
| Job categories | Data Analyst |
| Skills | Data Analysis, Python, Pandas, SQL, MySQL, Power BI, Excel, Power Query, Power Pivot, DAX, SQLAlchemy, ETL, Data Cleaning, Data Wrangling, Exploratory Data Analysis |
| LinkedIn | https://linkedin.com/in/ratchagan99 |

## What I'm looking for

```text
I'm seeking a Data Analyst role where I can deliver data-driven insights that support business decisions.
```

## About

```text
At BDREAMS GLOBAL SOLUTIONS, I clean and transform business data across analytics projects and turn it into reports and dashboards. My work includes tracking five pharmacy sales KPIs across ₹71.5L in sales, with a reported profit margin of 44%.

I developed an interactive Power BI dashboard to analyse customer shopping behaviour by age group, category, and subscription status. The analysis found a 71% customer subscription rate and identified the Mid-Age segment as the top revenue contributor.

For the Apollo Pharmacy Executive Dashboard project, I combined billing data with Power Query, modelled it in Power Pivot, and created an Excel dashboard. It highlighted the Salbutamol Inhaler as the highest-revenue product at ₹9.5L and showed stable monthly sales of ₹5.5L–₹6.2L.

In my customer shopping analysis project, I cleaned data with pandas, loaded it into MySQL using SQLAlchemy, and wrote 11 business queries. I also hold an MBA in Logistics & Finance and a B.COM in Computer Applications.
```

## Experience

### Data Analyst Intern (current)

BDREAMS GLOBAL SOLUTIONS. May 2026 - Present

```text
Cleaned, transformed, and standardised business data using Python (pandas) and Power Query (ETL) across 2 analytics projects. Built MIS reports and an Excel dashboard tracking 5 KPIs, wrote 11 SQL queries for revenue analysis, and developed an interactive Power BI dashboard with KPI cards, charts, and slicers.
```

Skills: Python, Pandas, Power-Query, Power-Pivot, DAX, Excel, SQL, Power-BI, Data-Cleaning, ETL, MIS-Reporting, Dashboard-Creation, KPI-Tracking, Customer-Segmentation, Trend-Analysis

### HR Recruitment Intern

JSJ Group of Companies. Jun 2025 - Jun 2025

```text
Screened and shortlisted candidate data by matching resume information against job description criteria. Maintained candidate tracking records in MS Excel using Pivot Tables and filters, and prepared structured documentation and summary reports.
```

Skills: Excel, Pivot-Tables, Data-Entry, Data-Comparison, MIS-Reporting, Documentation

## Education

### Besant Technologies

Data Analytics Course, Data Analytics

```text
Enrolled in a Data Analytics Course; certificate awaited.
```

### S.I.V.E.T Arts & Science College

MBA, Logistics and Finance. 2024 - Present. Grade: 72%

```text
Pursuing an MBA in Logistics and Finance with an aggregate of 72%.
```

### Saraswathy Arts & Science College

B.COM, Computer Applications. 2021 - 2024. Grade: 69%

```text
Completed B.COM in Computer Applications with an aggregate of 69%.
```

### HubSpot Academy

Content Marketing Certification, Content Marketing. 2024 - 2024

```text
Earned a Content Marketing Certification from HubSpot Academy.
```

### St. Joseph of Cluny Mat. Hr. Sec. School

Class XII, General. Grade: 80%

```text
Completed Class XII under the State Board with an aggregate of 80%.
```

## Tech stack

- Pandas
- MySQL
- Google Docs
- Python
- SQLAlchemy
- Google Workspace
- Google Sheets
- Microsoft Excel
- SQL
- Microsoft Word
- Power BI
- Microsoft PowerPoint
- Power Query

To contact Ratchagan, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [NIRANJANA Niru](https://himalayas.app/@niranjananiru): Data Analyst Intern, BDreamz Global Solutions Private Limited
- [Bitan Patra](https://himalayas.app/@bitanpatra): Data Analyst, Personal Projects
- [Sumit Kumar](https://himalayas.app/@sumitkumar24): Data Analyst Intern, Self Directed Projects
- [Siri Chandana](https://himalayas.app/@sirichandana): Intern Data Analyst, Analytics Space
- [Ramya D N](https://himalayas.app/@ramyadn): Data Analyst Intern, BDreamz Global Solutions Private Limited
- [Koushik Cherukuri](https://himalayas.app/@koushikcherukuri): Data Analyst Intern, BDreamz Global Solutions Pvt Ltd
- [Praveen A](https://himalayas.app/@praveena): Data Analyst, Bdreamz Global Solution Pvt Ltd
- [Keerthika S](https://himalayas.app/@keerthikas): Data Analyst Intern, BDreamz Global Solutions
- [Mohamed Arshath](https://himalayas.app/@mohamedarshath1): Data Analyst Intern, BDreamz Global Solutions Pvt Ltd.
- [hridhya paul](https://himalayas.app/@hridhyapaul): Data Analyst Intern, BDREAMZ Global Solutions Pvt. Ltd.
