Amaraja Deo
PA,Pennsylvania
Summary
Data analyst with over 10 years of experience specializing in data extraction, transformation, and visualization within Veeva Vault systems. Proficient in SQL, Power BI, Excel, and Python, delivering actionable insights and ensuring data integrity. Extensive knowledge of GxP compliance and data governance, contributing to successful system validation processes.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Data Analyst
Eikon Therapeutics
02.2023 - Current
- Designed and maintained Power BI dashboards to track user compliance training and document lifecycle statuses within Veeva Vault.
- Conducted in-depth data analysis on document workflows and user access issues to improve system utilization and support decision-making.
- Extracted, cleaned, and validated SharePoint metadata using Excel and SQL-based tools before document migration.
- Participated in business reviews by delivering actionable insights through custom reports and ad hoc data analysis.
Data Analyst
Axcella Therapeutics
10.2020 - 12.2022
- Led full-cycle data migration of clinical study records and regulatory submission documents into Veeva Vault Clinical and RIM systems.
- Developed source-to-target mapping specifications and created data validation reports using SQL and Excel.
- Created dashboards to monitor migration readiness, completeness, and compliance; collaborated with QA to resolve discrepancies.
- Performed root cause analysis on data issues and delivered weekly reporting packages to stakeholders.
- Analyzed document usage and lifecycle metrics within Veeva Vault; built custom reports to highlight performance and compliance.
- Collaborated with cross-functional teams to define KPIs and data governance requirements for SOP documentation and training access.
- Created workflows and Excel-based scorecards to visualize upgrade impact and user readiness.
Data Analyst – Vault Systems
Seagen
06.2018 - 09.2020
- Developed metrics dashboards and audit reports for Quality Docs and Regulatory systems using Power BI.
- Queried Veeva databases to analyze study lifecycle activity, user login trends, and content archival rates.
- Supported sprint-based analytics requirements from QA and clinical stakeholders for document tracking.
- Processed bulk data uploads and lifecycle transitions via Loader and FTP tools for various object types.
Data Support Analyst
Capita IT Services
11.2016 - 12.2018
- Conducted manual and automated testing for SQL-driven backend validation processes.
- Wrote and optimized SQL queries to validate test case data for enterprise telecom solutions.
- Delivered reporting on testing progress, defect trends, and weekly QA performance dashboards.
Data Operations Analyst
IBM India Pvt Ltd
01.2016 - 10.2016
- Extracted operational and business data from CRM and DB2 systems to create monthly and quarterly summaries.
- Built visual dashboards using Power BI and Excel to report CRM access and provisioning activities.
- Streamlined reconciliation processes using SQL and Python-based utilities.
Access & Testing
IBM India Pvt Ltd
08.2014 - 12.2015
- Performed test data setup and defect trend analysis; created reports for regression and UAT testing coverage.
- Delivered Excel-based analytics on system access logs, audit trails, and provisioning data.
- Created dashboards to track application performance issues and resolved data discrepancies.
Data Analyst – Reporting & Support
IBM India Pvt Ltd
08.2012 - 07.2014
- Built and maintained SQL queries for reporting on application support tickets and user activity.
- Supported analytics needs of internal teams by designing dashboards in DB2 and Excel.
- Developed reports on recurring issues and supported root cause investigations.
QA & Data Reporting Analyst
IBM India Pvt Ltd
06.2011 - 07.2012
- Created daily and weekly reports on system health using IBM Tivoli and Rational Performance Tester.
- Generated performance and usage metrics across key services; escalated trends to engineering and QA leads.
- Built and monitored dashboards to ensure SLA compliance.
Education
Bachelor of Engineering - Computer Science
Aurangabad University
IndiaSkills
- Data analysis and visualization: Power BI, Excel, SQL, DAX, pivot tables, dashboards
- Data migration and ETL: Veeva loader, metadata mapping, FTP, cleansing
- Business analysis: gap analysis, requirement gathering, validation testing
- Reporting and metrics: KPI dashboards, compliance reports, training analytics
- Tools: ServiceNow, SharePoint, JIRA, MS Visio
- Programming: Python (basic), Java (basic)
- Databases: MS SQL Server, Oracle, MySQL, and IBM DB2
Certification
- Veeva Vault Certified Associate Administrator (2024)
- ISTQB Foundation Level Certification (CTFL)
- IBM Certified Operator - AIX 6.1 Basic Operations
- Power BI Advanced (Udemy)
- AWS Certified Cloud Practitioner CLF-C02
Timeline
Data Analyst
Eikon Therapeutics
02.2023 - Current
Data Analyst
Axcella Therapeutics
10.2020 - 12.2022
Data Analyst – Vault Systems
Seagen
06.2018 - 09.2020
Data Support Analyst
Capita IT Services
11.2016 - 12.2018
Data Operations Analyst
IBM India Pvt Ltd
01.2016 - 10.2016
Access & Testing
IBM India Pvt Ltd
08.2014 - 12.2015
Data Analyst – Reporting & Support
IBM India Pvt Ltd
08.2012 - 07.2014
QA & Data Reporting Analyst
IBM India Pvt Ltd
06.2011 - 07.2012
Bachelor of Engineering - Computer Science
Aurangabad University
Similar Profiles
BRINDA KAMALIABRINDA KAMALIA
Senior Research Associate at Eikon TherapeuticsSenior Research Associate at Eikon Therapeutics
James RamirezJames Ramirez
Human Resources Operations Specialist 2 at Eikon TherapeuticsHuman Resources Operations Specialist 2 at Eikon Therapeutics
Naira BadalyanNaira Badalyan
Account Coordinator at Eikon GroupAccount Coordinator at Eikon Group
David McCormickDavid McCormick
Senior Quality Manager at Corrohealth/Virtix HealthSenior Quality Manager at Corrohealth/Virtix Health
Carsen MylesCarsen Myles
Student Equipment Manager at Penn State Men's Ice HockeyStudent Equipment Manager at Penn State Men's Ice Hockey