PROFILE SUMMARY:

• Over 8 years of experience in Business Objects Development using various Business Objects (BOBJ) Product Suite including Webi,Deski, Xcelsius Dashboards, Universe Development and Crystal
• Experience in BOBJ Development through versions Business Objects XI 3.1(R3.1) / XIR2/R1/6.x/5.x/5i/4.x and Xcelsius 2008 / 4.5
• Around 3 years in building dashboards using Xcelsius 2008/4.5 using QaaWS, Web service connections, Live Office, XML, flash variables and SAP BW Net weaver connections.
• Expertise in developing Universes for Customized Metrics and Goals to Create Metric Analytics and Goal Analytics.
• Major responsibilities include gathering requirements from the end user and developing Desktop Intelligence Reports, Crystal Reports and Webi Reports.
• Extensive database architecture and design skills working on high performance solutions in large corporate environments.
• Developed BOBJ 3.1 using advanced features including Database Delegated (Smart Measures), Hyperlinks, Delegate Search, Data Tracking, Input Controls and Merge Dimensions
• Strong Integration skills between External Portals with SDK and Xcelsius Dashboards.
• Server Intelligent Agent (SIA),Central Configuration Manager, Central Management Console, Business Objects Enterprise, BO Performance Management, Auditor, Crystal Reports, Crystal Xcelsius, Query as a Web Service (QaaWS), Voyager, Live Office, Dashboard Manager.
• Proficient in design, development, coding, implementation and Support.
• Handful of experience in SQL Development and SQL tuning
• Worked with various teams including Business Owners/ Users, Database and Front end Teams
• Designed and linked Universes for query, reporting, and analysis using the Designer Module.
• Expertise in gathering, analyzing and documenting business requirements, functional requirements, and data specifications for Business Objects Universes and Reports.
• 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.
• Performing Migrations from earlier versions 5.x, 6.x to XI R1/R2 architectures and recreating security Models in XI.
• Implemented both Single Pass Method and Incremental Method for Migrations.
• Expertise in dimensional data modeling, Star Schema Modeling, Snow Flake Modeling, fact and dimensional table design, physical and logical data modeling.
• Good understanding of all the architectural differences between all versions of Business Objects.
• Solid Experience in writing SQL queries, stored procedures, stored functions, packages, database triggers, exception handlers, Cursors, PL/SQL records & tables.
• Expertise in databases to include Oracle 10g/9i/8i/7x, MS SQL 2005/2000/7/6.5, DB2, and MS Access.

Technical Summary:

OLAP/DSS Tools:

Business Objects XI 3.1(R3.1)/R2/R1/6.x/5.x/5i/4.x, SDK, Crystal Reports, SIA, Central Management Console, Central Configuration Manager, Designer, Desktop Intelligence, Web intelligence, Webi Rich client, Report Conversion Tool, Translation Manager, Crystal Xcelsius 2008/4.5, Query As A Web Service (QaaWS), Performance Manager, Deployment Tool , Auditor, Crystal Report Explorer, Dashboard manager, Scorecards, Tomcat 4.0.6, Apache 1.3.x, Business Objects JAVA SDK

RDBMS:

Oracle 10G/9.x/8.x/7.x/5.x, DB2/400, SQL Server 2000/2005, MS Access 2000

Languages:

.net, ASP, VB Script, HTML,JAVA,JSP, PL/SQL, SQL, Shell Scripting

Utility Tools:

Erwin, TOAD, SQL* Navigator, Developer 2000, SQL*Loader

Operating
System:

MS-DOS, Windows 2003/XP/NT/2000/98/95, Unix, HP- Unix, Sun Solaris

Web Technologies:

VBScript, HTML 3.2/4.0, IIS 4.0/5.0

EXPERIENCE:

Confidential, Jun 09 - Present
Sr. Business Objects Consultant

Responsibilities:

• Gathered the requirements using JAD sessions, provided the related Mock-ups for the particular Reporting Scenarios and documented them properly for future references.
• Involved in designing Functional / Technical Specification documents.
• Created Web Intelligence Reports based on Portfolio and Financial level for Risk Analysis
• Developed reports specific with these Delegated Search, Database Delegated, Open Document and Data tracking new functionalities.
• Installed Crystal Xcelsius 2008 SP3 and developed dashboards using various components.
• Developed Xcelsius 2008 Dashboards on top of QaaWS and Live Office connections.
• Created Universe for Ad-hoc and Canned Reporting purpose based on DDL.
• Used dynamic visibility and Excel functions to control and manipulate the data.
• Implemented Open Doc to drill down to detail webI report from Xcelsius Dashboard.
• Exported Xcelsius to repository to make it available for users through info view.
• Used relative path URL to migrate Xcelsius Dashboards from one environment to other Environment.
• Created WSDLs using Query As a Web Service (Qaaws) from different Data sources.
• Designed, developed, deployed and maintained universes used Business Objects designer.
• Created Web Intelligence Rich Client reports with Metadata using Metadata Universe
• Created Dashboards with Metadata Reporting
• Used Aggregate Navigation with compatibility filters in universe to restrict the hierarchy.
• Written SQL queries and matching the data with database and reports.
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Generated Reports from Different Data Providers in Business Objects using a Normalized Schema Database.
• Created Web Intelligence Ad-hoc and canned reports.
• Tuning the queries to improve the performance of the report refresh time.
• Created dashboards with multiple hyperlinks to various reports using Open Document Syntax.
• Worked closely with DBAs to create aggregate tables to support Universes and dashboard.
• Developed Webi Reports based on ETL Audit tables to track Record submission, loaded records, Errors in records and Error details.
• Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard.
• Written Training manuals on S&P Reporting Application

Environment: Business Objects XIR3.1 (Designer, WEBI, Web Rich Client, Crystal Xcelsius 2008, QAAWS), Data Services, Oracle 10g, SQL Server 2005, Teradata, Toad, Windows Server 2003.

Confidential, Oct’07 - Jun’09
Sr.Business Objects Consultant
Responsibilities:

• Documented user requirements, translated Functional requirements into Technical Requirements and develop implementation plan and schedule.
• Developed Report Mock-up samples before User interaction to analyze the business requirements.
• Worked in the Team closely with Functional Architect, DBA and Analysts to get a clear understanding on the Application.
• Creating Derived tables at universe level to resolve report level complexity.
• Developed dashboards using Xcelsius 4.5 using live office and Qaaws as the data sources.
• 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 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.

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

Confidential, Jul’05 - Sep’07
Business Objects Administrator/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.
• Converted reports from 6.5.1 to XIR2 using the report conversion tool.
• 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 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 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, Essbase Hyperion Analyzer, DB2, Sun Solaris and Web Logic.

Confidential, June’02 - May’05
Business Objects Consultant
Responsibilities:

• Documented user requirements, translated Functional requirements into Technical Requirements and develop implementation plan and schedule.
• Supported Business Objects Environments as a Primary Role.
• Worked in the Team closely with Functional Architect, DBA and Analysts.
• Created Derived Tables in the Universe to meet the Reporting Requirements.
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Created Stored Procedures and validated data for the Performance.
• Installed and Configured Business Objects on Both Client and Server Installations.
• Created Default users using Central Management Console for the Application to verify the Reports.
• Worked with User Interface (UI) Developers to create Urls for Single Sign-on, passing the Required Parameters to run the Report.
• Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard.
• 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 Reports from Different Data Providers in Business Objects using a Normalized Schema Database.
• Created few Crystal Reports to Email and Ipage to the Customers.

Environment: Business Objects XI R1, Crystal Reports XI, Oracle 9i, LDAP, Vitria, Sun Solaris and Web Logic.