Summary:

• Over 8 years of IT experience in delivering Business Intelligence solutions by gathering requirements, analyzing, developing, testing, deploying Business Intelligence BI applications using OBIEE/Siebel Analytics and OBIEE Apps.
• Extensive experience in OBIEE 11.1.1.x/10.1.3.3.x, Oracle BI applications 7.9.5/7.9.6 and Siebel Analytics 7.7.1/7.8.5 which includes creating, customizing and managing repository and Presentation services Answers, Dashboards Delivers , OBI/Siebel iBots BI Scheduler , BI publisher, BI RPD and Web-catalog administration.
• Strong understanding of Data Warehouse concepts ETL, OLAP, Star Schema, Data Modeling using Normalization, Business Process Analysis, Dimensional Data Modeling, FACT Dimensions tables, Physical Logical Data Modeling , Aggregate persistence wizard.
• Strong working knowledge in Metadata modeling in all three layers physical, BMM, presentation .
• Experience in using Presentation, Repository and Session variables and Initialization blocks in OBIEE.
• Experience in administering various OBIEE environments with large number of users and providing optimum system uptime and performance designing security matrix, configuring authentication and authorization architecture, and providing permissions to users according to their role.
• Worked on BI Publisher importing data from multiple data sources and delivered Reports, common dashboards, metadata, security, calculation, caching, and intelligent request generation services.
• Expertise in developing OBIEE repositories from scratch, and also many Reports/dashboards with different analytics views drill-down/dynamics, cascading style sheets, pivot table, chart, column sector, tabular with local and global filters using OBIEE Answers/Dashboard.
• Experience in developing various dynamic and interactive complex reports/dashboards with intuitive drilldowns, drill-across and drillable charts using Answers
• Extensive Knowledge on Oracle Delivers and Implemented schedule based iBots to deliver reports
• Worked Extensively on OBIEE Administration Tool, OBIEE Presentation Services, Answers, Interactive Dashboards and BI Publisher.
• Strong knowledge of RDBMS databases like Oracle 10g/11g, MS SQL server 2000, IBM DB2 8.2
• Strong Knowledge in Oracle SQL queries Performance tuning using Explain plan.
• Good Communication, Co-ordination and team skills. Well organized with excellent leadership skills and commitment to deliver on schedule.

Technical Skills:

Work Experiences:

Confidential

Senior Oracle BI Consultant

Responsibilities:

• Assist with the sprint deployment process.
• Troubleshoot any issues with the deployment process, database issues, applications and development tools.
• Identify Process improvements and implement them.
• Work with data architect to implement the reference data change requests.
• Implement the database change requests DBCR and data change requests DCR .
• Provide support to the application teams on general Database Requests.
• Assist the application teams with running Repository Creation Utility RCU to install the underlying database schemas.
• Create naming standards for all the DDL and DML scripts.
• Perform reviews on the design and code frequently to ensure the project standards are being adhered to.
• Provide technical support to application development and test teams.
• Assist with impact analysis of any changes made to the database objects.
• Creating and Scheduling Oracle Backend Process Jobs in Crontab
• Automated the nightly RMAN backups for the Production and Test Databases in Crontab.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups with Export/ImportDatapumputilities .
• Installed and configured of Oracle BI Publisher on Red hat 5.0, IBM-AIX 7.1
• Installed and configured OBIEE on Red hat 5.0, IBM-AIX 7.1
• Configured UCM with BIPublisher/OBIEE
• Prepared the webcat and repository. Created security groups and application roles.
• Administration of the existing environment with respect to changes and the development changes and implementation feasibility.
• Implemented and configured iBot on development, Test, Production and UAT assigned users are groups and also masked the data and restricted users.
• Configured BI publisher and implemented the HIX template in the report.
• Worked on the memory utilization and reports using report optimization technique.
• Implemented User access, authentication and authorization following best practices in the Repository.
• Coordinated with business users in understating and implementing the security feature. Using Object level and Data level Security.
• Worked on creating deadlines for the development and engineering team to make application ready to deploy.
• Worked extensively on reports and dashboards to minimize the source system upgrade impact and data availability
• Worked on Repository .rpd , customized the RPD with the requirements of the End User. Designed and Developed the three layers Physical, BMM, Presentation
• Developed Dashboards, Reports, drillable charts, pivot table views, guided navigation, prompts, and compound layout.
• Implemented Dimensional hierarchies, Level based measures, Fragmentation content, Aggregation, Complex joins in rpd, Configured Repository and Session variables and Initialization block for Dynamic, Customized, Prebuilt reports.
• Implemented Delivers using iBots for delivery of report through email, hand held devices and mobile phones.
• Worked on administration of OBIEE Cache management, Security Management for Users, groups and web groups using the various authentication system such as LDAP Authentication using Session variable as well as Dash board / Report level Security.
• Implemented Row Level Security.
• Lead of analytics tier in disaster recovery activity. Activity objective is to bring the application live after complete disaster of the environment. Involved in cross training to the new employees to understand the Application and responsibilities
• As per client requirement I have done the Skin and Custom Style Changes in Analytics.
• Integrated OBIEE with OUD and OAM.
• Automated the Services Start and Stop using Shell Scripts
• Automated backup of Catalog, Repository and Config Files using Shell Scripts
• Configured OBIEE and BIP with Oracle UCM Web Center Content

Environment: OBIEE 11.1.1.7, Oracle BI Publisher 11.1.1.7 SQL,, Oracle Database 10g/11G, EBS R12.1.3,SQL Developer, RMAN,EXADATA,Red Hat Linux 5.5 and IBM AIX 7.1,Keypass,Oracle UCM 11.1.1.7.

Confidential

Senior Oracle BI Consultant

Responsibilities:

• Involved in upgrade of existing Sprint 2 system to Sprint 2.1 in test, UAT, production, break fix and training environment.
• Involved in upgrade where OBIEE 10g was replaced by OBIEE 11g in spectrum along with the existing environment.
• Involved in setup, installation, configuration of OBIEE 11g in Linux operating system also integrating with the existing environment. Involved in trouble shooting of errors encountered. And worked with Oracle support to analyze the issue.
• Executed the run installer for Data ware house and Informatica mappings as a standard process. Emplacing the OHSCDA help and image files and folders.
• Prepared the webcat and repository. Created security groups and application roles for OHSCDA.
• Administration of the existing environment with respect to changes and the development changes and implementation feasibility.
• Worked on Oracle application server and Apache web server.
• Worked on the environment setup of development, Test, Production, UAT, Training and break fix servers.
• Implemented and documented the best practices which are followed during the application installation and configuration.
• Worked on the Production environment and configured the clustered environment on the Linux system.
• Implemented and configured iBot on development, Test, Production and UAT assigned users are groups and also masked the data and restricted users.
• Configured BI publisher and implemented the HIX template in the report.
• Worked on the memory utilization and reports using report optimization technique.
• Implemented User access, authentication and authorization following best practices in the Repository.
• Coordinated with business users in understating and implementing the security feature. Using Object level and Data level Security.
• Worked on creating deadlines for the development and engineering team to make application ready to deploy. Migration of Repository, Webcat and Informatica mapping across the environment.
• Create new tables and schemas as a part of Fusion middle ware setup. As part of OHSCDA2.1 upgrade new informatica mappings were created and synchronized by creating new database tables in the Data ware house.
• Created shell scripts to automate the start and stop services of the Admin server, node manager, Managed server and OBI server component services.
• Worked on various layers of OBIEE architecture Application layer, Presentation layer. Involved in developing the Incremental ETL process i.e., Mappings Mapplets using various
• Transformations and Workflows with Sessions or Tasks.

Environment: OBIEE 10.1.3.4.1/11g, Oracle BI Applications 7.9.6.2/3, Oracle DAC BI Publisher SQL,PL/SQL, Oracle Database 10g, Teradata, Oracle EBS R12, Oracle 10g/11g, SQL Developer, Windows2003 server and Red Hat Linux 5.2

Confidential

OBIEE Developer/OBIEE Admin

Responsibilities:

• Worked closely with the business users to identify various KPI's and designed solutions to enhance business decision-making.
• Upgrading of existing Sprint 2 system to Sprint 2.1 in test, UAT, production, break fix and training environment.
• Worked on Oracle BI EE Administration tool for customizing the Physical layer, Business layer, Presentation layer and modifying it according to the business requirements.
• Worked with the physical layer to create Connection pools and imported physical tables and defined joins.
• Developed and customized some of the existing multiple Dimensions Drill-Down Hierarchies Logical objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Created Global/Local Prompts, Narrative Views, Filters, Charts, Pivot Tables, Compound layouts to design the dashboards.
• Created Security settings in Oracle Administration Tool to set up groups, access privileges and query privileges and also manages security for groups in BI Answers.
• Developed Dashboards for each of Metrics by embedding Reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics in providing summary and detail reports.
• Used OBIEE Delivers to automate iBot queries, obtain weekly reports and to send alerts to related managers and secured team members.
• Worked in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Participated in complete life cycle of the project from project initiation, to development, to production support and maintenance.
• Enhance performance of Reports/Dashboards by implementing the Aggregate tables, Table execution path by making use of hints, Creation/Re-building of Indices and Cache Management.
• Created and saved several BI Publisher reports by selecting an Answers request as the Data Source.
• Built multiple execution plans in DAC for weekly and daily loads.
• Created comprehensive and easy-to-understand Documentation of the complete implementation of the Customer Sales Business modules Reports, Dashboards, Security and Star schema .
• Build test cases and tested the Reports / Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.

Confidential

OBIEE Developer

Confidential is a not for profit health plan. Their mission is to improve the lives of the people it serves and the health of its communities. Confidential was recognized as an excellent health plan for service and clinical activity. Confidential became the first health insurer in the country to propose a specific plan for universal health coverage. The project was to centralize decision making system as part of data management which involved integrating and simplifying by dropping unwanted data elements, introducing new elements and combining data using ETL processes by providing composite and meaningful views to users.

Responsibilities:

• Participated in User Meetings to understand the requirements.
• Worked closely with the data modeler in creating logical data model Star Schema .
• Built the OBIEE repository/metadata Physical Layer, Business Model and Mapping Layer and Presentation Layer and created the subject area where reporting and analysis are centered around.
• Developed calculated measures and dimension hierarchies in the Business Model and Mapping Layer
• Configured web catalog objects Dashboards, Pages, Folders, Reports
• Implemented data level and object level security.
• Worked on OBIEE Answers to build Interactive Dashboards with drill-down capabilities based on organization's and product's hierarchies
• Implemented different views of report i.e. Pivot table, Titles, Graph, Filters etc.
• Generated Dashboards to provide insight into Sales Analytics, Activity Analytics.
• Created users, groups, configured the permissions in the administration tool and verified the Permissions of the users in web catalog.
• Assisted in creation of pivot table requests allowing manager's to analyze the business/data from different perspectives.
• Performed Pre and post implementation testing of Dashboard, Answers and validating Repository.
• Installed and configured Oracle BI Publisher and integrated it with Oracle BI Presentation services.
• Developed and modified reports in BI Publisher.
• Extensively used SQL queries, Procedures, Triggers.
• Developed user guides for the end users. User guide contained some screenshots of high level reports and also provides instructions in accessing them.
• Also participated in developing ETL design using Informatica, used Transformations like Aggregator, Joiner, Update, Filter, Lookup, Sorter.

Environment: OBIEE 10.1.3.4.1, BI Publisher SQL,PL/SQL, Oracle Database 10g, Oracle EBS R12.0.0, Oracle 10g/11g, SQL Developer and Red Hat Linux.