Ammar Vahora

Automated Excel reports using VBA/macros, reducing manual work by 30%. Created MoM, YoY, and QoQ spend graphs in Excel using v-lookups and categorized data. Developed real-time Power BI dashboards using multi-source financial data. Applied Agile methods to accelerate project delivery and improve collaboration. Launched digital marketing campaigns with a 25% ROI lift through strategy and tool optimization. Improved UX and drove 20% more engagement by executing a digital customer experience strategy. Led targeted email campaigns from strategy through execution and stakeholder coordination. Used SEO and tracking tools to analyze customer journeys and optimize conversion.

Created and analyzed digital marketing campaigns, achieving a 25% ROI improvement. Built a Power BI dashboard for real-time financial performance. Planned and executed a targeted email campaign for a product launch, including audience segmentation and stakeholder coordination. Organized historical spend data in Excel to visualize MoM, YoY, and QoQ trends using VLOOKUPs. Applied Agile methodology to data projects, improving collaboration and delivery. Coordinated WordPress updates and new layouts to enhance user experience and reduce bounce rate by 10%. Leveraged SEO techniques to measure journey and conversions.

Led web analytics and campaign optimization, driving a 15% increase in monthly subscriptions and a 15% uplift in conversions and CTR through GA4, GTM, and Google Ads. Validated event tracking with developers to ensure clean data pipelines. Executed on-page SEO improvements and collaborated with content teams to boost organic traffic by 20%. Built and maintained dashboards in Tableau, Power BI, and Looker Studio to monitor revenue, engagement, and product performance. Mapped SQL Server data into Power BI for real-time dashboards and connected Salesforce to Tableau using Tableau Pulse for AI-powered insights, reducing manual analysis time by 20% weekly. Enhanced Salesforce campaign tracking and cross-platform reporting across Salesforce, Pardot, and GA. Identified data anomalies and improved data hygiene to enhance forecasting reliability.