Download PDF

Brondi Alessandro

SAS Programmer on Clinical and Epidemiological Data

Summary

I work at S.C Epidemiologia dei Tumori, Turin.

I work at C.P.O. (Center of Oncology Prevention) in Turin from February 2014.

I have fixed-term contract (until 31/12/2018)

My work : Build or modify a program using SAS 9.2. I create also a macro with SAS 9.2.

I create a program that have as output a table contaning various type of clinical data.

I work in contact with epidemiologist and manager because I prepare a data to their studies.

I work with large number of patients and then I work in PHASE II and PHASE III of clinical studies. The principal target is evaluate which treatment or which medical equipment is better.

 

Work experience

February 2014

SAS Programmer on Clinical and Epidemiological Data

CPO Center Oncology Prevenction - S.C. Cancer Epidemiology – Turin, Piedmont
I work at C.P.O. (Center for Oncological Prevention) in Turin since February 2014.C.P.O. it is a small CRO and aims to study clinical studies. The team in which I work is composed of Epidemiologists, Clinicians, Statisticians and SAS Programmers. I work on PHASE II and PHASE III of clinical studies. To the C.P.O. we evaluate which medical treatment is better and which medical equipment is better. I generally work on tables containing lots of data. My job is to create or modify a program using SAS 9.2 Educational Edition. They are also SAS Data Manager.I create programs that produce output tables containing various types of clinical data. These programs also provide for import and export of data in Excel format. When I build a program or when I edit a program, I follow a standard for organizing and formatting data (SDTM) and then I stick to what the CDISC standards are. These are datasets that comply with SDTM standards so that all tables have a recognized and defined format.In this work I start writing SAS programs to generate report tables, lists and charts according to the statistical analysis plan (SAP) and the tables designed during the clinical study.Before and after writing a SAS program, together with my colleagues, I perform data analysis (ADaM: Analysis Data Model) describing the general structure of the tables, the type of variables used.

 

 

Project 2018

From February 2018

I create a job using SAS Enterprise Guide to create a table Hospital Discharge Register.

From January 2018

I work at project "Casi Intervallo". In this phase I worked with some collegues to perform a program using SAS 9.2. This type of program is used on Proteus.

 

From August 2017

I work on a project "Proteus". In this project I ran and created a SAS Base 9.2 program and created a table containing data on women the Proteus Project. In this project I made a connection from several types of clinical data: for example information on the hospital and on the incidence of the tumor.

 

Project 2017

AnagraficaID 2.0

Purpose :

There were many tables containing duplicate personal data because the person, in Italy, when she is admitted to the hospital, she is registered each time with an identity document. Every time this ID is different. And so if you want to connect this type of tables with the table that contains, for example, hospital discharge, you have many occurrences. With this program you have a numerical index that allows you to check the person as such. This table called Registry Data is increased each time they arrive new personal data. Within the program there is a control that prevents duplicate indices. This index has been applied to many other tables. (ex: hospital discharge, tumor incidence, mortality table, etc. ...)

 

Breast Cancer

Project 2015 and 2016

Survey

with the use of the unique ID, I created programs using SAS and I created tables containing different types of clinical data. The goal was to define the state of health of people after clinical treatment.

Purpose

the use of the ID allowed to associate a person with his / her state in life following a clinical treatment. This clinical treatment has been conducted on men who have colon cancer and that they were treated in the hospital. Treatment is better or worse for this man? I have prepared a table containing personal data, information about the disease and I linked it to the mortality table. I then discussed the results of the study with a doctor and epidemiologist. This type of study was repeated for 2016.

 

Project 2014 

AnagraficaID 1.0

with the use of the unique ID, I created programs using SAS and I created tables containing different types of clinical data. The goal was to define the state of health of people after clinical treatment.

Purpose :

There were many tables containing duplicate personal data because the person, in Italy, when she is admitted to the hospital, she is registered each time with an identity document. Every time this ID is different. And so if you want to connect this type of tables with the table that contains, for example, hospital discharge, you have many occurrences. With this program you have a numerical index that allows you to check the person as such. This table called Registry Data is increased each time they arrive new personal data. Within the program there is a control that prevents duplicate indices. This index has been applied to many other tables. (ex: hospital discharge, tumor incidence, mortality table, etc. ...)

 

Articles  :

Assessing the role of colonoscopy in screening for colorectal cancer (details at : https://www.cpo.it/it/chi-siamo/attivita/show/92214/)

Multicentre randomized controlled trial of “once-only” sigmoidoscopy screening for colorectal cancer (SCORE)

(details at https://www.cpo.it/it/chi-siamo/attivita/show/92206/)

Impact of screening on breast cancer incidence and mortality study (details at https://www.cpo.it/it/chi-siamo/attivita/show/92216/)

 


June 2011January 2014

Consultant Programmer 

System Evolution

Client : Regione Veneto.

Using Data Flux to assess the quality of data from the Health Service of the Veneto Region.


Client : Deutsche Bank.

I worked with HTML 5 and CSS 3 to create or edit web pages.


Client : Intesa San Paolo.

I used SAS Data Integration Studio 9.2 to build new job . I used SAS Guide to analyze charts and data .I created JOB to make possible the analysis of financial ratios and evaluate the volume of business of thecustomer. I used VB Script to Excel to create Excel macros and produce sheets used by the customer in the various meetings.


Client : CSI Piemonte.

Creating jobs with SAS Data Integration Studio 4.2 and 9.1 for the management plans of the accounts relating to different types of various entities . Using Business Object XI for reporting related to the harmonized charts of accounts or reclassified

August 2011June 2011

Consultant programmer

Betacom

Client : Replay.

Maintenance programs in PL / SqL existing . Creating procedures , functions and new implementations for the management of new customer specifications with which it operates with Reply . Maintenance creation of new forms and buttons with using Visual Basic 6.0 to meet the needs of customers working with Reply .


Client : Eufidi - EuroGroup.

Implementation of software solutions on PL / SQL on the Oracle platform . Writing , editing programs in PL /SQL . Generation output in text files to be sent to the Bank of Italy for reports of credit and guarantee . Creating programs PL / SQL operations to the Supervisory Board. Documentation of procedures or products listed.


Client : Betacom.

Building web pages using Visual Studio 2008 .


Client : CSI Piemonte.

Construction ETL with SAS Data Integration Studio 3.4 from Oracle scripts to handle password expiration of CSI employees . Construction ETL with SAS Data Integration Studio 3.4 . directions for the management of master , officers and cost centers . Update and insertion of Oracle tables through lines of program SAS 9.1 . Generating tables Staging. Reading from Oracle tables .
SAS programming 9.1 basis for management , maintenance and development of useful reports for services provided to internal employees ( Use Taxi Services, Mensa , Transfers of work , Using Phone company ) . Using SAS Web Report Studio for the creation of reports. Using SAS Information Map 3.1 for the modification of any filters or in the case of realization of new reports to display in a production environment .

March 2006October 2008

Programmer

Ribes Informatica

Visual Basic Programmer
Creating and managing tables on Access database.
Extraction and processing of reports from the system STS2000.
Programming in SQL and SQL to Access.
Programming in Visual Basic.
Statistical purposes.
Development of Web Sites
Through the use of Visual Studio 2008, development of websites using HTML, ASP, CSS and JavaScript.
Technical testing cell
Testing the Mail Management Service on mobile phones that support Symbian OS and Windows Mobile operating system. Using Nokia PC suite. Test on SIM for Vodafone to launch new services.

September 2005March 2006

Technician Help Desk di 2° level ADSL

Comdata

Configuring the modem and router operating systems like Windows XP, Windows 98 and Mac OS. Configuring Internet and email. Get the first connection from the client.

March 2005August 2005

Programmer PL/SQL

Retalix

Using the PL / SQL and in particular PL / SQL for Oracle database management relating to large retail supermarkets, hypermarkets to create applications to meet customer needs.
Actions on a context of existing programs by including a few lines and improving existing programs.
Management and creation of a graphical interface to manage the payment ticket restaurant of the products in some supermarkets and hypermarkets.
Development of economic statistics for the interpretation of particular algorithms concerning the reorganization of the goods.

September 2003August 2004

SQL Developer on Access

Vodafone Italia

Creating relational databases using Access using data from Excel.
SQL programming language and creating graphical user interface to manage campaigns telephone exchange.
Of economic statistics to assess the sales performance of the proposed cell.
Campaign management with the use of telephone systems such as SAP and OCA to verify the activation of its emission rate and credit note.

March 2003August 2003

STAGE

ARPA Biella

Using SAS and SPSS for processing health information. Study of the influence of drugs on diseases caused by smoking. Development of statistical and epidemiological use of the arguments developed in the thesis in relation to the case-control studies.

Knowing the problems of the territory of Biella. Transfer of knowledge of the Geographic Information System (GIS). Assessment of knowledge on environmental quality. Inspections in some municipalities in the territory of Biella for the knowledge of environmental issues. Organizing and processing of environmental data collected with the use of ArcView. Statistics on air and water quality in the territory of Biella.

September 1999December 1999

STAGE

CPO Center of Oncology Prevenction

Stage carried out in order to prepare the thesis in statistical analysis on the health of both descriptive and practical level of indexes that evaluate the impact of smoking and alcohol in humans.
Data collection, processing surveys and their interpretation.
Construction of survival curves and mortality.
Using SAS and SPSS for the interpretation of results.

Education

January 2000April 2002

three-year degree on Statistics

University of Turin
September 1996December 1999

bachelor's degree in Statistic

University of Turin
September 1991July 1996

Computer Science not graduated

ITIS Camillo Olivetti

Skills

SAS Base 9.2

Code and macros

SAS Data Integration Studio

Platform to perform a job using SAS

SAS Enterprise Guide

Platform to perform a job using SAS

PL/SQL

Code and Trigger

Office

Excel ; Word ;

Access

Database , query , form

Visual Basic

Code and macro

HTML 5 and CSS 3 and Javascript and ASP.NET

code

English

Comprehension

English

Write

English

Conversation

CERTIFICATIONS

PROFESSIONAL AWARDS

Epidemiology: The Basic Science of Public Health - February 2014

I follow this course on Coursera Site but I don't earn a Certificate. (6 week)

1) Course Introduction, History of Epidemiology and Epidemiology Research

2) Understanding Measures of Disease Frequency

3) Study Designs

4) Measures of Association

5) Causality

6) Conclusion

Data Management for Clinical Research - June 2014

I follow this course on Coursera Web (6 week) but I don't earn a Certificate.

1) Research Data Collection Strategy

2) Electronic Data Capture Fundamentals

3) Planning a Data Strategy for a Prospective Study

4) Practicing What We've Learned: Implementation

5) Post-Study Activities and Other Considerations

6) Data Collection with Surveys

Driver's Licence

Category B

MILITAR/CIVIL SERVICE

Country militar service: Italy in 2002

ADDITIONAL INFORMATION

I research a permanent job on SAS. If you want to call me, you could call at 17.15 p.m. or on Friday from 10.00.

 

Autorized the use of personal data D. lgs. 196/03