Canon USA

Senior Business Intelligence Analyst

Apr 2024 - Current

• Performed A/B tests in the companies e-commerce website, creating visual experiences (using HTML, CSS and Javascript) as well as collecting the necessary data to analyze such tests. Then, created significance reports to facilitate understanding of how A/B tests performed
• Aided personalization strategy, providing technological and data perspectives to marketing in the pursuit of better experience for individual users
• Developed ETL strategies and best-practices for a variety of pipelines, including: web behavior (usign GA4 extracts), CRM (for email tools) and market analysis (scraping vendor websites and/or using API endpoints)
• Engineered a Machine Learning model to recommend content (articles and videos) based on content similarity and user behavior
• Optimized existing dashboard to better serve business teams, improving timing and cost to maintain data updated and providing timely insigths

Business Intelligence Specialist

Dec 2021 - Mar 2024

• Tailored a variety of dashboards to marketing, sales and product teams that provided insight on topics including, but not restricted to: customer website behavior, revenue and competitor analysis
• Reverse-engineered SQL logic created by third-party service provider to produce dashboards. Effort led to, alongside increased productivity, accuracy and process optimization, the elimination of a seven figure annual contract
• Tuned a Large Language Model utilizing historical articles and videos produced internally to facilitate the creation of brand new articles
• Supported development of A/B tests on Canon's website to better understand customer behavior, with the intent to fuel one-to-one personalization strategies. Also developed a dashboard to track the performance of said tests, including an embedded statistical significance calculator to better identify superior experiences
• Developed sentiment analysis model using python (using NLTK, SKLearn, Gensim for modeling and GloVe and BERT for embeddings) to better understand and categorize online reviews of Canon products. The results allowed sales personnel to improve overall product ratings on 3rd party vendor websites and better respond customers with product-related issues
• Designed processes in python to automate repetitive tasks that saved employee hours, that included: download of invoices from source websites, data manipulation from various sources, file creation from data sources and others
• Launched a Django-based website to facilitate the management, distribution and execution of python scripts and data dashboards used by non-data personnel
• Improved data engineering process to audit BigQuery database, saving 2 hours/day and 10% of the BigQuery budget when compared to the prior process
• Managed database for Instant Rebate project, ensuring Project Management team has the correct products, lines and credit amount

Business Intelligence Analyst Associate

Feb 2020 - Dec 2021

• Scripted Python processes that gathered, downloaded, cleaned, stored and analyzed data from multiple sources to support further audit and analysis
• Managed the team's Tableau Server, performing upgrades (both for security and improvement), shared new capabilities that became available with new versions and provided insight on new trends on the data visualization world
• Created risk-based sample selection processes that allow auditors to pick samples from multiple tests, eliminating the risk of human error and the hours necessary to make manual selection
• Developed RPA bots, with and without user interface, to optimize the work of various departments, automating processes of low or zero ROI, increasing productivity, like document gathering, amount matching and data cleaning
• Designed a variety of dashboards utilizing many of Tableau’s capabilities, including, but not limited to, maps of office locations, process flow, risk assessment and many others, with the purpose of creatively sharing information and analysis with our internal customers
• Deployed the capacity of hosting data sources and data flows in Tableau Server allowing the department to streamline the data refreshes and avoid unnecessary employee touches in the data and dashboards, delivering our final product quicker and with less errors
• Shared the knowledge from the team in the US with the Brazilian counterpart by utilizing my capacity of speaking Portuguese and the advanced knowledge in Tableau
• Improved governance processes by creating a coding hub for projects developed in many coding/scripting languages used in the department and a Tableau dashboard to visually demonstrate our capabilities and allow internals and externals knowledge to be shared with the entire team
• Prepared various processes to ensure departments are compliant to SOX (Sarbanes-Oxley Act) through manual and automated controls on behalf of Canon’s external auditors
• Predicted expected payments to be done by the company in the next 30, 60, 90 and 120 days in order to allow decision-makers to follow a data driven method of investment

1-800-Flowers.com

Business Intelligence Intern

Apr 2019 - Dec 2019

• Generated weekly dashboards for visual presentations, summarizing data analysis
• Created a classification model, in order to better understand how users access the products from the company
• Automated data gathering and cleaning processes to spare time for deeper data analysis