Debbie Macrohon

Portfolio

Some of the projects I've done

1. {{cat.text}}

Work Experience

Aug
2015
May
2016
Feb
2019
April
2020
Aug
2021

Business Intelligence Student Assistant

University of Calgary

Designed a database for the university’s data dictionary application, documented parts of the 
    business process as well as the technical process behind the data dictionary
                
Collaborated with developers and business users for data dictionary and ensure their most urgent 
    needs were prioritized in the design
                
Researched other institution’s data dictionaries, and various educational research articles and 
    IT blogs about implementation methods for data dictionaries

Systems Analyst

Bridgewater Bank


Gathering requirements, creating mockups, test cases, traceability matrix and documentation, 
  designed database, developed the software and implemented security features of multiple internal 
  applications for Bridgewater Bank.
               
Developing on existing company framework that improve data quality using 
  Data Quality Services, Master Data Management and SSIS. 
               
Ensuring production environment stability and mitigating risks by assessing code reviews 
  before deployment to production, developing a process to streamline the QA deployment process, 
  resolving business intelligence tickets.

Software Developer

Arcurve


Integrated data from various sources (external API, physical files, databases) into a single
unified source used for business reporting using SSIS (SQL Server Integration Services). Created SSRS
(SQL Server Reporting Services) reports from the consolidated data. Updated SSAS (SQL Server
Analysis Services) cube using DAX and and SQL views.

Created reports through Power BI and developed DAX formulas to achieve dynamic results. Optimized 
Kusto queries from Azure Data Explorer and SQL queries from SQL Server Management Studio minimize 
performance issues of the reports. 

Working with creating, reading, updating, deleting object models through REST-ful APIs. 
Developing file (xml, Excel) and web scraping methods (HTML) to parse data, transform them 
into business-defined hierarchical models and integrate them into the system.

ETL Developer

Dynamic Risk


Integrating data from SQL Server and Oracle sources into environments of clients' choice 
  (SQL Server or Oracle) for analyzing spillage, cracks or anomalies from inline inspection
  data of their pipelines.

Created POC for data migration from on-prem database to Azure (SQL Database) using Data Factory. 

Optimized processes and queries.

Data Engineer - Sr Consultant

Avanade

Managed a group of 7 resources consisting of data, devops and QA engineers.

Created orchestration pipelines using Synapse and ADF and ETL pipelines using Databricks.

Developed PySpark notebook to materialize data and accommodate change data.

Influenced client decisions on best practices, solutions, general design and architecture.

Designed and building row level security for PowerBI reports and the data layer.

Configured resources for Data Lake Trickle from Dynamics365.

Configured Synapse with Data Landing Zone and leveraged CDMUtil to auto-create Synapse views

Built star schema data models using SQL for their supply chain management system in Azure Synapse dedicated pool from Dynamics365

Certifications

About

Professional Snapshot

Emerging from the University of Calgary with a BSc in Computer Science, I’ve carved my niche at Avanade as a Data Engineering Consultant. My professional canvas is painted with data - constructing sophisticated pipelines, designing compelling visualizations, and deciphering patterns to extract actionable insights.

Beyond the Workstation

In the pursuit of technological excellence, I continually explore emerging data technologies, assessing their potential applications. My current professional compass points towards Spark and cloud computing, with Azure being my platform of choice. Balancing my professional endeavors, I engage in a variety of leisure activities. I appreciate the tranquility of nature walks, the thrill of biking, and the culinary adventure of trying new eateries. Social interactions are a vital part of my life, whether it’s casual gatherings, strumming songs on my guitar, or immersing myself in the captivating worlds of video games and board games. 😊