#1: CC Data MART
Client : United Community Bank, Georgia, USA.
Role : ETL Developer.
Environment: Datastage, oracle, windows.
CC Data Mart (call center data mart) is part of (EDW and is having 7 sub-marts. This will enable strategic reporting across multiple operational systems and departments of company. The objectives are maintaining all call center oriented data and tracking of dialer activities to specific loan, IVR flow and drop off points, performance of call center team. It enables the customer to know the loan related information
Roles & Responsibilities:
&iuml;ƒ˜ Understanding existing business model and customer requirements.
&iuml;ƒ˜ Oracle tables and flat files as a sources and targets sources and targets.
&iuml;ƒ˜ Used Data stage to create respective cleance,transformation ,segregation Designer to create the mappings.
&iuml;ƒ˜ Joiner, filters, modify,merge and Aggregation stages are used in the jobs.
&iuml;ƒ˜ Created unit test cases for the jobs and trackes them
&iuml;ƒ˜ Used shared container and routines
&iuml;ƒ˜ Tuned the jobs as per the performance