Debora Regina Martins Caldas
New Westminster,BC
Summary
Process oriented data analyst with 9 years of experience. Experienced in creating and maintaining dashboards, analyzing data and managing ETL jobs, in order to help managers to make decisions and resolve problems, ensuring business growth and continuity. Complex problem-solver with analytical and driven mindset. Dedicated to achieving demanding development objectives according to tight schedules while producing impeccable code.
Overview
9
9
years of professional experience
Work History
BI & Analytics Lead
Rappi - RappiCard by Itaú
12.2021 - 05.2023
- Gave insights and analytics horizontally across different teams within Customer Lifecycle, such as Customer Onboarding, Marketing, Operations and Transactions
- Helped Jr BI Analysts to understand business and to develop best solutions for their LOBs, according to needs and data structure
- Served as mediator between Rappi and Itau teams, to better organize data transmission, according to needs, enhancing processes and ensuring data quality
- Used Power BI with DAX language to create different dashboards, delivering Business Intelligence for decision making
- Used Snowflake to create SQL codes and enhance ETL processes
- Used R to automate recurring tasks and to enhance data visualization through Power BI
- Worked in Sprints, using Scrum concepts to expedite projects
- Used Apache Airflow, Python and Microsoft Visual Studio to create pipelines to run scheduled ETL routines
- Used BitBucket to keep codes up to date
- Used Google Workspace Suite to create and maintain documents, spreadsheets and presentations
- Used Jira to manage tasks and coordinate efforts among team partners, always aiming to deliver great quality insights and visualization
- Used Trello to manage LOBs tasks
- Used Confluence to help organize and store team or business documentation and processes.
- Managed to increase profits by 15%, by suggesting changes in rules for approving customers from other countries. This suggestion came out after conducting a profitability study of such customers.
Senior Business Analyst Consultant
Evalueserve
05.2018 - 12.2021
- Used SQL, QlikView and Excel to update monthly and quarterly reports
- Used AWS EC2 server to store and process data
- Used SAS E-Guide to create a sniffing process on personal loan applications, to mitigate internal fraud and risks
- Used SAS E-Guide to manage and integrate data sources, creating recurring reports
- Used SAS E-Guide to create alerts about alleged frauds in personal loan applications
- Used R language to create clusters to categorize loan applications, aiming to detect fraud risky patterns
- Used R language to manipulate data, perform ad-hoc analyses and create visualization (ggplot and eCharts4R)
- Used Jira for project management and task assignment
- Used Tableau to create dashboards with business information.
- Updated and automated reports using SAS and Excel
- Responded to ad-hoc queries to provide information, timely, using SQL and Teradata
- Used R to analyze data and apply techniques, such as Clustering, Regression and Association Rules, delivering impactful analysis about consumer preferences
Business Intelligence Analyst
CELPA - Centrais Elétricas Do Pará
06.2014 - 04.2017
- Analyzed energy net data to discover patterns indicating current fraudulent customers
- Also participated in building new complex patterns based on decision trees to predict future fraudulent consumers
- Provided business indicators to assist managers and directors in decision making
- Used SAS Guide to automate ETL processes, gathering data from different data sources and treating it accordingly
- Built ETL processes using SAP Data Services, by extracting data from SAP Business Warehouse and SAP Hana Database, transforming and loading it to a local database (Oracle), using scheduled jobs to automate the whole process
- Built and maintained dashboards using SAP Business Objects, collecting data and delivering information to team superiors
- Developed and maintained procedures in Oracle 11g
- Also, worked on several ad-hoc queries to help upper management understand consumer behavior and dynamics about energy usage.
Education
Bachelor of Science - Computer Science
CESUPA (Centro Universitário Do Pará)
Belem, Brazil12.2013
Skills
- Data Analytics and Management
- Pipeline creation and management: Apache Airflow, SAP Data Services, Python, Visual Studio
- Data analysis and visualization: R
- Statistical modelling and Machine Learning: R, Python
- Business Intelligence: Power BI (DAX language), Tableau, SAP BO, Cognos
- Data manipulation: Python, R
- SQL
- PL/SQL and Oracle
- SAS Enterprise Guide and SAS Miner
- Snowflake
- Microsoft Office Suite
- Google Suite and others
Timeline
BI & Analytics Lead
Rappi - RappiCard by Itaú
12.2021 - 05.2023
Senior Business Analyst Consultant
Evalueserve
05.2018 - 12.2021
Business Intelligence Analyst
CELPA - Centrais Elétricas Do Pará
06.2014 - 04.2017
Bachelor of Science - Computer Science
CESUPA (Centro Universitário Do Pará)
Similar Profiles
Avnish VishwakarmaAvnish Vishwakarma
Lead Machine Learning Engineering at RappiLead Machine Learning Engineering at Rappi
ANA MARIA QUIROGA MATIZANA MARIA QUIROGA MATIZ
Global HRBP - Merchants at RappiGlobal HRBP - Merchants at Rappi
Sebastian Echeverry ClavijoSebastian Echeverry Clavijo
Financial Planning Manager at RappiFinancial Planning Manager at Rappi