WILLMA - Cloud Engineering, Big Data & Business Intelligence

A brief overview

WILLMA is a consulting firm specialized in Cloud Engineering, Big Data, and Business Intelligence. With over 25 years of experience, we help businesses modernize their cloud infrastructure, engineer scalable data solutions, and turn their data into actionable insights for sustainable growth.

Why choose WILLMA?

Proven Experience: 25+ years in software development, specialized in Cloud Engineering, Big Data, and modern data architectures.
Cutting-Edge Technologies: Mastery of GCP, Azure, Kubernetes, Terraform, ArgoCD, Databricks, Power BI, and advanced cloud platforms.
Personalized Approach: Solutions tailored to your specific needs, with technical and strategic support.
Mentoring and Training: Knowledge sharing and development of your team's skills.

Services

We offer a complete range of services to help your business fully leverage the potential of your data and achieve your strategic goals through cutting-edge technologies. Discover what we can do for you:

Data Engineering and Big Data

Large-Scale Data Analysis: Real-time processing of large data volumes with Spark, Kafka, and Databricks.
Modern Data Architectures: Design of medallion architectures, data lakes, and data warehouses.
Cloud Migration: Infrastructure migration to Azure, GCP with IaC and Kubernetes.
ETL/ELT Automation: Development and optimization of ETL/ELT pipelines with Azure Data Factory, SSIS, and Databricks.

Cloud and Platform Engineering

Infrastructure as Code (IaC): Cloud infrastructure provisioning and management with Terraform and Crossplane.
GitOps & CI/CD: Continuous deployment of Kubernetes applications with ArgoCD and GitHub Actions.
Monitoring & Observability: Prometheus/Grafana stack setup for application monitoring, alerting, and SLOs.
High Availability Web Applications: Deployment of applications (Drupal, CKAN) on GKE in HA configuration.
Cloud Migration: Migration from Azure to GCP and multi-cloud Kubernetes environment design.

Business Intelligence and Visualization

Data Modeling: Creation of tabular and multidimensional models with Azure Analysis Services and SSAS.
Interactive Dashboards: Development of reports and dashboards with Power BI, SSRS, and DAX/MDX measures.
Performance Optimization: Query improvement, indexing, and resource monitoring.
CI/CD Integration: Automation of deployments and version management with Azure DevOps.

Consulting and Support

Team Mentoring: Support for junior developers, code reviews, and training.
Strategic Consulting: Needs analysis, design of customized solutions, and technical support.
Specialized Projects: Development of custom solutions for data marts, OLAP cubes, and APIs.

Marketing and Communication Services (in partnership)

Social Media - Organic Content: Creation and planning of organic posts for social networks (LinkedIn, Facebook, Instagram, X).
Social Media - Paid Advertising: Management of paid advertising campaigns on social platforms with advanced targeting.
Google Ads & SEA: Management and optimization of Google AdWords campaigns to maximize ROI.
Content Writing: Creation of posts, blog articles, and SEO-optimized web content.
Visual Creation: Custom PowerPoint presentations, infographics, and visual materials.
Administrative and Accounting Services: Project deliverables management, tracking, bookkeeping, and accounting clerk services.

Contact us

For more information about our services or to discuss your specific needs, please don't hesitate to contact us. We would be delighted to collaborate with you!

About

William Martin - Senior Developer in Cloud Engineering, Big Data & BI

WILLMA is a consulting firm specialized in data engineering and business intelligence, offering cutting-edge services to businesses looking to fully leverage their data potential. Our team of experts has over 25 years of combined experience in software development, with 15 years specialized in the design, implementation, and optimization of large-scale data solutions.

Our Mission

At WILLMA, our mission is to provide innovative and personalized solutions that transform data into actionable insights and help businesses achieve their strategic goals through cutting-edge technologies.

Expertise

Our team has worked for prestigious organizations such as the Autorité Régionale du Transport Métropolitain (ARTM), the Commission de la Construction du Québec (CCQ), and Hydro-Québec. Our expertise covers the entire data spectrum: from Big Data engineering to business intelligence, including cloud architectures and advanced visualizations.

Our Values

Innovation: We believe in the importance of innovation to stay at the forefront of data technologies.
Transparency: We value transparency in all our interactions and collaborations.
Commitment: We are committed to providing high-quality solutions and exceeding our clients' expectations.
Mentoring: Knowledge sharing and support for teams' professional development.

Contact us

For more information about our services or to discuss your specific needs, please don't hesitate to contact us. We would be delighted to collaborate with you!

Expertise and Achievements

Our team of experts has participated in complex projects for major organizations in Quebec, bringing our expertise in data engineering and business intelligence.

Large-Scale Data Engineering Projects

Autorité Régionale du Transport Métropolitain (ARTM)

Research and development for 4 analytics teams, leading Spark/Kafka/Databricks solutions for real-time processing of large data volumes.
Deployment and management of open data web applications (Drupal, CKAN) on GKE with Terraform (IaC), in high availability (HA) configuration.
Implementation of GitOps CI/CD pipelines with ArgoCD for continuous deployment of applications on Kubernetes.
Implementation of application monitoring and observability with Prometheus and Grafana (dashboards, alerts, SLOs).
Migration from Azure to GCP and management of Infrastructure as Code projects.
Technical support and guidance for teams on new technologies.

Technologies: Azure, GCP, Kubernetes (GKE), Terraform, ArgoCD, Prometheus, Grafana, Databricks, Spark, Kafka

Advanced Business Intelligence Solutions

Commission de la Construction du Québec (CCQ)

Technical management of software development workflows and design of advanced BI solutions.
Development of complex data models and quality assurance of deliverables.
Technical support for teams: code reviews, coaching, data modeling.
Performance monitoring and optimization of analytical processes.
CI/CD integration and deployment automation.

Technologies: Azure, Power BI, Azure Analysis Services, Azure DevOps

Digital Transformation and Cloud Migration

Hydro-Québec

Strategic consulting for the evolution of Microsoft BI solutions.
Advanced ETL development for data lakes and modern data architectures.
Design of tabular models and DAX measures for business intelligence.
Workflow automation via Azure Data Factory and Power Platform.
Data modeling and creation of interactive dashboards.

Technologies: Azure, Databricks, Power BI, Azure Analysis Services, Power Apps

Consulting and Specialized Services

Various Clients (Media, Industry, Services)

Complex data migration and ETL loading with historization.
Creation of data marts and tabular models for specialized analyses.
Development of Power BI dashboards for client consumption.
Management of multiple SQL servers and performance optimization.
Design of data architectures for centralization and advanced analyses.

Technologies: Azure Synapse, SQL Server, SSIS, SSAS, Power BI

Custom Application Development and Solutions

Companies Across Various Sectors

Creation of custom management software for process optimization.
Design and development of dynamic and transactional websites.
Modernization of existing applications with SEO optimization.
Design and management of IT infrastructures.

Technologies: C#, ASP.NET, SQL Server, Azure, DevOps

Technical Skills

Cloud Infrastructure and DevOps

Kubernetes (GKE): Container orchestration, cloud-native application deployment and management
Infrastructure as Code (IaC): Automated deployments with Terraform, Crossplane, ARM Templates
GitOps & CI/CD: Continuous deployment with ArgoCD, GitHub Actions, Azure DevOps
Monitoring & Observability: Application monitoring with Prometheus and Grafana (dashboards, alerts, SLOs)
High Availability Applications: Deployment of web applications (Drupal, CKAN) in HA on GKE

Cloud Data Platforms

Azure Synapse Analytics, Databricks, Azure Data Factory, Azure Analysis Services, Azure Data Lake Storage, Azure Key Vault, Azure Storage Explorer

Development Tools

Visual Studio, VS Code, SQL Server Management Studio, Git, Power BI, Visio, Excel

Programming Languages

PySpark, SQL, Python, C#, YAML, VB.NET, DAX, HTML, MDX, Power Query M, Bash

Business Intelligence Expertise

Data Warehousing
Big Data (medallion architecture)
Azure Analysis Services (tabular models)
SQL Server Analysis Services (OLAP cubes)
SSRS, SSIS, DTS
Dataflows, ETL, ELT
Power Pivot

Other Skills

Cloud migration
ETL/ELT automation
Team mentoring
Modern data architectures
Performance optimization
CI/CD

Accomplishments

Microsoft Power BI Hackathon 2019

Winning Team Leader of the Microsoft Power BI World Hackathon 2019

Creation of a complete data model and interactive dashboard in 7 hours, based on public data and a topic announced on the same day.
Solution adapted to all types of users, awarded internationally.

Link to the winning team announcement

Other Achievements

Over 25 years of experience in software development, with 15 years specialized in large-scale data solutions.
Recognized expertise in cloud migration and ETL/ELT automation.
Technical leader for team mentoring and support for junior developers.
Participation in complex projects for major organizations in Quebec.

Contact

Contact Information
WILLMA - Data Consulting Services
Phone: (514) 999-0965
Email: info@willma.ca
Website: https://willma.ca