* Over 7 years of IT experience in Data warehousing and Business intelligence with emphasis on Application Design, Development, implementation and maintenance of client/server Data Warehouse and Data Mart systems . * Over 6 years of experience in providing end-to-end business intelligence solution Using OBIEE, Siebel Analytic Applications and Informatica. * Strong Experience in configuring metadata and building OBIEE Repository consisting of three layers (Physical Layer, Business Model & Presentation Layer). * Experience in Installation and Configuration of OBIEE 10.1.3.x/11.1.1.x, Informatica 8.x. * Hands on experience in configuring and developing the Analytics/OBIEE repository (.rpd), which involves Schema Import, Implementing the Business Logic by customization, Dimensional hierarchies, Aggregate navigation, Level Based Measures, security Management(Data level/Object level security), Variables, Initialization blocks, cache Management, MUDE, utilities, subject areas etc. * Strong Experience in designing Star Schema, Snowflake Schemas and Multi Dimensional modeling methodologies using OBIEE Analytics Administration tool. * Configured Answers (ad-hoc querying, reports), Interactive Dashboards with drill-down capabilities (charts/tables/graphs), Delivers/iBots (alerts) and administered Web Catalog Objects (pages, folders). * Worked Extensively in Creating Users, Groups, and Initialization Blocks in Oracle Admin Tool to set up Security using LDAP. * Experience with BI Publisher for development and documentation of reports. * Extensive knowledge of Oracle APEX (Application Express). * Extensive experience in various types of custom Authentication/Authorization schemes within APEX, custom security roles and features, custom CSS and Javascript incorporation including Custom Plugins, Custom Chart and Jquery in APEX applications * Expertise in Creating Dynamic Interactive Dashboards and Reports using Prompts, Filters, Calculations, Conditional Formatting, Drill Thru, Drill Up. * Expertise in working with Financial, Sales, HR, Procurement and Spend Analytics, Supply Chain Analytics, Order management Analytics, Project Analytics * Expertise in OLTP/OLAP system study, analysis and E-R modeling. Extensive experience with E-scholar Data model i.e fact and dimensional tables. * Strong conceptual background of RDBMS and access methods SQL, PL/SQL. * Complete knowledge of data ware house methodologies (Ralph Kimball, Inmon), ODS, EDW. * Immense ability to effectively provide technical documentation . * Independently handled application development and modifications. * Excellent problem solving skills with strong technical background and good inter-personal skills. Quick learner and excellent team player, ability to meet deadlines and work under pressure. TECHNICIAL SKILLS: Reporting Tools: OBIEE 10.1.3.x/11.1.1.x, OBIA, Oracle Apex 3.2/3.5/4.0, Business objects, BI Publisher 10.1.3.4.2. Oracle Utilities: TOAD 9.0/7.0/6.5, SQL Plus 10.x/ 9.x/ 8.x ETL Tools: Informatica Power Center 8.x, ODI. Operating Systems: Windows 95 / 98 / NT / XP, UNIX, MS DOS. Languages: C, C++, SQL, PL/SQL Databases: Oracle 11i/10g / 9i / 8i, SQL Server 2000. Applications: • MS Word, Excel, Outlook and PowerPoint. Data Modeling • Microsoft Visio, Ervin 4.1, Dimensional Data modeling(star schema, snow flake schema, physical and logical data modeling.