Description:

Gilead Sciences, Headquartered and founded in Foster City, California, is an American biotechnology company that researches, develops and commercializes drugs. The company focuses primarily on antiviral drugs used in the treatment of HIV, hepatitis B, hepatitis C, and influenza, including Harvoni and Sovaldi.

Responsibilities:

• Acted as a liaison between business users and BI team to facilitate understanding of business requirements.
• Implemented security based on LDAP Authentication.
• Created security settings in OBI Administration Tool and set up groups, access privileges and query privileges and also managed security for groups in Answers.
• Interacted with Dev Team, Testing Team on day to day activities on daily basis.
• Updating the status to Project Manager and keeping the Production Environment up and running.
• Closely involved with everyone to achieve miles stones and during deliverables.
• Created Requirements Mapping Document to trace requirements in BI implementation.
• Developed test cases and performed Unit Testing and Integration Testing of the Repository and Web Catalogs.
• Provided guidance and support to end users during the implementation and in production.
• Address system failures, incidents, tasks and change requests.
• User administration such as adding or removing users, modifying group membership or validating user settings.
• Handling BIAR requests and process on time to give project access and folder for users
• Subscribing the reports for users mail Id’s and scheduling the reports for user requests
• Monitoring the narrowcast services and delivering the schedules to user emails on time

• Created Requirements Mapping Document to trace requirements in BI implementation.
• Defined and created Initialization Blocks, Repository and Session Variables for generating filters and defining security.
• Implemented security based on LDAP Authentication.
• Developed metadata repository using OBI Administration tool in Physical, Business Model and Mapping, and Presentation Layer.
• Created New Logical Columns, Dimensional Hierarchy, Calculated Measures, and aggregate mappings in the BMM layer as per the business requirements.
• Developed Time Series Objects using Ago and To Date functions for time series comparisons.
• Designed and developed various Interactive Dashboards and reports with drilldowns, guided navigation, filters, and prompts.
• Created various session and repository variables and initialized them in the Initialization Blocks to change metadata dynamically as the environment changes.
• Developed test cases and performed Unit Testing and Integration Testing of the Repository and Web Catalogs.

Provided guidance and support to end users during the implementation and in production

Description:

Subaru Of America is the United States-based distributor of Subaru's brand vehicles, a subsidiary of Fuji Heavy Industries of Japan. The company markets and distributes Subaru Symmetrical All-Wheel Drive vehicles, parts and accessories through a network with approximately 600 dealers throughout the United States

Responsibilities:

• Worked during the whole life cycle of the project from requirements gathering to deployment.
• Configured BI Scheduler and Oracle BI Delivers- iBots to deliver alerts and publish updated content to subscribed users as per the schedules and requirements.
• Worked towards the Performance Tuning of Dashboards and Reports with Business Analysts and DBAs.
• Implemented security based on LDAP Authentication.
• Used various cache management techniques for performance tuning including configuring, defining cache parameters, cache persistence time, cache seeding and purging, and event polling.
• Created security settings in OBI Administration Tool and set up groups, access privileges and query privileges and also managed security for groups in Answers.
• Integrated BI Publisher with OBI to build reports in word, excel and doc format.
• Created various templates, reports, and prompts in BI Publisher.

Description:

Polycom is unarguably the number when it comes to Unified Communication. It is chosen ahead of others for solutions that enable their geographically dispersed workforces to communicate and collaborate more effectively and productively over distances. Using Polycom telepresence, video, and voice solutions and services, people connect and collaborate from their desktops, meeting rooms, class rooms and mobile settings. It is used to gain a fast return on their investment as their teams easily collaborate "face to face" wherever they are & also cut the time, cost, and carbon emissions associated with gathering the right people in one place to solve problems.

Responsibilities:

• Interacted with business representatives and business analysts for requirements analysis and to define business and functional specifications.
• Analysed the Reporting Requirements and participated in the documentation of Business Requirements.
• Developed Oracle BI Metadata repository using BI Administration tool.
• Developed interactive Dashboards and Reports in Oracle BI Answers as per the reporting specifications.
• Defined and created Initialization Blocks, Repository and Session Variables for generating filters and defining security.
• Created Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBI business model & mapping layer.
• Developed measure for time comparison using time functions, To Date and Ago.
• Used Filters and provided Prompts appropriately to make interactive reports and to avoid excessive data showing up on Reports.

• Customized/Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Performed the Performance Tuning of Dashboards and Reports and made required changes to repository and database in consultation with DBA.
• Implemented security based on LDAP Authentication.
• Configured Measures in the Business Model Layer and mapped to multiple logical table sources.
• Created schedulers and developed iBots to deliver reports and dashboards to the subscribers as per the schedules and alerts.
• Created report prototypes and presented them to users to get approval.
• Attended weekly meetings with BA and Stakeholders for project status updates.
• Performed unit and integration testing of reports and dashboards.

Description :

Verizon is an American telecommunications company which offers wireless products and services. It is a wholly owned subsidiary of Verizon Communications. Verizon Wireless is the largest wireless telecommunications provider in the United States.

Responsibilities:

• Preparing the technical specification document for reports.
• Customized activities as per user requirements
• Worked on vanilla rpd and modified it according to requirements.
• Created multiple interactive Dashboards and assigned respective security model.
• Worked on presentation variables to work on TopN functions.
• Build Repository at 3 layers Physical Layer (connecting Data sources & import schema), Business Model & data mapping (create Logical tables & data source mapping) & Presentation layer level (create presentation catalogs).
• Developing multiple Dimensions (Drill-Down Hierarchies) & Measure objects in Business Model Layer.
• Created logical joins between fact and dimension tables in business model layer