Over nine years of experience as Oracle BIEE/Siebel /BI Publisher/XML Publisher/Oracle EBS / Peoples...
Over nine years of experience as Oracle BIEE/Siebel /BI Publisher/XML Publisher/Oracle EBS / Peoplesoft and experience in gathering Business Requirements, performing GAP Analysis, Design / Data Modeling, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence using agile development techniques. Experience in working with OBIEE/Siebel Analytics 11g/10.1.3.x. /Siebel Configuration/ EAI/EIM Applications includes Extensively worked on OBIEE Publisher , scheduler , Hyperlinks, reports generation.BI publisher exp on XML Publishing , eText templates ,configuration RPD Development(physical,Business,presentation Layers),Dashboard Development and security ,Dimensional hierarchies, Expression builder, Timeseries wizard, Calculation wizard ,Creating initialization blocks and repository ,session variables . Aggregate Navigation-Creating aggregate tables using materialized views ,Multiuser development, Merging and Importing Objects from different repositories,Experience in migrating metadata and web catalogue between different environments Clustering,Load Balancing , Configuring delivers, bots ,Cache management, performance tuning at report level, database level .Installation,development,administration,production Support of OBIEE Experience in installing and configuring Oracle Bi Applications(informatica,DAC,OBIEE) and integrated with Oracle EBS, Oracle e-Business suite (Oracle Process Manufacturing, Oracle Inventory, Oracle Purchasing and Oracle Sales). Expertise in configuration of Oracle BI Analytics Repository, DAC (Execution Plans, Subject Areas, Containers, Design, Setup, Execute etc.,), Create/Manage Intelligent dashboards Expertise in working with Process Manufacturing, Financial, Sales, Marketing, pharma, HRMS,Time and Labor(OTL),Order management Analytics. Experience in Data Analysis & Warehousing using Informatica. Strong understanding of Dimensional Modeling, Hyperion, Smart view Star and Snowflake Schemas and Dashboard Reports. Extensive experience in 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). Knowledge on BIRT Framework and Web Java development. Worked Extensively on OBIEE Administration Tool, OBIEE Answers and Intelligence Dashboards and customized reports (Aggregations, Drilldown to meet client requirements. Expertise in Performance Tuning of Data Warehouses by implementing the materialized views, Bitmapped Indexes and Partitions. Production Support –involved in support, Administration, Migration, Maintenance ,performance Tuning, Deliverables Strong programming experience in creating Procedures, Packages, Functions, Triggers and other database objects using SQL and PL/SQL. Excellent people management, team building, presentation, facilitation techniques, motivation & leadership skills. Ability to learn and adapt to new technologies, Coordinated with offshore development team members to resolve issues ,Provided regular status reports and interacted directly with client leads. Technical skills: BI : OBIEE 220.127.116.11/1.6/1.5/10.1.3.4/Siebel Analytics8.0/7.8/7.7//crystal reports ETL : Informatica Power Center/Power Mart 8.6/8.1.1/7.1.4/6.2 RDBS : Oracle 10g/9i, EBS,OPM,SQl Server Modeling : Erwin, Dimensional Data Modeling-R Modeling Scheduling : DAC 7.8.5v, CVS, VMS Languages : .Net,SQL, PL/SQL, ESSBASE, Hyperion, Web Servers : Apache, IBM Web Sphere, Web Logic, and IIS Integration Services : Oracle SOA suite Operating Systems : Win XP, Red Hat Linux, UNIX
* Click the button to send an offerSend offer