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

Services

Client Feedback

Company
 Herbert G

Sales & Marketing Systems Setup

  • Project LevelBasic Level
  • United States
  • July 28, 2021
    • How was my proffesional behaviour?
    • How was my quality of work?
    • Was I focused to deadline?
    • Was it worth it having my services?

Completed

Company
  • Project LevelBasic Level
  • United States
  • July 16, 2021
    • How was my proffesional behaviour?
    • How was my quality of work?
    • Was I focused to deadline?
    • Was it worth it having my services?

testing

Company
 Herbert G

testForMukesh

  • Project LevelBasic Level
  • July 13, 2021
    • How was my proffesional behaviour?
    • How was my quality of work?
    • Was I focused to deadline?
    • Was it worth it having my services?

Very Good