VIVEK PATHAK

As a Senior Data Engineer I bring over 2+ years of solid experience as an AWS Data Engineer in IT industry, I excel in designing and implementing data solutions on AWS. I possess strong proficiency in Python, SQL, and Pyspark, alongside adeptness in BI tools like Amazon Quicksight, Tableau, and Power BI.

• Jigsaw Academy, Bangalore, Full Stack Data Science with Python and R
• Associate AWS Data Engineer
• Associate AWS Solutions Architect

Alghanim Industries(APR, 2022 - JUN, 2022)

• Assiste client in replacing manual reporting processes on outdated BI platforms.
• transition an outdated BI platform to Amazon QuickSight, harnessing advanced functionalities such as Q Topic and Incremental Refresh.

  Skills: Amazon QuickSight

  AWS Services: Amazon Redshift

Internal (DQM)(MAY, 2022 - NOV, 2022)

• Develop a Python-based data quality management solution that integrates data profiling and visualization within a BI.
• Improve data governance, enhance data integrity, and protect sensitive PII information.

  Skills: Python, Pyspark, Amazon QuickSight

  AWS Services: Amazon S3, Athena, Glue, DynamoDB

Q2Q/Nuvance Health(DEC, 2022 - JUL, 2024)

• Develop a Python-based solution to automate the generation of inventory, assessment reports and migration of Tableau workbook to QuickSight.
• Generate the Inventory and Assessment reports for 177 Tableau workbooks.
• Identify active and inactive users and assess current Tableau infrastructure costs to determine potential savings through migration to QuickSight
• Automate migration of 1 client-selected Tableau workbook, achieving a 35% reduction in cost and a 65% decrease in effort.

   Skills: Python, Amazon QuickSight, Tableau Sever/Cloud.

  AWS Services: S3, DynamoDB, ECS, CodeCommit, CodeBuild, Cloudshell, CloudWatch

LONZA GROUP AZ(FEB, 2020 - DEC, 2020)

• Create an ETL pipeline on Microsoft SSIS for Lonza Group.
• Design and develop SSIS packages and stored procedures to stream line the transformation layer of data.
• Develop end-user reports for data analysis.

   Skills: SQL Server, SSIS, SQL, Microsoft Power BI

• Rising Star - For R&D on Amazon QuickSight Q feature and embedded analytics.
• One Man Army - For exceeding expectations to meet the client's demands.
• Kaizen - For enhancing the existing processes.