Summary
Overview
Work History
Education
Skills
Websites
Certification
Languages
Timeline
Generic

Junior Marafelli

Sydney,Australia

Summary

Skilled Data Analyst with experience generating actionable insights, automating workflows, and building intuitive dashboards. Background in law, business administration, and manufacturing, with hands-on experience as a CNC Machine Operator. I am proficient in Excel, Python, Power BI, and CRM/ERP systems, specializing in sales reports, stock tracking, and freight cost analysis. Currently leading tests for NetSuite software implementation at ABM Global, integrating systems for improved data management. Experienced in managing container transportation logistics between China, Australia, and New Zealand, optimizing freight costs and calculating landed costs.


Overview

14
14
years of professional experience
1
1
Certification

Work History

Data Analyst

ABM Global
02.2024 - Current
  • - Developed automated reporting systems to generate monthly sales dashboards, reducing manual effort by 40%.
  • - Managed Stock on Hand (SOH) reports, categorizing and analyzing sales trends to optimize inventory decisions.
  • - Streamlined freight cost analysis using Python and pivot tables, ensuring invoice accuracy.
  • - Coordinated container transportation logistics from China to Australia, and from Australia to New Zealand, evaluating quotations to secure optimal value.
  • - Calculated landed costs to ensure accurate application to final product pricing.
  • - Leading testing and integration efforts for NetSuite software implementation to enhance system functionality.
  • - Designed Power BI dashboards for freight pricing, improving transparency in monthly cost evaluations.
  • - Standardized formula updates and introduced error-detection mechanisms, minimizing reporting errors.
  • - Spearheaded a version control system for Excel files, enhancing data backup and security.

Assistant Manager, Warehouse Logistics

ABM Global
12.2021 - 02.2024
  • Assisted in the recruitment and onboarding of new team members, contributing to a strong and cohesive workforce.
  • Implemented continuous improvement initiatives, leading to cost savings and process enhancements within the warehouse environment.
  • Optimized warehouse space utilization by regularly reviewing storage layouts and implementing necessary adjustments.
  • Led cross-training initiatives among warehouse staff to promote a flexible workforce that could adapt to changing business needs quickly.

Business Assistant

REIFOR Battery Company
01.2014 - 12.2016
  • - Managed administrative tasks, including balancing accounts, processing employee payments, and overseeing sales operations.
  • - Coordinated with sales and finance teams to ensure timely reporting and compliance with financial regulations.
  • - Prepared monthly financial statements and reconciled discrepancies in company accounts.
  • - Provided exceptional customer service and maintained accurate sales records to support business growth.

Law Assistant

Litucera Engenharia
01.2012 - 12.2014
  • - Supported legal teams with document preparation, research, and case management.
  • - Assisted in drafting contracts, reviewing legal documents, and maintaining compliance with regulatory requirements.
  • - Managed correspondence with clients and legal entities, ensuring accuracy and professionalism.
  • - Organized and maintained legal records and case files for efficient retrieval.

Business Assistant

Alfe Engenharia
01.2011 - 12.2011
  • - Provided administrative support, managing office operations and assisting with daily organizational tasks.
  • - Handled employee documentation, payroll processes, and scheduling to ensure smooth workflow.
  • - Organized and maintained company records, improving efficiency in document retrieval.
  • - Assisted with client correspondence and ensured timely communication for ongoing projects.

Education

Bachelor's Degree - Law

University UNIANCHIETA
12.2014

Skills

  • - Data Cleaning and Analysis (Python, Excel, Power BI)
  • - Sales and Stock Reporting
  • - Workflow Automation and Error Detection
  • - CRM/ERP System Management (Sassplications)
  • - Freight Cost Analysis and Invoice Reconciliation
  • - Artificial Intelligence and Data-Driven Insights
  • - CNC Machine Operation and Maintenance
  • - Administrative Management and Financial Reporting
  • - Stakeholder Communication and Collaboration

Certification

  • - TAFE Online: Introduction to Artificial Intelligence (Completed: 2024-11)
  • - CEPROVI: Administration Course, Vinhedo, SP, Brazil (Completed: 2013)
  • - Power BI for Business Analytics (Coursera)
  • - Python for Data Analysis (Udemy)
  • - Advanced Excel for Data Management (Coursera)

Languages

- Portuguese: Native
- English: Fluent

Timeline

Data Analyst

ABM Global
02.2024 - Current

Assistant Manager, Warehouse Logistics

ABM Global
12.2021 - 02.2024

Business Assistant

REIFOR Battery Company
01.2014 - 12.2016

Law Assistant

Litucera Engenharia
01.2012 - 12.2014

Business Assistant

Alfe Engenharia
01.2011 - 12.2011

Bachelor's Degree - Law

University UNIANCHIETA

Similar Profiles

CREATE PROFILE
Junior Marafelli