Fernando Retamales C. Portfolio

About Me

My experience summary contains:

• Generated savings of up to 1,5 millions USD/year, focusing on various cost efficiency initiatives.

• Reduced cost of coverage options by 15% for our patients in our primary healthcare providers.

• Implemented providers integration with ERP system by developing a tool which extracts metadata from payments and provides reports to a system-wide search database, reducing the cash flow time in 30%.

• Implemented a new care model in national healthcare network, being the leader of a project that helped reduce by 30% the primary care’s customer journey time while enforcing new behavioral techniques for physicians.

• Created and conducted the COVID-19 predictor project, a biometric app for likely infected patients, in alliance with Carnegie Mellon. After 6 months of iterating, the final platform was available to 70,000 affiliated firms.

• Selected as one of the organization’s 20 young leaders in 2018, part of the company’s young professional program.

Data Cleaning and Analysis

In light of Suicide Awareness Month, relationships between overall health investment (as a mental health proxy) and suicide rates are a key index to watch. This data was downloaded from the WHO Mortality stats published and ICD10 death classification codes, then edited for format and condensation of ICD (more than 5 million rows) in SQL (Query attached).

We see a positive effect of more expenditure in health topics, giving away less rates of suicides in countries worldwide. The hope of less suicides brings us a light of answers of where to put our efforts, even though this job does not consider other relevant factors such as socioeconomical development, private and public actions, and individuals characteristics.

Data Cleaning in SQL

Data Analysis in Python using Jupyter Notebook in Kaggle

Visualizations

In light of Suicide Awareness Month, relationships between overall health investment (as a mental health proxy) and suicide rates are a key index to watch. This data was taken from data cleaning+analysis in SQL+Python; then, the following tableau visualization was also developed.

Tableau Visualization

Excel Dashboard

Contact

• LinkedIn
• GitHub
• Kaggle

Elements

i = 0;

while (!deck.isInOrder()) {
    print 'Iteration ' + i;
    deck.shuffle();
    i++;
}

print 'It took ' + i + ' iterations to sort the deck.';