Data Oracle

Location:

Columbia, MD

Posted:

July 11, 2016

Contact this candidate

Resume:

Venkata Kolla. Mail: acvnd8@r.postjobfree.com.

Senior OBIEE Consultant/Administrator. Cell: 667-***-****.

Professional Summary:

I am a Senior OBIEE/OBIA consultant with 10+ years of experience in gathering requirements, designing, implementation, building, testing and customizing the OBIEE 10g/11g and BIAPPS 7.9.6.x. I have 3 years of experience in implementing the BIAPPS finance and HR analytics modules using E-Business suite as source system. I have good experience as an OBIA/OBIEE Technical Lead which includes managing the releases in the recent projects. I also have vast experience writing Technical documentation as a Technical Analyst as well as preparing and presenting the User Training Manuals. I have experience in managing the offshore teams as a Technical Lead and in setting up and training the offshore team. I am a very good team player and a quick learner. I have good communication and interpersonal skills. I am a quick learner and am open to new ideas. I not only remain motivated all the time but also motivate the team members by my abilities; I have extensive experience working with HR, Financial and Insurance clients.

Good working experience in Upgrade OBIEE environments from lower version to higher version.

Good experience in web logic administration for system management and fusion middleware control for monitoring the java and system components.

Deploy the RPD files, enabled/disabled cache parameters, performance setting and restart the OPMN services in EM.

Worked on cache management which deals with purging & seeding the cache, enable the cache etc.

Migrate the repository and presentation catalog between different environments like Dev, test,QA and maintenance.

Worked with maintenance team by creating scripts like kill the process, moving the logs, Restart services, Load average, long running queries and also setting up the Cronjobs for every week to recycle the OBIEE server.

Enabled usage tracking in OBIEE 11g which would help to track the Application usage.

Supports 24*7 and coverage weekend outage (DB, Linux, patching) Activities.

Experience in implementing end-to-end of various functionalities of Data Warehouse, Data Marts, and Business Intelligence and Transactional applications.

Strong Business Intelligence and Data warehousing experience with using Oracle Business Intelligence and BI Publisher, DAC, Informatica.

Expertise in design and development of Oracle Business Intelligence (OBI)Administration tool Repository (.rpd) at three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, configuring Interactive Dashboards with drill-down capabilities using global and local Filters, Security Setup (Data Level and Object Level using Oracle BI repository security), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).

Extensive experience in providing end-to-end business intelligence solution by dimensional modeling design, building business models, configuring metadata, Answers, Delivers/iBots, creating Reports/Dashboards, cache monitor, and building OBIEE Repository.

Performed OBIEE System Administration Tasks like granting privileges, creation of custom, complex and summary folders, linking folders for Drill-to detail, Configuration of system for deployment, Starting and Stopping services, managing and resolving services, migration of rpd and web catalog from test to production, backing up metadata.

Developed many Reports using different Analytics Views (Pivot Table, Chart, and Column Selector), Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters. Extensively used OBIEE Delivers and iBots

Experience in RPD, Data Modeling, ETL, OBIEE/BI Publisher, Siebel Analytics, Web Catalog. and OBIEE star schema

Experience in Security Setup at both Object and Data levels, which involved creation of users/ groups, Access privileges, LDAP authentication setup and configuration of Multiuser Development Environment.

Administering the OBIEE Dashboards and Reports, Data Visibility.

Experience in customizing Informatica workflow like SDE, SIL and PLP mappings.

Proficient experience in different Databases like Oracle and SQL Server.

Worked on Extract, Transformation and Loading of data from Multiple Sources to Data Warehouse using Informatica as ETL Tool.

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.

Administering the OBIEE Dashboards and Reports, Data Visibility.

Proficient in installation and configuration of all BI, ETL and data warehousing products.

Worked on Extract, Transformation and Loading (ETL) of data from Multiple Sources to Data Warehouse.

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 Written and Verbal Skills; Results oriented and Self- Starter looking for challenges; Ability to rapidly learn and apply new technologies and improve processes; Self motivated and results- oriented with solid work ethic.

Ability to work independently as well as in a team, fun-filled and challenging environment.

knowledge on basic concepts of Oracle Data Integrator, Business Intelligence Application Configuration manager and Functional setup manager.

EDUCATION BACKGROUND:

Master of Science (M.Sc.) from Bharathidasan University, India.

CERTIFICATION:

Certified in Oracle Business Intelligence Foundation suite 10g & 11g versions from Oracle Corporation.

Certified in Oracle Business Intelligence cloud service specialist from Oracle Corporation.

Certified in Introduction to oracle 9i: SQL.

Certified Tester foundation Level ISTQB/BCS.

TECHNICAL SKILLS:

Oracle Business Intelligence EE 10x/11x/12c (Administrator, Presentation Services, Delivers, Agents).

Oracle Business Intelligence Applications 7.9.6.X.

Oracle Map Viewer 11.1.1.x.

Oracle BI Cloud Services, BI Publisher, BI Office.

Informatica 9.x (Power Center).

Data warehouse Administration Console (DAC) 10g/11g.

Oracle 9i/10g/11g/12c,PLSQL,SQL*PLUS 8.x/9.xTOAD.

Windows 95/98/NT/2000, Unix, Linux.

PROFESSIONAL EXPERIENCE:

HRIT. Honeywell. New jersey, USA.

Sep 2015 to till date.

Role: Sr. OBIEE Developer/Administrator.

Environment: OBIEE 12C, OBIEE 11.1.1.9.0, BIAPPS 7.9.6.4, Informatica 9.5.1, DAC 11g, Oracle 11g, Oracle E-Business Suite, Red Hat Linux.

HRIT. Honeywell-This project involves transition of IBM Cognos BI reporting to Oracle HR Analytics so as to offer complete business integration and process management allowing Honeywell to integrate their people with business processes and technology effectively and efficiently. Large user community spread across North America, Europe and Asia.

The goal is to replicate all existing HR reports developed in IBM Cognos through OBIEE reports and dashboards. In addition to providing the standard Oracle HR Analytics reports, the tool will fully integrate Oracle HR Analytics into existing environment where existing integrations are designed for Cognos.

Responsibilities:

Interacted with various internal business units & external vendors to gather requirements.

Installation and Configuration of OBIEE 11G and 12C.

Log Monitoring on OBIEE Analytics, BI Scheduler Server and Presentation servers Include WebLogic Server.

Taking server performance report for all OLTP servers daily hourly basis.

Providing support to user in order to resolve system and application related issues.

Monitoring the obiee server components.

Supports monthly schedule activities for moving the code from dev to stage and production.

Enabled usage tracking in OBIEE 11g which would help to track the applications usage.

Maintain documentation on system environments related to OBIEE and upload it in libraries.

Application development, Application configuration, setting up Application, Migrating Applications.

Involved in customization of Repository and Catalog.

Installation and configuration of OBIEE 11.1.1.7.1, BIAPPS 7.9.6.4. versions.

Applied Oracle patches to fix the existing bugs in application.

Creating/customizing the OBIEE Repository and reports based on the new requests from business users.

Worked on Dimensional modeling by converting transactional data into the analytical data.

Worked closely with the ETL and Database Team to coordinate the Necessary Data movement.

Built OBIEE reports against to the Oracle DB and configured the RPD connectivity with Oracle Data source.

Apply analytical skills to high-level Business requests to determine the needs of the business and transform the requirements to technical specs.

Suggested the creation of Indexes, Partitions for the tables.

Created dimensional hierarchies as per the business needs.

Worked on Dimensional modeling by converting transactional data into the analytical data.

Worked closely with the ETL and Database Team to coordinate the Necessary Data movement.

Suggested the creation of Indexes, Partitions for the tables.

Created Logical Tables, Dimensions, Facts and additional Metadata in the Business Layer by using Administration tool.

Worked extensively on BMM (Business Model and Mapping) layer to develop various business models using Star Schema and Snowflake Schema.

Created Session (Static & Dynamic) and Repository (System and Non-system) variables.

Created the DAC Execution plan reports in Answers to analyze the Load Plans.

Built Interactive Dashboards and Reports using Tabular, Pivot and Pie Chart Reports with Drill down and drill up capabilities to enhance granularity in the Data.

Setup the security of Dashboards to employees with respect to their responsibilities. Administered permissions and privileges for Dashboard visibility and modifications to users based on their groups or responsibilities.

Managed Catalog migration and RPD version control between Dev, Test, UAT 7 Production environments.

Unit tested the code and documented the results.

Involved in Production deployments and releases.

Profit View, Wells Fargo, C.A, USA.

Mar 2015 to Sep 2015.

Role: Sr. OBIEE Consultant/Administrator.

Environment: OBIA Apps 11.1.1.8.1, OBIEE 11.1.1.9.0,Oracle Data Integrator, Oracle 11g, and Red Hat Linux.

Profit View is a new Wholesale profitability system that will calculate relationship profitability for Wholesale relationships. Profit View will provide more accurate, complete and timely relationship profitability and Cross Sell data that leverages the wise data infrastructure and common master data, and is delivered via a business intelligence user interface. The overall program goal is to provide wholesale businesses and product partners with critical, accurate profitability business intelligence in a timely fashion to drive the right decisions and enhance business profitability.

Responsibilities: OBIEE 11.1.1.5, 11.1.1.6, 11.1.1.7, Oracle 11g, and Red Hat Linux.

Installation and Configuration of OBIEE 11.1.1.5, 11.1.1.6, 11.1.1.7.

Log Monitoring on OBIEE Analytics, BI Scheduler Server and Presentation servers Include WebLogic Server.

Taking server performance report for all OLTP servers daily hourly basis.

Good experience in to setup SSO Integration with our obiee application.

Audit trails for all the servers.

Automation of schedule scripts to case of server administration.

Providing support to user in order to resolve system and application related issues.

Monitoring the obiee server components.

Worked on database refresh at DBA level.

Supports monthly schedule activities for moving the code from dev to stage and production.

Enabled usage tracking in OBIEE 11g which would help to track the applications usage.

Maintain documentation on system environments related to OBIEE and upload it in libraries.

Application development, Application configuration, Setting up Application, Migrating Applications.

Co-Ordination with DBA/other support teams for planned/unplanned outages.

Created users and groups in weblogic Console.

Changes going production/repository migration.

Done with the mapviewer reports and run the jobs.

Working with migration of the repository(.rpd) and cache management.

Involved SSO integration with our OBIEE application.

Ability to restart the services from Console and Linux

Experience in trouble shooting issues on the server side and presentation side.

Go-Live and Post Production Activities.

Rasing/Attending techinical discussions through bridge calls along with other teams for root cause analysis including identification, resolution, escalation, referral and followup with vendors.

Good team player with excellent Functional, analytical and Inter personnel skills.

Bio Marin Pharmaceutical Inc. CTMS, California, USA.

Nov 2013 to Feb 2015.

Role: Sr. OBIEE Developer/Administrator.

Environment: OBIA 7.9.6.4, OBIEE 11.1.1.7.1, Informatica 9.5.1, DAC 11g, Oracle E-Business Suite, Red Hat Linux.

Bio Marin Pharmaceutical Inc. The goal of the project is to outline a reporting solution that will fit the needs of most of the Bio Marin CTMS trial managers, targeted for biotechnology and pharmaceutical research and analysis. OBIEE to serve as a central repository of clinical trial management information to provide greater visibility into real-time site and study statuses and improve clinical quality and resource utilization.

Responsibilities:

Installation and Configuration of OBIEE 11.1.1.5, 11.1.1.6, 11.1.1.7.

Log Monitoring on OBIEE Analytics, BI Scheduler Server and Presentation servers Include WebLogic Server.

Taking server performance report for all OLTP servers daily hourly basis.

Good experience in to setup SSO Integration with our obiee application.

Audit trails for all the servers.

Automation of schedule scripts to case of server administration.

Providing support to user in order to resolve system and application related issues.

Monitoring the Obiee server components.

Worked on database refresh at DBA level.

Supports monthly schedule activities for moving the code from dev to stage and production.

Enabled usage tracking in OBIEE 11g which would help to track the applications usage.

Interacted with various internal business units & external vendors to gather requirements.

Involved in customization of Repository and Catalog.

Developed many reports and dashboards as per the user requirement.

Developed and Debugged Dashboards /Reports with different analytics views (Pivot table, Chart, Tabular and View Selector), Alerts, Guided Navigation and Dynamic /Interactive Dashboards with drill down capabilities using global and local filters

Performed OBIEE System Administration Tasks like Configuration of system for deployment, Security privileges like Object level & Data level, Starting and Stopping services, managing and resolving services, migration of rpd and web catalog from test to production, backing up metadata.

Created Dimensional hierarchies as per the business needs.

Effectively created Dashboard prompts, Page prompts, Global and local filters.

Created Session, Repository, Request, Presentation Variables and Initialization Blocks.

Created users and groups in the Database to implement the Object level security.

Created OBIEE analytical functions in reports as per user requirement.

Experience in OBIEE 11g Administration in Linux & Windows which includes starting/stopping the servers, managing deployments to different environments.

Configured LDAP security in web logic and Enterprise Manager for authentication of Users.

Involved in tuning the OBIEE reports by creating the indexes and Oracle Hints.

Involved in configuration of map viewer and created few reports.

Involved in designing and customizing Informatica workflows like SDE, SIL and PLP mappings.

Configured the Informatica workflows in DAC.

Created Technical Design Documents based on the Business Requirement Documents.

Involved in testing the reports on all data sources.

Used Multiple Logical table source (LTS) concept in order to convert Snowflakes to Star Schema in Rpd.

Created Opaque views in Physical layer to minimize the effort at database level.

Worked on the RPD upgrade and catalog objects upgrade from 11.1.1.6.8 to 11.1.1.7.1.

Managed Catalog migration and RPD version control between Dev, Test, UAT 7 Production environments.

Involved in Production deployments and releases.

Involved in Support activities post production.

Fitch Ratings, New York, USA.

Jan 2012 to Nov 2013.

Role: Sr. OBIEE Developer/Administrator.

Environment: OBIA Apps Version is 7.9.6.3(OBIEE 11.1.1.7.1, Informatica Version and Hotfix is 9.0.1 Hotfix 2, DAC Version is 10.1.3.4.1), Source System is PeopleSoft Financials 9.1 on an 11.2.0.2 Oracle Database, Data Warehouse Database (EDWP) is Oracle 11.2.0.3, Oracle Essbase 11.1.1.X.

Fitch Ratings, is the long-term credit ratings are assigned on an alphabetic scale from 'AAA' to ‘D’ first introduced in 1924 and later adopted and licensed by S&P. Fitch Group provides a rating Corporate Finance and Public Finance and Structured Finance. Corporate Finance companies fall into one of about three major categories which the NTT Data has structured into Financial Institutions, Global Power, and Corporates (aerospace, chemicals, food & beverage, gaming, tobacco, etc.) The Fitch also places rating(s) at the corporate (issuer) level in this area of the business, which is unique to Corporate Finance. The Public Finance group is responsible for rating public debt, which consists of borrowings by governments to finance expenditures not covered by tax revenues.

Structured Finance is the newest business area of Fitch Ratings, and is made up of three major groups – Asset-Backed Securities (ABS), Commercial Mortgage Backed Securities (CMBS), and Residential Mortgage-Backed Securities (RMBS). Whereas “traditional “corporate finance institutions have been issuing bonds for the last century, the more contemporary area of structured finance has only been around since the early 1990s.

Responsibilities:

Installation and configured OBIEE 10.1.1.7 and OBIA Apps Version is 7.9.6.3. versions.

Providing support to user in order to resolve OBIEE system and application related issues.

Daily Performing check list activities monitoring / maintenance of BI Servers.

Extensive Knowledge of Merging the RPD’s from different teams.

Manage migrations across all environments.

Gathered the business requirements by interacting with the business users for the Points System.

Development of financial business critical reports as per user requests.

Modeled the Logical Layer based on the Business requirements in the Business Mapping and Modeling Layer and Developed the necessary Star Schemas.

Involved in the Metadata Designing which includes customizing like design, configure, and document logical and Physical Data Models, Presentation Layer the repository according to the business requirements.

Created Oracle BI Repository (.rpd) at three layers Physical Layer, Business Model and Mapping Layer & Presentation Layer).

Created new dashboards/reports and made recommendations to report layout with reference to table, narrative, pivot, chart views in Presentation Services and embedded them into new/existing dashboards pages as required by the project.

Unit testing for the Involved in Finance modules to help better organize and quick decision making. The goal of the project was to upgrade the existing functionality with the new OBIEE 11g capabilities and also developing new functionality in addition to the existing one.

Provided to Training to the business users on OBIEE Answers and Dashboards and educating technical super users and administrators on repository and web catalog migrations procedures with OBIEE Best Practices.

Created users and application roles to implement object and data level securities.

Created presentation, repository and session variables to meet the user requirements.

Created Hierarchies for the drill down functionality.

Migrated the Catalog and repository from one environment to the other.

Tracking the ETL Mappings & trouble shooting and identify the issue/problem occurred and fix the issue’s and rerun the DAC to load the data into DDW. Handling the OBIEE 11g reports migration and issues.

Support and handling the new enhancements as per end user request.

IAS (Investment Advisory Services), CITI Bank, New Jersey, USA.

Feb 2010 to Jan2012.

Role: Sr. OBIEE Developer.

Environment: OBIA Apps Version is 7.9.6.2(OBIEE 10.1.3.4.1, Informatica Version 8.6, DAC Version is 10.1.3.4.1), Source System is EBS (R1212), Oracle DB 11g, Red Hat Linux.

Investment Advisory Services is a client oriented group from CITI. This project involves in transform, enhance, and load data provided by different service providers and clients. Where majority of the processing is done with this layer can be used to generate the Operational reports with the Entity Relationships between the tables as explained in the Physical diagram. Operational Layer is used an integration layer platform for data from various source systems which can be used for Operational Reporting purpose. Normalized tables are generated from the data model. These normalized tables are combined into a form of physical design that can be described as lightly normalized design.

Responsibilities:

Gathered the business requirements by interacting with the business users for the Points System.

Involved in rationalize and identify report and KPI requirements and develop in respective platforms.

Designed and Built Oracle BIEE Administration tool Repository(rpd) at 3 layers i.e., Physical Layer (connecting Data sources & import schema), Business Model / data mapping (create Logical tables & data source mapping) and Presentation Layer level (create presentation catalogs), create presentation folders, test and validate the model

Expert in cache management, Repository migration, data level and object level security in OBIEE.

Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector.

Created dashboards with global prompts, column selectors, navigation, and automatic drill-down.

Involved in testing the reports on all data sources.

Worked with Cache Manager to improve performance.

Created View, Aggregate Table and Indexes to improve performance.

Performed Unit Testing by comparing the data in OBIEE.

Handling the issues with respect to Analytics, Informatica and DAC by 24/7.OBIEE Reports are tested through HP load runner (which is tool in HP QC).

Manage Tickets raised in Service center (Internal Server which was developed by Peregrine Systems, Inc.).

Support and handling the new enhancements as per end user request.

Provided the sample reports to business users to signoff for new requirements.

DCP Midstream Partners, CO, USA.

Mar 2009 to Jan 2010.

Role: Sr. OBIEE Developer.

Environment: OBIEE 10.1.3.4.1, Informatica 8.6, DAC 10g, DAC Version 10.1.3.4.1, Oracle Database 10.1.3.4.1, Source System is EBS (R1212) on an 11.2.0.2 Oracle Database. windows server 2000.

DCP Midstream Partners, LP is a midstream master limited partnership formed by DCP midstream, LLC, to own, operate and to continue to broaden our portfolio of complementary midstream assets. The Partnership is engaged in all stages of the midstream business for both natural gas and natural gas liquids. This project involved to Development of reports in OBIA (7.9.6.3) application which included user requests like financial analytics. All the reports development has been developed in OBIEE Dashboard level and BI publisher.

Responsibilities:

Gathered the business requirements by interacting with the business users for the Points System.

Development of financial business critical reports as per user requests.

Modeled the Logical Layer based on the Business requirements in the Business Mapping and Modeling Layer and Developed the necessary Star Schemas.

Involved in setting up usage tracking in Oracle BI Enterprise Edition with the Direct Insert Option (By importing the S_NQ_ACCT table into the repository).

The dashboards provided instant insight for Organization’s business by providing them with relevant and timely information, allowing executives to instantly identify and apply appropriate check points to improve their efficiency.

Developed and debugged many Dynamic / Interactive Dashboards /Reports with different Analytics Views, drill-down & drill-across capabilities, Contextual Navigation, Guided Analytics, roles & web groups, and Alerts using Presentation Services Developed and Debugged Dashboards /Reports with different analytics views (Pivot table, Chart, Tabular and View Selector), Alerts, Guided Navigation and Dynamic /Interactive Dashboards with drill down capabilities using global and local filters.

Developed Dimensional Hierarchies for Drill Down, Level Based Measures and Time Series Functions (AGO and TODATE functions) based on the Requirements.

Extensively used presentation variables to develop the logic for the reports.

Implemented the variables in the repository.

Implemented Security by creating roles & web groups, checks with External tables and LDAP.

Testing the repository by using various techniques for yielding the correct results or not. Performed the regression testing on the Subject areas, dashboards and validated the build in production environment.

Generating Adhoc reports using Oracle Answers by applying filters and prompts and developed customized reports from analytics and used BI Publisher tool to generate the pixel perfect reports based user criteria.

Handling the issues with respect to Analytics, Informatica and DAC by 24/7.OBIEE Reports are tested through HP load runner (which is tool in HP QC).

Manage Tickets raised in Service center (Internal Server which was developed by Peregrine Systems, Inc.).

Support and handling the new enhancements as per end user request.

Balfour Beatty, UK

Mar 2008 to Feb 2009.

Role: Sr. OBIEE Developer.

Environment: OBIEE 10.1.3.4.1, Informatica Version 8.6, DAC Version is 10.1.3.4.1,Source System is EBS (R12) on an 11.2.0.2 Oracle Database, Data Warehouse Database is Oracle 11.2.0.2.

The Many of BB systems use complex or outdated business systems and different processes to support important day-to-day activities such as HR, Payroll, Finance, Procurement and Project accounting to increase effectiveness OBIEE reports has been developed and these reports supports Managers and supervisors with the annual pay determination process of BB employees worldwide.

Responsibilities:

Worked with Business representatives for gathering the reports and dashboards requirements and to define business and functional specifications.

Involved in requirement gather which include tasks like understand the EBS functionalities, user related queries & application flexibility and reports development which comes under end to end process.

Designed and Built Oracle BIEE Repository (RPD) at 3 layers i.e., Physical Layer (connecting Data sources & import schema), Business Model / data mapping (create Logical tables & data source mapping) and Presentation Layer level (create presentation catalogs), create presentation folders, test and validate the model.

Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector.

Customized Oracle BIEE 10.1.3.4.1 Metadata Repository (.rpd) using OBIEE Admin Tool by importing some of the required objects with integrity constraints into Physical Layer.

Handling the issues with respect to Analytics, Informatica and DAC

Involved in the Data Model Designing which includes customizing the repository (RPD) according to the business requirements

Involved in Migration of the catalog objects from Dev to Test and test to Production(Final release will be done UAT pass)

Involved in cache management, creating aggregate tables etc.

Developed many reports with different Analytics views (drill-down, pivot table, chart, and column selector). Implemented dynamic dashboard prompts & filters to zoom into particular segments of the business in a performance-optimized manner.

Created session & repository variables and Implemented Guided Navigation to link reports in the OBIEE front end using OBI Administration Tool.

Performed Administrative tasks like security privileges, rpd deployment and

Contact this candidate