Om Ingale Email & Phone Number

Mumbai, Maharashtra, India

Mumbai, Maharashtra, India

Project – IMSHighlights: This project is involved migrating analytics and data warehouse platform to snowflake cloud warehouse and integrate with Tableau dashboards. Key Result Areas: • Developed a Python code for automating extracting Mainframe data from DB2 database and loading into Snowflake permanent tables.• Performed transformations on data by creating user-defined functions in JavaScript along with built-in functions.• Worked on creating automated stage process… Show more Project – IMSHighlights: This project is involved migrating analytics and data warehouse platform to snowflake cloud warehouse and integrate with Tableau dashboards. Key Result Areas: • Developed a Python code for automating extracting Mainframe data from DB2 database and loading into Snowflake permanent tables.• Performed transformations on data by creating user-defined functions in JavaScript along with built-in functions.• Worked on creating automated stage process for Type 2, insert only and Upsert load strategies using Snowflake stored procedures, taking the data from landing to stage.• Created Airflow python scripts and package for establishing connection with Snowflake and IBM to carry out and schedule the ELT process.• Created job status table for tracking and monitoring the status of ELT jobs executed for each table.• Handling admin activities like giving access control to particular tables/schema only to the respective teams by creating roles.• Writing complex snowflake queries for transformation and tune the snowflake data model for better performance using materialized views and clustering keys.• Created stored procedure to give output result in JSON format according to the JSON input which was connected to Mules API. Show less

Mumbai, Maharashtra, India

Project: Ingredion ManufacturerLoading data and performing transformations on data in SQL Server and creating business reports and charts using the data with PowerBI.  Managed to create records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching. Handled Data cleaning and transforming.  Created views for complex SQL queries having… Show more Project: Ingredion ManufacturerLoading data and performing transformations on data in SQL Server and creating business reports and charts using the data with PowerBI.  Managed to create records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching. Handled Data cleaning and transforming.  Created views for complex SQL queries having aggregated data for further analysis. Created stored procedures using Pl/SQL taking number of inputs to obtain the desired filtered result. Analyzed performance of SQL Queries & performance tuning of the slow running queries. Designed and created dashboards and charts on the SQL Server data using PowerBI. Show less

Mumbai, Maharashtra, India

3. Project – NumeratorThis project is implementing Datawarehouse using Pentaho and snowflake. Also, migrating Pentaho to airflow for distributed processing & Automation.Key Result Areas:• Managed to load data in snowflake system using Airflow.• Worked on snowflake SQL queries for transformation.• Uploaded data to AWS S3 and copy data from AWS S3 into snowflake.• Used zero-copy cloning to clone database objects from PRD to QAT and DEV environment.• Configured data… Show more 3. Project – NumeratorThis project is implementing Datawarehouse using Pentaho and snowflake. Also, migrating Pentaho to airflow for distributed processing & Automation.Key Result Areas:• Managed to load data in snowflake system using Airflow.• Worked on snowflake SQL queries for transformation.• Uploaded data to AWS S3 and copy data from AWS S3 into snowflake.• Used zero-copy cloning to clone database objects from PRD to QAT and DEV environment.• Configured data retention period to prevent accidental deletes and data recovery Show less

Master Of Science - Ms, Data Science

Bachelor Of Science - Bs, Statistics

Hsc, Pcm With Computer Science

Ssc Maharashtra Board