Cleber Marcelo S. Machado

PMWEB
August 2023 to July 2024

Data Analyst

After taking ten months off from work to study English, I returned to Pmweb and continued working as a data analyst. I analyze and create processes for campaigns containing thousands of records from Raízen Shell, one of the largest oil companies in Brazil. Additionally, I assist in structuring data for Chevrolet company campaigns across Latin America.

● Responsible for creating tables, jobs, and views in SQL Server, Oracle Responsys and Big Query, study, learn Adobe Campaign Platform for marketing campaigns.

● Conducted data loading or extraction and classification for precise audience segmentation, optimizing campaign targeting in SQL Server, Oracle Responsys and Big Query.

● Performed regular maintenance of tables, views, procedures, jobs and data in SQL Server and Big Query, and Oracle Responsys, ensuring reliability of information used for BI analysis.

● Utilized GIT for version control, handling code commits and managing project branches.

● Constantly monitored job processing, identified and resolved issues to ensure efficient task execution.

● Processed all ETL processes on the SQL Server and Responsys Platforms Jobs.

PMWEB
November 2021 to October 2022

Data Analyst

Pmweb is a technology company based in Porto Alegre, Brazil, that offers digital marketing solutions and customer relationship management. As an experienced data analyst, I played a pivotal role in the analysis and processing of data at Grupo Renner, one of Brazil's largest fashion companies, renowned for its brands including Lojas Renner, Camicado, and Youcom. My responsibilities encompassed a wide range of tasks, including gathering data from various sources, meticulously overseeing the processing of over 25 million records on a daily basis, and providing insightful interpretations of the data. These efforts aimed to empower the company in making well-informed managerial and strategic decisions, with a specific focus on marketing and optimizing business performance.

● Responsible for creating tables, jobs, and views in SQL Server, Oracle Responsys and Clickhouse, ensuring availability and integrity of data required for marketing campaigns.

● Conducted data loading or extraction and classification for precise audience segmentation, optimizing campaign targeting in SQL Server, Oracle Responsys and Salesforce Marketing Cloud.

● Performed regular maintenance of tables, views, procedures, jobs and data in SQL Server and Clickhouse DBMS, and Oracle Responsys, ensuring reliability of information used for BI analysis.

● Utilized GIT for version control, handling code commits and managing project branches.

● Constantly monitored job processing, identified and resolved issues to ensure efficient task execution.

● Processed and monitored over 25 million daily records in all ETL processes on the SQL Server.

Barigui Group
February 2018 to December 2020

IT Analyst

Barigui Group has more than 82 dealerships, with sales revenue of approximately 3 billion reais per year. I was working as DBA, SQL Developer and Developer C#, providing and implementing rules to strategic planning, business process design, enterprise performance management implementation, and execution support to 3 DMS(Dealership Management System).

● Centralized all data from accounting and finance area of Barigui Group to data warehouse on RDBMS SQL Server, using SQL Server, Oracle and IBM Informix databases as sources, with ETL process developed in C # / Visual Studio 2015.

● Structured ETL process for Data Lake over PostgreSQL RDBMS, using SQL Server, Oracle and IBM Informix databases as sources. ETL process performed in C # / Visual Studio Code.

● Responsible for analyzing failures and troubleshoot of DMS´s processes and procedures and gathering documentation to request corrections or apply the necessary changes by Stored Procedures or Update Patches.

● Responsible for generating the Group's financial report for the demonstration of legal and financial information for demonstration to COAF(‘Financial Activities Control Council’ is a Brazilian administrative body).

● Others activities in SQL Server: Installation, linked servers, backup/restores, tuning, creation of roles, rules and objects, bulk data import and export.

Help Informatica
August 2015 to February 2018

IT Analyst

As an outsourcer in the MR Informátika data center and solutions, I was working as IT Analyst, providing implementation, management, performance monitoring and giving support in NBS Dealership Management, System for more than 25 Chevrolet dealerships, all over Brazil.

● Responsible for analyzing failures of DMS processes and procedures and gathering documentation to request corrections or apply the necessary changes via Stored Procedures or Update Patches.

● Responsible for ensuring the availability of internet links, monitoring and applying the Pfsense settings for Firewall and VPN, and applying access permissions to systems, directories and system files to users.

● Structure and monitor backup and restore processes, replication and performance of servers and databases.

IMTEP
March 2014 to May 2015

Purchasing Coordinator

● Procurement of medicines, medical materials, and equipment.

● Procurement of work safety equipment and PPE.

● Procurement of furniture, various equipment, and supplies.

● Management and leasing of properties and containers.

● Facility maintenance services.

● Land and air mobile service provision.

● Outsourced fleet management.

● In-house fleet administration.

● Key user for process design and creation of manuals for Protheus ERP implementation.

Ampla Digital
August 2012 to March 2014

IT Analyst

Ampla Digital is a Brazilian manufacturer of large format digital printers, one of the leading companies in Latin America in the segment. I was working as IT Analyst, performing activities of DBA and Developer.

● Manage SQL Server databases, monitoring the performance and applying tuning implementing backup and restores routines, using T-SQL to keep or create stored procedures to adjust the company's business rules or to create of management reports.

● Development of warranty management module and reports using in Delphi and Crystal Reports.

● Maintenance of ERP modules in VB and Crystal Reports using Visual Studio 2010.

● Others activities in SQL Server: Installation, configuration, backup/restores, tuning, and creation of roles, rules and objects.

Copan – Cooperativa Paranaense dos Anestesiologistas
July 2002 to July 2012

IT Coordinator

● Manage SQL Server databases, implementing backup and restore routines.

● Using T-SQL to keep or create stored procedures to adjust the company's business rules or to create of management reports.

● Monitor, configure and maintain health and performance (Tuning) of database servers and processes.

● Ensure high levels of performance, availability, sustainability and security.

● Analyze, solve, and correct issues in real time.

● Perform troubleshooting, repairs and data restoration (Disaster Recovery).

● Creation of financial management module, accounts payable and electronic collection (Delphi / SQL Server 2000).

● Analysis of operational needs that resulted in a significant reduction in payment processing time for Copan's members (up to 20 days for 4 hours).

CCV – Comercial Curitibana de Veículos
February 2000 to July 2002

Computer Technician

● Provide the backup routines and test restores.

● Perform constructions in T-SQL for the creation of management reports.

● Maintain and update data and system of the Maxinvest bank, belonging to the CCV Group.

● Development of intranet in Asp Classic.

● Created management reports and performance statements for the Board.

● Train Staff on use of computer systems.