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, 10 years
  • Data Modeling, 10 years
  • Data Visualization, 6 years
  • ETL, 6 years
  • Business Intelligence (BI), 6 years
  • Oracle Rdb, 6 years
  • Datastage, 5 years
  • Agile Software Development, 3 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.


  • 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, Qliksense
  • 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 DB, 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, C#, PHP, Java
  • Paradigms

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

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

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

    Data Visualization, Data Warehousing, ERM, Data Modeling, Data Structures, Algorithms, Data Architecture, Team Leadership, Algorithm Visualization
  • Frameworks

    Lumen, Laravel, AngularJS, Ruby on Rails (RoR)
  • Libraries/APIs

  • Tools

    Qlik Sense


  • Bachelor's degree in Informatics Sciences
    2005 - 2009
    Instituto Politécnico Nacional - Mexico City, Mexico
I really like this profile
Share it with others