Consultant2018 - 2019Acorn.work (via Toptal)
Technologies: Laravel, Vue.js, PostgreSQL
- Assembled and led the team.
- Created the data architecture and database design.
- Built ETLs.
Data Architect2017 - 2018Adext
Technologies: MySQL, Redshift, Laravel
- Redesigned the base architecture for the business in preparation for funded growth.
- Designed the data architecture for optimizing the SMB ad campaigns through machine learning.
- Coordinated the implementation of the data architecture to ensure integrity, timeliness, consistency, availability, flexibility, and maintainability.
- Designed the core information flow for ML sources.
- Reduced data costs by 50%.
Data Scientist2016 - 2017UST Global
Technologies: QlikView, Oracle, WebFOCUS, Teradata, Qlik Sense
- Coordinated six remote teams on three different sites for the implementation of a sales model at a Fortune's 1,000 USA subsidiary.
- Ensured data consistency with the ERP system, improving information timeliness by 40% and improving information integrity by 70%.
- Coordinated teams for implementation of a data lake for a big data model.
- Performed management activities in a technical position.
- Maintained the existing information model during a migration to a revamped version.
Front-end Developer2016 - 2016Fénix sa de SRL
- Performed contract work for developing management screens for a transportation-related company.
- Worked on data modeling for user, driver, and partner information.
- Wrote documentation for testing.
- Implemented test-driven development on AngularJS.
- Performed unit testing of the developed code.
Senior ETL Developer2014 - 2016UST Global
Technologies: IBM DataStage, Oracle Database, Salesforce, Teradata, DB2, Informix, MQ
- Led a team of up to 15 people.
- Ensured data availability by migrating from obsolete technology (Informix) to leading-edge technology(Oracle, then Cassandra Cloud) for a 2.5% cost reduction versus the EBITDA of a Fortune 1000 company.
- Analyzed, designed, developed, and documented the new ETL parallel processes using relational and cloud technologies.
- Migrated from Informix to Oracle of the customer management database and ETL processes.
- Created massive processing processes for adaptable load processes; having the process adapt to the information layout provided.
DWH Consultant2013 - 2014Randstad
Technologies: Oracle, DataStage, Teradata, MicroStrategy, QlikView, SAS
- Maintained the company data warehouse—ensuring a painless migration to a new platform while keeping internal customer satisfaction with an availability of 98%.
- Designed, developed, and documented the new ETL processes for the server; also simultaneously managing a team of three.
- Maintained and surveilled the company DWH, BI, and ETL server and parallel processes—reducing the upkeep time by 60%.
- Provided user support, development, and administration on the MicroStrategy BI server.
- Gave user support and administration on SAS 9.2, 9.3.
Assistant Professor2012 - 2013IPN
Technologies: SQL Server, Talend Open Studio, DataStage
- Prepared for the class: Information Based Systems.
- Taught database set analysis as basis for DSS.
- Lectured on data quality.
- Evaluated and gave feedback and support to students.
Analyst Developer2010 - 2012Edenred
Technologies: QlikView (BI & OLAP), C#, Adobe Flex, PrintNet T, AS400, MS SQL Server, DB2
- Engineered new requirements and upgrades for various systems.
- Maintained and upgraded the CRM (bonds emitted and earnings models) along with corresponding maintenance, upgrades, OLAP cubes, and ETL.
- Performed the upkeep of the company website.
- Upgraded the orders system from the database to the front end.
- Developed a new functionality to the IT support tickets system from the database to the front end.