# Shantanu Upparwal

Shantanu Upparwal is a remote worker on Himalayas, Data Engineer at Onecom, based in India.

Source: https://himalayas.app/@shantanuupparwal

```text
Data Engineer at Onecom building telecom billing pipelines and reporting that prevented £1,000–£2,000 in monthly billing costs.
```

| Detail | Value |
| --- | --- |
| Availability | Open to opportunities |
| Location | India |
| Authorized to work in | India |
| Job categories | Data Engineer, Technical Consultant |
| Skills | Data Engineering, ETL ELT, Data Warehouse, Data Modeling, BigQuery, SQL, Python, Airflow, dataform, Airbyte, Apache Spark, Google Cloud Platform, Google Cloud Storage, AWS, Snowflake |

## About

```text
At Onecom, I maintain and enhance enterprise ELT pipelines for the CMSP platform and designed end-to-end data pipelines for the ISP (Vodafone) platform. My work supports telecom billing and finance reporting, including automated reporting for 10,000+ CTNs and a billing defect fix that prevented incorrect charges and reduced unnecessary costs by £1,000–£2,000 per month.

At BluePi Consulting, I optimized BigQuery pipelines and developed an enterprise SQL Assistant using Python, Ollama, RAG, vector embeddings, and Snowflake. I also built AI and data pipeline projects for financial research and structured, validated AI-generated data.
```

## Experience

### Data Engineer (current)

Onecom. Sep 2025 - Present

```text
Maintained and enhanced enterprise ELT pipelines for the CMSP platform and designed end-to-end data pipelines for the ISP (Vodafone) platform using BigQuery, Dataform, Apache Airflow, Airbyte, Google Cloud Storage (GCS), Cascade, and Salesforce, enabling scalable telecom billing and finance reporting. Developed and optimized BigQuery SQL transformations for telecom billing, CTN lifecycle managemen
```

Skills: BigQuery, dataform, Airflow, Airbyte, Google-Cloud-Storage, Salesforce, SQL, Git, Metabase, Telecom-Billing, Data-Pipelines, ELT, Data-Warehouse, Data-Modeling

### Technical Consultant

AussTech Fusion. May 2025 - Jul 2025

```text
Built custom AL extensions in Microsoft Dynamics 365 Business Central to automate invoicing, PO approvals, and pricing workflows. Integrated Business Central with Power BI through OData and Dataverse, delivering real-time operational dashboards.
```

Skills: Microsoft-Dynamics-365-Business-Central, Power-BI, OData, Dataverse, DAX, Star-Schemas, Data-Modeling

### Data Engineer

BluePi Consulting. Mar 2024 - May 2025

```text
Optimized BigQuery pipelines using Iceberg and external tables, reducing query costs and improving performance. Migrated MS SQL workloads to BigQuery and developed scalable ETL pipelines using GCS, Dataflow, Apache Airflow, PostgreSQL, AWS S3, and Snowflake.
```

Skills: BigQuery, Iceberg, MSSQL, ETL, GCS, Dataflow, Airflow, PostgreSQL, S3, Snowflake, Python, RAG, Ollama, Embeddings, EC2

## Education

### UPES

Bachelor of Technology, Electronics & Communication Engineering. 2019 - 2023

```text
Pursued a Bachelor of Technology in Electronics & Communication Engineering from 2019 to 2023.
```

## Tech stack

- Snowflake
- Airbyte
- Apache Spark
- Looker
- Metabase
- Dataform
- Google Cloud Platform
- Google Cloud Storage
- NumPy
- Pandas
- PostgreSQL
- Microsoft SQL Server
- Python
- JSON
- OData
- Microsoft Excel
- pytest
- Git
- Airflow
- SQL
- Ollama
- Groq
- Microsoft Dynamics 365 Business Central
- Power BI

To contact Shantanu, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Nandini Wadaskar](https://himalayas.app/@nandiniwadaskar): Senior Data Engineer, 5X
- [Arpit Garg](https://himalayas.app/@arpitgarg): Data Engineer (LOTUS), NTT DATA
- [Kajal Kumari](https://himalayas.app/@kajalkumari7): Data Engineer (PySpark), Mavenir
- [Lakshya Rathee](https://himalayas.app/@lakshyarathee): Senior Associate Data Engineer L2, Publicis Sapient
- [Lucky TWL](https://himalayas.app/@luckytwl): Sr. Data Engineer, Cognizant Technology Solutions
- [Harishkv User](https://himalayas.app/@harishkvuser): Principal Data Engineer / Senior Data Analyst, Google
- [Sahasil Ak](https://himalayas.app/@sahasilak): Senior Data Engineer, EY
- [Sindhura Patibandla](https://himalayas.app/@sindhurapatibandla): Technical Lead, Optum
- [Shivam Agarwal](https://himalayas.app/@shivamagarwal4): Senior Data Engineer, Kipi.ai
- [anjaneyulu User](https://himalayas.app/@anjaneyuluuser): Software Engineer, Bajaj FinServ Direct Limited
