Sr. Business Objects administrator

Business Objects administrator/architect with over 9 years of experience in developing BI Reporting solutions on relational and multidimensional data sources. Extensive experience in analysis, design, development and testing of data warehouse and data mart systems which includes installing, configuring, administering and supporting BusinessObjects Enterprise suite in high performance business systems. Proficient in an assortment of technologies, including VBA, Java, C#, Oracle 9i/10g, Weblogic application server, Tomcat application server, Apache Web Server, SAP BW, IIS, UML, Windows and Unix.

Technical skills include:

Reporting Tools : SAP BI 4.0,BOXI 3.1 R3/R2/R1 & BO 6.X,SAP BW 7.0 ETL Tools: SAP Data Services 4.0, Infomatica power center Database: Oracle 9i/10g, SQL Server 2000, Teradata, IBM DB2, MS Access, Informix Application Server: Weblogic 9.x/10.x, Tomcat 5.x/6.x Web Server: Apache, IIS Programming Language: VBA, C, Java, C#, PL/SQL, HTML, XML Operating System: UNIX, Windows

Experience

Confidential, Austin, TX Sr. SAP Business Objects Architect May/2010 - Present Administer Business Objects Infrastructure including support for diverse internal clients. Enhance system performance through load balancing, performance tuning, capacity monitoring, Plan backup & recovery procedures, handle performance tuning and conduct regular system checks. Ensure technical and functional designs meet business requirements. Duties: Design & Construction:

• Designed & Implemented systems that meet the information delivery needs of business intelligence systems; performed technical and advisory functions in the development of SAP business objects architecture and the creation of frameworks for reporting, dashboards, delivery, scheduling and object retention policies for complex information systems
• Worked with the business management to ensure business objects are appropriately utilized for all required management and adhoc reporting, as well as data extracts for shared data agreements.
• Installed, Configured and Supported a federated high available & fault tolerant BusinessObjects XI3.1SP3 clustered infrastructures deployed on Windows 2008R2 & Solaris Spark 10 64 bit VMWares.
• Installed and configured Apache webserver and Tomcat web application server that supports high available/fault tolerant Infoview and highly available CMC web applications.
• Worked with Network Team to load balance and ensure high avaialabitly of BOE web applications by configuring DNS and Cisco content services switch.
• Oversaw the Maintenance of BusinessObjects Enterprise & coordinated the continued development and enhancement of BusinessObjects Universes and upgrade of all BOE deployments from BOXI3.1 SP3 to BOXI3.1 SP5 with data warehouse managers/owners.
• Configured BusinessObjects File Repository Servers to connect to SAN
• Provided highly advanced technical consultation to other information technology professionals concerning information delivery systems.
• Installed, configured and managed highly available, fault tolerant clustered SAP BI/Data Services 4.0 running parallel with 3.1 environment.
• Configured SSL and WindowsAD SSO to BI 4.0 platform and implemented security architecture as per organizations needs.
• Attended most SAP presentations and internal trainings held during BI4.0 road map and ramp up custom releases.
• Worked with SAP engineers to troubleshoot product defects effectively and requested hot fixes for critical product bugs.

Configurations: Configured BusinessObjects Infoview(& BI Launch Pad) web application and other BO Client tools for Single Sign On using Windows AD with Kerberos based Authentication:

• Ensured BusinessObjects Enterprise content security by creating custom access levels for Developer, Super User and Basic User roles in all dev, test, pre-prod and production environments.
• Assigned top level security within CMC for developer group, super user group and basic user group using the custom access levels in all enterprise deployments.
• Configured single sign on functionality for Opendoc to access reports and dashboards from third party applications.
• Configured destination job servers, report specific job servers & other job servers for SMTP, FTP, Business Objects Inbox and Unmanaged disk destinations.
• Configured web services parameters for Qaaws using dswsbobje.
• Created server groups and added multiple instances of processing/cache and job servers as required to handle the load efficiently.
• Enabled auditing events on business objects servers in production to analyze/track usage of reports and other actions.

Operations:

• Migrated application content from Business Objects 6.5/XIR2 systems to Business ObjectsXI 3.1 SP3 using Import Wizard.
• Promoted content from development to test to pre-production to production environments using life cycle manager (LCM) and import wizard after testing and user signoff.
• Developed universes for complex reporting needs and migrated to XI4.0; converted .unv files to .unx using Information Design Tools
• Supported customer reporting applications built with the standard web intelligence portal as well as customer portals built with SDK (ASP and JSP).
• Setup row level or column level security on universe to restrict data access to certain users or user groups.
• Optimized web intelligence report performance on OLAP databases with Query Stripping enabled at query properties or document properties level.
• Created and maintained server backup routines and schedules by conferring with DBA's and system administrators.
• Reviewed product release notes for vendor patches and made recommendations;
• Performed Business Objects Server/Client upgrades from Business Objects XI 3.1 SP3 to SP5.
• Established SLA's & adhered to the change management, incident management and problem management policies of the organization.
• Provided technical support, guidance and documentation to end users; provided immediate fixes remotely on critical issues.
• Managed over 4000 users and 50 enterprise user groups.
• Extensively used of the following Business objects applications:
• InfoView; CMC; CCM; Web intelligence; Desktop intelligence; Crystal reports 2008 Designer; Business view manager; Universe designer; Import wizard; Publishing wizard; Query As a Web Service; Report Conversion tool; Xcelsius; Live office; Information Design Tool; Upgrade Management Tool; Dashboard Design, Interactive Analysis; SAP Crystal Reports for Enterprise.
• Provided 24*7 on call support on critical issues and ensure the environment is highly available and fault tolerant, Continuously monitor, fine tune and investigate recommendations to improve the performance.

Confidential, Plano, TX Sr. Business Objects Administrator August/2009 - May/2010 Designed, Installed, Configured & Maintained a Business Objects XI3.1 enterprise environment that caters to reporting needs of the SGBU (Software Group Business Unit).SGBU enabled business systems to profitably maximize the total customer experience with Software ordering, Software Product delivery, Software licensing and Software Support Contract Administration. Provided high quality information management and reporting in order to reduce analysis time, and to improve productivity by leveraging business intelligence that enables our business partners/customers to make smarter business decisions. Duties:

• Installed the product layout, migrated repository data with security details and configured the CMS clustering.
• Installed and configured the tomcat web application servers and Apache web servers for Infoview and CMC web applications.
• Installed SAP GUI, SAP Java Connector & Installed Business Objects integration kit for SAP and configured SAP authentication to leverage the functionality of single sign on to Business Objects Enterprise for SAP users and roles.
• Designed the overall SAP BI-BO implementation strategy by defining interfaces and tools, Defined the deployment process and responsible for the overall BI - BO delivery.
• Configured Single Sign on to Business objects thru LDAP authentication by enabling LDAP security plugin, Imported users/groups from LDAP.
• Created and maintained Enterprise folder structure, custom access levels for users and groups.
• Created and maintained server backup routines and schedules.
• Configured/fine tuned the performance parameters of all BO processes
• Performance tuning of Webi reports on OLAP Universes using optimization techniques like query stripping.
• Supported the Installation and configuration of BO Software and client tools
• Supported code deployments and migrated content between environments and report jobs schedules.
• Managed objects, reports, universes and database connections within Business Objects.
• Exported universe, reports and other contents to repository making it available to end users. Used Instance manager and infoview for creating instances and scheduling documents to destinations.
• Setting up new universe connections, access restrictions, checked integrity, cardinalities, optimized query processing time by using key features of Business Objects like aggregate awareness, Indexing within designer.
• Audit the application usage of reports and security through the repository or auditing features. Develop various reports using Webi, Deski, Crystal and other BO applications.
• Created and enhanced OLAP universes using BEx queries, Infocubes and multiproviders, developed webi reports and tested them by validating the data with BI InfoCubes and multiproviders using BEx queries.
• Created dashboards using multiple data connections from live office, query as a web service(QAaWS) and BICS; Designed and configured dynamic visibility and alert features to support complex requirement scenario.
• Created Master detail reports on OLAP BEx Universes by passing prompt values to the detail reports using Opendoc functionality.
• Configured the server settings to communicate with client tools such as live office, X-celsius and Query as a web service.
• Reviewed vendor patches and make recommendations upon regressively testing these patches to conduct the service pack/fix pack upgrades to servers and clients.
• Coordinated communication of planned upgrades, enhancements and maintenance outage windows in collaboration with other infrastructure teams including scheduling, coordination of testing and production readiness planning.
• Configured Business Object processing, job, destination server parameters and performance tuning to achieve a reliable system.
• Implemented Clustering to increase system availability and distribute work load along with increasing system performance.
• Performance monitoring and tuning of the environments to ensure smooth operation; Identify and resolve major performance issues and to drive best practices and maintain constant uptime.
• Assisted end users with reporting requirements gathering, designing and developing webi,deski,crystal,dashboards along with resolving access related issues.
• Supported and maintained Business Objects Servers and application suite along with administering security settings.
• Documented procedures, architecture and defined standards for maintenance of the Business Objects portal.
• Worked with respective teams for configuring backup of the system repository and FRS.

Confidential, Carlsbad, CA Business Objects Administration/Technical Lead December/2008 - June/2009 Design and analysis of projects using Business Objects XIR3, consulted with end users to determine reporting needs. Designed and built complex adhoc reports using business objects. Duties:

• Provided technical leadership for Business Intelligence XI roadmap and the direction of application projects from data capture through application design and implementation.
• Implemented the best practices for Business Objects Environment.
• Managed customer expectations to ensure strong customer satisfaction by meeting the business needs for IT systems in a timely manner.
• Provided technical oversight and subject matter expertise to Business Intelligence team on key initiatives.
• Installed and administered Business Objects XI development, pre production and production environments.
• Implemented patches and upgrades to ensure business Objects systems are up to date with latest bug fixes and patches.
• Installed WebLogic web application server and IIS web server on windows 2003, Configured iisproxy.ini to facilitate communication between web and application server.
• Supported the following Business Objects components: webi; Universe Designer; Deski; Import Wizard; Query Builder; CMC; BO in Cluster Mode; BO SDK API; Auditing.
• Implemented single sign on using LDAP security plugin.
• Facilitated meetings across departments for implementing a standard architecture for deploying Business Objects XI R3 across the entire organization.
• Implemented Best Practices for Business Objects Suite of Products.
• Worked closely with the java application team to integrate & deploy custom java web applications developed thru Java SDK's.
• Designed, implemented and maintained disaster recovery strategies and plans, work with corresponding team to plan scripts, recovery procedures for FRS backup and CMS backup.
• Extensively used Central management console CMC for user management, content management, server management tasks and Central Configuration Manager to manage local and remote servers and other administrative tasks.
• Applied row level, column level security, and other access restrictions in Universe designer.
• Configured parameters on all Processing, Cache, Job, CMS, I/O FRS, event servers using templates.
• Implemented the security in Business Objects XI environment.; Administered BO Security and users using Admin launch web application.
• Migrated content across different environment, Trouble shoot user access issues and other product related issues.
• Provided 24/7 on call support outside normal business hours as needed.
• Designed and delivered end - user training and training materials.

Confidential California, OC, CA Sr. Business Objects Administrator/Developer February/2008 - November/2009 Analysis, Design, Develop and unit test highly complex Business Object reports; Migrate reports from legacy 6.5 system to Business Objects XIR3.1 and perform regression testing.

Confidential, New Brunswick, NJ Sr. Business Objects Developer January/2007 - January/2008 Conversion of Operational data into Enterprise Data Warehouse to allow decision support system to maintain higher hierarchy, build business intelligence reports for business users to analyze the business; Enterprise data warehouse architecture consisted of staging data store, operational data store and data warehouse against business objects and crystal reports.

Confidential, Chicago, IL Sr. Business Analyst/Sr. Business Objects Developer September/2006 - December/2006 Design and analysis of INSITE Management Information System which provides client and product profitability information, assets under management, net new money formation, Cost and revenue reporting ror management accounting purposes is designed to provide insight into key business perspectives such as clients and products to support decision-making.

Confidential, Woodbridge, NJ Business Objects Administrator June/2005 - August/2006 Design, Develop and maintain the Business Objects environment in ICICI Prudential which helps the MIS analysts, Sales and Marketing teams to deal and transact with clients of Life Insurance, Group Policies, Investment etc. The operational data of different Insurance departments is loaded into a central Data warehouse and OLTP systems and farmed out to different regional data marts/Universe, the various corporate metrics/web reports & universes has been developed for different systems like agents management systems, employee claims management system(ORION), HR Department(PACE), application tracking system(ATS) & call tracking system(ATLAS) for call center.

Confidential, Houston, TX(Onsite/Offshore) Business Objects Developer September/2004 - May/2005 Design and develop In-store as decision making system in HP Portal, The different reports present in the portal are In-store Dashboard reports, PAM reports and new account reports. The data set consists of country, retailer and entity level in EMEA region. The reports analyses the overall performance of sales, product distribution, shelf share, market share etc., of HP in EMEA.

Confidential Business Objects Developer April/2003 - Aug/2004 The project is mainly developed for Investment and Sales departments of Barclay Warehouse System. The Warehouse involves investment and sales activity; data warehouse design is based on snow flake schema. The project involves development, testing and maintenance of universes, analyzing client requirement for new reports. Design and create business objects reports, support web intelligence server products and connectivity issues.

Education Bachelor of Engineering in Computer Science Actively participate in events and webinars organized by ASUG(Americas SAP User Group)