Salvador Rovere
Verified Expert in Engineering
Database Developer
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
Experience
Availability
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
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.
Senior Data Engineer
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.
Senior ETL and Full-stack Developer
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.
Senior Data Engineer
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.
Senior Data Modeler
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.
ETL and SQL Developer
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.
Senior ETL Developer
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.
Professional Services Consultant
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.
Professional Services Consultant
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.
Experience
WannaPlay App
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.
Education
Higher Tertiary Degree in Programming (Computer Science)
UTN National University of Technology - Buenos Aires, Argentina
Certifications
IELTS General Training
IELTS Official
Teradata Database Certified Associate
Teradata
Vantage Certified Associate
Teradata
Skills
Libraries/APIs
jQuery, JSONP, REST APIs, Django ORM
Tools
Docker Compose, PyCharm, Informatica PowerCenter, Postman, Informatica ETL, RabbitMQ, pgAdmin, Celery, Microsoft Excel, Erwin, Control-M, Trello, Cloudera, Apache NiFi
Languages
Python, SQL, Python 3, JavaScript, 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
Frameworks
Django, Django REST Framework, Hadoop, Flask, Presto
Industry Expertise
Retail & Wholesale, Banking & Finance
Other
Data Warehousing, Data Analytics, Data Analysis, Shell Scripting, Full-stack, Back-end, Scripting, Teradata Systems Administration, MicroStrategy, Data Warehouse Design, Ajax, Data Modeling, Data Engineering, Webhooks, Utilities, Computer Science
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