Kevin Le Email & Phone Number

Vancouver, Bc, Ca

Vancouver, British Columbia, Ca

Vancouver, Bc, Ca

● Part of 3-person BI team that looks after all aspects of the data warehouse and reporting; providing BI solutions for all departments across the business in North America● T-SQL - building efficient and maintainable queries, stored procedures, indexes, functions and views● Built key business fact tables including sales and transactions; cleansed bad data and did reconciliation to ensure any variance could be fixed or explained, improving user trust and having a single “point of truth”● Building SSIS packages for various data pipelines and processes; imports and exports between SFTP servers and data warehouse, refreshing data cubes, and generating files formatted in CSV or XLSX● Built 50+ SSRS reports for different departments across the business: Retail, Finance, Digital, Demand Planning, Manufacturing, Inventory, Payroll, IT; building from a report spec or collaborating with users to come up with an effective reporting design and solution● Building and maintaining a tabular cube with 170+ tables using SSAS; wrote DAX measures commonly used by business users and did partitioning to optimize processing● Automating data check alerts in SQL to ensure high accuracy; providing early detection of problems and reducing overhead time by getting information directly to teams who could action it● Led team in scoping risk and impact of production changes; identifying objects that need to be updated and coordinating work with team members to get it done● Built interactive reports and dashboards with Microsoft Power BI; wrote training documentation and conducted Power BI training sessions for non‑Technology staff● Relied upon for debugging and resolving urgent data issues; reconciled variances between tables and other data sources, able to thoroughly track a problem to the source, document and explain it

Vancouver, Bc, Ca

● Worked closely with DBAs; developing SSRS reports, T-SQL queries, and setting up ETL processes in the data warehouse● Built the first OLAP cube for the business; encouraging self-service and reducing number of ad-hoc report requests sent to the team