SUMMARY

• 6 years of experience in Business Objects 4.0, XI R3/R2/6.X, Business Objects Designer, Reporter, Supervisor, Central Management Console Info View and Web - Intelligence.
• Strong knowledge in overall BO XIR2/3.0/3.1 application architecture and able to Design, Deploy, Support the application architecture.
• Extensive work experience in migration of Business Objects XI R2 to XI R3.
• Well versed in Business Objects (6.X and XIR2) with experience in Supervisor, Designer, Reporter, BCA (Publisher and Scheduler), Web Intelligence 2.5/2.6.1/6.0, Infoview, Dashboards, Auditor and Schema Design.
• Good knowledge and experience in using Querying and Reporting modules of Business Objects Enterprise XI.
• Worked on Web Intelligence to develop and publish thin client reports. gIn-depth knowledge in creation of WEBI reports and Dashboards using Crystal Xcelsius
• Expertise in retrieving data using Business Objects Universes, personal data files, stored procedures and free hand SQL methods.
• Good knowledge and experience in using Oracle 9i/10g, MS SQL Server 2000.
• Experience in using Triggers, Stored Procedures, Views and developing Oracle components
• Involved in designing Universe and creating reports web intelligence and Desktop Intelligence report.
• Experienced in migration of Business Objects 6.5.1 to XI R2/3.1.
• Well versed in Business Objects with experience in Supervisor, Designer, Reporter, BCA (Publisher and Scheduler), Web Intelligence 2.5/2.6.1/6.0, Infoview, Dashboards, Auditor and Schema Design.
• Good knowledge and experience in using Querying and Reporting modules of Business Objects Enterprise XI and Crystal Reports.
• Designed Data Models OLTP/OLAP data models.
• In-depth knowledge in creation of Dashboards using Crystal Xcelsius and Dashboard manager.
• Involved in designing Universe and creating reports on XIR2.
• Working on Web Intelligence report and Desktop Intelligence for XI R2.
• Expertise in retrieving data using Business Objects Universes, personal data files, stored procedures and free hand SQL methods. Solid knowledge of SQL and PL/SQL.
• Worked with Dimension modeling using Star Schema, Snowflake schema (ROLAP)
• Good knowledge and experience in using Oracle 9i/10g, MS SQL Server 2000/2005.
• Being a key project player, observed a full Life Cycle of a project, which included Requirement Analysis, Planning, Designing, Development, Test and Roll-Out / Go Live

TECHNICAL SKILLS

Reporting Tools: Business Objects 4.0,XI/R3.0/R3.1/R2/R1/6.x/ 5.x, Xcelsius 2008,Performance Management, Designer, Broadcast Agent, Publisher, DeskI, Web Intelligence, Live Office, Crystal reports 2008, Info View, dashboard Builder, Web Services

Languages & Misc Tools: SQL, PL/SQL, Stored Procedures, Functions, Toad, AQT,SQL* Loader, VB 6.0, C#

Databases: Oracle 7.x / 8i / 9i,10g/11g, SQL Server 7.0/2005, MS-Access, DB 2 10.1/9.8/9.7/9.5/9.5

ETL Tool: Confidential Information Server 8.1 (Datastage)

Operating System: Windows 98/NT/2000, Unix, Linux, AIX, MS-DOS, Macintosh

PROFESSIONAL EXPERIENCE

Confidential

Business Objects Consultant

Responsibilities:

• Involved in gathering, analyzing and documenting business requirements, functional requirements and data specifications for business object universes and reports
• Created Universes based on the business requirements provided
• Designed and developed the Functional Analysis and Technical Design like Joins, Shortcut Joins, Contexts, and Cardinalities of the tables and structures of the Universe
• Use of BO Designer Module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies
• Importing and Exporting the Universes to repository to make it accessible to end users
• Creating and Formatting the Reports as per the Users Requirements using the features in Business Objects like Master/Detail, Charts, Cross tabs, Slice and Dice, Drill down, @functions and Formulae to analyze the data
• Expertise in developing drill down reports and hyperlinked reports
• Created interactive dashboards and visualizations using Xcelsius 2008
• Created simple and complex reports including dynamic calculations involving Contexts, Queries, Hierarchies, List of Values (LOVS), local variables, Alerts, Ranking and multiple data
• Fine-tuned the universe objects in order to improvise the Query Performance
• Extensively used slice and dice, filtering and ranking to create cross tab and master/detail reports.
• Involved in formatting sections, tables, inserting and organizing multiple breaks
• Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors.
• Tested the data manually and also supported end users in UAT/Production issues.

Environment: Business Objects XI R4.0, Business Objects 6.1, Cognos, Web Intelligence, Teradata, Designer, Crystal Reports, Xcelsius 2008, Live Office, Import Wizard, Info view and Rich Client

Confidential

Business Objects Developer

Responsibilities:

• Designing new Universes and Modifying the existing Universes, using features like Check Integrity, Aliases, Loops, Contexts, Joins and finally creating the Objects (Dimensions, Measures and Details), which are grouped into Classes
• Upgrading and Maintaining Universes and Reports using Business Objects Best Practices in multiple Environments
• Creating and Formatting the Reports as per the Users Requirements using the features in Business Objects like Master/Detail, Charts, Cross tabs, Slice and Dice, Drill down, @functions and Formulae to analyze the data
• Creating and distributing Report Templates to Users. Web-Enabling the Reports using web intelligence
• Created interactive dashboards and visualizations using Xcelsius 2008
• The main Data Providers for the Report generation in Full Client are Universes / Freehand SQL and Universes for Web Intelligence
• Involved in Business Objects Support, Problem Solving, Trouble shooting and developing End User Notes
• Restriction done on object access, row access, query and SQL generation controls, and connection controls to the users at universe level
• Managing security by Adding, Enabling, Disabling and Deleting of Users/Groups and the granting of privileges using CMC

Environment: Business Objects XI R3/R2, Web Intelligence XIR2, Info View, Desktop Intelligence, Conversion tool, Oracle 10g, Xcelsius 2008, SQL Server 2005, CMS, TOAD

Confidential

DB2 Functional Verification Testing

Responsibilities:

• Responsible for developing test plans and test strategies for new functionality, writing and executing test scenarios, analyzing and debugging test case failures
• Communicating with other testers and developers directly and providing input at every stage of development to ensure high quality solutions are found.
• Communicating with other testers and developers directly and providing input at every stage of development to ensure high quality solutions are found
• Documenting and reporting defects using Confidential ’s defect tracking tools Solely responsible for getting DB2 Cobra certified on RedHat Linux,
• SuSe Linux, AIX, Solaris and Windows 2003 Server Gained extensive knowledge in installing and configuring serial/DPF mode of DB2 on all available platforms. Enhanced my debugging skills specific to each platform environment and available tools for them