Looks like you have JavaScript disabled. For the full Twine experience, you will need to re-enable it.

Hi, I’m Smitashivanandan, a Senior Analytics Consultant based in Pune, India. I have 9+ years of experience in SQL/BI and 4+ years in SaaS analytics, with a focus on large transactional datasets, operational workflows, and performance metrics. I design scalable data architectures and deliver actionable insights for growth, retention, and inventory visibility. I specialize in building robust data models, dashboards, and automated ELT/ETL pipelines using modern tools (BigQuery, dbt, Power BI, Fivetran, Stitch, Airflow), collaborating closely with cross-functional teams to drive data-driven decisions and measurable business impact.…Hi, I’m Smitashivanandan, a Senior Analytics Consultant based in Pune, India. I have 9+ years of experience in SQL/BI and 4+ years in SaaS analytics, with a focus on large transactional datasets, operational workflows, and performance metrics. I design scalable data architectures and deliver actionable insights for growth, retention, and inventory visibility. I specialize in building robust data models, dashboards, and automated ELT/ETL pipelines using modern tools (BigQuery, dbt, Power BI, Fivetran, Stitch, Airflow), collaborating closely with cross-functional teams to drive data-driven decisions and measurable business impact.

Smitashivanandan

Data Analyst, Data Scientist, AI Strategy Consultant, +2





Hi, I’m Smitashivanandan, a Senior Analytics Consultant based in Pune, India. I have 9+ years of experience in SQL/BI and 4+ years in SaaS analytics, with a focus on large transactional datasets, operational workflows, and performance metrics. I design scalable data architectures and deliver actionable insights for growth, retention, and inventory visibility. I specialize in building robust data models, dashboards, and automated ELT/ETL pipelines using modern tools (BigQuery, dbt, Power BI, Fivetran, Stitch, Airflow), collaborating closely with cross-functional teams to drive data-driven decisions and measurable business impact.…Hi, I’m Smitashivanandan, a Senior Analytics Consultant based in Pune, India. I have 9+ years of experience in SQL/BI and 4+ years in SaaS analytics, with a focus on large transactional datasets, operational workflows, and performance metrics. I design scalable data architectures and deliver actionable insights for growth, retention, and inventory visibility. I specialize in building robust data models, dashboards, and automated ELT/ETL pipelines using modern tools (BigQuery, dbt, Power BI, Fivetran, Stitch, Airflow), collaborating closely with cross-functional teams to drive data-driven decisions and measurable business impact.

Available to hire

Hi, I’m Smitashivanandan, a Senior Analytics Consultant based in Pune, India. I have 9+ years of experience in SQL/BI and 4+ years in SaaS analytics, with a focus on large transactional datasets, operational workflows, and performance metrics. I design scalable data architectures and deliver actionable insights for growth, retention, and inventory visibility.

I specialize in building robust data models, dashboards, and automated ELT/ETL pipelines using modern tools (BigQuery, dbt, Power BI, Fivetran, Stitch, Airflow), collaborating closely with cross-functional teams to drive data-driven decisions and measurable business impact.

Skills

Experience Level

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Intermediate

Intermediate

Language

English

Fluent

Hindi

Advanced

Malayalam

Advanced

Work Experience

Senior Data Consultant at Launch Control

September 20, 2024 - September 20, 2024

Designed modern data architecture with BigQuery, dbt, and Power BI, establishing a single source of truth and trusted decision-making. Shifted reporting cadence from weekly to hourly with yearly trend views, delivering real-time KPI visibility and cutting time-to-insight by 95%. Developed dbt models for MRR, churn, retention, and growth accounting, enabling proactive churn interventions. Built compliance dashboards to flag risks, improving delivery reliability and operational visibility. Optimized data warehouse models, reducing costs by 74% while scaling analytics. Delivered self-service Power BI dashboards empowering GTM, Ops, and Product teams with faster answers. Automated ELT pipelines with Fivetran, Stitch, and Airflow for reliable, scalable data ingestion.

Power BI Consultant at Salesorder.com

April 6, 2020 - October 31, 2023

At Salesorder, I delivered end-to-end self-service BI for multiple clients, building their inventory, sales, and fulfillment analytics frameworks from the ground up. I standardized reporting with a reusable Power BI semantic layer, cutting onboarding time and reducing dependency on vendor teams. Working directly with the CEO/CTO, I built dashboards that exposed multi-million-dollar dead stock, improved replenishment decisions, and gave leaders clear visibility into performance, turnover, and operational bottlenecks. The result was faster decisions, cleaner inventory, and analytics that scaled seamlessly across teams and clients.

BI Analyst at Tata Consultancy Services

June 6, 2005 - September 30, 2010

I worked as an IT Analyst for an American bank, where I designed and developed PL/SQL scripts, procedures, and triggers, optimized query performance, and built ETL pipelines in SSIS and reporting solutions in SSRS integrated with .NET and deployed to production.