Hi,
I am having two years of ab-initio experience. Worked on the development projects and was has successfully implemented various projects.
ETL Tool : Ab-initio 3.0
Data Base : Oracle
Client : Allstate Insurance (U.S)
Company : Syntel Ltd.
Please find my projects detail:
1. Integrated Data warehouse Management – Quotes Module
This project maintains huge amount of data related to Quotations for client. It uses Star Dimensional modeling to maintain the data warehouse. This module has 7 profile dimensions, 2 Key-maps (FACT less fact) and Four FACTS.
2. Integrated Data warehouse Management – Policy Module
This project maintains huge amount of data related to policy for client. It uses Star Dimensional modeling to maintain the data warehouse. This module has 11 profile dimensions, 4 Key-maps (FACT less fact) and one FACT.
Other projects worked on is Drivewise1.5, Crosssell, QSL
Developed SQL and PL/SQL as per the requirement of ETL process.
Developed various graphs based on the requirements.
Worked on the process related to RI check and Cleansing.
Worked on following components: Rollup, Scan, Join, Sort, Sort within group, Merge, Gather, Replicate, Dedup sorted, Reformat, Filter by expression, Write compressed block lookup, File components, Table components, and Partitioning components.
Responsible for coordinating with Team, gathering the requirements, QC, UAT, Production support