Riya Mehtariyamehta

Analyzed website traffic and user behavior to support content and engagement improvements. Generated performance reports using analytics tools and presented insights to stakeholders. Maintained structured content databases and improved data accuracy across platforms.

Developed, maintained, and supported modern websites using WordPress (custom themes, ACF, Gutenberg) and Laravel, focusing on performance, accessibility, and responsiveness. Built internal tools and services that support search, automation, and content delivery across multiple digital projects. Contributed to AI-powered features and API integrations using OpenAI, Claude, and vector databases. Collaborated with designers to deliver pixel-perfect front-end experiences with JavaScript, Vue.js, or Alpine.js. Wrote clean, modular code and followed best practices using Git, Docker, Tailwind, and Vite.

Wrote complex SQL queries using CTEs, window functions, and multi-table joins to analyse subscription renewals, failed payments, and user activity data from PostgreSQL databases containing 500K+ transaction records. Built automated ETL workflows using Python (Pandas,Requests, SQLAlchemy) to extract marketing and product usage data from HubSpot, Stripe, and Google Analytics APIs into reporting tables for daily KPI monitoring. Developed Power BI dashboards with DAX measures and drill-through reports to track MRR, churn rate, CAC, LTV, funnel conversion, and campaign attribution across multiple acquisition channels. Performed cohort retention and funnel analysis on user onboarding flows, identifying a 27% drop-off during account verification and helping product teams optimise the signup process. Validated and cleaned inconsistent CRM and transactional datasets by handling duplicate records, null values, schema mismatches, and timezone inconsistencies, improving reporting accuracy for exec