Business Intelligence Consultant
Current• Documented a series of use case scenarios for a Toronto Hydro dashboard outlining and reporting all possible use cases and their corresponding actual versus intended results• Collaborated in the development of Toronto Hydro and Swiss Avenue Partners dashboards mainly providing necessary enchantments and quality assurance in accordance with writing proper functional and business requirement documentations • Written five instructional blog articles at www.davidlai101.com/blog containing solutions and workarounds to user encountered problems with SAP Business Objects Information Design Tool, Design Studio, Dashboards and Web Intelligence software• Implemented and written a beginner’s setup guide for a Business Objects environment with client machines and a server that authorized certain Windows Active Directory logins to single sign on to Business Objects• Used VBA to developed an Excel program including a simple user interface to allow exporting of multiple Excel spreadsheet data into properly formatted XML files that were integrated within a dynamic dashboard to meet the client functional specifications