Aug 2023 – Oct 2025 · 2 yrs 2 mos

• Upgraded Metabase to version 0.50 using Docker and set up testing and staging portals, enabling seamless dashboard access for internal teams. Exposed VM ports via SSH for secure remote access.
• Built an interactive campaign insights dashboard using ApexCharts supported by an endpoint for breakdown insights(hourly, daily, weekly, monthly, yearly).
• Implemented flexible utility enabling seamless migration of over 10 SQL jobs through configuration, ensuring that new jobs can be added without any code modifications.
• Developed a background service for a marketing automation product that has successfully sent over 100,000+ promotional emails on campaign launch using the Mailgun API, increasing user engagement by 20%.
• Established a service to store the email metrics including opens, delivery and other data in DB for a user.
• Automated Power BI dashboard downloads and email distribution using Puppeteer script, cutting manual effort by 70%.
• Created a NuGet package for data retrieval and processing, facilitating 8,760 data downloads per month.
• Designed and implemented an service to fetch Google Ads data on an hourly basis.
• Orchestrated a daily utility for cross-referencing database data with API data, achieving 99% data accuracy and triggering automated re-downloads with email alerts for timely notifications.
• Integrated attachment support using iView component library, secured uploads to Amazon S3, and tracked attachment details in a dedicated database table

Feb 2023 – Jul 2023 · 5 mos