Rafael Kawamura

At the Court of Justice of São Paulo, I developed a data mart to supply the KPIs demanded by the federal institution responsible for evaluating each state's performance. This was mainly to build a solution that bears the complexity of Brazil's legal system and yet allows users to have control in the definition of each metric (due to a high frequency with the change in definitions). I designed a dynamic ETL solution based on parameters that identify the categories of legal processes and the status in their workflow based on the judge's actions.

To enable the airline's best reaction to the COVID-19 pandemic, I've built the cancellation data mart, crossing multiple third-party applications that provide the critical information needed to minimize the impact on the revenue and reach the legal obligations on both customers service and transparency to stakeholders.

I have developed the ETL process and data mart that allowed the company to cross Google Analytics logs with its online sale data, delivering crucial information on programs' effectiveness and customer behavior.

The Apparel Company decided to terminate their SAS license agreement and requested that everything is migrated in three months. The task of migrating more than 1,000 SAS programs created by business users for daily reports was entrusted to me, although I had no previous experience with SAS. In a tight schedule, I've quickly learned how the code works in the SAS platform and delivered new data marts on a centralized data warehouse solution that allowed everything done on SAS to be reported by the business intelligence team.