Andre Pereira da Silva

DataBase Specialist/ Data engineer Specialist

Greater São Paulo Area

About

- 17 years of experience in small, medium and large companies in the IT area, acting as operator, programmer analyst and database administrator; - Knowledge in Structured Analysis and UML, Development and Implementation of Client / Server systems, training and support to users, ERP (Dynamics, Myyork, Oracle ERP) and CRM (SalesForce and Dynamics), SCRUM, TDD, XP; - Knowledge in Case Erwin Tools, Geocase, Data Modeler; - Experience in MySql Database, MS SQL Server 2000/2005/2008 (Administration / Programming Transaction SQL), Oracle 10 and 11 (Administration / Programming PL / SQL), Access, Paradox, Dbase; - Programming language C #, VB .Net, Asp .Net, Asp, Java, Visual Basic 6, VBA, Delphi and Clipper, ApexCode, PL / SQL and Transaction sql; Framework 1.1, 2.0, 3.0, 3.5, 4.0 and 4.5; - Experience with AWS RDS, Kinesis, ElasticSerach, ElasticCache, Redshift, EC2, Route53 and Lambda. - Experience in Windows and Linux operating systems; - Advanced knowledge in ESRI Software Geoprocessing software (ArcGIS and ArcSDE).

Experience

  • Lead Data Analyst at Aleo Brasil
    Nov 2021 - Present · 4 yrs 9 mos

    - Disseminate knowledge and practices Cloud AWS technical and business area; - Propose improvements or new technologies in DataLake processes ; - Backlog mapping and negotiation between areas and suggesting new solutions using Data Science ; - Synchronization between the teams that are in the structuring or within the areas; - Propose and identify technical needs;

  • Data Specialist / Data Engineer at Zup Inovattion
    Nov 2020 - Nov 2021 · 1 yr 1 mo

    - Create Architeture for Data Pipeline for Kafka AWS; - Automation Proccess Ingestion Private Cloud Kubernets and Python; - Performance and Tunning Sql Server DataWarehouse; - Project Migrate Hadoop Cloud Private to Cloud Public AWS.

  • Data Manager at Marketup
    Jul 2020 - Nov 2020 · 5 mos

    - DataBase Migrate Sql Server to Aurora/ Postgresql - Start Project Migrate Data to DataLake; - Automantion Extractation e Send Data using Python.

  • Data Engineer Specialist at Yandeh
    Jan 2020 - Jul 2020 · 7 mos

    - Create , Migrate and Manager Data Pipeline Data Lake Aws - Design Architeture solution Aws Pipelie - Implementation CI/CD with Python ECS - Dynamo Stream with Lambda generate data for DataLake

  • Tech Lead Data / DataBase Specialist at Wappa Táxi
    Nov 2015 - Jan 2020 · 4 yrs 3 mos

    Administration, Tuning and Restructuring of Oracle Database, Sql Server, Mysql, Redis, RedShift, Aurora (Mysql and PostGree), MongoDB, Kinesis Stream / Firehose. Architecture, Analysis and Development and performace of the code in .Net to make the current scalable structure. Development in C # and Python. Study and migration test from Oracle to Aurora (Mysql 5.6 enterprise). Implantation of ElasticSearch for log and base analysis for DashBoard. Creating and processing data for Data Warehouse on AWS Redshift. Creating and configuring AWS Kinesis integrating with AWS Firehose with python script sending to Redshift and ElasticSearch doing treatment. Study and implementation of data processing of Kinesis using Spark with python.