Eurozone and UK Market Analysis.

Building Business Analytics and EPM solutions for planning, analysis, forecasting, and performance management for finance, workforce, supply chain, Sales, and Operations using the Anaplan models.Built data pipelines for bulk loading and micro-batches using COPY INTO and Snowpipe.Extensively worked on data ingestion into snowflake raw layer sourcing delimited, parquet, and JSONfiles from AWS S3 bucket.Ingested and processed batch and streaming data using AWS Lambda and AWS Glue… Show more Building Business Analytics and EPM solutions for planning, analysis, forecasting, and performance management for finance, workforce, supply chain, Sales, and Operations using the Anaplan models.Built data pipelines for bulk loading and micro-batches using COPY INTO and Snowpipe.Extensively worked on data ingestion into snowflake raw layer sourcing delimited, parquet, and JSONfiles from AWS S3 bucket.Ingested and processed batch and streaming data using AWS Lambda and AWS Glue, ensuring efficient ETLworkflows. Leveraged AWS Redshift for scalable data warehousing solutions.Implemented data mapping into Snowflake SQL code, near-real-time solutions using Snowflake Streamsand transformations using snowflake Tasks. Well-versed in Zero Copy Cloning and Time travel.Developed and implemented Snowpark Python to complex data transformations within Snowflake.Extensively implemented Slowly Changing Dimensions in the domain layer.Project: US-Based bank, Infosys Ltd. (Oct 2021- Mar 2024)Built data pipelines for a US-based Bank, dealing with mortgage, lending, credit card, auto dealer, and investment line of business.The Client wanted to migrate on-premise SQL Server and Oracle databases to the cloud, ensuring a single-source-of-truth data repository for incremental data sets.Utilized Click Replicate to migrate data from Oracle and SQL Server to Snowflake efficiently.Implemented ETL/ELT process to ingest incremental data from AWS S3 into Snowflake using COPY INTO and Snowpipe. Managed and organized raw data storage in the Snowflake RAW layer.Developed and executed business transformations using Snowflake tasks, transferring data to the Domain layer. Domain data is curated as per the business requirement and loaded into the Consumption layer for data visualization. Show less

Sumer Training at DRDO, Chandipur (June 2019)- Worked under Sc. Soumitra Ray in Central Timing Dept. and build “Ethernet Based Time Code Reader” using raspberry pi, python and socket communication.