Santanu Mandal Email and Phone Number

Providing technical leadership to large scale digital banking project.• 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… Show more Providing technical leadership to large scale digital banking project.• 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 Show less

1.Interacts with Business Users, Subject Matter Experts and other stakeholders to determine expected business process flow and define System Requirements by adhering end to end project delivery with due timelines keeping quality in place.2.Actively involved in Data modelling of Application.3.Development and enhancement in PL/SQL packages, stored procedures, functions, Cursors using TOAD and SQL Developer.4.Designed & Developed Ab-Initio Graphs for Data Loading and Extract Process… Show more 1.Interacts with Business Users, Subject Matter Experts and other stakeholders to determine expected business process flow and define System Requirements by adhering end to end project delivery with due timelines keeping quality in place.2.Actively involved in Data modelling of Application.3.Development and enhancement in PL/SQL packages, stored procedures, functions, Cursors using TOAD and SQL Developer.4.Designed & Developed Ab-Initio Graphs for Data Loading and Extract Process. 5.Involved in Migration of Legacy application into new Oracle Exadata Environment with new data model. 6.Involved in continuous enhancement, optimization and fixing of problems. 7. Worked on Batch scripting, scheduling jobs and monitoring logs for various purge jobs. Show less

1.Development and enhancement in PL/SQL packages, stored procedures, functions, Cursors using TOAD and SQL Developer.2.Designed & Developed Ab-Initio Graphs for Data Loading and Extract Process. 3.Involved in continuous enhancement, optimization and fixing of problems. 4. Worked on Batch scripting, scheduling jobs and monitoring logs for various purge jobs.

 1. Requirement gathering and system design.  2. Designed stored procedure and in line query in Database. 3. Transfer data from Oracle datable to SQL Server database using SSIS Tool. 4. Effective issue resolution 5. Software Configuration Management practices using Harvest.6. Logical data model using Erwin Data modeling tool.7. Designing Stored Procedures, SSIS packages, SQL tuning, Unit testing, Integration Testing