SUMMARY:

• Over 8 Years experience in Information Technology using Business Intelligence Tools, Business Objects (BOBJ)Tools in various versions- BI4(BOBJ 4)BO XI 3.1/R2/R1/ 6.5.1/ 5.1, SAP BW on Windows and UNIX Environments.
• Experienced in Developing Webi, Deski , Crystal , Webi Rich Client and Xcelsius Dashboards
• Developed WEBI report/dashboards/Universes(using IDT) in BI4 Environment.
• Development WEBI BOBJ 3.1 using advanced features including Database Delegated (Smart Measures), Hyperlinks, Delegate Search, Data Tracking, Input Controls and Merge Dimensions.
• 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.
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Created Web Intelligence Ad-hoc and canned reports.
• Created dashboards with multiple hyperlinks to various reports using Open Document Syntax.
• Experience in Building Dashboards for Visual Representation of Data using Crystal Xcelsius 2008 SP3/4.5 using Qaaws, Live Office, XML, Flash variables and SAP BW Net weaver as Source connections.
• Developed flexible queries using filters, navigational attributes in BEx Analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.
• Installed Business Content including DataSources, InfoSources, InfoCubes, ODS objects, Update Rules and Queries.
• Installed Crystal Xcelsius 2008 SP3 and developed dashboards using various components.
• Developed Xcelsius 2008 Dashboards on top of Qaaws and Live Office connections.
• Implemented Open Doc to drill down to detail WebI report from Xcelsius Dashboard.
• Installation of third party web servers including Web logic, Web sphere and Tomcat
• Defined Security – Users/Groups/Folders based on Business Model
• SAP Integration with BOBJ
• Experienced in Production Support role 24/7 to resolve the issues using a trouble ticket system
• Created Universes using complex and advanced features from various Database sources including Oracle, SQL Server, DB2, Teradata, Sybase and SAS
• Efficiently mapped business requirements and processes to technical solutions.
• Expertise in designing Universes for Performance Management and Reporting needs.
• Experienced in developing Web Intelligence, Desktop Intelligence and Crystal Reports using different Data Sources.
• Expertise in dimensional data modeling, Star Schema Modeling, fact and dimensional table design, physical and logical data modeling.

Professional Experience:

Confidential
SAP/Business Object Consultant Oct’10-Present
Responsibilities:

• Involved in collecting requirements, Interacted with prospective clients to gather their analytical requirements, which are very important to customer.
• Responsible for understanding end user requirement and convert into functional requirement and involved in preparing project plan.
• Designed, developed, maintained and tested universes for supporting ad hoc queries and canned reports according to the business requirements.
• Interacted with Users to know their Business views while gathering the Report requirements and provided Several Report Mock-ups to finalize the requirements.
• Extensive knowledge of working with company specific proprietary software and third party Software .
• Created Technical Specification requirements (use cases, interface specifications) by translating business requirements
• Designed the BEx Queries in the BW Environment.
• Extensively used BEx analyzer to create queries, variables, filters, calculated key figures, restricted key figures, charts and workbooks.
• Created Dash boards for the top level Management using SAP BW (Bex queries).
• Exported Xcelsius to repository to make it available for users through info view.
• Created WSDLs using Query As a Web Service (Qaaws) from different Data sources and implemented WSDLs into Dashboards.
• Implemented Open Doc to drill down to detail webI report from Xcelsius Dashboard.
• Designed, developed Universes and Webi Reports.
• Developed flexible queries using filters, navigational attributes in BEx Analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.
• Created web reports through report template in Web Application Designer.
• Converted business requirements in business/technical requirement documents.
• Designed web intelligence reports for dimensional hierarchical data
• Involved in unit testing and User acceptance testing.
• Deployed the reports to CMC for the users to able to see the reports in Info View and run, schedule and view the reports in different formats (PDF, Excel)
• Wrote formulas, parameters and conditions depending upon selection criteria.
• Implemented dynamic cascading prompts and defined business views
• Involved in Modifying and Performance tuning of the Existing Reports.
• Created the reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s etc.
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Developed reports specific with these Delegated Search, Database Delegated, Open Document and Data tracking new functionalities.
• Published Reports to CMC (Central Management Console) and involved in Scheduling and exporting the reports in different Formats.

Environment: Business Objects XI R2, 3.1, Crystal Xcelsius , Windows 2003,SAP 4.7, ECC 6, Windows XP.

Confidential, Dec’08to Sep’10
SAP/Business Objects Consultant
Responsibilities:

• Interacted with Users to know their Business views whilegathering the Report requirements and provided Several Report Mock-ups to finalize the requirements.
• Converted business requirements in business/technical requirement documents.
• Integrated Business Objects Reports and Dashboards to Third Party Portal using OpenDoc functionality.
• Defined security models with row level data security, role based security etc in Business Objects Universes and Central Management Console (CMC)
• Created users, groups, server groups and setup security architecture.
• Implemented Row Level, Object Level security for data restriction at Universe level.
• Developed Webi, Deski , Crystal , Webi Rich Client and Xcelsius Dashboards
• Developed BOBJ 3.1 using advanced features including Database Delegated (Smart Measures), Hyperlinks, Delegate Search, Data Tracking, Input Controls and Merge Dimensions
• 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.
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Created Web Intelligence Ad-hoc and canned reports.
• Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard.
• Created Xcelsius Dashboards for Sales and Product level data based on Product Age & Usage using various components of Xcelsius.
• Created WSDLs using QaaWS (Query as Web Services) and implemented into Xcelsius dashboards.
• Created Pseudo dashboards one report having multiple hyperlinks to various reports using Open Document functionality from Dashboard to Webi Report.
• Using Flash variables passed the parameters from Parent Dashboard to Child Dashboard.
• 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 Web intelligence reports in Advanced and Interactive mode using all the functionalities
• Developed Business Views on top of universes
• Created complex reports in Deski, using multiple Data providers.
• Converted Deski Reports to Webi using Report conversion tool for enhancements
• Created Derived Tables in Universe to meet specific requirements for Webi Reports and Dashboards.
• Used OpenDoc functionality to drill down from Xcelsius dashboard to Webi Reports.

Environment: Business Objects XI R2, 3.1,Auditing, SDK, LDAP, Crystal Xcelsius , Oracle 10g,SQL Server 2000 & 2005, SSIS, Teradata,Web logic 10 and Windows 2003,SAP 4.7, ECC 6, Oracle 9i, Windows XP, Unix, Java

Confidential, Feb 2007 – Nov 2008
Business Objects Admin&Developer

• Installed and configured Business Objects XI R2 on both Windows.
• Documented user requirements, translated Functional requirements into Technical Requirements and develop implementation plan and schedule.
• Installed and configured BOE XI R2 on Windows to test the functionality between XI R1 and XI R2.
• BOBJ SDK used for customization BOBJ reports access through portal.
• Worked in STTP Production Support and maintained Business Objects environments.
• Involved in Tuning and server configurations for different environments.
• Applied Service Packs and Fix packs to stabilize Server environments.
• Creating Derived tables at universe level to resolve report level complexity.
• 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 Deski & 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.
• Worked in the Team closely with Functional Architect, DBA and Analysts to get a clear understanding on the Application.
• Developed Report Mock-up samples before User interaction to analyze the business requirements.

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

Confidential, Nov 2004 – Jan 2007
Business Objects 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.
• Installed Business Objects XI R2 on Solaris with Tomcat and Apache.
• Converted reports from 6.5.1 to XIR2 using the report conversion tool.
• Automated ccm.sh UNIX scripts by using UNIX shell scripting.
• 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 Full client 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 Desktop Intelligence 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, DB2, Sun Solaris and Web Logic.