• Working as a Spend/Data Analyst under the Procurement Team.
• Developed database objects, including tables, views and materialized views using MySQL.
• Use MySQL to access the data, perform necessary queries to cleanse and maintain the data, so it can be used for further process.
• Use the SAP BI tool to gather the data uploaded by the client from different business units.
• As it is a spend data, it comes from units like accounts payable team, purchase orders, invoice reports, etc. so have to perform different processes to cleanse, map, Normalize and Classify the data as per the pre-defined taxonomy.
• Support procurement analyst to understand spend baseline for every supplier or as per requirement.
• Utilized MySQL, data warehousing programs, Tableau, Spotfire, and other dashboards/visualization toolsets for data intelligence and analysis.
• Produced monthly/Quarterly/Yearly reports using Tableau. And present these reports to the clients quarterly or as per requirement.
• Conducted impactful analysis characterized based on data integrity and transparency, and supported by accurate documentation and clear communication.