Professional Summary:

• 8 years of IT experience inBusiness Objects Developer Suite 4.0/XI3.1/XI3.0/XIR2/6.x Infoview, Designer, Desktop Intelligence, Web Intelligence, Central Management Console CMC , Import Wizard, Publishing Wizard, and Report Conversion Tool , Xcelsius 2008, live office, QaaWS.
• Extensive experience in all phases of the Software Development Life Cycle SDLC such as Requirements, Gathering, Analysis, Design, Implementation, Maintenance and also involved in the Production Support.
• Expertise in designingUniverse using Derived Tables, Aggregated Tables using Aggregate Awareness,Index awareness, contexts.
• Involved in gathering, analyzing and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Expertise in creating reports using Business Objects WebI, WebI Rich Client, DeskI and Crystal reports using different Data Sources.
• Created complex Xcelsius dashboards by connecting directly with existing Crystal Reports and XML files.
• Strong knowledge in designing and developing Data marts, Data warehouse using multi-dimensional Models such as Snow Flake and Star Schema.
• In depth knowledge of designing Entity Relationship and Data flow Diagram for business processes. Strong understanding of data modeling and dimension modeling concepts like slowly changing dimensions.
• Strong Database experience in Oracle, DB2, MS Access, MS SQL Server 2008/2005/2000, SQL Loader, PL/SQL.
• Extensive knowledge in SQL, PL/SQL DB2 programming and trouble shooting.
• Extensive experience working with End Users and Business System Analysts in understanding their requirements, assisting in providing technical solutions and implementing them.
• Strong Communication, Organizational and Interpersonal Competencies along with Detail-oriented and problem solving skills in the technology arena.

Technical Skills:

Professional Experience:

Confidential

Role: Sr. Business Objects Developer

Responsibilities:

• Involved in Full life cycle of Business Objects reporting Application right from requirements gathering till the deployment of the Business Objects reporting system on to the production.
• Worked with end users to gather and document requirements for a Business Objects reporting solution.
• Analyzed the functional requirement specifications and designed report specifications document, template design for Universe and Report Templates for standardizing the Structure of Corporate Documents.
• Interacted with Business Users and Business Analysts to gather and document the requirements and translate these to Technical specifications for designing Universes.
• Created WebI reports with multiple data providers and synchronized the data using Merge Dimensions.
• Created the WebI reports using Business Objects functionalities like Queries, Drill down, Functions, Cross Tab, Master/Detail and Formulas etc. and several Queries Union, Intersection, Minus
• Developed WeblReports on demand, AdHoc Reports, Frequency Reports, Summary Reports, Sub Reports, Drill-Down, Cross-Tab .
• Migrated Business Objects XI 3.1 content users/user groups, Universes, reports in to Business Objects 4.0 environment using the Import Wizard. Also provided all groundwork including installation and upgrade.
• Created reports using Crystal Reports and also using Business Objects functionalities like Queries, Drill down, Functionalities, Cross Tab, Master/Detail and Formulas etc.
• Involved in updating and maintaining existing Universes based on changes in user requirements and changes in data.
• Involved in creating new and modified existing Hierarchies in the universes to meet Drill Analysis needs of the users.
• Developed executive dashboards using Xcelsius/Dashboardswith Live Office, QAAWS and BICS connectivity's.
• Created Universes using Information Design Tool IDT and exported it to Repository and made a data provision for Web Intelligence to create reports.
• Designed, Developed and Maintained Single source Multi source Universes by defining joins cardinalities between tables applying contexts and alias tables to remove cyclic dependencies in Information Design Tool.
• Created Business Layer using Data foundation and defined functions aggregate aware, select, prompt, where in the creation of dimensions, measures and conditions
• Brief working knowledge on Content User administration related tasks using Central Management Console CMC .
• Generated controlled reports data by working with Universe and queries and used filters, sorts and rankings.
• Knowledge in architecture design of Extraction, Transformation Loading environment using Informatica.
• Optimized the reports at the universe level and report level to enhance their performance which involved working on SQL parameters, aggregates and joins.
• Publish, distribute and schedule Web Intelligence reports using Info view.
• Performed unit testing, system testing and user acceptance test UAT for universe, reports and security management.
• Responsible for improving the Business Objects query performance by tuning the Queries, Database and server parameters.
• Responsible for maintaining the BOBJ Landscape Development, Quality, Staging and Production repositories, universes, reports and connections and providing round the clock support during the production stage.
• Trained internal staff to handle BOBJ Development activities.
• Very good understanding of the architecture and functionality of the latest BOBJ components.

Environment: Business Object BI 4.0/XI 3.1,Xelcius2008,Dashboards, Crystal Reports 2008,Designer, Web Intelligence, Info View, CMC, Microsoft .NET, Informatica 8.1,SDK, DB2, SQL, PL/SQL, SQL Server 2008,IBM DB2, Windows 2007

Confidential

Role: Sr. Business Objects Developer

Responsibilities:

• Involved in interacting with Business Users and Business Owners to know their Business views in developing and modifying Universes and Reports accordingly.
• Involved in gathering, analyzing,documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Gathered and captured all existing Customization/enhancements in available BO system. Involved in preparation of BRD Business requirement document and GAP analysis in order to include each and every enhancement during Upgrade. Understand the business data flow.
• Responsible for Designing and building Universes using Universe Design Tool UDT over existing BW systems.
• Resolved Loops, Chasm and Fan Traps using Contexts and aliases in Universe Designer.
• Created Ad-hoc reports using BO functionalities like Master Detail, Formulas, Alerts, Slice and Dice, DrillDown and Functions.
• Created BO XI 3.1 Web Intelligence Reports with different functionalities like cascading prompts, drilldown, charts, graphs, ranking, Scope of Analysis and alerts.
• Reports were formatted according to the user requirements using Business Objects functionalities like Breaks, Calculations, Slice and Dice, Drill Down and Variables.
• Defined and Created Hierarchies as per the business rule for the reports to be viewed at selected reporting level. Checked the Integrity of the Universes and exported the Universes to Repository for making available to users.
• Used QAAWS to publish queries as a web service.
• Developed Crystal Reports and formatted the same with respect to the requirements, added parameters specific fields, formulae and used multiple data sources to create the reports.
• Created parameterized Crystal Reports and customize existing reports for presentations using Cross-Tab reports sub-reports, Running Totals, used Crystal syntax to create formulas for the reports.
• Experience in performance tuning of the BOBJ reports at the universe level and report level.
• Performed Business Objects Administrative activities in Central Management Console involving user groups and server management.
• Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data to be displayed on the report.
• Implemented security features of Business Objects like row level, object level and report level to make the data secure.
• Developed reports by linking different data providers in a single report, and made all possible incompatible objects as compatible by merging the common objects.
• Created Dashboards using Business Objects Xcelcius Dashboards.
• Involved in designing EXEC DASH Board universe for all the reporting Needs
• Involved in displaying data from legacy systems andrelational databases and also in creating, modifying reports using tables, views, functions and stored procedures.
• Created users and user groups, restricted access of the users as needed using Central Management Console. Involved in managing users, groups, folders and published reports using central management console.
• Designed, developed and tested the reports based upon data generated by enterprise transaction, financial and customer information systems using Business Objects XI connected to DB2 data source.
• Provided end user and production support after deploying the application into the production environment, also provided extensive support for the users on application usage and trained users in the functionality of the software.

Environment: Business Object XI3.1, Xcelsius 2008, Crystal Reports 2008, Designer, Desktop Intelligence, Web Intelligence, Info View, CMC, DB2, SQL, SQL Server 2008.

Confidential

Role: Business Objects Developer

Responsibilities:

• Interacted with Business Users to know their Business views in developing and modifying Universes and Reports accordingly.
• Worked in offshore as a Team Member for applications like MINDS system at Aviva Canada provides corporate information content via a web portal. It has been built upon various technologies and software applications. The key building block of this system is based on a suite of products called Business Objects version 5.1.9, which was released in 2000.The MINDS system is still functioning but is having difficulty meeting business changes which include: Performance and scalability issues prevent support of Corporate, Departmental Operational MI requirements. The current MINDS infrastructure exists on multiple platforms and uses different releases of the BO software The vendor has stopped supporting version 5.1.9 and will no longer support version XIr2 in June 2010 .The MINDS SUN and DB2 database platform does not meet current performance requirements.
• Migration of reports from DESKI 5.1.9 to BOXIR 3.1 Desk I to WEBI
• Understanding business requirements in terms of technical specifications for reporting and data analysis.
• Extensively used Business Object Universe, BO XI R2 Reports and Oracle database.
• Extensive analysis to design the Universes and assigned those to respective domains.
• Created universes, classes and objects by retrieving the data from data sources like BW queries and defined data loads and query performance issues.
• Created WEBI Reports on OLAP Universe using various formats like Cross tabs, Sections, Breaks, Sort options, Font, Colors and Charts.
• Created WEBI reports and deployed them through info view with BW universe as source.
• Extensively used calculations, variables, prompts, sorted inputs, drill down, slice and dice, alerts for creating business objects reports.
• Created complex views to overcome loops and contexts.
• Created Queries by defining structures, variables, formulas, exceptions, navigational attributes, conditions providing drill down functionality in reporting.
• Created complicated reports including sub-reports, graphical reports, formula base and well formatted reports according user requirements.
• Created Crystal Reports with Standard Cross Tabs and Grouping.
• Knowledge in architecture design of Extraction, Transformation Loading environment using Informatica, Power Mart and Power Center, Ascential Data Stages 7.5, Data Integrator.
• Created visualizations for Finance department to display important KPIs and metrics in one single view.
• Developed critical reports having complex drill down, Slice and Dice, master/detail for analysis of parts benefits and headcount.
• Generated Reports using the Universe as the main Data provider and also using the personal data files provided by the users.
• Documented the reporting requirements, dashboard design requirements by thorough interactive sessions with Business users by building prototypes for developing the interactive executive level dashboards.
• Prepared many other reports by using master details, cross-tabs, slice and dice and drill mode as per the requirement of the end-user.
• Converted Desktop Intelligence Reports to Web Intelligence using Report Conversion Tool.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Defined BO Classes, Objects, in the Universe, defined Cardinalities, Contexts, Joins and Aliases and resolved loops in Universes using aliases and contexts.
• Checked the Universes for Integrity and exported to the Repository to make resources available to the users and groups and Created Adhoc Reports by accessing the Universe.
• 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.
• Responsible for SQL tuning and optimization using Explain Plan, Indexes and optimizer hints.
• Involved in Business Objects support, Problem solving, trouble shooting and developing End user notes.

Environment: Business Object XI3.1, Desk I 5.1.9, Xcelsius 2008, Designer, Desktop Intelligence, Web Intelligence, Info View, CMC, SQL, PL/SQL, SQL Server 2008, SQL Assistant.

Confidential

Role: Business Objects Developer

Responsibilities

• Involved in all phases of Software Development Life Cycle. Gathering, analyzing, documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Worked in offshore as a Team Member for different applications like Non Life Facultative, Non Life Treaty, ODSP, E-board, Magnum Reporting across all over the world of customers.
• Created complex Universes and Reports and Checked the Universes for Integrity and exported them to the Repository to make resources available to the users and groups.
• Created predefined condition, prompts and customized LOV's in the process of building the Universes.
• Created users and user groups, restricted access of the users as needed using Central Management Console. Involved in managing users, groups, folders and published reports using central management console.
• Extensively created reports in WEBI and DESKImodule and implemented drill down features and created reports including horizontal table, vertical tables, forms and charts.
• Created reports on web using Info View Portal and published the reports on the World Wide Web to different users.
• Created several Classes, Objects, Conditions, and Measure objects
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Resolved loops, defined contexts and aliases to resolve loops and also tested them to ensure that correct results are retrieved.
• Resolving join path Problems like Chasm Trap and Fan Trap and loops by creating Context and Aliases.
• Exported the Universes to the Repository to make resources available to the users. Created reports from the Universes as the main Data Providers
• Created reports using Universe, Free-Hand SQL, and Stored Procedures Data providers.
• Improved the performance and reduced the coding with the use of functions aggregate aware, select, prompt, where . Created complex reports using different data sources.
• Developed and supported Business Objects reporting system for various Business units.
• Tested the created reports and modified the relevant objects in the Universe.
• Created a set of Ad hoc reports with Business Objects and finally deploying them in Web Intelligence

Environment: Business Objects XIR2/XI 3.1,Xelcius 2008, Web Intelligence ,Desk I, Oracle 10g, PL/SQL, SQL Server 2005, Windows 2007 Server/ XP/Professional