Abhishek roy
• Automated ETL processes across billions of rows of data, which reduced manual workload by 29% monthly.
• Build AWS solution to ingest data from different sources and produce output to Redshift Cluster cluster which reduces the manual effort of the client by 75%.
• Ingested data from disparate data sources using a combination of SQL, S3 and Snowflake using Python and Wherscape RED to create data views to be used in BI tools like Power BI.
• Worked with client to understand business needs and translate those business needs into actionable reports in Power BI, saving 12 hours of manual work each week.
- Role
Software Development & Alexa Engineer
- Years of Experience
5.5 years
Skillsets
- Hive
- Wherscape
- Snowflake
- SDK
- S3
- RED
- Python
- PowerBI
- Postgres
- NoSQL
- Nodejs
- MongoDB
- LLM
- JS
- Java
- MySQL - 3 Years
- Glue
- EMR
- BigData
- Athena
- Alexa
- Hadoop
- Spark
- ETL
- AWS - 3 Years
- AWS - 3 Years
- SQL - 3 Years
- PySpark - 3 Years
- PySpark - 3 Years
Professional Summary
5.5Years
- Sep, 2023 - Present2 yr 8 months
Data Engineer
Tredence Inc. - Jun, 2022 - Sep, 20231 yr 3 months
SDE - 1
Amazon - Nov, 2020 - Jun, 20221 yr 7 months
Application Developer
IBM - Jun, 2019 - Jul, 2019 1 month
Associate Engineer
Samsung Electronics
Work History
5.5Years
Data Engineer
Tredence Inc.Sep, 2023 - Present2 yr 8 months
SDE - 1
AmazonJun, 2022 - Sep, 20231 yr 3 months
Building data pipeline using Spark to process data displayed on Alexa developer console. Working on the Amazon Alexa skill kit team to develop NodeJs LLM SDK for LLM-based Alexa skills. Designed and developed Alexa Account linking component used to build Alexa skills requiring 3rd party vendor account details. Designed and developed End to End Test framework for Alexa skills.
Application Developer
IBMNov, 2020 - Jun, 20221 yr 7 months
Automated ETL processes across billions of rows of data, reducing manual workload by 29% monthly. Built AWS solution to ingest data from different sources and produce output to Redshift Cluster, reducing client manual effort by 75%. Ingested data from disparate sources using SQL, S3, and Snowflake with Python and Wherscape RED to create data views for BI tools like Power BI. Worked with client to understand business needs and translate them into actionable Power BI reports, saving 12 hours of manual work weekly.
Associate Engineer
Samsung ElectronicsJun, 2019 - Jul, 2019 1 month
Major Projects
1Projects
Don loose today
Education
B.E. in Electronics & Telecommunication Engineering
Jadavpur University (2020)
Certifications
SAP-C01 Certi cation