Vikrant Arora

I'm a vendor at Microsoft and is part of their EMEA Marketing BI & Analytics team responsible for providing reporting & analytics on marketing performance.

• End-to-end development and maintenance of Power BI reports & dashboards to help marketers do performance analysis of different marketing engines like events marketing, digital marketing, paid media marketing etc..

• Perform complex data modeling & transformation activities on data sourced from several sources to create highly comprehensive datasets & dashboards to give 360 degree view of business performance.

• Collaborate with marketing teams to gather requirements, define KPIs, and provide data-driven insights for optimizing marketing strategies and campaigns.

• Performing websites & campaign performance reporting using Adobe Analytics to optimize campaigns performance and websites inventory. This involves creation of reports in Adobe Analytics workspace & datawarehouse and also by pulling data using Adobe Analytics connector to bring data into Power BI to create dashboards to give consolidated view of performance of all EMEA marketing sites.

• Train and mentor team members on Power BI and Adobe Analytics usage, best practices, and data visualization techniques.

My job was to provide reporting and analytics support to Customer Success Managers/Account Managers of Adobe’s digital marketing vertical in Americas region to help them retain customers and realize upsells & cross-sells. Tasks performed:

• Creating reports & dashboards on usage & adoption of Adobe products by the customers.

• Reporting on user activity & usage of different features of Adobe products by customer to help account managers understand engagement level of customer with Adobe products.

• Deliver monthly or quarterly account review for upcoming renewals and mandatory product upgrades.

• Creating customer’s web traffic reports in Adobe Analytics to help account managers understand site traffic levels of customers.

Worked as a freelancer for some foreign management-consulting clients and helped them with their secondary research requirements. These consultants worked in sports sponsorship & sports marketing domains and my job was to provide them data & information needed for client engagements. Some examples of projects done:

• Yoga Apparel Market Sizing: To help a client understand the yoga apparel market and understand the business through a use case of successful yoga apparel manufacturer performed market size estimation and profiled in detailed the successful market manufacturer/retailer.
• Marketing Analysis for Sponsorship Targeting: Studied marketing campaigns & sponsorships of top UK & international companies for targeting them to sponsor a premium property in UK.
• Social Media Database of Top Sports Teams & Players: Recording subscribers/likes/followers data on prominent social media websites of top sports teams, players & leagues to analyze factors leading to spike in social media following.

My job was to provide reporting and analytics support to Customer Success Managers/Account Managers of Adobe’s digital marketing vertical in Asia region to help them retain customers and realize upsells & cross-sells. Tasks performed:

• Creating reports & dashboards on usage & adoption of Adobe products by the customers.

• Reporting on user activity & usage of different features of Adobe products by customer to help account managers understand engagement level of customer with Adobe products.

• Deliver monthly or quarterly account review for upcoming renewals and mandatory product upgrades.

• Creating customer’s web traffic reports in Adobe Analytics to help account managers understand site traffic levels of customers.

Worked as an Asst. Manager in the Quality Team of the Data department of AskmeGrocery, a grocery e-commerce company. Was responsible for data accuracy/quality, management reporting and led a team of quality checking analysts.