Omkar Gandhi

Data Analyst with 4+ years delivering BI solutions and insights across large enterprise datasets. Proficient in SQL, Python, Power BI (DAX), Tableau, Azure, and cloud data engineering. Proven track record building ETL pipelines, data models, and KPI dashboards for senior stakeholders. MSc Data Science & Analytics — 1st Class, University of Hertfordshire. Right to work in the UK. Open to relocating within the UK.

Data Analyst at Tata Consultancy Services (2022-01 – 2023-09)

Data Analyst role delivering BI solutions, ETL pipelines, and data models across enterprise datasets

• Redesigned SQL-based ELT pipelines and data models, improving processing efficiency by 30% and reducing system downtime across reporting infrastructure.
• Automated recurring reporting workflows using Python (Pandas, NumPy), cutting manual effort by 25% and speeding up weekly report delivery.
• Extracted, cleaned and migrated 1M+ enterprise records using SQL, maintaining full data integrity with zero data loss across all business-critical reports.
• Built Power BI and Tableau dashboards for 15+ KPIs across 3 business units, giving senior stakeholders clear real-time visibility into operational performance.
• Conducted exploratory data analysis (EDA) and statistical analysis on large enterprise datasets to identify trends, anomalies, and business opportunities, presenting findings directly to senior stakeholders
• Implemented data quality validation frameworks using SQL and Python, proactively identifying data inconsistencies across source systems and reducing downstream reporting errors by 20%.

Software Engineer at Human Cloud Technologies (2021-09 – 2021-12)

Software Engineer role optimizing SQL workflows and automating data extraction tasks

• Optimised 10+ SQL queries, stored procedures and ETL workflows, cutting pipeline processing time by 25%.
• Collaborated with senior engineers to gather technical requirements and document data pipeline specifications, supporting end-to-end testing and validation of ETL workflows.
• Used Python to automate repetitive data extraction and formatting tasks, improving team productivity and reducing manual effort by approximately 20%.
• Supported cloud-based data workflows on AWS (S3), assisting in the automated storage and retrieval of structured datasets to ensure seamless data availability for downstream analytics and reporting pipelines.

Software Developer at CRO Splendid Lab (2019-01 – 2021-05)

Software Developer role designing backend data processing modules and supporting cloud deployments

• Designed and developed backend data processing modules handling large volumes of structured data, ensuring accuracy, consistency and cross-platform reliability.
• Followed SDLC best practices and ran QA testing across 5+ client projects, cutting software defects by 90% and making releases far more stable.
• Wrote and optimised SQL queries to support application reporting features, improving data retrieval speed and reducing load times for client-facing dashboards.
• Supported deployment of data processing scripts on GCP (Google Cloud Platform), assisting in automating batch data jobs and improving pipeline reliability for client-facing reporting systems.

MSc in Data Science & Analytics – University of Hertfordshire (2024-01 – 2025-05)

B.E. in Electronics & Telecommunication – University of Pune (2014-06 – 2019-08)