Prerna Sharma

Project 1: Banca Nazionale del Lavoro S.p.A.
ETL Developer and Data Modeler
Banca Nazionale del Lavoro S.p.A. is an Italian bank headquartered in Rome.

ETL Tool: Informatica

Data Modelling Tool: Erwin

Database: Teradata

 Get requirements from the client. Go thoroughly to the requirements sheet known as DFA.
 After proper understanding of the requirements, firstly there is modelling of the data through Erwin tool.
 After data modelling, Designing of jobs using Informatica tool.

 Once Jobs Designing is done, There will be Unit testing of all the jobs.

Project 2: Nordea
ETL Developer
Nordea, is a Nordic financial services group operating in northern Europe

ETL Tool: Informatica
Database: Teradata.

 Worked as an ETL resource and maintaining the quality of the ETL process by active monitoring.
 Executed loading operation by triggering datastage jobs through Unix scripts.
 Performed root cause analysis on all processes and resolve production issues and validate data and conducted routine tests.
 Involved in loading the data from Mainframe to Core using tools like Unix and Winscp.
 Worked with database administrators to ensure that the data warehouse is tuned for optimal performance.

Project 3: Sales Monitoring System
ETL Tool:
Database: Teradata.

 The aim of this project is to develop the fertilizers sales performance reports for “GREEN FERT LTD”. In this project, the analysis is performed based on the 5 years of sales data. The analysis has been done by taking into
 Account the various entities like Retailers, Products, and Salesperson. During the analysis, first design the
 Data warehouse model by using the various aspects of dimensional modelling after ETL tool.