Vitor C.

DRB Consulting is a Brazilian consulting company focused on increasing retailer sales by applying the category management concept.

• Part-time work in the coordination and execution of the business intelligence process: loading, data transformation, maintenance, and creation of reports for the PGFarma product offered by DRB Consulting

• Programming complex data models and visualization using Power Query M and DAX languages, training, and follow-up of interns and colleagues in the business intelligence area

• Communication with the database technical team for data model alignment and with consultants and stakeholders (CEO) for business rules understanding

• Communication with backend and frontend development team for data model alignment.

• Data consumption via several database engines of pharmacy ERP systems through data flow and data mart in PowerBI service.

NTT DATA is a top 10 global IT services provider, headquartered in Tokyo, with over 190,000 employees and operating in 57 countries. The client for this position is the Inter-American Development Bank.

• Developing visualization models in PowerBI, ingesting data stored in the Azure cloud environment using SQL Server and Azure Table Storage

• Communicating with stakeholders to understand business rules and report improvements in data projects

• Perform data quality analysis, communicate with backend and frontend developers to collaborate on insights, report bugs and improvements to promote a high-quality data environment

• Perform ad hoc analysis, reports, and presentations requested by stakeholders, execute data patches via SQL to fine-tune information in the operating information system

• Assist other professionals at different service levels in creating SQL and executing data patches to maintain data quality.

• Creation of a Python application to automate tasks such as conciliation of two databases, decreasing the analysis time from 8 hours to 1 hour.

Callink offers personalized value-added solutions in the call center and communications industry, with high-performance deliveries that always focus on your journey as a customer.

• Working on the Management Information System (MIS) team, providing data and information to telemarketing operations planning teams

• Acting in internal projects of idealization and redesign of reports to optimize and modernize the process of construction and documentation

• Bringing the reports closer to the business rules of the operation

• Acting in projects for external clients Bradesco and Mercado Pago.

Complastec Engineering specializes in high-performance thermoplastics, serving all industries and selling pipes, fittings, valves, centrifugal pumps, and diaphragm pumps, which can be used with highly corrosive chemicals.

• Coordination of financial, accounting/tax, purchasing, warehousing, HR and IT areas

• Implementation of financial management reports using the Pentaho Report Designer tool and Firebird database, financial and warehouse dashboards using the PowerBI tool and Firebird database, analysis and operation of accounts payable and accounts receivable

• Credit analysis

• Analysis of suppliers and partnerships, balance sheet analysis, income statement, the interface of the company's needs, and the board with the accounting office interface between the operation and the board.

• Project leader on behalf of the client in the implementation of the ERP Sankhya system

• Performing the interface between Sankhya consultants and Complastec teams and processes

• Leading the insertion of the data migration project between the legacy system and the new system and performing the maintenance of the information technology structure

AZShip is a Brazilian logistics and transportation company.

• The aim of the project was to build real-time updated dashboards for a logistics strategy company.

• Freelance development of the entire Business Intelligence process, consisting of problem understanding, project planning, data extraction, processing and loading, and visualization through the PowerBI tool.

• The objective of the project was to understand the use of the system by the clients of the platform and visualize alerts and usability indicators in real-time.

Expresso Nacional is one of the largest Brazilian cargo distribution and transportation companies.

• The aim of the project was the construction of real-time updated dashboards for a transportation company located in Uberlândia/MG

• Freelance development of the entire Business Intelligence process, consisting of understanding the problem, project planning, extraction, treatment and loading of data, and finally, visualization through the PowerBI tool

• The areas contemplated were fleet management, freight management of partner companies, finance, and HR.

DRB Consulting is a Brazilian consulting company focused on increasing retailer sales by applying the category management concept.

• Creating, planning, and maintaining Business Intelligence projects in PowerBI to aid operational visualization

• Assist in tracking the application of new strategies, visualize and analyze the history of various pharmacy clippings for pharmaceutical clients served by the consulting firm

• On-site assistance to local clients and clients from nearby cities

• Structuring and standardization of the business intelligence processes in the consultancy

• Orientation of consultants regarding the clients' Business Intelligence processes and operational aspects

• Performing analysis of purchase price, sales price, and profit margin of products according to the ABC curve and category studies

• Analysis of stock, stock-outs, service level, and purchasing models.

• Spreadsheet automation, database supply, and maintenance.

Xtrategie is a marktech that has been working since 2009 for the prosperity of people and organizations.

• First professional contact with the world of data

• Participating in different projects in different companies

• The activities performed were data processing (via R language, KNIME, Excel, MySQL, and CliquePerformance), database creation, feeding and maintenance, creation of MySQL queries and dashboards

• Data retrieval via REST APIs

• Cluster analysis through R and SPSS