Sofia Longart

About Sofia Longart

Digging into the “nitty gritty detail” and working around with data (numerical and non-numerical) is what I love to do because data is fact that cannot be denied. My passion is discovering data insights that help business see what area is calling for improvement, cost saving opportunities and fuels business growth overall. From capturing, transforming, modeling data to report into dashboards that are easy to read and understand to non-technical audience by using storytelling adapted to the right hearing. Data is in everywhere and in every industry so having experience in the Oil & Energy and Manufacturing strengths my data mining skills to uncover the gold that everyone wants to buy. Proficient in Excel, PowerBI SQL and skillful in Python.

Experience

1. Inventory

   Aust Group

   May 2025 — Present · West Valley City, UT, US

   Conduct statistical analysis of inventory data to assess, model and minimize scrap rate more than 2%, conduct variance between manufacturing versus production, stock levels, minimize aging materials.•Calculate material requirements for production orders and proactively alert Manufacturing and Planning teams about shortages, preventing downtime and adjusting order quantities as needed.•Partner with Purchasing to manage MRP, and ensure BOM accuracy; collaborate with Accounting to resolve invoice document issues.•Develop and update Excel tools, write VBA and Python code to automate repetitive tasks and data ETL; build data models and dashboards in Power BI for efficient data management, analysis and visualization.

Education

• Rice Business

  Specialization on Business Statistics & Analysis, Business Statistics

  2018 — 2018

• IUTIRLA

  Bachelor's Degree, Information Technology

• Miami Dade College

  Language Certification, English as a Second Language

  2001 — 2001

Skills

• Oracle Primavera Project Management
• Schedule Development
• Schedule Control
• Project Control
• Microsoft Project
• Project Planning
• Data Analysis
• Data Management
• Database Development
• Project Management
• Project Coordination
• Process Scheduler
• Microsoft Office
• Sharepoint
• Access
• Analysis
• English
• Mysql
• Software Documentation
• Translation
• Petroleum
• Spanish
• Upstream
• Construction
• Intercultural Communication
• French
• Forecasting
• Energy
• Primavera P6
• Microsoft Excel
• Analytical Skills
• Data Science