Saimon

Led the SQL Server to Oracle database migration project, ensuring the autonomy and continuity of the database management process through the creation of documentation.

• Mapped the data transformation and integration process of the current SQL Server database to enable migration to Oracle
• Created documentation to give transparency to the workflow between the IT and Go-To-Market areas
• Data Definition, Manipulation, Query, and Transaction on SQL Server

Led the creation of a collection of data-driven processes to track, oversee and optimize every interaction between the customer and the company’s products and services throughout the customer journey and its lifecycle. Developed a set of processes for cleansing, manipulating, and organizing customer data from three online research platforms used across the business to capture customer rating and feedback using MS Excel, Power Query and SQL language in Google Big Query

• Created data solutions and dashboards to share valuable insights on the Net Promoter Score (NPS) with internal stakeholders, directors and CEO using Google Sheets, Power BI, Dax language and Google Data Studio.
• Led committees in a monthly basis with the managers of key business areas (Customer Service, CRM, Training and Development) to discuss the NPS performance, address issues in the customer journey and create an action plan.
• Took leadership in the CX platform implementation, guiding the calibration of metrics, dashboard creation and refinement of text analytics
• Migrated blocks of code and queries in SQL from SAP Hana to Google Big Query
• Represented the business area in an agile squad to develop an ETL process for the customer data from the CX platform into Google Cloud Platform
• Data Definition, Manipulation, Query and Transaction on Big Query

Technologies:  MS Excel, Power Query, SQL, BigQuery, Power BI, Google Sheets, Google Data Studio, SAP Hana, ETL, GCP, Agile, Looker Studio

Mid-Senior Data Analyst (Brands & Product Insights): Initiated the digital transformation of the process of sales performance analysis inside the Product & Brand Insights department of the Strategy, Planning, and Insights (SP&I) Area, alongside generating actionable data solutions and insights on product migration and new product launches in the main operations of South America (Argentina, Chile, Peru, Paraguay, and Uruguay).

Mid-Senior Data Analyst (Trade Marketing Insights):  Promoted a digital transformation of the process of sales performance analysis inside the Trade Marketing Insights department of the Strategy, Planning, and Insights (SP&I) Area, along with generating actionable data solutions and insights on Sales Performance for the Business Units of North and Northeast in Brazil.

• Designed an ETL process to enhance data from multiple sources and systems (excel files, SAP, retailers, Kantar, Nielsen, Ipsos), recombining them into new datasets using MS Excel and Power Query. Implemented a self-service dashboard solution in Power BI to facilitate more informed decisions for Sales Specialists and Brand Managers.
• Led committees on a weekly basis with Brand Managers, Demand Planning Managers, and Trade Managers to discuss sales target achievement analysis based on operational KPIs (volume, numeric and weighted distribution, repurchase rate, share of market). Trained and coached staff in the usage of Power BI Desktop and Power BI Service solutions to contribute to their skills development.
• Optimized the creation process of trade marketing insights from 5 hours to 20 minutes by implementing Power BI dashboards, thus, allowing employees to be more focused on business decisions.

Technologies:  PowerBI, SQL Server, ETL, SAP, PowerQuery, MS Excel

Supporting the decision-making process of the Capacity and Budget Department regarding technology improvement projects through building and monitoring dashboards. Collected data from multiple spreadsheets and recombine them into a single data source in SQL Server to be able to analyze data trends and patterns regarding budget management of technology improvement projects. Automated operational processes through the development of macros in VBA. Developed queries, functions, procedures, and jobs in T-SQL.

• In an Agile squad performed the data modeling of a data warehouse that served to store data from an online project management application, as well as supporting the creation of Tableau dashboards.
• Through data analytics with the support of Tableau dashboards, discovered the misallocation of over R$ 500K in technology improvement projects that later I negotiated the refund in favor of the company.
• Data Definition, Manipulation, Query and Transaction on SQL Server

Technologies:  SQL Server, T-SQL, VBA, Agile, Tableau, PowerBI

• Business Intelligence Analyst – Procurement and Logistics at IBF Industria Brasileira de Filmes (2017)
• Business Intelligence Analyst – Procurement at Norsk Hydro (2015-2017)
• Scholarship Holder at CAPES – Coordenação de Aperfeiçoamento de Pessoal de Nível Superior (2013-2014)
• Engineering Intern at Status Construções (2012)