Keith Tham Email & Phone Number

Richmond, British Columbia, Canada

• Develop data, reporting and BI solution requirements with internal clients across a business portfolio currently including Health Care, Finance, IT and extending to Assessments. • Develop, modify or enhance SQL based business ad-hoc reports and Business Intelligence solutions for operational applications and analysis. • Utilizing a variety of software platforms including: Power BI, Webi, SAP Crystal, Tableau, Excel with data connection capabilities as well as custom conditional email alert solutions via a SharePoint server.• Taking a hybrid Agile approach, have learned to apply the use of Azure (DevOps) Board as a key tool to organize and manage requests that come to the Business Intelligence and Analytics Department.

North Vancouver

• Establish MS Access database and created custom VBA scripts to automate importing newly standardized QuickBooks Excel reports submitted by 75+ internationally located franchises to significantly improve data integrity and reporting efficiencies. • Develop Finance audit tool to reconcile projects against royalty payments uncovering missed revenue.• Implement company-wide complete Smartsheet solution for Employee Expense approval and re-imbursement workflow and digital archiving of all receipts and transactions.• Customized Excel revenue forecasting commitment tool, using Salesforce data, scalable across franchises.• Customized Excel contract template generation tool automatically using Salesforce data.• Define business requirements to transition accounting system to QuickBooks Online to capitalize benefits of Qvinci for consolidated BI across international franchises.

Yvr Airport

Business Consultant, Nikanna Consulting Inc.Business Analyst• Document creation of 2018 thru 2020 Operational Parking Plan as YVR transitions from the present Value Lot closure to a new Long Term Value Parking lot located near McArthur Glen shopping outlet center.Project Team Lead• Expand YVR’s online pre-booking reservation system to bring additional upgrade parking product offerings for the Vancouver Airport Value Lot and Parkade locations.Project Team Lead• Implemented online e-commerce booking system with multi-product cross-sell functionality that is scalable and provides customers a seamless single payment experience but split fund settlement functionality. Book your lounge today http://www.yvr.ca/en/passengers.• Define business requirements to meet unique YVR conditional revenue constraints and coordinate internal departments, developer, payment service provider and external vendor to meet objectives to successfully deliver an e-commerce scalable solution.Project Team Lead• Execute the administration for the TransLink Compass Card program for the Vancouver Airport Authority (YVR) and its business partners/tenants on Sea Island to provide employees economical transit options.Business Analyst• Provide operational review and documentation for YVR’s newly implemented Parking Token equipment.• Provide operational process assessment and recommendations for Parking Ground and Transportation administration and curbside operations at YVR to expand capacity and improve efficiencies.• Created data logging tool for control room operators to reduce errors, improve data integrity and improve reporting capability.

12091 88Th Avenue Surrey Bc

Ever challenging newspaper manufacturing facility for the daily printing of the Vancouver Sun and Province newspapers. As Project Manager for the automated roll logistics project I gained valuable experience in resource planning, multinational communications, managing budgets, time management and commissioning. On-going responsibilities as Production Data Systems Manager and Newsprint Logistics Manager allowed me to work on continuous improvement projects in data warehousing, JIT supply chain management, financial budgeting, statistical analysis, forecasting models, and business intelligence modelling.

Bachelor'S Of Technology (Btech), Technology Management, W/Distinction

• Digital Strategy, Innovation and Entrepreneurship • Strategic and Tactical business use of Technology • Marketing Research and Analysis.

Diploma, Operations Management

• TQM Method Study, Theory of Constraint and Continuous Improvement Methodologies • Business Analysis and Process Control Expertise •.