PROFESSIONAL SUMMARY:

• Overall 5years of Professional experience.
• Working in the field of Information Technology on Oracle BIEE Analysis, Design and Development for BI Systems, Oracle database with UNIX Environment for last 5 Years .
• Experience in working Oracle Analytics Cloud and Datasync tool
• Extensive experience on script Development & Testing of Load/Performance on OBIEE 11g by JMeter.
• Developed different layers of Admin Tool (Physical, Business and Presentation Layer).
• Excellent working Knowledge in development of OBIEE including Oracle BI Answers, Oracle BI Delivers, Oracle BI Interactive dashboards, Oracle BI Administration tool .
• Strong background in RDBMS (Oracle) and Data warehousing concepts.
• Good knowledge of SQL with the experience in constructing the tables, synonyms and views.
• Good knowledge in Star, Snowflake schemas.
• Real Time experience in Creating Dimensional Hierarchies, Level Based Measures. Time series Functions, Initialization Blocks and Variables.
• Real Time experience in aggregate navigation, level Based measures in Business Model, logical and physical column, opaque view table.
• Real Time experience in cache Management .
• Real Time experience in Webcat Migration .
• Experienced in developing Write Back Reports .
• Experience in Cache Management - manual and through event pooling table.
• Experienced in setting up & using MUD environment.
• Proficient in working on WebLogic Admin Console and Enterprise manager and having in depth knowledge on the Oracle Business Analytics warehouse.
• Worked in Supply chain and Order Management analytics.
• Worked on security privileges for subject area and dashboards according to user requirements.
• Real Time exposure to connection pools creation, physical tables, defined joins and implemented authorizations in the physical layer of the repository
• Hands on experience in different kinds of report development (pivots, charts, tabular)
• Hands on experience in Production load monitoring using (Dac and Informatica)
• Experience in analyzing the report specifications.
• Experience in leading multiple projects executing onsite/offshore model and provide optimum solutions
• Excellent presentation skills and ability to communicate with stakeholders, organizational skills, outgoing personality, Self-motivated, hardworking, ability to work independently or cooperatively with end-users and different teams of IT organizations.

TECHNICAL SKILLS:

BI Tools: OBIEE 10g,11g,12c

ETL Tools: Informatica Power Center, DataSync

Performance Testing tool: JMeter with Apache

RDBMS: Oracle 10g,11g,12c

Database Language: SQL

Operating Systems: Windows and UNIX.

Programming Languages: C, C++

Others: Toad for Oracle 9 & 12, MS Word, MS Excel.

PROFESSIONAL EXPERIENCE:

Confidential, Hartsville, South Carolina

Environment: Microsoft SQL Server database, OBIEE 11g on Windows 2008 server

Responsibilities:

• Created different types of Customized test plans and script with JMeter.
• Carry out Load / Performance testing with JMeter.
• Worked on Agent creation.
• Document all the Load testing results and findings.
• Present the results and finding to Confidential BI Team.

Confidential

Environment: Oracle 11g, OBIEE 11g, Informatica 9.2 on AIX Power system 64 bit 6.1

Responsibilities:

• Analyzing business requirements.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Created different types of Customized Reports (Drilldown, Aggregation) to meet client requirements.
• Created business reports using OBIEE Answers as per requirements.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Developed custom reports/Ad-hoc queries using OBIEE Answers and assigned them to application specific dashboards.
• Worked on Oracle BI Answers to build Interactive Dashboards with drill-down capabilities.
• Developed reports using dashboard prompts.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Having good communication skills while interacting with clients and Business users.

Confidential

Environment: Oracle 11g, OBIEE 11g, Informatica 9.2 on AIX Power system 64 bit 6.1

Responsibilities:

• Analyzing business requirements.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Created different types of Customized Reports (Drilldown, Aggregation) to meet client requirements.
• Created business reports using OBIEE Answers as per requirements.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Developed custom reports/Ad-hoc queries using OBIEE Answers and assigned them to application specific dashboards.
• Worked on Oracle BI Answers to build Interactive Dashboards with drill-down capabilities.
• Developed reports using dashboard prompts.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Having good communication skills while interacting with clients and Business users.

Confidential

Environment: Oracle 11g, OBIEE 11g, Informatica 9.2 on AIX Power system 64 bit 6.1

Responsibilities:

• Extensively worked on analyzing Source query.
• Extensively worked on Regression testing and re-testing of multiple Dashboards.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Created different types of Customized Reports (Drilldown, Aggregation) to meet new requirements.
• Worked on RPD changes.
• Created business reports using OBIEE Answers as per requirements.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Developed custom reports/Ad-hoc queries using OBIEE Answers and assigned them to application specific dashboards.
• Worked on Oracle BI Answers to build Interactive Dashboards with drill-down capabilities.
• Developed reports using dashboard prompts.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Having good communication skills while interacting with clients and Business users.

Confidential, WI

Environment: Microsoft SQL Server database, OBIEE 11g on Windows 2008 server

Responsibilities:

• Analyzing business requirements.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Created different types of Customized Reports (Drilldown, Aggregation) to meet client requirements.
• Created business reports using OBIEE Answers as per requirements.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates
• Worked on RPD changes for new reports.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Developed custom reports/Ad-hoc queries using OBIEE Answers and assigned them to application specific dashboards.
• Worked on Oracle BI Answers to build Interactive Dashboards with drill-down capabilities.
• Developed reports using dashboard prompts.

Confidential, Grafton, WI

Environment: OBIEE 12c, Informatica 9.5.1, DAC on Oracle DB 12c

Responsibilities:

• OBIEE Production Support
• Gathering the design specifications for new subject area.
• Creation of Analytic reports based on the design document.
• Design and customization of Siebel Answers, Reports and Dashboards.
• Defining Multiple Dimension Hierarchies for the Dimension Logical Table.
• Creating Presentation Catalogs with measures from Multiple Fact Tables.
• Making RPD changes for new subject area.
• Creating the Dashboard and Report level prompts.
• Implemented measures & dimensions and organized the data into related subject areas.
• Configured dashboards, metadata objects and report level security to set up position based functional dashboard access.
• Using OBIEE Administration tool to develop and enhance Meta data to build Business Model and established relationships.
• Involved in Organizing Presentation layer in a format that is easy for end users to use as basis for reporting.
• Testing-unit testing and integration testing for ongoing projects.

Confidential

Environment: Oracle 11g, OBIEE 11g, Informatica 9.2 on AIX Power system 64 bit 6.1, OAC

Responsibilities:

• Gathering the design specifications for the migration.
• Creation of Analytic reports in OAC based on existing environment.
• Sync data to cloud engine using Datasync tool.
• Creating Models in OAC.
• Creating the Dashboard and Report level prompts.
• Implemented measures & dimensions and organized the data into related subject areas.