Sanket Panse
Data and AI Architect
Mumbai
Summary
Data and AI Specialist at with a proven track record in the banking sector. Expert in designing and implementing data architecture projects, with a focus on developing innovative AI use cases recently. Demonstrated success in AI-driven Know Your Customer (KYC) processes, customer sentiment analysis, and credit application processing. Skilled in creating compelling presentations for pre-sales teams and managing project delivery to ensure successful outcomes. Committed to leveraging data and AI to drive business growth and efficiency.
Overview
14
14
years of professional experience
4
4
years of post-secondary education
3
3
Languages
Work History
Data Architect
Collabera Technologies
09.2022 - Current
- Requirements Gathering and Design: Gathered, defined, and refined requirements, collaborating with system architects and design analysts.
- Database Architectural Strategies: Developed strategies for modeling, design, and implementation to address business needs.
- Data Modeling: Created a Data Model for Data Vault design after integrating UB P Data Systems with CITI data.
- Data Asset Management: Managed identification, protection, and utilization of data assets.
- AI Development: Developed an AI chatbot and text summarizer using Salesforce xgen-7b-8k LLM.
- AI Architecture:Created AI technical use cases for Presales Team
Data Architect
Piramal Capital and Housing Finance Ltd
08.2021 - 08.2022
- Designed End-to-End Data Flow: Orchestrated data flow for partnership data in PCHFL.
- Database Migration: Successfully moved the data platform from Postgres to Snowflake DB.
- Implemented Data Governance and ML: Developed data quality frameworks, data lineage, and data catalog. Contributed to data visualization in PowerBI and worked with AWS services for real-time data processing.
Senior Data Engineer DWH and Big Data
UBS (Swiss Bank) business Solutions India
03.2017 - 08.2021
- LEGR (Legal Entity Governance Reporting):Designed and developed a single warehouse for UBS data.
Enabled KPIs visualization for MicroStrategy team for different legal entities.
- FRS (Financial Reporting System - Global Wealth Management):Contributed to ETL development in Hive, Spark, and Scala.
Migrated on-premises HDFS and Spark operations to Azure.
Lead ETL Architect
Capgemini
05.2015 - 02.2017
- Grant Thornton Data Integration (ETL) and GTDW Design:Architected an ETL solution for Grant Thornton, proposing a flexible model to minimize impact on ETL code during source system changes.
Contributed to Informatica Cloud integration for Microsoft CRM to CMS system and maintained ETL processes for multiple applications.
Systems Engineer - Database Design
Tata Consultancy Services
01.2014 - 01.2015
- JPMorganChase Query Quality Control:
Tuned Teradata queries executed by users across different environments (ETL, Reporting).
Analyzed query performance, considered factors like indexes and table structure, and provided optimal solutions to improve efficiency. - Wyndham Hotel Group Data Warehouse Migration:
Migrated the data warehouse from Oracle/DB2 to Teradata.
Innovatively designed ETL solutions using external loaders (MLOAD, FLOAD, TPUMP) and TPT for Teradata loading.
Software Engineer
iGATE Global Solutions
01.2010 - 01.2014
- Actuarial AXIS System Valuation (ETL):Verified data for Actuarial risk prediction and management in the Pre-AXIS and Post-AXIS systems.
Provided report tracking and production support.
- Informatica SFDC Organization Merge:Enhanced existing SFDC functionality by merging two systems.
Improved report tracking and maintenance.
- ETL Consolidation (Production Support):Supported BI production environments across various Genworth applications.
Addressed user-reported bugs, data validation, and minor enhancement requests.
Education
Bachelors in engineering - Computer Engineering
Mumbai University
Mumbai 04.2006 - 04.2010
Skills
Amazon Web Services (AWS S3,Kinesis,Sagemaker,Redshift,ECS,CICD)undefined
Personal Information
Date of Birth: 12/07/88
Awards
- LEGR Appreciation, UBS, 04/2018, Received appreciation at UBS for contribution to LEGR Project as ETL Architect and Dev lead.
- CIO appreciation, Grant Thornton, 2016, Received Grant thornton CIO's (client) appreciation for successful Integration of Tax Symphony, automating solutions for Production Support issues which were critical and occurring frequently.
Timeline
Data Architect
Collabera Technologies
09.2022 - Current
Data Architect
Piramal Capital and Housing Finance Ltd
08.2021 - 08.2022
Senior Data Engineer DWH and Big Data
UBS (Swiss Bank) business Solutions India
03.2017 - 08.2021
Lead ETL Architect
Capgemini
05.2015 - 02.2017
Systems Engineer - Database Design
Tata Consultancy Services
01.2014 - 01.2015
Software Engineer
iGATE Global Solutions
01.2010 - 01.2014
Bachelors in engineering - Computer Engineering
Mumbai University
04.2006 - 04.2010
Similar Profiles
Musaddiqali BaigMusaddiqali Baig
Lead PMO at Collabera TechnologiesLead PMO at Collabera Technologies
JHANSI DODDAJHANSI DODDA
Azure Cloud Engineer at Collabera TechnologiesAzure Cloud Engineer at Collabera Technologies
Rajesh DevabhaktuniRajesh Devabhaktuni
Cloud Data Analytics Solution Architect at Collabera TechnologiesCloud Data Analytics Solution Architect at Collabera Technologies
Yogesh GangurdeYogesh Gangurde
Intune / SCCM Server Engineer at 63Moons technologies LtdIntune / SCCM Server Engineer at 63Moons technologies Ltd
Srishti ShettySrishti Shetty
Central Monitor I at Syneos Health India Private LimitedCentral Monitor I at Syneos Health India Private Limited