A brief overview

William Martin - Big Data and BI Expert

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 large-scale data solutions.

Why choose WILLMA?

  • In-Depth Data Expertise: 20+ years of experience in large-scale data solutions, Big Data, and modern architectures.
  • Cutting-Edge Technologies: Mastery of Microsoft Azure, 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.

Contact us today

To discover how we can collaborate and grow your business together! Discover our services, our expertise, and our skills. Contact us to discuss your project.

Services

Data engineering and Big Data 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.

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 - Big Data and BI Expert

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

Collective expertise in data

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 analytics teams, leading Spark/Kafka/Databricks solutions for real-time processing of large data volumes.
  • Management of cloud infrastructure projects and migration to modern platforms.
  • Technical support and guidance for teams on new data technologies.

Technologies: Azure, GCP, Kubernetes, 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

Technical skills in data

Cloud Infrastructure and DevOps

  • Kubernetes : Container orchestration, cloud-native application deployment and management
  • Infrastructure as Code (IaC) : Automated deployments with Terraform, ARM templates, Bicep
  • Crossplane : Unified multi-cloud infrastructure and Kubernetes resource management
  • Azure DevOps & CI/CD : Automated pipelines, continuous integration and deployment
  • GitOps : Infrastructure configuration management via Git

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

Professional 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