Sap Business Objects Sme/ Administrator Resume
SUMMARY
- Over 14 years of expertise in software analysis, design, and development of applications which includes experience in providing Business Intelligence solutions using Business Objects products like CMC, Supervisor, Designer, Broadcast Agent, Web Intelligence, Crystal Reports, Design Studio, Lumira, and other data warehousing tools in DSS.
- Installed, configured, Maintained complete SAP Business Intelligence suite (4.2, 4.1, XI 3.1, XIR2, 6.5) on Windows, Linux and Amazon web services.
- Expertise in Installing and Configuration SAP Business Objects applications and maintenance in Windows and Unix environments
- Integrated & Implementing Single Sign On (SSO) With SAP Business Objects with SAP BW on Windows and Unix Platforms on BOXI R2 / BOXI 3.1 / BI 4.
- Installed and Configured SAP Business Objects Explorer on BWA with SAP and Non - SAP Systems.
- Extensive experience building Business Objects XI R2/4.1/4.2 security model, Well Versed with SIA, FRS, CMS, Page Server, Cache Server, Job Server, Input/Output Servers, and CR Servers within BOE.
- Extensively Used CMC (Central Management Console) for user management, content management, and server management tasks and CCM (Central Configuration Manager) to manage local and remote servers.
- Experience with Installing and Administration of entire hardware, and software products like Tomcat, IIS 5, and Apache
- Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as developing, configuration testing, Migrating, Administrating, maintenance, security management and production supporting on various platforms like UNIX, Windows.
- Extensively Used CMC (Central Management Console) for user management, content management, and server management tasks and CCM (Central Configuration Manager) to manage local and remote servers.
- Experience with Installing and Administration of entire hardware, and software products like Tomcat and Apache
- Solid understanding and experience in setting up of Repository, creating, managing users and user groups using Supervisor and CMC.
- Experienced in production support (24*7) of Business Objects environments 6.5 and XI R2 /R3.1/4.1/4.2 on Windows and Linux platforms.
- Good understanding of Dimensional modeling (Star and Snow Flake Schemas)
- Expertise in providing Business Intelligence solutions using Business Objects and other data warehousing tools in OLTP/Data warehousing/DSS.
- Expertise in building universes and creating reports using Web Intelligence and Business Objects.
- Extensive experience with creating Dashboards using CX 2008, QaaWS and Live Office.
- A dedicated team player/leader with excellent communication, organizational and interpersonal skills.
TECHNICAL SKILLS
Hardware: IBM Compatibles, Sun SPARC Stations, HP, IBM
Operating Systems: UNIX (Hp/Sun Solaris) Windows 95/98, Windows NT/2000
Languages: SQL, PL/SQL, Java, JavaScript, VBScript, HTML, Shell Scripting
RDBMS: Oracle 9i/10g/11g, SAP HANA, SQL Server 7.0, 2012, MS Access, Informix 2.5, DB2 UDB
Front End Tools: Visual Basic 5.0, Developer 2000
DSS Tools: Business Objects 5x, 6x, XI r2/ r3.1, BI 4.0/4.1/4.2(CMC, CCM), Dashboard Designer, IDT, UDT, Web Intelligence SAP HANA, Design Studio, SAP Lumira, Dashboard Designer, Crystal Xcelsius 4.0/2008 Sp3, Crystal Reports 2013/2016, Tableau 9x/10x, Cognos Powerplay 6.0, Cognos Impromptu 6.x/7. x.
ETL Tools: Informatica PowerMart 4.7, PowerCenter 1.7, Business Objects Data Integrator6.1.
Data modeling Tools: Erwin/ERX 3.5
PROFESSIONAL EXPERIENCE
Confidential
SAP Business Objects SME/ Administrator
Responsibilities:
- Involved in Architecture Design for the BI 4.1 for a clustered environment on Windows and Linux environments
- Designed the upgrade road map for the Business Partners to upgrade from the exiting environment to BI 4.1 and 4.2
- Worked on sizing, scaling and performance tuning of Business Objects BI 4.1/4.2 environments
- Installed middleware components (Oracle Client) on windows 2012 and REHL 7
- Managed entire 4.2 upgrade project which involved planning Pre and Post Installation / Upgrade cutover tasks.
- Installed Business Objects Enterprise 4.1/4.2 SP04 on Windows VMware environment with Tomcat as Application Server in Windows and REHL environments.
- Configured the BO Services in CMC with various settings as a part of Performance Tuning
- Applied Service Packs and Fix pack as needed and also to fix the bugs in the process of upgrade to 4.2 SP04 Patch 01
- Created detailed design document for all the environments which included Installation Run books, and configuration settings
- Implemented 2 Factor Authentication to add additional security in existing BI environments using Trusted Authentication mechanism.
- Installed SAP Lumira/Design Studio Add-on to the existing Business Objects Landscape.
- Upgraded current BI 4.1 systems to BI 4.2 SP4 Patch1
- Installed multiple Web Tiers using Tomcat as the Web Application Server
- Configured and tuned all the Business Objects Servers (FRS, APS, AJS, DSL, WebI, Crystal Services)
- Configured LDAP authentication and setup SSO for end users.
- Integrated Business Objects systems with SAP BW/HANA systems and imported SAP users and setup SSO from BO to BW systems.
- Setup security model for SAP BW users in Business Objects.
- Configured Business Objects environment with SAP HANA systems
- Configured notification, Mobile push and Admin Cockpit BI4.2 SP04.
- Configured CMS Driver setup and created Universe based on CMS for real time information.
- Worked as a Business Objects BI 4.1 /4.2 subject matter expert on existing issues in the environment
- Configured the BO Services in CMC with various settings as a part of Performance Tuning
- Designed DR and Backup strategy for the Business Objects environment for high availability
- Created replication jobs as a part of Disaster Recovery and documented the process.
- Configured the Promotion Management, monitoring components and also gave a demo to the application users for promoting the content.
- Worked with business groups to resolve the upgrade issues related to reports.
- Worked on security model, custom access levels, user and group management to implement Folder and Application level security.
- Worked on server administration and maintenance, performance monitoring, service pack and fix pack installations, and clustering of Business Objects servers for load balancing and fault tolerance
- Deployed Business Objects Web Applications on multiple tomcat instances in REHL.
- Managed Service Now ticket queue - trained end users, troubleshooting server and client issues and granted subject area access
- Worked with SAP support on several tickets related to platform defects and also reports
- Managed Offshore/Onsite Teams to support Business Objects environments
- Involved in 24/7 support for the end user community resolving the tickets raised by them
- Created backup and disaster recovery procedures and setup DR environment.
- Created Audit based reports to track the usage of reports by the Business and also reports to list out the status of the scheduled reports.
Environment: Business Objects 4.1/4.2, XI R2(CMC, CCM, Import Wizard, Life Cycle Manager, Business Objects 4.0, Desktop Intelligence, Web Intelligence, Lumira, Design Studio, Live Office), Data Services 4.1 BI Explorer, Tableau 9x/10x, Oracle 11g /12g, SQL Server 2012, Windows 2008 and 2012 Server, Linux Red Hat, Tomcat7/8
Confidential
SAP Business Objects Admin
Responsibilities:
- Involved in Architecture Design for the BI 4.0 for a clustered environment on Windows 2008 Servers
- Installed Business Objects Enterprise on Windows VMware environment with Tomcat as Application Server
- Configured BI Launchpad Single Sign on (SSO) authentication using Ventela for both tomcat and web logic deployments.
- Configured the BO Services in CMC with various settings as a part of Performance Tuning
- Applied Service Packs and Fix pack as needed and also to fix the bugs in the process of migration from R3 to 4.0
- Worked on DR and Backup strategy for the BOE and Crystal environments
- Configured the LCM, monitoring components and also gave a demo to the application users for promoting the content.
- Created a POC for migrating universes from XI R2 to BI 4.0
- Created detailed design document for all the environments which included Installation Run books, and configuration settings
- Designed the migration road map for the Business Partners to migrate from the exiting environment to BI 4.0
- Designed Security model to access the BI content by different Business Partners
- Assigned Folder level and Application level security to the groups imported from Windows AD.
- Coordinate with offshore team, assign tasks and work closely with them in Universe and Report development activities.
- Implemented the Security with Custom Access levels for different types of user base to restrict Applications/Content and functionalities
- Maintenance of the multiple Business Objects environments on a regular basis
- Created test cases for BO Client tools (IDT, UDT, BI Launchpad and Crystal)
- Tested the upgrade process using the existing BOXI R2 environment to BOBJ 4.0 which included migrating Universes, Reports and various objects from the earlier version to BI 4.0 using Upgrade Management Tool (BIAR too Live)
- Fixed INF errors in the reports while migrating the reports from XI R2 to BI 4.0
- Created Test Cases and Test Scenarios as a part of UAT to get the reports signed off
- Tested the both Deski and WebI reports with different test scenarios which includes data validation and also formatting
- Debugged issues which resulted from Migration. Provided support in enhancement and maintenance of the Reports and Universes.
Environment: Business Objects SAP BI 4.0/ XI 3.1 sp3, XIR2, (CMC, CCM, Designer, Web Intelligence, Import Wizard), UMT, Advance Analysis 1.1, BI Workspace, Oracle10g, MS SQL Server 2008, TOAD, Windows XP/2008 Server, UNIX, Sun Solaris.
Confidential
SAP Business Objects SME
Responsibilities:
- Involved in Architecture Design for the BOXI 3.1 / BOBJ 4.0 Environment on Windows 2008 Servers
- Involved in building the landscapes BOBJ Enterprise with multi clustered environment
- Installed Business Objects Enterprise on Windows VMware environment with Tomcat and Apache as web and application servers.
- Configured Business Objects Authentication with Windows AD / SSO
- Assigned Folder level and Application level security to the groups imported from Windows AD and SAP Roles.
- Installation and configuration of SAP Integration Kit in windows environment
- Configured the Job servers for scheduling the reports which supports email and FTP options
- Created Server Groups to schedule reports for various Business groups
- Implemented the Security with Custom Access levels for different types of user base to restrict Applications/Content and functionalities
- Maintenance of the multiple Business Objects environments on a regular basis
- Involved in 24/7 support for the end user community resolving the tickets raised by them
- Involved in performance tuning of the BO environment by configuring various settings for various BO services
- Upgraded the existing BOXI 3.1 Dev environment to BOBJ 4.0 which included migrating Universes, Reports and various objects from the earlier version to BOBJ 4.0 using Upgrade Management Tool
- Fixed issues related to Reports and Universes in the process of migration
- Installed and configured Crystal Xcelsius 2008, Live Office and Advance Analysis in multiple environments
- Created Universes on top of BW sources and also created new objects and conditions using the existing objects in the Universe to support the reporting environment
- Created new objects based on the objects generated from the SAP BW sources based on the reporting requirements
- Designed and Built Universes using Designer by defining joins, cardinalities between tables and applying contexts and aliases to remove cyclic dependencies.
- Created Audit based reports to track the usage of reports by the Business and also reports to list out the status of the scheduled reports.
- Created complex reports for Key Accounts with multiple data providers based on the Business Requirements
- Designed Event based scheduling for batch reports to execute and save in different formats as soon as the new data is loaded to the Warehouse
- Created derived tables at the Universe level to reduce the complexity of the Universes.
- Debugged issues which resulted from Migration. Provided support in enhancement and maintenance of the Reports and Universes.
- Involved in creating web-based reports using Business Objects Web Intelligence Rich Client and Crystal reports.
- Formatting the Reports based on the Users requirements using the functionalities in Business objects like Slice and Dice, Drill Down, Alerters, User response, @Functions.
- Created complex Web Intelligence reports from the universes which were created using the BEx Queris.
- Suggested the client with best practices related to Universe design and Report development and implemented them successfully
- Created Test Cases and Test Scenarios as a part of UAT to get the reports signed off
- Used Web Intelligence Rich Client to build reports on top of Universes.
Environment: Business Objects BOBJ 4.0/XI 3.1 sp3, (CMC, CCM, Designer, Web Intelligence, Import Wizard, Publishing Wizard), SAP IK, Advance Analysis 1.1, Xcelsius 2008, BO Data Services 3.2, SAP BW, Oracle10g, MS SQL Server 2008, TOAD, Windows XP/2008 Server, UNIX, Sun Solaris.