Andre Ramos da Silva

Key Skills

  • ETL
  • Data Modeling
  • CI/CD
  • TDD
  • GIT Flow
  • API REStfull
  • business Intelligence
  • Software Development
  • Data structures
  • Data Integration
  • Objetct Oriented Programing (OOP)
  • Cloud
  • SQL
  • NoSql
  • OLAP/OLTP
  • Data Enginering

Technologies

  • Python
  • Node.js
  • Java
  • SQL-Server
  • Redshift
  • Hive
  • Hadoop
  • EMR
  • PySpark
  • AWS Lambda
  • microservices
  • integration services (SSIS)
  • Data Integration
  • Elastic Search, Log Stash, Kibana (ELK)
  • GCP
  • AWS

Work Experience

Software Engineer - Mercado Livre

March-2024 - Today

-Working on development of cloud applications, using best practices

Software/ Data Engineer - Santander

jan-2023 - ago-2023

-Working on development of a data platform that allows data democratization. -Development of a data lake warehouse, and migration of data from on premisses to the cloud. -Worked in the migration of a few PetaBytes. -Lead the migration of enginees, processes , applications and data(silver/gold) for PJ, PF. .

Software Development Engineer - Itau

April 2021 - dez-2022

-Worked on the core Migration & modernization of Exchange breaking down the whole system into microservices and putting it on aws using best practices and ways to keep it secure, scalable and reliable. Designed and implemented the core of Exchange(called conference). Designed a microservices architecure using lambda, SQS , SNS and kafka. Main feature delivered was "conferencia"(conference) is a module where all the microservices focus on the main validations for Exchange. .

Software Engineer Artificial Intelligence - Accenture

august 2019 - April 2021

- Development of APIs using Node.js and python
- Development of softwares and applications using Node.js and python
-Developed an integrated solution of a chatbot for a Brazilian Bank. -Developed a solution for unit tests.
-Developed analysis based on the chatbot conversation, created a dashboard using ELK (Elasticsearch, Kibana and Logstash).
-Developed an dashboard platform for an ominchanel solution with reporting features using node.js, angular and mongoDB.
-Developed chatbot solution to help bars buy easily stock with the help of a virtual assistant using node js, Luis , azure,bot framework with graphql.
-Worked on version migration of hadoop server.
-developed apis and pipelines to publish data from mines using Python,flask and sql server.

PM/BI Intern - Amazon

March 2018 - august 2019

- Responsible for Model data and metadata to support ad-hoc and pre-built reporting.
- Responsible for design, development, and maintenance of ongoing metrics, reports, analyses, dashboards, etc. to drive key business decisions. Tax Classification (GTS-Global Trade Services)
- Helped re-invent the new process for the tax classification products.
- Simplified the process, and merged the database used to query key metrics, making it faster and easier to pull data and insights.
- Extracted data for analysis and crated reports based in project needs, as well as in the product audit process at Amazon.com.br.
- Created relevant reports such as VLT (Vendor Lead-Time), and a summary of the process as a whole which is used in our MBR.

- Responsible for reports used in the BR Marketplace WBR (Seller Performance, Selection, New Sellers e Price Competitiveness).
- Created a dashboard with key metrics to help New Account Managers track their seller’s performance.
- Created a single Marketing dashboard used in the BR Marketing WBR (Manual Outbound, Browse Node Performance, Gateway Share of Voice).

BI Engineer/Project Intern - Banco Safra

Janruary 2017 - March 2018

- Responsible for tables creation using data modeling concepts, and for managing the databases into the DW.
- Created and owned ETL processes that loaded data into Data-Warehouse, scheduling and supporting these processes:
- Accounts Project: used to calculate variable compensation of the Sales team.
- Exchange Project: This process utilized data form the systems in the bank. It would load data extracted from the system and calculate the investments in this product.
- Imobiliario (real estate found): This process was based on data from the real state found team they will share their data with me, and my process would calculate investments in this product.

Education

FATEC (Technology College of Sao Paulo)

bachelor’s in system Analysis and Development (2015-2019)

ETEC Guaianazes (Technical School of Sao Paulo Guaianazes Campus)

Computer Science (2011-2012)