PROFESSIONAL SUMMARY:

Responsibilities:

• Designing Universe using Information design Tool
• Creating Webi reports for RAAP, Fixed, Internal and External performance calculation for physician
• Creating Dashboard for the presentation
• Converting reports to Webi reports from Web logic system

Responsibilities:

• Provide technical support to resolve Production issues involving Web Intelligence Reports. Interaction with the Business Analysts, users and business leads to understand Business needs.
• Constant Interaction with users in going over the use cases for new Business needs and validation of the existing implementations.
• Migrated Universes and reports from BO XIR 3.1 to BO 4.0, Created and developed universes and reports using BO 4.0 according to the new requirements
• Creation and testing of complex reports and documentation of test cases and report specifications. Drill down the Analytics to the detail level data by a Web Intelligence Report.
• Involved in the extensive standards guidelines documentation. Created Derived tables in the Designer to enhance performance of the universe.
• Creation of Dashboards Converting Business Data requirements into Conceptual and logical data models. Commonly used excel functions VLookup, Hlookup, Index, Match and Conditional statements Microsoft excel as a data source.
• Exported Dashboards to BOE Server Exported visualization contents to various file formats pdf, ppt, and html, flash .
• Maintenance, Migration, Testing, Change the color scheme for components in a dashboard. Dashboard gives the information of the Best 10 stores by Shrink , Worst 10 stores by shrink by region.
• Created Aliases and Context to resolve loops, defined the cardinalities as defined in data model. Created new reports from the scratch for new requirements and modified some of the existing reports in SSRS and BO 4.0.
• Created reports using SAP BW BEX Queries in Web Intelligence, Set up Aggregate Awareness to enhance the performance of SQL transactions, Updated Universes based on changing user requirements and data source changes, Prepared different report layouts and blocks like Tables, Cross Tabs and Charts.
• Resolved issues related to RDBMS flaws such as Fan Trap, Chasm Trap using BO multi parse SQL functionality. Created new stored procedures in SQL server 2005 to use in SSRS reports.
• Created WEBI Reports with multiple variables at report level to get , Average, variance etc values. Created Hierarchies according to the business rules for viewing data at selected level of detail.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, Functions, Cross Tab, Master/Detail and Formulas etc.

Responsibilities:

• Gathered business requirements and performed detailed analysis.
• Created universes with Classes and Objects for investment management system.
• Defined contexts, aliases and used multi parse SQL in the universes to address loops, chasm traps and fan traps, which support Ad-hoc and canned reports.
• Applying Time standard Monthly Reports, Quarterly Reports Annual Reports published by Revenue. Designed Dashboard Using SAP Xcelsius Tool. Using Add-on components to create the Dashboards. Creating user authentication for the dashboards.
• Using Universe Crystal Reports and Webi Reports as a Data source of Xcelsius to build the dashboards thru Use live office QAAWS to getting the live data.
• Used Index awareness, aggregate aware and Aggregate tables for optimized query performance. Created universe on top of views build in composite coming from multiple data sources.
• Worked extensively with functions select, prompt, where in designer, created optional prompts, also created objects using complex case functions.
• Created Multiple Custom Hierarchies for several groups to provide drill across functionality. Wrote functional specification documents for the project scope to be created in security to be implemented in Business Objects XI R 3.1
• Extensively involved in developing Web Intelligence reports' publications, scheduling and monitor publications..
• Implemented Row level restriction for managers profiles using designer. Resolved tickets to support production environment, modified and tweaked report content and distributed reports in multiple formats such as Excel and PDF.
• Used aggregate aware function and Aggregate tables for optimized query performance. Used prompts to create predefined conditions and prompts to filter the data and dynamic user selection.
• Worked with Crystal Report 2008/XI for creating complex reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports and analysis reports.
• Developed Graphic Reports, Pie charts for the statistical representation of the data. Tested the Web Intelligence reports in System Integration and Testing SIT environment and Performance Testing Staging environment to validate performance of all the reports, which helped in analyzing its performance before moving into production environment.

• Managed the Business Intelligence project teams through all phases of blueprint, realization, go-live, rollout, and post implementation support, which involved all aspects of each of the functional areas, working with developers and data architects.
• Involved in creating dashboards for graphical presentation, Created resource plans, programming specifications, testing and validation procedures, Acted as Data Lead and Liaison between ERP projects and value center data
• Worked closely with the project leadership team to document schedules, resource requirements, business requirements, test strategy, and plans for data migration, Involved in migration of reports from BO 6.5 to BO XIR3, Migrated universes, reports and security domain from 6.5 to BO XIR3 Using Import Wizard, Resolved several issues with installation, designing, reporting and migration
• Produced technical document and user manual for migration from one built to another built of Business Object, Identified skills needed, mapped resources to skills and provided training for BO migration, Converted Deski Desktop Intelligence reports to Webi Web Intelligence reports using Report Conversion Tool, Used Crystal Report XI Enterprise to design the front end reports.
• Worked on group expert, select expert, sort expert, section expert for different report formatting activities for crystal reports, developed and formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built in/custom functions
• Created different types of reports, like master/Detail, Cross Tab and Chart for trend analysis , Used filters, conditions, calculations etc, Maintained business and process metadata collected for data related Work Flow Enhancement projects within Bank tools Business Objects, and or designated bank database, Analyzed specs and database model to generate the reports for the sign-off specs
• Created Business Objects Web Intelligence Desktop Intelligence reports and published on the INFOVIEW, Involved in migration and deployment of the universes and reports across multiple repositories, Published report to Enterprise server, to get the report access from INFOVIEW

Responsibilities:

• Worked on Import Wizard to promote Reports/Universe to Production. Created access level for specific functionality for particular User/Groups.
• Implemented migrations of repositories Universes, Reports, Securities, and Categories . Implemented migrations of repositories Universes, Reports, Securities, Categories from DEV to UAT and then to PROD.
• Installed, Maintained the Business Objects Enterprise. Responsible to talk to business users and finalize on any enhancements/new requirements needed by reporting department.
• Defined contexts, aliases and used multi parse SQL in the universes to address loops, chasm traps and fan traps, which support Ad-hoc and canned reports.
• Used Index awareness, aggregate aware and aggregate tables for optimized query performance. Created universe on top of views build in composite coming from multiple data sources.
• Worked extensively with functions select, prompt, where in designer, created optional prompts, also created objects using complex case functions.
• Created Multiple Custom Hierarchies for several groups to provide drill across functionality. Wrote functional specification documents for the project scope to be created in security to be implemented in Business Objects XI R 3.1
• Extensively involved in developing Web Intelligence reports' publications, scheduling and monitor publications.
• Created Xcelsius Dashboard using Query as a Web services and Live Office as a source. Developed dashboard using Xcelsius, involved in POC and user training on Xcelsius and live office
• Implemented security matrix in CMC, created access levels for users and applied restrictions on contents. Implemented Row level restriction for managers profiles using designer.
• Resolved tickets to support production environment, modified and tweaked report content and distributed reports in multiple formats such as Excel and PDF.
• Used aggregate aware function and Aggregate tables for optimized query performance.
• Used prompts to create predefined conditions and prompts to filter the data and dynamic user selection.
• Worked with Crystal Report 2008/XI for creating complex reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports and analysis reports.
• Used conditional formatting as per user requirements in crystal reports.
• Extensively worked with SQL Developer running on Oracle 10g client to cross check the data accuracy, validation and the performance of the reports.
• Developed Graphic Reports, Pie charts for the statistical representation of the data.
• Tested the Web Intelligence reports in System Integration and Testing SIT environment and Performance Testing Staging environment to validate performance of all the reports, which helped in analyzing its performance before moving into production environment.
• Extensively used Variables, Sub-queries, Input Controls, Context Operators In, For Each and For All , Drill down, folding/unfolding, Breaks, Sections, Ranks and Alerter in the creation of reports.
• Created complex reports using Free Hand SQL Custom SQL feature of Business Objects Web Intelligence.
• Developed various WEBI reports and dashboards using OLAP Sap BW as a data source Universe.
• Involved in user training, trained users on Infoview and Xcelsius Applications, and provided technical guidance tousers.

Responsibilities:

• Involved in Full project life cycle requirement gathering to implementation phase .
• Worked very closely with upper management to get detailed information on what information they require in each report
• Created/Modified Universes and linked with the existing Universes with Oracle backend and exported to repository.
• Created Users and implemented security features.
• Created Slice and Dice, Drill down and Cross Tab reports.
• Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors, etc.
• Various ad hoc reports were created using User module in Business Objects according to the given requirements.
• Extensively used Designer to design various universes for different business groups. Created classes, aliases, help text, simple reports and complex reports using cascading prompts, decode objects, etc.
• Implemented row and object level security in business objects supervisor module.
• Worked with Dimension modeling using Star Schema ROLAP .
• Managed the scheduling options stored in the repository and also involved in changing the document descriptions.
• Created Business Objects reports, Queries with constant interaction with the end users. Trained end users in understanding the reports. Functionalities such as Slice and Dice, Drill mode and Ranking were used for Multidimensional Formatting.