Santanu Mandal

About Santanu Mandal

Result oriented Enterprise Data Architect with over 19 years of experience in enterprise transformation and integration strategies and delivery. Significant hands-on exposure in data modeling, data architecture, business intelligence & data warehousing and analytic application development using progressively evolving technology of Big Data, cloud based shared service.Experience in Data Modeling and Database Architecture based on functional requirements and system design of the client using RDBMS concepts and constructs.Expertise in Performance Tuning and Query Optimization using various types of Hints, Partitioning, Bulking techniques and Indexes.Experience in Data Extraction, Transforming and loading (ETL) between Homogenous and Heterogeneous System using tools (Ab-Initio, SSIS).Experience in Data modeling (Dimensional & Relational) like Star-Schema Modeling, Snowflake Modeling, ER-Modeling and fact and dimension tables.Technical Expertise:RDBMS/DBMS: Oracle Exadata, Snowflakes, Oracle 18c, Microsoft SQL Server 2005, IBM DB2, Teradata, Snowflake ETL Technologies: Glue, Ab-Initio 3.1.7.3, SQL Server Integration Services, TalendCloud Technologies- Aws Lambda, Glue, Lake Formation, DataBrew, AWS Data Quality, ECS Fargate, AWS, EC2, VPC, EBS, EMR, RedShift, RDS, EBS, CloudWatch, Cloud Trail, CloudFormation, AWS Config, Autoscalling, CloudFront, IAM, S3Reporting Tool - Quicksight, Bigdata Technologies Hortonworks Hadoop HDP 2.3, Sqoop, Pig, Hive, Yarn, Ambari Languages: Pyspark, SQL, PL/SQL, T-SQL, Python, Hive, Big SQLDesign Technologies: ER-WinOperating Systems: Windows7, Vista, XP, 98, Windows 2003 ServerReporting Technologies: Crystal Reports 8/10, SSRSSoftware Engineering Tool: Visual source Safe, HarvestTool: PLSQL Developer,Toad,Microsoft Business Intelligence 2005, Snowsql, Hottonworks, snow pipe, snowflake Kafka connectorBigdataData Security Tool : HP Voltage secure data

Experience

1. Senior Manager

   Cognizant

   Nov 2021 — Present · Kolkata, IN

   Providing technical leadership to large scale digital banking project.• Agentic AI design, Retrieval Augmented Generation(RAG), AWS Bedrock Models (Claude, LLama)• AI ML orchestration using Databricks Workflow & Model serving • Design, develop, and implement end-to-end data solutions (Data Fetch, storage, ETL, Sever less procession, Data warehouse )• Research and analyze data sources and create technical solutions for various features within data platforms.• Creating AWS Lambda function/ Firehose to connect to different batch and near real time source, Store Data in S3 bucket.• Use ASW Glue and Crawler to move the data into large-scale redshift warehouse.• Participate requirement & design call with client SME, solution architect to finalize the targ

Education

• West Bengal University of Technology, Kolkata

  Bachelor of Technology (B.Tech.)

  2001 — 2005

• Asansol Engineering Collage

  Bachelor of Technology (B.Tech.)

  2001 — 2005

Skills

• Talend Etl
• Etl Tools
• Shell Scripting
• Ssas
• Solution Architecture
• Sql Server Integration Services (Ssis)
• Xml
• Unix Shell Scripting
• Ab Initio
• Sql Tuning
• Python
• Data Analysis
• Crystal Reports
• Software Development Life Cycle (Sdlc)
• Exadata
• Pl/Sql
• Connect Direct
• Sql Server
• Oracle
• Requirements Analysis
• Databases
• Data Warehousing
• Extract, Transform, Load (Etl)
• Data Migration
• Sql
• Microsoft Sql Server
• Db2
• Performance Tuning
• Big Data
• Agile Methodologies
• Data Modeling
• Oracle Database
• Ssis