Bhavesh Singh

Experience

• 

  Hindustan Powerprojects Private Limited

  Jun 2019 - Jul 2019

  Internship Trainee

  Finance & Accounts Department

• 

  Cilio AutomationFactory

  Sept 2021 - Dec 2023

  1. Developed 30+ ETL dynamic pipelines with Azure Data Factory (ADF) fetching current/historical financial & FX data from multiple vendor's APIs in JSON/Parquet format, transforming (using Azure Data Flows) and populating the data into SQL DB Tables/Views. Relevant config and log tables were made with email alerts for pipeline failure/success. Saving up to 50 man-hours monthly.2. Migrated AWS Redshift DW to Azure Dedicated SQL pool (formerly SQL DW) with ADF containing IOT data coming from solar panels. Migrated AWS Quicksight Dashboards to Power BI, converting Redshift DW syntax used in Quicksight queries to Dedicated SQL pool syntax. Resulting in 10x cost reduction.3. Migrated Intellicus Reports to Power BI, converting intricate Non-ANSI MySQL queries syntax to ANSI Redshift syntax to be used in Power BI Reports.4. Converted PowerShell scripts to ADF pipeline and created pipelines to fetch GraphQL data, populating transformed data to SQL DB.5.- Created Azure Dashboards for ADF & ADLS gen2 analytics.- Created pipelines for fetchinng forms data from an API in CSV format, transforming (using data flows) and populating in SQL DW.- Complete Azure Environment Handling (Azure Advisor, Databricks/Stream Analytics/Event Hub/ADF monitoring and maintenance)- Migrated ADF pipeline to Azure Function App fetching, transforming, and sending generated files to AWS S3 bucket, using real-time IOT data with 5 minute trigger.6. Created Power BI dashboards for automating monthly Actuals & Budgets Reports for a logistic giant Show less

  • Data Engineer/Analyst

    Jan 2022 - Dec 2023

  • Internship

    Sept 2021 - Jan 2022
• 

  Teleperformance

  Jan 2024 - now

  Senior Analyst Business Intelligence

  1. Azure Dedicated SQL pool (formerly SQL DW) optimization and time deduction for developed ADF ETL pipelines.