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.

• 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

• Spain
• Software Development

• 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.



Banco Santander

• Argentina
• Banking
• 1 - 100 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