Instituto Nordeste Cidadania
September 2016 - February 2022
OSCIP (Civil Society Organization of Public Interest) operationalized the BNB Agroamigo and Crediamigo microcredit programs. These programs facilitated the lending of over R$ 16 billion to 3.8 million active customers in 2021.
● Implemented an automated workflow utilizing Power Automate and Power BI to streamline the rendering of accounts. The implementation resulted in an impressive 80% reduction in task time, improving efficiency and productivity.
● Implemented an efficient ETL flow using Knime to consolidate and concatenate over 20 Excel spreadsheets into a centralized database. The streamlined process significantly reduced task time by 90%, enabling seamless data integration and enhancing the performance of the Power BI dashboard.
● Developed an impactful Power BI report enabling comprehensive weekly performance data analysis, pinpointing goal attainment, and guiding targeted actions for achieving weekly objectives, resulting in a remarkable 30% performance enhancement.
● Developed a Power BI report with Row-level security (RLS) implementation to track campaign costs and budgets, providing secure access for over 30 users while ensuring data analysis, accuracy, and confidentiality.
● Facilitated an extensive Power BI training program for a cohort of 60+ students, enhancing their proficiency in utilizing the tool effectively and optimizing its application throughout the organization.
● Implemented efficient process for meal voucher benefits rendering (R$ 1,8 million monthly), resulting in an impressive 80% reduction in execution time and a remarkable 96% decrease in errors.
● Developed an accurate rewards campaign check flow using Excel, consolidating over 30 sheets, resulting in 99% accuracy for a campaign worth R$ 1.4 million per semester, benefiting 5k+ employees.