Vigneswara reddy T.

Vigneswara reddy T.

Data Analyst | Python developer| PL/SQL Developer ||Data Warehouse( OLAP, BI ) | OBIEE Developer

Bangalore , India

Experience: 6 Years

Vigneswara reddy

Bangalore , India

Data Analyst | Python developer| PL/SQL Developer ||Data Warehouse( OLAP, BI ) | OBIEE Developer

54049.7 USD / Year

  • Notice Period: 60 Days

6 Years

Now you can Instantly Chat with Vigneswara reddy!

About Me

Oracle PL/SQL, OBIEE(BI Publisher, Bi Answers, Dashboards), Oracle Wallet, Hadoop(Hive, Impala, OOZIE, SQOOP), Machine Learning(Regression, Class...

Ø  Involved in Design(Security, Compatibility), Development(RPD, BI Answer, BI Publisher, iBots) & Testing as part of Oracle Discoverer 10G/11G to OBIEE 12C Migration

Ø  Experience in writing Oracle PL/SQL packages, Procedures, Functions, Database Triggers, Cursors, Exceptions, data modelling and advanced concepts like arrays, bulk collect and forall, Performance Tuning and analytical functions, Oracle Wallet Configuration

Ø  Worked on Big Data Technologies like Hive, Impala, Sqoop, Oozie Languages

Show More

Portfolio Projects

Company

Implementation of IVR Systems

Role

Software Architect

Contribute

 We have developed IVR Systems for maintaining out bound calls, Inbound Calls & Self Service  For activating/modifying any products we have to send requests to CRM/CBS through GFEP from IVR  Monit

Description

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

Show More Show Less

Skills

CRM PL/SQL

Tools

IDLE

Oracle Discoverer 11G to Oracle BI 12C

https://github.com/VigneswaraReddy/ProfessionalProjectExperience/tree/master/Discoverer11G_to_OBIEE12C_Migration

As part of this requirement we need to migrate all Discoverer reports to OBIEE r

Company

Oracle Discoverer 11G to Oracle BI 12C

Role

Software Architect

Contribute

 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

Description

Ø  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

Show More Show Less

Skills

PL/SQL

Tools

Github

Company

OBIEE 11G to OBIEE 12C

Role

Software Architect

Contribute

Upgrade existing OBIEE 11g to OBIEE 12c. You have to be on OBIEE 11.1.1.7 or later to be able to successfully do the migration

Description

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

Show More Show Less

Skills

PL/SQL

Tools

Github

BOFA

Company

BOFA

Role

Backend Developer

Description

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

Show More Show Less