Vaibhav Arora

Data Analyst

Wunderman Thompson Studios•  May 2021 - April 2024•  Gurugram

• Cross-functional collaboration with accounts payable team, marketing team, and senior management to align budgetary goals of Microsoft’s procurement cycle with overall business objectives. • Developed interactive dashboards and reports using Power BI to visualize complex datasets which has helped to communicate insights to the stakeholders. • Utilized Power BI features such as DAX and Power Query(M) to create interactive reports to forecast the volume trends which has helped in decision making. • Wrote and optimized SQL queries to extract, manipulate, and analyze data from relational databases. • Leveraged various types of SQL joins and Window Functions to perform advanced analytical tasks which has helped in budget management. • Implemented SQL stored procedures, functions, and triggers to automate repetitive tasks and enforce business logic within the database environment. • Managed and maintained databases using SQL, ensuring data integrity and security. • Monitored and tracked marketing expenditures using designated tool to identify and address any budget deviations or discrepancies. • Contributed to the development of procurement strategies aligned with overall organizational goals and identifying opportunities for process optimization and standardization.