John Victor Email & Phone Number

State Of São Paulo, Brazil

São Paulo, São Paulo, Brasil

São Paulo, São Paulo, Brasil

Currently, I work in the "Canais Assistidos" squad, responsible for developing payment screens in agencies. In my daily life, I carry out the following activities:I carry out studies and analyses to improve our channels (example: complaints analysis), value projects, and provide volumetric data.I develop dashboards in Amazon QuickSight, creating detailed visualizations to support decision making.I build and maintain ETL flows using Python and AWS Glue with PySpark, ensuring… Show more Currently, I work in the "Canais Assistidos" squad, responsible for developing payment screens in agencies. In my daily life, I carry out the following activities:I carry out studies and analyses to improve our channels (example: complaints analysis), value projects, and provide volumetric data.I develop dashboards in Amazon QuickSight, creating detailed visualizations to support decision making.I build and maintain ETL flows using Python and AWS Glue with PySpark, ensuring efficiency and data integrity.I develop Machine Learning models, such as K-Means on Amazon Sage Maker for complaints analysis, segmentation, grouping, and data analysis.I perform data analysis using AWS Athena through SQL queries and build pipelines with AWS services such as EventBridge, S3, AWS Glue, Athena, and Step Functions.I work with BIG Data, analyzing databases in a Hadoop environment and building ETL (Map Reduce) flows with distributed processing using PySpark.I implement versioning of ETLs with Git and participate in the implementation of tagging on micro front-ends using TypeScript and Angular.I extract data from the Data Mesh, Lake, Mart architecture through SQL queries and API requests to build the analysis's dataset (SOT and SPEC layers). Show less

São Bernardo Do Campo, São Paulo, Brazil

I work on developing process automation, KPIs, and indicators to optimize logistics operations. My experience encompasses robust KPI structure design, information extraction through web scraping and API consumption, as well as efficient management of Data Warehouse (relational databases). I implement automated solutions, such as RPAs, to enhance processes, creating applications and scripts for SAP automation and updated reports.Additionally, I develop ETL for various processes and… Show more I work on developing process automation, KPIs, and indicators to optimize logistics operations. My experience encompasses robust KPI structure design, information extraction through web scraping and API consumption, as well as efficient management of Data Warehouse (relational databases). I implement automated solutions, such as RPAs, to enhance processes, creating applications and scripts for SAP automation and updated reports.Additionally, I develop ETL for various processes and projects, applying concepts like data lake and data warehouse. I have experience using various programming languages, including Python, VBA, C#, VBS, SQL, and JavaScript. Additionally, I am skilled in automation tools such as UiPath and Power Automate, and I can develop applications using Microsoft Power Apps. I also gained experience in code versioning via Git through GitLab. I performed the creation and management of all automation logs and utilized Microsoft Azure Cloud Services. Show less

São Paulo, São Paulo, Brasil

As the founder of Pit Impots, an online clothing store, I was responsible for digital marketing, including ads and paid traffic, partnerships with digital influencers, and creating visual content such as flyers, logos, videos, and reels. I managed product imports from the USA and China, implemented pricing strategies and promotions, and organized logistics for deliveries in São Paulo and shipments via postal services and Uber Moto.

Tecnólogo Em Análise E Desenvolvimento De Sistemas, Information Technology

Cursando o 3º Semestre de Análise e Desenvolvimento de Sistemas na Fatec. (trancado)

Bacharelado Em Engenharia Da Computação, Information Technology

Cursando o 4° Semestre de Engenharia da Computação na USJT.

Curso Técnico Integrado, Integrated High School Technician In Industrial Automation, Industrial Automation Systems

During the course I developed skills involving electricity, electronics, robotics, mechatronics, workplace safety, and teamwork. I.