Waqas Ahmed

Data Analyst (RevOps and Marketing Data)

1 Clean Air • Full-time

Oct 2025 - Present • 11 mos

• Produce daily sales, revenue, and performance reports to monitor business performance, operational KPIs, and sales activity. • Prepare monthly ROI/ROAS reports across 1CleanAir, HomeDepot, EnvirPlus Duct Cleaning, and HVAC White Glove. • Perform QC on sales orders, identifying incorrect, incomplete, or inconsistent information entered by sales representatives and correcting CRM issues. • Verify and maintain sales schedules, checking bookings and operational data for accuracy and resolving inconsistencies. • Monitor sales-representative activity through daily QC reports covering calls, emails, SMS, and required follow-up activity. • Review and correct lead-source information and marketing attribution in CRM systems to improve reporting accuracy. • Manage business data across Pipedrive, ServiceMonster, ServiceTitan, CallRail, and RingCentral. • Design Excel, Power BI, and Streamlit dashboards for sales, revenue, marketing, and operational performance. • Build n8n automation workflows and prototype CRM/API integrations, including Pipedrive ↔ ServiceMonster order tracking. • Use Google Ads Manager and Facebook Ads Manager data and apply Python, Pandas, NumPy, and Machine Learning for analysis and forecasting.

Data Analyst

Cloud Data • Full-time

Jul 2025 - Sep 2025 • 2 mos

• Analyzed complex datasets to identify trends and generate actionable business insights. • Prepared MIS and performance reports and performed data cleaning, validation, transformation, and structuring.