João Megale Email & Phone Number

Rio De Janeiro, Rj, Br

Rio De Janeiro, Brasil

Rio De Janeiro, Brazil

Towards my goals of pursuing a career in data and technology, I had the opportunity to start from scratch in the applications and automation area, under the LTV management, Pricing and Campaigns Directorate.• Implementation of a discount model developed with Bain & Company, entry for application developed in powerapps.• Creation of PowerApps Applications using SQL instance on the azure and Power Automate. (SQL Server/Oracle - MSP)• Creation of power bi for applications and KPI's inherent to the business. (Power BI - SQL oracle)• Creation and maintenance of server schedules and datapipelines. (Python - Pentaho - Server - Prompt)• Elaboration and management of Average Ticket, Discounts and Revenue KPIs for business areas. (Python - SQL)• Knowledge about azure cloud, and maintenance of data models developed by consultancies.• Creation and maintenance of datapipelines using Python and Modeler SPSS.• Alignment of demands and solutions with the customer areas.

Rio De Janeiro, Brazil

Challenge accepted in the middle of a pandemic, we needed to keep students studying so that there is a healthy balance between revenue and discount.• Campaign generation using methodology developed in conjunction with visagio consultancy. (Modeler SPSS - SQL - Power BI)• Use of Agile Kanban Methodology.• Creation of the retention simulator. (Python, Cloud AWS, PHP)• Automation of flows integrated with system databases online. (Modeler SPSS - SQL)• Analysis of evasion and targeting the solution (Excel - Intelligence)• Data Modeling.

Rio De Janeiro E Região, Brazil

Invitation made after presenting good reports on the area of ​​partnership contracts, seeking to apply my business and technical knowledge to prepare more comprehensive reports, on student base, dropout, document compliance, among others.• Creating/Updating Reports.(Power BI and SQL)• Datamining from different sources using IBM Modeler SPSS.• Extraction and treatment of databases for the area.(IBM Modeler SPSS - SQL)• Generate databases to support the operation of the centers in order to visualize the leads daily.(IBM Modeler SPSS - SQL)• Interface with the Expansions/Contracts/Operations area in order to be the Pivot of the generated information.• Demands Spots for reports for other areas.(IBM Modeler SPSS - SQL)

Rio De Janeiro E Região, Brazil

• Performance reports (Power BI);• Preparation of management reports and dashboard's (Power BI - SQL);• Interface with the business areas;• Implementation of the area's DMS.

Rio De Janeiro, Brazil

Shared Services Center• Supporting the academic operation of more than 500 campuses/poles throughout Brazil.• Plan, control and operationalize processes for each campus.• Management of the course portfolio as specified by the market team.• Assistance to Estácio's employees in order to ensure that the guidelines are complied with internal.• Preparation of automated spreadsheets.• Periodic reports.Improvements:• Implementation of process automation, using AutoIT (https://www.autoitscript.com/).

Rio De Janeiro, Brazil

• Creation, together with the IT team, of the Robot for sending messages via Whatsapp, using AutoIT (https://www.autoitscript.com/).

Postgraduate, Software Engineering

Mba, Business Management

Mba, Business Intelligence

Bachelor'S Degree, Production Engineering

Mba Jr., Business School