About Leonard Letsoalo:
Business Intelligence Developer
SQL Developer
3years experience
Experience
- Created numerous cubes for the old and new plant including Production cube, Transfers cube, Packs cube, Stock Reconciliation, Pallet movement etc. from several sources to staging to Datawarehouse and finally analysis model.
- Migrated the Finance cube from multi-dimensional to tabular which improved the ETL’s processing time down to a steady 20 minutes from an average of 1 hour and improved the users refresh time from 1 minute average to 10 sec.
- Resolved the granularity of the sales cube from the highest level to the lowest level. This was critical because users had to break down the measures in excel before advancing to their reporting.
- Created an SSRS trips efficiency report which helps senior manager to investigate inefficient trips, So they may take necessary steps to avoid inefficient trips by planning the trip ahead.
- Best dedicated flexi worker - 2016
Education
NATIONAL HIGHER CERTIFICATE: IT SYSTEMS SUPPORT NQF Level 5
Year Obtained: 2015
MATRIC: Ivory Park Secondary School
Year Obtained: 2006
