Devesh Singh Panwar

• Client and Stakeholder Presentations: Leveraged Power BI's visualization capabilities and Excel's data presentation features to effectively communicate insights and recommendations to clients and operations management
• Monthly SLAs Reports: Created and maintained Excel and Power BI reports on Ariba PO Enablement, PO compliance, Contract Compliance, e-Invoicing Percentage, Ariba Invoice Enablement, Invoice First Pass Yield rate, Invoice Paid on Schedule Date, Electronic Payments made, and Helpdesk Inquiry resolution rate Leveraged Excel for data consolidation and initial calculations including data extraction through SAP and Internal tools
• Daily Reports: Posted Semi QC, Web cycle cases, IWGPH, SQF, ACF, and DMS reports, updating data on the central tool, and visualizing key metrics in Power BI for real-time monitoring and Utilized advanced Excel functions for data cleaning and preliminary analysis
• Data Validation and Client Communication: Validated operational reports (Req to PO Flip, Req to PO - Quotations with no negotiations, Data accuracy - PO Quality and Vendor Master Data) using Excel for detailed analysis and presented findings to clients using Power BI visuals for clarity and impact
• Dashboard Development and Maintenance: Designed, developed, and regularly updated interactive Power BI dashboards to track KPIs, operational metrics, and trends, ensuring data accuracy and relevance Integrated Excel data sources seamlessly into Power BI
• Ad-Hoc Reporting and Analysis: Utilized Power BI and advanced Excel functions (e.g., Power Query, Macros) to conduct in-depth analysis of large datasets, generating comprehensive ad-hoc reports to address specific business questions and support decision-making
• Data Modeling and Transformation: Transformed and modeled data within Power BI and Excel to create optimized datasets for efficient reporting and analysis
• Client and Stakeholder Presentations: Leveraged Power BI's visualization capabilities and Excel's data presentation features to effectively communicate insights and recommendations to clients and operations management.

• Technical support to Amazon European Customers with technical and non-technical queries on users on multiple chat concurrency
• Escalating the cases to L2/T2 Support when outside the scope of L1/T1 Technical Support
• Supported 3+ batches in their OJT and teams in the absence of SME as a Floor Walker / Mentor
• Retrieving performance metrics data of each individual within the team from the Pulse Tool and sharing the reports related to it
• Arranging refresher/doubt-clearing sessions aligned with the training team
• Sharing process-related announcements/ updates within the team
• Identifies, investigates, and resolves user issues related to Amazon.de, Amazon.Fr, and Amazon.es including orders-related queries, accounts, payment, invoicing, prime membership, and services associated with it

• Setting up and maintaining computer labs: This involves installing and updating software, configuring hardware, troubleshooting network issues, and ensuring the overall functionality of the lab environment
• Managing servers and computing resources: TAs are responsible for the administration of servers, cloud infrastructure, and other computing resources used for research, teaching, and departmental operations
• Software installation and troubleshooting: They assist faculty, researchers, and students with installing and configuring software tools, libraries, and frameworks required for their projects, also troubleshoot software-related issues
• Assisting with course delivery: TAs may help professors with preparing course materials, setting up online learning platforms, conducting lab sessions, grading assignments, and providing additional support to students
• Conducting tutorials and practical sessions: They lead tutorials and practical sessions to reinforce theoretical concepts, guide students through programming exercises, and address their questions
• Providing technical support: They act as a resource for faculty, researchers, and students, answering technical questions, troubleshooting problems, and offering guidance.

Technical Assistant for the Government of NCT Delhi, with annual contract renewals.