J

James Oluwafemi

About

Detail

Lagos, Nigeria
Contact James regarding: 
work
Full-time jobs
Starting at USD15/hour
groups
Networking

Timeline

work
Job
school
Education
folder
Project
flag
Award

Résumé

Jobs verified_user 0% verified
  • T
    Microsoft Office MIS Manager
    Tangerine Life,
    Jan 2021 - Dec 2022 (2 years)
    • Developed complex SQL scripts for data extraction and integration as required by the business. • Developed dashboard and Decision Support System (DSS) for performance measurement and decision making. • Collating data such as monthly dashboards, prospect tracking, leads conversion Enterprise tracking, numbers tracking, overlaps, premium collection, etc. for performance analysis. • Managed ETL projects, reporting, and visualization • Budget planning, monitoring, control, and reporting utilizing the ERP. • Handled the automation of finance and operation reports, which takes away reporting from Ms-Excel to proprietary applications. • Successfully migrated Sage ERP data using ETL tools (SQL scripts, SSIS, and MySQL workbench) to Dynamic
  • M
    Management Information System Manager
    Metropolitan Life Insurance Ltd,
    Jan 2010 - Dec 2020 (11 years)
    • Initiated and developed various information system optimization for finance and operations that resulted in 95% efficiency and effective delivery of information to end-users and subscribers for information. • Designed monthly performance dashboards and report templates, prospect tracking, leads conversion tracking, numbers tracking, overlaps, premium collection ratio (PCR), etc., for performance analysis. • Developed complex ETL and SQL script for regular and ad-hoc reporting. • Designed, executed, and managed the business Data Warehouse (DWH) project that reduced operation costs by 30%, improved revenue by 45%, and reporting and analysis by 80% • Managed the Enterprise Resource Planning (ERP) suite with more than 95% efficient us
  • L
    Senior Consultant
    Lagetronix Nigeria Ltd,
    Apr 2007 - Dec 2009 (2 years 9 months)
    • Participated in presales and marketing activities that won many projects • Led team of consultants on pre-implementation documentation: functional and technical requirements documentation on many successful projects. • Led team of consultants, programmers, and analyst in the design and implementation of enterprise-wide solutions for clients. • Post implementation support and training for new and existing clients. • Successfully implemented ERP solutions for LADOL FTZ (logistics, oil and gas and construction), which was the biggest in Africa for Sage in 2009. • Designed report templates for clients that improved clients' financial and operation reports by more than 95%
Education verified_user 0% verified
  • S
    Analytic Cloud - BI Expert
    SAP University
    Apr 2022 - May 2022 (2 months)
  • University of the People
    Associate Degree
    University of the People
    Apr 2021 - Current (5 years 3 months)
  • M
    Microsoft Certified Solution Association (SQL Server)
    Microsoft University
    Jun 2014 - Apr 2015 (11 months)
  • A
    Advanced Diploma (Business and Accounting)
    Association of chartered certified Accountant (ACCA)
    Dec 2011 - Jun 2017 (5 years 7 months)
  • Lagos State University
    Bachelor of Science
    Lagos State University
    Apr 2009 - Dec 2009 (9 months)
Projects (professional or personal) verified_user 0% verified
  • T
    Legacy Policy
    Tangerine Life
    Dec 2024 - May 2025 (6 months)
    The project involves the migration of legacy policyholders' details and financial information with Tangerine over the years from a crashed database to an on-prem SQL server, connecting the server to the Microsoft PowerApps cloud using a gateway, and the design of a frontend for premium collection, claims payment, actuarial valuation, and reports.
  • Metropolitan Life
    Metro-Life Data Warehouse
    Metropolitan Life
    May 2019 - Oct 2019 (6 months)
    The project brought together different data silos in the organization in a data warehouse for dashboarding, reporting (regular and ad-hoc), and analysis. Data from the Core Business Application, the ERP were, and other silos were harmonized and normalized on the DWH. Triggers and scheduled jobs update the tables with a carefully designed latency parameter that balances performance and workload.
Awards verified_user 0% verified
  • Metropolitan Life
    Certificate of Recognition
    Metropolitan Life
    Jun 2019
    Recognition for the successful implementation of data warehouse project.