Satyam Pandit

Data Engineering Architect @Wavicle Data Solutions

Chicago, IL, US

Cloud Migration Project: Key participant in data migration project from on-premises Cloudera Hadoop system to AWS cloud, to reduce project costs and improve performance. Developed Talend jobs, Python and PySpark scripts for data ingestion and integration. Pricing Snapshot Project: Designed a data warehouse to load Pricing Snapshot data of a chain-restaurant per store per date from the source XML files residing in S3 bucket/ HDFS and store in Redshift database to analyze the sales of the products based on price change Natural Language to SQL: Developed a POC using Python Flask and DialogFlow that transforms natural language questions into corresponding SQL queries for relational databases Nutrition Calculator: Developing a mobile application as part of a POC to provide food items of nearby restaurants based on price and calorie limit per meal.