Skip to main content
Ratchagan RanganathanRR
Looking for a job

Ratchagan Ranganathan

@ratchaganranganathan

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

India
Message

What I'm looking for

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

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

Work history, roles, and key accomplishments

BS
Current

Data Analyst Intern

BDREAMS GLOBAL SOLUTIONS

May 2026 - Present (6 months)

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.

JC

HR Recruitment Intern

JSJ Group of Companies

Jun 2025 - Jun 2025 (0 months)

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.

Education

Degrees, certifications, and relevant coursework

BT

Besant Technologies

Data Analytics Course, Data Analytics

Enrolled in a Data Analytics Course; certificate awaited.

SC

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

MBA, Logistics and Finance

2024 -

Grade: 72%

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

SC

Saraswathy Arts & Science College

B.COM, Computer Applications

2021 - 2024

Grade: 69%

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

HA

HubSpot Academy

Content Marketing Certification, Content Marketing

2024 - 2024

Earned a Content Marketing Certification from HubSpot Academy.

SS

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

Class XII, General

Grade: 80%

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

Availability

Looking for a job

Location

India

Authorized to work in

Salary expectations

70k+ INR

Job categories

Interested in hiring Ratchagan?

You can contact Ratchagan and 600K+ other talented remote workers on Himalayas.

Message Ratchagan

People also viewed

View all talent

Get matched with your dream remote job

Sign up now and join over 1,000,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!

Sign up
Himalayas profile for an example user named Frankie Sullivan