Audrey Masawi
• 10 plus years of IT Industry experience. • 8 plus years of experience in Business requirement gathering, Analysis, Design, Data modeling, Development, Testing and Implementation of Data warehousing using Oracle Business intelligence 11.1.1.5.0,11.1.1.6.0, 10.1.3.2/3.3/3.4 and Siebel Analytics 7.5/7.7/7.8. • Experience in Installing, configuring and administering OBIEE/Siebel Analytics server, both in standalone and enterprise applications. Business model development with facts, dimensions, hierarchies, measures, partitioning, Aggregation rules, time series and cache management. OBIEE/Siebel Analytics Repository (.rpd) development at three layers (Physical Layer, Business Model & Mapping Layer and Presentation Layer) and configuring metadata. OBIEE/Siebel Analytics security at the data and object levels. OBIEE Answers, Dashboards, Delivers, i-Bots and BI publisher. Creating report layout templates in BI publisher. Designing Interactive dashboards, incorporating dashboard prompts, navigation, drill down and web catalog objects using OBIEE. Performing data integration using ODI (oracle Data Integrator) ETL process using Informatica in extraction, transformation and loading from multiple data sources to Data warehouse. Managing ETL mappings and executing workflows using DAC. Creating complex and reusable mappings, transformations, and multiple file handling sessions in Informatica. Working with CRM and ERP applications as Siebel CRM, Oracle apps, people soft and their integration with OBIEE. Working with SQL developer and SQL server management studio to create and maintain tables, schemas and joins in the back end. • Good understanding of database design, OLAP, OLTP and normalizations. • Proficient in programming languages like java, C, C++, python. • Proven leadership qualities, strong technical, organizational and communication skills. Technical Skills • BI : OBIEE 11.1.1.x/10.x (Administration tool, Analytics, Answers, Dashboards, Delivers and BI publisher) and Siebel 7.x (Administration tools and Analytics) • CRM :Siebel CRM • ETL : Informatica 8.x/7.x/6.x, DAC • ELT oracle : Oracle Data Integrator (ODI) • Languages : Java, Python, c, c++ • RDBMS : Oracle 10g/11g, SQL server • OS : Windows 2000/XP/NT/7/Vista, UNIX and LINUX • Tools :MS Visio, Eclipse, Glassfish, Oracle JDeveloper 11g/10.1.1.3, Autosys 4.x, VSS 2005