Data modeling Projects list

 ========================================== 

1. Pharma client

========================================== 

• Modeling tool : Erwin 2021 R1 
  
  
•  Source & Target : 
• Source : Excel , flat files  
• Target : Snowflake
  
  
• Requirement : 

1. Create Data model for new entities and
2. create data mart for each of the departments

• Steps followed :  

1. Create STTM document 
2. Update confluence document about the new changes to be made like list of Tables and updated columns
3. Create Logical / Physical model 
4. Create PDF of the models and upload into sharepoint 

 ========================================== 

2. Food and restaurant business client

========================================== 

• Modeling tool : Erwin 2021 R1 
  
  
•  Source & Target : 
• Source : Excel , flat files  , CSV, TSV ,xml 
• Target : Snowflake
  
  
• Requirement : 
1. This restaurant has bought several new outlets in each country but the database of each new outlet is not similar the the database of JFC , 
2. so the client wants to take the database of NA as the standard and convert each country of South america, japan , malasia , singapore, indonesia to be similar to that of NA 
   
   
• Steps followed :  
1. Create STTM document for NA 
2. get sample data files from each country and do a due deligence investigation and study  the differences between DB of NA and each country and discuss with the POC of each country DB architect and propose solution 
3. Try to find out the new tables and columns in each country and identify similar tables in NA and propose solution 

========================================== 

3. Banking client

========================================== 

• Modeling tool : IBM IDA 
  
  
•  Source & Target : 
• Source : Excel , flat files  , CSV, TSV ,xml 
• Target : DB2
  
  
• Requirement : 
1. During the COVID season there were a number of Medical claims from the Bank customers
2. So we worked on a data model of the DB of all COVID pateients tables and thier total claims
3. 
   
• Steps followed :  
1. Create STTM document for  all the COVID claims related tables 
2. Design the grain of the reports 
3. identify the facts and dimensions from each of the tables
4. Design a data model