Fernando Demarchi
Verified Expert in Engineering
Data Engineer and Developer
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
Experience
- ETL - 9 years
- SQL - 9 years
- Business Intelligence (BI) - 8 years
- Data Engineering - 6 years
- Python - 2 years
- Snowflake - 2 years
- PySpark - 1 year
Work Experience
Data Engineer
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.
Big Data Supervisor
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.
Data Engineer
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.
BI Developer
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.
Project History
Data Transfer
Fidelity
Education
Systems Engineer Degree in Computer Science
Universidad Tecnologica Nacional (UTN) - Córdoba, Argentina
Certifications
Predictive Modeling Using Logistic Regression
SAS
SAS Programming 2: Data Manipulation Techniques
SAS
MicroStrategy 10
DICSYS S.A.
SAS Programming 1: Essentials
SAS
Statistics 1: Introduction to ANOVA, Regression, and Logistic Regression
SAS
MicroStrategy for Beginners
DICSYS S.A.
Skills
Libraries/APIs
PySpark
Tools
Cloudera, Bitbucket, Tableau, SAS Viya, Microsoft Power BI, Jira, Git, Apache Airflow, Amazon Elastic MapReduce (EMR), AWS Glue, Amazon Athena, BigQuery
Languages
SQL, Snowflake, SAS, Python
Paradigms
Business Intelligence (BI), ETL, Scrum, Kanban
Platforms
Oracle, Jupyter Notebook, Linux, Amazon Web Services (AWS), Amazon EC2
Frameworks
Hadoop
Storage
MySQL, SQL Server DBA, Oracle SQL, Redshift, Amazon S3 (AWS S3)
Other
Data Warehousing, Data Visualization, Data Warehouse Design, SAS Visual Analytics, Big Data, Data Engineering, MicroStrategy, Analytics, Leadership, Tableau Server, Amazon Kinesis
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring