Input your fixed/hourly price in this field.
Freelancers
freelancer
Amar K
0.0/5 (0 Feedback)
Member since March 24, 2021

1

  • $1.00 / hr
  • NH
  • Save

• 8+ years of experience in gathering Business Requirements, Analysis, Design, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse, Data Marts, Business Intelligence and Transactional applications • Extensive experience in Business Intelligence and Data warehousing: Kimball and Inmon Methodology using OBIEE/Siebel Analytics 7.x • Extensive experience in providing end-to-end business intelligence solution by dimensional modeling design, building business models, configuring metadata, Answers, Delivers / iBots, creating reports / Dashboards, cache monitor, and building OBIEE/Siebel Analytics Repository consisting of three layers (Physical Layer, Business Model & Presentation Layer) • Experience configuring Interactive Dashboards with drill-down capabilities using global and local Filters, Siebel Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports) • Expertise in providing end-to-end business intelligence solutions using Siebel Analytics, full SDLC, UML, RUP, and Web Technologies • Worked Extensively on OBIEE/Siebel Analytics RPD, Siebel Analytics Web/Presentation Services, Answers, & Interactive Dashboards and Security Implementation • Expertise in Data Analysis, Performing Gap Analysis, Identification of Dimensions (type-1, type-2 and type-3), Associative tables, Facts, and Aggregate tables, Measures and Hierarchies • Experience configuring Interactive Dashboards with drill-down and drill through capabilities using global and local Filters, Siebel Security Setup (groups, data access/query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports, Filters, Prompts) • Expertise in Debugging and Performance Tuning of Siebel Analytical Dashboards for minimum run time reports • Very strong in developing Informatica Mappings / Mapplets using various Transformations for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and creating Workflows with Worklets & various Tasks and scheduling them using both Workflow Manager and Unix Shell scripts (using pmcmd ) • Experienced in Data Analysis, Identification of dimensions, Facts, Measures and Hierarchies • Good at database Performance Tuning of Data Warehouses by implementing the materialized views, bitmapped indexes and partitions • Very strong in writing, testing and implementation of the triggers, stored procedures, functions, packages at database level using Oracle PL/SQL • Expertise in working with senior level managers and developers across multiple disciplines and possess excellent interpersonal and communication skills; Excellent problem solving skills with strong technical background • Expertise in OBIA Finance module with Sales for reporting support along with EBS tables used to generate reports in BI Publisher and Oracle Discoverer • Worked as Project Manager for the implementation of various projects from scratch • Experience with Oracle EBS (Enterprise Business Suite) for migration of BI instances. Technical Skills OBIEE: OBIEE(11.1.1.6.1, 10.1.3.4.1, 10.1.3.3.x), Siebel Analytics (7.x), Siebel Data warehouse Application Console (DAC), Siebel Analytic Server (SAS), Siebel Analytic web (SAW), Scheduler, BI Publisher, Informatica 9.1 Oracle 8i/9i/10g, 11gTOAD SQL*PLUS 8.x/9.x, PL/SQL 8.x/9.x C, C++, SQL Windows /NT/2000/XP, Linux, Unix

0

Ongoing projects

0

Completed projects

0

Cancelled projects

3

Ongoing services

0

Completed services

0

Cancelled services

$0.00

Total earnings

* Click the button to send an offer

Send offer