toptal.com
Contact us: +1.888.867.7001
Salvador Rovere, Database Developer in Winnipeg, MB, Canada
Salvador Rovere

Database Developer in Winnipeg, MB, Canada

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.
Salvador is now available for hire
Hire Salvador

Portfolio

Experience

Location

Winnipeg, MB, Canada

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.

Employment

  • 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 DB, 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 Warehouse Design, Data Warehousing, 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 Warehouse Design, Data Warehousing, 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

Experience

  • 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.

Skills

  • 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, Webhook, Utilities, Computer Science

  • Frameworks

    Django, Django REST Framework, Hadoop, Flask, Presto DB

  • 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

Education

  • Higher Tertiary Degree in Programming (Computer Science)
    2006 - 2008
    UTN National University of Technology - Buenos Aires, Argentina

Certifications

  • IELTS General Training
    NOVEMBER 2019 - NOVEMBER 2021
    IELTS Official
  • Teradata Database Certified Associate
    AUGUST 2017 - AUGUST 2022
    Teradata
  • Vantage Certified Associate
    AUGUST 2017 - AUGUST 2022
    Teradata

To view more profiles

Join Toptal
Share it with others
Hire the top 3% of freelance developers TM