Eduardo Meira Email & Phone Number

Curitiba, Paraná, Brasil

Allocated to client AB-Inbev.Project - BrewGen:Operating on a new global system for managing world-class agricultural research programs, which includes fully integrated data storage, to facilitate and optimize variety development for malting and brewing.​Applied technologies:- Azure SQL- Azure Data Lake Storage- Azure Databricks- Azure Data Factory- Azure Functions Serverless- Python with Pandas and PySpark- PowerBIMain activities:Organization of the lakehouse, preparation of bronze, silver and gold layers, cleaning and optimization of processing, automation of synchronizations with data factory and serverless functions, 90% reduction in time and costs in the cloud with intelligent processing that identifies changed data by processing only what you need, delivering reliable data to generate insights in PowerBI for decision making by management and directories.Modeling a new database for managing global seed stocks, being able to edit quality, transfer seeds between programs, reset stock positions, merge and split seed bags.

Curitiba, Paraná

Allocated in the Michelin Group company - SascarProject - Smart ReportsBI reports built into the system with indicators and dashboards for predictive analysis in order to reduce costs and prevent accidents in customer fleets. It is also possible to analyze the wear of vehicle components and drivers' driving notes.Applied technologies:Modeling and implementation of Data Warehouse for BigData in the Cloud Azure environment using the dedicated Synapse Analytics pool with data integration within Workspace Studio in 3 environments, More than 20 million monthly data packages in production integrated with PowerBI Premium.EventHub configuration for position packages, Stream Analytics for real-time processing and analysis, Datalake Storage for storage following patterns in containers for each type of data.API development with Serverless Functions in Python with CosmosDB.Configuration of logs, jobs and alerts using EventGrid event-driven architecture in the Cloud Azure environment.Configuring pipelines for publishing automation via GIT Azure DevOps (Continuous Integration and Continous Delivery) between environments using best practices recommended by Microsoft.Documentation of flows, pipelines and data catalog.Project - Resolution of areas and points of interest in real timeShow on the map system in which areas or points registered by customers the vehicles are in real time for each position. There are more than 100 million positions per day.Applied technologies:Installation and configuration of MongoDB distributed on 9 machines with high availability Shards, ConfigServers and ReplicaSets for real-time analysis solutions capable of receiving multiple microservice requests.Router configuration for failover.Other technologies:Procedures, triggers, functions, views in PostgreSql, Oracle, Redshift and Sql Server databases.Qlik SenseLib Pandas and FlaskPentaho Data Integration

Curitiba

Installation, configuration, maintenance and upgrade of SQL Server 2008-2016 in at least 5 environments with bases larger than 500GB;Configuration of backups (full, diff and log) in at least 150 databases;Maintenance of procedures, cursors, functions, views and triggers;ETL, data import and transformation using SSIS (Oracle, MySql, Firebird, txt);Maintenance of indexes and statistics, rebuild, reorganize;Configuration of error email alerts on instances;Backup/Recovery configuration, database mail, mirror, CDC;Profiles and accesses to the DB, linked server, auditing, reading error logs;Table and index partitioning, modeling and standardization;Profiler, activity monitor, query performance analysis and execution plan optimization;Reading DMVs to identify deadlocks, cpu consumption, missing and unused indexes;DW modeling, dashboards and KPIs configuration using QlikView and Qlik Sense;Installation of Qlik Sense Server, configuration of user directory connector to authenticate logins from other systems, configuration of streams, schedules and profiles.Good experience with programming in Java Desktop, MySql and Power BI.

Curitiba, Paraná, Brasil

Company in the field of Call Center.Maintenance in high availability MySql Servers with more than 10 million numbers of clients, being 98.9% of the time available;Scripts in MySql and Php to import FEBRABAN files to dispute invoices;MYSQL replication, triggers for logging and control;Query optimization, analysis of unused indexes, partitioning of tables and indexes;Project with improvements in tables, indexes, reducing the server cost by 90%;BI reports with QlikView, with dashboards, sales evolution and indicators;BI reports using EXCEL 2010 + PowerPivot + Microsoft SQL Server 2008;Installation, configuration, backups, database mail from SQL 2008 to ERP PROTHEUS;Creation of software in JAVA for monitoring network servers and database;Shell Script development for MySql Backups on Debian server;File sharing and SAMBA configuration for copying backups over the network.

Curitiba, Paraná

Supervision and coordination of the support team; Weekly meetings to check improvements, problems, solutions; Specific training for employees when necessary; Weekly employee qualification reports.Distribution of internal processes to the responsible technician; Creation of technical knowledge with scripts and steps for everyone to consult and learn; Support for external technicians, sending errors and pending issues to the test analyst; Organization and distribution of service for calls in the support email; Guidance in answering the phone and internal processes; Meetings with clients and group organization;

Maintenance in MSSQL 2000/2005 database; mdb, dbf, xls, SQL Server and Firebird database conversions; Customer support via remote assistance, VNC, LogMeIn, TeamViewer and telephone; System training for external customers; Configurations of fiscal printers and label printers; Installation and configuration of software for clients; Configuration of replication of customer data with branches (Merge and Snapshot);

Curitiba, Paraná, Brazil

User service guided by the intranet system, updates and images (Ghosts) for PCs, assembly of RJ45 cables, maintenance of LexMark, Samsung, Brother, HP, multifunctional and laser printers, etc. Internal software development in Java with Oracle to control asset movements, Data Warehouse in Excel, data recovery, backups, TCP/IP and Proxy configurations, DHCP, user service via VNC remote assistance, PC assembly, software installations and hardware, troubleshooting, script development, performance settings for Windows XP, and other industry needs.

Curitiba, Paraná, Brazil

Customer service, explanations about some Windows programs (Word, Excel, PowerPoint), network and Wireless settings, Proxy configuration, laboratory organization, weekly reports of problems during the event, possible solutions.