Project Oracle

Technical Summary

Having Over all * years of experience, out of this 4 years in OBIEE as Consulting/ Quality Analyst.

Extensive Experience in Software Development Life Cycle (SDLC) implementation: gathering and analysis of Business and System Requirements, Development, Implementation, Support, and Testing.

Experience interacting with Business users and documenting high level requirements, design and detailed level design documents.

Proficient in creating and managing Dashboards, Reports and Answers

Proficient and hands on Experience of using in OBIEE Admin Tool for SCM industry.

Experienced in configuring Request with drill-down capabilities.

Experience in Preparation of Level based Measurements.

Expertize in preparation calculation measures by using Physical and Logical data.

Hands on Experience with Cache setup and way of Proceedings in BI Tool.

Work experience with multiple data sources.

Changing the existing reports views, if required and created different views for different views.

Creating i-bots for BI delivers

Fully conversant with Life Cycle Methodologies from conceptualization to implementation and maintenance

Extensive Experience in Preparation of Business Analysis documents with respect Customer requirements.

Supported experience as Techno functional consultant

Self-starter and team player with excellent communication, interpersonal and analytical skills.

Having Proficient skills in Preparation of Business documents, Business Requirements, Change Request Analysis.

Technical Skills

BI : Oracle Business Intelligence Enterprise Edition (OBIEE)

10.1.3.4, 11.1.1.5

RDBMS : Oracle 9i/8.0/7.x, MS SQL Server 2000/7.0, Oracle 10g,11g

Operating Systems : Windows 2000, XP, NT, Unix, MS DOS

MS Suite : Word, Excel, PowerPoint, Access.

Test Tools : Test Director 8.0, Test Partner,

Scripting Languages : VB Script, SQL,

Educational Details :-

Bachelor of Engineering in ECE From Jawaharlal Nehru Technological University,Hyderabad

in April 2005 .

Project Details :-

Client 1:- PETCO EMBARK

Role Oracle BI Consultant with IT Analyst.

Location TATA CONSULTING SERVICES(TCS)

Duration Mar’2012- To till date

Environment Oracle BI EE (11.1.1.5), Windows 2000/2003, Oracle 10g,11g

Project Name EMBARK

Project: - Metadata & Reports Developer for the PETCO EMBARK .Petco is a leading pet specialty retailer that provides the products, services and advice that make it easier for our customers to be great pet parents.

Responsibilities:

Extracting business logic, Identifying Entities and identifying from the existing data .

Create groups in the repository and add users to the groups and grant privileges.

Creating dashboard for the reports.

Involved in implementing different views of report such as Pivot table, Titles, Graph, Filters.

Customized all the dashboards, reports to look and feel as per the business requirements using different analytical views.

Project Details :-

Client 2 :- AXA UK

Role Oracle BI Consultant with IT Analyst.

Location TATA CONSULTING SERVICES(TCS)

Duration Jan’2012-Feb’2012

Environment Oracle BI EE (11.1.1.5), Windows 2000/2003, Oracle 10g,11g

Project Name SIEBEL UPGRADE

Project: - AXA insurance, health care, investment, pension, life insurance and life insurance. Offering both personal and business company products to suit all needs.

Responsibilities:

Upgraded the RPD from Siebel 7 to 10 g.

Created various drill report in 10g environment.

Worked on new feature in 10g such as Sliders in reports, Hierarchies created in RPD and are used in Reports, Start and Stopping the services.

Mapped different data sources to the Physical Layer and created the Business Model and Mapping Layer.

Designed Hierarchies, Dimensions, and Aggregates.

Define appropriate joins, calculations, dimensions and measures in the repository.

Created and customized various Reports and Dashboards for various user groups.

Designed various reports as per the requirements for user interface design like Drill Down, Pivot, Break down Reports, Narrative reports in Answers.

Created reports with different views (Compound, Chart, Table, Pivot and Narrative).

Developed and scheduled iBots for delivering personalized reports to users on time.

Secured Dashboards and Reports by defining user roles.

Implemented OBIEE security at the data and object levels.

Created prompts in OBIEE to navigate on maps, passing parameters between

Summary and detailed Reports

Project Details :-

Client 3 :- ROYAL BANK OF SCOTLAND (RBS)

Role Oracle BI Consultant with IT Analyst.

Location TATA CONSULTING SERVICES(TCS)

Duration Sep’2011-Dec’2011

Environment Oracle BI EE (11.1.1.5), Windows 2000/2003, Oracle 10g,11g

Project Name NEXTGEN

Project: - The Royal Bank of Scotland is one of the retail banking subsidiaries of the The Royal Bank of Scotland Group plc.Our project mainly deals with the generating of daily, weekly, monthly reports by executing batch run using Informatica work flows manager.

Responsibilities:

Giving support for OBIEE implementation

Executing batches using Informatica work flow manager

Project Details :-

Client 4 :- STANDARD CHARTERED BANK(SCB)

Role Oracle BI Consultant with IT Analyst.

Location TATA CONSULTING SERVICES(TCS)

Duration Mar’2011-Aug’2011

Environment Oracle BI EE (11.1.1.5), Windows 2000/2003, Oracle 10g,11g

Project Name STORM II, operational Reporting

Project: - Metadata & Reports Developer for the STANDARD CHARTERED BANK(SCB) under APAC India Hub.The implementation was on OBIEE 11g . Generating reports and dash boards based on the data provided by the BanCs.

Responsibilities:

Extracting business logic, Identifying Entities and identifying from the existing data .

Created functional specification,Report Specifications for the reporting purpose and configuring Interactive Dashboards with drill-down and drill-across capabilities,creating reports and prompts in answers.

Create groups in the repository and add users to the groups and grant privileges.

Creating dashboard and links for the reports.

Involved in implementing different views of report such as Pivot table, Titles, Graph, Filters.

Customized all the dashboards, reports to look and feel as per the business requirements using different analytical views.

Peer review of code, testing, Monitoring NQS Query and tuning reports.

Responsible for post production support.

Analysis of PR documents and make a Business Requirement documents in defined format.

Client 5 :- BRITISH TELECOM(BT)

Role Oracle BI Consultant with IT Analyst.

Location TATA CONSULTING SERVICES(TCS)

Duration Jan’2011 – Feb’2011

Environment Oracle BI EE (10.1.3.4), Windows 2000/2003, Oracle 10g

Project Name BSM.EMP.Non-UK_FR_BAU.Off.Q4

Responsibilities:

Maintaining & support for existing RPD( Repository )

Client 6 :- Fedex Trade Newtwork (FTN)

Role Oracle BI Consultant with Quality Analyst.

Location RCI (DRDO) HYD

Duration April’2008-Dec’2010

Environment Oracle BI EE (10.1.3.4), Windows 2000/2003, Oracle 10g

Project Name eTrans

Project: - Metadata & Reports Developer for the Fedex Trade Network (FTN) business implementation. The implementation was on Siebel Analytics which is used to replace their current system [Excel Based reporting] from other system.. This has provided a single point repository which contains a complete portfolio of the company’s business sales, Financial Transactions, Vendor Orders, for specific and regular customers across the Eroup and It provided a clean interface for Export and Import Orders..

Responsibilities:

Extracting business logic, Identifying Entities and identifying measures/dimension out from the existing data and create new Logical Columns,

Creating Repository and designing physical and logical star schema.

Creating hierarchy, formula, measures etc in BMM layer.

Created logical tables and assigned levels and custom aggregation rules.

Implemented Security management for users, groups and web-groups using the various authentication systems.

Design Schema/Diagrams using Fact, Dimensions, Physical, Logical and Alias tables.

Applied Object level security,Implemented Delivers.

Created Repository Varaibles and Session Varibles.

Configuring Interactive Dashboards with drill-down and drill-across capabilities,

Creating reports and prompts in answers.

Create groups in the repository and add users to the groups and grant privileges.

Creating dashboard and links for the reports.

Involved in implementing different views of report such as Pivot table, Titles, Graph, Filters.

Customized all the dashboards, reports to look and feel as per the business requirements

using different analytical views.

Peer review of code, testing, Monitoring NQS Query and tuning reports.

Responsible for post production support.

Perform the UAT before moved it to Production.

Analysis of PR documents and make a Business Requirement documents in defined format.

Client 7 :- Pacific International Lines (PIL)

Role Quality Analyst / Trainee BI Consultant

Location RCI (DRDO) HYD

Duration June’2007 – April ’2008

Project Name i-Shipping

Project :- I-shipping was an enterprise Project which provides the Transportation services for the shipping modes of Transport facilities only. This Project includes the Updating of Client requirements like Quotation details, Voyages Maintenance, booking details, Equipment maintenance, charges details and call closure Operations. Maintaining the Booking status different stages of the shipping transportation and updated including with B/L maintenance. Track systems helps to develop a management strategy in order to increase the Sales Orders, effectiveness and thereby enhancing their business index which in turn improves the overall ROI of China Shipping and PIL shipping. .

Responsibilities:

Involved in Understanding the Requirements and Preparing Design Documents.

Extensively involved in creating logical and physical joins using RPD.

Work extensively with Physical Layer, Business Model& Mapping Layer and Presentation Layer.

CDeveloped Calculated measures, level based measures and dimension hierarchies in the Business Model and Mapping Layer .

Web Catalog Objects (Dashboards, Pages, Filters, Reports)

Generated different kinds of reports using Siebel Answers and assigning them to application specific dashboards.

Manage day-to-day repository, Scheduler

Implemented Dashboard prompts and Filters for limiting the number of records

Performed Pre and post implementation testing of Dashboard, Answers and validating

Repository.

Contact this candidate