Harshad Patil profile photo 1 on Tal

Harshad Patil

Data Architect - Supply Chain & Procurement | Data Modelling | Databricks | Data Lakehouse | Building data products | dbt | Data Mesh

Pune District

18+ years of work experience

KONE
Apr 20242 yrs 5 mosPresent

Pune, Maharashtra, India

Tata Consultancy Services
Apr 20231 yr 1 moApr 2024

Pune, Maharashtra, India

Data Architect for UK's largest retail. • Data Vault Modeling for Cloud Data warehousing (Snowflake) • Data Reconciliation between legacy and strategic data sources • Hands-on SnowSQL
Tata Consultancy Services
Dec 20202 yrs 6 mosMay 2023

Bengaluru, Karnataka, India

• Developed data pipelines using Databricks • Developed PowerBI reports for Revenue optimization project for Pharma client. • Integrated Natural Language Processing capabilities using Spacy & NLTK libraries into Ml solutions • Developing Machine Learning based solutions using Django REST framework (DRF) & PostgreSQL DB • Integrating Cognitive speech APIs from leading cloud providers into AI solutions • Hands-on video analytics using APIs from Azure & GCP • Exploring MLOps platform – MLflow
Tata Consultancy Services
Sep 20163 y 11 moAug 2020

Bengaluru, Karnataka, India

• Transaction Monitoring Post Implementation Plan for a leading UK based bank • Applied statistical techniques to segment the country specific customers into different buckets using their historical transactions and fine-tune the threshold for each customer segment for each AML scenario by applying gradient descent machine learning algorithm • Developed customer segmentation models using topological data analysis methods using Ayasdi Machine Intelligence platform
EY LLP
Nov 20114 yrs 11 mosSep 2016

Mumbai Area, India

Achievements: • Delivered multiple Data Warehousing, Business Intelligence (BI) & Analytics implementations for BFSI clients in India. • Implemented multiple projects for BFSI customers including risk reporting, BI reports development, customer churn prediction for Life Insurance client, reports migration from QlikView to SAS platform. • Led the team of SAS & Teradata developers for Data Warehousing implementation for largest public sector bank in India.
SAS Research & Development Pune
Aug 20101 yr 4 mosNov 2011

Pune

Software Engineer for SAS Credit Scoring for Banking solution development team. Developed SAS jobs, programs and macros required for CSB 5.1 solution development. • Developed ETL jobs for populating Foundation and Credit Scoring Data Marts • Did performance testing • Developed Solution specific SAS Macros • Fixed solution defects
3i Infotech Ltd.
Jan 20082 yrs 5 mosMay 2010

Mumbai Area, India

SAS Developer - Data warehousing implementation for General Insurance company. Achievements: • Developed end-to-end product based data marts (requirements gathering to reports creation) using SAS platform tools. • Automated generation of month end text files in SAP system acceptable format to save 30 hours of manual efforts every month. • Developed ad-hoc reports for business users of Data Warehousing platform. • Gained extensive hands-on experience in SAS platform tools including SAS programming, ETL & Reporting, Jobs scheduling and monitoring, Performance tuning of ETL jobs.

Harshad’s AI Stack

gemini
gemini
grok
grok
openai
openai

Education

Indian Institute of Management Bangalore

Certificate Program in Business Analytics and Intelligence, Business Analytics

Indian Institute of Management Bangalore

20171 yr2018
University of Mumbai

Bachelor of Engineering - BE, Electronics

University of Mumbai

20014 yrs2005

Join Harshad and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

Harshad Patil on Tal

Headline

Data Architect - Supply Chain & Procurement | Data Modelling | Databricks | Data Lakehouse | Building data products | dbt | Data Mesh

About

Experienced data professional with proven knowledge in Data Management, Data Warehousing & Business Intelligence & Analytics. Recently gained expertise in Predictive Analytics & Machine Learning using Python. Technical skills: Programming languages: Python, Core Java, Base SAS, SQL, Scala Databases: Teradata, PostgreSQL, SQL Server, Hive Data Science Libraries: Numpy, Pandas, Seaborn, Scikit-learn, Tensorflow, Spacy Frameworks: Django web framework, Hadoop, Apache Spark BI Tools: SAS Intelligence Platform, Tableau, Power BI Web Development: HTML, CSS, Javascript Teradata FSLDM Versioning tools: SVN & GIT Domain Knowledge: Banking & Insurance, Retail

Location

Pune District

AI stack

gemini

grok

openai

Work experience

Data Architect at KONE, Apr 2024 - Present · 2 yrs 5 mos, Pune, Maharashtra, India

Data Architect - Analytics at Tata Consultancy Services, Apr 2023 - Apr 2024 · 1 yr 1 mo, Pune, Maharashtra, India, Data Architect for UK's largest retail. • Data Vault Modeling for Cloud Data warehousing (Snowflake) • Data Reconciliation between legacy and strategic data sources • Hands-on SnowSQL

Assistant Consultant - Data Science & Engineering at Tata Consultancy Services, Dec 2020 - May 2023 · 2 yrs 6 mos, Bengaluru, Karnataka, India, • Developed data pipelines using Databricks • Developed PowerBI reports for Revenue optimization project for Pharma client. • Integrated Natural Language Processing capabilities using Spacy & NLTK libraries into Ml solutions • Developing Machine Learning based solutions using Django REST framework (DRF) & PostgreSQL DB • Integrating Cognitive speech APIs from leading cloud providers into AI solutions • Hands-on video analytics using APIs from Azure & GCP • Exploring MLOps platform – MLflow

Senior Data Analyst at Tata Consultancy Services, Sep 2016 - Aug 2020 · 3 y 11 mo, Bengaluru, Karnataka, India, • Transaction Monitoring Post Implementation Plan for a leading UK based bank • Applied statistical techniques to segment the country specific customers into different buckets using their historical transactions and fine-tune the threshold for each customer segment for each AML scenario by applying gradient descent machine learning algorithm • Developed customer segmentation models using topological data analysis methods using Ayasdi Machine Intelligence platform

Senior Consultant - IT Advisory at EY LLP, Nov 2011 - Sep 2016 · 4 yrs 11 mos, Mumbai Area, India, Achievements: • Delivered multiple Data Warehousing, Business Intelligence (BI) & Analytics implementations for BFSI clients in India. • Implemented multiple projects for BFSI customers including risk reporting, BI reports development, customer churn prediction for Life Insurance client, reports migration from QlikView to SAS platform. • Led the team of SAS & Teradata developers for Data Warehousing implementation for largest public sector bank in India.

Software Engineer at SAS Research & Development Pune, Aug 2010 - Nov 2011 · 1 yr 4 mos, Pune, Software Engineer for SAS Credit Scoring for Banking solution development team. Developed SAS jobs, programs and macros required for CSB 5.1 solution development. • Developed ETL jobs for populating Foundation and Credit Scoring Data Marts • Did performance testing • Developed Solution specific SAS Macros • Fixed solution defects

Software Engineer at 3i Infotech Ltd., Jan 2008 - May 2010 · 2 yrs 5 mos, Mumbai Area, India, SAS Developer - Data warehousing implementation for General Insurance company. Achievements: • Developed end-to-end product based data marts (requirements gathering to reports creation) using SAS platform tools. • Automated generation of month end text files in SAP system acceptable format to save 30 hours of manual efforts every month. • Developed ad-hoc reports for business users of Data Warehousing platform. • Gained extensive hands-on experience in SAS platform tools including SAS programming, ETL & Reporting, Jobs scheduling and monitoring, Performance tuning of ETL jobs.

Education

Certificate Program in Business Analytics and Intelligence, Business Analytics, Indian Institute of Management Bangalore

Bachelor of Engineering - BE, Electronics, University of Mumbai