Sap Bo Lead Resume
Schaumburg, IL
SUMMARY
- SAP Business Objects Certified Architect with over 10 years of Information technology experience including 8 years of Business Objects server operations and administration.
- Good experience in setting up fully redundant and failover SAP Business Objects clustered environment.
- Senior Business Objects administrator/architect with extensive experience in full Business Objects project life cycle of versions E651, BOXI, BOXIR2, BOXI 3.1 SP3 FP3.3 & BI4.0 & BI4.1, BI 4.2(Ramp Up).
- Expertise with SAP BI architecture design & security.
- Over 8 years of experience in five large Business Objects implementations.
- Significant experience providing 24x7 operational support of business - critical software products.
- Ability to coordinate effectively with other operational groups to troubleshoot and resolve Business Objects issues.
- Expertise in designing, installation, configuration, administration, testing,, upgrade and migration of Business Objects Desktop and Server Products for 6000+ users.
- Expertise in scaling Business Objects servers according to the usage.
- Expertise in end to end single sign on for BOXIR2 SP1/SP2 and XI 3.1 &BI4.0, (LDAP, Win AD, SNC & STS)
- Expertise in Administering Business Objects security Via CMC.
- Expertise in Disaster Recovery planning and implementation.
- Expertise with SAP BO Mobile, Design Studio and Explorer.
- Business Objects global deployments expertise.
- Expertise in setting Business Objects Monitoring using legacy Monitoring delivered by SAP, MOM & Site scope.
- Expertise with SAP BI architecture design, security, upgrade, migration and benchmark testing.
- Developed procedural improvements and implemented standards for Business Objects Development, server maintenance, installs and configuration.
- Expertise with all Business Objects toolset (Webi, LO, Xcelsius, Crystal 2011, Crystal 2011 Enterprise, BICS, Designer, IDT, Upgrade Management Tool, QAAWS, Explorer, LCM & Import Wizard).
- Excellent team player having strong leadership roles, excellent communication, client interaction and problem solving skills
- Results-orientation with high attention to detail.
- Proven ability to work efficiently on multiple projects simultaneously.
- Excellent team player having strong leadership roles, excellent communication, client interaction and problem solving skills.
- Managed priorities and setting expectation for new projects/stack holders coming on board to BI environments.
- Ability to adapt in a dynamic work environment and make independent decisions.
- Very high level expertise and understanding on how SAP Business Objects process works on back end.
- Exceptional Business Objects troubleshooting skills.
TECHNICAL SKILLS
Business Intelligence: BI 4.2(Ramp Up)BI4.1BI4.0, BOXI//BOXIR2SP1/SP3 FP3.3/XI 3.0 /6.5.1/5.1. X/ Supervisor, Designer, Information Steward 4.0,Reporter ZABO,BCAP, BO Auditor, Broadcast Agent, CMC, CCM, Import Wizard, Publishing Wizard, Data Source Migration Wizard, Live Office, Xcelsius, Design Studio, BI Widgets, Voyager, Webi rich client, Query as Web service, LCM,IDT, Dashboards, Security audit SDK,WEBI, 2.5/2.6/2.7.3
Database: Oracle 11g,Oracle 10g, SQL, PL/SQL, SQL Server, Teradata, SAP Hana, Netezza
MOBILE: SAP Mobile & ROAMBI
OLAP: Hyperion, SAP BW
Analytics: SAP Lumira, Xcelsius & Design Studio
Database Tools: SQL, Toad, SQL Navigator, SQL * PLUS, Developer 2000,AQT
Operating Systems: Linux Red Hat, Win2000, Windows 2003, Windows 2008 & Windows 2012,Solaris
Web Technologies: ASP, IIS5.0/6.0,Tomcat,Weblogic.
PROFESSIONAL EXPERIENCE
Confidential - Schaumburg, IL
SAP BO Lead
Responsibilities:
- Implemented fully redundant and failover server infrastructures for Business Objects BI4.1
- Implemented and BI4.2 Beta Ramp up for testing and validation purpose.
- Configured CMS and Audit repositories for the application
- Worked in Migration of WebI and Crystal reports between environments.
- Involved in Troubleshooting of Web Intelligence report issues.
- Responsible for server sizing and capacity planning.
- Responsible for monitoring the different services on the application server and troubleshooting of issues.
- Designed Customization of Universes and Reports for the application teams reporting.
- Worked in Migration of Universes and Reports across environments using UMT.
- Monitor performance statistics for determining hardware requirements and communication/ network bandwidth to support projected transaction volumes, response time and system availability targets.
- Involved in creating user roles, security access, server administration, password management using the Central Management Console (CMC).
- Created Setting up of SMTP and FTP functionality for report delivery.
- Troubleshooting of user issues with regard to Universe and Report design.
- Worked in of Business Users using Business Objects for reporting needs
- Communication with Business Objects tech. support in resolving issues.
- Presentation of Business Objects functionality to new application teams in the organization.
- 24 / 7 primary production support across the organization of all Business Objects related issues.
- Involved in creating the functional documents & technical documents.
- Involved in data modeling, creating star schema and snow flake schemas.
- Created, modified, enhanced, tested, deployed, optimized, and maintained Business Objects Universes using Designer to include objects like dimensions, details, measures & tables, views according to the users requirements
- Created the Default, Custom Hierarchies & cubes created canned & ad-hoc reports with Multi-Level Scope of Analysis using drill down, drill across, drill up and slice and dice
- Implemented cascading prompts in universe, worked extensively with @functions (@select, @prompt, @where) to overcome the problems with database when integrating with Business Objects, and checked the integrity of the universes
- Created Aliases and Contexts for resolving Loops, Chasm Traps & Fan Traps and checked the cardinality and Integrity of the Universe
- Used QAAWS, Live Office to bring the data from Business Objects into Microsoft office for analysis of data using charts, graphs etc.
Confidential - Berkeley, CA
SAP BO Architect/Administrator
Responsibilities:
- Implemented fully redundant and failover server infrastructures for Business Objects BI4.1 SP4.
- Played Key role in Performance tuning and stabilization of BI4.1 environments.
- Worked as a lead in migrating Contents from 3.1 to BI4.1 SP4
- Designed upgrade plan and executed upgrade of BI4.1 SP4 to BI4.1 SP5.
- Architected, designed and developed event based scheduling process of the reports.
- Built complete architecture comprising BO server, Web-App server, Repository, databases and SSO using LDAP/Enterprise Authentication.
- Converted BOXI3.1 Desktop Intelligence reports to Webi reports using Report Conversion Tool.
- Scripted Business Objects client tool install to automate install of BOBJ client tools via SMS push.
- Involved in horizontal scaling of the environment splitting BOBJ servers/Services across the landscape for better performance.
- Utilizing the new monitoring tool for better monitoring of our BI4 servers apart from Site Scope Monitoring.
- Designed and Managed Business Objects Security.
- Created Business Objects Disaster Recovery procedure.
- Configured Auditing and used audit data extensively to monitor system usage and also to identify long running reports on the system.
- Requirement gathering for new groups coming aboard and setting up the security template.
- Developed and implemented standards for system/server maintenance and configuration. Automated routine maintenance tasks as appropriate.
- Ensured proper backups procedures are in place and in use.
- Worked with applications development teams to troubleshoot and resolve issues, including performance tuning.
- Migrated Business Objects content using Promotion management tool and also using Command Line Interface (CLI).
- Monitored scheduled Jobs, Event Based schedules and Publications.
- Implemented SAP Mobile in SAP BI 4.1 SP5
Confidential - Saint Louis, MO
SAP Business Objects Architect / Admin
Responsibilities:
- Performed user requirement analysis to determine the SAP BI 4.0 system needs for DEV,QA and PROD
- Used SAP Sizing Estimator to determine the server sizing for optimal performance.
- Followed the best practices in designing a futuristic, robust and scalable BI landscape.
- Designed BOXI3.1 upgrade plan and led the successful upgrade of Business Objects systems to BI 4.0 SP6
- Upgraded BI4.0 SP6 systems to BI4.1 SP3 patch3.
- Implemented BI 4.0 & Explorer 4.0 on Linux, Configured BI launch pad & Explorer.
- Implemented BI 4.0 on Linux Platform and Windows 2008 servers.
- Built complete architecture comprising BO server, Web-App server, Repository, databases and SSO using LDAP/Enterprise Authentication.
- Designed fully redundant Business Objects server environment.
- Worked closely with the business and designed and architected various reporting requirements.
- Solution Architect for designing reports and dashboard with the news BI 4.0 system.
- Responsible for server sizing, configuration, space estimation, and complete architecture of new environments.
- Administered users and groups using LDAP authentication and monitor server activities using auditor and legacy monitoring tools.
- Architected, designed and developed event based scheduling process of the reports.
- Configured server groups.
- Scaled Adaptive Processing servers to improve the performance of SAP BOBJ systems.
- Configured the File Repository servers and deployed the Backup Policy for the content of the file servers and the CMS & Audit database
- Designed and implemented the Security Architecture for each user groups for the entire BI Landscape
- Scheduled BODS reports to the user inbox for their daily usage
- Extensively used Business Objects Access levels in setting up SAP BI Security
- Configured WinAD SSO and SAP trust for Business Objects environment.
- Successfully deployed SAP Mobile
- Configures SAP Business Object system to use WinAD, SNC and STS.
- Worked with Citrix team to deploy SAP BI4.1 Client tools on Citrix.
- Set up server monitoring rules to oversee the performances and status of BI 4.1 services
- Presented of Business Objects functionality to new application teams in the organization
- Bundled BI 4.1 client tools using silent scripts for SMS push.
- Built BODS (DEV/QA/PROD/SBX) servers.
- Performed Dev-Test-Prod migrations
- Created Business Objects Audit reports to track systems usage metrics and trends.
- Assisted Business Objects user community with Business object issues.
- Worked with SAP Business Objects Vendor in resolving product defects.
- Business Objects patch testing and Validation.
- Designed and implemented Apache/Tomcat split deployment to improve the performance of Webservers in SAP BOBJ environment.
- Managed BOXI3.1 Business Objects systems support.
Confidential - St Louis, MO
SAP Business Objects Architect
Responsibilities:
- Installed, configured, tuned performance supported and administered Business Objects 4.0 environments (Sandbox, DEV, QA, and PROD).
- Configured Windows Authentication, SSO, SAP authentication, SAP Role Mapping and BOBJ over BW.
- Evaluating the Version Management tool for better change control of report modification.
- Created Disaster Recovery plan for new BI4 environment.
- Evaluating the possibilities of using HANA models for reporting.
- Used Promotion Management Tool to Promote objects between BI4 SP4 Landscapes (Sandbox, DEV, QA and PROD).
- Working as a point of contact for our offshore resources.
- Working with SAP support engineers from different regions, back office and TQM (Technical Quality Manager) to fix BI4.0 post migration issues. customers of the new features available in BI4.0 and Coordinating UAT effort and fixing issues from time to time.
- Involved in Share point and iVIEW portal integration with new BI4.0.Publishing Crystal reports and Web Intelligence reports.
- Configured BOBJ environment to using WinAd with STS and SNC.
- Monitoring the servers for CPU, I/O SAPSOCOL.
- Providing Primary On-call support on a 24*7 basis.
- Designed scripts for BI4.0 Client tools software for SMS push.
- Designed & managed BI4.0 security via CMC.
- Assisted users with day to day Business Objects issues.
- Played key role in design & stabilization of BI4.0 systems since BI4.0 ramp up days.
- Applied best practices while developing universes using Information Design tool and the universe designer.
Confidential, TX
Business Objects Administrator
Responsibilities:
- Involved in Installation and configuration of BOXI R2 (with different service pack upgrades) and BOXI R3.1 (with different service pack upgrades) on both Windows.
- Played significant role in upgrade of BOXIR2 systems to BOXIR3.
- Mentored users on BOXI3.1 SP3 new functionality & security.
- Moved around 6000 users and reports/universes from BOXIR2 to BOXI3.1 systems.
- Designed fully redundant BOXI3.1 systems for failover purpose.
- Involved in Performance management reports and dashboards creation, using Xcelsius 2008.
- Involved in Win AD authentication and SSO (Single Sign On).
- Involved in WAR file and BIAR (Business Intelligence Archive Resource) file recovery.
- Involved in INFOVIEW Customization.
- Daily administration of Business Objects server to prevent outage and plans for optimized system resource utilization.
- Designed user security template for BOXI3.1 security in CMC.
- Monitoring the servers for CPU, I/O usage thru NAGIOS, a 3rd party tool and thru SQL server activity monitor.
- Preparing component design documents, Application design documents, unit & integration test plan and unit & integration test script.
- Unit testing, Regression testing of canned reports, ad-hoc reports and Universe as per the client request and turnover of reports and universe.
- Providing Primary On-call support on a 24*7 basis.
Confidential - Peoria, IL
Business Objects Administrator
Responsibilities:
- Experience in Installation, configuration and maintenance of BO 6.5 and BOXI R2 (with different service pack and fix pack upgrades).
- Led the migration effort of BO 6.5 to BOXI R2 SP2, User and content migration and security redesign at new destination server.
- Re-designing/Managing Business Objects securities at all levels (Row level, column level, Folder level, Group level, user level, application level and at Report level).Managing Business Objects users, user access rights. Full versed on explicit access and access by inheritance.
- Involved in Windows AD (Kerberos)/NT (NTLM)/LDAP authentication and SSO.
- Installed, configured, tuned, supported administration of BOXIR2 SP2 on 8 server Production cluster, 2 server Test cluster and 2 server Dev cluster Servers are fully redundant for failover.
- Broadcast Agent Publisher E6.5.1 mentoring.
- Repository Scan & Repair in E6.5.1.
- New Group/Domain Creation and Configuration in E6.5.1.
- Security Configuration Assistance and Mentoring in BOXIR2 SP2.
- User Activity Logging and Reporting in BOXIR2 SP2.
- Broadcast Agent Scheduler Set-Up and Configuration in E6.5.1.
- Performed repository scan & repair to remove logical deletes from the repository from time to time.
- Providing Primary On-call support on a 24*7 basis.
Confidential
Business Objects Administrator/Developer
Responsibilities:
- Played significant role in upgrade of Business objects 5.1.7 environment to E651.
- Designed & executed flawless upgrade of BO 5.1.7 to E651.
- Created best practices for repository scan & repair.
- Created & maintained BCA’s.
- Monitored scheduled jobs running E651 Business Objects systems.
- Assisted users with day to day BO related issues.
- Installed & configured E651 Business Objects Systems.
- Designed steps to bundle to the Business Objects client tools software and to push to users works stations.
- Tuned Business Objects systems according to the usage based on Audit metrics.