Hitesh Singh

Working on ingesting data from disparate sources like Oracle/SQL Server DBs and Azure Blobs to Azure Data Lake Storage (ADLS) using Azure Data Factory (ADF) and Azure Databricks (ADB). Developed and maintained scalable data pipelines and leveraging AWS Redshift as the data warehousing solution. Designed ETL workflows using AWS Glue to extract, transform and load data from various sources to AWS Redshift, enabling effective data processing and analysis. Created different types of Triggers to kick-off Pipeline according to the need.

Worked on Grand Vision Portugal-MultiOpticas banner data to write and test queries for various computed columns in Big Query using appropriate source columns and interim tables. Development of churn prediction and customer lifetime value (CLV) estimation model for Grand Vision UK-Vision Express banner's final load data to get best business insights for marketing and discounting. Performed Exploratory Data Analysis (EDA) on Grand Vision UK-Vision Express banner's data to analyse and investigate on data sets for calculating CLV value and Churn Rate estimation.

Customer segmentation based on recency, frequency, monetary value using Joins and Window functions in SQL Server to roll out suitable offers to them via e-mail, messages and push-notifications. Contributed to the realm of analytics by offering insightful data-driven analysis using SQL and Power Bi.