Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

Shashikumar S A

Lead Data Analysts
Bengaluru,Karnataka

Summary

Results-driven Lead Data Analyst at Livspace with expertise in Python and SQL. Spearheaded the design of optimized ETL processes, reducing AWS costs by 40%. Demonstrated strong leadership in cross-functional teams, delivering advanced analytics solutions that empowered stakeholders with self-service reporting capabilities. Committed to data quality and operational excellence.

Overview

8
8
years of professional experience
3
3
years of post-secondary education

Work History

Lead Data Analyst

Livspace
Bengaluru
07.2017 - Current

Core Competencies Professional Experience

  • Data Engineering: ETL/ELT processes, Data Modeling, Data Warehousing
  • Cloud Platforms: AWS (Glue, Athena, S3, Redshift, RDS), GCP (pilot)
  • Business Intelligence: Power BI, QuickSight
  • Programming & Scripting: SQL, Python
  • Project Management: Agile methodologies, Jira, Cross-functional team leadership

Lead Data Analyst
Livspace, Bengaluru
Apr 2022 – Present · 3 yrs 2 mos

  • Lead a cross-functional team of data analysts and data engineers responsible for designing, maintaining, and optimizing data pipelines using AWS services (DMS, Glue, S3, Athena).
  • Architected and implemented real-time and batch data workflows supporting multiple business units, including Finance and Operations.
  • Delivered advanced dashboards using Amazon QuickSight, improving visibility into revenue, GST, and operational KPIs for senior management.
  • Built reusable datasets that allow business analysts to generate reports without writing complex SQL queries.
  • Created numerous flat tables to reduce dependency on multiple joins, improving query performance and simplifying reporting logic.
  • Collaborated with stakeholders and used Jira to manage Agile-based sprint planning and delivery.
  • Led a pilot initiative to evaluate Kafka and Debezium for real-time data ingestion and GCP for cloud data warehousing; the project was discontinued due to higher costs and limited benefit over AWS stack.

Senior BI Engineer
Livspace, Bengaluru
Jul 2020 – Jun 2022 · 2 yrs

  • Worked on low to medium complex and cross-functional BI solutions.
  • Analyzed business and functional requirements and translated these into robust, scalable, operable solutions.
  • Collected, analyzed, and shared data to help teams improve key business metrics, customer experience, and results.
  • Designed and built reporting tools for more efficient planning, forecasting, and decision-making.
  • Developed and tested BI solutions including databases, views, reports, and dashboards.
  • Enhanced BI tool performance by defining data filters and indexes.
  • Extensively executed SQL queries on SQL Server to validate successful data transactions.

Education

MCA - Computer Applications

Nitte Meenakshi Institute of Technology
Bengaluru, India
06.2012 - 07.2015

Skills

Python programming

Data integration

Optimization techniques

Data warehousing

Advanced analytics

Data quality management

ETL development

SQL expertise

Python programming

Accomplishments

  • Handled GST Data Pipeline Independently : Responded to a critical data request from the GST Department by designing, building, and maintaining a scalable and compliant GST reporting pipeline. Delivered accurate, audit-ready datasets without external support.
  • Reduced AWS Costs by 40% : Identified and eliminated underused resources, optimized Glue job schedules, and restructured S3 partitions to cut operational costs significantly.
  • Built End-to-End Revenue Dashboard : Integrated data across systems to create a comprehensive revenue report, enabling financial transparency and strategic insights.
  • Managed Finance Reports : Automated financial workflows and maintained high reporting accuracy, reducing manual effort by 60%.
  • Empowered Analysts with Self-Service Datasets : Created well-documented datasets in Athena and QuickSight that enabled analysts to build reports independently, improving turnaround time.
  • Improved Query Efficiency via Flat Tables : Designed flat tables for high-usage reporting layers, significantly improving performance and minimizing technical debt.

Timeline

Lead Data Analyst

Livspace
07.2017 - Current

MCA - Computer Applications

Nitte Meenakshi Institute of Technology
06.2012 - 07.2015
Shashikumar S ALead Data Analysts