Debora Fernandes Email & Phone Number

Rio De Janeiro, Rj, Br

Responsible for creating and optimizing complex SQL queries to ensure precision and efficiency in data analysis. By interpreting analysis results, I provide clear and actionable insights that help the organization understand its activities. I prioritize stakeholder requests for specific data analyses, develop customized analytical solutions, and facilitate data-driven decision-making. I communicate insights clearly to both technical and non-technical teams and design and implement interactive dashboards in Power BI for continuous monitoring of key metrics and KPIs. I also regularly maintain and update these dashboards to reflect changes in data and business needs.Technologies used: SQL Server, Power BI, Excel

At AgileEngine, I developed and enhanced SQL queries in Snowflake to extract data efficiently and accurately from large volumes of information. I collaborated with data engineering teams to create robust and scalable analytical solutions. I designed and developed interactive dashboards in Tableau to deliver clear and impactful data visualizations. My role involved integrating data from multiple sources and applying best practices in visualization to facilitate the understanding and analysis of complex information. I provided analytical support to internal and external clients by addressing specific requests and offering data-based solutions. I effectively communicated insights and recommendations to aid clients in making informed and strategic decisions.Technologies used: Snowflake, Tableau, SQL

At PSafe, I developed and maintained the company's internal dashboard, ensuring the integration and functionality of both Front-End (Angular) and Back-End (Node.js). Created Python scripts for automated data extraction from various APIs and loaded the extracted data into the Data Lake (AWS S3) for subsequent transformation and analysis. Daily worked on Hive for data treatment and organization into different layers (Bronze, Silver, and Gold). Use of Sqoop to transfer processed data to MariaDB, ensuring data integrity and accessibility. Development of tables and procedures in MariaDB to transform raw data into relational tables, optimized for detailed reporting and analysis. I maintained data pipelines using AWS Data Pipeline and developed serverless functions with AWS Lambda for real-time data processing. I orchestrated workflows with AWS Step Functions to ensure orderly and efficient task execution.Technologies used: AWS, SQL, Hive, MariaDB, Node, Angular, Python

Rio De Janeiro Area, Brazil

• Daily routine using relational(MySQL) and non relational databases(Hive) to analyze data providing insights to decision making;• Development of python scripts to gather data from different APIs such as Google Ads, Mopub, Criteo, Google play and add those files into AWS S3 for further treatment and analysis;• Working with Node.js to create and do maintenance on internal dashboards;• Experience on AWS environment using features such as Lambda, CloudWatch, Data Pipeline, Emr and etc;

Rio De Janeiro Area, Brazil

• Working into a big player in telecommunications sector in Brazil, succeeded on automate manual processes performed daily using SQL;• Account Reconciliation gathering data from different systems that doesn’t connect with each other using queries. After the work of extract data, the process was to re-conciliate and create a new system that was loaded with all analyzed data;• Basic use of R to read data from pdf’s to identify if the file is reasonable to use or not;

Rio De Janeiro Area, Brazil

• Worked in the team responsible for creating loads into SAP AA and PM modules related to reconciliation of reversionary property in compliance to regulatory requirements;• Development and maintenance of SQL Server scripts;

Rio De Janeiro Area, Brazil

• Acting inside a Telecommunication Client working on a daily basis doing the Accounting Reconciliation making use of ACL software to create scripts that were used to Reconciliate data from different types of system;• Working with SQL Server to implement automatic validation of data regarding other types of internal reconciliation.

BT/IT Student

Graduate Degree In Big Data, Big Data

Bachelor'S Degree, Systems Information

Systems Information, This College Went To Bankruptcy In 2013