Involved in Reading data from files & Validating schema, data using pyspark data frames  Working for Clean Up Hadoop Databases by finding largest tables & unused tables from hive meta store for HDFS & AWS DB  Created Impala UDF’s for Generating Random Data with & without Predefined List of Data using core java  Based on File Triggers ActiveBatch will trigger Jobs to execute set of python jobs to clean & load data into HDFS  Involved in reading Kafka consumer messages & storing in HDFS table to store user activity in prod servers.  Working for migrating tables between databases by removing sensitive information like Prod to Dev  Working for migrating tables from encrypted zones to green zone by removing sensitive information  Working for Change requests (CR) for new/modify functionality

Ø As Part of Migration we need to Migrate Multiple End User Layers (EUL) to Single Repository (RPD).

Ø Created star/snow fall schemas in the repository between fact and dimensional tables.

Ø We have Created BI Publisher reports, Bi Answer reports, Dashboards & ibots in OBIEE Based on SQL Queries fetched from Discoverer Plus tool and from Discoverer Table’s

Ø As part of Reports security we have used Roles, Privileges, Groups in OBIEE

In This Project i have to Migrate Catalog Reports & User-Role Security Priviliges from RPD to Weblogic Console

Playing Customer needed information through IVR Systems as per Client Requirement (In Bound Calls, OutBound Calls, Self Service)