Shaddy Moumen
Having 8+ years of IT experience in the analysis, design, development of database, data warehousing and BI applications with good understanding of requirements and business data flow. Developed Physical Layer, Business Model & Mapping and Presentation Layer using Oracle BI Administration Tool in both OBIEE 11.1.1.5, 10.1.3.3 Environments. Developed many Reports / Dashboards using Answers with different Analytics Views (Drill-Down / Dynamic, criteria filters, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Oracle BI Presentation Services in both OBIEE 11.1.1.5, 10.1.3.3 Environments. Experience in OBIEE solution architecting (OBIEE 10g) in Ability to analyze source systems and business requirements, identify and document business rules, design data architecture. Strong experience as BI Developer in developing/modifying repositories and reports using OBIEE Good understanding of functional specs and converting them into technical specs in accordance with SDLC guidelines. Experience in designing Star/Snowflake Schema using OBIEE Analytics Administration tool. Experience in Metadata Modeling at all three layers (Physical, Business Model and Presentation) using the OBI Administration Tool. Expertise in Business Model development with Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series. Experience in building, configuring and managing repository, creating and managing OBIA Dashboards, OBIA Answers, Delivers and iBots. Experienced in configuring OBIEE/OBIA Reports & Dashboards, OBIEE Delivers, advance Reports. Experience in setting up Object level and data level security. Configured OBIEE Variables and security Users and Groups. Experience in building Reports, Prompts and Dashboards using Answers. Experience in building the reports using BI Publisher10.1.3.3. Created Reports including Charts, Pivot tables and Compound layouts using OBI Answers. Troubleshooting performance related issues with reports and data. Experience in Migration of RPD and Web Catalogue across Instances (Dev to QA and QA to Prod). Experience in ETL concepts/methodology for supporting data extraction, transformation and loading using Informatica PowerCenter. Areas of expertise in extraction, transformation, and load (ETL) of data directly from different heterogeneous source systems like flat files, Excel, Oracle, and SQL Server. Implemented ETL process to load data into target tables. Developed Informatica mappings using various transformations. Involved in performance tuning of Informatica mappings, sources, targets, transformations, sessions and SQL Queries. Excellent communication, interpersonal, analytical skills and strong ability to perform in a team On the other hand, Expert in using Ms-Excel which makes data validation very easy. Technical Skills: • BI Tools : OBIEE 10x/11x, Business Objects, Informatica 7.1/8.5, • OS & Tools : Unix, Windows NT/2000/XP, Toad, SQL Tools , WinSQL • RDBMS : Oracle 8i/9i/10g/11g, Sql Developer