Safety Science Analyst

Jayashri Lokhande Email: *******************@*****.***

Mob: +91-738*******

Address: Hadapsar, Pune.

Professional Summary:

Safety Science Analyst with 3.4+ years of experience in building interactive dashboards, optimizing data models, and delivering actionable insights across the Pharmacovigilance and Healthcare Analytics domain. Expertise in Power BI, SQL, ADF, and Azure services with proven ability to translate business requirements into scalable reporting solutions. Skilled in data analysis, visualization, and automation with strong problem- solving and communication skills.

Technical Skills

SQL Data Extraction & Transformation, Complex Queries, Joins, Window Functions

Azure Azure SQL (ASQL), Azure Data Lake (ADLS), Azure Data Factory

(ADF)

Power Bi Custom Visualizations, Optimized Data Modeling, Power Query

(ETL), DAX

Python Basic Python

Professional Experience:

Worked as Safety Science Analyst in Fortrea Scientific Services Pvt. Ltd. Pune from March- 2021 to Present.

Project Exposures & Responsibilities

Domain Healthcare

Role Safety Science Analyst

Technology Power Bi, SQL, ADF

Description: Develop a healthcare analytics dashboard to consolidate Safety and operational data from various sources and provide actionable insights for decision-makers. This project leverages Azure Data Factory for data processing and Power BI for visualization. Azure Data Factory (ADF) will be used for data extraction, transformation, and loading (ETL).

Roles and Responsibilities:

1. Developed and deployed end-to-end Power BI dashboards with slicers, KPIs, and advanced DAX calculations.

2. Created different charts such as Bar Chart, Pie Chart, Donut Chart, Heat Map, Line chats, customized Bar chart, KPI's.

3. Interact with Business, gather the business requirements and create the requirement documents. 4. Created custom measures, hierarchies, and parameters, enabling users to drill down data dynamically. 5. Connected and integrated data sources from SQL Server & Azure (ADLS, ADF). 6. Implemented Row-Level Security (RLS), scheduled refresh, and incremental load for secure reporting.7 7. Collaborated with business stakeholders to align KPIs with dashboards. 8. Optimized Power Query & DAX models, reducing report load time by 40%. 9. Built geo-maps, heat maps, and drill-through reports, enhancing interactive data exploration. Domain Healthcare

Role Data Analyst

Technology SQL, Power Bi

Description: Healthcare & Pharmacovigilance Data Analyst with expertise in AE reporting, case processing, safety monitoring, and compliance dashboards. Strong technical skills in Power BI, SQL. Roles and Responsibilities:

1. Built dashboards to track adverse event reporting trends, drug safety KPIs, and compliance metrics.

2. Analyzed clinical trial and post-marketing surveillance data for safety signal detection. 3. Automated safety data extraction from SQL & Azure databases to streamline case processing workflows.

Projects:

Adverse Event Dashboard: Designed dashboards to track case volumes, seriousness criteria, and timelines across therapeutic areas.

Compliance Monitoring: Developed KPI reports for case closure timelines, improving compliance by 25%. Achievement:

Process excellence All Rounder award in 2024

People excellence award in 2023

Academics:

Bachelor of Pharmacy, Savitribai Phule Pune University 2016 – 2020 CGPA :8.41

XII, Maharashtra State Board 2014 – 2015

Score:72.60 %

X, Maharashtra State Board 2012 – 2013

Score:92.20 %

Interests:

• Cooking

• Travelling

Contact this candidate