Aditya Sharma

• Extracting and transforming data using Power Query, SAP P80 & P23 Systems, SAP BW, Azure Data bricks (Data Lake) and other tools, ensuring accuracy and integrity
• Analyzed complex data sets using advanced techniques to identify patterns, trends, and insights
• Designed and created visually compelling reports, dashboards, and interactive data visualizations using Power BI and Excel
• Presented data-driven insights to stakeholders in clear and concise manner
• Collaborated with cross-functional teams to understand business needs and requirements
• Conducted thorough analysis of business processes and systems to identify areas for improvement
• Utilized Power Automate, Power Query, VBA(Macros) and automation tools to streamline data collection, transformation, and reporting processes
• Identified opportunities for process automation and developed workflows to enhance efficiency and accuracy
• Ensured data integrity, consistency, and adherence to data governance standards

Projects:

• Developed an automation tool utilizing Excel VBA code to streamline the retrieval of reports from SAP systems and automate the generation of business reports. This implementation effectively eliminated two hours of daily manual intervention
• Worked in the development of a tool using Power BI, enabling users to conveniently access procurement business expenditure data. This approach replaced the previous reliance on a third-party source that necessitated a subscription and incurred per-user charges for database access
• Built a live Power BI Dashboard using Data Lake (Azure Data Bricks) which presents the overall Purchase Orders Count by process, TAT, KPI data for daily operations of all procurement teams

• Extracting and transforming data using Power Query, SAP P80 & P23 Systems, SAP BW and other tools, ensuring accuracy and integrity
• Analyzed complex data sets using advanced techniques to identify patterns, trends, and insights
• Designed and created visually compelling reports, dashboards, and interactive data visualizations using Power BI and Excel
• Presented data-driven insights to stakeholders in clear and concise manner
• Collaborated with cross-functional teams to understand business needs and requirements
• Conducted thorough analysis of business processes and systems to identify areas for improvement
• Utilized Power Automate, VBA(Macros) and automation tools to streamline data collection, transformation, and reporting processes
• Identified opportunities for process automation and developed workflows to enhance efficiency and accuracy
• Ensured data integrity, consistency, and adherence to data governance standards

• Worked on blocked orders by monitoring, screening, and working towards to release them within SLAs using SAP GTS systems
• Proactive and reactive handling of orders in SAP and email requests for multiple regions globally like Asia Pacific, EU and US
• Multiple Reports handling and ensuring timely publishing to stakeholders and clients
• Working on Legal control for orders import and export by assigning license and product classifications on global level
• Addressing client requests and emails within SLAs
• Creating and presenting multiple business dashboards to stakeholders and clients using Power BI

• Ensured smooth and timely freight pick-up and delivery between vendors and Amazon fulfillment centers in North America
• Implemented strategies to enhance productivity and efficiency, resulting in tangible benefits for the company
• Supervised and guided a team of 8 to 10 members, including training and mentoring new and existing employees
• Handled responsibilities in both inbound and outbound operations of North America's fulfillment centers
• Successfully resolved issues impacting customer satisfaction and business continuity
• Analyzed network exceptions and proposed automation or process changes to optimize operations
• Developed and maintained key business metrics such as MDP, deals freight metric, and NCNS metrics, and presented them to clients and stakeholders through dashboards