Business Intelligence A Team

Obafemi J Abiba

Cincinnati, OH

Have a background in Computer Programming, mathematics and statistics with over 15+ years of experience as a Team and Project Lead deploying SAS MLD, Anti Money Laundering, SAS Fraud and Arcsight SIEM solutions.

Professional IT career spans years of implementing and administering enterprise solutions as a consultant in over 12 EMEA countries across a broad range of key industries like telecoms, airline and mostly finance. This includes experiences of both hands on and project delivery.

Have experiences with data analysis, business intelligence and report writing, project & business management.

Training And Higher Education:

University of Lagos - BSc. (Hons.) – Mathematics and Statistics - CGPA 3.43/4.00

SAS South Africa 2009 - SAS Data Management; Platform Administration; Business Intelligence and Analytics

Splunk Fundamentals 1 & 2 training

Professional Certificates:

SAS® Certified Base Programmer for SAS®9

SAS Certified Advanced Programmer for SAS®9

SAS® Certified Platform Administrator for SAS®9

Oracle® Database 8i-11g Administrator Certified Professional

Sun® Certified System Administrator for Solaris (TM) 10

Splunk Certified User 6.x

Technical Skills:

Programming Languages : SAS, Java, SQL, SPLUNK,

Operating Systems : SunOS, HP-UX, Macintosh, Windows Servers, Linux 8.0

Databases : Oracle 8i -11g, SQL Server, MySQL

Web Technologies : J2EE, JBOSS, XML, DHTML, JavaScript, VBScript.

Other Tools : SAS Enterprise Guide, SAS Macros, XML mapper, SAS ECM, Workflow

Studio, Data Integration Studio for ETL, SAS Management Console, ODS,

SAS Scenario Administrator, MS Office (Word, Excel, Access), T-SQL,

PL/SQL; MySQL, SQL server 2008, Oracle Server administration

Professional Experience:

Fifth Third Bank/ TekSystems Inc. Nov 2023-Dec2024

Fifth Third Bank/Tata Consultancy Services, OH July 2018- Oct 2023

(SQL / ETL Developer) June 2020 – Dec 2021

(SAS Developer / Administrator) July 2018- May 2020

SAS AML Architect / Platform Administrator / Developer

Enterprise Risk Management

Ensure successful implementation of SAS Anti-Money Laundering implementations

Developed SQL scripts that ensure constraints check to flag and filter bad / unusable data from bank's daily transactions and ensures source to target comparisons.

Configured and developed programs to segment and filter customer transactions based on agreed rules in the business requirement documents.

Ensured data preparation from bank's multiple sources and incorporated ETL scripts to load daily transactional data into star schema database for analysis.

Created headers and defined various custom scenarios for finding suspicious accounts, customers and transactions; monitoring also of bank's employee's transactions, based on defined rules.

Generated customized regulatory reports in various formats like HTML, PDF, XLS & XML for respective banks to file CTR, STR reports.

Classified and segmented bank's products.

Analyzed reports using SAS ECM and SAS Scenario Administrator in compliance area.

Developed program to check bank's customers against different types of Global Sanction list and Watch lists in near real time.

Led team and projects, using Agile/Scrum, and provided support trainings on how to generate timely reports.

Safely handed over the technical processes to bank's support team around architecture, design, development, implementation and general maintenance of products and ETL scripts to support daily processes.

Responsible for installing, configuring and administering SAS platform on multi-tier servers and connect web servers.

Monitored logs; troubleshot servers and processes, including error messages and managed user access and OS permissions and maintain software process with GitHub.

Applied maintenance releases, upgrades and hot-fixes.

Configured business workflow with Workflow Studio and E-File submission through ECM studio.

Platform: Linux, DB2, SAS 9.4

AIG/Cap Gemini America Inc., Houston, TX June 2017-July 2018

Senior Consultant

Data Quality & Validation for ISO report

Data Driven Security, Insurance Firm

Prepare Information Security Office (ISO) report that provides a comprehensive view into a multinational insurance company’s security posture focusing on: Threat and Vulnerability Management (how vulnerable is the company?), Security Operations (how effective is the company's operations?), and Cyber Response (how well prepared to detect and respond to incidents?).

Prepare ISO reports for audit that will be consumed by BU CIO's and COO's

Aggregate Spunk's SPL and provide monthly reports

Analyse Configuration Management Database (CMDB)information about assets.

Analyse GEAR information about applications

Analyse Workers Data Store (WDS) information about staffs of the insurance firm

Identify gaps within data and analyse data assets

Performs analysis by correlating data from various sources

Communicate report findings and support discussions on strategy to SME's provide support for new analytic methods for detecting threats

Prepare automation of data collection and data analysis

Unit Testing and validation

Documentation on SharePoint Office 365 Enterprise E3.

Platform: Splunk, QlikView, SQL Server

Startup Hedge Fund (MCL Capital), NYC, NY July 2016-May 2017

Senior Analyst

Developed a business model for a start-up to trading options.

Integrated data from different sources around company earnings report

Analyse market based on public information and update charts.

Developed algorithm to analyse and predict earnings for each company traded

Automate routines that allowed to find strategies and best trades weekly

Design and deliver monthly performance reports

Resourcery PLC Mar 2012-Jun 2016

SAS Professional Service / Consultant for Banks Across EMEA

Employed Oracle database to create and maintain Data Marts from Data Warehouse.

Designed and developed data flows and ETL components.

Developed scripts for staging area from Production database and created adequate data marts.

Designed and supervised overall development of Data Mart and Oracle-hosted dimensional models.

Developed scripts that extracted reports from data mart.

Generated customized HTML, PDF, XLS & XML reports.

Created ETL designs and provided end users an easy accession to data marts.

Built and Customized Reports (like CTR, STR, FTR, SAR, FATCA) European & African Regulations

Troubleshot and resolved data model’s issues and formulated reports and analytical programs.

Tested, adjusted and monitored alterations in designs.

Documented data discovery, designs, patterns and mining projects.

Developed standardized metadata documents for ETL processes, Data Marts and Reports

Developed unit testing strategies and provided process improvements insight and requirements to end users

Responsible for installing, configuring and administering software on multi-tier servers

Monitored logs; troubleshot servers and processes, including error messages and managed user access and OS permissions.

Applied maintenance releases, upgrades and hot-fixes as required for different software products in any OS platform

Created headers and defined various custom scenarios for finding suspicious accounts and transactions; monitoring of bank’s customers and bank’s staffs, based on business requirement.

Classified and profiled bank’s customers. Generated and analyzed reports using SAS AML and SAS Scenario Administrator in compliance area.

Checked customers against different types of Global Sanction list and Watch lists (e.g. OFAC) in near real time.

Configured business workflow and integrated regulatory reports for various countries’ regulatory firm and E-File submission.

Resourcery Limited (Finance Industry) Apr 2009-Mar 2012

SAS Software / Data and BI Analyst / Senior Consultant

Team Size: >15

Implemented, configured and administered SAS anti money laundering solution in 5 different Groups of Banks, SAS Fraud and Risk solutions in three banks, and also Arcsight SIEM in 3 multinational banks.

Responsible for installing, configuring and administering SAS platform on multi-tier servers

Gathered requirements, designed, developed, extracted, transformed and loaded data processes to get meaningful information from data warehouses and created detailed reporting data marts for business reports and score calculations.

Provided technical leadership and training related to InfoTech team on architecture, design, development, implementation and general maintenance of SAS platforms and SAS specific products.

Deployed and configured SAS AML, ECM, Risk Profiling;

Monitored logs; troubleshot SAS servers and processes, including error messages and managed user access and OS permissions.

Applied maintenance releases, upgrades and hotfixes as required for all SAS products in the platform

Created headers and defined various custom scenarios for finding suspicious accounts and transactions; monitoring of bank’s customers and bank’s staffs, based on business requirement.

Classified and profiled bank’s customers.

Generated and analyzed reports using SAS AML and SAS Scenario Administrator in compliance area.

Checked customers against different types of Global Sanction list and Watch lists (e.g. OFAC) in near real time.

Generated customized HTML, PDF, XLS & XML reports using SAS Base/Macros/ODS

Configured business workflow with Workflow Studio and integrated regulatory reports for various countries’ regulatory firm and E-File submission through ECM studio.

Customized Reports (like CTR, STR, FTR, SAR, FATCA) European & African Regulations.

Platform: SAS / HP-Arcsight

Virgin Nigeria Airways, West Africa Region Feb 2007-Mar 2009

Second Level IT Support, I.T & Network Support

Maintained stable and optimal IT operations and network for an airline.

Ensured that all customer requests were closed on time or escalated where issues were pending.

Assigned responsibilities to Infrastructure support engineers or application developers if unresolved at first call.

Created, enabled and / or disabled all staffs network and email authorization requests from H.R and also from staff who needed password resets from LDAP directory.

Administered staff laptops to ensure the OS was working and had access to network.

Ensured that all phone lines were patched and worked efficiently.

Ensured availability of network across staff operations worldwide.

Reported and escalated network and server issues to the IT network manager.

Supported airport system; maintained ticket printers, bag tag printers and airline software.

Troubleshot customer requests via Phone and email from staffs and sales point worldwide.

Logged in daily requests in central database and ensured detailed reports weekly & monthly.

Contact this candidate