Ahsan Khurshid

Technical Associate ( Operation and Data )

Siemens•  November 2022 - November 2023

• Supported customer operations and the marketing team by extracting and visualizing data using Excel, Power BI, and SQL queries. • Optimized dashboards and reports using visualization tools like Power BI to efficiently address day-to-day data and analytics requests, and converted all the insights into performance according to key metrics. • Applied advanced modeling techniques, converting insights into strategic opportunities. • Enhanced communication skills with in-house vendors, ensuring timely order completion and fostering a smooth workflow for effective project management. • Cleaned and analyzed complex data on product and service rates, utilizing Excel and creating a dashboard for swift data-driven insights. • Maintained info-records of various materials on SAP for long-term reference with attention to detail. • Worked with the planning department, conducting one-on-one meetings with stakeholders. • Manipulated datasets in Excel, drawing information from different data collection methods primary and secondary sources. • Addressed day-to-day challenges related to data consumption and awareness, contributing to a well-rounded support system for customer operations and marketing endeavors. • Monitored and analyzed diverse data sources for accurate collection, processing, and modeling. • Prepared daily sales and special project reports, ensuring timely updates. • Worked on data integration management and control over multiple data entities. • Learned about terminologies like clouds, databases, dimensional data, data lakes, and ETL/ELT processes. • Identified 5-8% profitability improvement potential in the operation department. • Led a team of one Associate and one Intern to conduct extensive quantitative and qualitative benchmarking of routine works.