Rahul SIRAS

Create storage integration between AWS and Snowflake; Create and configure an S3 bucket on AWS and create folders; Provide required permission to AWS S3 bucket under Bucket policy; Ensure Matillion workflow output stored into AWS S3 Bucket; Use Snow-pipe for Real-time Ingestion from MDS data; Ensure data is stored in a Snowflake-compatible format; Prepare Market Submission report for clients, HHRVOLS, HHRAGGR and EIEP3 reports for clients; Writing SQL Procedures and modifications; Real time data replication using Qlik (QEM) and Snowflake Snow-pipe setup; Monitoring real time data replication and source & destination end points; Preparing Matillion Workflows and scheduling jobs as per requirements; Handling User access, roles and profiles for Snowflake Users.

Migration of EDW tables (On-prem) to Snowflake (Cloud) using ADF pipeline; Create and monitor ADF pipeline for Machine learning model; Maintain recent data into Snowflake Data Lake for ML model training Data Sets; Providing weekly leads for Device propensity and winter deals campaign; Interactions with end users/customers for requirement gathering; Preparing reports for Spotify Migration to VAS Framework; Writing SQL / Snowflake queries for data processing; Works as a dedicated team member of Customer Data squad in Spark NZ ltd; Maintaining Data quality and Governance compliance; Design of various data reports and publish it on Oracle APEX portals; Writing of data automation scripts on OS level and update data on daily basis; Preparation of Spotify Reconciliation reports and sharing it with Finance Dept.

Installation, configuration and manages the MS SQL, Oracle Server, and Database Administration; Gathering raw data from various sources and accommodating it into one source; Maintain data accuracy, optimize data delivery, maintain data structures and data processing; Checking data discrepancies and maintaining valid & consistent data in the Data Warehouse; Designing various reports and sharing it with managements and stake holders; Execution of periodic background jobs for CRM-ECC data replication; Manage Windows, SQL server or CRM Application updates on regular basis.

Oracle and MS SQL Database Administration & validation of Backup on daily basis; Installation of New Database and ERP Software's and support the applications Software; Installation of SAP S4 HANA, ECC, BW, SRM, Portal, TREX systems and post installation configuration; Writing Database stored procedures & code to refresh SAP Databases on regular basis; Responsible for BAU and discretionary work in projects; Responsible for SAP Release & Cutover, Go-live projects.