We provide IT Staff Augmentation Services!

Business Objects Developer Resume

SUMMARY:

  • Over 8 Years experience in Information Technology using Business Intelligence Tools, Business Objects (BOBJ)Tools in various versions- BI4(BOBJ 4)BO XI 3.1/R2/R1/ 6.5.1/ 5.1, SAP BW on Windows and UNIX Environments.
  • Experienced in Developing Webi, Deski , Crystal , Webi Rich Client and Xcelsius Dashboards
  • Developed WEBI report/dashboards/Universes(using IDT) in BI4 Environment.
  • Development WEBI BOBJ 3.1 using advanced features including Database Delegated (Smart Measures), Hyperlinks, Delegate Search, Data Tracking, Input Controls and Merge Dimensions.
  • Experienced in developing complex reports using Business Objects Webi Rich Client & Crystal Reports Enterprise having Parameter/Formula Fields and Selection Formulas, Grouping and Sub reports.
  • Tuned and Enhanced Universes with SQL Queries for the Report Performance.
  • Created Web Intelligence Ad-hoc and canned reports.
  • Created dashboards with multiple hyperlinks to various reports using Open Document Syntax.
  • Experience in Building Dashboards for Visual Representation of Data using Crystal Xcelsius 2008 SP3/4.5 using Qaaws, Live Office, XML, Flash variables and SAP BW Net weaver as Source connections.
  • Developed flexible queries using filters, navigational attributes in BEx Analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.
  • Installed Business Content including DataSources, InfoSources, InfoCubes, ODS objects, Update Rules and Queries.
  • Installed Crystal Xcelsius 2008 SP3 and developed dashboards using various components.
  • Developed Xcelsius 2008 Dashboards on top of Qaaws and Live Office connections.
  • Implemented Open Doc to drill down to detail WebI report from Xcelsius Dashboard.
  • Installation of third party web servers including Web logic, Web sphere and Tomcat
  • Defined Security – Users/Groups/Folders based on Business Model
  • SAP Integration with BOBJ
  • Experienced in Production Support role 24/7 to resolve the issues using a trouble ticket system
  • Created Universes using complex and advanced features from various Database sources including Oracle, SQL Server, DB2, Teradata, Sybase and SAS
  • Efficiently mapped business requirements and processes to technical solutions.
  • Expertise in designing Universes for Performance Management and Reporting needs.
  • Experienced in developing Web Intelligence, Desktop Intelligence and Crystal Reports using different Data Sources.
  • Expertise in dimensional data modeling, Star Schema Modeling, fact and dimensional table design, physical and logical data modeling.

Professional Experience:

Confidential
SAP/Business Object Consultant Oct’10-Present
Responsibilities:

  • Involved in collecting requirements, Interacted with prospective clients to gather their analytical requirements, which are very important to customer.
  • Responsible for understanding end user requirement and convert into functional requirement and involved in preparing project plan.
  • Designed, developed, maintained and tested universes for supporting ad hoc queries and canned reports according to the business requirements.
  • Interacted with Users to know their Business views while gathering the Report requirements and provided Several Report Mock-ups to finalize the requirements.
  • Extensive knowledge of working with company specific proprietary software and third party Software .
  • Created Technical Specification requirements (use cases, interface specifications) by translating business requirements
  • Designed the BEx Queries in the BW Environment.
  • Extensively used BEx analyzer to create queries, variables, filters, calculated key figures, restricted key figures, charts and workbooks.
  • Created Dash boards for the top level Management using SAP BW (Bex queries).
  • Exported Xcelsius to repository to make it available for users through info view.
  • Created WSDLs using Query As a Web Service (Qaaws) from different Data sources and implemented WSDLs into Dashboards.
  • Implemented Open Doc to drill down to detail webI report from Xcelsius Dashboard.
  • Designed, developed Universes and Webi Reports.
  • Developed flexible queries using filters, navigational attributes in BEx Analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.
  • Created web reports through report template in Web Application Designer.
  • Converted business requirements in business/technical requirement documents.
  • Designed web intelligence reports for dimensional hierarchical data
  • Involved in unit testing and User acceptance testing.
  • Deployed the reports to CMC for the users to able to see the reports in Info View and run, schedule and view the reports in different formats (PDF, Excel)
  • Wrote formulas, parameters and conditions depending upon selection criteria.
  • Implemented dynamic cascading prompts and defined business views
  • Involved in Modifying and Performance tuning of the Existing Reports.
  • Created the reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s etc.
  • Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
  • Developed reports specific with these Delegated Search, Database Delegated, Open Document and Data tracking new functionalities.
  • Published Reports to CMC (Central Management Console) and involved in Scheduling and exporting the reports in different Formats.

Environment: Business Objects XI R2, 3.1, Crystal Xcelsius , Windows 2003,SAP 4.7, ECC 6, Windows XP.

Confidential, Dec’08to Sep’10
SAP/Business Objects Consultant
Responsibilities:

  • Interacted with Users to know their Business views whilegathering the Report requirements and provided Several Report Mock-ups to finalize the requirements.
  • Converted business requirements in business/technical requirement documents.
  • Integrated Business Objects Reports and Dashboards to Third Party Portal using OpenDoc functionality.
  • Defined security models with row level data security, role based security etc in Business Objects Universes and Central Management Console (CMC)
  • Created users, groups, server groups and setup security architecture.
  • Implemented Row Level, Object Level security for data restriction at Universe level.
  • Developed Webi, Deski , Crystal , Webi Rich Client and Xcelsius Dashboards
  • Developed BOBJ 3.1 using advanced features including Database Delegated (Smart Measures), Hyperlinks, Delegate Search, Data Tracking, Input Controls and Merge Dimensions
  • Experienced in developing complex reports using Business Objects Webi Rich Client & Crystal Reports Enterprise having Parameter/Formula Fields and Selection Formulas, Grouping and Sub reports.
  • Tuned and Enhanced Universes with SQL Queries for the Report Performance.
  • Created Web Intelligence Ad-hoc and canned reports.
  • Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard.
  • Created Xcelsius Dashboards for Sales and Product level data based on Product Age & Usage using various components of Xcelsius.
  • Created WSDLs using QaaWS (Query as Web Services) and implemented into Xcelsius dashboards.
  • Created Pseudo dashboards one report having multiple hyperlinks to various reports using Open Document functionality from Dashboard to Webi Report.
  • Using Flash variables passed the parameters from Parent Dashboard to Child Dashboard.
  • Written SQL queries have been used on the Universe and created as Derived Tables.
  • Wrote Complex SQL Queries for Data validation purpose.
  • Tuned and Enhanced Universes with SQL Queries for the Report Performance.
  • Created Views, Stored Procedures and validated data for the Performance.
  • Created Web intelligence reports in Advanced and Interactive mode using all the functionalities
  • Developed Business Views on top of universes
  • Created complex reports in Deski, using multiple Data providers.
  • Converted Deski Reports to Webi using Report conversion tool for enhancements
  • Created Derived Tables in Universe to meet specific requirements for Webi Reports and Dashboards.
  • Used OpenDoc functionality to drill down from Xcelsius dashboard to Webi Reports.

Environment: Business Objects XI R2, 3.1,Auditing, SDK, LDAP, Crystal Xcelsius , Oracle 10g,SQL Server 2000 & 2005, SSIS, Teradata,Web logic 10 and Windows 2003,SAP 4.7, ECC 6, Oracle 9i, Windows XP, Unix, Java

Confidential, Feb 2007 – Nov 2008
Business Objects Admin&Developer

  • Installed and configured Business Objects XI R2 on both Windows.
  • Documented user requirements, translated Functional requirements into Technical Requirements and develop implementation plan and schedule.
  • Installed and configured BOE XI R2 on Windows to test the functionality between XI R1 and XI R2.
  • BOBJ SDK used for customization BOBJ reports access through portal.
  • Worked in STTP Production Support and maintained Business Objects environments.
  • Involved in Tuning and server configurations for different environments.
  • Applied Service Packs and Fix packs to stabilize Server environments.
  • Creating Derived tables at universe level to resolve report level complexity.
  • Developed universes to accommodate complex database design approaches.
  • Tuned and Enhanced Universes with SQL Queries for the Report Performance.
  • Streamlined SQL generation from Universes by implementing Aggregate Aware functions and @ Variables.
  • Created highly formatted reports to visually represent data..
  • Created Deski & Webi Reports using all the BO functions like Drill Down, Prompts, Dimensional and Measure variables to show accurate Results.
  • Created live reports in a drill down mode to facilitate usability and enhance user interaction.
  • Developed Dashboards using Crystal-Xcelsius with data source as Live Office.
  • Developed and maintaining of two Projects with individual responsibilities.
  • Developed customized Webi reports as a source data for Live Office.
  • Collecting report & Visual requirements from users/business owner.
  • Enhanced the Performance of the Dashboards by manipulating and using complex formulas on the Universe and Excel.
  • Troubleshooting and rectifying Universe, Webi & Live Office errors.
  • Worked in the Team closely with Functional Architect, DBA and Analysts to get a clear understanding on the Application.
  • Developed Report Mock-up samples before User interaction to analyze the business requirements.

Environment:Business Objects XI R2,Audit, Crystal Xcelsius 4.5, Live Office, Oracle Database, PL/SQL, SQL scripting and Windows 2000 server

Confidential, Nov 2004 – Jan 2007
Business Objects Developer
Responsibilities:

  • Installed and Configured Business Objects on Both Client and Server Installations.
  • Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard.
  • Installed Business Objects XI R2 on Solaris with Tomcat and Apache.
  • Converted reports from 6.5.1 to XIR2 using the report conversion tool.
  • Automated ccm.sh UNIX scripts by using UNIX shell scripting.
  • Worked on the WEB.XML file on the application server to enhance auto user logout from infoview with the parameter customization and then users are redirected to a custom JSP page.
  • Changed the infoview page layout by adding new features like the company details instead of the Business Objects logo by using the customization methods.
  • Created user defined @prompts and complex conditions at Universe level for better performance.
  • Created Reports using all the BO functions like Drill Down, Prompts, Dimensional and Measure variables to show accurate Results.
  • Generated Full client Reports from Different Data Providers in Business Objects using Oracle Database.
  • Created Compound Analytics, Charts and Goals on the Dashboard Manager.
  • Created Universes for Customized Metrics and Goals to Create Metric Analytics and Goal Analytics.
  • Scheduled Metrics and Analytics to refresh for a scheduled time.
  • Created Analytics on top of Metrics for the Performance Manager.
  • Opened tickets in the Tracker for Reporting purpose to track all the Report statuses purpose.
  • Created Derived Tables in the Universe using views and stored procedures to meet the Desktop Intelligence Reporting Requirements.
  • PM repository development and Metrics development.
  • Created Cascading Prompts on the Reports.
  • Implemented Filters, conditions in the Universe to the run the Reports quickly.
  • Created single sign-on for many reports using the URL functionality to access them directly for upscale users.
  • Created Analytic Dashboards for upscale users on the Financial Actual Budget and Target Budget.
  • Created Metrics, Metrics lists and used different analytics.
  • Written SQL queries have been used on the Universe and created as Derived Tables.
  • Wrote Complex SQL Queries for Data validation purpose.
  • Tuned and Enhanced Universes with SQL Queries for the Report Performance.
  • Created Views, Stored Procedures and validated data for the Performance.
  • Created hundreds of reports in thin client and full client using all the functionalities
  • Used the Export option for the Reports to schedule them in Broadcast Agent Server and sent the scheduled reports via Email, Text and Excel formats.
  • Used the Broadcast Agent Server to Schedule and Monitor the Reports.
  • Prepared Documentation to understand how the reports will work and how to use the functionality with step by step.
  • Prepared universe for Ad-hoc query functionality to educate users. Allowing them to run queries to create some reports using objects in the universe.
  • Audit reporting system implementation on UAT and Production Environments.
  • UAT was one of the important processes that we had developed during this project.

Environment: Business Objects 6.5.1, XI R2, Oracle 10g, DB2, Sun Solaris and Web Logic.

Hire Now