Natan Amaral Email & Phone Number

São Paulo, Brazil

São Paulo, Brazil

Achievements:• Delivered a comprehensive ad-hoc analysis, revealing over $100M in potential savings and driving strategic enhancements for key Pro services segments.• Diagnosed a 30% spike in subscription transitions during peak weeks, uncovering critical gaps and designed targeted data assets to reduce downgrades in high-risk segments, improving retention strategies.• Conducted a benchmarking study across six loyalty programs, projecting a 20% increase in adoption rates for Rappi’s personalized offers post-implementation.Context:Data Analyst responsible for leveraging analytics to optimize Rappi's premium services globally, focusing on churn reduction, customer retention, and enhanced service execution. Plays a pivotal role within Rappi’s Global Pro Team, collaborating with cross-functional teams to address diverse analytical needs and delivering comprehensive, end-to-end data solutions.Technologies:• Python | Pandas | Matplotlib• SQL | PostgreSQL | DataGrip• Azure Synapse | Snowflake• Power BI | DAX• Microsoft Excel | Google Sheets• Pivot Tables | Pivot Charts | Power Query• JIRA | ConfluenceActivities:• Designing and executing advanced SQL queries to analyze customer behavior, Pro user trends, and subscription performance, ensuring actionable insights for strategic decision-making.• Building interactive and visually compelling dashboards using Power BI to communicate key metrics and findings to stakeholders across teams.• Conducting comprehensive market research and competitive analysis to refine loyalty program strategies, aligning with industry best practices.• Providing strategic and operational data support to cross-functional teams, collaborating on global initiatives.

Curitiba, Paraná, Brazil

Achievements:• Attained a monthly savings of R$9,000 by conducting a tailored Ad-hoc Analysis focused on optimizing cost-efficiency, which mapped over R$500,000 in annual expenses minimization opportunities within a complex freight logistics operation.• Worked on the optimization of a Data Visualization Architecture, leading to an annual cost reduction of US$21,700 in BI expenses, by proposing a new architecture that simultaneously improved performance, scalability, and data modeling.• Identified over R$1 million in cost-saving opportunities through a comprehensive Inventory Turnover Analysis, and designed an intuitive dashboard for near real-time inventory management, fostering efficiency and optimizing inventory health.Context:Data Analyst responsible for meeting the Analytics needs of Erathos' consulting clients in the US and Brazil. Responsibilities involve researching, designing, and implementing end-to-end Analytics and Business Intelligence solutions. Conducted various ad-hoc analyses, established and managed multiple data warehouses based on the medallion architecture, taking charge of data cleaning, modeling, analysis, and visualization, generating meaningful business insights across a wide array of industries, including Finance, SaaS, Health, HR, Law and Retail.Technologies:• Python | Pandas • DataGrip | SQL | BigQuery | MySQL | PostgreSQL• Power BI | Tableau | Looker | Figma• Microsoft Excel | Google Sheets | DAX• JIRA | ConfluenceActivities:• Gathering data from various sources, such as databases, APIs, and external files.• Cleaning and preprocessing data to remove inconsistencies.• Applying statistical techniques to explore data and identify patterns, trends, and anomalies.• Creating summary statistics, reports, and visually appealing dashboards to communicate insights to non-technical stakeholders.• Establishing data monitoring systems to track KPIs.• Optimizing data processes to improve accuracy and efficiency over time.

Vancouver, British Columbia, Canada

Achievements:• Improved Return On Investment (ROI) in marketing campaigns for one of the largest animation companies in China by optimizing ad spend through an Ad-hoc Audience Segmentation Analysis.• Enhanced social media engagement strategy of a US$50,000 crypto project by monitoring and benchmarking the performance of over 50 marketing campaigns through a tailored Competitor Analysis.• Optimized a large email marketing operation, improving email open rates, click-through rates, and conversion rates through reasearch and analytics strategies.Context:Data Analyst responsible for optmizing the marketing strategy operation of BIBI LABS' clients in Canada and China. Resposibilities include researching, designing, and implementing Analytics solutions, leveraging data to optimize campaigns, enhance audience targeting, and improve ROI. Analyzed marketing performance for different consulting clients within the crypto space, providing data-driven actionable insights to inform strategy.Technologies:• SQL | PostgreSQL • Power BI | Tableau | Figma• Microsoft Excel | Google Sheets | DAX• Pivot Tables | Pivot Charts | Power Query | FunctionsActivities:• Using Excel and SQL to clean and prepare data for analysis, including removing duplicates, handling missing values, and ensuring data quality.• Creating and using Pivot Tables in Excel to quickly summarize and analyze large datasets, providing insights into marketing campaign performance and customer behavior.• Designing interactive dashboards and visualizations in Power BI to present marketing insights and KPIs in a visually appealing and user-friendly format.• Writing and executing SQL queries to extract specific data for in-depth analysis, including segmenting audiences, tracking campaign performance, and identifying trends.• Generating reports in Excel and Power BI to convey key findings, trends, and actionable recommendations to marketing teams and clients, facilitating data-driven decision-making.

Ribeirão Preto, São Paulo, Brazil

Achievements:• Enhanced data accuracy and organization by maintaining firm's records, minimizing errors and categorizing legal data, leading to better decision-making.• Improved research efficiency and data processing time by unifying and standardizing internal financial reports.• Analyzed several cases in civil and corporate law to identify trends in legal matters, judge rulings, and case durations, leading to better case strategies.Context:Data Analyst tasked with supporting data-driven initiatives at Coletto LLP, a leading law firm specialized in corporate law. Responsibilities encompass data entry, research, analysis, and the implementation of data-driven solutions to enhance legal operations, improve case outcomes, and drive efficiency. Collaborated with legal teams to analyze case data and provide valuable insights to inform strategic decisions, as well as generate informative reports that facilitate informed legal counsel and strategy development.Technologies:• SQL | PostgreSQL | Power BI | DAX • Microsoft Excel | Google Sheets • Pivot Tables | Pivot Charts | Power Query | FunctionsActivities:• Utilizing Excel and Google Sheets to ensure data accuracy and quality by removing duplicates, handling missing values, validating legal documents and case information.• Creating Pivot Tables in Excel and Google Sheets to efficiently summarize large volumes of legal data, identifying key trends, case outcomes, and legal performance metrics.• Maintaining organized and detailed records of legal case data, firm documents, research findings, and analysis procedures for future reference.• Collaborating with legal teams to provide insights that inform legal strategies, case management decisions, and client counseling, while contributing to informed and data-driven legal practices within the firm.