- Overall 7.5 years of Professional experience.
- 6+ Years of experience in obiee development.
- 6+ Months of experience in Oralce Cloud Analytics, Preparing Data Models, Data Massaging, Creating Modules & Reports.
- Working in the field of Information Technology on Oracle BIEE Analytics, Design and Development for BI Systems on Oracle database with UNIX Environment for last 6 Years .
- 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 .
- 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 ETL load monitoring using Dac, Informatica and data sync.
- Experience in gathering requirement’s and analyzing the requirement’s for developing rpd and report creation.
- 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.
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.
Confidential, Grafton, WI
Environment: Oracle 12C, OBIEE 11g, Informatica 9.2 on AIX Power system 64 bit 6.1, OAC
- I hereby declared that all the information furnished above is true to the best of my Knowledge.