Shivaranjan Uppushetty

• Product Demonstration/Workshop of Oracle Cloud Products such as Oracle Analytics Cloud, OCI Data Integration, and Fusion Analytics Warehouse, and BICC
• Participated in discovery calls with Customers/Sales Reps/Architects for gathering the POC requirements
• Deliver Proof of Concepts using BI products like OAC, OAS, Data Visualization, BI Apps/FAW, ADW, ODI, OCI DI and BI Publisher
• Build customer demos and provide first-line technical support for software evaluations and/or pilot projects
• Worked on migrations from on-premise OBIEE to OAC and OBIEE on OCI VM's
• Worked on extracting Oracle SaaS Applications data to Oracle ADW using BICC, OAC Data Replication and OCI Data Integration (OCI DI)
• Worked on FAW in terms of connecting Oracle SaaS Applications, Data Augmentation, Data Validation, Designing Security Framework, Creating KPI, Decks and Projects
• Worked on on-premise database migration to Oracle ADW
• Worked directly with customer technical teams to troubleshoot the ongoing issues and helped them to consume their cloud credits effectively
• Worked with Customer Success teams to help with (technical) questions in a Request for Information (RFI) and Request for Proposal (RFP)
• Participated in Oracle Cloud Day events
• Participated in designing OCI Data Lakehouse solution for various industry verticals like Manufacturing, Healthcare, Retail, and Financials
• Experience in modelling OAC/OAS/OBIEE RPD using Essbase Cubes.

Worked on different BI projects both offshore and onshore. Project details are below.

Project Description: DHL Express, the world's leading international express services provider implementing end-to-end supply chain contract with the Metropolitan Police Service to design, procure and deliver uniforms and equipment

Responsibilities:

• Developed Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Maps, Column Selector, with global and local filters) using Oracle BI Presentation Services
• Developed custom reports/Ad-hoc queries using Answers and assigned them to application specific dashboards
• Added users and configured security in Weblogic Console and Enterprise Manager of OBIEE 12c
• Created logical columns, Time series functions and Level based measures using admin tool in the Business Model and Mapping Layer
• Performance Tuning of Repository and Reports by setting Cache, limiting the number of initialization blocks, limiting select table types, pushing the calculation to the database
• Implemented Authentication of users using External Table and implemented Object Level and Data Level Security in BI Repository
• Configured Intelligence dashboards by including embedded content such as links/images & HTML objects
• Coordinated the OBIEE .rpd and Web Catalog objects migration from Redevelopment environment to QA environment and then to the Production environment

Environment: OBIEE 12c, ODI 12c, Oracle EBS R12, Solaris.

Project Description: ADFCA is an Abu Dhabi Government entity responsible for food regulatory system in the field of food safety. ADFCA has various enterprise applications to maintain Food Permits, Animal Identification and Registration, Fodder Sales, Animal Health and Wealth, Agricultural Census, Service Requests and Customer Service

Responsibilities:

• Scratch built BI Solution Development Management (Requirement Review, Design & Design Review, Development (Self) & Development Review (Code Review), SQA and UAT Co-Ordination) managing a technical workforce with OBIEE 12C, Oracle DB 12C & Informatica 9x
• Design and Development Review and recommendations against detailed ETL engineering including source to target column mappings for various modules using Informatica
• Designed schema using KPIs, Fact, Dimensions, Physical, Logical, Alias and Extension tables
• Built Business Model and established relationships & Foreign Keys (Physical, Logical and Complex Joins) between tables
• Developed Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Maps, Column Selector, with global and local filters) using Oracle BI Presentation Services
• Developed custom reports/Ad-hoc queries using Answers and assigned them to application specific dashboards
• GIS Maps integration and configuration with OBIEE
• Customized Informatica prebuilt mappings and workflows for enhancements as per the requirements
• Developed new Informatica mappings for enhancements and to created various reports as per various requirements
• Created workflows for full load and incremental loads to be used by DAC
• Created Custom SDE Adaptors and Assembled new Subject areas and Execution Plans in DAC for new customized subject area
• Added users and configured security in Weblogic Console and Enterprise Manager of OBIEE 11g, 12c
• Configuring and Monitoring Incremental & Full load through DAC
• Worked in production support and seen through the phase of the developments in the production and done various bug fixes
• Fixed all upgrade issues in OBIEE 12c and performance tuning in bi server and admin server for better performance
• Responsible for installing, configuring, developing, support and maintenance of the OBIEE, BI APPS, Informatica and DAC
• Production Support for around 200+ users using HPSM ticket handling tool

Environment: OBIEE 12c, BI Apps 7.9.6.4, Informatica 9.5.1, DAC 11g, Siebel CRM, Solaris.

Project Description: Department of Transport is an Abu Dhabi Government entity which runs transport in Abu Dhabi. DoT has individual applications to maintain transport related permits, service requests, Complaints, Incidents such as accidents and parking damages. After implementation of Siebel all the DoT related business has been taken care in Siebel with a 360 degree customer's view

Responsibilities:

• Gathered requirements of the various work streams by meeting with the business user and base lining the details
• Installed and Configured OBIEE, DAC and Informatica
• Configured and created OBIEE Repository, Involved in modifications of the physical, the BMM, and the presentation layers of metadata repository using OBIEE Administration Tool
• Designed schema using KPIs, Fact, Dimensions, Physical, Logical, Alias and Extension tables
• Built Business Model and established relationships & Foreign Keys (Physical & Logical) between tables
• Developed Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local filters) using Oracle BI Presentation Services
• Developed custom reports/Ad-hoc queries using Answers and assigned them to application specific dashboards
• Customized Informatica prebuilt mappings and workflows for enhancements as per the requirements
• Developed new Informatica mappings for enhancements and to created various reports as per various requirements
• Created workflows for full load and incremental loads to be used by DAC
• Created Custom SDE Adaptors and Assembled new Subject areas and Execution Plans in DAC for new customized subject area
• Added users and configured security in Web logic Console and Enterprise Manager of OBIEE 11g
• Monitoring Incremental & Full load through DAC
• Worked in production support and seen through the phase of the developments in the production and done various bug fixes
• Responsible for installing, configuring, developing, support and maintenance of the BI APPS

Environment: OBIEE 11g, BI Apps 7.9.6.3, Web Logic Server, Informatica 9.0.1, DAC 10.1.3.4.1, Siebel CRM, Windows Server 2008.

Project Description: Allanasons is an India's largest exporter of processed food products and agro commodities. The Company has been designated as the Five Star Trading House by the Government of India and the World's Largest Producer and Exporter of Frozen Halal Boneless Buffalo Meat. Allanasons is India's largest exporter of coffee as also leading exporter of cereals and frozen marine products. The Group has also set up plants for processing, preserving and freezing of Marine Products across India.

Responsibilities:

• Gathered requirements of the various work streams by meeting with the business user and base lining the details.
• Created logical columns, Time series functions and Level based measures using admin tool in the Business Model and Mapping Layer.
• Modified presentation layer dimensions and attributes to match user requirements.
• Developed custom reports/Ad-hoc queries using Oracle BI Answers and assigned them to application specific dashboard.
• Customized key reports for business such as Balance Sheet, Profit & Loss, ROI, OM reports for business to analyze.
• Developed different kinds of Reports Pivots, View Selectors, Column Selectors, and Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters, and Page/Dashboard Prompts.
• Used Filters (global and local) and provided customized Prompts to avoid excessive data showing up in the reports.
• Performance Tuning of Repository and Reports by setting Cache, limiting the number of initialization blocks, limiting select table types, pushing the calculation to the database.
• Implemented Oracle EBS security integration with BIApps.
• Implemented Authentication of users using External Table and implemented Object Level and Data Level Security in OBIEE 11g Repository in BI Repository.
• Configured Intelligence dashboards by including embedded content such as links/images & HTML objects.
• Coordinated the OBIEE .rpd and Web Catalog objects migration from Redevelopment environment to QA environment and then to the Production environment.
• Used DAC (Data warehouse Application Console) for both incremental and full loads.
• Monitored and Scheduled ETL along with reducing application configuration and development time by using DAC.
• Provided end-user training and documentation and second-line support to power users to develop dashboards, reporting metrics and reports.

Environment: OBIEE11g, BIApps 7.9.6.3, Informatica 9.0.1, DAC 10.1.3.4.1, Oracle EBS R12, Oracle 11g, Windows Server 2008, HP UX.

Project Description: Jostens is an American manufacturer of memorabilia. The company is primarily known for its production of yearbooks and class rings for various high schools and colleges as well as championship rings for sports. Jostens also produced photobook products for Disney's PhotoPass photography service offered at Disney theme parks and resorts.

Responsibilities:

• Partnered with the OBIEE team in analyzing business requirements
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas
• Added Aggregate measures using Aggregate Persistence Wizard
• Involved in creating Dashboards for the reports also using Guided Navigation and Links
• Involved in Performance Tuning of reports
• Configured iBots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching and Configured Business Intelligence Delivers
• Designed Interactive Dashboards and created dashboard prompts with multiple selections
• Generated compound views and advanced features such as editing prompts, inserting funnel and gauge views in the BI Answers Request

Environment: OBIEE 10.1.3.4.1, BI APPS 7.9.6.1, Informatica 8.1, Oracle 11g