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
3 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
3Years
- Jun, 2022 - Present3 yr 9 months
Software Development Engineer
Amazon Development Center India - Nov, 2020 - May, 20221 yr 6 months
Data Engineer
IBM India
Work History
3Years
Software Development Engineer
Amazon Development Center IndiaJun, 2022 - Present3 yr 9 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.
Data Engineer
IBM IndiaNov, 2020 - May, 20221 yr 6 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.
Major Projects
1Projects
Don loose today
Education
B.E. in Electronics & Telecommunication Engineering
Jadavpur University (2020)
Certifications
SAP-C01 Certi cation