OnBenchMark Logo

Prashanth (RID : 6v6vlrfyrj6x)

designation   Sr Technical Lead

location   Location : Hyderabad, India

experience   Experience : 11 Year

rate   Rate: $14 / Hourly

Availability   Availability : Immediate

Work From   Work From : Offsite

designation   Category : Information Technology & Services

Shortlisted : 0
Total Views : 55
Key Skills
Python Power BI Tableau AWS Cloud Computing Data Warehousing Oracle Javascript

· Over 11 years of expertise in analyzing the requirements, design, development, testing in Database development and Data Warehousing and Business Intelligence, Cloud Computing.

· Excellent experience in writing Pyspark and Python code in AWS Glue and AWS Lambda.

· Created crawlers in AWS Glue to view data in AWS Athena.

· Loaded the data into Redshift and also Snowflake.

· Excellent experience in Dashboards, Answers, RPD, ETL (Informatica, ODI, PL\SQL), DAC and DW schema customization.

· Strong knowledge on BIAPPS 11g.

· Extensive experience on BICS, OBIEE/Siebel Analytics web features (Answers, Dashboards, and Delivers, I-Bots, Scheduler, write back etc.).

· Extensive experience on OBIEE/Siebel Analytics Repository (Physical Layer, Business Model & Mapping Layer and Presentation layer).

· Extensive experience on OBIEE/Siebel Analytics administration features (i.e., Clustering, Security, cache, usage tracking, dimensional hierarchy, aggregate navigation, MUD, Variables/Initialization Blocks configuration).

· Extensive experience on BIAPPS 11g, featuring ODI as ETL.

· Optimized the Solution using various performance tuning methods (SQL tuning, ETL tuning (i.e. optimal configuration of transformations and memory parameters), Database tuning using Hints, Indexes, partitioning, Materialized Views, External Table, Procedures, functions etc.).

· Team player and self-starter with good communication skills and ability to work independently and as part of a team.

· Strong knowledge in DENODO for building Data Virtualization SQL queries and also performance tuning and also on SNOWFLAKE

· Expertise in building Data Visualization reports using TABLEAU, POWER BI and LOOKER

· Used ODI 12c for Data Migration for migrating the data from Legacy systems to CCnB application.




OBIEE Infrastructure : Installation, Upgrade, Administration and configuration of v10.3 of OBIEE Components.

OBIEE Applications

: Installation, Upgrade, Administration and configuration of 7.9 OBIEE applications. (Supply Chain and Order Management,Financial), BIACM , FSM

Cloud Application AWS , Snowflake

Data Virtualisation Denodo

Data Visualisation Tableau , Power BI , Looker , Google Data Studio

Siebel Analytics : Installation, Upgrade, Configuration of Call Center, Sales, Service.v 7.8.

Languages : Python , Pyspark, R Programming, JS, SQL, PL/SQL, JavaScript, HTML,UNIX Shell Script.

ETL Tools : Informatica Power Center 7.0, 8.0 , ODI 11g , OWB

Databases : Oracle 9i, 10g,

Design Tools : UML

OS : MS-DOS,Windows NT/XP/Vista, UNIX, Solaris

Matching Resources
My Project History & Feedbacks
Copyright© Cosette Network Private Limited All Rights Reserved
Submit Query
WhatsApp Icon

stuff goes in here!