Sameer Patel Email & Phone Number

Bengaluru, Ka, In

Vancouver, Bc, Ca

Vancouver, British Columbia, Canada

• Managing clients and health care providers, facilitating the loaning and returning of health equipment.• Ensuring the integrity of data collection and recording of all call/ client trackers and statistical information.• Providing exceptional customer service to Health Equipment Loan Program clients.• Conducting weekly/biweekly training sessions for clients.

Bengaluru, Karnataka, India

• Spearheaded the analysis and optimization of the supply chain managing INR 12 billion in annual spend, improving customer experience, and reducing return rates by 5.3% through strategic insights.• Reduced logistics operation costs by 12.11%, leading to annual savings of over INR 0.14 billion by optimizing shipment weight reconciliation models and introducing performance-based allocation of shipments.• Automated 85% of the manual data entry processes using Python, saving approximately 15 hours per week and reducing human errors by 90%.• Built SQL-based models that optimized shipment weight accuracy, reducing average shipment weight by 9%, resulting in cost savings of 6% on logistics expenditures.• Created and maintained 10+ dynamic Tableau dashboards, which reduced reporting time by 30% and provided real-time data visibility to senior management for faster decision-making.• Utilized cohort analysis on 100+ million rows of transactional data using SQL, identifying key trends that led to a 6.1% reduction in logistics costs year-over-year through better allocation of shipments to logistics partners.• Managed the daily processing of 0.4 million+ customer orders and optimized logistics routes, improving operational efficiency by 15% across a network of 0.5 million+ routes.• Collaborated with cross-functional teams to implement 50+ automated SQL queries, cutting report generation time by 50% and improving data accuracy across operational reports.• Developed advanced Excel-based financial models to project supply chain costs, achieving a 15% improvement in forecast accuracy, and providing critical insights that directly impacted budget planning and resource allocation.• Improved database accuracy and consistency through rigorous data cleansing and standardization, increasing data reliability by 95%, and ensuring cleaner analysis and more impactful business insights.

Bengaluru, Karnataka, India

• Managed and optimized databases to ensure high-performance data flow across systems.• Developed and optimized SQL queries, reducing query execution times and improving database efficiency.• Designed data models to support business needs, ensuring clean and consistent data for analysis.• Identified data flow gaps and standardized database formats, enhancing data integrity across multiple systems.

Mumbai, Maharashtra, India

• Built and optimized SQL queries to support large-scale data retrieval from millions of records, improving query performance by 25% and reducing server load during peak hours.• Implemented an advanced SQL-based order confirmation system, which identified high-risk orders through buyer behavior analysis (e.g., acceptance rates, return history), reducing Return to Origin (RTO) orders by 15% (on selected cohort).• Conducted cohort analysis on customer behavior using complex SQL queries to segment and analyze data, providing insights for performance optimization and fraud detection.• Designed custom data models and flows using SQL to support business-critical operations, facilitating more accurate and efficient decision-making across departments.• Designed a fraud detection dashboard that tracked suspicious returns/disputes at the regional level, leading to a 20% reduction in fraudulent activities across multiple business units.• Standardized data collection processes across all regional units, ensuring data consistency and improving overall reporting accuracy by 15%.