· 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.

 

SKILL SET

 

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