Data, Change and Analytics Manager Journey
" My journey in data transformation and consulting showcases a unique blend of chemical engineering background and advanced data analytics expertise."

by Mari Perez

Transitioning into Data Analytics

1

Chemical Engineering Background
Graduated with a Bachelor's in Chemical Engineering from Brazil.

2

First Data Exposure
As BI and Planning Analyst, worked with data integration and market analysis.

3

Key Learning
Integrated internal and external data to create decision-supporting dashboards at ExxonMobil.
Transforming Data into Actionable Insights at ExxonMobil (Moove)
The Challenge
At ExxonMobil, I faced a fragmented data environment, with data siloed across Salesforce, market research reports, and focus groups. This made it difficult to gain a unified view for strategic decision-making.
The Solution
I participated on the implementation of Oracle (Datawarehouse) and Alteryx to automate ETL processes, bringing together data from various sources. Tableau Prep was used to clean, normalize, and standardize the data, ensuring accurate and actionable insights for both internal teams and external stakeholders.
ExxonMobil – BI and Data Integration
ETL and Data Integration
Built ETL workflows with Alteryx and standardized data with Tableau Prep.
Dashboard Creation
Developed Tableau Dashboards for internal stakeholders and external distributors.
Business Impact
Helped distributors identify untapped markets and improve sales strategies using geolocation analysis and Pareto charts.
Enhanced internal decision-making with goal-oriented dashboards.
Fostered data-driven decision-making across the organization.
Showcasing Actionable Insights
A systematic approach to transforming data into compelling business stories at ExxonMobil.
1
Data Analysis
Gathered and processed distributor data using geolocation analysis and Pareto charts
2
Dashboard Creation
Developed comprehensive Tableau dashboard to empower distributors with data-driven insights for identifying untapped markets
3
Strategic Presentation
Created engaging PowerPoint presentation leveraging Tableau visualizations to enable informed decision-making
View the complete market scan analysis (double-click below to open):
Other Dashboard example for Potential Volume for specific sku per geolocation
Building on Data Knowledge at RMIT University
1
Pursuing Data Science
Enrolled in Master's in Data Science at RMIT in 2019.
2
Core Concepts
Mastered programming, ETL workflows, and big data technologies.
3
Achievements
Served as Peer Mentor and conducted NSW land market scan project.
Data Analytics Project with Python, Apache, and SQL
Leveraging Python
Utilized Python's robust data manipulation and machine learning capabilities to extract insights from complex data sets.
Apache Integration
Integrated Apache technologies like Spark and Hadoop to enable scalable, high-performance data processing and analysis.
SQL Mastery
Demonstrated proficiency in SQL for data querying, transformation, and integration with Python and Apache tools.
Data Literacy Badge
Earned the Data Literacy Badge, showcasing my principles-based understanding of data analysis and decision-making.
Final Project: NSW Land Market Scan
Objective
Analyse and visualize trends in the NSW land market.
Tools Used
Tableau Prep (ETL), Weka (SQL), Tableau (Dashboard) for analysis and visualization.
Outcome
Provided actionable insights for informed land investment decisions.

PDF file

Data Science Project Presentation

7.1 MB

www.youtube.com

Market Scan Dashboard - Tableau

If the YouTube link above doesn't work > https://www.youtube.com/watch?v=WFILyIT2Vkc
My Evolution at VG

1

2

3

1

System Implementer
Started role focused on implementation.

2

Team Leader
Promoted to lead a team of 4.

3

Business Consultant
Managed up to 8 simultaneous projects.
End-to-End Project Management

1

Project Kickoff
Translated lead information into custom proposals aligning with client needs via Proposify.

2

Scoping Sessions
Organized meetings with C-level stakeholders to understand business challenges and Operations Team to understand daily gaps.

3

Gap Analysis
Identified process gaps and assessed cost-benefit for system upgrades.
Creating Actionable Business Reports
Deliverables
Produced comprehensive Business Reports outlining company overview, gap analysis, and proposed solutions.
Tools Used
Utilized Lucidchart for process flowcharts and Accelo for project tracking.
Project Delivery Tools
Accelo
Accelo is a platform for managing project timelines, tasks, and resources efficiently. It tracks project progress, allocates team capacity, and ensures transparency for stakeholders. I use it to coordinate multiple projects simultaneously, align resources with deliverables, and maintain visibility across my team's workload.
Lucidchart
Lucidchart is a tool for creating visual flowcharts and diagrams. After scoping sessions, I map the current state of the company’s operations, identify gaps, and design improved workflows. These diagrams provide a clear, visual guide for clients on areas needing optimization.

PDF file

Company Overview Process

303.1 KB

PDF file

Alclad Detailed Process.pdf

315.7 KB

Business Report
The Business Report consolidates findings from scoping sessions, including company overviews, operational gaps, and tailored recommendations. It aligns proposed solutions with the client’s goals, providing a roadmap for transformation, including process improvements, systems integration, and training plans.

PDF file

Alclad Business Report

843.4 KB

PDF file

EBS - Business Audit & Recommendation Report.pdf

750.1 KB

System Implementation and Data Transformation
Designing System Setup
Configured user permissions and data security to ensure the integrity and accessibility of the new system.
Permissions Example
ETL Process
Handled the process of importing and cleansing data, guaranteeing high-quality information for the client.
Tailored Training
Provided comprehensive training to clients on the new system, covering standard operating procedures and business rules.
Videos, SOPs, Face-to-Face
Integrated Data Warehousing
Leveraged AWS S3 and Oracle for data storage and system integration, enabling efficient data processing and reporting.

PDF file

Data Analytics & Engineering Portfolio.pdf

1.2 MB

Key Technologies and Tools
Expertise in ETL, data processing, business intelligence, visualization, and system integration tools.
Business and Data Transformation: Reporting and Dashboards
Power BI Dashboards
Created interactive, real-time dashboards for clients, enabling them to gain actionable insights from operational metrics.
Example BI
SQL, Data Modelling & PowerQuery
Leveraged SQL and PowerQuery to seamlessly integrate cleansed data into Power BI from Oracle, providing stakeholders with a comprehensive view.
Example BI
Accreditation Support
Tailored documentation and processes to help clients achieve ISO accreditation for Quality and Safety, ensuring compliance.
Example - Documentation
Accelerating Workflows with Microsoft's Power Platform
Seamless Integration
Seamlessly integrated Power Apps and Power Automate with SharePoint, creating cohesive data management systems.
Streamlined Data
Leveraged Microsoft Lists to centralize and manage data, ensuring accessibility and consistency.
Automated Workflows
Implemented Power Automate to eliminate manual tasks, boosting team productivity and efficiency (emails, workflows of approval, quoting).
Actionable Insights
Utilized Power BI to build interactive dashboards and reports, providing stakeholders with data-driven decision-making capabilities.
Microsoft Power Platform Tools in Action
Visual examples of our integrated Microsoft solutions that drive business efficiency.
Team Leadership and Resource Management
Team Management
Managed a team of 4 including System Implementers, Data Analyst and Junior Business Consultants. Responsible for their career development, setting KPIs, and providing training.
Using Employment Hero to track improvement and KPIs
Resource Allocation
Ensured the team's resources were optimally allocated to meet project deadlines and deliver high-quality results for clients.
Why I'm Exited about my path

Passionate About Data-Driven Decisions
I'm passionate about leveraging data to drive business success and make informed, transformative decisions.

Strong Leadership
My experience in data integration, governance, and visualization, combined with my leadership skills, make me an ideal fit for a Data Driven position.
Thank You and Connect with Me
Mariana Perez
Let's Connect
  • mariana.sperez@icloud.com
  • +61 420 474 931
Thank You
I appreciate your time and consideration.