SHUBHAM CHAKRABORTY

DATA MODERNIZATION -In this project we are moving data from Legacy System to Modern Database (Snowflake)

RESPONSIBILITIES:-

• Interpreted data models for conversion into ETL diagrams and code for IICS.
• Developed various kinds of mappings on basis of Intelligent structure model and Hierarchical Schema.
• Developed various types of Decision based Taskflows which consisted various kind of Mapping tasks for better tracking .
• Migrated some components of informatica Power Center to IICS as per requirement.
• Used Push Down Optimization and Partition as part of Performance Tuning Technique in IICS Mappings which resulted in decrease in runtime by 10%-15%.
• Created Tables, custom querys and views in Snowflake for data migration as per legacy systems like Teradata, SQL Server and Oracle.
• Fixed various Stored Procedures(SP) related to Data
  migrations and BI views.

Implementation of database model in Azure Storage for SAP modules (PROCUREMENT, SALES & INVENTORY).

RESPONSIBILITIES:-

• Created and Managed database objects like Tables, Stored procedure and Views.
• Worked on fixing of Stored Procedures(SP) for Data
  migrations and auditing.
• Fixing and Monitoring Azure Data Factory(ADF) pipelines and fixing issues related to data transformation process.
• Implemented Partitioning and Indexing resulted in decrease in run time by more then 15%.
• Worked on Custom Power BI Report development.