SUMMARY

• Over 8 plus years of experience in Business Objects 4.0 XI 3.1/R2/6.5.
• Over 8 years of experience in Web Intelligence Thin Client, InfoView, Desktop Intelligence, Designer.
• Over three years of experience in Xcelsius, Live Office, BI Services, SAP NetWeaver BW Connection (BICS) and QaaWS.
• More than12 months of experience in Crystal Reports 2008.
• More than 6 months of experience with Analysis for Office and Analysis for OLAP.
• Experience in Migration of reports, universes and dashboards from B.O 3.1 to BI 4.0 by using Upgrade Management tool.
• Converted .UNV universe to .UNX universes.
• Created KPIs and Forecast Dynamic Dashboards using QaaWS,
• Created queries with query filters as well as combined queries for specific department reporting needs.
• Created WebI horizontal, vertical, crosstab and form reports utilizing teh reports formatting, free standing cells, variables, filters, sections, alerts, drill down and ranking along with bar, line and pie charts.
• Created complex Ad - Hoc and canned Reports.
• Strong knowledge in creating universe using teh Designer.
• Experience in creating Universes with measures and dimensions objects, Join conditions, Filters, LOV, cardinality, Aliases, Contexts, Aggregate Awareness using Business Objects Designer
• Strong knowledge of SQL,PL/SQL,
• Experience in Integrating Business Objects 3.1 with BW.
• Strong working experience with RDBMS, Complex Queries, joins, grouping.
• Expertise in gathering Business Requirement and building Universes.
• Sound knowledge in all phases of Full Life Cycle Manager (FLCM) such as developing, testing, migrating, administrating, security management and production supporting. Migrating universes, reports, users, categories from old version to Business Objects XI environment and migration from DEV to QA and QA to PROD.
• Expertise in retrieving data using Business Objects Universes, Personal data files, stored procedures and free hand SQL methods.
• Experience using Microsoft Excel, PowerPoint, PDFs interaction with Business Objects.
• Pro-active team player, committed to providing quality deliverables with strong analytical skills.

TECHNICAL SKILLS

B.me Tools: Design Studio,Designer, Information Design Tool, Universe Design Tool, Web Intelligence Rich and Thin Clients, Desktop Intelligence, Crystal Reports 8.5, XI and 2008, Xcelsius 4.5 and 2008, QaaWS, B.me Services, InfoView, CMC, BI Launchpad, Business Objects Explorer, Analysis for OLAP, Analysis for Office

Databases: Oracle 9i, 10G and 11i, Microsoft SQL Server 2000, 2005 and 2008, MS Access

Operating Systems: WINDOWS 95/98/2000/2003 SERVER, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Mason, MI

SAP Business Objects consultant

Responsibilities:

• Developed Dashboard using design Studio 1.3
• Developed Universes using teh Information Design Tool with multiple data sources and mapping teh data models in teh Data Foundation Layer of teh tool.
• Created multiple Business Layers in teh IDT and assigned access to different User based on teh User Group.
• Designed teh Universe by creating teh Business Objects data model, selecting/joining tables, Indicating cardinalities, created aliases to resolve teh loops, used Aggregate function and created teh objects which are grouped into classes based on Business Functionality.
• Developed Business Views on top of universes.
• Used @functions (@select, @where, @prompt to create predefined conditions, and prompts to filter teh data in teh universes.
• Created Derived Tables in Universe to meet specific requirements for Webi Reports and Dashboards.
• Createdinformation spacesinbusiness objects explorerand performedindexingon them
• Developed complex queries and sub-queries using different data providers in teh same report.
• Developed a complexWebi report with dynamic visibility functionality. Teh report had teh capability todrill down, data was made visible dynamically.
• Createdcomplex webi reportswithmultiple queries, custom sql, using complex functions, hyperlinking, OpenDoc syntax merging dimensions at report level, drill down, drill up, drill across, complex filters etc
• Worked onvalidatingthead-hoc webi reportswith teh end user andcustomizedsome of canned/ad-hoc reports.
• Created Reports with graphical representation such as Bar charts, Pie charts for multidimensional analysis.
• Linked reports using Open Document syntax to link master report to detail report.
• Created various reports using Analysis for OLAP and Analysis for Office.
• Created Web intelligence reports in Advanced and Interactive mode using all teh functionalities
• Involved in SCM GA Analytic Dashboard using BI Services.
• Created Inventory Dashboard for finance team using live office.
• Made use of various components of Xcelsius during dashboard development.
• Used OpenDoc functionality to drill down from Xcelsius dashboard to Webi Reports.
• Involved in Unit Testing, Integration Testing and Performance Testing of reports and Universes.
• Involved in testing and fixing issues in Universes, Reports, Objects, Conditions and LOV’S (List of Values).
• Trained teh users about all teh functionalities and analysis of teh reports for their applications.
• Actively involved inknowledge sharing, documentation and troubleshootingany SAP business objects related problems

Confidential, Plano, TX

SAP Bobj Developer

Responsibilities:

• Deployed BI 4.0 in a sand box for testing and functionality evaluation.
• Installed and configured BI 4.0 in DEV, Q and Production and migrated contents (Reports, Universes and Dashboards) from B.O 3.1 to BI 4.0 by using Upgrade Management Tool.
• Developed UNX universe by using IDT in BI 4.0.
• Deployed and configured Business Objects Explorer and made Information Spaces on top of UNX universes.
• Saved E-Views of Business Objects Explorer.
• Interacted with Business Analysts, Business Users and Managers in gathering business requirements.
• Involved in analyzing, documenting business requirements, functional requirements for developing universes and reports.
• Created teh repository and defined teh users and privileges for teh Users to access teh System.
• Created derived tables at teh Universe level to reduce teh complexity of universe building.
• Extensively used Web Intelligence, Info view, reporter and explorer for querying, reporting and analysis tasks.
• Involved in testing and fixing issues in Universes, Reports, Objects, Conditions and LOV’S (List of Values).
• Used @functions (@select, @where, @prompt to create predefined conditions, and prompts to filter teh data in teh universes.
• Involved in creating complex financial, historical OPS Metrics, Demand Trend, Material Management, Inventory Management, Order Managements Reports, KPI, Global Sales & Acct Management, Sourcing, Contract Management, Supplier Performance reports against varied data sourced like stand-alone databases like SQL server & MS-Access etc.
• Specified teh standards for universes, Classes, Aliases, Simple and complex objects.
• Created filter objects, and formatted objects and measures within teh universe for faster report generation.
• Created Measure class for measures, and created separate class for conditional objects.
• Defined cardinalities, Checked integrity, Detected loops and resolved them by using aliases and contexts to remove teh cyclic dependencies.
• Proficient in using SQL, PL/SQL, T-SQL to study data in different systems and to validate reports.
• Developed Ad hoc reports using Business Objects.
• Created KPI, Scorecards utilizing teh Xcelsius SP3.
• Created Interactive Xcelsius dashboard utilizing teh themes and templates, selectors, and adding dynamic visibility.
• Resolved loops by creating aliases and contexts using Business Objects Designer.
• Created teh reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, Functions, Cross Tab, Master Detail and Formulas etc.
• Create and maintain database schemas required to support BO reporting needs.
• Developed complex queries using different data

Confidential, Toledo, OH

SAP Bobj Consultant

Responsibilities:

• Designed teh Universe.
• Created Aliases and Contexts for resolving teh loops to increase teh performance.
• Extensively used filters, conditions, Lovs and calculations in DeskI and WebI.
• Linked teh Universes to share common objects. Updated and maintained Universes based on changing user trends and data source changes.
• Designed teh Universe based on ER Diagram using Visio.
• Created different types of reports such as master /detail cross tab and charts.
• Created complex reports using user defined functions, condition objects and used aggregate awareness, short-cut join functions for Query performance enhancement.
• Applied slice-and-dice, drill-up and drill-down techniques in master detail reports for multi-dimensional analysis.
• Worked extensively on Dashboards and scoreboards while developing teh reports.
• Created reports using Performance Manager.
• Created KPI, Scorecards utilizing teh Xcelsius.
• Created cross-tab, conditional, drill-down, Charts and sub reports using Crystal Reports.
• Applied Aggregate awareness, Object Hierarchies, Query optimization and linked Universes.
• Developed & Tested complex reports (combining data from multiple Data Sources) for various groups and published them to teh Corporate Documents. Developed complicated reports like Orders by Customer/Product/Region reports, Revenue & Commission reports.
• Scheduled teh reports and access teh reports through thin client.
• Part of teh team for implementing and testing of reports from Business Objects XI R2 to Business Objects XI R3.1.
• Trained teh users in viewing teh reports using teh Info view.

Confidential, Uncasville, CT

SAP BO consultant

Responsibilities:

• Created Cross tab, Master/Detail Reports for Sales, Operations and Corporate.
• Created reports using different formula, extended context, Breaks and variables.
• Created Dashboards using Performance Manager for Corporate MIS.
• Created Complex reports in WebI and DeskI.
• Wrote SQL queries in PL/SQL Developer to extract teh data from database
• Created several WebI reports, DeskI reports and Xcelsius Dashboard reports for graphical presentation.
• Created Report using teh Data Providers Linking across multiple data providers.