Summary
Overview
Work History
Education
Additional Information
Certification
Timeline
Generic

Hiba Ahmed

Toronto,Canada

Summary

Hiba Ahmed is a Data Engineering Consultant with 4+ years specialized experience in Project Management (Agile/Waterfall), Data Engineering and Data Visualization. Proficient in Budget, Vendor and Resource Management. Experienced in migrating On-Prem data to cloud via Azure Data Factory pipelines. Skilled in analyzing & visualizing complex datasets into dashboards to drive strategic business decisions while communicating insights to Executive Leadership. Passionate advocate for building high-performing teams, coaching and storytelling.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Data Engineering Consultant

Avanade
06.2022 - Current
  • Acted as the primary liaison with clients in Banking, Transportation, Oil and Gas industries, gathering and finalizing requirements.
  • Managed SQL Changes deployment using Azure DevOps, Microsoft Visual Studio, and Azure DevOps release pipelines for Dev and QA Environments , developed SQL Stored Procedures and SQL Views integrated into ADF Pipelines
  • Designed SQL Stored Procedure and SQL Views integrated into ADF Pipelines
  • Led UAT process, addressing SQL / Power BI defects and coordinating remediation efforts with external vendors, client product owners
  • Spearheaded the end to end migration of 150 SAP Crystal Reports to Power BI Paginated Reporting, overseeing development and conversion processes in Power BI , SQL and Oracle.
  • Assisted in RFPs and presale activities with clients, presenting demos and presentations to highlight product capabilities and benefits in Microsoft ecosystem (Databricks, Azure Synapse)

Project Manager

Rogers Communications
6 2021 - 06.2022
  • Led a cross-function IT project team of 11 developers, QA & Solution Architect to deliver 15 agile projects ranging from $30K- $1.54M across data warehouse, data lake and cloud deployments within 10% of forecasted budget
  • Spearheaded daily scrums to deliver 50+ deployments on time, prioritized Jira backlog & scope, analyzed & resolved timeline risks with Product Owners in Jira/Confluence over 10-month period
  • Collaborated with 5+ external vendors & onshore/offshore teams on resource allocation to reduce costs and enabled $1.54M to 600K budget cut, managed overall budget to reduce resource costs by 8% without impact to existing timelines.

Data Engineer

Rogers Communications
07.2020 - 06.2021
  • Created a financial dashboard in PowerBI with 20+ KPIs and interactive drill-downs by type, vendor, labor, etc
  • For Directors, visualized growth of $27M+ project portfolio by consolidating 75+ SharePoint files using DAX queries, eliminated manual process by 100%
  • Developed PowerBI Operational Dashboard for call performance using Oracle SQL databases, mined & processed 2M records of data and generated insightful visuals, reduced 80% of data volume with intermediate SQL ETL, M-scripts, DAX and optimal data modeling
  • Consolidated 7 KPI dashboards from SharePoint, PowerBI, Tableau, Excel & Jira into single interactive PowerBI report for CTIO & SVPs
  • Migrated 12 Oracle & Hadoop tables to Azure using SQL, Databricks, Azure Data Factory, Kafka & GitHub for database modernization initiative, implemented rigorous data quality checks to ensure seamless data migration
  • Facilitated pre- & post-migration activities, created implementation plans & collaborated with QA & Developer teams to unit testing of codes in Oracle & Hadoop databases on Azure.

Research Analytics Lead

Ryerson University
05.2019 - 06.2020
  • Led 3 undergraduate students in analysis of 10-year historical admissions data to understand shift in student behavior & publish a report
  • Analyzed data from student surveys & admissions to produce visualizations of key trends & patterns in the data, built linear regression models using Python NumPy, Matplotlib, Pandas, Scikit learn libraries to predict student admission rates, with 88.4% accuracy.

Database Analyst

Enbridge Gas Distribution
05.2018 - 08.2018
  • Automated SOX Audit Reporting System, decreased auditing time by 10% using Oracle BI Publisher
  • Completed SOX Audit scripts on Unix, SQL & Linux Databases, presented evidence on behalf of Database team during Audit meetings
  • Extracted IT Department Data using custom SQL queries to create Dashboards on server availability for mangers using Splunk
  • Devised a 'Fusion Integration Delivery Model' using Microsoft Visio diagram for external stakeholders.

Education

Bachelor of Commerce - Business Technology Management

Ryerson University
Toronto, Canada

Additional Information

Data Engineering:

  • Databases (Oracle, Hadoop, SQL Server, Azure Synapse , Azure)
  • Cloud (Databricks, Azure Data Factory, GitHub, Informatica)
  • Python, R , ETL
  • Data Modeling


Data Visualization:

  • Power BI (DAX, ETL, M Scripting, Power Query Fabric)
  • Tableau, SAP Crystal Reporting Migration
  • Data Migrations (Oracle to SQL / Azure)
  • Data Mapping
  • Excel (Power Query, VLOOKUP)



Project Management:

  • Jira/Confluence/Sharepoint/Kanban/Scrum
  • Agile/Waterfall/SDLC
  • Presenting, Story Telling, Client Management , Communication
  • Budget Management

Certification

  • Microsoft Certified: Fabric Analytics Engineer Associate Certification (DP-600)
  • Microsoft Certified: Data Analyst Associate (DA -100)
  • Microsoft Certified: Azure AI Fundamentals (AI - 900)
  • Microsoft Certified: Azure Data Fundamentals (DP -900)

Timeline

Data Engineering Consultant

Avanade
06.2022 - Current

Data Engineer

Rogers Communications
07.2020 - 06.2021

Research Analytics Lead

Ryerson University
05.2019 - 06.2020

Database Analyst

Enbridge Gas Distribution
05.2018 - 08.2018

Project Manager

Rogers Communications
6 2021 - 06.2022

Bachelor of Commerce - Business Technology Management

Ryerson University

Similar Profiles

CREATE PROFILE
Hiba Ahmed