Summary
Overview
Work History
Education
Skills
Timeline
Generic
Ivan González Schulten

Ivan González Schulten

Software Developer SR.
Las Condes

Summary

Amenable Software Engineer gifted at translating basic client requirements into technical development plans. Communicates productively with both technical and non-technical personnel and clients. Friendly provider of deep programming knowledge and invaluable final products.

Overview

6
6
years of professional experience
5
5
years of post-secondary education
3
3
Languages

Work History

Solution Developer Senior

Coca Cola Andina
Santiago
02.2021 - Current
  • Programming solutions for Services on AWS, such as Redshift, S3, Lambda, EMR, EC2, Aurora, Athena, Step Function, DynamoDB
  • Solutions and orchestration created with the aforementioned services
  • Dedication and guidance for cell group to solutions integration, also unit testing and QA
  • Use of Python 2.6+, Pyspark, Scala and Dax Languages, Java where maven was used as compiler, also interaction with DB like Oracle and Mysql through ssh tunneling with Putty where linux was installed (Azure)
  • The Company uses agile and scrum methodology, using tools of platforms like Atlassian
  • We created a whole flux from Sap to models which were shown on visualizations on a web application
  • We made a emigration from Azure to AWS, using all similar Services which aws did offer.

Data Science and Data Engineer

TCS Chile
Santiago
11.2020 - 02.2021
  • Giving Support to the Citi Bank in the US in Technology Fields, such as:
  • Arcadia
  • Pyspark
  • Tableau
  • Kafka
  • Scala/Spark
  • Relational DBs like Cassandra and PostgreSQL
  • As a team we created a streaming program, which did capture all the clicks and views of a normal User and transformed the data in valuable information for the team at the Citibank

Data Science and Data Engineer

Soluciones BI (Project)
Santiago
06.2020 - 09.2020
  • I was hired as support for the Solution team, to generate data integrations and automated ingests through the platform
  • Cloudera, using Sqoop, Hive, Impala, Spark, and Kafka
  • I was also asked to train the team in the use of the services of
  • Cloudera
  • Used Pyspark, also creating Lambdas interacting with the other services of AWS, like DynamoDB, Redshift, Athena and S3 for modeling and creating outputs in the Data Warehouse.

Data Science and Data Engineer

Consalud Insurance (Project)
Santiago
07.2020 - 09.2020
  • I was hired for the fulfillment of a ML modeling project
  • Of Frauds and automatic licensing, using Pyspark on Zeppelin (EMR), Java,
  • Scala, Glue and showing the business logic on Tableau
  • I implemented for automatic viewing, data integration, ingest and debugging, and then leaving WF running through more than 300 created variables was able to automatically endorse the licenses until 30% per month
  • Using Pipeline iterations of a Tuned Random Forest and Kmeans , with automation of the Threshold so that the cost of error does not exceed the cost of error for the staff who were in charge of reviewing the licenses manually (AWS)

Data Science and Data Engineer

Anticipa S.A, Santiago de Chile
Santiago
03.2020 - 12.2020
  • Technology solutions company - Implementation of Machine Learning models (knn, Random Forest, tree decisions, bayesian, Svm), AI, Forecasting (exponential smoothing, holt-Winters, Arma, Arimax), presentations on PowerBI, automated, creation of mathematical algorithms for the calculation of indicators for E-commerce clients
  • Solutions and creation of new automated algorithms and supervised and unsupervised learning for companies, Based on programming languages

    such as: Python, Java, Autoit, html, Dax among others
  • Use of Hadoop Cloudera for handling large amounts of data (Big Data) and processing it to create a data flow between SQL servers and then for its automated ingestion to PowerBI with a gateway
  • Sqoop, Hive, Spark, Scala, Pyspark, Impala, ssh tunneling Unix -Use of AWS and Cloudera, to manage ingest, manipulate algorithms and machine learning models with Spark using the apis Python and Scala
  • Streaming with Spark and Kafka, structuring data with Hive and Impala, creating Spark applications such as Workflows for technological solutions for different companies and complementing Software's and applications created by Anticipa
  • Cloudera platform support
  • Also worked with MariaDB, Mysql, SQL Server and NoSQL DB like Mongo and Cassandra
  • Use of Atlassian tools like Jira, Confluence and Bitbucket.

Academic Professor of Financial Mathematics

DuocUC
Santiago
03.2020 - 12.2020

Academic Professor of Financial Mathematics and Mathematical Tools for Electrical Engineers

Data Scientist

SUBUS Chile
Santiago
01.2020 - 04.2020
  • Creation of Macros in Python and Excel Creation and manipulation of structured databases in Sql to find solutions of data inefficiency and software developer in Python, Java
  • Creation of reports in PowerBI with interaction in R and Dax
  • Automation of systems via Bots in Autoit, C # and use of Pentaho
  • Statistical analysis of workers creating RFM and K-Means clustering models, to find inefficiency groups of workers, Using the AWS platform with Spark-Glue, in Pyspark and other Jobs in Spark Scala.

Software Developer

PlanOK
Santiago
01.2019 - 06.2019
  • I was in charge of automating models and graphs online with SQL, Python and Pentaho Integration on AWS, so that statistical information for clients was automatically updated in PowerBI
  • Financial Analysis through Machine Learning models (Random Forest, Random Forest classification models, KNN) created with Spark ML libraries in Scala and Pyspark (Cloudera)

Data Miner and Data Scientist

Isa Intevial S.A, Santiago de Chile
Santiago
01.2019 - 06.2019
  • Creation of statistical models with databases in Excel and SQL to create probabilistic reports of when fraud or internal theft could occur in the company, using R and Python programming languages

    to be presented in an automated way in PowerBI and using Pentaho for reports sent via email with AWS S3, Emr, Athena and Glue services

Software Engineer

Max Planck Institut for Polymer Research
Mainz
03.2017 - 03.2018
  • Germany's largest Polymer Research Institution
  • Creation of macros in Python, C and Spec X-Ray for MPIP
  • Functional organization of the procedure of experiments
  • Scientific control
  • Implementation of Machine Learning algorithms for image processing and logical and exponential regressions, in Python, Pyspark and R on the Cloudera Data Science Workbench platform, making large ingests of image data, the servers were physical and therefore required constant maintenance And control.

Program and Management Analyst

Deutsche Post A.G
Mainz
06.2016 - 03.2017
  • Control of attracting new clients
  • Generation of Django forms in Python, for structuring the order of deliveries
  • Working with Relational DB like MySQL and SQL Server, in order to connect the forms information - Presentations in PowerBI, creation of forms in Django (Python), for the correct operation of Deliveries, Data ingestion through AWS (SparkSQL)
  • Automation.

Education

Master of Science - Civil Engineering in Mathematics

Catholic University of Chile
Santiago, Chile
01.2019 - 01.2020

Bachelor of Science - Mathematik/Informatik

Johannes Gutenberg University
Mainz, Germany
01.2014 - 12.2017

Skills

Python

undefined

Timeline

Solution Developer Senior

Coca Cola Andina
02.2021 - Current

Data Science and Data Engineer

TCS Chile
11.2020 - 02.2021

Data Science and Data Engineer

Consalud Insurance (Project)
07.2020 - 09.2020

Data Science and Data Engineer

Soluciones BI (Project)
06.2020 - 09.2020

Academic Professor of Financial Mathematics

DuocUC
03.2020 - 12.2020

Data Science and Data Engineer

Anticipa S.A, Santiago de Chile
03.2020 - 12.2020

Data Scientist

SUBUS Chile
01.2020 - 04.2020

Master of Science - Civil Engineering in Mathematics

Catholic University of Chile
01.2019 - 01.2020

Software Developer

PlanOK
01.2019 - 06.2019

Data Miner and Data Scientist

Isa Intevial S.A, Santiago de Chile
01.2019 - 06.2019

Software Engineer

Max Planck Institut for Polymer Research
03.2017 - 03.2018

Program and Management Analyst

Deutsche Post A.G
06.2016 - 03.2017

Bachelor of Science - Mathematik/Informatik

Johannes Gutenberg University
01.2014 - 12.2017
Ivan González SchultenSoftware Developer SR.