Sr. Business Objects Administrator

Over 8 Years experience in Information Technology Industry out of which nearly 7+ Years experience into installation, configuration, migrate, design, create and modify Business Objects Universes and Reports. Have extensive working knowledge of all stages of Business Intelligence development in finance, retail, manufacturing, insurance and healthcare Industries. An effective communicator with client and team members, easily interfacing between the technical and non-technical users.

Professional Summary

• Expert in Business Objects BO 4.0/XI 3.1/ 3.0/R2/6.5.
• Experience with Installing and Administration of entire hardware, and software products like Tomcat, and Apache (Clustered and Standalone environments).
• Installed and tested the BI4.0 application on sandbox.
• Worked with server team to provide them with list of specifications need to build the servers for BO4.0.
• Worked with Developers to consolidate the Business Objects repository before migrating to BO4.0.
• Expert in designing, developing, maintaining and optimizing the Universes using Designer module.
• Substantial experience in Business Objects Migration (5.1, 6.5 to XIR2/3.0/3.1/4.0).
• Effectively administered and supervised the Business Objects (SAP BI) environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports.
• Knowledge about Business Objects Security Model and experience with Business Objects Security Implementation (Row level, Object level, Command level in both 6.5 and XIR 2).
• Expertise in working with all the modules of Business Objects (All Versions including XIR3) like Supervisor, Designer, BO User, Web Intelligence, Desktop Intelligence, CMC, CMS, BCA, BO SDK and Crystal Reports.
• Expert in implementing aggregates, linked universes, drill-through and dynamic modules.
• Experience in Training & Supporting end-user reporting needs using Business Objects.
• Experience with Data Integrator for ETL (Extraction, Transformation, and Loading) of data from multiple sources database systems to Data Warehouses.
• Extensive experience in developing static and dynamic dashboards using Xcelsius 4.5 via the web service connectors like QAAWS, Live Office, XML.
• Strong experience in T-SQL, Stored Procedures, Triggers and Packages.
• Expertise evaluating the performance of SQL statements and PL/SQL modules.
• Good knowledge and experience in data warehouse development life cycle, requirement analysis, dimensional modeling, and implementation of STAR, Snowflake schemas.
• Experience in performance tuning, identify and resolve performance bottlenecks at various levels like source, target, mappings, and session.
• Experience in writing system documents, technical documents, and user documentation and also writing training materials helpful for end users.
• Strong exposure to Software Project Development full life cycle and batch processing.
• Developed and deployed Data integrations solutions for the contract information group by using Xcelsius.
• Experience in creating Dashboards using metrics and analytics.
• Experience in Business Objects XIR3.2, XIR2, XI, 6.X, Business Objects Designer, Report
• Infoview, Web Intelligence, Desktop Intelligence, Instance Manager, Query Builder.
• Installed and configured all the three environments (DEV/QA/PROD) with Business Objects XIR2/XIR3.2 with Apache and Tomcat as web and app servers on windows and Unix servers.

Education

• B. Tech in Computers Engineering.

Technical Skills

• Data Warehousing / OLAP / Business Intelligence Tools: Business Objects 5.1/6/6.1A/6.1B/6.51/XI R2/XI 3.0/ XI 3.1/4.0 - CMC, CCM, Auditor, Designer, Desktop Intelligence, Info View, Web Intelligence 2/2.5/2.6/2.7, Supervisor ,Lice Cycle Manager, Business view Manager, Java BO SDK's, Microsoft .net frame work 3.0/3.5/higher, Enterprise Performance Manager, Import Wizard, Report Conversion Tool, Publishing wizard, Broadcast Agent Server, Query Builder, Xcelsius Dashboard 2008
• Administration: Business Objects
• Operating Systems: MAC OS X/Windows 95/98/NT/2000/XP/Unix AIX and DOS
• RDBMS: Oracle 10.x/9.x/8.x/7.x/5.x, Teradata, SQL TOAD, MS Access 2000/2007
• Programming: SQL, PL/SQL, Transact SQL
• WEB/GUI: Apache, Tomcat, Web Sphere 5.1/6, IIS 4/5, Web Logic, site minder, Visual Basic
• Version Control & Others: Microsoft Excel 2000, TOAD 9.1.0, SQL Navigator

Professional Experience:

Confidential, Atlanta, GA June 12 - Till Date
Role: Sr. Business Objects Administrator
Project: BO 4.0 Installation
Project Description:
Confidential is the innovation leader in the production of polysaccharides by microbial fermentation, extraction from land and sea plants, and modification of cellulose-based raw materials. CP Kelco, has over 200 years experience in the manufacturing, manipulation and application of multiple hydrocolloids

Responsibilities:

• Solid technical understanding of Business Intelligence in general and the BusinessObjects suite of tools in particular.
• Design, build, and provide administrative/technical/consulting support for Business Intelligence solutions of Business Objects XI 4.0 experience - Central Management Console, Central Configuration Manager, BI Java Launch Pad, Life Cycle Manager, Universe Designer tool infrastructures utilized across various Client division organizations.
• Responsible for the technical analysis of requirements and design changes to existing BI4.0 Infrastructure components.
• Experienced with the installation, configuration and administration of the various BI4.0 components.Coordinate and perform customization of various BusinessObjects systems according to business needs.
• Installed Patches, Support Packs and Fix packs after the installation of the base versions according to the client needs.
• Customization of the BI 4.0 web applications like CMC and BI Java Launch pad with the company logos, favicon.
• Customized some of the attributes in the style sheet(WebIDefaultStyleSheet.css) such as Font size, Color, Cell size, Padding, Background, Border etc for Cells, Tables, Section, Break etc.
• Designed a Corporate webi template based on the corporate standards by changing the default cell size, font size, Paper size.
• Maintained & managed different versions of the same document using Life Cycle Manager.
• Be directly responsible for or coordinate the publishing of system documentation (requirements, technical specs, etc.), testing of various BusinessObjects based products prior to deployment; integration with other Client systems and processes (Windows AD & SSO).
• Responsible for project planning and task prioritization following Client's project lifecycle methodology.  
• Able to perform performance analysis of the various Business Objects infrastructure components.   

Environment: Business Objects 4.0 SP2 Patch 11, Life cycle Manager, Universe Designer, Upgrade Management tool, Oracle 11, Windows Server2008,Windows 7 64 bit.

Confidential, Bartlesville, OK Dec 11 - May 12
Role: Sr. Business Objects Administrator
Project: Upgrade and Transition (Production support)
Project Description:
Confidential is an American multinational energy corporation with its headquarters located in the Energy Corridor district of Houston, Texas in the United States. It is also one of the Fortune 500 companies and 22nd on Forbes Global 2000.ConocoPhillips is the fifth largest private sector energy corporation in the world and is one of the six super major vertically integrated oil companies. The company has announced plans to reposition its upstream and downstream businesses into two stand-alone, publicly traded corporations during the second quarter of 2012.

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outlines proposed solutions.
• Expertise in Resolving the Daily issues in the Daily Production Environment.
• Involved in full life cycle of Business Objects XIR2/R3.
• Cloned all the public folders to the new PSX 66 downstream and renaming all the folders and report names.
• BO Upgrade from XIR2 to XIR3 and also responsible for applying service pack and fix pack to BO installation and also deployed WAR files after upgrade.
• Ensured all the environments are in synchronization and checked supported environments and hardware requirements from the Products Availability Report (PAR) document for the new installation.
• Identify the servers for 3.1 Installation, Decluster the server without Apache Tomcat installation. Test CMS and CCM of independent servers, Performed Parallel installation BOXIR2 and BOXIR3 on a Clustered environment.
• Uninstalled BOXI R2 from the server to install and Removed Registry Entries with keywords such as Business Objects, business objects, busobj, bobj, Crystal Decisions, Designer, Desktop Intelligence, Web Intelligence etc before the installation.
• Installed Microsoft .net framework prior to the installation of BOXIR3.1 for successful installation of all the BO components.
• Transferred CMC data between old (XIR2) and new version either through CMC/BIAR File/Import Wizard.
• Apart from promoting info objects,used Life Cycle Manager to create,copy,Edit and scheduled a job.
• Maintained & managed different versions of the same document using Life Cycle Manager.
• Verified the remaining Business Objects installation works without any issues.
• Validated the installation by checking the public folders, Reports in Personal folders, Groups, Row level security, Scheduling and by running some sample reports.
• Troubleshoot cyrstal reports, webi reports after promotion from one environment to other.
• Created repository and security domain with user groups and security implementation.
• Extensively worked with security issues and user maintenance in XIR2/XIR3.1.
• Evaluated the possible use of aggregate tables and worked with DBA to create the aggregate tables.
• All the Scheduled report jobs were built and maintained through Info view. Output destinations include email and user BO Inbox in various formats such as PDF & Excel. Prior to the installation of BOXIR3.1.
• Involved in the Single Sign-On (SSO) application team for the Operations Updates project and used the
• BO SDK to accomplish this task.
• Migrated Universes, Reports, Securities from the Development to Production environment after System Integration Testing(SIT) and then followed by Business Acceptance Testing(BAT). Used Import Wizard for the Migration process across the environments.
• Administer and supervise the BO environment by monitoring/granting permissions and rights to vast users, creating and publishing reports and implement Folder and object level restrictions.
• Used different Web services like Live Office, QAAWS to make a live connectivity between the Crystal Xcelsius Dashboards and BO Enterprise 3.1.
• Importing the groups and users from windows Active Directory into Business Objects and granting the users and groups with appropriate rights trough Central Management Console.
• Administer and supervise the BO environment by monitoring/granting permissions and rights to vast users.

Environment: Business Objects XI R2/3.1, Business View Manager, Life cycle Manager XI 3.1, Crystal XIR2/2011 Web I 11.5, Info View, Universe Designer, Oracle 9i/10g, Windows Server2003.

Confidential, Indianapolis, IN Feb 11 - Nov 11
Role: Sr. Business Objects Administrator
Project: FSCM and Account Receivables
Project Description:
Founded by Confidential in 1876, and is now the 10th largest pharmaceutical company in the world. We have steadfastly remained independent, but not isolated. Across the globe, Confidential has developed productive alliances and partnerships that advance capacity to develop innovative medicines at lower costs. Confidential is consistently ranked as one of the best companies in the world to work for, and generations of Confidential employees have sustained a culture that values excellence, integrity, and respect for people.

Responsibilities:

• Identified and road mapped the Business Requirements (functional & technical) with the Business users, which acted as a base for the project initiation and implementation.
• Gathered Customer, User and Owner requirements; analyzed and documented them.
• Expertise in Resolving the Daily issues in the Daily doc Production Environment.
• Extensively worked with servers and server configurations and on distributed servers.
• Developed Universes in XI R3 and set up row level security for different groups in Designer.
• Worked with database connections, SQL joins, cardinalities, loops, aliases, views, parsing of objects and hierarchies.
• Created repository and security domain with user groups and security implementation multilevel hierarchies are set up enabling the drill down functionality and created Derived Tables.
• In a multi-server environment, implemented load balancing efficiently across multiple machines greatly enhances scalability and end-user response time.
• Designed universes by retrieving data from database, defining the necessary connections and exported them to specific universe domains.
• Created cascading list of values edited the list of values (LOV's) for few objects.
• Scheduling and publishing reports onto WEBI to different destinations
• Trained end users in understanding the reports. Functionalities such as Slice and Dice, Prompt, Drill mode were used for Multidimensional Formatting.
• Tuned Report Performance by creating objects and rewriting the SQL for the report variables at the universe level.
• Migrated Universes, Reports, Securities from the Development to Production environment after UAT. Used Import Wizard for the Migration process from XIR2 to XI 3.1.
• Implemented java SDK's to improve the performance.
• Expertise in using Import Wizard for taking backup's of the universes to BIAR file and migrating the Universes and Reports between different environments like Dev, QA and Production.
• Worked with installations and up gradations in the versions within the project and worked on CCM.
• Installed and Configured BO Software on client machines and created User groups and users for PROD, DEV and TEST environments.
• Providing user support and training in using Report Designer for creating Ad-Hoc reports.
• Strong technical, communication, time management and interpersonal skills.

Environment: Business Objects XI R2, Web I 11.5, Info View, Universe Designer, Oracle10g, Data Integrator XI, Windows Server2003.

Confidential, Windsor, CT July 10 - Jan 11
Role: Sr.Business Objects Administrator
Project: BOXIR2 to BOXIR3.1

Project Description:
Confidential is a leading provider of investment products, life insurance and group benefits; automobile and homeowners products; and business property and casualty insurance. The company's international operations are in Japan, the United Kingdom, Canada, Brazil and Ireland.

Responsibilities

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outlines proposed solutions.
• Identified the reporting requirements and prepare the requirements specifications document. This involved interviewing the business users and understanding the current reporting system.
• Documenting the entire effort. The documents generated during the process were Requirements Specifications, Design Document, Project Planning, Change History, Unit testing documents, and System testing documents.
• Involved in creating the Sales and Distribution, Financial Reporting, Costing, and Forecasting Universes
• Responsible for Created user-groups in CMC and implemented the security model on the groups created.
• Creation of Folders in CMC and implementing security on various objects of CMC (folders, Applications, Universe and Connections).
• Good experience in designing Universes, incorporating all the business requirements.
• Created hierarchies in Universe design to support drill down functionality in reports.
• Implement Data Level Security, based on the Divisions and Markets.
• Created Classes, Subclasses, Objects and conditional Objects.
• Maintaining Universes and Object Oriented Universe Design Techniques, working knowledge of Linked Universes.
• Experienced in creating the Aggregate tables and Aggregate awareness implementation & Aggregate Objects Creation and using in the reporting.
• Used functionalities such as sub-reports, cross-tab reports with Drill down feature of Crystal reports to generate inventory, account receivables & payables, cycle and monthly reconciliation reports for billing purposes.
• Extensively used Calculations, Sorting, Rank, and Drill down, Drill thru, Slice and Dice, Formatting, Breaks, Filters, Changing Displays and Prompts for creating Business Objects Reports.
• Publish, distribute and schedule Web Intelligence reports using Info view.
• Involved Migration from Business Objects 6.5 version to BO XIR2.
• Used Import Wizard for the Migration process. Migrated users, universes, reports and Converting Deski Reports to WEBI using Report Conversion Tool.

Environment: Business Objects XIR2, WebI, Infoview, Oracle10g, SQL Server 2007, PL/SQL, Windows 2003 Server.

Confidential, Cupertino, CA Mar 09 - Apr 10
Role: Business Objects Consultant
Project: I Chat

Project Description:
At present apple care use live person tool for chat reporting. But Live person's tool has many limitations like, reporting and data management, lack of integration to any other AC system (iLog, iDesk, Genesys, GBI, Agent Master), lack of support from Confidential, and limited ability to customize the customer experience. So to overcome these limitations Confidential will use Genesys chat reporting.

Responsibilities:

• Involved in requirements gathering from the business users to build the reporting application by working closely with architects and business analysts to understand system and business requirements.
• Perform an initial study of the current reporting application, to finalize the data elements required for reporting.
• Designing Universes, incorporating all the business requirements.
• As a BI Developer, Created Universes for report generation using Designer module in Business Objects.
• Universe construction and exporting the Universe/Reports to the Repository for automation.
• Created Classes, Objects, cardinalities, Strategies, resolved loops using Aliases and contexts and checked the Integrity of the Universes.
• Organized data in the reports by using Filters, Sorting, Ranking and highlighted data with Alerter.
• Working knowledge in implementing Aggregate awareness in universe objects and making compatibility through Aggregate navigation
• Analysis and requirement gathering for creating WEBI reports on infoview by building Universes from data warehouse.
• Created WebI reports using one or multiple data providers, merged dimensions, Union queries as per the requirement.
• Migrated Universes, Reports, Securities from the Development to Production environment after UAT. Used Import Wizard for the Migration process from XIR2 to XI 3.1.
• Developed various Reports to test the newly added objects in the universe and created regression reports for all the modified universes using Business Objects XI 3.1.
• Involved in administration and developing multiple reports in Crystal XI, Web Intelligence.
• Worked on Administration of BOXIR2 and BOXI CMC Security setup.
• Involved in Creating Repository, Creating Users and User Groups.
• Provided user support and training in using Report Designer for creating Ad-Hoc reports.
• Run report Timing Scripts to capture performance benchmark to verify that the Business objects reports (SQLs) against the refreshed database perform to expectations before/after patch installation, Oracle upgrades, environment refreshes, changes to the tables the universes are based on or when a specific request is made to capture the timings to ensure the consistent performance of the databases used by the reports.
• Used various @Functions like @Prompt (for user defined queries), @Where (For creating conditional filters), @Select, @Aggregate Aware and @Variable.
• Extensive experience in developing static and dynamic dashboards using Xcelsius 4.5 via the web service connectors like QAAWS, Live Office, XML.
• As a Universe developer had a good experience working with the offshore team.
• Tested the generated reports based on User Acceptance Test criteria.
• Designed Industry standard Business requirement document for the report development and involved in the requirements gathering process for the reporting environment.
• Strong technical, communication, time management and interpersonal skills.
• Worked with Business Users and team leads to develop system requirements, analyze data Element and continuous end-user support.
• Importing the users from Active Directory group into Business Objects and providing the users and groups

Environment: Business Objects XI R2/3.1, Web I 11.5, Crystal Reports2008/XI/10, Crystal Xcelsius2008, Info View, Universe Designer, Teradata, MAC OS X, Windows Server2003.

Confidential, Carry, NC Nov 06 - Feb 09
Role: Business Objects Administrator
Project: Financial and Sales Reporting Systems

Project Description:

Confidential distinguishes itself by offering personalized attention to our customers' needs and Requirements. The job involved working on several projects aimed at automating all Financial and Sales management tasks. Responsibilities included: working with end users and business analysts in understanding business requirements, defining business objects and managing development process for the project life cycle.

Responsibilities:

• Gathering the Functional and Business requirements.
• Responsible for creating use case diagrams and work flow charts.
• Administrating, maintenance, security management and production supporting on various platforms like Windows NT/2000/XP/98.
• In UNIX environments, used shell scripts to install and configure each of the system services on the available hardware.
• Managing the User rights on Business Objects Applications like Desktop Intelligence, Web Intelligence, Designer, Dashboards etc and Folder Security for different groups of Users.
• Worked extensively on distribution, maintenance, and optimization of universes for Business Objects and Web Intelligence deployments.
• Extensively worked in all phases of the project such as developing, configuration testing, Migrating,
• Generated and Published web reports in Info View using Web Intelligence.
• Scheduled the reports according to the user requirements based on the Oracle database connectivity.
• Performed a migration prototype from Business Objects 6.5/XIR2
• Migrated reports from business objects 6.5 to business objects XIR2 and fixed the issues during the migration and after migration.
• Migrated users, categories, groups, reports, folders, Universes, security models from Business Objects 6.5 version to Business Objects XI R2.
• Creation of Folders in CMC and implementing security on various objects of CMC (folders, Applications, Universe and Connections).
• Involved in performance tuning of Business Objects Full Client and WEBI reports and published reports to WebI.

Environment: Business Objects 6.5/XIR2, BO (Designer, Supervisor, CMC, CCM), TOAD, MS SQL Server 2005, Unix.