Scroll To View More
Juan Carlos Lozano Cervantes

Juan Carlos Lozano Cervantes

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
  • Data Modeling, 10 years
  • SQL, 10 years
  • ETL, 6 years
  • QlikView, 6 years
  • Oracle Rdb, 6 years
  • Business Intelligence (BI), 6 years
  • Datastage, 5 years
  • Agile Software Development, 3 years
Mexico City, Mexico
Preferred Environment
Mac OS X, Amazon AWS
The most amazing...
...thing is discovering the great challenges in the world and not limiting your beliefs.
  • Data Architect
    2017 - PRESENT
    • Redesigned the base architecture for the business in preparation to funded growth.
    • Designed the data architecture for optimizing the SMB ad campaigns through machine learning.
    • Coordinating the implementation of the data architecture to ensure integrity, timeliness, consistency, availability, flexibility, and maintainability.
    • Designed the core information flow for ML Sources.
    Technologies: MySQL, Redshift, Laravel
  • Data Scientist
    UST Global
    2016 - 2017
    • Coordinated 6 remote teams on 3 different sites for the implementation of a sales model at a Fortune's 1000 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 migration to a revamped version.
    Technologies: QlikView, Oracle, WebFocus, Teradata
  • Front-End Developer
    Fénix sa de srl
    2016 - 2016
    • 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.
    • Did test-driven development on AngularJS.
    • Performed unit testing of the developed code.
    Technologies: JavaScript, AngularJS, POP, PostgreSQL, TDD
  • Sr. ETL Developer
    UST Global
    2014 - 2016
    • 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
    • Did the upkeep and maintenance of the company data warehouse. Ensured a painless migration to a new platform while keeping internal customer satisfaction with an availability above 98%.
    • Designed, developed, and documented the new ETL processes for the server; also simultaneously managing a team of 3.
    • 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
    • Did class preparation for the Information Based Systems subject.
    • 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 on the 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
  • Tools
  • Platforms
    QlikView, Oracle, Linux, Unix, AIX, JSE
  • Storage
    MySQL, Datastage, Oracle Rdb, Microsoft SQL Server, DB2, IBM Informix, PostgreSQL
  • Misc
    Data Warehouse, ERM, Business Intelligence (BI), Data Modeling, Team Leadership, Algorithms, Data Structures, Algorithm Visualization
  • Paradigms
    Agile Software Development, Scrum
  • Frameworks
    Ruby on Rails (RoR), AngularJS
  • Bachelor's degree in Informatics Sciences
    Instituto Politécnico Nacional - Mexico City, Mexico
    2005 - 2009
I really like this profile
Share it with others