TECHNICAL SKILLS:

Key Skills: Oracle Business Intelligence Enterprise Edition (OBIEE), OBIEE 11g, OBIEE 10g, BI Apps (Oracle Certified), Oracle Discover, Oracle Discoverer Plus, SQL, Crystal Reports, Business Objects, Requirements, Documentation, Testing, HP Quality Center, JIRA, Business Intelligence, DMHRSi

PROFESSIONAL EXPERIENCE:

Confidential

OBIEE/OBIA Developer

Responsibilities:

• Duties and Responsibilities included; building new reports, troubleshooting existing reports.
• Requirement Gathering
• Develop Technical Design Documents (TDD)
• Unit Testing

Environment: OBIA 7.9.4, Financial Analytics, OBIEE 11.1.1.7, PeopleSoft

Confidential

OBIEE Architect

Responsibilities:

• Responsibilities included Configuring Delivers in Enterprise Manager.
• Capturing step by step guide on Configuring Delivers and enabling MS Plug In and iPad.

Environment: OBIA 7.9.6.4, OBIEE 11.1.1.7.1, EBS R12

Confidential

OBIEE/OBIA Developer/Tester

Responsibilities:

• Duties and Responsibilities included, testing and troubleshooting the financial reports.
• Setting up security for the new users
• Creating new Subject Area “Customer Revenue”

Environment: OBIA 7.9.4, OBIEE 11.1.1.7, PeopleSoft.

Confidential

OBIA Lead

Responsibilities:

• Duties and Responsibilities included Requirements Analysis, and Technical Design.
• Developed detail TDD’s for HR, SCM and Finance.
• Worked closely with the PeopleSoft team and the Business Users to understand the Metrics and converting them into OBIEE.
• Lead a team of 4 from Confidential China and Confidential India to complete the deliverables and submitted on time.

Environment: OBIA 7.9.4, OBIEE 11.1.1.7, PeopleSoft.

Confidential

OBIEE Report Lead

Responsibilities:

• Duties and Responsibilities included Requirements Analysis, Design, Development, Testing and providing .
• Work closely with functional, chain management and other business groups to identify, analyze business requirements.
• Develop detail technical requirement based on business requirements.
• Developed Reports and Dashboards
• Used Stack Chart, Bart Chart, View Selectors, Column Selectors, Static Text, Narrative Views, Guided navigations, and links for several summary and detailed dashboards.
• Created Answers reports using various analytics views like Table, Pivot tables, Charts, Column Selectors, View Selectors, Narrative and Static text.
• Created new Dashboards according to best practices by using Columns, Sections and Guided Navigation
• Managed/Administered OBIEE web catalog using Catalog Manager
• Worked in End to End construction of the BI model from repository to reports development
• Led the testing team of 2 testers ensuring all test phases are completed in a timely manner and that quality deliverables are submitted to the client
• Responsible for creating project wide testing strategy, testing plan, and testing schedule
• Analyzed the requirements, authored 50 plus test scripts and scenarios for System Integration Testing (SIT), Quality Assurance (QA) and User Acceptance Testing (UAT)
• Oversaw the team execute test cases, generating and logging defects in JIRA, triaging with technical team leas and client liaison
• Provide to the users on using the dashboards and creating ad - hoc reports using Answers
• Accessing and editing Canned reports and Dashboards
• Executing groupings, Action Links and inserting Case statements

Environment: Oracle, OBIEE 10g/11g, JIRS, SQL Developer

Confidential

OBIEE 10g/11g Report Developer

Responsibilities:

• Used technical and functional to drive a successful implementation of Integrated Reporting R1 and R2
• Active in all stages of the project lifecycle, from system analysis, business, functional, technical requirements gathering, development, testing and deployment.
• Created complex business intelligence solutions using the OBIEE suite of tools
• Expertise in complex report and charts using BI Publisher from multiple disparate systems with integration to OBIEE to meet challenging requirements
• Development of interactive flash-based drillable charts such as bar-charts, Gauges etc…
• Maintain, develop and test Physical Layer, Business Layer and Presentation Layer of OBIEE
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository
• Create dimensional hierarchies
• Write several initialization blocks, repository variables, session variables and presentation variables and request variables
• Performed Operation and Management (O&M) duties of deploying, merging, and maintaining projects system wide.
• Wrote custom PL/SQL functions to handle more complicated client request.
• Mentor junior members concerning development techniques, skills, and best practices
• Set up OBIEE instances and merged environments
• Used advanced OBIEE techniques such as guided navigation, custom sql, drilling to meet client needs
• Interface with clients on change request and report modification
• Leveraged knowledge of Data warehouse, Oracle DB 11g, and OBIEE technologies.
• Produce and present demonstrations of the software system to stakeholders as well as tutorial sessions to users
• Involved in several administrative roles including setting up users and roles and permissions, managing catalogs
• Managed security privileges for each subject area and dashboards according to user requirements ed the Outstanding Performance for work on projectRequirements
• Collaborated with different functional area of the organization to determine how to best leverage OBIEE to assist their reporting needs
• Designed and developed Functional Design Document to be used by developers to create reports
• Created mockup reports and dashboard for review by business usersTesting
• Generating and implementing templates for Test Plan, Test Cases, and Test Scripts
• Extensively used SQL Queries to verify data in the back-end database
• Performed User Acceptance Testing (UAT) and Back-end Testing
• Executed Regression Testing by repeated execution of automated test scripts to identify errors in each modified build
• Used HP Quality Center for Performance and Load Testing

Environment: Oracle, OBIEE 10g/11g, BI Publisher, Oracle Administration, Oracle Catalog Manager, SQL Developer, HP Quality Center

Confidential

OBIEE Report Developer

Responsibilities:

• Used Oracle BI Publisher 10g and 11g to have a successful development of two Safety reports.
• Converted 10g BI Publisher reports to 11g Publisher.
• Created BI Publisher reports using Microsoft word plug in to design report templates.
• Implemented multiple logical conditions in a single RTF template.
• Created data set and XML output format so developers could easily build the Word Template.

Confidential

BI Architect

Responsibilities:

• Solely responsible for entering data into DMHRSi (Defense Medical Human Resource System internet).
• Used multiple BI tools to extract data from DMHRSi to generate reports for the Stakeholders.
• The Business Intelligence solution consisted of four major applications: Business Objects XI R2, Oracle Discoverer/Discoverer Plus, OBIEE 10g and SQL server.
• Analyzed variables in Discoverer and Discoverer Plus reports to minimize the refresh time.
• Created different reports containing charts showing revenue and operating manpower in different divisions.
• Created reports on the web using Web Intelligence and distributed them to different users through info view portals.
• Was involved with client on a regular basis discussing what was required, to produce a usable finish product.

Confidential

Crystal Reports Developer

Responsibilities:

• Was solely responsible for creating Universe using Designer.
• Involved in all the Administration responsibilities; granting access to users and maintaining Central Management Console.
• Created reports on the web using Web Intelligence which were accessible by users.
• Made Changes to universes using Designer.

Confidential

Business Objects/Crystal Reports Developer

Responsibilities:

• Was solely responsible for creating Universe using Designer.
• Was responsible for maintaining Central Management Console.
• Involved in Objects Level Security, Password Settings, Data Restrictions and Row Restrictions, Disabling and Deleting Users.
• Made Changes to universes using Designer.
• Used Crystal Reports to develop reports according to User needs.
• Set Datasource Location to switch to different schemas to make reports run faster.
• Analyzed variables in reports to minimize the refresh time.
• Involved in all phases of migration from Business Objects Enterprise 6.5 to XI R3.
• Developed critical reports like drill down, Slice and Dice, Master/detail for analysis of parts benefits and headcount.
• Created complex reports using the multiple data providers and synchronized the data providers by linking the common objects.
• Created complicated reports including sub-reports, graphical reports, formula based reports according to user requirements.