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
PowerBI (DAX, ETL, M Scripting, Power Query)
SAP Crystal Reporting
Tableau
UX Design
Business Analytics
Project Management
Jira
Kanban/Scrum
Confluence
SharePoint
Agile/Waterfall
SDLC
Client Management
Excel (Power Query, VLOOKUP)
Databases (Oracle, Hadoop, SQL)
Cloud (Databricks, Azure Data Factory, GitHub)
Python
Data Mining & Analytics
Data Modeling
Presenting
Storytelling
Team Building
Decision Making
Communication
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