Murilo S.

●Developed Revenue Forecast of a Subscription Service

●Developed Financial and Sales Dashboard using Tableau

• Performed Studies and data exploratory analysis to answer specific business questions and support decision taking to attract leads and increase conversion for Google Cloud Platform product

• Automated data extraction, transforming and cleaning process (ETL) using Google tools (Plx, Google BigQuery and Google Sheets)

• Designed and developed dashboards and data Visualizations in Looker Studio

● Worked in Data Migration of a Data lake in Denodo, using Data from Athena and Redshift and containing data for hundreds of Dashboards in QlikView and Power BI

● Designed and developed dashboards and data Visualizations in Power BI for Janssen - (Brazil and all Latin America) Skills and Tools Used: Power BI, AWS Tools (Athena, Redshift), Denodo, SQL Language, Git, QlikView

● Worked in 2 different global teams in Bayer Pharma focused on Data Visualization and Analytics (Latam Team, people from Latin America speaking mainly in Spanish and Portuguese, and Global Team, people from India and Germany, speaking in English).

● Designed and developed dashboards and data Visualizations in Tableau for Bayer Pharma - (Germany, Argentina, Uruguay, and Chile)

● Extracted, transformed, and loaded data using MS SQL Server and SQL Server Integration Services for Bayer Pharma

● Used Snowflake, Git, and Amazon Web Services tools (S3, Glue) for extracting, transforming, and loading data in Data warehouses.

● Collaborated with clients in Argentina and Germany to understand business requirements and create data sources and dashboards to satisfy business needs.

● Worked in a Project of Data Warehouse Migration from Denodo to Snowflake, involving hundreds of dashboards in Tableau which used Data from these sources

● Conducted analyses on P&L (premiums, claims, underwriting, operating expenses, credit) and market data to inform business strategies and enhance performance for the Brazilian Surety Bond market leader.

● Developed dashboards and data sources.

● Performed studies and data exploratory analysis using Python (Numpy, Pandas, Sklearn, Seaborn, Plotly), participating in the company's growth between 2019 and 2021

● Extracted, transformed, and loaded (ETL) Data using MS SQL Server

● Developed unsupervised machine learning models for Customer clustering, using Python (Sklearn)

● Performed studies to support marketing strategies, focused on customer retention, using statistical modeling and machine learning methods (customer clustering, retention scoring, customer lifetime value analysis)

● ETL creation of reports and dashboards of commercial and market indicators and satisfaction surveys (NPS-Net Promoter Score, complaints) for one of the largest insurance companies in the world

● Prepared profitability studies of partner brokers, decreasing the cost with low-relevance brokers.

● Analyzed insurance market data such as market share rankings and contribution margin.

● Supported the commercial area and proposed/monitored price adjustments for Analyzed Margin (cost x price), considering sociodemographic variables and vehicle models.

● Reported and analyzed current and issued policy portfolio KPIs for the Brazilian branch of one of the largest European insurance companies (Talanx Group)

● Automated controls related to the conversion and loss ratio indicators of the portfolio, reducing the operational work by 90%