Shiva Sharma

• Developed interactive marketing dashboards using Looker Studio specifically tailored to the real estate sector, catering to the needs of developers and brokers
• Actively contribute to team automation through the use of Google Apps Script. This has resulted in a nearly 4-hour reduction in manual reporting
• Proficiently manipulated and processed extensive datasets using Google Sheets. Conducted segmentation based on geographic regions, utilizing phone data, to target specific audiences for email marketing campaigns
• Performed monthly backups of spend data from Meta, Google, and TikTok, as well as lead data, by ingesting Google Sheets into BigQuery. Created and maintained BigQuery tables to store this data, and executed SQL queries based on specific requirenments

• Experience working with Google Tag Manager (GTM) and Google Analytics (GA). Managed the analytics tracking for an E-commerce website with millions of monthly visitors
• Developed custom JavaScript tracking tags and triggers for Meta, Twitter, TikTok and Snapchat in GTM to capture crucial user interactions for accurate performance dashboards and presentation
• Developed and maintained comprehensive developer documentation for data layer implementations across multiple accounts. Verified data accuracy from the data layer in Google Analytics and created funnel reports to support the performance team in client presentations

• Executed SQL queries within the SAS environment to extract data based on business team requirements, ensuring accuracy and relevancy. Leveraged this data to drive cross-selling initiatives for various campaigns, including the promotion of gold loans through diverse channels such as email, SMS, and mobile banking
• Worked closely with marketing and sales teams to understand their data needs and translate them into technical requirements
• Generated comprehensive reports to present findings and insights to stakeholders, aiding in strategic decision-making processes

CLIENT - CITIGROUP

• Collected, cleansed, and verified data from Campaign Manager 360, Display & Video 360, and Google Ad Manager. Successfully integrated this data into the Datorama dashboard for analytics and reporting
• Collaborated with stakeholders across departments to ensure all requirements are met prior to delivery of reports. Prepared ad-hoc reports as requested by senior management team

Client - Google

• Provided timely and effective resolutions to user inquiries and issues related to Google My Business (GMB) listings, ensuring high levels of customer satisfaction
• Assisted customers with the creation, verification, and optimization of their GMB listings to enhance online visibility and business presence
• Analyzed client data and feedback to identify common issues and trends, contributing to the continuous improvement of support processes and tools