Ian Aranda Grossi Email & Phone Number

Perth, Western Australia, Australia

Exploratory analysis of customer data using BigQuery and Google Data studio to check for quality of data in a digital Ad fault software. Interpret, analyse and draw conclusions from Customer’s data and generate reports using Bigquery and Looker.Build and maintain dashboards for the customer success team to help them measure, analyze and optimize every aspect of their engagement with customers.Working with product owners and stakeholders by analysing customer data and flagging any fraudulent transactions/interactions and abnormality in customer digital ad data by understanding various threats in the Digital ad space.Maintaining and documenting data assets throughout the lifecycle of a customer audit.

São Paulo, Brazil

Assisting in identifying business requirements relating to data strategies and supporting product, customer service and CX areas;Preparing data analysis ensuring data accuracy and quality, and creating clear visualisations according to business needs;Managing and controlling datasets and daily updates routines/trigger operations;Identifying processes for improvement and working closely with Data Scientists creating queries and data strategies for the team;Building comprehensive reports, insight presentations and analytical dashboards for different departments and clients;Helping in the transition of systems and platforms after the start-up acquisition by DiDi;Key Achievement: Created a Power BI dashboard centralizing Customer Service data and metrics that would be daily updated and feed a team of + 100 Customer Services Agents and Managers with relevant information. This system was often updated with new metrics I developed to give meaningful insights and bring efficiency to the CS team work. I also supported the Data team during the acquisition of 99 by DiDi, holding meetings with their Data Team in China discussing systems integration and ensuring data accuracy by making comparison analysis.

São Paulo, Brazil

Working with sales team conducting reports and analysis to understand revenue and best marketing solutions for clients;Centralizing complex data into dashboards, from extraction to the creation of clear visualizations according to business/client needs;Managing and reviewing data sets ensuring data accuracy and quality taking appropriate actions to resolve data discrepancy;Using Tableau to cross data from multiple sources and platforms;Providing business insights and reports to other departments and to the Sales Director;Preparing recommendations on strategies, data, reporting methodologies to meet client needs;Planning the quotes and establishing an agreement with sales reps based on data analysis;Helping the Marketing Manager with set up of marketing campaigns, events, digital media release, website, launching of new products and translating new material to Portuguese;Serving as data support on LinkedIn marketing activations on advertising agencies;Conducting studies on campaign audience and targeting to optimize platforms;Key Achievement: Awarded by LinkedIn in San Francisco for the creation of a dashboard project using Tableau and SQL crossing data from multiple platforms. The project Caipirinha, named after a famous Brazilian drink, gathered campaign and detailed segment /audience data from different marketing solutions in one place and it optimized sales development and account management. Implemented and successfully created the same platform in the Canada and the US branches. This project not only helped the sales team on a daily basis, but also helped identify deficiencies on targeting and segments delivery that led to optimization of platforms and consequently better campaign results.

São Paulo, Brazil

Developing and maintaining new business relationships within the industry and preparing all the offline media for the organisation;Creating, identifying and developing sales proposals together with the ad team;Maintaining database records of all inquiries through the CRM, quoting system and other programs as required;Creating marketing campaigns, developing structure and strategies to maximise the portfolio and implementing campaigns;Tracking campaigns results, analysis and follows ups with clients and providing after-sales support to customers and preparing reports as needed;Developing KPI measurement to maintain an effective sales process within the Sales departments and updating the Media Kit with data extraction from the websites;Analysing delivery according to marketing campaign requirements.

São Paulo, Brazil

Manipulating and analysing large, complex data sets, turning them into actionable business insights for teams and departments using excel spreadsheet and VBA macros;Working with the account managers, building and maintaining dashboards, reports, and perform analysis to drive customer and revenue growth;Creating a platform to verify costs x sales analysis;Preparing cross campaigns data from multiple sources to make them more comprehensive to read;Developing and maintaining control sheets updates with campaigns data;Proposing, scope and executing projects that are aligned with the broader business goals.

Advanced Diploma, Ict Networking

Certificate Iv, Marketing Communications

Bachelor'S Degree, Advertising And Marketing

Advanced Diploma, Mechatronics, Robotics, And Automation Engineering