Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Timeline
Intern
Francis Lawson

Francis Lawson

Accra

Summary

Efficient business intelligence and reporting solutions architect with comprehensive understanding of company database roles. Accessibility-focused data synthesizer with deep history of establishing well-organized and approachable information systems. Flexible program problem solver with collaborative outlook and agility in designing effective databases.

Overview

18
18
years of professional experience
1
1
Certification

Work History

Head Data and Insight

AirtelTigo Ghana
04.2022 - Current
  • Ensure data is provided within agreed timelines and that it is consistent with the sources
  • Meet and collaborate with business users on requirements, objectives and measures
  • Identify and propose Data Warehouse and Business Intelligence initiatives that provide high business value to the business
  • Evaluate new technologies and tools that will help increase visibility, facilitate usage and solve business needs
  • Manage the Data Warehouse and BI team by enabling a channel to exchange ideas, best practices and implementation, and ensuring the achievement of the objectives set for the department
  • Work closely with the regional and global teams to ensure alignment with the AirtelTigo DW/BI strategy
  • Coordinate resource staffing based on the current needs and future requirements of the operation

BI Lead

Surfline GHANA
08.2015 - 04.2022
  • Collecting and interpreting data
  • Analyzing results
  • Reporting the results back to the relevant members of the business
  • Identifying patterns and trends in data sets Working alongside teams within the business or the management team to establish business needs
  • Maintaining the DWH/Business OBIEE portal
  • Running of Adhoc reports using SQL/PLSQL
  • Developing new reports on the OBIEE using the OBIEE Analysis

BI Lead

IBM GHANA
03.2015 - 08.2015
  • Maintaining the Business portal Cognos for Airtel Ghana
  • Running of Adhoc reports using DB2
  • Developing new reports on the Cognos portal
  • Ensuring Data quality checks are done

Senior Data Warehouse Engineer

Tech Mahindra
05.2012 - 02.2015
  • Ensure the loading of all revenue streams into Data warehouse system
  • Develop checks and matrixes to correct all Exception during the Loading process
  • Perform Daily Data Quality checks on the loaded Data
  • Develop SSIS packages for the loading of CDR’s
  • Monitoring Jobs through the Agent Job Activity for 3 Tigo Telco countries
  • Note; Tech Mahindra DWH-team is supporting the operations of six(6) Tigo Telco countries through the BMC ticketing system.

Data Warehouse Engineer

MTN Ghana Ltd
12.2006 - 05.2012
  • Develops solutions and prepares new and Adhoc reports from Data Warehouse System
  • Prepare Daily, Weekly, Monthly reports and statistics for Excom “War Room” Sessions
  • Run day to day task and monitor Data Warehouse Systems performance
  • Participate in upgrades and expansions of Data Warehouse system
  • Monitor backup and recovery tasks for Data-Warehouse system
  • Applies changes requested by supervisor
  • Projects undertaken
  • Re-developing Surfline Oracle/BI –DWH application and generating standard reports for business
  • Analysing Surfline revenue reports Base on cell id, Site Names and developing trend analysis for usage congestion on various cell sites
  • Redefining Airtel Ghana NCA system base counts and generating new system base from April 2014
  • Creating and Reconciling 30 UAT reports during the implementation of MTN BI system

Education

Bachelor of Science - Computer Science And Programming

Kwame Nkrumah University of Science And Technology
Ghana
07.2005

Skills

  • IBM DB2
  • SQL Server Database
  • Critical Thinking
  • Database Design and Management
  • Data Warehouse Processing
  • Data Transformation
  • Data Mapping
  • Enterprise Resource Planning
  • Active Listening
  • Database Optimization
  • Excellent Interpersonal Skills

Accomplishments

Re-developing Surfline Ghana Oracle/BI –DWH application and generating standard reports for business


Analyzing Surfline Ghana revenue reports Base on cell id, Site Names and developing trend analysis for usage congestion on various cell sites


Redefining Airtel Ghana NCA system base counts and generating new system base from April 2014


Creating and Reconciling 30 UAT reports during the implementation of MTN BI system

Certification

Informatica (PowerCenter 8x Administration/Developer) PBT Informatica ETL 2 nd November 2009

Taming Big Data with MapReduce and Hadoop - Hands On!

The Ultimate Hands-On Hadoop - Tame your Big Data

UDEMY CredentialID: UCYTFRUQ7W UC-DBC7JZEI https://www.udemy.com/certificate/ March 2019-Jan 2020

Timeline

Head Data and Insight

AirtelTigo Ghana
04.2022 - Current

BI Lead

Surfline GHANA
08.2015 - 04.2022

BI Lead

IBM GHANA
03.2015 - 08.2015

Senior Data Warehouse Engineer

Tech Mahindra
05.2012 - 02.2015

Data Warehouse Engineer

MTN Ghana Ltd
12.2006 - 05.2012

Bachelor of Science - Computer Science And Programming

Kwame Nkrumah University of Science And Technology

Similar Profiles

CREATE PROFILE
Francis Lawson