Technical and highly innovative IT Professional, with over 10 years of general IT experience and 9 years of experience in Business Intelligence Applications using Oracle Business Intelligence (OBIEE) / Oracle Business Intelligence Apps (BI Apps) and various Business applications. 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. Experience in translating user requirements into functional, technical and system specifications, managing clients/ vendors/ partners relationships, ensuring service delivery and tracking requests for system enhancements, improvements from end-users /customers. Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to OBIEE Repository. Strong aptitude for learning and understanding business process and needs. Over 10+ years of diversified IT experience of which 9 years in working with Business Intelligence, Big Data Applications, OBIEE Admin, Weblogic, OBIEE Analytics, Oracle BI Applications, which include building and configuring repository, creating and managing Oracle BI Intelligent Dashboards, Oracle BI Answers, Oracle BI Delivers, Oracle BI iBots and Extraction Transformation and Loading using Informatica. Implement BI solutions for Financial, business processes and HR. Automation of OBIEE routines using scripts ( cleaning temp files etc) WebLogic Configuration, Administration, and Performance tuning. Expertise in converting and using Oracle pre-built rpd’s OBIA,DAC (Financial, HR etc.) Expertise in Business Model development with Facts, Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management. Experience in OBIEE interfacing with various applications. Experience in performance tuning at the Database level by creating aggregate tables, Bitmap, B Tree Indexes, RPD level by creating Database hints in physical Layer, Tuning Reports. Experience in implementing Security at object level and data level using Repository Variables, Initialization Blocks, and Session Variables. implementing Security Models for Dashboards, Row Level, Object Level, Role Level. Expertise in configuring Interactive Dashboards with drill-drown capabilities using global and local filters, Security setup (groups, access/query privileges), metadata objects and web catalog objects (Dashboard, Pages, Folders, Reports). Expertise in implementing Oracle BI Apps in all phases like implementing Out of the Box(Vanilla mappings) prebuilt mappings, Designing ETL, metadata management using DAC, Creating Oracle provided data warehouse BAW,OBIEE RPD development, OBIEE reports and dashboards Expertise in Data warehouse Administration console (DAC) to configure, monitor and schedule ETL routines. Expert in Unit, System and Integration Testing and Performed Data Validation for all the ETL’s and reports generated from Informatica and OBI Analytics. Extensive experience in working with RDBMS like Oracle, MySQL and SQL Server. Experience in creating SQL, PL/SQL, Stored Procedures/Packages/Triggers/Cursors and UNIX Shell scripts. Exposure to competitive BI tools/technologies like OBIEE / OBIA / Business Objects / Spotfire / Tableau / Hadoop (cloudera) / R / Noetix / Informatica. Part of Tableau Public Authors http://public.tableausoftware.com/profile/niranjan59 Worked on Architectural solutions for business users. Business Intelligence & Reporting tools: OBIEE 11.1.1.7/6/5/3,10.1.3.4/ 3/2, Oracle Business Intelligence Applications 7.9.x,Tableau and exploring – Data Modeling / ETL/ Scheduling Tool: Informatica Power center 7.x, 8.x, 9.x, Star and Snow flake Design, DAC – RDBMS: Oracle 10g/9i/8i, SQL Server 2000,MySQL 4.0 – Database Tools: SQL*Plus, SQL * Loader, PhpMyadmin, ODBC, SQL Tools, TOAD – Change Management Tools: Clear Case, Clear Quest, Remedy, Bugzilla – Web Technologies: HTML, Java, JavaScript, JDBC, XML, XHTML,XAMPP – Programming Languages: C, C++, SQL /PLSQL and Shell scripting – Operating Systems: Windows XP/NT/2000/2003/2008 , UNIX (AIX, Linux), understanding of *nix – Other Applications Interacted: Siebel, Oracle BRM, Oracle EBS, Noetix, Tibco Spotfire, Hadoop, Primavera