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
Portfolio
Experience
  • SQL, 10 years
  • Data Modeling, 10 years
  • ETL, 6 years
  • Business Intelligence (BI), 6 years
  • Oracle Rdb, 6 years
  • Data Visualization, 6 years
  • Datastage, 5 years
  • Agile Software Development, 3 years
Mexico City, Mexico
Availability
Part-time
Preferred Environment
Mac OS X, Amazon AWS
The most amazing...
...thing is discovering the great challenges in the world and not limiting your beliefs.
Employment
  • Data Architect
    2017 - 2018
    Adext
    • 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
  • 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
    Randstad
    • 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
    IPN
    • 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
    Edenred
    • 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
Skills
  • Languages
    SQL, C#, PHP, Java
  • Paradigms
    ETL, Agile Software Development, Scrum
  • Platforms
    Oracle, QlikView, AIX, Unix, Linux, JSE
  • Storage
    Oracle Rdb, MySQL, Datastage, PostgreSQL, IBM Informix, DB2, Microsoft SQL Server, RedShift
  • Other
    ERM, Business Intelligence (BI), Data Warehouse, Data Visualization, Data Modeling, Data Architecture, Data Structures, Algorithms, Team Leadership, Algorithm Visualization
  • Frameworks
    AngularJS, Laravel, Ruby on Rails (RoR), Lumen
  • Libraries/APIs
    Node.js
Education
  • Bachelor's degree in Informatics Sciences
    2005 - 2009
    Instituto Politécnico Nacional - Mexico City, Mexico
I really like this profile
Share it with others