Sundar Fartyal
8449261082 | https://www.linkedin.com/in/sundar-fartyal-424955209/
Summary
Results-driven Data Analyst with 4+ years of experience in data analytics, business intelligence, and end-to-end data pipeline development. Proficient in Python, SQL (MySQL, PostgreSQL), and data visualization tools such as Power BI and Advanced Excel.
Experienced in performing funnel analysis, cohort analysis, and predictive analytics to drive business growth and improve customer engagement. Proven track record of delivering measurable impact, including increasing user retention by 30%, reducing manual reporting effort by 70%, and optimizing conversion rates through data-driven insights.
Strong ability to translate complex data into actionable business strategies and collaborate with cross-functional teams to support decision-making and improve operational efficiency.
Overview
8
8
years of professional experience
Work History
Lead Data Analyst
Vetic
Gurugram
07.2022 - Current
- Designed and implemented end-to-end data pipelines and real-time dashboards, integrating multi-source data (MongoDB, Google Ads, Facebook Ads, LSQ) into PostgreSQL (10+ optimized tables) with robust data cleaning and transformation, enabling actionable insights for 50+ stakeholders and reducing reporting time by 60%.
- Engineered an end-to-end app funnel analytics system and data pipeline (Python, SQL) integrating Google Analytics, BigQuery, and MongoDB, enabling detailed user journey and service-level (OPD, Grooming) conversion analysis; identified key drop-offs (45% & 20%) and operational bottlenecks like high zero-slot incidence, driving product and supply optimizations that reduced slot unavailability and improved overall funnel conversion by 10%.
- Built data-driven customer engagement dashboards in Power BI, applying cohort and behavioral analysis at service-level segments (e.g., OPD, Grooming, Vaccination) to identify retention drivers and optimize marketing campaigns, resulting in a 30% increase in user retention.
- Engineered and automated end-to-end inventory management workflows using Python & SQL, leveraging predictive analytics to optimize stock planning, resulting in a 40% reduction in stockouts and significantly improving supply chain efficiency.
- Designed and implemented a multi-dimensional analytics solution (clinic × service level) using Python & SQL to optimize AOV and Attach Rate, uncovering actionable insights that led to a 10% uplift in Average Order Value and improved revenue performance across key services.
- Built and optimized a subscription (membership) model for key services (Grooming, Vaccination), implementing lifecycle tracking and automated renewal triggers using Python, which improved user engagement, repeat rate, and cross-sell conversions, ultimately contributing to 70%+ of overall revenue.
Data Analyst
Pristyn Care
08.2021 - 06.2022
- Built and monitored critical healthcare conversion metrics (Lead-to-OPD, Lead-to-IPD, OPD-to-IPD ratios) using advanced Excel and Python, providing actionable insights that improved conversion rates by 18%.
- Spearheaded reporting initiatives for Growth Department, developing automated dashboards for Leads, OPDs, IPDs, Calls, and Marketing Spend that reduced manual reporting effort by 70%.
- Automated data workflows using Python and Google Apps Script, enabling real-time updates across 15+ reports and eliminating 20+ hours of manual work weekly.
- Established performance targets and KPI frameworks for key business metrics, conducted variance analysis, and presented actionable insights to C-level executives for informed strategic planning.
Data Analyst
Evelyn Learning Systems Pvt. Ltd.
09.2019 - 07.2021
- Developed dynamic dashboards for department-specific needs, enabling senior management to make informed strategic decisions through daily, weekly, and monthly reports.
- Executed continuous process improvement initiatives using data analytics insights, enhancing operational efficiency and achieving measurable cost savings.
- Analyzed event performance data using statistical techniques, identifying improvement opportunities that led to 15% increase in attendee satisfaction and 20% cost reduction.
Management Information System Executive
Red Carpet
10.2018 - 09.2019
- Implemented rigorous data validation procedures, improving data accuracy by 35% and ensuring integrity of business-critical information.
- Streamlined data collection and reporting processes, enabling faster access to critical business metrics.
Education
MBA - Data Science
IMT Ghaziabad
Ghaziabad India06-2025
Bachelor of Arts (BA) -
M B Govt. P.G. College
Haldwani, India01-2017
Skills
- Python
- MySQL and PostgreSQL
- Power BI and Advance Excel
- Google Sheet and Google Script
- MongoDB
- Google Analytics and BigQuery
- Predictive Analytics
- Data Modeling
Accomplishments
- Reduced manual reporting effort by 70% through automation, saving 20+ hours weekly
- Improved conversion rates by 25% through funnel optimization and data-driven insights
- Enhanced user retention by 30% via targeted engagement strategies based on behavioral analytics
- Decreased inventory stockouts by 40% using predictive analytics and automated workflows
Timeline
Lead Data Analyst
Vetic
07.2022 - Current
Data Analyst
Pristyn Care
08.2021 - 06.2022
Data Analyst
Evelyn Learning Systems Pvt. Ltd.
09.2019 - 07.2021
Management Information System Executive
Red Carpet
10.2018 - 09.2019
MBA - Data Science
IMT Ghaziabad
Bachelor of Arts (BA) -
M B Govt. P.G. College