Ashish Kumar

Over seven years of experience in Software Development and Expertise in OBIEE 11g, gathering Business Requirements, Analysis, Design, Data Modeling, Development, Implementations and Testing of Data Warehouse/Data Mart and Database business systems applications. Expertise in complete life cycle of Design, Development, Maintenance and Documentation of various functionalities of Data Warehouses and Data Marts. Expertise in Data Analysis, Performing Gap Analysis, Identification of dimensions, Facts & aggregate tables, Measures and Hierarchies. Extensive experience in providing end-to-end business intelligence solutions by dimensional modeling design, building business models, configuring metadata, creating reports / Dashboards, cache monitor, building OBIEE Repository consisting of three layers (Physical Layer, Business Model & Presentation Layer), time series objects, configuring OBIEE (groups, access / query privileges) using OBIEE. Exposed to working with Oracle Business Intelligence and performed proof of concept on BI publisher. Excellent problem solving skills with strong technical background and good interpersonal skills. Quick learner and excellent team player, ability to meet deadlines and work under pressure. Excellent ability to understand and analyze the client requirements. Business Intelligence Responsible for interacting with business partners to identify information needs and business requirements for reports. Strong in Analysis and collecting business requirements from BSA’s, users. Expertise in creating Business / Functional Documentation for Business Analytics OBI EE Stand Alone Experience in building and deploying an OBI repository (Physical, Business and presentation model) to create Dashboards, answers, iBots. Experience in creating dimension hierarchies and level-based measures. Experience in adding disparate sources to business model objects. Experience in modeling aggregate tables to speed processing. Experience in building calculated measures for the fact tables. Experience in setting up a Multi-User Development Environment (MUDE). Proficient in using the time-series functions to support historical time comparison analysis. Experience in using OBI answers to run queries to test and validate the repository. Experience in creating requests, adding filters, creating prompts, and creating pivot tables using OBI. TECHNICAL SKILLS ERP: Oracle Financial R12/11i/11.3 (GL, AP, FA, AR) Oracle BI EE: Oracle BI Administration Tool, Answers, Dashboards, Delivers, BI Publisher MS-Office Plug-in Languages: PL/SQL, SQL Operating System: WINDOWS, UNIX Databases: Oracle 11g/10g/9i, MS SQL Server 2008/2005/2000, MS Access Oracle Tools: Oracle FSG, SQL*Loader, APEX 3.2, Oracle SQL Developer Platform: UNIX, Windows XP/Vista, MS-DOS Project Management: AIM 3.0, SharePoint, and Ms Project Office Tools: MS Office Enterprise Data Modeling Logical / Physical, Star/Snowflake Schema, FACT & Dimension Tables.