Ankit Yadav
@ankityadav13
I build scalable analytics pipelines and dashboards that improve business decisions.
IndiaWhat I'm looking for
At SmartQ, I deliver end-to-end analysis with BigQuery, Power BI, Python, and SQL for India operations and post-launch performance. I've automated data preparation to cut manual effort by 40%, optimized BigQuery costs by 8–10%, and improved Power BI refresh times by 10–15 minutes.
Previously at Sigmoid Analytics, I supported Jack in the Box supply chain analysis, improved Redshift processing efficiency by 20%, and delivered Power BI and Tableau reporting. At Play Games24x7, I built an end-to-end BI pipeline from Kafka and Spark ETL through datamarts and dashboards, helping increase D7 retention by 10% and revenue by 15% through sales analytics.
I've also delivered stakeholder-focused Tableau and Excel reporting at Ericsson, where my data cleaning and audit processes reduced errors and discrepancies. I use generative AI tools including Claude to accelerate exploratory analysis, dashboard prototyping, DAX development, and data modeling.
Experience
Work history, roles, and key accomplishments
Senior Data Analyst
SmartQ
Nov 2024 - Present (1 year 9 months)
Delivered end-to-end data analysis using BigQuery and Power BI, producing business-critical insights for India operations. Leveraged generative AI to accelerate exploratory analysis and prototype dashboards, and automated data preparation with Python, cutting manual effort by 40%.
Senior Data Analyst
Sigmoid Analytics
Oct 2023 - Nov 2024 (1 year 1 month)
Led requirement gathering for a client in supply chain management and wrote complex SQL in Redshift for ad hoc analysis, achieving a 20% improvement in data processing efficiency. Developed Power BI dashboards and reduced Tableau extract refresh time by 15%.
Data Analyst
Play Games24x7 Private Limited
May 2022 - Oct 2023 (1 year 5 months)
Designed and built a BI pipeline end-to-end from Kafka and Spark ETL to Power BI visualizations. Automated data pipelines using AWS and built a data pipeline for App Event Optimization, increasing D7 retention by 10%.
Data Analyst
Ericsson
Dec 2019 - May 2022 (2 years 5 months)
Designed and delivered reports and dashboards on Excel and Tableau using Scrum/Agile methodology. Developed data cleaning procedures reducing data errors by 20% and tracked product KPIs including MRR and CAC.
Education
Degrees, certifications, and relevant coursework
IET, MJP Rohilkhand University
Bachelor of Technology, Electronics and Communications Engineering
Bachelor of Technology in Electronics and Communications Engineering from IET, MJP Rohilkhand University, Bareilly, completed in June 2019.
Kendriya Vidyalaya Air Force Station
High School / Intermediate, Science
Completed High School and Intermediate with Science (PCM) from Kendriya Vidyalaya Air Force Station in May 2015.
Tech stack
Software and tools used professionally
Availability
Location
IndiaAuthorized to work in
Job categories
Skills
Interested in hiring Ankit?
You can contact Ankit and 90k+ other talented remote workers on Himalayas.
Message AnkitGet matched with your dream remote job
Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!
