Gerardo Alvarez
Download
Recommend
Messages
Share
Gerardo Alvarez

Gerardo Alvarez  new_releases

About

Detail

Data engineer
Michoacán, Mexico
Contact Gerardo regarding: 
connect_without_contact
Finding mentors

Timeline

work
Job
school
Education
folder
Project (professional or personal)

Résumé

Jobs verified_user 0% verified
  • TATA CONSULTANCY SERVICES TCS
    Data Engineer
    TATA CONSULTANCY SERVICES TCS
    Oct 2022 - Current (3 years)
    - Agreggate data from multiple source systems into a consistent DW from Snowflake - Worked with the DataStage tool from IBM Infosphere to perform ETL´s on data source into the target system. - Helped organizations to aggregate data from multiple source systems into a consistent Data Warehouse. - Used Control M to schedule the workflow of the ETL’s process to run as the manager requires. - Work with linux shell commands to navigate through the server and configure files.
  • f
    Data Engineer public Remote experience
    freelance
    Aug 2022 - Oct 2022 (3 months)
    - Built a web scraper class - Built a web scraper that extracts data from restaurants web pages to then gather all the data into a csv file for further analysis. -I implemented the web scraper class using python and request framework. And with the use of Pandas I was able to gather all the data in XML into a Pandas DataFrame, transform the data and then export the data as a csv file.
  • I
    Data Engineer at
    Intellidatasys
    Aug 2021 - Jul 2022 (1 year)
    - Deployment of a pipeline for customer sentiment analysis - Deployment of a pipeline for Anomaly detection in data ingestion - Followed AGILE Methodology to promote iterations, collaboration, and process adaptability and participated in SCRUM Meetings throughout the life cycle of the project. - Created a Data Pipeline for Customer Sentiment Analysis using Python, Spark, Pandas, SQL, Hadoop and Machine Learning. - Worked with ETL's throughout the life cycle of the pipeline - Perform data preparation on datasets to handling missing values, feature selection, feature engineering, handling outliers and fixing the variables data distribution. - Created a class that handles outliers per day of the week and did null imputation on time series dat
  • S
    SQL Developer
    May 2021 - Jul 2021 (3 months)
    - Helped an organizatio to management their data - Created a Restaurant Management System (RMS) for a restaurant in PostgreSQL creating a Database, Tables, Inserting Data and creating Entity Relationship Diagram (ERD) to help a medium size restaurant have a better management of their data. Creating Employees table, Inventory Table, Food Catalog table and Customers Table. - Successfully helped the organization have a better organization of their data
  • Jabil
    Test Engineer
    Jabil
    Jul 2019 - Apr 2020 (10 months)
    - Test on ICT Machines - Built a database to organize the data from the ICT department - Operating the ICT (In circuit test) and fixtures machines . - Used Linux shell scripting to configure files and fixing debugs on the ICT machine. - Solving problems in the ICT test. - Constant maintenance of the ICT and Fixtures machines - Built a Database that manages inventory about the ICT department. This was achieve through PostgreSQL.
Education verified_user 0% verified
  • C
    CertNexus Certified Data Science Practitioner
    Jan 2022 - Current (3 years 9 months)
  • I
    IBM Data Engineering Professional Certificate
    Jan 2022 - Current (3 years 9 months)
  • Instituto Tecnologico de Morelia
    Bachlors in Electronic Engineering
    Instituto Tecnologico de Morelia
    Aug 2013 - Dec 2019 (6 years 5 months)
    - With a minor in embedded systems. - Highly proficient with Texas instrument's MSP family of micro-controllers, especially with MSP4302G2553 and MSP430F5559. Skillful with PsSoc 5 from Cypress, At mega and Arduino. - Develop low-level code for hardware with FPGA by creating an ALU and doing floating-point addition and multiplication.
Projects (professional or personal) verified_user 0% verified
  • I
    Anomaly detection in data ingestion
    Intellidatasys
    Mar 2022 - Jul 2022 (5 months)
    - Build an Machine learning algorithm - Detect anomalies in data ingestion through ARIMA models - Develop a Machine learning algorithm for anomaly detection in time series
  • C
    Customer Sentiment Analysis Pipeline
    Aug 2021 - Mar 2022 (8 months)
    - Data Preprocessing and Machine Learning Implementation - Predict Customer satisfaction - Preprocessing the data to be ingested in a Machine Learning model to create a Customer Sentiment Analysis pipeline