Ankit Verma

Experience

• 

  ICAT-International Centre for Automotive Technology

  Jan 2016 - Jan 2017

  Diploma Engineer trainee
• 

  UpGrad Campus

  Jun 2022 - Jan 2023

  Data science with AI Certification program

  Data Analysis in Excel | Database |MySql |Python|Data Visualization with python | Tableau|Power BI | Machine Learning

• 

  Guardian

  Oct 2022 - now

  Data Engineer

  • Established robust data extraction pipelines and REST APIs using Python for platforms like Shopify, Meta Ads, Google Ads, Google Analytics 4, and Firebase, improving data accessibility and reducing data retrieval time. • Created custom APIs, connected to AWS SQL for data storage, and set up data warehouses using Google BigQuery & SQL Server, centralizing and optimizing data storage & retrieval. • Developed automated web scrapers and email alerts using Beautiful Soup and Selenium, reducing manual monitoring efforts, and set up automated updates to Google Sheets with Gspread and cron jobs in Linux, increasing data processing efficiency. • Designed and implemented 10+ insightful BI dashboards using Google Looker Studio, leading to a 50% improvement in decision-making and data-driven insights. • Conducted comprehensive data analysis, monitored KPIs, and performed exploratory data analysis with Python, providing actionable insights and boosting app performance metrics. • Optimized website speed and tracked performance KPIs through Python automation, enhancing the user interface and experience by 40%. Show less