SEBASTIAN TEMITOPE OGEYINGBO
BSC. COMPUTER ENGINEERING, SYBASE CERTIFIED PROFESSIONAL
Address: 4A Ajidagan Street Gbagada Estate Phase I Gbagada Lagos Nigeria
Mobile: -
E-mail-
PROFILE
Experienced C++/Java Developer, Data Architect and certified Database Administrator with over 15
years of experience in:
-
-
Software Engineer C++/SQL at Crossover
C++ development using Qt.
Java Development using Spring/Avaje Ebean/Maven/Eclipse/JavaScript
Data center operational support.
Experience with Sybase ASE 12.x and 15.x performance tuning and administration up to Sybase
ASE 15.7, and Oracle 11g,
Experience with integration of heterogeneous technology environments as well as maintaining
and managing coexistent multiple generations of technology in an enterprise datacenter
environment.
Extensive knowledge of backup, restore and archival technologies, including Bacula on Linux.
Shell scripting knowledge and automation of repeated tasks using scripts.
OS hardening & Implementation of security patches.
Managing disk space, processor utilization, network utilization related to server.
Implementing Hardware and Software RAID levels through Linux LVM.
Experience with VMWare virtualization.
Database patch management on linux and UNIX Systems.
Processing and resolving support service requests and evaluating and reporting system
performance.
Experience in developing and supporting disaster recovery architecture, strategies, and
implementations.
Implementation of databases and database management practices in retail banking environments.
Capacity planning and performance tuning of database servers
Ability to work in a 24/7 environment.
Most challenging projects to date
1. Development of a high-speed SMS messaging application in C++
2. Migrate Data Information Warehouse to PostgreSQL Database
3. Migrate Master Data Management Suite to Visual Studio 2015
4. Development of online portal for real estate management
5. Consolidation of 10 years of historical data from diverse sources into a single database for a
150-branch retail bank.
6. Integration of various components(VS, SDP, MINSAT) within the MTN IN-Prepaid Network to
reduce service desk calls and improve operational reporting to the business.
7. Migration of 200GB Sybase ASE database (200-branch retail bank) from 2k page size to 8k page
size without significant downtime.
8. Capacity planning and hardware design for OLTP and DSS for a 50 branch retail bank running on
Sybase ASE 12.5.
9. Centralization of 17GB imaging database using Component Integration Services (CIS)
10. Upgrade of a retail banking application and database from Sybase ASE 12.0 to Sybase ASE 12.5.
Page 1 of 7
Details on most challenging project: SMS Messaging Application for Cellulant.
Cellulant, a mobile-commerce company required an SMS messaging application for high-speed delivery
of bulk SMS messages. I was able to deliver the application with the ability to submit over 1,000
messages per second to the EMG SMS gateway.
Page 2 of 7
TECHNICAL SKILL SUMMARY:
Operating systems:
IBM AIX , Linux, Solaris, Windows 2000, Windows Server
Middleware Server Systems: Apac he Tomcat, Spring.
Languages:
Java, C++, C, C#,Transact SQL, UNIX shell scripting (sh, bash)
Databases:
MySQL, PostgreSQL, Sybase ASE, Sybase SQL Anywhere, Microsoft
MSSQL, Oracle 11g.
Network Connectivity:
TCP/IP
Software/Desktop:
Crystal Reports, MS Word, MS Excel, MS Outlook, MS Project
IDE
Eclipse, DBArtisan
Hardware: IBM p-Series, HP Proliant, SAN/NAS Storage.
Page 3 of 7
EMPLOYMENT HISTORY
Software Engineer C++ SQL
June 2016- Date Crossover for Work
Deputed to Magnitude Software, I was part of the team that migrated MDM and DIW to Visual Studio 2015
from VS 2010. The project involved converting C++ and C# code to run in VS 2015 environment.
Project Examples:
1.
2.
3.
4.
5.
Migrate Data Information Warehouse (DIW) to PostgreSQL (C++)
Upgrade performance testing suite to support PostgreSQL (C#)
Migrate Master Data Management (MDM) to VS 2015 (C#)
Fix bugs in the codebase of MDM (C#)
Develop additional functions for input data transformations (C#)
Java/C++ Developer/Sybase DBA/Data Architect
Feb 2014- June 2016 Sebastian Consulting
Sebastian consulting is a sole proprietorship. I was assigned a few projects to design data management
architecture for backend, embedded and payment terminal databases and manage field deployments.
Project Examples:
6. Development of a high-speed SMS messaging application (Cellulant 2015)
7. Development of online portal in java/spring/avage ebean/maven/javascript.
8. Performance Tuning of Sybase ASE/Equinox Banking System (Centenary Bank Uganda, November
2014).
9. Embedded Systems Development (Cellulant Nigeria, April 2014)
The client commissioned the development of card authenticated payment terminal application
development in C language on BITEL5100 terminals for communicating with e-wallet.
Sybase DBA/Java Developer
August 2013- Jan 2014
gTeam FZ LLC/Freelance
gTeam FZ LLC is a Software Development company with multiple locations around the world.
My duties, through tele-presence, include:
- Automation of Sybase & Oracle installations using shell scripts
- Database migrations for multiple software products
- Automation and shell scripts.
Data Architect
January 2012 – September 2013
Freelance/Contractor
Project Examples:
10. Database Performance Tuning (FINCA Uganda & DRC, April 2013)
The client commissioned a review of EOD processes in order to reduce the time taken and to provide
more efficient processing during transactions. We were able to successfully migrate the database to
4k page size and to reduce the total time taken from 2.5hours to 1 hour.
11. Database Performance Tuning(CRDB Uganda, September 2012)
The time window for running EOD processes was becoming upwards of 6 hours.
The project was commissioned to tune the database without hardware changes. The result was the
reduction of EOD processing time to 3 hours.
Page 4 of 7
12. Disaster Recovery (Tanzania Postal Bank, Tanzania, May 2012)
The client experienced an outage on its centralized retail banking database due to data corruption. The
system was recovered within a few days and the client was able to resume operations without data loss.
13. Mobile Money System Review ( Cellulant Nigeria Limited, February 2012)
The client commissioned a system review in order to ensure preparedness for licensing requirements
of its mobile money system. My achievement consists of providing change management and disaster
recovery procedures. The company organogram was also reviewed during the project.
Consultant
February 2008 – December 2011
Information Engineering Technologies Ltd
Information Engineering Technologies is a systems integration company that ensures the proper interfacing
of all information technology infrastructures within the operating environment of clients in the banking
industry. As consultant to Stanbic IBTC Bank PLC, Nigeria, a subsidiary of Standard Bank of South Africa,
we were able to implement policies and procedures for the effective management of database infrastructure
and the improvement of space utilization by automating the archival of historical transactions.
Project Examples:
1. Data Warehouse Project (Stanbic IBTC PLC, Nigeria,-)
Data warehouse project delivered for 10 years of historical data consolidated from several versions of
Sybase ASE spanning 5 data silos and several versions of a single application. The data was consolidated
into a single SQL Server database such that all ledger and customer transaction reports are obtainable up
to the last end-of-month, thus saving time and expenses in the maintenance of obsolete server hardware
and software and in the maintenance of redundant storage.
The data warehouse assisted in the post-migration support to a new banking system, ensuring easy
reconciliation, operational analytics and reduction in reporting fraud.
2. Database Performance Enhancement Project ( Stanbic IBTC PLC , Nigeria,-)
Database tuning project delivered a process for assessing end-user turnaround times and system
availability for the purposes of fine-tuning the retail banking database infrastructure for optimal
performance. Part of achievements was the reduction of nightly batch processing time from 2.5 hours to
1 hour and the reduction in customer-facing turnaround time for tellers and cheque processing staff.
Consultant
February 2005 – December 2007
Freelance/Contractor
Project Examples:
1. Database Performance Enhancement Project (Bank PHB, Nigeria, 2007)
Database tuning concluded within four weeks for a Bank PHB without downtime and significant time
window reductions for end-of-day batch from 5 hours to 3 hours. After the exercise ATM hangs and
locking issues were also resolved.
2. Data Integration Project (IN-PREPAID MTNN Nigeria, 2007)
In this role, I was assigned to solve pending voucher issues which result when Voucher Server fails in
communicating prepaid voucher status over AIR (Account Information Refill system). I was able to
integrate MINSAT and Voucher Server so that pending vouchers are filtered and resolved through daily
batch processing. This reduced the number of calls to customer support by 30%.
3. Database Management & Standardization Project (Intercontinental Bank, May 2005)
This role entails the standardization of the maintenance of processes and procedures of all Sybase ASE
Page 5 of 7
12 database servers within the organization. This has led to a dramatic improvement in configuration
management, the reduction of batch processing time from 4 hours to 2 hours, the complement
elimination of daytime lock contention and the reduction of operational accidents by 70%.
4. Capacity Planning Project (Centenary Rural Development Bank Uganda, Sept 2005)
I was assigned to analyse the Bank’s operational requirements in terms of the maintenance windows of
database-centric business processes and to advise on hardware and software to be purchased to meet
these requirements.
5. Data Port Project (Zenith Bank, August 2005)
This role entails the testing of the Phoenix Banking System on Linux. I was assigned to automate the
procedure to port all the data from a 60GB Sybase ASE 12.5 database on AIX 5L/p590 to Sybase ASE
12.5 on Linux/x86 and to certify the port process. The port methodology that was adopted ensured that
all data could be ported from the source database to the target database in less than 6 hours. The data port
process was automated using MS DOS scripts.
Lead Database Administrator June 2000 – February 2005 Computer Systems Associates Ltd
Computer Systems Associates Ltd (Partner to Neptune Software Plc UK, Kenya) is a Banking Applications
Vendor with over 100 consultants supporting the Equinox Banking System. Within one year of joining the
company, I was able to solely migrate the Phoenix/Equinox Banking System from Sybase Adaptive Server
Enterprise 11.0 to Sybase Adaptive Server Enterprise 12.0. The milestone, which was achieved within a
period of two months, lead to an improvement in the daytime processing of transactions by existing
customers, thus enabling the company to broaden its customer base by 50% within the subsequent year.
Project Examples:
1. Performance Tuning Project (Centenary Rural Dev. Bank Uganda, Sept 2004)
Under the initiative to reduce the time taken by nightly processing in order to ensure that it fits into the
allotted time window, I was responsible for improvements that lead to the reduction of time taken from
over ten hours to under three hours within two days of the assignment.
2. Performance Tuning Project (Housing Finance Kenya, August 2004)
Under an initiative to optimise the backend data processing environment, I was assigned to evaluate the
bank’s processing needs and automate database maintenance procedures using UNIX KSH scripts
(HP-UX 11i) and MS DOS scripts to keep performance optimal.
3. Data Migration Project (Africa International Bank Nigeria, August 2003)
My role was one of data migration consultant. Requirements were issued for the migration of 30GB
production database from Windows to Tru-64 UNIX. The following tasks where carried out:
● Install Sybase ASE 12.0 on target production system
● Write UNIX/T-SQL script to automate the data migration process.
● Verify the process by test-run, and correct problems.
● Migrate data and verify operation of applications
● Optimise the data processing environment
4. Data Migration Project (Centenary Rural Development Bank Uganda, 2002)
My role was one of database implementation consultant. Requirements were issued for the migration of
newly converted data from the conversion platform (Sybase SQL Server 11.0 on Windows) to the
production platform (Sybase ASE 12.5 onTru-64 UNIX). The following tasks where carried out:
● Install Sybase ASE 12.5 on target production system
● Write UNIX/T-SQL script to automate the data migration process using the bulk copy method.
● Verify the process by test-run, and correct problems.
● Migrate data. Verify operation of applications, and optimise the data processing environment
Page 6 of 7
EDUCATION & QUALIFICATIONS
2003
Sybase Certified Professional (Sybase, Nigeria)
- Examination Sybase Certified Associate (ASE 12.0) passed 83%
- Examination Sybase Certified Professional (ASE 12.0) passed 80%
1998
Bachelor of Science, Computer Engineering (Obafemi Awolowo University, Nigeria), 2nd Class
Upper, 5 years
- Project: Design and implementation of programmable logic algorithms
Page 7 of 7
