Unlock this candidate profile
Sign up free as a recruiter to view the full CV, contact info and reach out to this candidate.
Skills
Experience
Data Engineer
Centennial Optical Limited
2019-08 -
Managed and maintained SQL Server data warehouses, achieving 99% system uptime and reliable reporting for business teams. Built and automated ETL pipelines using Azure Data Factory and PySpark, cutting data processing time by nearly 50%. Designed star schema models in Azure Synapse, significantly improving query performance for analytics workloads. Optimized stored procedures and indexing strategies, reducing average query latency and enhancing report responsiveness. Led migration of legacy SSIS workflows to Azure Data Factory, boosting platform scalability and lowering maintenance overhead.
Business Intelligence Analyst
VSF Consulting Inc
2018-07 - 2019-07
Designed enterprise data warehouses on SQL Server and Azure Synapse, streamlining data accessibility for reporting teams. Built interactive dashboards in Power BI and Tableau, providing executives with faster visibility into performance metrics. Developed ETL workflows using SSIS and SQL, improving data integrity and reducing recurring errors. Modeled tabular solutions in SSAS with DAX, enhancing forecasting accuracy for analysts. Collaborated with stakeholders to define KPIs and delivered BI solutions on schedule, improving report refresh times through indexing and incremental loads.
Senior Business Intelligence Analyst
Quest Advisory Services Limited
2016-05 - 2018-06
Gathered business requirements through use cases and workshops, strengthening stakeholder alignment across projects. Built SSIS ETL packages that loaded operational data into the Enterprise Data Warehouse with high accuracy. Implemented control frameworks and conformed dimensions, improving overall warehouse consistency. Applied slowly changing dimension (SCD) techniques to preserve historical data integrity. Created Power BI and Tableau dashboards that enhanced KPI visibility and accelerated decision‑making.
Business Intelligence Analyst
Albert and Benjamin Ross
2013-05 - 2016-04
Developed SSIS packages incorporating Lookup and SCD transformations, improving ETL efficiency. Managed SSRS report lifecycle processes, delivering dependable, easy‑to‑access reports for end users. Built dashboards in Tableau and Power BI that accelerated business decision‑making. Created standardized KPI dashboards that reinforced financial transparency across teams. Designed user‑friendly reports in SSRS and Power BI to support staff productivity.
Education
B.Sc., Electrical Electronic Engineering
Languages
English
fluent
Last updated: 1 week ago