Ayan Kumar Dutta Email & Phone Number

India

Projects:• Digital NorthStar – Procurement and Sustainability • Responsibilities:• Data analysis, Data modelling, Data Engineering, Data Warehousing – Ingesting data from peripheral systems like SAP, Mendix etc to AWS Redshift using S3, Lambda (Python), Glue (PySpark) for transformation• Maintained data pipeline and automated ELTL process across high volume of OLAP data helped client to maintain MDM/ single source of truth. • Data Warehousing using AWS Redshift helped in… Show more Projects:• Digital NorthStar – Procurement and Sustainability • Responsibilities:• Data analysis, Data modelling, Data Engineering, Data Warehousing – Ingesting data from peripheral systems like SAP, Mendix etc to AWS Redshift using S3, Lambda (Python), Glue (PySpark) for transformation• Maintained data pipeline and automated ELTL process across high volume of OLAP data helped client to maintain MDM/ single source of truth. • Data Warehousing using AWS Redshift helped in visualization and analytics.• Informatica Cloud adaptation helping client for easy extract and transformation using minimum coding approach. Show less

Edinburgh, Scotland, United Kingdom

Projects:• Digital Experience – Inception, Adaptation, Transformation• Asset Management automation with leading Global financial management organization• Asset Money Laundering (AML) and Financial Crime (FCDS) check with multinational consumer credit reporting company• Regulatory Projects – Ban on fees, Orphan Process Automation, Tax Year End, Her Majesty Revenue & Customs (HMRC) tax reporting Responsibilities:• Data analysis, Data architecting and… Show more Projects:• Digital Experience – Inception, Adaptation, Transformation• Asset Management automation with leading Global financial management organization• Asset Money Laundering (AML) and Financial Crime (FCDS) check with multinational consumer credit reporting company• Regulatory Projects – Ban on fees, Orphan Process Automation, Tax Year End, Her Majesty Revenue & Customs (HMRC) tax reporting Responsibilities:• Data analysis, Data architecting and reporting• On-premises to Cloud native system and data migration using AWS based ETL offerings• Solutioning for Data cleansing, loading and integration with existing system• Secure site-to-site VPN networking between local to third-party data centre• Secure connection establishment and data-flow design between local and third-party data centre• Design walkthrough, approval and negotiation with Technical Design Authority, Info Security, Infrastructure Community Panel Show less

Kolkata, West Bengal, India

Projects: • General Data Protection Regulation (GDPR)• Incident Management and Small Change• Migration from Legacy technologyResponsibilities:• Successful migration of Clients Legacy Mainframe System (source data analysis, data mapping, data transformation, data migration)• Implementation of GDPR regulations (Data Analysis, Data Desensitization, Data deletion)Edinburgh, UK (Feb 2016 – Jan 2017 & Jan 2020 to Oct 2021 )Kolkata, India (June 2014 to Jan… Show more Projects: • General Data Protection Regulation (GDPR)• Incident Management and Small Change• Migration from Legacy technologyResponsibilities:• Successful migration of Clients Legacy Mainframe System (source data analysis, data mapping, data transformation, data migration)• Implementation of GDPR regulations (Data Analysis, Data Desensitization, Data deletion)Edinburgh, UK (Feb 2016 – Jan 2017 & Jan 2020 to Oct 2021 )Kolkata, India (June 2014 to Jan 2018) Show less

Kolkata, West Bengal, India

Projects: • Multi-Channel Upgrade Program• Investment Pathway/ GlidePathResponsibilities:• Peoples’ management and Resource planning• Quality SPOC• System design and end to end delivery support• Collaboration with various stakeholder

Kolkata, West Bengal, India

Projects: • Product Projection rate changes for Annual Statement• Tax residency Status recording and reporting• Tax rate change for UK and non-UK clientResponsibilities:• Understanding business requirements, along with the high-level design, to work out the low-level design• Coding and Unit testing, peer review for code and other deliverables• Extensive documentation along with user manuals (if applicable)

Pgemba, Business Analytics, First Class

Bachelor Of Technology - Btech, Electonincs And Communication Engineering, 8.45

Under Graduate, Science, Secondary - 90.5% Higher Secondary - 81%