Hello! My name is Leon, and I support individuals and businesses to achieve and exceed their goals. Professionals and business owners enjoy collaborating with me because I bring the best of services, resources, and methods to meet their needs.
My experiences reflect for delivering end-to-end big data service, developing valuable BI reporting solutions in Power BI and the Microsoft Data Platform stack to drive accuracy and process efficiency.
I am proficient at running successful process operations; advanced experience of entire Microsoft Data Platform Suite of products, including SQL Server, SSIS, SSAS, SSRS, Azure and Power BI SDLC from prototyping to deployment.
Recognised by my clients for strong knowledge of constructing Dataware house framework (DWH) and ETL solutions by using T-SQL and SSIS, based on Kimball methodologies.
I am trouble-shooter skilled in optimising query performance with complex measures to ensure excellent user engagement.
Tackle life and career management scenarios with meticulous strategies based on my major accomplishments in the following areas:
★ Led the development and enforcement of business initiatives to showcase Power BI as data modelling, data analysis and visualisation tool.
★ Created bespoke dashboards, DAX measures and data streaming for monitoring of business critical processes.
★ Maintained referential integrity across 30M+ rows of data and 127 tables by utilising SSIS, T-SQL, and C# to analyse and build end to end data migration from third party legacy system to in-house bespoke solution.
★ Decreased third party license fees by 21% by building standardised data model and enhancing SSRS/Power BI reporting functionality.
★ Delivered efficient and less convoluted reporting solution to business users through SSAS OLAP Tabular cubes integration.
Please feel free to contact me with any thoughts, comments, or questions about
my work. I look forward to hearing from you soon!