Venugopal Arra

• Involved in requirements gathering of the various work streams by meeting with the business user and base lining the details. • Involved in assisting building detailed project schedule, gathering the requirement, completed the proof of concept in translating functional requirements into technical requirements, designed, developed and making Technical designs and Unit test scripts • Created Technical Requirement based on BRD functional document for (Order Management, Order Fulfillment and Inventory Etc) • Configured out-of-the box and custom Analytics Reporting functionality of Supply Chain and Order Management Analytics using OBI Answers. • Involved in designing and development of building Physical Layer, Business model and presentation layer and report development. • Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and Presentation layer. Also created hierarchies and variables in the repository • Defined dimensional hierarchies and associated the proper level of granularity to the fact table. • Created Time Series Metrics by using Ago and Todate functions. • Modified many logical Metrics/Columns by duplicating as per the requirements. • Implemented Multiple Currency metrics for SCOM, POS and Performance dashboard by using Static, Session and Request variables. • Involved in implementing the Security by creating the Users, Groups, Web Groups In RPD and Web Catalog • Implemented external tables for Authorization and LDAP for Authentication. • Created Complex Reports by using Pivot, Table, Chart, Column selector, View Selector and Union view for POS and Performance Reports/Dashboards. • Enabled Usage Tracking and Dashboards to track performance by updating the NQSconfig.INI file. • Migrated RPD and Catalog from Dev Windows’s environment to QA Linux environment by using the WinScp and Catalog Manager.

Cox Communication is the third-largest cable entertainment and broadband services provider in the country, Cox Communications Inc. is best known for pioneering the bundle of television, Internet and telephone services together. EBI Department is upgrading BI Reports and Dashboards from Obiee 10.1.3.4.1 to Obiee 11.1.1.3 because of new features are added in Obiee 11g. •Installed OBIEE 11.1.1.3 on Windows Server 2003 Environment.•Installed Repository Creation Utility on Oracle 11g Database.•Upgraded RPD and Catalog from OBIEE 10.1.3.4.1 to OBIEE 11.1.1.3 by using ua.bat file. Perform Any Required Post-Upgrade Manual Steps for Oracle BI EE. •After up gradation of RPD fixed Errors and warnings compatible with OBIEE 11g.•Deployed RPD and Catalog by using Enterprise Manager.•Compared OBIEE 10g reports and Dashboards with OBIEE 11g Reports and Dashboards. •Added new Tags into the OBIEE 11.1.1.3 instanceconfig.xml file resolve the report and dashboard issues like Graph engine is not responding, pivot table/charts display twenty five rows by default etc.•Opened Service Requests (SR’s) for RPD and Reports issues.•Regularly coordinated with Oracle support team for resolution of the Issues.•Created Users and Groups in the Embedded Web logic LDAP Server by using Oracle Web logic Server Administration Console.•Created Application Roles and Policies using Fusion Middleware Control and mapped Application roles to the Groups. •Implemented Security by using External table Authentication. •Created different Views like Table, Pivot, Graph, Narrative, Static, Filter for testing purpose.•Given Suggestions and solutions to the Developers for up gradations issues and also documented.•Migrated and upgraded RPD’s from OBIEE 10.1.3.4.1 to OBIEE 11.1.1.3 by using UDML Script.Migrated Catalog from OBIEE 10.1.3.4.1 QA Environment to OBIEE 10.1.3.4.1 PROD Environment by Using Catalog Manger after that upgraded to OBIEE 11.1.1.3 by using up gradation utility.

Riverbed Technology partnered with KPI Partners for rolling out their enterprise wide Business Intelligence Application Solutions. Responsible for all activities related to the development, implementation, administration and support of ETL processes and for scheduling using DAC and reporting using OBIEE Customized and developed approach to load data into GL Star, AP Star, AR Star, Budget star Data Models using ETL tool Informatica,Configured DAC –Data warehouse Access control for running of ETL jobs. Worked with all three layers in the repository – Physical, Business, and Presentation Layer. Worked on security for users based on LDAP Authentication type in Production and also other Authentication types (External table authentication and Database) in other environments. Implemented the Cache Purging Strategy and usage tracking of Reports.Implemented the Implicit Fact column for all Subject areas.Defined dimensional hierarchies and associated the proper level of granularity to the fact table.Added column/data level security at the repository level. The data was restricted with respect to the group user belongs too. Created Summary and Detail reports according to user requirements and also created corresponding dashboards for the reports.Customized Out Of Box Dashboards and Reports as per the User requirements given by the client. Actively involved in deployment and post release support. Trained the users on how to use the Dashboards and Answers and also modify the stored reports in Answers.

Smiths Medical is a leading global provider of medical devices for the hospital, emergency, home and specialist environments. Smiths Medical partnered with Apps Associates for rolling out their OBIEE solution. As part of their rollout, Smiths Medical is migrating their existing entire Discoverer based reporting solutions into OBIEE based reporting solutions, rollout dashboards for Global Sales Force, Global Marketing, Global Finance Subject Areas. I involved in RPD Development by Creating new metrics, Logical Columns, Created Repository Varaibles and Session Varibles,Implemented LDAP and External Table Authentication,VPD and External Table Autherization.Developed different types of Views and finally developed Dashboards.Applied Object level security,Implemented Delivers.

Executive Report Automation deals with the financial reporting like Assets & Flows, Fund Of Funds, Data Programming, Monthly, Income-Statements and Fidelity Cost and Profitability of Fidelity. The project involved in development of reports in OBIEE and also in modifying the Metadata (RPD).Fund Of Funds: Developed Dashboards that allow the users to better understand the underlying investment products of a pool of Assets.Income Statement: Implemented business logic to assist in producing the firm’s monthly income statement in an efficient and timely manner. Interacted with Business Users and Business Analysts for gathering new business requirements and also understand the current requirements, performed GAP Analysis, and Data Analysis.Involved in modifications on the Repository Metadata. Developed Logical Columns in Business Model Layer based on Business Requirements by using Time Series Objects and business logic’s, and creating the Presentation catalogs in Presentation Layer.Developed different kinds of Reports using Table and Pivot Views, View Selectors, Column Selectors, Narrative Views, Static Views ,Chart and Plot Views, Title Views and Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters, and Page/Dashboard Prompts. Developed different kinds of complex reports using Unions and Flex Edges.Developed different kind of reports using BI Publisher.Extensively used Dynamic Section Prompts and Guided Navigation in dashboards.Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment.Involved in Upgrade process of the entire infrastructure from OBIEE 10.1.3.3.2 to OBIEE 10.1.3.4. Performed the Performance Tuning of Dashboards/Reports and made required changes to repository and database. Performed Unit testing to validate report.Involved in UAT and post Production Support.

Competitive Marketplace Insight enables more effective decisions that drive profitable market share growth through simple, accurate, timely access to marketplace intelligence data for all levels and functions at whirlpool and for our trade customers. I designed and developed RPD by importing the Dimensional and Fact tables,Created new metrics and logical columns,Implemented security by using LDAP.Configured Delivers. I have created various kind of views like Table,Pivot,Chart,Narrative,static,Column and View Selector etc.Then developed Dashboards,I integrated BI Publisher with OBIEE,I Implemented Usage Tracking.