Ifeoluwa Olla

Work History

Konec USA LLC

Houston, TX

06.2024 - Current

Monitoring incoming and outgoing departmental operations, ensuring the accuracy and reliability of reported data.
Establishing and maintaining strong relationships with clients (Tesla) and vendors, securing essential contracts for departmental projects.
Utilizing software tools such as Python, SQL, and Excel for data analysis, generating insights, and producing technical reports. Managing databases, dashboards, and presenting findings using tools like Tableau and Microsoft Office.
Using data analytics tools to forecast demand, plan inventory, and optimize supply chain operations. Simplifying complex tasks by developing alternative approaches, enhancing overall efficiency and effectiveness.
Leveraging data analysis to identify areas for improvement, monitor trends and patterns, managing stock and material usage.
Managing project workflows among team members to ensure efficiency, accuracy, and effectiveness in execution.
Implementing logistical strategies 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 utilizing SQL to extract data from diverse sources, including relational databases consisting of contracts, inventories, suppliers, products, and invoices. Performed data cleaning and transformation operations to guarantee accuracy and consistency of data, resulting in remarkable 45% improvement in data reliability.
Conducted in-depth data analysis using SQL and Excel to identify trends, patterns, and insights on bus parts usage and bus operations. Generated reports and visualizations to present findings effectively to material management department and support data-driven decision-making.
Managed department's database by creating, modifying, and optimizing SQL queries, stored procedures, and views. Implemented efficient indexing strategies to enhance query performance and overall database efficiency.
Created and maintained visually appealing and informative dashboards, charts, and graphs in Excel to present data analysis results about revenue, average gas price, inflation, deflation, bus parts usage and 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

12.2020 - 07.2022

Managed database and utilized SQL to format, extract, transform, and analyze customer data to identify patterns, preferences, and trends.
Developed and implemented predictive models using Python to forecast customer behavior trends and designed interactive Tableau dashboard to visualize and communicate findings to stakeholders.
Built machine learning models to automate data analysis and identify patterns that are not immediately apparent.
Performed ad hoc analysis to address concerns in consumer behavior and formulated hypotheses using machine learning to test and validate hypotheses.
Applied basic and advanced functions on large dataset in Excel to sort, validate, clean data, and performed mathematical functions.

National Bureau of Statistics - NBS

11.2019 - 12.2020

Produced monthly reports using advanced Excel spreadsheet functions.
Identified, analyzed and interpreted trends or patterns in complex data sets.
Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
Utilized data visualization tools to effectively communicate business insights.
Generated data report to reflect aspect of Nigeria government basic amenities that required more funding and significantly improved national budget accuracy by 50%.

Ladoke Akintola University Of Technology

05.2017 - 08.2017

Coded using computer programming languages such as C++, html, CSS and JavaScript to build web applications.
Improved software efficiency by creating automated scripts and tools.
Collaborated with other developers to build an online based testing platform.
Debugged, analyzed and revised computer programs to increase operating system software efficiency.
Developed in-house applications designed to manage over 20,000 student information and maintain student portal.