Julia Agúndez González
SAS Programmer at OXON Epidemiology- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
Español Native or bilingual proficiency
-
Inglés Professional working proficiency
Topline Score
Bio
Credentials
-
Big Data (2015) Specialization
Coursera Course CertificatesJul, 2016- Nov, 2024 -
Big Data - Capstone Project (2015)
Coursera Course CertificatesJul, 2016- Nov, 2024 -
Graph Analytics for Big Data (2015)
Coursera Course CertificatesApr, 2016- Nov, 2024 -
Machine Learning With Big Data (2015)
Coursera Course CertificatesFeb, 2016- Nov, 2024 -
Introduction to Big Data Analytics (2015)
Coursera Course CertificatesJan, 2016- Nov, 2024 -
Hadoop Platform and Application Framework
Coursera Course CertificatesDec, 2015- Nov, 2024 -
Introduction to Big Data (2015)
Coursera Course CertificatesNov, 2015- Nov, 2024
Experience
-
OXON Epidemiology
-
United Kingdom
-
Research Services
-
1 - 100 Employee
-
SAS Programmer
-
Sep 2020 - Present
- Developing SAS programs for DM and Stats departments. The develops were for multiple studies of different disease: Pneumonia, narcolepsy, hipertension, melanoma... - Developing SAS macros to create LOTs with all the patient's medication. - Creating the database for the analysis based on the information provided by CPRD and SNDS. - Improvement in validation process in observational studies using the existing study documents (specs, data dictionary...) to check the correct fill of information on the different forms. - Using TortoiseGit to keep a control changes on the SAS programs. - Developing Excel VBA macros to identify overlaps and gaps on the different time-treatments for the same patient. Identify overlaps between different treatments for the same patient. Show less
-
-
-
Linical
-
Japan
-
Pharmaceutical Manufacturing
-
100 - 200 Employee
-
Biostatistical SAS Programmer
-
Feb 2019 - Sep 2020
- Develop SAS programs and macros to create ADs and TLFs. - Update the proc report output format in order to apply a clean and clear look across the whole document. - Working in several studies, some of them as lead programmer, based on SDTM/ADAM structure, and reviewing on them Pinnacle 21 outputs to check and fix the issues. - Share my feedback, in our internal weekly meeting, about the studies progress and my availability with the bio-statistical department, just in case there is any urgent study that need some programming support. - Using SAS (Enterprise Guide v7.1) including creation of codes with macros, SQL queries, graphs and statistical procedures, and also Microsoft Word, Excel and macros on Excel VBA. Show less
-
-
-
Sopra Steria
-
France
-
IT Services and IT Consulting
-
700 & Above Employee
-
Functional Analyst
-
Mar 2017 - Feb 2019
Corporate IT support project to the eleven entities of Santander Bank to load the information on Risk Data Base. Generate new reports for the IRB calculating process with SAS. Generate reports in Excel with SAS for the TRIM documentation (Targeted Review of Internal Models) for CBE. Corporate IT support project to the eleven entities of Santander Bank to load the information on Risk Data Base. Generate new reports for the IRB calculating process with SAS. Generate reports in Excel with SAS for the TRIM documentation (Targeted Review of Internal Models) for CBE.
-
-
-
Sopra Steria
-
France
-
IT Services and IT Consulting
-
700 & Above Employee
-
Organic Analyst
-
Jul 2015 - Oct 2016
Maintenance project of SAS applications in Enterprise Guide 4.3 to adapt the provisions calculation to IAS39 regulation, and later the migration process to IFRS9 regulation. New applications development to improve the performance and structure of existing programs. Scripts programming in Unix environment to automate SAS execution processes. Analysis of intra-month default impact on provisions. Maintenance project of SAS applications in Enterprise Guide 4.3 to adapt the provisions calculation to IAS39 regulation, and later the migration process to IFRS9 regulation. New applications development to improve the performance and structure of existing programs. Scripts programming in Unix environment to automate SAS execution processes. Analysis of intra-month default impact on provisions.
-
-
-
Axpe Consulting
-
Spain
-
IT Services and IT Consulting
-
500 - 600 Employee
-
Programmer Analyst
-
Jan 2012 - Jul 2015
As part of a support team for the Operations Department of the Central Bank of Spain I have undertaken the following activities: · Creating documentation for the maintenance of the applications developed in SAS, including a document with a list of files and processes used. · Maintenance of public debt bulletin and operations bulletin that published daily, which includes, in addition to SAS processes, macros developed in visual basic. · Analysis, development and maintenance of new requirements that allow better performance SAS environment strings from the HOST: - Maintenance and creation of CLIST and screens through FSEdit SAS. - Tracking changes make on the database. - Data verification manually modified by a different user to which input. - Cancel the execution of a process if any previous chain has finished incorrectly. - Taking user requirements by business analysis, development, and evolutionary implications. · Knowledge of fixed income. · Planning of vacation, guards and shifts. Show less
-
-
-
Coritel
-
Isban - Private Banking/DWH Project
-
Programmer
-
Dec 2010 - Jan 2012
Maintenance on the application, as a follow-Track, review and correct them. In this respect, I have done coding work under supervision for correction of incidents. - Decreasing the degree of degradation of the application and process improvement tabulated thereof, to be detected and corrected problems in the day, both by creating and modifying software and scripts developed in COBOL. - COBOL programming on UNIX environment. Maintenance on the application, as a follow-Track, review and correct them. In this respect, I have done coding work under supervision for correction of incidents. - Decreasing the degree of degradation of the application and process improvement tabulated thereof, to be detected and corrected problems in the day, both by creating and modifying software and scripts developed in COBOL. - COBOL programming on UNIX environment.
-
-
-
Santander
-
Spain
-
Banking
-
700 & Above Employee
-
Intership
-
Mar 2009 - Mar 2010
Performance Management team following Santander Consumer Finance projects in Spain, Germany, Hungary, Czech Republic, Poland: - Analysis of consumer credit portfolio of Santander Consumer in Spain: - Segmentation of accounts by risk profiles. Tracking of account performance. - Generation of variables for behaviour and collection scoring, analysis of the variables predictability. - Ad-hoc analysis and on-going tracking of consumer credit portfolio of Santander Consumer Hungary: - Tracking of Collection Department performance including efficiency of the dialling system, agents performance, process efficiency and collections results. - Analysis of customer behaviour, segmentation of customers by risk profile to support collection strategy. - Consumer credit portfolio analysis including was-is analysis, roll-rates, vintage tracking, etc. - Prepared various reports and presentations using MS Power Point. - Using SAS (v.9.13) including creation of codes with macros, SQL queries and graphs and statistical procedures. Show less
-
-
Education
-
2002 - 2010
Universidad Complutense de Madrid
University Degree on Mathematics -
2014 - 2017
Universidad Católica 'Santa Teresa de Jesús' de Ávila
Certificate of Higher Education on Web Applications Development -
2015 - 2016
University of California San Diego
Big Data Specialization
Community
