CAREER SUMMARY:

• Having over 7 years of experience in TCS as OBIEE &OBIA Consultant and worked in Travel Transport & Hospitality, Hi - Tech, Manufacturing, Telecom and Banking domain.
• Good expertise in designing and building RPD in Siebel Analytics & OBIEE 11g.
• Good working experience in designing and building reports and dashboards.
• Excellent knowledge and grasp of repository Development, Oracle BI Answers, Oracle BI Interactive Dashboards, Oracle BI Delivers, Oracle BI Publisher.
• Experience in maintaining and Supporting core OBIEE applications dashboards, repository maintenance and BI Answers.
• Proven experience in implementing Oracle BI Applications for Finance, Procurement & Spend, Human Resource Analytics, Sales Analytics, Service Analytics
• In-depth knowledge of Data modelling and Datawarehousing.
• Good Knowledge in Marketing Analytics and Business Objects.
• Working experience on oracle 10g,11g database.
• Working experience on Informatica and DAC.
• Good understanding of Relational Database Management Systems.
• Good experience in developing Test Plans and Test cases using requirements and design documents while specifying Testing Overview, Approach, Strategy, Scope, Roles and Responsibilities.
• Good team player with strong interpersonal skills, communication and Problem solving skills.
• Successful in meeting the new technical challenges by fulfilling the customer requirements

TECHNICAL SKILLS:

Operating Systems: Windows 98/2000/2003 , XP

Languages: C, Core Java, Pl/Sql

Databases: ORACLE

Domain Knowledge: Logistics, Finance, Human Resource, Supply Chain

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Report Requirement Gathering and prioritizing them
• Identifying and understanding the legacy systems being used for the as-is reports
• Preparing Requirement Specification documents.
• Prepare High Level Design document
• Prepare Low Level Design document
• OBIEE Repository build and report development

Confidential

BI Report Analyst

Responsibilities:

• Report Requirement Gathering and prioritizing them
• Identifying and understanding the legacy systems being used for the as-is reports
• Preparing Requirement Specification documents.
• OOTB Sales Analytics, Service Analytics Report walkthrough to business
• Testing OOTB Service Analytics, Sales Analytics Reports
• Fit gap analysis for new requirements and identifying the level of customizations required.
• Prepare High Level Design document
• Assist the development team in understanding business process related reports

Confidential

OBIA Administrator, OBIA Consultant & OBIA Architect

Responsibilities:

• Installation of OBIEE, ODI & OBI Applications with OOTB Analytics Content
• Configuration of OBI Apps Service Analytics module.
• Demonstration of OOTB Reports to business users.
• Report Requirement Gathering for custom reports.
• Identifying and understanding the legacy systems being used for the as-is reports
• Fit gap analysis for new requirements and identifying the level of customizations required.
• Prepare High Level Design document
• Data modeling, Data mapping to source systems
• ODI Interface designing and development to extract data from EBS and other applications
• OBIEE Repository build and report development
• OOTB ETL, report objects bug fixing
• Prepare migration plan for UAT & Production Rollout
• Assist the development team in understanding business process related reports

Confidential

OBIA Administrator, OBIA Consultant & OBIA Architect

Responsibilities:

• Installation of OBIEE, ODI & OBI Applications with OOTB Analytics Content
• Configuration of OBI Apps Finance Analytics, Human Capital Management Analytics, Procurement & Spend Analytics and Supply Chain Management Analytics modules
• Demonstration of OOTB Reports to business users.
• Participate in requirement gathering sessions with Functional Consultants
• Fit gap analysis for new requirements and identifying the level of customizations required.
• Analyze all reports to come up with rationalization strategy and road map for implementation.
• Prepare High Level and Low Level Design documents
• Data modeling, Data mapping to source systems
• ODI Interface designing and development to extract data from EBS and other applications
• OBIEE Repository build and report development
• OOTB ETL, report objects bug fixing
• Prepare migration plan for UAT & Production Rollout
• Assist the team in understanding business process related implementation issues
• Issue resolution of custom ETL’s and Custom reports

Confidential

OBIA Consultant, OBIEE Consultant & OBIA Architect

Responsibilities:

• Study As-Is reporting applications
• Analyze report inventory to come up with rationalization strategy and road map for implementation
• Participate in Requirements gathering sessions
• Perform Gap Analysis of requirements against out of the box solution
• Prepare High Level and Low Level Design documents
• Data modeling, Data mapping to source systems
• Informatica mapping designs and development to extract data from EBS and other applications
• OBIEE Repository build and report development
• Verify ETL, report objects and bug fixing
• Review configuration for adherence to coding standards
• Prepare migration plan for SIT, UAT, Production Rollout
• Document design specification, migration plan road map
• Assist the team in understanding business process related implementation issues
• Issue resolution

Confidential

OBIA Administrator, OBIA Consultant, OBIEE Consultant

Responsibilities:

• Installation of OBIEE 11.1.1.7.0 on linux and applying mandatory patches
• Upgrading Weblogic Server from 10.3.5 to 10.3.6
• Install and upgrade ODI 11g Server and studio
• Install OBI Apps 11.1.1.9.1 and its related setups
• Configure domain values for Financial Analytics, Human Resource and Procurement and spend analytics in OBI Apps 11g
• Work in collaboration with Business users and internal teams
• Data loading for the respective modules using ODI and resolving related load failure issues.
• Testing the data correctness of the OOTB Dashboards and reports
• Bug fixing of the OOTB code.
• Object Level Security setup for the standard Dashboard/Reports
• SSL implementation for OBIEE 11.1.1.7
• Designing road map for Extending the OOTB objects
• Performance tuning of OBIEE 11g

Confidential

OBIA Administrator, OBIA Implementer, OBIA Technical Consultant, OBIEE Consultant

Responsibilities:

• Configuration of OBIA for Human Resource Analytics
• Customizing the styles and skins of OBIEE Screens.
• Development of Custom reports and dashboards
• OBIA Admin related activities at the time of implementing the modules
• Configuring OOTB Security features to integrate with Oracle EBS
• Training users to use the application.
• Extending the OOTB objects to meet the customer requirements in HR Analytics
• GAP analysis on custom requirements
• Advanced OBIEE Report Development Training to Users
• Performance tuning of OBIEE Application
• Enforcing best practices in repository building and Report development.
• Functional Assistance to the other vendors to understand business requirements

Confidential

OBIA Administrator, OBIA Implementer, OBIA Technical Consultant, OBIEE Developer

Responsibilities:

• Installation of OBIEE 11g, OBIA7.9.6.4, DAC11g, Informatica 9.01 hot fix2 in Unix environments.
• Configuration of OBIA for Financial Analytics and Procurement and Spend Analytics.
• Customizing the styles and skins of OBIEE Screens.
• Development of Custom reports and dashboards
• OBIA Admin related activities at the time of implementing the modules
• Configuring OOTB Security features to integrate with Oracle EBS
• Training users to use the application.
• Implementing SSL in OBIEE 11g
• Implementing Usage Accelerator Tracking in OBIEE 11g.
• Extending the OOTB objects to meet the customer requirements in Procurement & Spend Analytics
• Designing new ETL mappings & Workflows on the top of existing OOTB Informatica objects.
• Designing new DAC objects to include new ETL’s in the Execution plans
• Dimensional modeling & Building RPD for the new report requirements
• Development of new reports & Dashboards as per the Standards for new requirements given by the business.
• Deployment of new ETL(Informatica, DAC) & OBIEE Objects on the servers.
• Preparing Functional Design Documents for the custom requirements
• Preparing Tech - Design Documents for the custom requirements.
• Preparing Testing & Code Deployment documents for the new requirements
• Maintaining and Supporting the Informatica, DAC & OBIEE Applications in Production, UAT, Dev environments

Confidential

OBIA Administrator, OBIA Implementer, OBIA Developer

Responsibilities:

• Installation of OBIEE 11g, OBIA7.9.6.4, DAC11g, Informatica 9.01 hot fix2 in windows environment.
• Configuration of OBIA for Financial Analytics and Procurement and Spend Analytics.
• Gap Analysis of OOTB Reports with the Business
• Customizing the styles and skins of OBIEE Screens.
• Demonstration of all the OOTB reports to the Business
• OBIA Admin related activities at the time of implementing the modules
• Configuring OOTB Security features to integrate with Oracle EBS

Confidential

OBIEE Administrator, OBIEE Developer

Responsibilities:

• Installation of OBIEE 11g in Windows and Linux Environment.
• Installation of Informatica & DAC on windows & Linux environments.
• OBI Apps Installation and Configuration for Finance Analytics
• Gap Analysis of OOTB reports
• Interacting with business users to gather new requirements to build Enterprise datawarehouse.
• Taken part in developing Functional Design Documents.
• Created and configured Repository.
• Created Analysis and published on Dashboards.
• Created Proof of Concepts for reporting functionalities
• Customization of Styles and skins of OBIEE 11g.
• Creation of KPI's and Scorecards.
• Worked on Technical Feasibility of Complex reports.

Confidential

Developer

Responsibilities:

• Creating Reports as per the users Requirement and publishing them on dashboards.
• Configured RPD in Siebel Analytics to fulfill new requirements from the users.
• Responsible for resolution of Issues faced by Business Users.
• Reports, Dashboards and RPD maintenance.
• Creating and scheduling ibots.
• Worked to Improve the Response time of the Adhoc Queries fired by the users.
• Worked on Incident, Request and Change Management (Remedy Tool).
• Scheduling and monitoring Data loads.
• Test Case Development.
• Interact with the Business requirements and the design team and prepared the Low Level Design and High Level design Documentation.

Confidential

Trainee

Responsibilities:

• Learned Installing Business Objects XI R3.1 software on Windows Clients.
• Learned to Administer Business Objects security, domains, groups and users.
• Learned to Analyze the existing data which is there in excels and MS Access.
• Learned basics of ETL implementation.
• Learned how to create mappings in Oracle Warehouse Builder.
• Learned how to design, deploy and execute the Process flows in Oracle Warehouse Builder.
• Learned Database designing for Staging, Foundation, and Access schemas and implementing the same.
• Learned how to design Universes and to create Complex Reports.
• Learned tuning the reports for better performance by modifying the SQL code