Prathmesh Agrawal

• Designed and developed data pipelines for subscription-based chef prepared meal service to support key business KPIs such as customer engagement, retention, churn prevention, CRM, customer acquisition and product portfolio data analysis.
• Designed and implemented data integration workflows using Fivetran and Stitch to efficiently extract and load data from various sources such as Magento, Segment, Customer.io, Google Analytics, Facebook Ads, Stripe and custom MySQL-based applications.
• Used DBT to transform data in snowflake based enterprise data warehouse.
• Collaborated with cross-functional teams, including data analysts, data scientists, and business stakeholders to ensure data accuracy, completeness, and quality.
• Led development of CI/CD pipelines using GitLab to automate deployment of data pipelines.
• Mentored and coached junior engineers, providing guidance and support to help them develop their skills.

Project: Medtronic Digital information core

• Designed integration workflows for Tire 1 applications for medical devices compliance, sales and marketing domain in Informatica Intelligent cloud service and DBT to combine and Transform data from multiple, varied data sources such as DB2,salesforce, SAP center piece,SAP CMS,Azure, LDAP ,Informatica MDM and SQL servers, which pushes data to various reporting and downstream application based on Hybris,SAP BO,Power BI and tableau based reporting system

Technology: DBT,Snowflake, Oracle Exadata,IICS.

Project : Servicenow Incidents Tagging:

• Major part of development in Service Now ticket labeling and classification using NLP and elastic search which saved 200 hours of manual effort by effectively providing Knowledge article and self service document to users across various business unit.

Technology: Python, Elastic search

Project : Data Integration Hub

• Worked with Data Architects to enhance existing ETL integration designs which involved activities such as developing new Power Center workflows ,bug fixing,sql tuning,impact analysis ,building data connections which integrate data from various sources such as SAP,DB2,Salesforce,workday,Siebel IFO,service now,etc which feeds data to various down stream custom application and BI reports according to business requirements.

Technology : Informatica Powercenter, Oracle Exadata, IBM tivoli, SAP HANA

Project : Global Sales Reporting

• Worked with Business Analysts and top leadership to develop ETL designs from scratch to fetch data and convert to useful information required by Medtronic orders portal, Medtronic finance reports used by top leadership, Medtronic Sales reports used by Business Analysts to provide incentives

Technology : Informatica Powercenter, Oracle Exadata, IBM tivoli, SAP HANA