Brian Ochieng Email & Phone Number

Nairobi, Kenya

Key Responsibilities:• Design, Develop, and maintain Current BigData pipelines achieving 99.9% service availability.• Innovate CVM solutions to improve customer experience using data.• Work closely with cross-functional teams to deliver CVM value to the business.

Nairobi, Kenya

Key Responsibilities:• Work with the business to gather requirements for data, and understand data sources from third party vendors.• Design and develop custom ETL, ELT and EL processes to pull data from different reliable sources and load it to target databases or systems. • Design and develop PL SQL queries for data analysis and reporting.• Develop data streams, data pipelines, API and plug to target systems.• Design Data Marts, Data warehouses and use best principles to clean, sort and push data.Key Achievements:• Integrated AIMS (data source) to target systems like OASES, MAYFLY, TM1 and fuel plus. This improved the airline's performance tremendously by ensuring effective invoice tracking, and accurate invoice payment.• Developed ETL python scripts to collect data from text files, JSON and rest APIs, CSV, and XLSX then ingest the data to oracle database tables.• Automated PGP encryption and transmission of confidential financial files to CitiSmart Match from Kenya Airways and Back using python and shell script.• Automated a process to write data to views which are used to perform financial reporting on a daily basis using PL SQL and python.• Supported Businesses with the right, clean, reliable and stable data for reporting as well as maintaining data pipelines with an uptime of 99.9%.

Nairobi, Kenya.

In my role, I work with a team that is responsible for developing custom web portals and data-driven solutions from user requirements using agile methodology. Most requirements come from business and others are developed by us from the user's story.Key Responsibilities:• Gather software requirements from end-users and the business team and break them down into milestones.• Develop web portals from the gathered requirements using Liferay.• Write test cases and test scenarios for the developed portal modules. • Write automation scripts, to automate repetitive processes.• Script PL SQL queries to generate business reports for business insights and analytics• Lead development of financial advisers payslip web portal.Key Achievements:• Developed Compliance module for Financial advisers and deployed to the FA Portal for production that improved Britam's Financial advisor's onboarding process and performance by 40%.• Script PL SQL queries to generate business reports for business insights and analytics.• Lead development of an automated mail sending service for Britam financial advisers and deployed it to production on a financial advisor management system.• Lead development of a java-based payslip module with Liferay and deployed it to production on the Britam fa portal.

Nairobi, Kenya

Developed Tamarix Ltd's official website. Designed and developed an official Tamarix support ticket web app for clients for tracking issues and fast resolution.Led Britam's financial advisor management system application cloud deployment on GCP. Developed analytics report for business insights platform for Britam Insurance.

Eldoret Kenya

Mobile and web developer.

Kenya

In my role;I developed flight booking payments tracking reconciliation reports, with python, shell scripting, and OracleDB. Reports were done in Tableau and data got from all supported Kenya airways forms of payments.I developed an Automated ETL process application with Python and Shell scripting.I developed warranty Tracker, an application that tracks airplane and plane equipment repairs process, manages spare parts orders records, counts man-hours, and manages work signoff for the technical workshop and mechanical department. Done in Laravel and Microsoft Active Directory LDAP.I developed an automated flight activity tracking dashboard in a team, that tracks inbound and outbound flights. Checks on flight delays and improves efficiency - Laravel frontend, Python, and shell scripting for the backend.

Nairobi

Setup, repair, configure ,offer DATA base support of the QMS , train other staff how to use the qms and always trouble shooting the system to check on the errors.

Data Engineering Nanodegree, Data Processing And Data Processing Technology/Technician

Activities and Societies: Innovate, solve problems.Learn Big Data engineering concepts. Develop Bid Data projects.

B.Sc Computer Science, Computer Science

Activities and Societies: innovation, Sports, SDG, Drone technology.Participated and won in innovation challenge sponsored by Intel.

Oracle Soa For Developers Certification., Oracle Soa For Developers

Activities and Societies: Application and implementation of SOA I development environment. Application of SOA in business.

Oracle Service Cloud Integration For Developers., Oracle Service Cloud Integration For Developers.

Training offered by Oracle in partnership with Kenya airways Implementation of Oracle service cloud for developers.

Backend And Frontend Development

Activities and Societies: Liferay development Community.Learn Backend and Frontend Development in Liferay.