Fernando Demarchi, Developer in Córdoba, Cordoba, Argentina
Fernando is available for hire
Hire Fernando

Fernando Demarchi

Verified Expert  in Engineering

Data Engineer and Developer

Location
Córdoba, Cordoba, Argentina
Toptal Member Since
December 28, 2019

Fernando is a data engineer and BI developer with more than nine years of experience working with big data solutions and data scientists on machine learning projects. Fernando specializes in improving companies' decision-making processes by transforming transactional data into information via analytic methodologies. Fernando has led teams of data engineers and data scientists to give solutions to robust data infrastructure to deliver end-to-end solutions to business problems.

Portfolio

Toptal
Data Engineering, SQL Server DBA, Tableau, Scrum, ETL, Data Warehouse Design...
Claro Argentina
Analytics, SAS Visual Analytics, Data Engineering, Scrum...
Claro Argentina
Bitbucket, Analytics, SAS Visual Analytics, Data Engineering, Scrum...

Experience

Availability

Part-time

Preferred Environment

Apache Airflow, Hadoop, Python, Linux

The most amazing...

...project I've worked on was one that involved machine learning to predict the outliers of all the company KPIs in near real time.

Work Experience

Data Engineer

2020 - PRESENT
Toptal
  • Developed a set of visualizations and reports with Power BI and Tableau.
  • Deployed and configured the infrastructure of a BI environment.
  • Developed a set of reports integrated by Microsoft Power BI embedded.
  • Created a new data model to analyze the data through Power BI and Tableau.
  • Recommended and implemented an ETL infrastructure based on the organization's requirements.
Technologies: Data Engineering, SQL Server DBA, Tableau, Scrum, ETL, Data Warehouse Design, Data Warehousing, Business Intelligence (BI), SQL, Microsoft Power BI, Data Visualization, Snowflake, Apache Airflow, BigQuery

Big Data Supervisor

2018 - 2020
Claro Argentina
  • Ensured the team worked on relevant assignments and acted as a facilitator in daily blocker situations.
  • Identified and recommended solutions to address or solve specific problems of the company (customer experience, average revenue per user, fidelization, service quality).
  • Worked together with different big data and BI vendors such as IBM, SAS, Tableau, and MicroStrategy.
  • Created monthly progress reports for executive stakeholders.
  • Monitored and assessed ongoing projects with Scrum using Trello and Jira.
  • Recommended the development of a new technological architecture to solve problems through big data and machine learning, avoiding the purchase of expensive vendors.
  • Worked together with executives from multiple areas to create projects that improved the customer experience, ARPU (average revenue per user), and fidelization.
  • Reviewed the quality of Python, SQL, and BI tools developed by the team.
Technologies: Analytics, SAS Visual Analytics, Data Engineering, Scrum, Business Intelligence (BI), ETL, SQL, Python, Cloudera, Hadoop, Jira, Apache Airflow, Bitbucket

Data Engineer

2015 - 2018
Claro Argentina
  • Created ETL from different data sources with SQL and Python to load on HDFS format (parquet, text format) or Oracle databases. Developed with ETL tools such as Airflow and Oozie.
  • Worked together with business analysts and managers to develop their projects.
  • Created dashboards and reports with BI Tools like Tableau, MicroStrategy, SAS Visual Analytics, and Visual Crossing.
  • Tested new big data and analytics technologies, such as Hadoop Cloudera, Isilon, Airflow, AWS, Python for machine learning, and SAS Code.
  • Worked with data scientists on machine learning projects.
  • Oversaw performance optimization, tuning, and indexing in SQL, Hive, and the Impala databases.
  • Ran weekly meetups with stakeholders of ongoing projects.
  • Maintained existing ETL developed in SQL and Python.
Technologies: Bitbucket, Analytics, SAS Visual Analytics, Data Engineering, Scrum, Business Intelligence (BI), Oracle, ETL, Microsoft Power BI, SAS, Tableau, SQL, Python, Git, Apache Airflow, Cloudera, Hadoop, Data Visualization

BI Developer

2010 - 2015
DICSYS S.A.
  • Analyzed data from different sources with Oracle SQL.
  • Visualized the data by creating dashboards and enabling the data to be explored by the user using different BI tools such as MicroStrategy and SAS.
  • Developed a new ETL process using Oozie at the beginning and also SQL scripts.
Technologies: Kanban, SAS Visual Analytics, Business Intelligence (BI), Oracle, ETL, SQL, Cloudera, Hadoop, MicroStrategy, SAS, Oracle SQL, Data Visualization

Data Transfer

Extract, transform, and load all the data from different sources, such as CDR (call detail record) files with billions of daily transactions and tables from different databases, social media, and so on. Then to be stored in a data lake while working in real-time or near real-time and batch data.

Fidelity

The principal goal was to obtain a predictive score for each customer—for values from one to ten—where one is for a customer close to leaving or unhappy with the company and ten for those clients who enjoy and promote the company's services.

Languages

SQL, Snowflake, SAS, Python

Tools

Cloudera, Bitbucket, Tableau, SAS Viya, Microsoft Power BI, Jira, Git, Apache Airflow, Amazon Elastic MapReduce (EMR), AWS Glue, Amazon Athena, BigQuery

Paradigms

Business Intelligence (BI), ETL, Scrum, Kanban

Platforms

Oracle, Jupyter Notebook, Linux, Amazon Web Services (AWS), Amazon EC2

Other

Data Warehousing, Data Visualization, Data Warehouse Design, SAS Visual Analytics, Big Data, Data Engineering, MicroStrategy, Analytics, Leadership, Tableau Server, Amazon Kinesis

Frameworks

Hadoop

Storage

MySQL, SQL Server DBA, Oracle SQL, Redshift, Amazon S3 (AWS S3)

Libraries/APIs

PySpark

2006 - 2014

Systems Engineer Degree in Computer Science

Universidad Tecnologica Nacional (UTN) - Córdoba, Argentina

AUGUST 2017 - PRESENT

Predictive Modeling Using Logistic Regression

SAS

MAY 2017 - PRESENT

SAS Programming 2: Data Manipulation Techniques

SAS

JUNE 2016 - PRESENT

MicroStrategy 10

DICSYS S.A.

MAY 2016 - PRESENT

SAS Programming 1: Essentials

SAS

APRIL 2016 - PRESENT

Statistics 1: Introduction to ANOVA, Regression, and Logistic Regression

SAS

JANUARY 2011 - PRESENT

MicroStrategy for Beginners

DICSYS S.A.

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring