Imtiyaz Khan Pathan

Delivered enterprise-grade BI solutions across quality, workforce, and operations, driving efficiency and decision-making. Designed and deployed over 20 Power BI dashboards integrating data from Excel, SQL Server, Salesforce, and SharePoint, leveraging DAX, calculated columns, and Row Level Security for secure, scalable reporting. Implemented automated refresh schedules and performance tuning, cutting manual reporting effort by ~30% and improving responsiveness. Streamlined workflows with Advanced Excel and VBA Macros, enhancing data integrity and saving significant analyst time by eliminating repetitive tasks. Core project for DTR (Dell Technologies Renewals Team): Holistic Performance Report Ensured data accuracy and integrity to evaluate DTR Global team performance on a monthly, quarterly, and annual basis. Served as the primary input for appraisals, bonuses, and promotions, while reducing review cycle prep time by ~25%. Capacity Utilization Report Developed an analytical model comparing actual task time against available capacity. Enabled data-driven staffing decisions and optimized resource allocation, resulting in reduced overstaffing costs. Quality Audit Report Developed a multi-dimensional audit system to track errors, checks, heat maps, and score trends. Automated root-cause analysis improved customer experience, while integration with the Holistic Report and dashboards enabled proactive training and escalation prevention. Quality Audit Macro Developed an automated audit system covering audit assignment, pending audit notifications, error alerts, and score trend tracking. Integrated with the Holistic Report to provide unified visibility, saving approximately two hours per day through reduced manual effort. Other Macros Developed and implemented multiple automation solutions to handle routine and recurring tasks. Standardized processes to maintain data integrity and accuracy, while reducing manual effort. These automations saved analysts and SMEs significant time, improved efficiency, and ensured consistency across reporting activities.

Designed and maintained daily, monthly, and annual MIS and KPI reporting frameworks using Advanced MS Excel with VBA Macros. • Developed complex maintenance scorecards, performance dashboards, and analytical models to track equipment lifecycle, resource utilization, and maintenance cycle KPIs. Page 2 of 2 • Conducted manpower utilization and capacity planning analysis with Excel-based models, enabling optimized scheduling and cost savings in maintenance operations. • Extracted and interpreted data from maintenance cycle systems, identified trends, and delivered actionable insights to engineering and operations management. • Served as Internal Auditor, ensuring maintenance compliance was implemented and consistently maintained across technical departments. • Assisted the KPMG team by developing a data migration tool to transfer in-house MMS (Maintenance Management System) data. Mapped and generated equipment classifications and categories for seamless migration to the Oracle-based Enterprise Asset Management system. • Automated routine and daily tasks to save time and reduce manual effort.

• Managed end-to-end supply chain operations for IT hardware procurement and installation, ensuring on-time delivery and vendor compliance. • Maintained customer relationship management (CRM) processes, handling key accounts and resolving escalations to improve client satisfaction. • Supported administrative and operational functions, contributing to process documentation and office efficiency.

Root Cause Analysis — ISO 9001-2008

ISO

Process Approach to Quality Management System — ISO 9001-2000

ISO

Lean Six Sigma

EMC

Data Analytics Certification

GAT