Faizan Khan

• Extracted, transformed and loaded data from multiple sources (SAP, SQL, SharePoint, Excel, Web Links, etc.) into Power BI to standardize large datasets and improve data quality and accuracy.
• Developed interactive Power BI dashboards to track logistics, supply chain and operational KPIs for leading multinational clients like Amazon, Inditex, Takko, Adlibris, etc.
• Collaborated with cross-functional teams (Operations, Finance, Logistics) to identify business needs and provide actionable insights through Power BI.
• Shared dashboards and analytics with internal stakeholders and clients to support data-driven decision-making.

Key Deliverables :

• Lead a team of around 4-5 Power BI analysts to develop and deliver data-driven dashboards and insights.
• Designed a customized analytics dashboard that enhanced client decision-making, leading to a 15.5% improvement in operational efficiency.
• Implemented DAX and Power Query optimizations, improving report performance by 25%.
• Built data models to ensure seamless integration and efficient reporting.
• Connected live data to Power BI dashboards to show real-time business updates.
• Conducted regular meetings with clients to gather business requirements and customize analytics solutions while also delivering Power BI training sessions to enhance team members data analytics skills.

Key Power BI Projects Managed :

• Shipment Transit Time Analysis.
• Container Optimization/Utilization Analysis.
• Global Procurement Visibility Analysis.
• Career Aspiration Analysis (HR Team).
• Demand and Supply Forecasting Analysis.

• Handled end-to-end Supply Chain solutions for Import/Export manifestation.
• Developed interactive dashboards using Power BI to visualize real-time analytics from large datasets stored in the Data Warehouse.
• Prepared Import/Export General Manifest (IGM/EGM) reports and submitted them to customs on time with 100% accuracy.
• Generated various reports related to import orders, deliveries, container tracking, freight forwarding and document follow-ups with shippers, buyers and consignees.
• Designed Key Performance Indicator (KPI) Power BI dashboards for multiple departments, enabling data-driven decision-making.

Key Deliverables :

• Coordinated with shipping liners, freight forwarders and Customs House Agents (CHA) for document verification and manifest amendments.
• Integrated SQL, SharePoint, Web Link and other data sources into Power BI for seamless data analysis.
• Created ad-hoc reports and interactive dashboards in Power BI to support dynamic business needs.
• Ensured compliance with customs regulations and industry best practices while optimizing reporting workflows.

• Processed and verified customer orders, ensuring accuracy in pricing, quantities and terms.
• Created Purchase Orders (POs) and Return Exchanges (REs) for all HARMAN KARDON products for U.S. based clients.
• Managed the SAP application, resolved client issues and provided support to major clients such as Walmart, Best Buy, Amazon, etc.
• Collaborated with logistics teams to ensure on-time deliveries and resolved potential issues.
• Supported the team and proactively ensured 100% quality in the work of new team members.
• Handled customer inquiries and complaints related to orders, maintaining a high level of service.