fbpx Saimon | DevReady

Let’s Get Started

Saimon
HireSaimon

Saimon

São Paulo, São Paulo, Brazil --:--:--

Saimon Assunção is a Data Analyst with over 7 years of professional experience in Data Analytics, Data Visualization, and ETL development. He imposes strong PowerBI skills and is experienced with Tableau with a strong Business Intelligence and Data Visualization background. He has been promoting digital transformation and optimizing the decision-making processes of organizations from different industries and markets (mining, telecommunication, tobacco, and cosmetics). Saimon is an elite Data Analyst who holds a Post-Graduation Degree in Data Science and Big Data, looking for a Senior Data Analyst position.

Hire Saimon
Skills
Years
1
2
3
4
5
6
7
8
9
10+
Customer Experience Insights
Trade Marketing Insights
SAP
Power Query
Data Analytics
Big Query
Google Sheets
VBA
SQL Server
Business Intelligence
PL/SQL
Tableau
T-SQL
Digital Transformation
Oracle SQL Developer
SAP HANA
ETL
GCP
MS Excel
Looker Studio (Data Studio)
Power BI
DAX
Developer Personality

Independent

Collaborative

Trailblazer

Conservative

Generalist

Specialist

Planner

Doer

Idealist

Pragmatist

Abstraction

Control

100
50
0
50
100
Feature Experience

Data Visualization Creation

Database System Management

Sales/Trade Marketing Insights

Reporting and Presentation

MODERATE
EXTENSIVE
EXPERT
Cultural Experience

Agile - Scrum

Sales Marketing

Customer Experience

Trade Marketing

MODERATE
EXTENSIVE
EXPERT
Portfolio

LG Electronics Brazil

Data Specialist (Go-to-Market)

Categories

Work Experience : 2022-Present

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

 

 

More

Boticário Group

Data Specialist (Consumer Experience)

Categories

Work Experience : 2021-2022

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

More

British American Tobacco BAT

Mid Senior Data Analyst

Categories

Work Experience : 2019-2021

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

 

More

Oi Telecommunication

Business Intelligence Analyst

Categories

Work Experience : 2017-2019

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

More

Previous Roles

Categories

Work Experience : 2012-2017
  • 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)

Features

More

Hire Saimon