Summary
Overview
Work History
Education
Skills
Certificates Courses
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

Work History

Data Engineering Consultant

Avanade
06.2022 - Current
  • Acted as the primary liaison with clients in Banking, Transportation, and Government Housing industries, gathering and finalizing requirements.
  • Spearheaded the migration of 150 SAP Crystal Reports to Power BI Paginated Reporting, overseeing all development and conversion processes.
  • Orchestrated Power BI / SQL / Peer reviews and deployments to higher environments, ensuring seamless transitions at a senior level.
  • Led UAT process, addressing SQL / Power BI defects and coordinating remediation efforts, demonstrating senior-level leadership.
  • Assisted in RFPs and presale activities with clients, presenting demos and presentations to highlight product capabilities and benefits in Microsoft ecosystem
  • Designed SQL Stored Procedure and SQL Views integrated into ADF Pipelines
  • 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

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, ON
05.2001 -

Skills

undefined

Certificates Courses

  • 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

Bachelor of Commerce - Business Technology Management

Ryerson University
05.2001 -

Project Manager

Rogers Communications
6 2021 - 06.2022

Similar Profiles

CREATE PROFILE
Hiba Ahmed