Alexandria Ferguson

North Highland

Acquired The Bridge in Jan 2025 | Acquired Armeta Analytics in Dec 2024

Senior Consultant, Data & AI

• Led teams in delivering data solutions in On-Prem and Cloud environments (Azure, Snowflake, AWS) using Agile/Scrum.
• Designed, built, and optimized ETL processes, data pipelines, data models, and reporting solutions.
• Implemented CI/CD processes in Azure DevOps for seamless deployments.
• Developed and optimized ETLs in IICS, SSIS, and Azure Data Factory based on client requirements.
• Developed software and automation scripts in SQL, Python, Java, C#, PowerShell, Spark, and PySpark.
• Designed and improved SSAS tabular models and Power BI reports to enhance reporting accuracy and performance.
• Reworked a key Stored Procedure for End of Fiscal Year calculations, meeting a 5-day deadline and ensuring accurate reporting.
• Migrated and converted existing IICS jobs into SSIS and Azure Data Factory pipelines, enabling retirement of the legacy IICS environment.
• Oversaw cloud migration projects, including Azure Synapse, ADLS, Databricks, and Delta Lake implementations.
• Helped design and execute migration of on-premises data warehouses and ETLs into Azure Synapse and Azure Data Factory.
• Established naming and organization standards for Azure Data Factory, Azure Data Lake, and Robot Schedule automation jobs.
• Directed production support, resolving data quality issues, pipeline failures, long-running jobs, and CI/CD issues.
• Planned and executed migration from mixed On-Prem/Azure Synapse datasets into Databricks using Azure Data Factory, PySpark notebooks, and Unity Catalog tables.
• Designed and implemented a new data model and report for Alarm and Crime data, enabling improved incident analysis, false alarm identification, and crime hotspot detection for store planning.
• Designed and documented cloud migration plans, Data Lake structure standards, and Azure object naming standards in collaboration with the team.
• Rebuilt existing on-premises ETLs and tables from Oracle, DB2, Microsoft Access, and SQL Server into Azure Data Factory and Azure Data Lake.
• Created detailed documentation for rebuilt processes and successfully handed them off to the client.
• Led a team to migrate and validate on-premises education data into Snowflake.li>
• Monitored migration progress, validated migrated data, and updated the client’s internal validator with information on tables that are ready for validation.
• Conducted regular client meetings to provide progress updates and address blockers.
• Developed a new ETL using ActiveBatch, SSIS, Unix Shell Scripts, SQL Server Stored Procedures, and Informix SQL Stored Procedures to load retail data from a newer system into a legacy Informix system for reporting.
• Created a plan to ensure the legacy Informix system was read-only for all reporting users.
• Produced detailed documentation on the new ETL process and read-only implementation, successfully handing it off to the client for ongoing maintenance.
• Implemented and maintained CI/CD processes in Azure DevOps.
• Mentored and trained team members while managing task allocation and project delivery.