Bathsheba Nyairo

• Successfully conducted Extract, Load, and Transform (EL-T) tasks within the organization using Oracle Data Integrator (ODI). Responsibilities included designing, developing, and executing data integration workflows to extract data from various sources, transform it as per business requirements, and load it into target systems.
• Implemented efficient data cleansing, validation, and enrichment processes to ensure data accuracy and integrity.
• Proficiently handled data requests by executing SQL queries in Oracle database environment. Responsibilities included retrieving, analyzing, and manipulating data to generate reports, fulfill ad-hoc data inquiries, and support business operations.
• Led the development of data pipelines using Oracle Data Integrator (ODI) to streamline data flow and facilitate efficient information exchange within the organization. Responsibilities encompassed designing, implementing, and maintaining end-to-end data integration processes to ensure seamless data movement across disparate systems.
• Conducted performance tuning and optimization to enhance pipeline efficiency, supporting both real-time and batch processing requirements.

Conducted extensive data analysis on various ad-hoc projects, analyzing trends using Python and SQL.

Developed interactive dashboards with Tableau, Dash, Plotly, to visualize key performance indicators and trends.

Conducted Exploratory Data Analysis (EDA) with Pandas and Seaborn to identify key trends and relationships.

Built predictive models using linear and ridge regression with Scikit-Learn, achieving high accuracy in forecasts.

Created visualizations using Matplotlib and Plotly to communicate findings effectively.

• Entered data into various computer systems accurately using Microsoft Office Suite.
• Created and managed weekly driver settlements using Microsoft Excel
• Updated and maintained Google Sheets with comprehensive truck status, including load details, pickup and drop-off routes, and associated freight companies.
• Generated load payment invoices and maintained an updated log in Google Sheets to track payment status for each invoice.
• Recorded and monitored credit card balances, truck service receipts, repairs, and associated charges.
• Oversaw and updated insurance coverage for each truck to ensure compliance and adequate coverage.