Leonard Letsoalo

Business Intelligence Developer 

SQL Developer

3years 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 

NATIONAL HIGHER CERTIFICATE:                IT SYSTEMS SUPPORT NQF Level 5                                                                                                           

Year Obtained:                                     2015                                               

MATRIC:                                             Ivory Park Secondary School                                                                                            

Year Obtained:             2006