PROFESSIONAL SUMMARY

• 7 years of IT experience in Business Objects XI3.1/XI3.0/XIR2/6.5.1/6/5.x - Business Objects Universe Designer, Desktop Intelligence, Web Intelligence, Info view, Crystal Reports 2008 XI, Query as a Web Service (QaaWS), OLAP, Oracle 11g/10g/9i/8i, Oracle EBS, SQL Server 2005/2008, MS Access
• Worked on SAP Business Objects 4.0 and other versions. Expertise in planning, designing, modifying, updating, maintaining and distributing Universes and reports.
• Experience in Querying and Reporting modules of Business Objects Enterprise XI
• Extensive experience in Crystal Reports, created complex reports using functionalities like Groups, Cascading parameters, Linked reports, Sub reports and conditional formatting. Expertise in performing tuning and optimization
• Worked on InfoView to create Web Intelligence, Des Intelligence reports over the Universe Created
• Worked on Combination Queries, created Web Intelligence reports over multiple queries
• Developed Xcelsius dashboards for presentations, live data dashboards wif alerts, calculators, historical data comparisons and using crystal Xcelsius by various methods like excel as data source and using QAAWS and LIVE OFFICE.
• Developed Complex Universe structures for Ad-Hoc Reporting
• Worked extensively on various Business Objects functionalities like Queries, Slice and Dice, Cross Tab, Master Detail, Breaks, Alters, Filters, Sorts, Ranking, Prompts and Calculations.
• Good knowledge and experience wif Central Configuration Management (CCM), change control and source control systems.
• Experience in Software Development Life Cycle of Business Intelligence and Data Warehousing projects
• Ability to adapt to new technologies very quickly and different project environments
• An excellent team member wif interpersonal and communication and presentation skills along wif Time management

TECHNICAL SKILLS

Data Warehousing / OLAP / BI Tools: Business Objects XI 3.1, 3.0, 4.0 (Central Management Console, Central Configuration Manager, Central Management Server, Desktop Intelligence, Import Wizard, Web Intelligence Rich Client, Designer, Infoview, Performance Manager, Dashboard Manager), Business Objects Data Integrator, BusinesObjects 6.5 (Reporter, Designer, Supervisor), Crystal Xcelsius 4.5/2008, Crystal Reports XI R2/10.0/9.0/8.0, Crystal Reports 2011, Live office, Web Intelligence 4.0, Crystal Reports Enterprise 4.0 and Dashboard Designer 4.0, SAP Business Explorer.

Administration: Business Objects

Databases: Project Management

Teradata Oracle: 11g/10g/9i/8i, Oracle EBS, MS SQL Server 2008/2005, MySQL 5.1, IBM DB2, MS Access.JIRA, MS Project, MS Access, MS Visio and MS Excel.

Operating System: Windows XP/NT/2000/98/95, Windows 2003, UNIX

Version Control & Others: Microsoft Excel, TOAD, SQL Navigator, WinSQL

PROFESSIONAL EXPERIENCE

Confidential, Ohio

Business Objects Developer

Responsibilities

• Designed and developed Universes involving the required tables from Data mart.
• Also used Derived queries/tables, nested derived queries for best performance using Business Objects Universe Designer.
• Assigned @ BO Variable to implement User Level Security and created reports based onn on free hand SQL and Universe Objects
• Worked on Gathering Requirements, Understanding technical specifications as required by the Project guidelines, the Scope and simultaneously developing universes, Reports and Dashboards
• Worked wif DBA to create aggregate tables and views to improve the performance of the query by cutting down the size of the result set
• Created/Modified new Business objects Deski/Webi Reports using Webi Intelligence Rich Client and Infoview
• Specified the Joins, checked the cardinalities and resolved loops by either using Aliases or Contexts
• Created complex reports involving table/section breaks, multiple data providers and derived tables
• Created complex reports like drill down, Slice and Dice, master/detail and headcount of the records
• Also worked in the Support team to resolve any BO Project related tickets/issues related to Universe, Webi reports and Dashboards
• Tested the aggregate awareness to ensure the query is pulling up the correct level of aggregation
• Used Import Wizard for migrating Project Deliverables between Dev, IST, UAT and Production Environments.
• Generated various reports on Daily, Weekly, Monthly and Yearly basis.
• Successfully implemented export to Excel, PDF and .CSV feature in lower versions of Business Objects using macros to match the data in Webi report as well as Excel download and .CSV download.
• Also created Technical Design Documents to translate the Business Requirements Document into a technical description to ensure dat it describes in detail the specifics of the functions from user’s perspective, provide implementation detail and will be used as blue print of implementation.
• Developed Business Objects Code Promotion documents for all the Developed/ Enhanced Universes and Reports to Migrate it to the next Level.
• Handled project for verifying Project Deliverables against both Technical and Functional Specifications.

Environment: Business Objects XI 3.1/XI 4.0 (Business Objects Designer, Web Intelligence, Desktop Intelligence, Infoview, CMC), SAP Query Builder, RDBMS (Oracle 11g/10g/9i), IDE (Toad 10, SQL Plus), Defect Tracking Tool (HP Application Lifecycle Management 11)

Confidential, West Des Moines, IA

Business Objects Developer

Responsibilities

• Analyze the reporting requirements wif the business users/architects and come up wif the technical Specifications for universe and Business Objects reports.
• Utilized a thorough understanding of available technology, tools, and existing designs and worked on most complex problems where analysis of situations or data requires evaluation of intangible variance factors
• Improved the performance and reduced the coding wif the use of @select, @prompt, @where.
• Improved the performance and reduced the coding wif the use of @aggregate aware and tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
• Defined Alias and Contexts to resolve loops and also tested them to ensure dat correct results are retrieved.
• Created Universes on top of SAP BW Info Providers for reporting wif Web Intelligence.
• Used Query Designer in Business Explorer for applying Prompts and filters on top of Info providers.
• Administer and supervise the Business Objects environment by monitoring/granting permissions and rights to a vast Users located all over the world for viewing, creating and publishing reports and implement Row and object level restrictions.
• Created reports using free-hand SQL, Stored Procedure, PL/SQL.
• Resolved universe problems such as loops, chasm and fan traps using aliases and contexts by testing the overall integrity of the structure using check integrity.
• Modifying the existing universes, adding new objects, editing joins, mapping the existing objects wif renamed tables.
• At the universe level checked whether all the outer joins are created properly and also removed if their are any variables which are not used.
• Implementing Object-level and Row-level security using Manage Restrictions on the developed universe restricting the end-users in accessing certain objects.
• Created Web Intelligence Reports using Webi reports Formulas, Grouping, Parameters and Static/Dynamic Cascading Prompts to handle the customer’s requests from Tables, Stored Procedures, and Views.
• Created Custom Hierarchies for using scope of Analysis and Drill Down options.
• Created the Reports using Business Objects functionalities like Multiple Data Providers, Prompts, Slice and Dice and Drill Down.
• Improved the performance of the reports by removing any additional filters or alerter on the report. Turned the formula into a variable if it TEMPhas any multiple uses.
• Developed and executed the Reports using Business Objects XI 3.1
• Used Import Wizard for the Migration process. Migrated users, universes, reports

Environment: Business Objects XI 3.1, Designer, Web Intelligence Rich Client, Infoview JIRA, CMC, Teradata, MS SQL Server 2008, Oracle 11G, SQL.

Confidential, KS

Business Objects Developer

Responsibilities:

• Interacted wif Business Users and Business Analysts to gather and document the Requirements and translate these to Technical specifications for Designing Universes and responsible for analysis on crystal reports migration.
• Worked on Universes related to Supply Chain.
• Improved the performance and reduced the coding wif the use of @select, @prompt, @where.
• Improved the performance and reduced the coding wif the use of @aggregate aware and tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
• Defined Alias and Contexts to resolve loops and also tested them to ensure dat correct results are retrieved.
• Used Query Designer in Business Explorer for applying Prompts and filters on top of Info providers.
• Scheduled the reports on daily, weekly and monthly basis by using Scheduler.
• Updated and maintained existing Universes based on changing user requirements and based on changes in data source.
• Used Cascading prompts for geographical hierarchies.
• Used Teradata Utilities to increase the performance on the reports.
• Developed standard, cross-tab, On Demand and Drill-down Reports using Crystal Reports.
• Developed Web Intelligence reports making use of several Queries (Union, Intersection, Minus).
• Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data to be displayed on the Web Intelligence report.
• Developed Web Intelligence reports by linking different data providers in a single report, and made all possible incompatible objects as compatible by merging the common objects.
• Used multi-dimensional analysis (Slice & Dice and Drill Functions) to organize the data along a combination of Dimensions and Drill-down Hierarchies giving the ability to the end-users to view the data from heterogeneous viewpoints and Created different types of reports, like Master/Detail, Cross Tab and Chart (for trend analysis) using Web intelligence Rich Client.
• Worked extensively wif the major functionality of Business Objects like Breaks, sections, Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking.
• Created Analytics and Dashboards using Performance Manager to enable executives track progress and compare current and historical performance against established targets.
• Created single or multi line chart for showing tendency over a period of time particularly used in revenue history using Xcelsius 2008.
• Created Revenue Dashboard, Sales figure Dashboard using Xcelsius 2008.
• Migrated Business Objects XI R2 content (users/user groups, Universes, reports) in to Business Objects XI 3.0 environment using the Import Wizard.
• Migrated Crystal Reports 8 to Crystal Reports XI and also responsible for testing and publishing reports.
• Involved in Business Objects Support, Problem Solving, Troubleshooting and developing End user Notes.

Environment: Business Objects XI 3.0/R2, Web Intelligence Rich Client, Xcelsius 2008, Crystal Reports, Infoview, Teradata 13.0, Teradata 13.10, SAP BW, TOAD, Windows 2003 Server.

Confidential

Business Objects Consultant

Responsibilities:

• Interacted wif Business Users and Business Analysts to gather the requirements and business logics.
• Interacted wif end users, regularly in order to generate the reports requirements, these reports were generated using Business Objects functionalities such as Slice and Dice, Master/Detail, User Responses, Formulas, etc.
• Checked Universes for Integrity and exported them to the Repository to make resources available to the users and groups.
• Created Universes and Reports based on requirement and Involved in Migrating Reports from BO 6.0 to BO 6.5
• Resolved loops in Universes using table aliases and contexts to remove cyclic dependencies.
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Involved in creating reports on the web using Business Objects Web Intelligence 6.x.
• Created and managed users and their groups for different areas, repositories, and documents through Supervisor module.

Environment: Business Objects 5, Business Objects 6x, Central Management Server, Designer, Oracle 8i, Windows 2000.