
Ratchagan Ranganathan
@ratchaganranganathan
Data Analyst Intern at BDREAMS GLOBAL SOLUTIONS, turning pharmacy sales and customer data into dashboards and business insights.
What I'm looking for
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
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.
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
Besant Technologies
Data Analytics Course, Data Analytics
Enrolled in a Data Analytics Course; certificate awaited.
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%.
Saraswathy Arts & Science College
B.COM, Computer Applications
2021 - 2024
Grade: 69%
Completed B.COM in Computer Applications with an aggregate of 69%.
HubSpot Academy
Content Marketing Certification, Content Marketing
2024 - 2024
Earned a Content Marketing Certification from HubSpot Academy.
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%.
Tech stack
Software and tools used professionally
Availability
Location
Authorized to work in
Salary expectations
Social media
Job categories
Interested in hiring Ratchagan?
You can contact Ratchagan and 600K+ other talented remote workers on Himalayas.
Message RatchaganGet 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!
