Profile of Kumar
Kumar Warehousing
Experienced Business Intelligence Architect with over 8 years of expertise in designing, implementing, and maintaining data warehouse and transactional systems. Proficient in gathering business requirements, system analysis, data modeling, and implementation. Specialization in Oracle Business Intelligence Enterprise Edition (OBIEE) and Oracle BI Applications.
Skills:
* Business Intelligence (BI) Design and Implementation
* Data Warehousing and Data Mart Creation
* Gathering Business User Requirements
* System Analysis and Design
* Data Modeling (Ralph Kimball and Bill Inmon Methodologies)
* OBIEE Repository Development (Physical Layer, Business Model, Presentation Layer)
* Time Series Objects
* Interactive Dashboard Design with Drill-Down Capabilities
* Security Setup and Configuration (LDAP, Database Authentication, SSO)
* Security Models Implementation (Row Level, Object Level, Role Level, Dashboard Level)
* Aggregate Table and Materialized View Creation
* OBIEE Best Practices Implementation
* Oracle BI Apps Implementation
* Data Warehouse Administration Console (DAC) Configuration and Management
* ETL (Informatica Power Center)
* Report Development (OBIEE, Oracle Reports, Discoverer, XML Publisher)
* Supply Chain Analysis and Dashboard Design
* Informatica Mapping and Transformation (Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, Aggregator)
* Functional and Technical Design Document Development
* Databases/RDBMS: Oracle 11g/10g/9i, MS Access, SQL Server 7.x, 2000, Teradata V2 R6
* ETL Tools: Informatica Power Center 9.1, 9.0.1, 8.1.1, 7.1, DAC 11g/10.1.3.4.1/7.8.5v, ODI
* Oracle Applications: Oracle Financials E-Business Suite R12/11i (Order Management, Inventory, Purchasing, General Ledger, Accounts Receivables, Accounts Payables, Fixed Assets, Cash Management, AOL, System Administrator), PeopleSoft 9.1/9.0 (Financials, HR)
* Developer Tools: OBIEE 11g/10g, DAC 11g/10g, Oracle Reports 10g/6i/4i, Oracle BI Apps 11g/7.9.x, Oracle Forms 10g/6i/4i, Discoverer 10g/6i/4i, BI Publisher 10g/11g, Oracle ACPP, Oracle Endeca, TOAD 9.7.3/8.x, SQL*PLUS, Data Loader, SQL*Loader, SQL Developer
* Languages & Tools: SQL, PL/SQL, C, C++, C#, HTML, XML, Teradata SQL, Toad
* Operating Systems: Windows NT/XP/2000/98, UNIX, IBM/AIX 5.30, Red Hat Enterprise Linux