Avi Rastogi

Experience

• 

  CrazyProf

  Jun 2017 - Aug 2017

  Software Development Engineer Intern

  Created an android application "Gate 5 years - ME (GATE-2018)" which contains solved GATE papers for the past 5 years for Mechanical Engineering students. Techstack used - Android Studio, In-memory DB

• 

  EzySchooling.com

  Jun 2018 - Sept 2018

  Software Development Engineer

  Created an application in python for reading school admission forms and extracting data from them using Optical Character Recognition (OCR) and sending data to the company website into the user accounts. Microsoft Computer Vision API is used to implement OCR, and Django framework is used to create backend.

• 

  Accenture

  Oct 2018 - May 2021

  Developed and maintained python programs which get oil and stocks data fromdatabase, manipulate data for creating and uploading informative graphs to clientwebsite, making easy for client to make predictions on stocks and prices.Developed and maintained python programs to get raw stocks data from web usingweb scraping, and structurizing it to make it improve readability. Reduced datagathering time by up to 50%.Developed and maintained Python programs to clean and organize data obtainedfrom web scraping and load it into database.Improved existing programs and performance, reduced time by 50%, automated dataextraction, graph generation, eliminated manual work, saved > 3 hrs per day. Show less Developed and maintained SAS applications to generate client report, saving 1-2 hrsof manual work. Later automated the process using python, eliminating all manualwork and execution time reduced to only a few seconds.Improved performance of existing SAS applications by reducing execution time up to40%, migrated data from SAS to SQL, reducing cost for using SAS.Developed an Excel VBA application to generate client reports to removedependency from existing SAS application, which reduced execution time up to 50%and saved the cost for using SAS, and was user-friendly. Show less

  • Application Development Analyst

    Dec 2020 - May 2021

  • Application Development Associate

    Oct 2018 - Nov 2020
• 

  Kibaza

  Jun 2021 - Apr 2022

  Senior Software Engineer

  Designed API and backend for a meal planning and tracking application using Python,FastAPI, Elasticsearch.Developed programs to scrape 10000+ recipes from 7 different sources, 6000+ rawingredient facts from 3 different sources and structurized it to store in elasticsearch.Created dashboards to analyze data and use this information in application design.Developed algorithm to extract quantity information from recipe ingredients, andmatch ingredients with raw food item facts. More than 60% matching accuracy.Developed program to calculate recipe nutrition facts using facts data fromelasticsearch to provide users with nutrition info for better meal planning, tracking.Developed program to generate a grocery list based on meals planned to simplifyshopping experience for users. Show less

• 

  Tata Consultancy Services

  Apr 2022 - now

  System Engineer

  Create CI/CD pielines for framework using python.Create DAGs to setup up automated data loads from Amazon S3 files to amazon redshift tables.