Ready to start and grow your business bigger and win customers forever?
Check it out
%202%20(1).png){kind=small}
.png){kind=small}
US Med Supply is a healthcare services provider specializing in the nationwide distribution of medical supplies and durable medical equipment (DME). Focused on delivering timely and reliable service, the company supports patients with essential health products while ensuring seamless coordination with healthcare providers and insurance carriers.
Custom ETL from Zoho CRM
Solved SCD with status tracking
Standardized datetime, mapped relationships
Visualized conversions, funnel, status KPIs
Data Engineer
BI Dashboard Developer
CRM Data Analyst
Project Coordinator
Fixed-Scope CRM Analytics Modernization Project
Dataprep and BigQuery incompatibilities disrupted transformation workflows.
No native join path required custom logic for relational integrity.
The project began with extracting lead and contact data from Zoho CRM and staging it in BigQuery using Dataprep. Custom modules were developed to track historical status changes—enabling lead funnel visibility across time. Key performance indicators were derived and visualized in Looker Studio dashboards tailored for sales and marketing.
Challenges in Modeling Subscription and Business Metrics
.png)
DataRopes.ai is a global technology partner which delivers end to end services like data engineering, data analysis, data science and AI & ML
Reviewed on
150 E B St Lbby # 1810
1106 A, 11th floor, Haly Tower,
Sector R DHA Phase 2, Lahore
DataRopes.ai is a global technology partner which delivers end to end services like data engineering, data analysis, data science and AI & ML.
Reviewed on
Address
150 E B St Lbby # 1810
1106 A, 11th floor, Haly Tower,
Sector R DHA Phase 2, Lahore
© DataRopes 2025. All rights reserved
.png)
.png)
