SUMMARY:

• Having 4 years of work experience as a SAP BI/BO Consultant.
• Extensive experience on SAP Business Objects XI R3 and Knowledge on XI R4 Arora
• Strong knowledge on BO tools like Design Universes, WEBI Reports, Xcelsius Live Office and QAAWS and Crystal Reports.
• Strong understanding of Business Information Warehouse like Info cubes, ODS objects, Characteristics, key Figures and Multi providers.
• Involved in Production, Enhancement Projects for SAP BI/BO and Implementation project for developing reports in SAP BO.
• Self-Starter with drive, Initiative and a positive attitude and able to deliver results even under pressure.
• Experienced in Migrating reporting from BOXI R2 to BOXI R3
• Knowledge in installation of SAP Integration with BO desktop and server products
• Strong Understanding on Crystal Reports, Xcelsius, Live Office and Performance Manager
• By Using HANA STUDIO Creating Attribute Views, Analytical Views, Calculation Views Graphical, Script
• Creating Batch Jobs on BODS and transfer data to HANA DATABASE.
• Have knowledge on SLT to pull the data from SAP systems and Non-SAP systems
• Creating Reports Xcelsius, Crystal Reports, WEBI on HANA DATABASE BO XI 4.0

SKILL SET: Business Intelligence: Business Objects XI R3 /R4, Central Management Console, Central Configuration Manager, Web / Desktop / OLAP Intelligence, SAP BEX, Designer, Dashboard Manager, Crystal Reports Server XI, Crystal Xcelsius 2008/4.5,Import Wizard, Publishing Wizard. Data Modeling : Star-Schema on Master Tables and Transaction Tables DBMS : Oracle 9i, 10g Environments : Windows NT/XP/2003/2000 HANA : HANA 1.X, HANA DATABASE. Industry Application : Banking and Finance, Healthcare, Retail, Manufacturing and Logistics PROFESSIONAL EXPERIENCE: Confidential

Role: Business Object Developer Environment: Designer, Web Intelligence XI R3, Xcelsius, Dashboards, Data Marts, SQL, Windows 2000 Server.

• Developed universes by using Universe Designer Tool, Developed the General systems Universe Non-SAP Universe by using secured connection.
• Exported the universes to the Repository to make resources available to the users
• Created reports for various Portfolios using the Universes as the main data Providers
• Analyzed the business logic built into the warehouse and also gathered user requirements for the reporting work
• Created Classes Sub classes , Objects, Prompts and Predefined conditions and user defined objects and custom Hierarchies for drill down purposes
• Work with the onsite team to meet the specified project deadlines. Work in unison during product development
• Tested Universe and Reports, which includes
• Database connectivity
• Resolved loops and contexts to ensure the correct results from the query
• Objects in the universe, to ensure the correct mapping of the objects
• Aggregate awareness to ensure the query is pulling correct level of aggregation
• Verified the data by running the SQL against the database
• Designed and Developed WebI Reports using the features like Charts, Cross Tabs, Drill Down, Drill Up, Functions and Formulas to analyze the data
• Created user Prompts, Conditions and Filters for various reports to specify the reporting parameters

Role: Business Object Developer Environment: Business Objects XI R2/R3 CCM, CMC, Designer, Web Intelligence, Desktop Intelligence ,Crystal Reports, SQL, Windows XP. Responsibilities:

• Designed universes and applied row level and objects level restrictions to different groups and users as required
• Interacted with Oracle App's team members to understand the BRD's and convert them to tangible Technical spec's to be used in report specifications
• Coordinating with onsite team to update the business requirements. Work hand-hand during the entire product development
• Embedded reports directly into developed web applications and thick client report generation
• Worked extensively on creating Universe's for Order Management, Accounts Payable, Invoice and Account Receivable Data Marts
• Created Classes Sub classes , Objects, Prompts and Predefined conditions and user defined objects and custom Hierarchies for drill down purposes
• Used Functions like Prompt for user defined queries , Where for creating conditional filters , and Select to create duplicate objects in the process of building the Universes
• Handled all the change requests to the existing universes requested by reporting team
• Worked towards optimal development of universes by removing loops through the use of aliases and contexts, Creating Universe with number of Classes, many objects, Derived Tables using inner/outer and equi joins as per requirement
• Used Dashboard Manager to build Dashboards and deploy them across the organization to monitor business performance
• Attended Business meetings and assisted Business Analysts in gathering requirements, discussed the conversion work reviews and Auditing follow-ups
• Documented requirements and performed Gap analysis to identify the gaps
• Data modeled part of the warehouse tables and was part of the team in designing the final conceptual, logical, physical model.

Role: Business Object Developer Environment: BO XI R3 CMC, CCM, CMS, Designer, Info View, WEBI , Xcelsius 2008, Oracle 9i, Windows 2000/XP. Responsibilities:

• Interacted with Users and Business Analysts to understand and document the requirements and translate these to technical specifications for designing Universes and Business Object Reports
• Designed Universes using BO XI R2 designer by retrieving data from database, using Derived tables, defining the necessary connections and exported them to specific universe domains
• Extensively worked with Web Intelligence XI R2 and Info View to create thin client reports based on the business requirements
• Designed and Developed WEBI Reports as per the Users Requirements using the features in Business Objects including: Master/Detail, Charts, Cross Tabs, Slice and Dice, Drill Down, Functions and Formulae to analyze the data
• Created user Prompts, Conditions and Filters for various reports to specify the reporting parameters as per the business rules and requirements of the end users
• Mocking up the data considering security and confidential data. Thorough Documentation of all the Reports with Report definition, field definitions and layouts
• Created Crystal Reports Templates to support Corporation Report Standards and color scheme
• Used Dashboard Manager to build Dashboards and deploy them across the organization to monitor business performance
• Created interactive Dashboards and Business Presentations by importing data from Excel sheets using Crystal Xcelsius
• Development confirmation with users and modification if required accordingly