Julian Cortes

Experience

• 

  INSSJP - National Institute for the Social Services to Retirees and Pensioners

  Jan 2010 - Sept 2013

  Head of Campaign Analysis Team

  ● Automatize the validation of the medical services rendered and the corresponding fraud detection. SQL procedures were used to accomplish this.● Development of a web App that allowed stakeholders reach information that before had to be provided by my team.● Teach SQL to stakeholders and work alongside to include new information and medical services in the first two bullets.

• 

  Central Bank of Argentina

  Nov 2013 - Jul 2016

  Risk Analyst

  ● Lead the creation of an Operational Risk model and test the Capital at Risk against the Argentinean financial system.● Review, comprehend and test the international financial regulation projects with ends on calculating Capital at Risk and regulatory reserves. ● Create and incorporate variables to the Credit Risk predictive model used in the bank’s stress test exercise.● Conduct a seminar for bank auditors on Basel III methodologies to calculate Market Risk metrics.

• 

  Cordial Compañía Financiera S.A.

  Jan 2018 - Jan 2019

  Business Intelligence Analyst

  ● Lead the clients’ segmentation and clustering. Applied A/B testing and K-Means among others, mostly used SQL and Python to achieve these goals.● Modified the SQL procedure behind the products’ campaign to add products and improve its efficiency.● Created a churn model based on a logistic regression and tested it through KS, ROC curve and lift.● Automatize the detection of clients who might stop consuming or using the company’s services.● Generate automatic metrics, KPIs and reports for managements and stakeholders. Show less

• 

  InvoCare

  Sept 2019 - Mar 2020

  Data Analyst

  ● Build dashboards to analyze the call center´s performance metrics & KPIs as well as building red flags and automated alerts. (SQL, Microsoft Excel)● Generate a database of potential clients, suppliers, stock and related variables. (PL/SQL)● Automatize the detection of suppliers in financial distress, lack of stock and delivery issues. This includes assigning the different cases to stakeholders according to priority and subject. (PL/SQL, Microsoft Excel)● Migrate information from the old management system to a SQL database, including its architecture. (SQL) Show less

• 

  Balun

  Apr 2020 - Jun 2022

  Co-Founder & Data Scientist

  ● Business Intelligence project building and project management, setting of goals, timelines, research, consulting hours & employee training/formation.● Creation of Cloud environments. (cPanel, AWS)● Development of API connections for data extraction and uploading of information. (Python)● Building databases, its architecture, management, ETL (Extract, Transform, Load), data governance. (SQL)● Model development: churn, segmentation, cross selling, among others. (Python)● Automation of procedures aiming to cut on operative time consuming tasks. (SQL, Python, CRON Jobs, Excel/Gsheets)● Data Visualization dashboards & reporting: including red flags & alarms, client segmentation, CRM, financial statements, market trends & insights, Key Performance Indicators (KPIs) analysis, etc. Dashboards are updated automatically according to the client’s needs. (Power BI, Tableau, SQL, CRON Jobs) Show less

• 

  PwC

  Aug 2020 - Feb 2021

  Data Scientist

  ● Client Segmentation & clustering using A/B testing, K-Means, RFM (Recency, Frequency, Monetary value) techniques among others. (Python & SQL) ● Data Analytics & Data Visualization dashboard development oriented to market trends & insights, metrics & KPI tracking and projections, red flags & alarms, etc. (Power BI, SQL, CRON Jobs)● Automation of procedures aiming to cut on operative time consuming tasks. (SQL, Python, CRON Jobs, Microsoft Excel/GSheets, Alteryx)● Risk Assessment and Management, applying data insights to solving business problems.● Predictive model development: churn, clustering, classification, among others. (Python) Show less

• 

  Foton.

  Feb 2021 - Oct 2021

  Data Scientist

  ● Planning of short & long term projects and department objectives.● Development of API connections for data extraction and uploading of information. (Python)● Creation of entertainment cloud databases: movies, series & gaming. Unification of data sources, ETL (Extract, Transform, Load), automatic data update and processing, data governance. (Python, SQL, CRON Jobs, cPanel)● Data Visualization dashboard development oriented to market trends & insights, metrics & KPI tracking and projections, red flags & alarms, etc. (Power BI, SQL, CRON Jobs)● Venture capital modeling, both client presentation version & inner technical model.● Automation of procedures aiming to cut on operative time consuming tasks. (SQL, Python, CRON Jobs, Microsoft Excel/GSheets, Alteryx) Show less

• 

  IPSY

  Jul 2022 - now

  Data Analyst

  ● Business Intelligence project building and project management, setting of goals, timelines, research, consulting hours & employee training/formation.● Automation of procedures aiming to cut on operative time consuming tasks. (SQL, PySpark, CRON Jobs, Excel/Gsheets)● Data Visualization dashboards & reporting: including Logistics timelines red flags & alarms, client segmentation, financial statements, market trends & insights, Key Performance Indicators (KPIs) analysis, etc. Dashboards are updated automatically according to the client’s needs. (Tableau, SQL, PySpark, CRON Jobs) Show less