Salvador Rovere, Developer in Winnipeg, Canada
Salvador is available for hire
Hire Salvador

Salvador Rovere

Verified Expert  in Engineering

Database Developer

Location
Winnipeg, Canada
Toptal Member Since
June 24, 2020

Salvador is a data warehouse specialist with over ten years of experience developing applications and solving problems across various technical and business domains, including finance, retail, restaurants, and telecommunications. Motivated by data-driven solutions, Salvador is recognized by his peers for his work and for being an exemplary partner on projects.

Portfolio

WannaPlay (A Division of Enzime Venture Capital SA)
Amazon Web Services (AWS), Django REST Framework, Django, Python 3
Galicia Bank at Teradata de Argentina SRL (Financial Industry)
Shell Scripting, Python 3, Presto, Apache Hive, Cloudera, Hadoop, Linux...
Carrefour at Teradata de Argentina SRL (Retail Industry)
Shell Scripting, Django, Python 3, MicroStrategy, Teradata Databases

Experience

Availability

Part-time

Preferred Environment

Docker, Amazon Web Services (AWS), Linux, PyCharm, Django REST Framework, Django, Python 3, Hadoop, ANSI SQL, Teradata

The most amazing...

...thing I've ever built is an on-demand ETL tool for a retail company that enabled users to update live data on their data warehouse—reducing 40% of manual tasks.

Work Experience

Architecture and Development Manager

2019 - 2020
WannaPlay (A Division of Enzime Venture Capital SA)
  • Selected the cloud provider and designed the architecture of the application.
  • Led the application back-end reengineering process using Python 3 and Django framework—replacing the legacy, poorly performing Python 2 implementation.
  • Designed and implemented the automated production deployment process using AWS Lambda Functions and the Django Zappa Module.
Technologies: Amazon Web Services (AWS), Django REST Framework, Django, Python 3

Senior Data Engineer

2018 - 2019
Galicia Bank at Teradata de Argentina SRL (Financial Industry)
  • Implemented a new pipeline for ETL processes on the Hadoop platform. Defined and implemented the user profiles and user groups for related data environments.
  • Built an ETL framework that also contained shell scripting language that managed services, jobs, and logs for each process.
  • Designed and implemented an AnalyticOps framework whose main function was to deploy automatically data models in a scalable and sustainable way.
Technologies: Shell Scripting, Python 3, Presto, Apache Hive, Cloudera, Hadoop, Linux, Teradata Databases

Senior ETL and Full-stack Developer

2018 - 2018
Carrefour at Teradata de Argentina SRL (Retail Industry)
  • Conducted, assisted, and supervised multiple dashboards migration from MicroStrategy Web Services 9.4 to 10.4.
  • Designed, scoped, developed, and implemented an ETL tool using Python 3 and the Django web framework. The solution allowed users to upload data into the data warehouse on demand. It also was integrated with LDAP and contained profile-based menus.
  • Wrote and tested back-end SQL processes for the product stock control procedure.
Technologies: Shell Scripting, Django, Python 3, MicroStrategy, Teradata Databases

Senior Data Engineer

2017 - 2018
Interbank Perú at Teradata de Perú (Financial Industry)
  • Wrote, designed, and optimized quality control processes on the existing ETL jobs.
  • Analyzed and automated ETL integration scripts as much as possible.
  • Coordinated user requirements and based on that designed and built processes on the Hadoop platform to load the Aster database for the development of data models.
  • Worked side by side with a data scientist on the event data repository for a churn analytical codel—designing and building a physical data model using Erwin along with scoping, designing, and testing daily ETL routines in Teradata.
Technologies: Linux, Python 3, Apache NiFi, Apache Hive, Cloudera, Hadoop, Teradata Databases

Senior Data Modeler

2016 - 2017
Galicia Bank at Teradata de Argentina SRL (Financial Industry)
  • Designed and built a physical data model for the risk financial department used to create dashboards for directors.
  • Scoped, designed, and tested daily ETL routines along with managing ETL reports and administering the final live process and optimal data visualization.
  • Trained other team members of the analytics department to improve their use of the Teradata database platform.
  • Developed a Python ETL tool with a Windows Graphic User Interface to upload data that wasn't present in any operating system to the risk data mart.
Technologies: Python 3, Shell Scripting, Windows, Trello, Informatica PowerCenter, Teradata Databases

ETL and SQL Developer

2015 - 2016
BBVA Francés Bank at Teradata de Argentina SRL (Financial Industry)
  • Built ETL processes with Informatica PowerCenter 9.
  • Led the migration from Teradata 13.10 to Teradata 14.10 using Linux low-level utilities.
  • Helped co-workers to succeed in obtaining their Teradata certifications.
Technologies: Utilities, Linux, Informatica PowerCenter, Teradata

Senior ETL Developer

2013 - 2014
Arcos Dorados at Teradata de Argentina SRL (Restaurant Industry)
  • Worked on the full data warehouse lifecycle—designing and building a physical data model along with scoping, designing, and testing ETL routines and administering the final live process.
  • Developed a Python program to acquire data from the checkouts of the McDonald's terminals in order to have live data available for key users' decision-making processes.
  • Acted as a database consultant in optimizing ETL processes by applying knowledge of Teradata architecture and proper usage of indexes.
Technologies: Data Warehousing, Data Warehouse Design, Oracle Data Integrator (ODI), Teradata

Professional Services Consultant

2013 - 2013
Movistar at Teradata de Argentina SRL (Telecommunications Industry)
  • Acted as a database consultant in optimizing report queries by applying knowledge of Teradata architecture and proper usage of indexes.
  • Scoped, designed, and tested ETL algorithms using an in-house ETL tool with ANSI SQL.
  • Detected, as an ETL consultant, pain points in the main batch process and optimizing the identified steps.
Technologies: Data Warehousing, Data Warehouse Design, Windows Server, Utilities, Teradata

Professional Services Consultant

2009 - 2013
Carrefour at Teradata de Argentina SRL (Retail Industry)
  • Automated ETL processes from Informix and SQL Server databases to Teradata using PERL.
  • Built and tested MicroStrategy reports and dashboards for the sales departments and the board of directors.
  • Migrated a MicroStrategy Server 7 to 9.02 and a Teradata database 13.10 to 14.10.
  • Implemented a backup strategy using ARCMain and Tivoli and established backup copies of critical data on a daily, weekly, and monthly bases.
  • Designed and developed a process that allowed forecasting the number of employees and open checkout points needed by the store at a particular time of day using large volumes of historical data.
Technologies: Utilities, Teradata, MicroStrategy, Microsoft SQL Server, Linux, Shell Scripting

WannaPlay App

A Swift- and Android-based app, that allows people to find other people to join together and play soccer.

I developed the second version of the back end and also defined the architecture and implemented it on AWS using Lambda Functions and S3 as storage.

Languages

SQL, Python 3, JavaScript, Python, CSS3, CSS, HTML, HTML5

Paradigms

Database Design, ETL, Dimensional Modeling, REST, Database Development

Platforms

Windows, Docker, Windows Server 2012, Linux, Oracle Data Integrator (ODI), AWS Lambda, Amazon Web Services (AWS), Windows Server

Storage

Teradata, ANSI SQL, Databases, Teradata Databases, Relational Databases, PostgreSQL, JSON, MySQL, Amazon S3 (AWS S3), Apache Hive, Database Modeling, Database Architecture, Redis, Microsoft SQL Server

Other

Data Warehousing, Data Analytics, Shell Scripting, Full-stack, Back-end, Scripting, Teradata Systems Administration, MicroStrategy, Data Warehouse Design, Ajax, Data Modeling, Data Engineering, Webhooks, Utilities, Computer Science

Frameworks

Django, Django REST Framework, Hadoop, Flask, Presto

Libraries/APIs

jQuery, JSONP, REST APIs, Django ORM

Tools

Docker Compose, PyCharm, Informatica PowerCenter, Postman, Informatica ETL, RabbitMQ, pgAdmin, Celery, Erwin, Control-M, Trello, Cloudera, Apache NiFi

Industry Expertise

Retail & Wholesale, Banking & Finance

2006 - 2008

Higher Tertiary Degree in Programming (Computer Science)

UTN National University of Technology - Buenos Aires, Argentina

NOVEMBER 2019 - NOVEMBER 2021

IELTS General Training

IELTS Official

AUGUST 2017 - AUGUST 2022

Teradata Database Certified Associate

Teradata

AUGUST 2017 - AUGUST 2022

Vantage Certified Associate

Teradata

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