Freelancers
freelancer
Email Verified John M
0.0/5 (0 Feedback)
Member since May 10, 2021

• Over 7+ years of experience in designing, developing and implementation of OBIEE 10g,11g & 12c, ...

• Over 7+ years of experience in designing, developing and implementation of OBIEE 10g,11g & 12c, 6+ years’ experience in 11g and 1+ year’s in 12c. • Experienced in OBIEE 12c/11.1.1.7,Oracle BI Applications 7.9.6.x, Siebel Analytics 7.x which include building and configuring repository, creating and managing oracle/Siebel Intelligent Dashboards, oracle/Siebel Answers, oracle/Siebel Delivers and oracle/Siebel Alerts (ETL ODI 11g/Informatica 9.5.1, Reporting-Siebel Analytics, Scheduling-DAC). Experienced in Data Warehousing Methodologies. • Experienced in OBIEE solution architecting (OBIEE 11g & OBIEE10g) and have a strong understanding on OBIEE 11g capabilities with administering Web logic 10.3.6 as an Application server. Knowledge on Tableau 8.1 • Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer. Experienced in working with Oracle Fusion & Web Logic. • Experienced in designing and developing Data Modeling and Analysis using Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables and Physical and Logical data modeling in the OBI Administration tool. • Highly skilled at configuring OBIEE Metadata Objects including repository, variables, interactive dashboards with Map viewer/Big Maps/Google Maps, reports and three tier OBIEE architecture. • Expertise in Data Modeling design, analyze and implement – conceptual, logical and physical data model, Data conversion, Data integration and Data Mining specialization in the area of Data Warehouse and Business Intelligence. • Expertise in ETL using Informatica 9.5.1 to facilitate Extraction Transformation and data Load from OLTP systems to OLAP systems. • Expertise in Oracle DAC 11.1.1 installation and configuration, creating Tasks, Task groups, Containers, Incremental/Full loads, Subject areas, Execution plan, synchronization, and execution (data warehouse load). • Experienced in Integrating OBIEE with Hyperion Essbase 9.x and in developing RPD and reports against multidimensional databases. • Experienced in Installation, Configuration, Upgrade, Migration and Administration of OBIEE 11g, Oracle BI Apps, ODI/Informatica Power Center 9.5.1. • Experience in Oracle EBS Release 12/11.5.10.2 and OBIEE integration and LDAP Single Sign- on (SSO/SSL) configuration. • Expert in configuring, designing, development, implementation and using Oracle pre-build RPD’s (Financial, HCM/Payroll, Sales, Supply Chain, Marketing Analytics, etc.) and ETL Mappings according to business requirements. • Expert in building repositories using star schema, developing Subject Areas, and applying security (group, access / query privileges) at object and data level in Administration Tool. Hands on experience in customizing reports, filters and charts in Oracle BI Answers, Interactive Dashboards, BI Publisher (Excel) and Delivers. Expert knowledge of report development execution in a complex environment. • Experienced in writing, testing and implementation of Stored Procedures and Packages at database level using PL/SQL, Database designs Methodologies. • Strong Knowledge and understanding of Relational Databases (Oracle SQL, PL/SQL and SQL Server), data warehousing concepts and querying tools. • Experienced in Simplifying Migration Process – Changing environment specific variables in RPD development, administration, analysis report. • Experienced in involving daily production support activities for DAC loads/tasks and administering integration related activities with external applications. • Created and scheduled Alerts using delivers to send alerts, run reports, and deliver reports to the users. Experienced in supporting performance tuning and process tuning at all levels. • Proficient in using the time-series functions to support historical time comparison analysis and creating requests, adding filters, creating prompts, and creating pivot tables. • Experienced in configuring Usage Tracking and Multiuser Development Environment (MUDE). • Experienced in creating Dimensional hierarchies and designing customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters, and variables. • Experienced in translating business requirements into a business dimensional model, key subject areas, dimensions, hierarchies, attributes and measures. • Expert ability to trouble shoots and prioritizes issues. • Excellent interpersonal and communication skills for efficient client interaction. TECHNICAL SKILLS OBIEE Infrastructure OBIEE 11.1.1.7, OBIEE 11.1.1.6, OBIEE 10g OBIEE Applications OBIA7.9.6.3, 7.9.6.1(Financial analytics, Supply Chain, Manufacturing, Sales) ETL Tools ODI 11g(11.1.1), Informatica Power center 9.5.1, DAC 11.1.1 Languages and Web Technologies Oracle SQL, PL/SQL, Java, C, C++ XML, HTML/XHTML, TOAD 12 .5.0.99 ERP and Applicati Servers Oornascle Applications 11i, R12, PeopleSoft 8.9, Oracle Web Logic Server 10.3.6 RDBMS DB2 UDB (8.x and 7.x), Oracle11g/10g, MS-Access, SQL-Server 2008, Hyperion System 9 Essbase Operating Systems Microsoft Windows 8.x, Windows 7, Solaris 5.8, UNIX, Oracle Enterprise Linux Mac OS X Methodologies Agile Methodology ,Software Development Life Cycle (SDLC) – Waterfall Mode

0

Ongoing projects

0

Completed projects

0

Cancelled projects

0

Ongoing services

0

Completed services

0

Cancelled services

$0.00

Total earnings

* Click the button to send an offer

Send offer