Skip to main content
José Zamora de la VegaJV
Looking for a job

José Zamora de la Vega

@joszamoradelavega

Data analyst at ICON Clinical Research designing SQL reports and Power BI dashboards for clinical trial reporting.

Mexico
Message

At ICON Clinical Research, I design and troubleshoot SQL reports and create paginated reports and Power BI dashboards for pharmaceutical and biotechnology clients. I work with internal and cross-functional teams on clinical trial analysis, reporting, and sponsor-specific solutions.

At Nielsen Media, I automated internal reports with Python and migrated Access and SAS programs to Python and SQL. I also created KPI dashboards in Power BI to support audit requirements and identify inconsistencies in metrics.

At Servicio de Administración Tributaria, I analyzed tax data and automated reports using SQL, SAS, and Access. My analysis identified patterns of tax evasion and networks.

Experience

Work history, roles, and key accomplishments

ICON Clinical Research logoIR
Current

SQL Developer II- IMI

Sep 2023 - Present (3 years 1 month)

Design and troubleshoot SQL reports, develop RDL files in Visual Studio for paginated reports, and design dashboards using Power BI. Communicate with internal teams to create deliverables for pharmaceutical and biotechnology clients.

TS

PowerBi Developer

Jun 2023 - Sep 2023 (3 months)

Assisted in the creation and deployment of an institutional dashboard, collaborating with cross-functional teams to design a user-friendly interface using Agile methodology. Conducted user training sessions to ensure effective utilization of the dashboard.

TS

Data Scientist – Advanced modeling

Jul 2022 - Jul 2022 (0 months)

Developed and automated a SAS model for unifying and standardizing forecast across multiple call centers. Improved forecast accuracy compared to the oldest way and automatized the way to get the forecast and needed outputs.

NM

Data Scientist Analyst – Internal Audit

Jul 2019 - Jul 2022 (3 years)

Automated internal reports using Python and developed several indicators to address audit requests. Migrated ACCESS and SAS programs to Python/SQL, improving efficiency and scalability, and created dynamic KPI dashboards in Power BI.

ST

Data Analyst

Servicio de Administración Tributaria

Jun 2017 - May 2019 (1 year 11 months)

Extracted and transformed tax data using SQL, generating comprehensive statistics, graphs, and reports in Excel. Developed advanced SQL queries in SAS and ACCESS for report automation and detected patterns of tax evasion through meticulous data analysis.

Education

Degrees, certifications, and relevant coursework

Universidad Autonoma de Estado de Hidalgo logoUH

Universidad Autonoma de Estado de Hidalgo

Degree, Economics

2010 - 2015

Degree in Economics from Universidad Autonoma de Estado de Hidalgo, completed in 2015.

Tech stack

Software and tools used professionally

Interested in hiring José?

You can contact José and 90k+ other talented remote workers on Himalayas.

Message José

People also viewed

View all talent

Get matched with your dream remote job

Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!

Sign up
Himalayas profile for an example user named Frankie Sullivan