ALI WAQAS

• Developed and maintained province-level public health dashboards tracking disease surveillance data for COVID
19, Polio, Dengue, and H1N1, enabling real-time outbreak monitoring across Punjab.
• Designed interactive Power BI dashboards integrating multi-source data via Power Query and DAX to deliver real
time KPI insights for senior leadership across the Health & Population Department.
• Provisioned and managed user accounts, security groups, and RBAC permissions in Active Directory and Microsoft
365, ensuring secure and compliant identity management.
• Managed enterprise device deployments via Microsoft Intune and Jamf MDM, enforcing configuration policies and
maintaining 100% endpoint compliance.
• Maintained enterprise network connectivity (LAN/WAN, VPN, Wi-Fi), achieving 99.9% uptime for critical healthcare
and administrative operations.
• Administered Oracle, MySQL, and SQL Server databases, ensuring data integrity, security hardening, backup
management, and optimal query performance.
• Applied TCP/IP, DNS, DHCP, routing, switching, VLANs, and wireless networking to support connectivity across
healthcare facilities and administrative systems.
• Developed automated ETL processes and standardized data templates using Power Query and VBA Macros,
eliminating manual data manipulation and ensuring 100% data integrity.
• Built financial models and What-If analysis tools using Dynamic Arrays, DAX, and Regression Analysis to forecast
trends and identify operational growth drivers.
• Engineered advanced data pipelines using Query Folding, Incremental Refresh, and Custom Functions across APIs,
OData feeds, and web scraping sources.
• Led development of digital contact tracing systems and outbreak surveillance databases for COVID-19 and H1N1
pandemic response, enabling real-time epidemiological monitoring.
• Implemented a Laboratory Information Management System (LIMS) ensuring data integrity, chain-of-custody
traceability, and regulatory compliance for clinical sample analysis.
• Resolved 50+ technical support tickets weekly across hardware, software, and network domains, maintaining 95%
customer satisfaction and reducing average resolution time by 20%.
• Supported Odoo ERP implementation across HR, Payroll, Inventory, Purchasing, and Accounting modules —
including requirements gathering, configuration, data migration, UAT, go-live, and end-user training.
• Supported cybersecurity initiatives through endpoint protection, risk mitigation, and adherence to organizational
security policies.