Ayush Devrani

Business Development Executive

Delhi, India3 yrs 9 mos experience

Key Highlights

3.8+ years in business analytics and data strategy.
Expert in SQL, Python, and Tableau for data-driven decisions.
Proven track record in e-commerce and healthcare analytics.

Stackforce AI infers this person is a Business Analyst with expertise in E-commerce and Healthcare analytics.

Contact

Skills

Core Skills

Business AnalyticsE-commerce AnalyticsBusiness IntelligencePharma Analytics

Other Skills

AWS (Redshift, S3)Ad Hoc AnalysisAd-hoc ReportingAdvanced SQLAmazon RedshiftAmazon Web Services (AWS)Azure DatabricksCRM AnalyticsConfluenceData AnalysisData AnalyticsData AutomationData GovernanceData ModelingData Pipeline Optimization

About

Senior Business Analyst with 3.8+ years of experience in business analytics, customer engagement, and data strategy across e-commerce and healthcare domains. At Tata 1mg, I drive sales growth by analyzing CRM funnels, optimizing lead conversions, and delivering actionable insights to boost customer outreach and revenue performance. Previously at ZS Associates, I specialized in pharma analytics—building dashboards, automating ETL pipelines, and enabling data-driven decisions for global life sciences clients. Skilled in SQL, Python, Tableau, Excel, CRM systems, and Informatica, with a B.Tech in Computer Science. I combine strong technical skills with business acumen to solve complex problems and scale impact in high-growth environments. Core Skills: Business Analytics | E-commerce Analytics | Inside Sales | Customer Engagement | Pharma Analytics | SQL | Python | Tableau | Excel | ETL | Informatica | CRM Analytics | Dashboarding | Data Automation | Funnel Analysis | Revenue Optimization Actively exploring new opportunities in Business Analytics, Growth Strategy, or Data Science roles where I can drive impact through data.

Experience

Tata 1mg

Sr Business Analayst

Jan 2025 – Present · 1 yr 2 mos · Gurugram, Haryana, India · On-site

Driving core analytics, data engineering, and business intelligence initiatives to enable data-backed decisions across e-commerce and healthcare verticals.
Designed and maintained scalable ETL pipelines to ingest and transform large volumes of structured data from multiple sources using SQL and Databricks.
Led the System Optimization Initiative, enhancing performance across Databricks, Tableau, and Metabase dashboards by reducing query execution time and eliminating compute bottlenecks.
Built efficient dashboard frameworks and reporting structures to support inside sales, CRM analytics, and executive decision-making.
Created and maintained comprehensive Confluence documentation to ensure continuity, knowledge transfer, and audit readiness of data workflows.
Conducted code reviews and championed best practices in data modeling, query optimization, and analytics engineering.
Tech Stack: SQL | Python | Databricks | Tableau | Metabase | ETL | Confluence | CRM Analytics | Business Intelligence | E-commerce Data | Data Pipeline Optimization

SQLPythonDatabricksTableauMetabaseETL+7

Zs

Business Technology Solutions Associate

Jul 2022 – Jan 2025 · 2 yrs 6 mos · Gurugram, Haryana, India · On-site

Delivered high-impact pharma analytics solutions for global life sciences clients by combining deep SQL expertise, dashboarding, and ETL automation.
Designed and optimized complex queries using Advanced SQL to meet dynamic client requirements across multiple therapeutic areas.
Built and maintained interactive dashboards on Tableau Server to enhance visualization, reporting efficiency, and client decision-making.
Automated routine data workflows using Informatica ETL, reducing manual effort and turnaround time.
Managed and analyzed large datasets using Amazon Redshift, S3, and AWS services, streamlining healthcare data processing.
Led Salesforce-based reporting for granular analysis of sales and customer data, supporting business development strategies.
Conducted advanced analysis using MS Excel, addressing ad-hoc client asks with high accuracy and speed.
Migrated SQL procedures and logic across multiple client environments, ensuring data integrity and operational continuity.
Facilitated smooth code deployments and ensured stakeholder alignment through transparent communication and regular sync-ups.
Tech Stack: Advanced SQL | Tableau | Excel | AWS (Redshift, S3) | Salesforce | Informatica | PL/SQL | Healthcare Analytics | Data Automation | ETL | Business Intelligence | Ad-hoc Reporting