Scroll To View More
Juan Carlos Lozano Cervantes, Data Modeling Developer in Mexico City, Mexico
Juan Carlos Lozano Cervantes

Data Modeling Developer in Mexico City, Mexico

Member since August 9, 2016
Juan is a very curious, humane person who's always trying to get to know the customer and their underlying problems. He is proud of how quickly he learns and his dedication to his work. During his career, he has met with all sorts of people and this has taught him to be broadminded yet to uphold the best practices that he is passionate about.
Juan is now available for hire



  • SQL, 12 years
  • Data Modeling, 12 years
  • Data Visualization, 8 years
  • Business Intelligence (BI), 8 years
  • ETL, 8 years
  • Oracle Rdb, 6 years
  • Agile Software Development, 5 years
  • Datastage, 5 years
Mexico City, Mexico



Preferred Environment

Mac OS X, Amazon AWS

The most amazing...

...thing I've done was the logistics tracing for El Puerto de Liverpool.


  • Consultant

    2018 - 2019 (via Toptal)
    • Assembled and led the team.
    • Created the data architecture and database design.
    • Built ETLs.
    Technologies: Laravel, Vue.js, PostgreSQL
  • Data Architect

    2017 - 2018
    • 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%.
    Technologies: MySQL, Redshift, Laravel
  • Data Scientist

    2016 - 2017
    UST Global
    • 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.
    Technologies: QlikView, Oracle, WebFOCUS, Teradata, Qlik Sense
  • Front-end Developer

    2016 - 2016
    Fé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.
    Technologies: JavaScript, AngularJS, POP, PostgreSQL, TDD
  • Senior ETL Developer

    2014 - 2016
    UST Global
    • 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.
    Technologies: IBM DataStage, Oracle Database, Salesforce, Teradata, DB2, Informix, MQ
  • DWH Consultant

    2013 - 2014
    • 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.
    Technologies: Oracle, DataStage, Teradata, MicroStrategy, QlikView, SAS
  • Assistant Professor

    2012 - 2013
    • 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.
    Technologies: SQL Server, Talend Open Studio, DataStage
  • Analyst Developer

    2010 - 2012
    • 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.
    Technologies: QlikView (BI & OLAP), C#, Adobe Flex, PrintNet T, AS400, MS SQL Server, DB2


  • Languages

    SQL, JavaScript, C#, Java, PHP
  • Libraries/APIs

    Node.js, Vuex, Vue.js 2, LinkedIn API, Chart.js
  • Paradigms

    Agile Software Development, Scrum, ETL, Business Intelligence (BI), Database Development, Kanban, Web Architecture
  • Platforms

    QlikView, Oracle, Unix, Linux, AIX, JSE, Amazon Alexa
  • Storage

    PostgreSQL, MySQL, Datastage, Oracle Rdb, Database Architecture, Redshift, IBM Informix, IBM DB2, Microsoft SQL Server
  • Other

    Data Visualization, Data Warehousing, Data Structures, Data Architecture, ERM, Data Modeling, Database Table Optimization, Performance Tuning, Code Review, Algorithms, Team Leadership, Technical Hiring, Stored Procedures, Architecture, Team Management, Algorithm Visualization
  • Tools

    Qlik Sense
  • Frameworks

    Lumen, Laravel, AngularJS, Ruby on Rails (RoR)


  • Bachelor's degree in Informatics Sciences
    2005 - 2009
    Instituto Politécnico Nacional - Mexico City, Mexico
  • Licenciatura en ciencias de la informática, Cédula 8144527
    JUNE 2013 - PRESENT
I really like this profile
Share it with others