Prabodhan Mestry Email & Phone Number

Mumbai, Mh, In

𝐏𝐫𝐨𝐣𝐞𝐜𝐭 𝐃𝐚𝐭𝐚 𝐐𝐮𝐚𝐥𝐢𝐭𝐲 𝐈𝐦𝐩𝐫𝐨𝐯𝐞𝐦𝐞𝐧𝐭𝐂𝐥𝐢𝐞𝐧𝐭: Kenvue, a client of vCreatek consulting services pvt ltd. | 𝐌𝐚𝐫 𝟐𝟎𝟐𝟒 𝐭𝐨 𝐏𝐫𝐞𝐬𝐞𝐧𝐭𝐊𝐞𝐲 𝐓𝐞𝐜𝐡𝐧𝐨𝐥𝐨𝐠𝐢𝐞𝐬: Azure Databricks, ADLS, ADF, Snowflake, DBT, Apache Airflow• Provided daily data support and calculated Data Quality Index (DQI) scores, assessing accuracy and coverage for various Key Data Elements (KDEs)• Designed and implemented data pipelines to meet business needs… Show more 𝐏𝐫𝐨𝐣𝐞𝐜𝐭 𝐃𝐚𝐭𝐚 𝐐𝐮𝐚𝐥𝐢𝐭𝐲 𝐈𝐦𝐩𝐫𝐨𝐯𝐞𝐦𝐞𝐧𝐭𝐂𝐥𝐢𝐞𝐧𝐭: Kenvue, a client of vCreatek consulting services pvt ltd. | 𝐌𝐚𝐫 𝟐𝟎𝟐𝟒 𝐭𝐨 𝐏𝐫𝐞𝐬𝐞𝐧𝐭𝐊𝐞𝐲 𝐓𝐞𝐜𝐡𝐧𝐨𝐥𝐨𝐠𝐢𝐞𝐬: Azure Databricks, ADLS, ADF, Snowflake, DBT, Apache Airflow• Provided daily data support and calculated Data Quality Index (DQI) scores, assessing accuracy and coverage for various Key Data Elements (KDEs)• Designed and implemented data pipelines to meet business needs, focusing on DQI tasks• Supplied relevant data extracts to the business team for validation against DQI scores in dashboards• Collaborated with the Alation team for data lineage tracking and improvements𝐂𝐥𝐨𝐮𝐝 𝐃𝐚𝐭𝐚 𝐄𝐧𝐠𝐢𝐧𝐞𝐞𝐫𝐢𝐧𝐠 𝐚𝐧𝐝 𝐎𝐩𝐭𝐢𝐦𝐢𝐳𝐚𝐭𝐢𝐨𝐧𝐂𝐥𝐢𝐞𝐧𝐭: Frontdoor, a client of vCreatek consulting services pvt ltd. | 𝐉𝐚𝐧 𝟐𝟎𝟐𝟏 𝐭𝐨 𝐌𝐚𝐫 𝟐𝟎𝟐𝟒𝐊𝐞𝐲 𝐓𝐞𝐜𝐡𝐧𝐨𝐥𝐨𝐠𝐢𝐞𝐬: Oracle, Snowflake, Python, GCF, DBT, Apache Airflow, AWS Managed Service, Docker • Optimized job execution by migrating GCP functions to AWS Fargate, reducing delays and costs• Architected a system to manage JSON data explosion, transforming 3-4K records into millions and optimizing cost• Facilitated marketing operations by uploading offline conversions to Google, Bing, and Facebook• Standardized addresses from vendors & developed outbound pipelines for Snowflake to AWS S3 data extraction• Implemented pipeline to ingest Google Analytics data into Snowflake, using DBT to materialize production tables Show less

𝐏𝐫𝐨𝐣𝐞𝐜𝐭 𝐂𝐨𝐦𝐩𝐫𝐞𝐡𝐞𝐧𝐬𝐢𝐯𝐞 𝐃𝐚𝐭𝐚 𝐌𝐢𝐠𝐫𝐚𝐭𝐢𝐨𝐧 (BITS 2.0 Data Migration)𝐂𝐥𝐢𝐞𝐧𝐭: AmeriHealth | Jun 2020 to Jan 2021𝐊𝐞𝐲 𝐓𝐞𝐜𝐡𝐧𝐨𝐥𝐨𝐠𝐢𝐞𝐬: Azure Data Factory, Azure Databricks, Azure SQL DB, Azure Synapse, Apache Spark• Developed metadata-driven parameterized pipelines on ADF for Azure data ingestion• Generated metadata in Azure SQL DB for multiple table ingestions into ADLS Raw layer• Transformed data with PySpark in Databricks for… Show more 𝐏𝐫𝐨𝐣𝐞𝐜𝐭 𝐂𝐨𝐦𝐩𝐫𝐞𝐡𝐞𝐧𝐬𝐢𝐯𝐞 𝐃𝐚𝐭𝐚 𝐌𝐢𝐠𝐫𝐚𝐭𝐢𝐨𝐧 (BITS 2.0 Data Migration)𝐂𝐥𝐢𝐞𝐧𝐭: AmeriHealth | Jun 2020 to Jan 2021𝐊𝐞𝐲 𝐓𝐞𝐜𝐡𝐧𝐨𝐥𝐨𝐠𝐢𝐞𝐬: Azure Data Factory, Azure Databricks, Azure SQL DB, Azure Synapse, Apache Spark• Developed metadata-driven parameterized pipelines on ADF for Azure data ingestion• Generated metadata in Azure SQL DB for multiple table ingestions into ADLS Raw layer• Transformed data with PySpark in Databricks for staging, then ingested into Azure Synapse Gold layer• Converted SQL Server stored procedures to Spark SQL for dashboard transformations in Synapse• Created Tableau dashboards leveraging data from the Azure Synapse consumption layer Show less

𝐏𝐫𝐨𝐣𝐞𝐜𝐭 𝐃𝐚𝐭𝐚 𝐒𝐜𝐢𝐞𝐧𝐜𝐞 𝐌𝐨𝐝𝐞𝐥 𝐃𝐞𝐩𝐥𝐨𝐲𝐦𝐞𝐧𝐭 (Data Model Migration)𝐂𝐥𝐢𝐞𝐧𝐭: Chamberlain | 𝐉𝐚𝐧 𝟐𝟎𝟐𝟎 𝐭𝐨 𝐉𝐮𝐧 𝟐𝟎𝟐𝟎𝐊𝐞𝐲 𝐓𝐞𝐜𝐡𝐧𝐨𝐥𝐨𝐠𝐢𝐞𝐬: Azure Databricks, Spark, Azure DevOps, Azure SQL Server• Integrated updated data science models into Azure DevOps repository, developing Docker files for OrientDB installation and testing, ensuring seamless deployment and functionality• Constructed a pipeline in Azure DevOps to generate… Show more 𝐏𝐫𝐨𝐣𝐞𝐜𝐭 𝐃𝐚𝐭𝐚 𝐒𝐜𝐢𝐞𝐧𝐜𝐞 𝐌𝐨𝐝𝐞𝐥 𝐃𝐞𝐩𝐥𝐨𝐲𝐦𝐞𝐧𝐭 (Data Model Migration)𝐂𝐥𝐢𝐞𝐧𝐭: Chamberlain | 𝐉𝐚𝐧 𝟐𝟎𝟐𝟎 𝐭𝐨 𝐉𝐮𝐧 𝟐𝟎𝟐𝟎𝐊𝐞𝐲 𝐓𝐞𝐜𝐡𝐧𝐨𝐥𝐨𝐠𝐢𝐞𝐬: Azure Databricks, Spark, Azure DevOps, Azure SQL Server• Integrated updated data science models into Azure DevOps repository, developing Docker files for OrientDB installation and testing, ensuring seamless deployment and functionality• Constructed a pipeline in Azure DevOps to generate Python wheel packages for models, installing them on Databricks clusters using Databricks CLI within DevOps pipelines to optimize operational efficiency• Organized Azure Data Lake Storage folder structures for data science model input files and forecast outputs, configuring secure access via Azure Active Directory Service Principal• Deployed Jupyter notebooks for forecasting on Databricks, storing and extracting forecasting outputs from ADLS, and loading the data into Databricks for enhanced data integration• Ingested historic forecast data from DataMart into Databricks, executing Slowly Changing Dimensions (SCD-Type2) in PySpark to maintain data integrity with specific flags for new inserts, updates, and soft deletes• Updated historic data in DataMart with newly transformed data using SQL in Python scripts, ensuring data accuracy and relevance Show less

𝐏𝐫𝐨𝐣𝐞𝐜𝐭 𝐂𝐥𝐨𝐮𝐝 𝐖𝐚𝐫𝐞𝐡𝐨𝐮𝐬𝐞 𝐈𝐦𝐩𝐥𝐞𝐦𝐞𝐧𝐭𝐚𝐭𝐢𝐨𝐧 (IMS)𝐂𝐥𝐢𝐞𝐧𝐭: Ingredion | 𝐌𝐚𝐫 𝟐𝟎𝟏𝟗 𝐭𝐨 𝐃𝐞𝐜 𝟐𝟎𝟏𝟗𝐊𝐞𝐲 𝐓𝐞𝐜𝐡𝐧𝐨𝐥𝐨𝐠𝐢𝐞𝐬: Snowflake, Python, Airflow• Designed scalable ETL processes in Snowflake to support business data demands• Automated Mainframe data extraction from DB2 to CSV using Python, then loaded into Snowflake• Created Snowflake stored procedures for data ingestion strategies, including SCD Type 2… Show more 𝐏𝐫𝐨𝐣𝐞𝐜𝐭 𝐂𝐥𝐨𝐮𝐝 𝐖𝐚𝐫𝐞𝐡𝐨𝐮𝐬𝐞 𝐈𝐦𝐩𝐥𝐞𝐦𝐞𝐧𝐭𝐚𝐭𝐢𝐨𝐧 (IMS)𝐂𝐥𝐢𝐞𝐧𝐭: Ingredion | 𝐌𝐚𝐫 𝟐𝟎𝟏𝟗 𝐭𝐨 𝐃𝐞𝐜 𝟐𝟎𝟏𝟗𝐊𝐞𝐲 𝐓𝐞𝐜𝐡𝐧𝐨𝐥𝐨𝐠𝐢𝐞𝐬: Snowflake, Python, Airflow• Designed scalable ETL processes in Snowflake to support business data demands• Automated Mainframe data extraction from DB2 to CSV using Python, then loaded into Snowflake• Created Snowflake stored procedures for data ingestion strategies, including SCD Type 2 implementation• Collaborated with Business Analysts to assist in data profiling activities Show less

Mumbai, Maharashtra, India

Mumbai Area, India