# Ratna Kumari

Ratna Kumari is a remote worker on Himalayas, Associate Data Analyst at Novartis, based in India.

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

```text
Power BI Developer at Novartis, building market performance dashboards with 99%+ reporting accuracy.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | India |
| Authorized to work in | India |
| Salary expectations | 140k+ INR |
| Job categories | Power BI Developer, Business Intelligence Analyst, Data Analyst, Power BI Analyst |
| Skills | Power BI, DAX, SQL, Power Query, Data Modeling, ETL, data transformation, Data Validation, Data Cleaning, Star Schemas, Dimensional Modeling (Star And Snowflake Schemas), KPI Reporting, Market Share Analysis, Pharmaceutical Sales Analytics, Brand Reporting |

## About

```text
At Novartis, I developed Power BI dashboards to track Cosentyx market performance and Gulf sales trends across UAE and Kuwait. These reports brought together data from multiple sources to support market and business decision-making.

For the APMA Cosentyx LT Tracker, I created DAX calculations for YTD, MAT, prior-year comparisons, growth, and market share. I also added interactive filters and drill-through features, and validated and reconciled data to maintain 99%+ reporting accuracy.

On the GULF IQVIA Dashboard, I developed interactive reports for tracking sales trends and business KPIs. I configured scheduled refreshes using Data Gateway and built measures and visuals to help users analyze performance by country, product, market, and time period.

My work spans Power BI reporting and dashboard development, SQL, and healthcare analytics, including pharma sales and brand performance reporting. I also have experience with Tableau and migrating reports from platforms such as Excel and Qlik.
```

## Experience

### Associate Data Analyst

[Novartis](https://himalayas.app/companies/novartis). Nov 2024 - Jun 2026

```text
Developed Power BI dashboards for market performance tracking, including advanced DAX calculations and data validation. Managed report security and created visualizations to support business decisions.
```

Skills: Power-BI, DAX, SQL, Excel, Power-Query, SharePoint, Data-Validation, Data-Modeling, KPI-Reporting

### Power BI Analyst

Lumminaire Technologies. Jun 2021 - Nov 2023

```text
Developed Power BI reports and dashboards, imported data from multiple sources, and created relationships and measures using DAX. Published reports to Power BI Service and configured scheduled refreshes.
```

Skills: Power-BI, DAX, SQL, Power-Query, Data-Modeling, Data-Visualization, Power-BI-Service

## Education

### M.Sc. Computer Science

Master of Science, Computer Science

```text
Graduated with a Master of Science in Computer Science in 2023.
```

### B.Sc. Computer Science

Bachelor of Science, Computer Science

```text
Graduated with a Bachelor of Science in Computer Science in 2011.
```

## Tech stack

- Tableau
- MySQL
- Oracle
- Microsoft Excel
- SQL
- Power BI
- Microsoft PowerPoint
- Power Query

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

## People also viewed

- [Vikrant Patil](https://himalayas.app/@vikrantpatil): Senior Analyst, Supply Chain Analytics, Ecolab
- [Ram Kumar](https://himalayas.app/@ramkumar2): Power BI Developer, Venzo Technologies
- [Syed Ahamed](https://himalayas.app/@syedahamed): Power BI Developer, American Family Insurance
- [Shobitha S](https://himalayas.app/@shobithas): Data Analyst / Power BI Developer, Aon Consulting
- [Manjima Ghosh](https://himalayas.app/@manjimaghosh): Enterprise Diagnostic Insights Platform, Siemens Healthineers
- [resham nagpal](https://himalayas.app/@reshamnagpal): Senior AIA Developer, Cognizant
- [Rasika Mhetre](https://himalayas.app/@rasikamhetre): Specialist Payment Accuracy I, Cotiviti
- [A Devesh Manav](https://himalayas.app/@adeveshmanav): Reporting and Insights Analyst, Omnicom Global Solutions
- [Saurabh Biswas](https://himalayas.app/@saurabhbiswas): Analyst, Sanofi
- [Vasumathi J Y](https://himalayas.app/@vasumathijy): Measurement and Reporting Associate, Accenture