Name: Jagannath Roy

Experience:

Address: Hyderabad India

Clinical Software handling

CTMS 95%
e TMF: ELVIS, Wingspan, Veeva Vault 85%
EDC: Medidata Rave, Inform 96%
Veeva Vault 91%
e COA 85%
SRTE Tool: Spotfire, Site Green Light 98%

Data Analysis skills

Power BI 98%
Advanced Excel: VBA 98%
SQL 98%
Python: VBA 98%

About

About Me

I am a detail-oriented and results-driven clinical research professional with a Master’s degree in Pharmaceutics and a strong foundation in pharmaceutical sciences. With extensive hands-on experience in managing Clinical Trial Management Systems (CTMS), Electronic Data Capture (EDC), and Trial Master File (TMF) platforms such as ELVIS and Wingspan, I specialize in ensuring process efficiency, regulatory compliance, and high-quality project execution across global clinical trials. My core responsibilities include maintaining high site compliance through accurate CTMS data entry, overseeing site milestone and subject tracking, and managing audit-ready TMF documentation in accordance with ICH-GCP and SOP standards. I proactively support cross-functional teams by facilitating training compliance, managing study payments, and handling system access management across various platforms. I am technically proficient in Microsoft Excel, VBA Macros, and Power BI—developing automated trackers and interactive dashboards that provide valuable insights into site performance, query trends, and project health. Notable contributions include building the Quality Data Review (QDR) dashboards and automating trackers such as the SRtE and Site Monitoring Visit Trackers, significantly reducing manual workload and enhancing reporting accuracy. In recognition of my subject matter expertise, I have served as an Instructor-Led Training (ILT) Facilitator at IQVIA, onboarding new hires with structured training on tools and systems. As a Subject Matter Expert (SME) in Excel, IWRS, and SRtE, I regularly conduct knowledge-sharing sessions and troubleshooting support to uplift team capabilities. My strengths lie in combining domain expertise with technical skills to drive continuous improvement, enhance operational transparency, and deliver quality outcomes in every project I’m part of.

  • Profile: Centralized Monitoring & Project Management
  • Domain: Contract Research Org
  • Education: Masters in Pharmaceutics
  • Language: English, Hindi, Kannada, Bengali
  • BI Tools: Microsoft Power BI & Spotfire
  • Other Skills: Power BI, Excel,SQL,Python & SEO

0 +   Projects completed

Experience

Professional Experience

IQVIA IQVIA

Centralized Monitoring Assistant

Clinical Operations & Data Oversight

June 2023 – October 2025 · 2 Years 4 Months

Hands-on experience supporting global clinical trials using CTMS, EDC (Rave, InForm), and eTMF (ELVIS, Wingspan). Managed site milestones, TMF QC, audit readiness, study payments, and system access management. Built Power BI dashboards and automated Excel trackers using VBA to ensure GCP-compliant and on-time study execution.

Sanofi Sanofi

Clinical Trial Support Associate

R&D Systems & Quality Compliance

October 2025 – Present

Expanded responsibilities into SOP governance, Independent Process Controls (IPC), CAPA tracking, and global study setup oversight. Supported quality compliance, cross-functional collaboration, vendor coordination, and ensured regulatory-aligned, audit-ready clinical trial processes across global studies.

Education

Academic Background

SkilloVilla SkilloVilla

Data Analytics (Gold Program)

SQL · Python · Power BI · Advanced Excel

2024 – 2025

Industry-focused analytics program with hands-on projects in SQL querying, Python data analysis, Power BI dashboards, and Excel automation. Delivered multiple capstone projects emphasizing real-world business insights.

View Certificate
PES University PES University

Master of Pharmaceutics

Pharmaceutical Sciences

2021 – 2023

Advanced academic training in formulation science, drug delivery systems, pharmacokinetics, and regulatory affairs. Graduated with CGPA 9.71.

B Pharmacy RGUHS

Bachelor of Pharmacy

Pharmacy

2017 – 2021

Built a solid foundation in pharmacology, pharmaceutics, medicinal chemistry, and clinical pharmacy. Graduated with CGPA 7.9.

Projects

Projects

Below are the sample Data Analytics projects on SQL, Python, Power BI, Excel.

Shopnest Data Analysis By Power BI

This project leverages sales data from ShopNest to drive business growth.

PwC PowerBI Experience Call Center Trends Analysis

As a business data analyst to help an organization named “PhoneNow” to analyze their data and help them understand how they can leverage on their massive amount of data.

PWC Power BI Virtual work experience Customer Churn Retention

Completed the Data transformation in Power Query and the dataset loaded into Microsoft Power BI Desktop for modeling.


Diversity & Inclusion Project: Advancing Gender Balance in Executive Leadership

This project is centered around advancing gender balance in the executive leadership of a prominent telecom client. I've utilized Power BI to create meaningful Key Performance Indicators (KPIs) and visualize gender diversity insights.

SkilloVilla-Capstone Python

Used multiple machine learning models to forecast sales (retail store) and performed time series analysis.

Social Media Data-Analytics-and-Visualization Accenture

Client's Problem that Accenture is tasked to address : The client has reached a massive scale within recent years and does not have the resources internally to handle it.


Airline Database Capstone Project-SQL

The aim of this project is to tackle real-world issues through SQL queries related to seat allocation, flight schedules, and passenger information..

Freshco_Hypermart_Excel_Data_Analysis

Freshco Hypermarket, situated in HSR, Bangalore, has established itself as a prominent supermarket in the region, catering to a wide range of customers.

More projects on Github

I love to solve business problems & uncover hidden data stories


Contact

Contact Me

Below are the details to reach out to me!

Address

Hyderabad
India

Phone

6363696315

Email

jagannathasus420@gmail.com

GitHub

Jagannathro

Instagram

@betared.bill

LinkedIn

Jagannath Roy


Copyright © All rights reserved | This template is made with by Colorlib