Ifeoluwa Olla

Work History

Konec USA LLC

Houston, TX

06.2024 - Current

Secured a contract for manufacturing newly improved aluminum motor and inverter gear cases on Tesla Cyber truck electric vehicles. Maintaining strong relationships with clients, vendors and coordinating other essential contracts for departmental projects. Communicating effectively with clients on order status, advanced shipment notice, deliveries and supply chain management.
Coordinating procurement, proposals, negotiations, contract compliance and analyzing quotations. Revising contract terms, validity and ensuring compliance with city, state and federal regulations, including Incoterms for logistic operations.
Generating new part numbers and ensuring engineering changes are properly implemented on new parts during the manufacturing process. Supervising production, developing capacity plans to ensure supply meets demand, building sales and shipment plans.
Utilizing software tools such as Python, SQL, and Excel for data analysis on inventories, material usage, performance, running predictive analysis to forecast demand and supply, generating business insights, and producing technical reports. Managing databases, dashboards and presenting findings using tools like Tableau and Microsoft Office.
Performing simulation on performance and production data to implement logistical strategies on how to reduce costs, break down problems, evaluate solutions, and make informed decisions.

Orange County Transportation Authority

Orange, CA

07.2022 - 06.2024

Compiled data and utilized SQL to extract data from diverse sources, including relational databases consisting of contracts, inventories, suppliers, and invoices. Performed data cleaning and transformation operations to guarantee accuracy and consistency of data, resulting in remarkable 45% improvement in data reliability.
Reviewed and evaluated existing and obsolete contracts, consolidating them to create a single, unified, and up-to-date agreement.
Generated new part numbers, monitored stocks on hand, and worked closely with the inventory planner on recommended orders. Facilitated expedited shipment on priority orders, tracked shipment and reported updates to stakeholders.
Prepared month-end reports on RINs, LCFs, Hydrogen usage and revenue. Developed visually compelling dashboards, charts, and graphs in Excel to effectively communicate data analysis insights on revenue trends, average gas prices, inflation and deflation metrics, as well as bus parts usage and inventory storage.
Utilized advanced Excel functionalities, such as Excel formulas, pivot tables, V-look up, and macros, to automate data manipulation tasks and improve efficiency.

Deepsify LLC

Irvine, CA

11.2019 - 06.2022

Led cross-functional team operations focused on verifying inbound and outbound shipments,
resolving discrepancies, and ensuring proper documentation of all materials handled. Collaborated
with internal departments to streamline operations and maintain effective communication with
customers to enhance service delivery.
Designed and implemented a centralized database; applied SQL and Python to analyze customer
data and uncover trends. Leveraged ERP systems to maintain accurate inventory records and
generate performance/inventory reports.
Developed predictive models to forecast revenue and sales based on active projects. Created
interactive Tableau dashboards to clearly communicate data-driven insights to stakeholders.
Conducted ad hoc analyses to investigate shifts in customer behavior; used machine learning to
build and test hypotheses, driving data-backed recommendations.
Analyzed performance metrics to identify inefficiencies and led continuous improvement initiatives
that reduced costs and improved turnaround times.