Sr. Bo Consultant/admin Resume
Dallas, TX
SUMMARY
- Over SEVEN years of extensive experience in all phases of Software Development Life Cycle (SDLC) such as requirements gathering, designing, developing, testing, implementing and production supporting Reporting/Business Intelligence solutions using Business Objects XI Release3.1/R2/XI/6.5, databases: Oracle 11g/10g, SQL Server 2008, Teradata.
- Extensive experience in designing & developing Universes, complex reports using Business Objects Suite tools: Universe Designer, Web Intelligence and Desktop Intelligence, CMC, Infoview.
- Experience in developing universe using different Data Sources - Oracle 11g/10g, SQL Server 2008.
- Extensive experience in using Business Objects features like Drill Through, Slice and Dice, Cross Tab, Master Detail and Report level variables for the preparation and analysis of reports.
- Proficient in designing Star Schema.
- Exposure in designing the interactive dashboards using Xcelsius tool.
- Exposure to Business Objects Administration.
- Experience in interacting with business users to analyze the business process and requirements and transforming requirements into screens, documenting and rolling out the deliverable.
- Adept in providing end-user training and developing documentation for reporting.
- Created the users / groups / roles / assigning the users to groups through CMC (Central Management Console).
TECHNICAL SKILLS
Reporting Tools: Business Objects XI R3.1/R2/6.5 Tool Suite (Universe Designer, Web Intelligence, Desktop Intelligence, CMC, Infoview), BO Xcelsius.
ETL Tools: Informatica 8.6.
Databases: Teradata, Oracle 11g/10g, MS SQL Server 2008/2005/2000 , MS Access.
Operating System: Windows 2003/2000/98 , UNIX, Linux.
Languages: SQL.
Others: TOAD 10, MS Office 2007.
PROFESSIONAL EXPERIENCE
Confidential, Dallas, TX
Sr. BO Consultant/Admin
Responsibilities:
- Directly coordinating with users to gather the new requirements and working with existing issues.
- Designed Universes creating classes, objects, measures, universe level filters.
- Created Objects and prepared Reports like financial reports, HR reports, and standard adhoc reports.
- Resolving the loops using aliases and contexts.
- Prepared other reports by using master details, cross-tabs, slice and dice and drill mode as per the requirement of the end-user.
- Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
- Generated the Business Objects reports involving complex queries, sub queries, Unions and Intersection.
- Performed unit testing, system testing and user acceptances test (UAT) for universe, reports and security management.
- Developed universe user documentation guide for the end users reference.
- Requirement Gathering for new issues or enhancement requests received from business users.
- Ensuring the data quality post resolution of defects and enhancement request.
- Data Analysis in production environment.
- Co-ordination of production activities and support.
- UAT co-ordination.
- Managing the various services through CMC as part of Admin role.
- Data validation to ensure data quality.
- Interacts with the various business teams to ensure the availability of sources for ETL.
- Cleaning the repositories like orphaned connection, universes, and documents.
- Managing the users / documents through CMC.
Environment: SAP Business Objects XI 3.1, Web Intelligence, Infoview, Desktop intelligence, Designer, Teradata V12.0, Windows XP, PL/SQL.
Confidential, Trenton, NJ
Business Object Consultant and Administrator
Responsibilities:
- Creating, developing, maintaining and testing the Universe for running the queries against the Database.
- Created Repository and assigned privileges to users and groups using Supervisor.
- Analyzed the existing database and designed Universes using Designer module for generating reports.
- Used various data providers like Freehand SQL and Stored Procedures to extract data from different sources and tuned for better performance.
- Resolved loops by creating Aliases & Contexts and checked integrity of universes.
- Worked on Query Panel, Prompts, Report Layout and Re-formatting.
- Involved in development and deployment of Complex Reports.
- Creating users, groups through CMC, assigning Roles to users and assigning to Groups.
- Managing services for optimal performance of the servers.
Environment: SAP Business Objects XI 3.1, Web Intelligence, Infoview, Desktop intelligence, Designer, Teradata V12.0, Windows XP, PL/SQL.
Confidential
Business Object Consultant
Responsibilities:
- Designed and created various Business Objects reports as per the user specifications.
- Created complex reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements.
- Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
- Designed Universe creating different Classes, Objects, measures with filters and prompts.
- Exported the Universes to the Repository to make resources available to the users for ad-hoc report needs.
- Provided the security access management by creating users/groups and folders.
- Involved in project cycle plan for the data warehouse, analyzing the source data, deciding the exact data extraction, transformation, loading strategy.
- Converting functional specifications into technical specifications. Unit and system testing of the Business Objects reports and documenting in technical specifications.
- Wrote test plan, test cases and test scripts and provided documentation for future enhancements.
- Identifying test scenarios and prepared test data for unit and system testing. Executed test scenarios in different test environments. Analyzed the test results from various team members and identified potential errors and helped resolving the defects.
- Supported by assisting and training end users in Business Objects.
- Creating the dashboards in Xcelsius like Pie Chart, Interactive Dashboars using Slider etc.
Environment: Business Objects XI R3.1/R2 Tool Suite (Universe Designer, Web Intelligence, Desktop Intelligence, Infoview, CMC, Xcelsius), UNIX, Oracle 11g/10g, TOAD 7.6.
Confidential, Whippany, NJ
BO Consultant
Responsibilities:
- Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
- Designed, developed and managed Universes in Business Objects Designer for generating the pay roll reports for sales, marketing reports for marketing group users.
- Interacted with customer support regularly, in order to generate the reports required and to resolve the existing issues.
- Created Universes by defining connections and retrieving data from database.
- Creation of various complex BO reports like Reports by Period, Demographic reports and Comparative Reports.
- Created New Classes and User Objects in designing the universes.
- Generated various reports on Daily, Weekly, Monthly and Yearly basis.
- Created Charts to display summary data using universe as main data provider.
- Extensively used Calculations, Variables, Drill Down and Slice and Dice for creating Business Objects reports.
- Imported/ Exported the Universes from/ to repository to make them accessible to end-users.
- Defined Aliases and Contexts to resolve loops in the universes.
- Created User Conditions and Filters to improve report generation & readability of report and displayed the summary of data by creating Charts.
- Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects.
- Extensively used Calculations, Variables, Break Points, Drill, and Slice and Dice for generating reports.
Confidential
BO Developer
Responsibilities:
- Enhancements of the existing the universes and managing the supervisor.
- Involvement in resolving table linking problems like 'Chasm Trap' and 'Fan Trap.
- Creation of different types of reports like Cross Tab, Charts, Master Detail and reports using multi data sources.
- Creating the reports using Business Objects functionalities like Multiple Data Providers, Prompts, Slice and Dice, Drill Down, Cross Tab and Master Detail.
- Created Reports from GL and Fixed Asset Data Sources like Account Analysis, Journal Entry Enquiry, General Ledger, and Account Analysis with Payable Details.
- Creation of web-based reports using Web Intelligence with scheduling of such reports through BCA.
- Automated document Scheduling, Publishing and Distribution for WebI and Info View clients using Broadcast Agent server.
- Involved in optimizing the universe developing time and SQL Tuning to increase the query performance.
- Used Designer as a part of Universe Development for Defining the Parameters of Universe, Inserting the table, making Joins, Resolving Loop's, Creating Classes, and Objects.
Environment: Business Objects 6.5, Designer, Full-client, Supervisor, Oracle9i, PL/SQL, and Windows NT/XP.