I'm Data Enthusiast
Dexter Alcani

I’m a certified Business Intelligence and Data Warehouse Consultant with over 8 years of hands-on experience, having led 15+ full-lifecycle implementations across diverse industries — from Energy Trading and Financial Services to Parcel Delivery, Construction, the Public Sector, and Aviation..

Dexter Alcani 2019 1024x768

About Me

Data is my passion.

With extensive experience in global collaboration, I’m ready to take on your project—no matter where you are in the world.

I help my clients make informed decisions that drive business growth and performance by transforming data into meaningful insights and actionable knowledge. As a consultant, my vision is to share expertise and grow alongside my team—applying the leadership and training skills I’ve developed over the years.

section 1 bg1

Working Process

Develop any business by analyzing data.

Work Experience

Services that I offer in my work.

DWH Consultant
2015-2018
  • Enhancing Stability: Enhanced an analytical application to address security breaches, significantly improving system stability and performance.
  • Optimizing Performance: Optimized load times and application efficiency, resulting in smoother operations and enhanced experience
  • Elevating Data Quality: Led initiatives to enhance data quality, reducing the time to close user requests and bolstering data integrity across the board.
  • Agile Methodology Practitioner: Advanced the use of Scrum methodologies within the project, enhancing team agility and project delivery effectiveness
  • Key Skills Developed: Performance Optimization, Data Quality Management, Security Analysis,  Agile Project Management, Stakeholder Communication.
DWH Consultant
Data Engineering
2022-2025
  • Data Reconciliation Innovations: Initiated the development of scripts for IFRS17 financial data extraction and reconciliation, enhancing reporting accuracy and efficiency.
  • WhereScape Mastery: Leveraged WhereScape to automate complex data tasks, significantly improving agility in IFRS17 reporting processes
  • Auditor Approval: Developed data scripts adopted by KPMG, validating the effectiveness and reliability of the reporting framework
  • Performance Optimization: Reduced Snowflake processing time by 70% and compute costs through advanced query optimization, warehouse tuning, and dbt model refinements.
  • Data Quality Excellence: Elevated data quality metrics by implementing automated testing frameworks using dbt tests and custom Snowflake procedures.
  • Key Skills Developed: Snowflake Optimization, Data Quality Engineering, Cost Management, dbt Best Practices, Data Vault 2.0 Implementation. Community Building, Customer Journey Optimization, Technical Leadership, Effective Communication, Stakeholder Engagement.
Data Engineering
Data Automation
2019-2022
  • Community Engagement & Enablement: Championed the growth of WhereScape’s user community through the organization of user groups, webinars, and instructional content. Successfully boosted community interaction and product knowledge.
  • Customer Journey Facilitation: Drove the customer experience from discovery through to support, including demos, POC planning, MVP delivery, onboarding, training, coaching, and technical assistance, ensuring a seamless transition at each stage.
  • Effective Stakeholder Communication: Mastered the art of presenting complex data automation concepts to a wide range of audiences, from technical staff to executive-level stakeholders, enhancing client engagement and understanding across diverse sectors.
  • Developed Custom API Integrations: Spearheaded the creation of plugins via VaultSpeed’s API, enabling tailored data extraction solutions that met specific client needs and enhanced product utility. 
  • Provided Expert Technical Support: Offered dedicated support to clients, solving complex technical issues to ensure seamless integration and optimal use of automation tools
Data Automation

What People Say

People opinion about me and my work.

Thomas Haydon

Alex is a very technically able resource who is capable of leading, guiding and mentoring other team members. During the time Alex worked for me he was always the go-to person for deep technical issues such as performance optimization and resolution of complex design issues. He was a popular member of the team and was well regarded by others and showed great care for his co-workers. He demonstrated on numerous occasions the ability to pick up new skills and apply them immediately. I would recommend Alex in any complex DWH project.

Thomas Haydon
Boney Varghese

It’s rare that you come across a standout talent and a mentor like Alex. I had the pleasure of working with Alex for almost 3 years at Uniper, collaborating on several development activities. I was particularly impressed with his eagerness to learn a new skill/enhance his existing skill-set and also with his efforts on self improvement. His performance optimisation techniques were legendary! He is also a great team player and has compassion for his co-workers. We always looked forward to Monday mornings thanks to his baked goodies! Alex would be a great asset to any complex DWH project and has my highest recommendation.

Boney Varghese
Sneha Manandhar

It was a delight to work with Alex in Uniper BI project. He has very good understanding of the BI Systems and landscape. He has right attitude towards his assignment and has always provided his valuable consultation to resolve many issues related to performance enhancement in the ETL processes. Alex is surely people’s person, strategic, technically equipped person and great team player. I would always positively recommend Alex to companies. He would be a great asset to any company.

Sneha Manandhar

Stay In Touch