Headline

Business Analytics | Financial Services | Wealthy, Ex- Angel One | CFA L1 Cleared

About

Analytics professional with 3+ years delivering data-driven solutions in financial services and global consulting. Proven track record building production ETL pipelines, automating analytics workflows, and translating complex datasets into executive-ready insights. At Angel One (India's leading retail brokerage), I design and maintain data pipelines processing 10M+ rows/month from Redshift to BigQuery, automate segmentation models (RFM, LTV, FTP, churn) that contributed to ₹15Cr revenue growth in MTF products, and integrate analytics systems with marketing platforms serving 3M+ users. Collaborate with Compliance, Risk, and Growth teams on KYC analytics, regulatory reporting, and campaign performance tracking. Previously at Kantar, I led marketing mix modeling (MMM) and regression analysis for Fortune 500 FMCG and automotive clients across US, France, Belgium, and Scandinavia - translating econometric outputs into C-suite budget recommendations that improved ROAS by 12-18%. 🔧 Technical Stack: - Languages & Databases: SQL (BigQuery, Redshift, Snowflake), Python (pandas, scikit-learn, APIs, automation) - Data Engineering: ETL/ELT pipelines, Databricks, scheduled workflows, data QA/validation - Analytics: Regression modeling, RFM/LTV/propensity scoring, clustering, time series (exposure) - Tools: Tableau, Git (working knowledge), JIRA, Excel (advanced) 📊 Domain Expertise: - Financial Services: MTF, F&O, derivatives trading, KYC/AML analytics, brokerage revenue analysis - Stakeholder Management: VP-level presentations, cross-functional delivery, Agile/Scrum environments - Regulatory Reporting: Compliance dashboards, data governance, audit-ready documentation 🎓 Certifications: CFA Level 1 Cleared | PSM I (Scrum.org) | Google Data Analytics | Google Project Management 📧 siddhantsaswat99@gmail.com

Location

Bengaluru

AI stack

claude code

claude

codex

cursor

gemini

openai

Work experience

Senior Business Analyst at Wealthy, Jun 2026 - Present · 4 mos, Bengaluru

Associate Business Analytics at Angel One, Jul 2024 - Jun 2026 · 2 yrs, Bengaluru, Translated requirements from Marketing, Compliance, and Support into data specs and acceptance criteria; enabled pipelines processing 3M+ KYC rows/month and powering segmentation and reporting for downstream campaigns. Produced weekly/monthly MIS dashboards, KPI deep-dives, and ad-hoc analyses to support prioritisation discussions across F&O, Intraday, and B2B initiatives; surfaced activation and churn drivers used in VP-level review cycles. Built and maintained ETL pipelines (Redshift → BigQuery) processing 10M+ rows/month; owned QA/validation to deliver reliable dashboards and campaign triggers to meet refresh SLAs. Automated LTV, RFM, FTP, and churn outputs; reduced manual reporting by 80% (saving 5–10 hours/week) and cut audience/campaign readiness time by 3×. Integrated BigQuery cohorts with CleverTap via Python APIs, supporting 50+ campaign deployments/month by powering personalised targeting and trigger-based messaging. Initiated build of a campaign performance dashboard tracking CTR, conversions, and delivery metrics — used by Growth, Support, and Campaign teams.

Senior Analyst at Kantar, Aug 2022 - Jul 2024 · 2 yrs, Bengaluru, - Led marketing mix modeling (MMM) and regression analysis for FMCG and automotive clients across 5+ countries (US, France, Belgium, Scandinavia); quantified channel effectiveness and media contribution to revenue, identifying high/low-performing channels that enabled budget reallocations improving ROAS by 12–18%. - Translated complex econometric model outputs into executive-ready insight decks for C-suite stakeholders; tailored analytical narratives to decision context and stakeholder needs, enabling data-driven investment decisions across multi-million dollar media budgets. - Analyzed sales drivers, promotional effectiveness, and seasonality patterns using statistical modeling; identified optimization opportunities that informed strategic budget recommendations across client portfolios. - Standardized data preparation workflows for proprietary modeling tools using Python and Excel automation, reducing pre-model setup time by ~30% and ensuring consistent delivery quality across concurrent multi-geography engagements. - Collaborated with data engineering, client management, and operations teams to align analytical deliverables with business goals; managed competing stakeholder requirements across concurrent projects in US and European markets.

Research Analyst at AiRA, Jan 2022 - May 2022 · 5 mos

Frontend Developer Intern at Alore - Growth OS, May 2019 - Jun 2019 · 2 mos, Bengaluru Area, India

Education

Bachelor of Technology - BTech, Chemical Engineering, Manipal institute of technology