Principal OBIEE Consultant
- Worked on four data marts and transactional systems. This involved analyzing requirements (user stories), identifying transactional database / data marts, validating data mart design and ETL mappings logic, creating mappings from data mart for the report, creating repository (rpd), reports and dashboard, testing those reports, unit testing, regression testing and documentation.
- Worked on OBIEE 11g up gradation project.
- Created RPD, dashboards, reports, performed testing and deployment related activities.
- Created reports using BI Publisher with multiple data sources. Created presentations and demos for internal training to the team. These reports were created using Federated data from MSSQL Server databases and flat files.
- Worked on multiple lean agile and configuration releases, creating documentations for each release, presently following scrum methodology.
- User Support, resolving user issues.
at this job
- Created queries using add Command object in Crystal Reports XI.
- Created linked, unlinked and on-demand sub reports.
- Created various Cross-tab, Master-detail, Tabular and Summary reports.
- Created new universe and also modified existing universe for creating WebI reports.
- Created Crystal Reports using Standard, Summary, Cross Tabs, SQL, Command Objects, Selection Criteria, grouping, sub reports.
at this job
- Developed business models conforming to functional mapping, defined logical and complex joins for the dimension tables.
- Used Oracle BI Analytics for generating Sales reports, which provides web-based reports for executives, managements and individuals.
- Extensively used BI Administration Tool for customizing and modifying the Physical, Business and Presentation layers of metadata repository.
- Created connection pools to retrieve data from Oracle Database.
- Specified aggregate levels for each source and created dimension sources for each level of aggregates.
- Created custom mappings to accommodate customized fields. Utilized Intelligent Dashboards, Oracle BI Analysis, and BI Publisher for reporting requirements.
- Worked Extensively on Oracle BI Analysis, BI Publisher to create reports as per client requirements.
- Used Filters and provided Customized prompts appropriately for Reports performance.
- Created iBots and Delivers to send Alert messages to subscribed users.
- Migrated Reports from OBIEE10g to OBIEE11g.
at this job