Awais Mohammed Sabry
Brampton,ON
Summary
Damage Prevention Analyst specializing in transforming complex datasets into actionable insights for compliance and finance teams. Expertise in designing automated workflows and developing impactful dashboards in Tableau and Power BI, enhancing decision-making and reporting accuracy across cross-functional teams.
Overview
13
13
years of professional experience
Work History
Damage Prevention Analyst
Toronto Hydro
Toronto, ON
2024.05 - Current
- Transform complex operational, compliance, and financial datasets into actionable insights supporting Damage Prevention Department, Compliance, and Finance teams.
- Design and automate Alteryx workflows that streamline reporting, reduce manual effort, and improve data accuracy across multiple business units.
- Develop KPI reporting structures, and automated data models to support regulatory and operational targets.
- Build and maintain Tableau and Power BI dashboards for locates ticket monitoring and finances.
- Created monthly, weekly, and daily locate performance dashboards for Toronto Hydro Contractors and Third Party Locate Service Providers (LSP).
- Identified process inefficiencies and implemented workflow optimizations to enhance turnaround time and support operational decision making.
- Led dashboard migration from Tableau to Power BI to enhance performance and usability while ensuring data governance.
- Collaborate with cross functional teams to ensure data alignment, compliance accuracy, and timely reporting.
- Leverage modern tools such as Microsoft Copilot to accelerate analysis, automate tasks, and improve reporting efficiency.
- Created monthly scorecards for Third Party Locate Service Providers and designed an Alteryx workflow for automated backup file creation.
- Create purchase requisitions and purchase orders for receipting the monthly invoices in SAP for Ontario One Call and Third Party Locate Service Providers.
- Create WBS elements using current year's WBS and create work orders under the relevant projects.
- Involved in the Request for Proposal (RFP) process for Third Party LSPs.
Mapping and Records Associate
GTel Engineering
London, ON
2020.08 - 2024.05
- Created detailed utility locate sketches for Damage Prevention Technicians supporting Fibre-to-the-Home and Gas-to-the-Home projects.
- Produced Hydro One Planning Maps for ticket requests, ensuring accurate representation of infrastructure and work areas for effective project execution.
- Interpreted ArcGIS Reader layers and LAC MultiViewer data to produce accurate, field-ready sketches.
- Maintained centralized database of sketch templates, enhancing consistency and efficiency for office sketchers and field technicians.
- Identified locate request issues originating from Ontario One Call and escalated risks impacting timely service delivery.
- Analyzed pre-populated ticket billing accuracy for billing predictability project, contributing to improved financial forecasting.
Junior RF Engineer
Verveba Telecom
, USA
2015.05 - 2018.08
- Contributed to RF design and optimization of regional cellular networks to improve coverage, capacity, and quality of service.
- Recommended optimized azimuths, antenna tilt, transmit power, and parameter changes, enhancing network performance based on propagation studies and KPI targets.
- Performed RF validation tests including Single Site ATP Shakedown, E911, stationary, and mobility testing, confirming compliance with operational standards.
- Collected and analyzed drive test data using JDSU, QxDM, and Nemo, ensuring accurate evaluation of live network performance.
- Utilized mapping tools like DeLorme Street Atlas to assess drive routes, terrain impacts, and signal propagation for optimal RF coverage.
- Diagnosed interference and performance issues; collaborated with customers to review drive data, facilitating effective resolution of RF problems.
Administrative Graduate Assistant
Southern Illinois University
Carbondale, IL
2013.08 - 2014.12
- Administered and maintained Windows Server 2008 R2 systems, ensuring reliable IT services for department operations.
- Updated and maintained Windows Office Tracker server, streamlining faculty request processes.
- Troubleshot hardware and software issues for faculty workstations and laptops, ensuring minimal disruption to operations.
- Delivered and set up laptops, projectors, and TVs, improving technology access for classroom and faculty use.
Education
Master of Science - Electrical And Computer Engineering
Southern Illinois University Carbondale
Carbondale, IL2014-12
Skills
- Data Workflow Automation
- Workflow automation
- Business intelligence tools
- Dashboard design
- Data analysis
- KPI analysis
- Operational Reporting
- Data manipulation
- Data presentation
- Process optimization
- Compliance management
- Risk analysis
- Financial forecasting
- Data Governance
- Microsoft Office
Timeline
Damage Prevention Analyst
Toronto Hydro
2024.05 - Current
Mapping and Records Associate
GTel Engineering
2020.08 - 2024.05
Junior RF Engineer
Verveba Telecom
2015.05 - 2018.08
Administrative Graduate Assistant
Southern Illinois University
2013.08 - 2014.12
Master of Science - Electrical And Computer Engineering
Southern Illinois University Carbondale