Vivek Pathak

Project: Client Data Exchange/JPMorgan Chase & Co.

• Developed scalable data engineering solutions on AWS using Python and PySpark for various enterprise data needs.
• Designed and implemented reusable frameworks in AWS Glue for data transformation pipelines supporting structured and semi-structured datasets.
• Contributed to BvD migration project using Terraform, ensuring secure and scalable infrastructure deployment across environments.
• Integrated AWS services such as Step Functions, EventBridge, SNS, and Lambda to automate complex event-driven workflows with robust observability via CloudWatch.
• Contributed to multiple feature upgrades and production enhancements improving overall pipeline efficiency and reliability.

Technology & Tools:

• AWS Services- Glue, Step Functions, Lambda, S3, Athena, SNS, EventBridge, CloudWatch
• Infrastructre: Terraform
• Scripting- Python, Pyspark

Project: Q2Q (Quick to Quicksight)/Nuvance Health

• Developed a Python-based solution to automate the generation of inventory, assessment reports and migration of Tableau workbook to Quicksight.
• Assisted in identifying active and inactive users and assess current Tableau infrastructure costs, determining potential savings through migration to QuickSight.

Technology & Tools:

• AWS Services- S3, ECS, DynamoDB, CloudWatch, Cloudshell, Amazon Q, Lambda
• Scripting- Python
• Business Intelligence- Amazon Quicksight, Tableau Server

Project: Internal (DQM)

• Developed a Python-based data quality management solution that integrates data profiling and visualization within a BI.
• Improved data governance, enhanced data integrity, and protected sensitive PII information.

Technology & Tools:

• AWS Services- S3, Athena, Glue, Dynamo DB, Lambda
• Scripting- Python, Pyspark
• Business Intelligence- Amazon Quicksight

Project: Supply Chain/Hindustan Unilever

• Worked in the field of data visualization on Power BI in Supply Chain Domain.
• Reshaped the data as per the business needs using Python.
• Improved existing BI systems and created visualization and reports for requested projects.

Technology & Tools:

• Scripting - Python, Excel
• Business Intelligence - Microsoft Power BI

Project: Inventory Management/LONZA GROUP AG

• Created an ETL pipeline on Microsoft SSIS for Lonza Group.
• Designed and developed SSIS packages and stored procedures to streamline the transformation layer of data.
• Developed end-user reports for data analysis.

Technology & Tools:

• Microsoft BI Suit- SQL Server, SSIS, Excel
• Business Intelligence- Microsoft Power BI