Shivang Gupta

IT Analyst

Tata Consultancy Services•  December 2022 - Present

Data engineer | Big data | AWS | Airflow | Snowflake | Python | Shell scripting

Associate Consultant - Automation

XL Group•  December 2019 - November 2022

Responsible for development of SQL queries, stored procedures, functions, tables, and views and run tasks for data migration between multiple SQL servers. Working on Data analytics using Apache Spark and Python. Good understanding of spark architecture with databricks, structured streaming, databricks workspace for business analytics. Experience in data extraction, writing parallelized code, transformations and loads (user - defined functions, join optimizations. Partitioning and programming with MapReduce.

Contractor

accenture•  November 2017 - December 2019

• MS Excel automations using Visual Basic for applications. • Developed SQL queries to fetch data from MS Access databases. • Created relational tables, Queries, Forms and Reports in MS Access. • Automated Transportation cost invoice processing using Microsoft Visual Basic and SAP GUI scripting.