Vagner Amaral

I created the logic behind the solution as well as the integration between the data source (a Google Sheets file) and Google Data Studio (GDS) so that our client could have the visibility and transparency necessary to track the expected results by the solutions that were being delivered to their clients.

I designed the data visualization and the logic behind the data source (a Google Sheets file), which had an automation script developed to ensure we would get the most recent data directly from the client's Jira API. With that, we could generate a daily 'snapshot' of the current sprint's progress for each team, and have that snapshot sent by email to all interested stakeholders to keep them updated about the team's progress and sprint performance.

I structured the data source (a Google Sheets file). I created the logic, formulas, and custom calculations needed to generate shared metrics dashboards where we could analyze each team's performance and metrics and make data-driven decisions on improving the team's deliveries and processes efficiency by making the workflow steps bottlenecks and queues visible—allowing us to manage the flow more efficiently.

I created this framework to help me guide companies and organizations and accelerate the formation of new teams, areas, business units, and departments, starting from their purpose and objectives and going all the way down to their workflows and value streams. The initial classes of services would be based on the context of each team's needs.

I created an artifact that helped teams, departments, and managers address the subjectivity and ambiguity related to the prioritization process and criteria used by the company at the time, and which used to create extremely long discussions and a lot of confusion among teams and stakeholders, generating a lot of frustration and a feeling of "time wasted" during the meetings. After implementing the Prioritization Matrix as an "official/standard" artifact to guide the discussions and organize the list of proposed solutions in the "right" order, the main problems and constraints related to the process were either addressed or completely resolved.

I improved the visibility of a client's strategic objectives and its key results/goals (OKRs) by creating an automated report in Google Data Studio so that everyone in the company would have access to follow the company's progress related to its defined and shared objectives. The solution considerably increased the organization's transparency and, consequently, employees'/collaborators' engagement, ownership, and accountability.