Badges
Certifications
Work Experience
Business Technology Solutions Associate
ZS Pharma•  July 2021 - April 2023
1. Creating a Datawarehouse layer on EMR using Spark SQL as per client requirement to generate key insights and implement different business standards. 2. Responsible for development, maintain ETL jobs, extract data from different sources such as Veeva CRM, Veeva Vault, S3 by using SQL, python scripts for call API, shell scripts. 3. Debugging existing ETL process and performance tuning to fix bugs. 4. Creating Glue Job for pushing data on a weekly basis to push the data to redshift for client visibility. 5. Automated end-to-end ETL processes for weekly refresh of data using a tool called Azkaban. 6. Created shell and python script for a different use-case for pulling data from API and automated it. 7. Created tables as per client requirement in EMR from Redshift and automating it by creating stored procedures. 8. Developed a global reporting solution to cover different countries in US, APAC, LATAM, EUCAN, CHINA, JAPAN, TWHK. 9. Developed reporting tables for Sales data to generate insights displayed in Tableau. Skill: Big data, Data and Analytics, ETL, Spark SQL, Hadoop, Data Warehousing, Database Management, AWS, Shell Scripting, MS Excel, MS Word, MS PowerPoint, Visio, Leadership, Python
Education
Asansol Engineering College
Information Technology, B.Tech•  July 2017 - August 2021