Ratna Kumari

Results-driven Business Analyst with 1.8 years of experience at Novartis in Power BI, SQL, Data Analytics, and Business Intelligence. Proven expertise in designing interactive dashboards, building DAX data models, and performing ETL processes to deliver actionable pharma market insights. Hands-on experience managing APMA Region brand performance reporting for Kesimpta, Zolgensma, and Plavitto — including monthly P4L deck updates, Business Excellence external slides using IQVIA PADDS, and country-level KPI tracking.

Strong analytical, problem-solving, and cross-functional stakeholder collaboration skills.

Business Analyst – APMA Brand & Performance Analytics - Novartis

(2024-11)

• Managed and updated the APMA Business Excellence Dashboard monthly for key pharma brands: Kesimpta, Zolgensma, and Plavitto, ensuring accurate KPI and market performance data across all APMA countries.
• Prepared and delivered monthly P4L (Plan-for-Launch) deck updates, consolidating YTD and MAT metrics using IQVIA PADDS data in collaboration with Country CPO teams.
• Produced monthly Business Excellence external slides covering YTD and MAT brand performance, distributed to internal and external stakeholders in coordination with Country CPO teams.
• Coordinated monthly Kesimpta external slide updates, collecting and consolidating country-level sales and performance data provided by regional Country Teams for accurate reporting.
• Tracked and reported brand KPIs including YTD, MAT, and growth metrics, ensuring data accuracy and timely delivery to senior leadership and cross-functional stakeholders.
• Collaborated with cross-functional teams across APMA markets to gather, validate, and consolidate data inputs, ensuring consistency and reliability in brand performance reporting.
• Developed 10+ interactive Power BI dashboards to track market performance, sales analytics, and KPIs, enabling data-driven strategic decision-making across business units.
• Built robust data models and created complex DAX measures and calculated columns to support advanced analytics, reporting, and business intelligence requirements.
• Automated data transformation pipelines using Power Query (M Language) to streamline ETL processes, reducing manual data preparation time by approximately 40%.
• Conducted end-to-end data validation, data cleansing, and quality assurance checks to ensure data integrity and accuracy across multiple data sources.
• Enabled actionable business insights through ad hoc analysis and scheduled reports, directly supporting stakeholder decision-making and revenue optimization strategies.
• Collaborated with cross-functional teams including Sales, Marketing, and Finance to gather business requirements and translate them into analytical solutions.
• Published and managed dashboards on Power BI Service with row-level security (RLS) for secure, role-based data access.

M.Sc - Computer Science (2023)

B.Sc - Computer Science (2011)