Lead, Database Architect/Analytics & Enterprise reporting | Administration of SAP B1 V10.00 FP2202

• Oct 2021 - Present

Lead , Enterprise Database Administrator

• Jan 2013 - Dec 2021

Supports Finance & Accounts department by implementing process workflow on SAP Business One that lead to automation of vendors payments process in such a way that ensured faster and effective payment processes, by eliminating duplicate, reduce bottlenecks, achieving auto-upload of payment data to the payment gateway and effective payment process for the organization. Successfully designed and implemented Database backup policy that encrypt database backup files, auto backup files daily and truncate file base on available HDD on host server without any interruption to operations activities. Planned, designed, implemented and manages SQL replication platform comprises of 84 subscribing DB nodes and master DB at HQ that replicate data in real time across high speed WAN network for effective operational activities. The real time data generated provides feasibility into activities at the downstream oil and gas sector of Nigeria where loading, transporting and monitoring of Petroleum trucks involves in distribution of petroleum products across Nigeria are tracked electronically. The data generated provides technical reports that helps in national planning. Worked with SAP vendor to designed and implemented SAP B1 add-on that factors in the peculiar Budgetary process requirements for public sectors which mandates government parastatals to operate zero based budgeting system. The add-on provides an added functionality that enable the ERP(SAP B1) to automatically keep tracks of expenses in relation to the actual, provision and expensed amount from the budget scenarios template. Responsible for identifying database requirements by relating closely with programmers and application developer; analyzing departmental needs, programming, and operations; evaluating existing systems and designing proposed systems. Recommends solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications. Show less

Lead, Network Infrastructure

• Jan 2010 - Jan 2013

Successfully led the team that Performs hardware, software and network upgrades from 6 block of IP to 12 Block of IP Addressing systems for the Company expansions and readiness for deployment of MS Windows 2008 Enterprise Edition based network.Successfully planned, designed and implemented the microwave/VSAT connectivity of 6 branches to Abuja HQ office that ensure availability of legacy software systems for the staff at the branch office for effective operational activities and presence across the 6 geo political zone of Nigeria.Successfully implemented DMZ (demilitarized zone) network that protect the organization core IT infrastructures systems against direct cyberattack hit from any untrusted network.Successfully implemented and configured VPN remote clients’ access on Cisco ASA 5510 device to enable foreign technical partners’ access application servers remotely.Successfully trained CRM staff on the use of automated finger print identification system (AFIS) to capture high quality thumbprint which facilitated a successful data cleanup exercise and increased chances of pin generation to 90%Successfully managed the IVR/PABX machine efficiently that led to reduction in telephone bills by 58% Show less

System Administrator

• Oct 2007 - Jan 2010

Trainee Network Engineer

• Feb 2004 - Sep 2004