Sr. Business Objects Consultant

Professional Summary:

Over 7+ years of professional IT experience in the areas of designing, developing, modifying and migrating Business Objects (BOBJ) Universes and Reports on Windows and UNIX platforms. My Strengths include:

• Worked through all phases of Business Intelligence projects (SDLC & Agile) including analysis, design, development, testing, debugging and post production support. Involved in documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Experience in working Business Intelligence using SAP Business Objects XI-4.0/3.1/R2/6.x with Info view, Web Intelligence, Data Integrator, Webi Rich Client, Desktop Intelligence, Crystal Reports 9/10/XI/2008 Xcelsius 4.5/2008, life cycle manager, Central Management Console (CMC), Central Management Server (CMS), Central Configuration Management (CCM), Query as a Web Service, Live Office, Business Explorer/Polestar XI 3.1, Publishing Wizard, Import Wizard and Report Conversion Tool.
• Excellent business analysis skills and comfortable working with business users to understand workflow and processes in order to elicit business requirements.
• Good knowledge of Oracle data bases - Views, Materialized views, indexes, stored procedures, functions, triggers.
• Experience in Designing/Developing the User-Interface (Universe/Data-Model), Developing Canned/Ad-hoc Reports, Scheduling and processing of reports using Broad Cast Agent and Supervisor.
• Good understanding of R4 implementation - Explorer, BI Launch Pad, Information designer, Crystal 2011.
• Defined and established enterprise level Business Objects best practices and standards and documentation
• Good knowledge of using TOAD, SQL Editor to analyze data structures and understand table relationships.
• Experience in performance tuning Universe and Crystal reports SQL's to improve performance by modifying the queries, using indexes, creating materialized views, passing hints etc.
• Good understanding of Business Objects .net SDK to call crystal and WebI reports using Open Doc commands
• Excellent experience in designing Business Objects universes, complex BO reports both full client and Webi Reports.
• Performing Migrations from earlier versions 5.x, 6.x to XI R1/R2 architectures and recreating security Models.
• Extensively worked on Business Objects Architecture & Administration. Created Users and Groups and setting the rights on them using Central Management Console (CMC).
• Used Live Office and QaaWS (Query as a Web Service) to feed live data into Xcelsius 2008 (both Dashboards & Scorecards)
• Extensively worked on Crystal reports with different functions such as running totals, conditional formatting, drill down, linked sub reports, parameters.
• Involved in analyzing Hyperion intelligence and Brio reports and convert them to crystal reports and use the logic BO for universe development.
• Extensive experience with SAP BW integration and using BEx Query designer, BEx Analyzer.
• Extensive knowledge in SQL & PL/SQL programming and trouble shooting.
• Solid ETL knowledge. Involved in designing BODS mappings for loading data to data warehouse and data marts.
• Developed test cases to perform unit testing and integration testing of business objects reports.
• Good at understanding data warehouse design principles, database design, and dimensional data modeling.
• Excellent communication, interpersonal, training, analytical and technical skills.

Technical Skills:

• Reporting Tools: Business Objects XI4.1/3.1/XIR2/6.x/5.x (CMC, Designer, Reporter), Web Intelligence XI/6.x/2.x, Info View, Explorer, Dashboard Manager, Voyager, Xcelsius, Life Cycle Manager, QAAWs and Crystal Reports XI/9.0, Java/.net SDK.SSRS, Cognos8 (Framework manager, Report Studio, Query Studio, Analysis Studio, Cognos Connection, Dashboards), Brio Intelligence.
• ETL Tools: BO Data Integrator/Data Services BODI 12.2,11.7.3/11.7.2/,6.5 ; Informatica 5.1/6.1/7.1/8.0 (Power Mart/Power Center).
• Operating Systems: Sun Solaris 8/9, Unix and Windows NT/2000/2003/XP.
• Languages: Java, C, C++, SQL, PL/SQL, Visual Basic 6.0, UNIX Shell scripting, XML, VB, ASP
• RDBMS: Oracle 10g/9i/ 8i/, SQL Server 2000/05/08, DB2, MS Access, Teradata, MySQL 5.0/4.1.
• Tools: ER Studio, Erwin 4.1, TOAD, SQL* PLUS, Quality Center, Service Center, Remedy

• Bachelor of Technology in Computer Sciences.

EXPERIENCE:

Confidential, FL Jan 2012 - Till Date
Sr. Business Objects (BOBJ) Consultant

Responsibilities:

• Worked with Business Analysts and Super Users to understand business requirements and design BI solutions using Business objects Universes and Reports.
• Used Designer to create universe(set universe parameters, link tables, create classes, classified objects into classes based on business logic, createcontexts and aliases to avoid Chasm trap , Fan trap & loop problems, create derived tables, create hierarchies)
• Good SQL skills to understand and analyze teradata systems and develop business objects universes
• Developed prototype universes to demo the adhoc querying capability by consolidating multiple disparate data sources and after performing source table analysis
• Designed Universe by creating the Business Objects Data Model selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the objects like Dimensions, Details and Measures which are grouped into Classes and checked the integrity of the universe.
• Developed adhoc reports in working with Business Objects WebI with visualizations(analysis) with associative data (created filters to affect and show/hide bubble charts, bubble charts, scatters, line charts and other objects)
• Used @aware Functions, filters with Multi dimensional expressions(MDX), conditions, list of values (LOV), calculations, etc Created Objects, Predefined Conditions, and Isolated Joins in the Universe.
• Led the effort to modify crystal reports from using stored procedures to command objects and dynamic cascading prompts. This involved analyzing the stored procedures to understand the sql and rebuild it
• Implemented row level and object level security in business objects universe using @BOUSER variable, creating over ride groups in universe designer and assigning them to BO user groups.
• 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.
• Used Prompts in the reports as well as the Universe to create more interactive reports for the users.
• Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Webi.
• Extensively used Calculations, Variables, Break Points, Drill and complex queries for creating reports.
• Built reports using multiple data providers, external data providers and used merge dimension functionality. Synchronized queries from multiple data providers by linking the common dimensions using merge dimensions option in Webi.
• Used database ranking, ranking on report level, alerter, input controls, report filters and section functions to build reports. Created different types of reports, like Master/Detail, Cross Tab and Chart (for trend analysis).
• Developed Web Intelligence reports making use of combined Queries (Union, Intersection, Minus).
• Developed universe user documentation guide for the end users reference. Provided training for end users for generating their own report including complicated report.
• Created crystal reports using pivots tables, groups, sub groups, complex formulas, running totals, parameters, charts, cross tabs in both sql command and in linked tables.
• Involved in business objects support and administration. Debugging long running reports in business objects server and killing the process to unblock other priority reports.
• Created Business Objects folders and users, assigned security. Created report schedules with broadcasting to users inboxes, emails on a periodic basis.
• Configured ODBC connections to migrate reports across different environments.
• Created User Conditions and Filters to improve report generation & readability of report and displayed the summary of data by creating Charts.
• Configured single sign on windows AD authentication for logging in business users.
• Familiar with Mercury Quality Center, Service Center and Remedy.
• Involved in Documentation of the project, which includes Requirement specifications, Design document, and Project Planning.

Environment: Business Objects XI 3.1/R2 (CMC, Designer, Web Intelligence Rich Client, Import Wizard, Publishing Wizard), Crystal Reports 2008, Hyperion Intelligence 8.5/8.1, Info View, Xcelsius 2008, Oracle 10g, 9i, SQL Server 2008, QAAWS, Live Office, Window XP SP3, Teradata.13.0.

Confidential, Houston, TX Aug 2010 - Jan 2012
Sr. Business Objects (BO) Consultant

Responsibilities:

• Installed and configured BO XI 3.1 Software on windows environment and created user groups and users of PROD, DEV, TEST environments.
• Created Universes using Designer according to the business requirements. Clearly defined the different object types including Dimensions, Details and Measures in universe and fine tuned for better performance.
• Build universes with Derived tables using complex SQL's and to provide relative dates capability from disparate sources
• Designed complex universes which take user inputs using cascading prompts, defined global filters with MDX to support data security.
• Worked on customer service reports, Operational Scorecards, Budget Scorecards, Sales Views, Budget Views for Business Units and Supplier Partners. Designed complex BEx queries and built reports using BEx analyzer, web.
• Worked on legacy applications and modified existing Hierarchies in the universes to meet drill analysis of the user's reporting needs.
• Improved the performance of Business Objects adhoc reporting and high DB queries using BI Accelerator
• Used BIA for existing indexes and configured activation and filling, created new indexes with activation
• Worked with .net developers to configure Business Objects SDK and execute parameterized crystal reports
• Created single or multi line chart for showing tendency over a period of time particularly used in revenue history using Xcelsius 2008. Used QAAWS and Live office functionalities of BO to pull Data from SAP Universes and Bex Queries.
• Created graphical representation of reports such as Bar charts, 3D charts, Pie charts, Column chart, Line chart, and Bubble chart using Xcelsius 2008.
• Modified hyperion intelligence reports to create reports, add pivot tables, add new formulas to support business.
• Involved in performance tuning and optimization of Business Objects universes by creating aggregate tables.
• Created new classes, objects and made structural changes to universes in Designer.
• Defined Alias and Contexts to resolve loops and also tested them to ensure that correct results are retrieved.
• Created reports using business objects functionalities like drill down, @functions cross tab, chart, master/detail, and formulas. Created objects using case statements. Created custom hierarchies to support drill down reports.
• Involved in Administration to Schedule and monitor reports at the server level. Supervised the business objects environment by monitoring granting permissions and rights to users for viewing, creating and publishing reports and implement row and object level restrictions.
• Involved in working with different database environments and in migrating the universes and reports between Production, Development, and Test.
• Involved in Unit testing, System testing and User Acceptance Test (Universes and Reports) throughout the process.
• Defined Report Level Ranking, Database Ranking and Alerts in Reports based on the specifications.
• Applied most advanced Business Objects functionalities like conditional hiding, ranking, hyper linking, conditional sorts, alerter etc.
• Supported existing ETL daily loads and debugged failed packages. Determined the root cause and channeled it to the source data discrepancy.
• Performed rigorous source data analysis to determine load criteria. Designed sql * loader to load staging area.
• Designed and built Universe, reports using Webi, Crystal Reports 2008 on the top of the SAP BEx queries.
• Created Style-guide, Templates & Technical Designs for the Xcelsius 2008 Deliverables.
• Created Metrics and Analytics for the dashboard and incorporated Drill down option and extensively used Alert Analytics, dynamic visibility while creating the Dashboards.
• Extensively used Alerts while creating the Xcelsius Dashboards and used Functions like VLOOKUP, HLOOKUP for while pivoting the Data to Crystal Xcelsius Designer.
• Created WSDLs using Query as a Web Service (QAAWS) from different Data sources.
• Created Queries with Live Office and Query as a Web Service by connecting to the Required Universes in order to get the data into Excel. Developed dashboards and scoreboards for detailed analysis.
• Created parameterized Crystal reports and customized existing reports for presentations using Cross-Tab reports, Sub-reports, Visual Basic syntax to create formulas for the reports.
• Debugged Business objects Enterprise( BOE) for data consistency, performance tuning and data validations.
• Worked with performance tuning tools to improve the performance & Involved in preparing detailed documentation for reports, migration of reports as well as universes developed.

Environment: Business Objects 3.1/R2 (CMC, Designer, Web Intelligence Rich Client, Import Wizard, Publishing Wizard), Business Objects .net SDK, , SAP Netweaver BI Accelerator Crystal Reports 2008,Hyperion Intelligence 8.5/8.1, Oracle 10g, SQL Server 2005, Info View, Xcelsius 2008, QAAWS, Live Office, Window XP SP3, Teradata.13.0.

Confidential, Providence, RI Jul 2009- Aug 2010
Sr. Business Objects Consultant

Responsibilities:

• Worked with business analysts and end users to understand their reporting requirements. Responsible for gathering and analyzing source date for enterprise data warehouse schemas based on the requirement.
• Worked extensively with Derived tables and @functions (@aggregate aware, @select, @prompt, @where) in the creation of dimensions, measures and conditions.
• Implemented row level security for different groups by designing security table. Implemented object level security by hiding universe objects using security groups.
• Led the effort to consolidate multiple hourly schedules running for the same report by different users. Configured Business Objects historic instances are limited to user requirements.
• Experienced in Tuning SQL Statements and Procedures for enhancing the load performance in various schemas across databases. Tuned Universes(BOE) for Report level performance.
• Created Reports using Webi Intelligence, used multiple sources to create reports, Combined Queries, Slice and Dice, Drill Down, cross tab and Master Detail Reports to provide interactive reports.
• Created Reports using all the BO functions like For Each, For All, Drill Down, Prompts, Dimension and Measure variables to show accurate results. Created alerts, filters and inserted Breaks while designing reports.
• Used prompts and cascading Prompts to make the reports confined to a particular case as per the business Requirement.
• Developed crystal reports for applications with parameters, applications use business objects sdk calls to pass parameters and render the report in the required format.
• Provided level 2 support for all end user crystal and business objects reporting queries - include access requests, data base configurations, technical support on developing formulas in crystal.
• Extensively performed reports query analysis to identify slow running queries and ensures performance improvement.
• Revised the Group Structure in both Development and Production Environments.
• Conducted training sessions to educate users about using the Business Objects tools and also about the user management.
• Imported existing users, groups, categories, Webi documents, connections, universes and restrictions to BO XI environment. Manually scheduling the recurring reports.

Environment: Business Objects XI R 3.1/R2(CMC, Designer, Webi, QAAWS), SAP BW 3.5 , Crystal Professional XI R2, Xcelsius 2008, BODS/BODI,SQL 2000/05,Oracle 9i, Window 2003 Server/XP, and SAP NW Portal.

Confidential, Jacksonville, FL Apr 2008 - Jun 2009
Sr. Business Objects Consultant

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Involved in Installation, Configuration and Administration of all products of Business Objects.
• Developed table profile documents to establish source and target table relationships.
• Created dependencies on ETL packages and scheduled them to load daily. Loaded monthly snapshots tables.
• Designed and developed Universes by defining joins, cardinalities between tables, linked the existing Universes using Business Objects Designer. Resolved loops by creating Aliases & Contexts and checked integrity of universes.
• Customized LOVs in Universes for quicker performance of reports.
• Used Designer as a part of Universe Development for Defining the Parameters of Universe, Inserting the table, making Isolated Joins, Resolving Loop\'s, Creating Classes, and Objects.
• Involved in creation of Filters, @prompts and setup Hierarchies for Multidimensional Analysis.
• Experience in universe migration across repositories. Involved in migrating reports and universes from 5.x to 6.5 and WebI reports using the report migration utility.
• Created various reports like Master/Detail reports, Cross Tab reports, Slice and Dice reports, Charts using Freehand SQL and Stored Procedure as data providers.
• Created and maintained Business Objects & Web Intelligence reports. Created reports based on PL/SQL.
• Exported the Reports to the Broadcast Agent and used the Broadcast Agent server to Schedule and Monitor the Reports which offered robust performance and ability to balance Loads.
• Generated analytical reports using Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae features.
• Automated document Scheduling, Publishing and Distribution for Webi using Broadcast Agent server. Used Supervisor to Grant User rights and roles etc.
• Developed crystal reports using stored procedures, database tables etc. Used crystal syntax formulas extensively to implement business logic.
• Excellent data debugging skills. Identified and coded test scenarios to unit test crystal and WebI reports.
• Involved in optimizing the universe developing time and SQL Tuning to increase the query performance.

Environment: Business Objects XI R2, Crystal Enterprise XI/X, SQL SERVER 2005, Oracle 9i, Web Intelligence XI R2, and Desktop Intelligence, Windows Server 2003.

Confidential, Newport Beach, CA Apr 2007- Mar 2008
Business Objects/BO Consultant

Responsibilities:

• User interaction was one of the key aspects of the project to understand their needs to develop universes and reports.
• Defined, Developed, Deployed and maintained Business Objects Universe and reports for multiple projects.
• Created several new reports and modified existing reports in Business Objects.
• Actively involved in creating new users/groups, user profiles were maintained with pre-defined settings, access to different documents was controlled.
• Loops in the universes were resolved by applying the combination of aliases and contexts.
• Integrity check was done before the Universes were made accessible to the end users. Optimized SQL queries for better performance.
• Supported existing ETL daily loads and debugged failed packages. Determined the root cause and channeled it to the source data discrepancy.
• Created Adhoc and Canned reports in full client version.
• Few graphs in the reports were created using slice and dice and cross tab tables. They involved bar graphs, pie charts etc. Standard company templates were applied to the reports.
• Handled production tickets, research and follow-up and resolution activities.

Environment: Business Objects XI R2, Crystal Enterprise, SQL server 2005,Oracle 9i, Web Intelligence and Desktop Intelligence, Info view, CMC, PL/SQL, Supervisor, Broad cast agent. .

Confidential, India. Jan 2005 - Mar 2007
Business Objects Developer

Responsibilities:

• User interaction was one of the key aspects of the project to understand their needs to develop universes and reports.
• Developed table profile documents to establish source and target table relationships.
• Created dependencies on ETL packages and scheduled them to load daily. Loaded monthly snapshots tables.
• Developed PLSQL Stored Procedures and functions for loading data to data marts and staging area.
• Worked on legacy applications and modified existing Hierarchies in the universes to meet drill analysis of the user's reporting needs.
• Created new classes, objects and made structural changes to universes in Designer.
• Involved in working with different database environments and in migrating the universes and reports between Production, Development, and Test.

Environment: Business Objects 6.5.1,Web Intelligence, MS SQL Server, Brio 6.0, PL/SQL, Oracle 9i, Windows 2000, Dream weaver, HTML.