SUMMARY:

• Over 6+ 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 chartsusing 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:

Oracle EBS: R12/11.5.10, HP Quality Center, Siebel Analytics 7.X, OBIEE 10.1.3.X, 11.1.1.X & BI Applications 7.9.X, Oracle 9i/10g/11g, Oracle GoldenGate,SQL Server 2000/2005, Win XP/2003/2008 Win 7, Windows NT/98 & UNIX (Linux), C, C++, SQL, PL/SQL, VS COBOL II, Mainframe Focus, Core JAVA, Shell Scripting, Informatica Power Center 8.6/8.1, DAC 7.x, HTML, XML, TOAD, SQL*plus, ODBC, SQL*Loader, SQL Developer, Oracle BPEL, ESB, JDeveloper 10.1.3.3, 10.1.3.4, MS Project,RMAN, Oracle UCM.

PROFESSIONAL EXPERIENCE:

Confidential, CALIFORNIA, Sacramento

OBIEE Admin/OBIEE Developer

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.
• Developed measure for time comparison using time functions, ToDate and Ago.
• Used Filters and provided Prompts appropriately to make interactive reports and to avoid excessive data showing up on Reports.
• Customized/Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• 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.
• Expert in using OBIEE Analysis to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience.
• 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
• Created security settings in OBIEE Administration Tool and set up groups, access privileges and query privileges and also managed security for groups in Analysis.
• Involved in performance tuning of the dashboards with DBAs and BAs using cache management and aggregate tables
• 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)
• ñ Installed, Configured and administered Oracle WebLogic Server 10/11g, and Webservers like iPlanet/Apache in
• Development, Test and Production Environments.
• Deployed applications (WAR, JAR and EAR) using WLST, Anthill
• Maintained Load balancing, high availability and Fail over for the servers
• Installed and ConfigurediPlanet/Apache Plug-ins for WebLogic.
• Installed and configured Siteminder for Sunone.
• Configured and created JMS queues & topics, Connection Factories, Datasources, connections pools & multi Connection pools.
• Extensively involved in Tuning the server.
• Set up Secure Sockets Layer (SSL) communication between iPlanet and the WebLogic Application Server.
• Writing various posting scripts for log rotation, log analysis.
• Migrated WebLogic Server applications from existing version to 10 to 11g
• Involved in performance tuning of JVM and used Garbage collection Algorithms for better performance.
• Monitor and managing the weblogic server instances using WSLT and also for the automation purpose.
• Involved in trouble shooting and fixing day-to-day problems of the applications in production, production-Fix and testing environments.
• Configured LDAP using directory Server for user authentication
• Installed BEA patches using Smart Update tool, and troubleshooting application and post- installation issues.
• Installed and Configured Wily Introscope and to monitor weblogic servers.
• Provided 24x7 on-call support for production / non production environments.
• Involved in documentation of environment using Visio tool.
• Applied the patches to the WebLogic servers.

Environment: OBIEE 11.1.1.7, Oracle BI Publisher 11.1.1.7 SQL,, Oracle Database 10g/11G, SQL Developer, RMAN,EXADATA,Windows2003 server, Red Hat Linux 5.2 and IBM AIX 7.1,Keypass,Oracle UCM 11.1.1.7, WebLogic server 10/11g, HPserver automation tool, J2EE,Apache 2.2, Sunone,Sun Solaris, RedHat Linux 6Anthill,Oracle 11g, MQ client, Wily, Remedy, Jms, JRockit, WLST.

Confidential, Windsor CT

OBIEE Admin

Responsibilities:

• Develop full SDLC project plans to implement ETL solution and identify resource requirements.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository Configured and Created repository using OBIEE 10.1.3.4.1 Admin tool.
• Co coordinating with Onsite/Offshore teams.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer created numerous executive level reports. Dashboards were generated to provide insight into the financial data.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Created different types of Customized Reports (Drilldown, Aggregation) to meet client requirements.
• Built Business model and established relationships & Foreign Keys (Physical & Logical) between tables.
• Created business reports using Oracle BI Answers as per requirements.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Involved in managing appropriate security privileges on subject areas and dashboards according to business requirements.
• Developed custom reports/Ad-hoc queries using Oracle BI Answers and assigned them to application specific dashboards.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Conduct impact assessment and determine size of effort based on requirements.
• Perform as active, leading role in shaping and enhancing overall ETL Informatica architecture.
• Identify, recommend and implement ETL process and architecture improvements.
• Familiarize the team with the customer needs, specifications, design targets, the development process, design standards, techniques and tools to support task performance.
• Ensure deliverables are prepared to satisfy the project requirements, cost and schedule.
• Work with functional managers and the team sponsor to obtain necessary resources to support the team's requirements.
• Establish meeting times, places and agendas.
• Coordinate the review, presentation and release of design layouts, drawings, analysis and other documentation.
• Coordinates meetings with the product committee, project manager and functional management to discuss project impediments, needed resources or issues/delays in completing the task.
• Provide status reporting of team activities against the program plan or schedule.
• Keep the project manager and product committee informed of task accomplishment, issues and status
• Serve as a focal point to communicate and resolve interface and integration issues with other teams.
• Escalate issues which cannot be resolved by the team.
• Handled both off shore and onsite team.

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

Confidential, Moline IL

OBIEE Admin/Sr OBIEE Developer

Responsibilities:

• Worked with functional and technical leads, business groups to identify, analyze, and document business requirements.
• Prepared Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Installed and Configured OBIEE11g server on UNIX (Linux).
• Upgraded OBIEE 10g Reports to OBIEE 11g
• Administered Web logic for OBIEE.
• Monitoring the progress of all the developers who built their respective dashboards.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas.
• Worked on fragmentation and partitioning concepts to enhance performance of the model.
• Used Evaluate function in rpd to push some of the functions to database.
• Created init blocks, session variables and used them in front end to set these variables.
• Involved in taking backups of Repository and Web Catalog files.
• Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.
• Created Time Series measures using AGO, To Date and Period Rolling functions.
• Created new Repositories/Subject areas and merged the same with different environments which are Development, Test, Stage and Production using Subversion.
• Developed automation tool to seed and purge the cache in Admin tool.
• Created users and granted permissions using BI Admin tool.
• Involved in Performance Tuning in BI by implementing aggregate navigation and cache management.
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the OBI Application level.
• Extensively used write back, solution for insert and update in database.
• Created Presentation catalogs, and Folders in Presentation Layer in Oracle BI Administration Tool.
• Enabled Usage Tracking Table and Dashboards.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache.
• Involved in setting up Ibots (Agents) to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching.
• Designed and developed Security Strategy and worked with Middleware to implement this in FMW.
• Modified NQSConfig, NQServer, Instanceconfig.xml files for Server configurations and troubleshooting reports performance.
• Developed Ad-hoc and standard Reports/dashboards with different Analytics Views - Drill Down, Drill across Cascading Style sheets, Pivot Table, Chart, Column Selector and Tabular With Prompts, Global and local Filters, Contextual Navigation, Business rules with user identity and role within the OBIEE suite.
• Worked in Performance tuning of reports/dashboards as well as metadata repository using optimization efforts such as re-organizing the data, cache management, indexes.
• Implemented Data Level Security and Object level Security using LDAP and External Tables.
• Involved in Integrating Oracle BI Presentation Services with BI Publisher.
• Set up BI publisher Security to control access given to business users.
• Experienced in working with BI (XML) Publisher, Data Templates, RTF, and XSL Templates and provided the capability to download the reports in the user defined formats.
• Used the OBIEE 11.1.1.x Administration tool to develop and enhance meta-data.
• Installation and configuration of all components of OBIEE, including the physical, logical, BMM and presentation layers.
• Involved in One on One meeting with SME to understand the business scenario and process flow.
• Used Filters (Global) and provided customized prompts to avoid excessive data showing up in the reports.
• Created session variables for users to provide row- level (data level) security and used the session variable in OBIEE answers to build the query.
• Involved in setting up methods of usage tracking using Direct Insertion and setting up Log File. Merged the Usage Tracking Repository with the main repository (.rpd) to have dashboard based usage tracking.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Built Time-Series calculations using AGO and TODATE functions on BMM (Business mapping and modeling) layer of repository and TIMESTAMP Functions in the Answers.
• Worked on data from different sources and data at different levels of granularity to build the required functionality.
• Performed Data Validation including both unit and regression testing of data in the reports and dashboards including the functionality based on requirements.
• Shared Knowledge in ETL processes using Informatica Power Center, PL/SQL for various transactions and loading data from various legacy data sources.
• Worked with Other Teams of Reporting, Data warehouse Developers and DBA's along with the Business Analysts and BRM's for requirement Gatherings and Feasibilities, Standards and Troubleshooting with the Issues along with QA Teams.
• Implemented user security authentication using LDAP server directory
• Involved in performance tuning for BI server and Oracle SQL queries.
• Worked Extensively on Oracle Answers, Dashboards and Delivers to create reports.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Performance Enhancement of the data ware house using indexing, partitions and running statistics.

Environment: OBIEE 10.1.1.X,OBIEE 11.1.1.X, Siebel Analytics 7.8, DAC 7.9.5, ORACLE 11g, SQL, TOAD, PL/SQL,DB2, BI Publisher, XML, Oracle Reports, UNIX.