Arun Wadeyar
Belgaum
Summary
Experienced Power BI Developer with a proven track record of designing and developing data models, creating insightful visualizations, and delivering data-driven solutions to enhance decision-making. Proficient in data integration, report development, and data transformation using Power BI. Committed to staying current with the latest Power BI developments to drive continuous improvement.
Overview
10
10
years of professional experience
3
3
Languages
Work History
Senior Data Engineer
Tiger Analytics
04.2024 - Current
- Company Overview: Sage Therapeutics is a biopharmaceutical company focused on developing innovative therapies for central nervous system (CNS) disorders. One of their key drugs, Zurzuvae, is the first and only FDA-approved oral treatment for Postpartum Depression (PPD). Market analytics around Zurzuvae plays a vital role in understanding prescription trends, payer coverage, and healthcare provider adoption to support strategic decision-making.
- Worked closely with the Senior Marketing Director to deliver advanced market analytics and reporting solutions aligned with business goals.
- Designed and developed Payer, Insurance, ARM, and HCP reports using Power BI, enabling sales and marketing teams to track access and prescription dynamics.
- Analyzed IQVIA healthcare datasets to address business-critical questions such as: Who are the targeted HCPs
- What are the prescription trends and volumes
- How does payer coverage impact drug adoption
- Created intuitive dashboards and visualizations to effectively communicate trends, insights, and KPIs to stakeholders, improving decision-making.
- Implemented Power BI solutions involving data transformations, data modeling, DAX measures, and deployment to production.
- Leveraged advanced Power BI features such as Incremental Refresh for handling large datasets and Row-Level Security (RLS) for secure, role-based data access.
- Delivered actionable dashboards that improved visibility into Zurzuvae prescription performance, payer trends, and HCP behavior, directly supporting strategic brand planning and market expansion.
- Sage Therapeutics is a biopharmaceutical company focused on developing innovative therapies for central nervous system (CNS) disorders. One of their key drugs, Zurzuvae, is the first and only FDA-approved oral treatment for Postpartum Depression (PPD). Market analytics around Zurzuvae plays a vital role in understanding prescription trends, payer coverage, and healthcare provider adoption to support strategic decision-making.
Senior Software Engineer
SIEMENS
01.2024 - 04.2024
- Developed and optimized data models in Power BI to ensure efficient data storage and retrieval for analytical purposes.
- Created calculated measures, DAX queries, and complex calculations to derive insights and KPIs from the data.
- Designed and implemented data visualizations that effectively communicate insights and trends to end-users.
Application Development Senior Analyst
Accenture
05.2021 - 01.2024
- Designed & Developed Financials, OPEX, CAPEX & Taxation reports & used Power apps screen for any Manual Adjustment made by the users for Model Predicted values based on the historic actuals.
- Designed and developed efficient data models using Power BI.
- Collaborate with data analysts, business analysts, and other stakeholders to understand their requirements and provide data-driven solutions.
- Used Power Query to transform and clean data, ensuring it's ready for consumption in Power BI.
- Created and maintained complex data models in Power BI to support accurate and efficient reporting, using relationships, hierarchies, and calculated columns.
- Utilized DAX (Data Analysis Expressions) for complex calculations and measures.
- Connected Power BI to various data sources (SQL databases, Excel, cloud services etc.).
- Incorporated drill-through, drill-down, and filtering capabilities for enhanced user interactivity.
- Customized reports to meet specific business requirements and user preferences.
- Identified and addressed performance bottlenecks in Power BI reports and data models.
- Optimized queries and data loading processes for faster report rendering.
- Implemented role-based security to control data access within Power BI reports.
Data Engineer
Data Semantics
09.2019 - 04.2021
- Onsite Team Lead for the client Aujan Group Holding (Coca-Cola) on Power BI Technology.
- Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
- Data Analysis Expressions (DAX) to perform advanced calculations, aggregations, and create custom measures and calculated tables.
- Implemented role-based security and data access controls to protect sensitive information within the data model.
- Diagnosed and resolved issues related to data modeling, data integration, and data accuracy.
- Performed routine maintenance to keep the data model up to date.
- Build end-to-end BI solutions from conception through to successful delivery.
- Migration of reports from SAP-BO, SSRS to POWER BI.
Data Analyst
Sonata Software
01.2016 - 08.2019
- Developed tabular models that are compatible with warehouse standards.
- Creation of tables, views & stored procedures as per business requirements.
- Creating Reports using Power BI Report Server to make users visualize data in a much better way.
Education
Pre-University Education -
RLS Institute
Schooling - undefined
St. Xavier's High School
Bachelor of Engineering - Electronics and Communications
Jain University
06.2015
Skills
Power BI
SQL
Datawarehouse
Python
Data Modeling
DAX
Power Query
Excel
Snowflake
Market analytics
Awards
Annual Excellence Award for significant and outstanding contribution to the company.
Timeline
Senior Data Engineer
Tiger Analytics
04.2024 - Current
Senior Software Engineer
SIEMENS
01.2024 - 04.2024
Application Development Senior Analyst
Accenture
05.2021 - 01.2024
Data Engineer
Data Semantics
09.2019 - 04.2021
Data Analyst
Sonata Software
01.2016 - 08.2019
Schooling - undefined
St. Xavier's High School
Bachelor of Engineering - Electronics and Communications
Jain University
Pre-University Education -
RLS Institute