SUMMARY

• Over 7+ years of experience in Business Intelligence using SAP Business Objects XI R3.1/R2/6.x with Info view, Web Intelligence, Webi Rich Client, Desktop Intelligence, Crystal Reports 9/10/XI/2008 Xcelsius 4.5/2008, Central Management Console (CMC), Central Management Server (CMS), Central Configuration Management (CCM), Query as a Web Service, Live Office, Publishing Wizard, Import Wizard and Report Conversion Tool, Broadcast Agent.
• Extensively worked on Business Objects Architecture & Administration. Created Users and Groups and setting the rights on them using Central Management Console (CMC).
• Complete Software Development Life Cycle experience including requirements gathering, analysis/design, development and testing.
• Experience on working with multiple databases like MS SQL Server 2008/2005/2000/7.0 , Oracle 11g/10g/9i/8i/8.0/7.x, Tera - data 12.0/V2R5, DB2 400, and MS Access, MS Excel.
• Good Knowledge of Data Warehouse Concepts including Schemas and Data Modeling.
• Worked in various BO environments linking data from multiple sources, applying several functionalities, and using various Data Providers.
• Excellent experience in designing Business Objects universes, complex BO reports both full client and Web Intelligence Reports.
• Experience in performance tuning the Universes and DESKI/WEBI Reports.
• Used Live Office and QaaWs (Query as a Web Service) to feed live data into Xcelsius 2008 (both Dashboards & Scorecards).
• Strong organizational, time-management and planning skills to deliver projects on time/budget, despite intense pressure and aggressive timelines.
• Excellent communication, interpersonal, training, analytical and technical skills. Quick learning capacity and positive attitude towards new challenges.

TECHNICAL SKILLS

BI Tools: SAP Business Objects XI 3.1, R1/R2 6.5.x, Crystal Report 9/10/ XI/ 2008, Xcelcius 4.5/2008, Info view, CMC, CCM, CMS, BEx Query, Desktop Intelligence XI, Full Client, Web Intelligence, Business View Manager, Live Office.

RDBMS: Oracle 11g/10g/9.x/8.x, DB2/400, SQL Server 2000/2005/2008 , MS Access 2000, Tera-data12.0/V2R5.

Languages: C, C++, SQL, PL/ SQL.T-SQL, Java.

DB Tools: Toad, PL/SQL Developer, SQL Plus

Operating System: Windows (all flavors), UNIX.

PROFESSIONAL EXPERIENCE

Confidential, West Des Moines, IA

Business Objects Developer/Analyst

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications about the system for Business Objects Universes and Reports.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Created few Crystal Reports to Email and Ipage to the Customers.
• Designed Universe by creating the Business Objects Data Model selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the objects like Dimensions, Details and Measures which are grouped into Classes and checked the integrity of the universe.
• Created Derived Tables in the universes. Resolved Chasm traps, Fan Traps & Loop problems to reduce the complexity of the universes.
• Applied User and Group Restrictions in selected objects in universe level.
• Created reports from multiple sources & functionalities like slice & dice, drill down in Crystal Reports.
• Used Prompts in the reports as well as the Universe to create more interactive reports for the users.
• Used filters, conditions, list of values (LOV), calculations, etc Created Objects, Predefined Conditions, and Joins in the Universe.
• Exported the Universes from/ to repository to make them accessible to end-users.
• Resolving and troubleshooting Business Objects/Crystal reports XI R2 issues using Heat ticket system
• Implemented Security features like row level, object level security to make the data secure.
• Provided the security access management by creating users/groups and folders.
• Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Webi.
• Created complex objects using various @Functions, Aggregate objects in the universe.
• Created complex reports using cascading and user objects like measure objects by using @aggregate aware function to create the summarized reports.
• Extensively used Calculations, Variables, Break Points, Drill and complex queries for creating reports.
• Built reports using multiple data providers, external data providers and used merge dimension functionality.
• Synchronized queries from multiple data providers by linking the common dimensions using merge dimensions option in Webi.
• Scheduled Crystal Reports in CMC on Daily, Monthly, Weekly basis. Debugging the Problems exists in the Crystal Reports.
• Used database ranking, ranking on report level, alert, input controls, report filters and section functions to build reports.
• Created different types of reports, like Master/Detail, Cross Tab and Chart (for trend analysis).
• Developed Web Intelligence reports making use of combined Queries (Union, Intersection, Minus).
• Created single or multi line chart for showing tendency over a period of time particularly used in revenue history using Xcelsius 2008.
• Used QAAWS and Live office functionalities of BO to pull Data from SAP Universes.
• Created graphical representation of reports such as Bar charts, 3D charts, Pie charts, Column chart, Line chart, and Bubble chart using Xcelsius 2008.
• Developed universe user documentation guide for the end users reference. Provided training for end users for generating their own report including complicated report.
• Interacted with customer support regularly, in order to generate the reports required and to resolve the existing issues.
• Monitored and solved the issues encountered in Universes and reports while migration and tested before moving to production.

Environment: Business Objects XI R3.1 (CMC, Designer, Web Intelligence Rich Client, Import Wizard, Publishing Wizard), Crystal reports 2008, InfoView, Xcelsius 2008, QAAWS, Live Office, Window Server 2008, Oracle 11i/10g, MS SQL Server 2008, Toad, Mercury Quality Centre.

Confidential, Marshall, MN

Business Objects Consultant

Responsibilities:

• Interacted with business analysts and end users to understand technical and functional requirements.
• Added/modified Users, Groups, folders and rights using Central Management Console (CMC).
• Designed Complex Universes for supporting reporting requirements.
• Used derived tables to create the universe for best performance, and use context and alias tables to solve the loops and traps in the Universe.
• Responsible for creating Derived Tables, Aggregated Tables using Aggregate Awareness concept, creating Indexes, views to increase the performance of the universe.
• Created Complex reports using User defined functions like @prompt, variable, condition objects and Aggregate awareness functions for SQL Enhancement.
• Linked universe based on Master/Kernel approach
• Created various reports using Business Objects functionalities like Sub-Queries, Slice and Dice, Drill Down, Functions, Cross Tab and Formula's.
• Embedded Webi reports in to Microsoft Excel using Live Office.
• Create reports include formatting options such as Grouping, Sorting, Drill-down, Parameter prompts.
• Scheduled recurring daily, weekly and monthly reports (Webi, Deski and Crystal Reports) in CMC and used Calendar based scheduling for the reports custom dates.
• Involved in the creation of Macros to save the reports as Excel and send them to users inbox.
• Created critical visualization using Business Objects Crystal Xcelsius 2008 for the Business Dashboard.
• Created Excel-based interactive visual analytics, dynamic charts and groups and business presentations with Crystal Xcelsius.
• Responsible for migration of universes & reports into Production environment.
• Trained end users to generate reports and other features of Reporter Module.

Environment: Business Objects XI 3.1/ XI (R2) (Designer, BO Full Client, Web Intelligence, Live Office, Info View, QaaWS, CMC), Xcelsius 2008, Crystal Reports, SAP BW, SAP ECC, BEx Analyzer, SQL Server 2005/2008,Teradata, Oracle 10g/9i

Confidential, Durham, North Carolina

Business Objects Developer

Responsibilities:

• Worked with the Business Group in understanding the Project requirements. And responsible to create technical specification documents.
• Worked with end users to understand and Adhoc report requests.
• Maintained User/Application security using CMC.
• Used import wizard in migrating the content between the environments.
• Created universe from scratch and worked on enhancing the existing universes based on Oracle/SQL Server.
• Resolved Loop issues in universe using Alias and Context technique also used short-cut joins where ever necessary.
• Created Universe objects using various database analytical functions like Decode, Sum, and NVL etc.
• Using @functions while creating dimension to increase the usability and make the universe easy to manage.
• Used aggregate awareness in universe to improve the performance
• Scheduled reports using CMC at various intervals and used calendars for custom dates
• Linked different data providers and used sub queries in Web Intelligence reports
• Created reports using breaks, sections, local and global filters.
• Converted Deski reports to WEBI using Report Conversion Tool
• Provided excellent workarounds Deski features lacking in Webi.
• Created reports using input/output context (IN, FOREACH, and FORALL) operators.
• Created reports using Slice and Dice, Drill down and Master Detail
• Worked with the customers to resolve various issues associated with the reports.

Environment: Business Objects XI R2, CMC, InfoView, CMS, Web Intelligence, Desktop Intelligence, PL/SQL, Oracle 10g, MS SQL Server 2003, Solaris 10, PL/SQL Developer.

Confidential, Mount Lurel, NJ

Business Objects Developer

Responsibilities:

• Analyzed the existing database and designed the Universes using Business Objects Designer Module.
• Involved in creating Users, User Groups and assigned privileges to the users using CMC.
• Created various reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports, Charts using Freehand SQ as data providers.
• Resolved the loops, cardinalities, contexts and checked the Integrity of the Universes.
• Designed application by integrating product knowledge with client requirements.
• Synchronized reports using data from multiple data providers in Web Intelligence by merged dimensions functionality.
• Extensively used calculations, variables, filters, conditions, breaks, sorting, drill down, slice and dice, master/detail, cross tab, charts and alerts for creating Business Objects reports.
• Created context and aliases to resolve ‘Chasm Trap’ and ‘Fan Trap’ problems.
• Checked the integrity of the Universe schema for any errors in objects, joins, conditions, loops and cardinalities of the Universe.
• Used @Functions such as @Prompt to restrict return values and to enter prompt, @Select- to reuse the select statement of another object, @Variable- to restrict the currently logged user etc.
• Created Complex WEBI reports multiple data providers coming from multiple universe
• Used Breaks and Sections to legibly format the data in reports
• Prepared user documentation for hands on training of end user community.

Environment: Business Objects XI R2, CMC, InfoView, WEBI, DESKI, SQL server 2000, Windows server 2003.

Confidential, NJ

Senior Business Objects Consultant

Responsibilities:

• Added users, user groups and managed the Access Privileges of the user community using the Supervisor/CMC module of Business Objects.
• Migrated universes and reports to PROD, SYS and DEV environments from BO 6.5 to BOXIR2 version to their respective domains.
• Involved in Analysis, Development, Testing, and Maintenance and Resolved problems during Migration.
• Responsible for User Support and Training for Full Client reporting, Webi reporting, BO XIR2 architecture to users and resolving Trouble Tickets/Cases reported by user.
• Used aggregate awareness, short-cut join, @ functions, Derived Tables at Universe Level for Query performance Enhancement.
• Resolved loops using aliases and contexts. Created complex joins like outer joins and equi-join & theta joins and checked the integrity of the Universes.
• Created Complex Reports using Drill down, Cross tab and Charts (time series graphs, column, line, pie).
• Used the drill functionality, ranking, sorting, complex alert and complex variables in full client reports.
• Used Deski, Web Intelligence for Adhoc reporting.
• Customized the Info view to have the start page as the “my documents” page and set the default option of viewing the reports based on the user profile.
• Involved in performance tuning of Business Objects Full Client and WEBI reports.

Environment: Business Objects XI R2/6.5, Oracle 9i, Redhat Linux.

Confidential

BOBJ Developer

Responsibilities:

• Created & Modified Universes for various functional areas of high level reports group using Designer.
• Customized LOVs in Universes for quicker performance of reports.
• Created Joins, Contexts, and Aliases for resolving Loops & Universe Tuning and checked the Integrity of the Universes.
• Used SQL against the database to check data retrieved.
• Changed the universe parameter settings to optimize the performance of universe.
• According to the customer information created complex report using Universe as main data provider.
• Exported the universes to the Repository making resources available to the users.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, @Functions, Custom sorts, Cross Tab, and Formulae's etc.
• Created reports according to different requirements Such as Summary Charts etc Using Wizards and Web intelligence2.x.
• Exported the Reports to the Broadcast Agent and used the Broadcast Agent server to Schedule and Monitor the Reports.
• Used Supervisor, Info View to manage Users etc.
• Various Programming tasks included developing Reports using free hand PL-SQL, and T-SQL procedures.
• Created reports using Crystal Reports 9/10 with Standard, Summary, Cross Tabs, SQL, Command Objects, Selection Criteria, grouping, sub reports etc.
• Created various analytical reports like Market Share, Trending, Rank reports from multiple data providers. Interacted with the various users for reporting requirements.
• Provided end user support and problem resolution for various issues related to BO.
• Used the Aggregate Awareness feature of Business Objects for the Optimization and Performance tuning of Universes.

Environment: Business Objects (Designer, Reporter) 6.1, Supervisor, Broadcast Agent, Crystal Reports, Oracle 9i, PL/SQL, T-SQL, Web intelligence2.x.