Amanda Tassi Email & Phone Number

Montreal, Quebec, Canada

- Looker Implementation and Model Development: Developed and implemented a comprehensive data model in Looker, transforming business needs into efficient data solutions. Created dimensions and metrics to establish a robust business layer between raw data and visualization, facilitating the creation of comprehensive reports and dashboards. Contributed to the governance structure, ensuring proper user access to data.- Dashboard Redesign and Optimization: Redesigned and optimized dashboards, leveraging advanced data visualization tools. Enhanced performance and user experience, empowering and facilitating EPOC clients to access and utilize these dashboards seamlessly for informed, data-driven decision-making.- Database Migration and Optimization: Actively collaborated in migrating from a MySQL database to Big Query. Utilized Google Cloud resources to create and optimize the company's data lake structure, enhancing data storage and retrieval efficiency.- Data Security and Insights: Ensured the effective and secure use of data by providing valuable insights that supported the organization's operations and strategic decisions. Implemented best practices to maintain data integrity and confidentiality.- Data Validation and Quality Control: Performed data validation and quality control checks to ensure the accuracy and reliability of data, supporting high standards of data integrity.

- Data Collection and Analysis: Collected, processed, and analyzed large datasets from various sources to derive actionable insights, enhancing data-driven decision-making.- Database and ETL Development: Developed and maintained databases, data systems, and ETL scripts in Python to automate data extraction, transformation, and loading processes, ensuring efficient data integration.- Trend Analysis and Reporting: Identified, analyzed, and interpreted trends and patterns in complex data sets, creating comprehensive data reports, visualizations, and dashboards to communicate findings to stakeholders.- Stakeholder Collaboration: Collaborated with cross-functional teams and stakeholders to understand their data needs, develop tailored reports, and provide actionable insights aligned with organizational goals.- Dashboard and KPI Optimization: Optimized dashboards and reports with key metrics, KPIs, and data visualizations, improving decision-making and increasing reporting efficiency.- Data Lake Management: Contributed to the creation and maintenance of a data lake structure on AWS, ensuring scalability, efficiency, and adherence to data governance and management policies.- Data Validation and Quality Control: Performed data validation and quality control checks to ensure the accuracy and reliability of data, supporting high standards of data integrity.- Data Aggregation: Aggregated data from multiple sources, eliminating manual work and streamlining data collection systems to optimize statistical efficiency and data quality.- Cost Reduction Report: Created a detailed report that led to a 50% cost reduction for a specific product account on AWS, demonstrating the impact of data analysis on cost-saving initiatives.

- Data Preparation: Collected, cleaned, transformed, and manipulated data, ensuring data quality by removing extraneous data, filling in missing values, conforming data to standardized patterns, and validating the results.- Report Creation: Created comprehensive reports to present data insights to clients, enabling them to make informed decisions based on accurate and well-structured information.- Tool Utilization: Utilized ORACLE database, SQL/PL-SQL, and Excel to execute data preparation and reporting tasks efficiently. These tools were essential in handling large datasets and performing complex data operations.

São Paulo, Brasil

- Executed all processes that a real estate valuation requires. Collected data from real estates available at the market, applied statistical methodologies to calculate the market valuation to the real estate and prepared reports to present to clients.

Bacharelado, Civil Engineering

Técnica Em Edificações, Civil Engineering

High School Diploma