PROFESSIONAL PROFILE

• 7+ years of SAP Business Objects (BO) experience and Business Intelligence & Business Warehousing (BIBW).
• Has extensive experience in working wif multiple projects encompassing multi - cultural teams from diverse geographical regions.
• Experience working for corporations across diversified industry verticals includes Pharmaceutical, Retail, Manufacturing.
• Proficient wif Data Services, and also Business Intelligence applications using SAP Business Objects Business Intelligence 4.0 wif BI Launch Pad, SAP Business Objects Enterprise XI R3.1/R2, wif InfoView.
• Experience in SAP Data Migration using Data Integrator as teh tool and Data Cleansing, Address cleansing using Data Quality as teh tool and Pro-Active Data Validation.
• Data Object Planning, Definition, Mapping, Migration & Consolidation.
• Experience working wif Web Intelligence, Web Intelligence Rich Client (WEBI), Desktop Intelligence, Crystal Reports 2008 & 2011, Xcelsius 2008 (Dashboards 4.0), Central Management Console (CMC), Query as a Web Service (QaaWS), Live Office, Publishing Wizard, Import Wizard and Report Conversion Tool.
• Excellent noledge in implementation of Relational Database (OLTP) and Data Warehousing systems (OLAP) and Data Marts.
• Experience in Business Requirements Analysis and Documentation.
• Used Dashboard design tool to build interactive dashboards to be used by executive management.
• Extensively worked on developing Dashboards, Analytics, and Metrics using Performance Management.
• Used BEX queries developed in SAP BI/BW 7.1 as a data source for teh universes built in SAP BO/BI 4.0
• Extensively used Calculations, Variables, Prompts, and Sorted inputs, Drill down, Slice and Dice, Alerts for creating Business objects reports.
• Expertise in generating teh Complex Crystal Reports like On Demand reports, Sub Reports, Drill-Down, Dynamic Grouping, Cross-Tab, Graphical, Ad Hoc Reports, Summary Reports, Linked Reports, Mailing Labels and Aging Reports.
• Good Experience in creating Corporate Dashboards, Scorecards, Performance Metrics, Rules, Alerts, Bar charts, 3D charts, Pie charts, Column chart, Line chart, Bubble chart and Goals using Xcelsius 2008.
• Experienced in Business objects universe designing (OLAP Universes), Business Objects Web Intelligence (WebI), InfoView, and BOE.
• Hands on experience in creating BO Xcelsius dashboards and KPI’s to large-scale multi-layer reports.
• Expertise in creating and maintaining Process Chains and Meta Chains for automating data loads.
• Expertise in working wif BEx Analyzer in building Queries. Extensively created Calculated Key Figures, Restricted Key Figures, Formula Variables, Conditions, Exceptions, Aggregations, Cell editors, Customer Exit Variables and Structures for developing complex custom reports.
• Extensively worked on publishing reports to roles and portal, broadcasting workbooks, reports to end-users. Experience in providing teh security using Authorizations for various requirements.
• Involved in End-User training on Navigating reports, Post Go-Live maintenance manuals, Web Application Designer, Portals.
• Excellent Documentation, communication, verbal, and problem solving skills. Proficient skills to communicate effectively wif Team members, developers, clients and end users in a diverse environment.

TECHNICAL SKILLS

BO Tools: SAP BO BI 4.0, SAP Business Objects XI 3.1/XIR2,Xcelsius 2008 (Dashboard Design)

Crystal Reports: 2011/2008, Universe Designer, WebI, DeskI, QaaWS, BIES/BICS, BOBJ

Explorer/Polestar: XI 3.1, CMC, InfoView, BI Launch Pad, Analysis - Edition for Microsoft Office.

SAP BW/BI: SAP BI 7.3/7.0, SAP BW 3.5, SAP ERP SAP ECC 6.0

Operating Systems: UNIX, LINUX, Windows

Databases: Oracle 10g/9i/8i/8.0, Sybase, SQL Server 2005, MS Access

Other Tools: MS Office 2010/2007/2003 (Excel, PowerPoint, Word, Outlook, Project)

PROFESSIONAL EXPERIENCE

Confidential, Omaha, NE

SAP BOBJ / BODS Consultant

Environment: SAP BO 4.0, Web Intelligence Rich Client, Dashboard Design, BI LaunchPad, QaaWS SQL server2008, Mobile BI, Analysis - Edition for Microsoft Office.

Responsibilities:

• Interacted wif Business Analyst and business users to understand teh business requirements and Gathered requirements for enterprise data warehouse schemas.
• Responsible for source system analysis, data transformation guide lines, data loading and data validation from source systems to Integration Applications.
• Created technical specs for universes and Webi reports.
• Designed and developed functional specifications, technical specifications for Dashboard requirements for contracts, promulgate regulations, set water and natural gas rates, buy, sell or lease land and issue revenue bonds.
• Interacted wif users in gathering reporting requirements and created report and dashboard mockups
• Designed, created and implemented WebI reports, Webservices (BIWS) and Xcelsius Dashboards using best practices
• Created WebI reports on top of BEx queries using BICS, and created Webservices on top of WebI report blocks using BIWS to bring data into teh dashboard.
• Developed complex dashboards using Dynamic Visibility functionality
• Created multi-layered dashboards to display various tabs like Scores, Key KPIs, Spend, CASH And Alert Tool
• Broadcasted WebI reports to individual recipients using BI LaunchPadscheduling functionality
• Created WebI reports wif multiple data providers and synchronized teh data using merged dimensions
• Involved in End User-Training documentation, conducted User Acceptance events
• Created linked WEBI reports and Xcelsius dashboards using Open Document (OpenDoc) functionality
• Used Life Cycle Management (LCM) to transport WebI reports, Webservices and dashboards from Development to Test to Production systems
• Set-up, presented and created WebI reports for SAP Mobile BI platform using teh SAP BusinessObjects Mobile on Apple iPad and iPhone using simulators
• Developed Interactive PDF functionality in teh dashboard by creating teh Crystal reports and embedding teh flash wifin teh report by bringing data using flash variables and Crystal Reports Data Consumer connection.

Confidential, SFO, CA

SAP BOBJ / BODS Consultant

Environment: SAP BO XI3.1, Web Intelligence, Oracle 10g, Crystal Reports 2008, Xcelsius 2008, Import Wizard, and CMC.

Responsibilities:

• Requirement Gathering, System Analysis, Process Mapping, Reporting & Documentation wif strong noledge in ETL & SOA architecture.
• Responsible for source system analysis, data transformation guide lines, data loading and data validation from source systems to Integration Applications.
• Designed a complex Dashboard for inventory categorization deployed in all plants across Europe and Asia to be used in materials management
• Designed and developed functional specifications, technical specifications for BOBJ reporting on top of SAP BI/BW and ECC as per teh system landscape.
• High-level Design, Development, Testing and Deployment of teh Interface applications for Tempur-Pedic BO Rapidmarts Project.
• Configured BO data services by creating users and groups in teh management console.
• Interacted wif users for customized and standard reports, gap analysis and associated solutions
• Interacted wif Project manager and end-users in architecting reporting solutions by understanding teh requirements and building universes, reports and Dashboards
• Created reports in BEx Query Designer and extensively used BEx Analyzer
• Involved in requirements gathering, data modeling, planning/scheduling data extraction from source systems
• Involved in installation and configuration of BO Enterprise 4.0 components, BI LaunchPad, Dashboard Designer, Xcelsius, Crystal Reports, Live Office, Interactive Analysis, SAP BI/ BOBJ Integration Kit
• Validated teh installation of Business Objects 4.0 and its integration wif teh SAP BW 7.3 and SAP BWA 7.2
• Involved in setting up teh BOBJ landscape (Dev/QA/Prod environments) and its integration wif respective BW environments and setting up teh Single Sign On (SSO) across all teh environments
• Demonstrated teh creation and use of information spaces and Exploration views on BWA Indexes and universes using Business Objects Explorer
• Created BEx reports using filters, calculated key figures, and restricted key figures
• Created OLAP Universes on SAP data (InfoCubes / BEx queries) using Universe Designer and Information design Tool
• Responsible for establishing and maintaining teh folder structure in teh BI LaunchPad
• Created detailed reports wif Drill-down capability using Web Intelligence in BI LauchPad / InfoView, worked on Ad hoc Query, Reporting, and Analysis
• Experience wif CMC in creating User-groups and worked on security rights.

Confidential, Centralia, WA

SAP BOBJ / BODS Consultant

Environment: SAP Business Objects (SAP BOBJ), Enterprise XI 3.1 SP3 (Designer, Desktop Intelligence, Web Intelligence, Info View, Import Wizard, Report Conversion Tool), Crystal Reports 2008, Xcelsius 2008, SQL Server 2008, Oracle 10g.

Responsibilities:

• Worked closely wif teh DBA and teh functional users to understand and gathered teh business requirements for teh Silverpop and CCRP projects.
• Prepared technical specifications and high level design documentation for teh ETL processing.
• Designed teh system architecture to build BO data services on all environments DEV/QA/PROD.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Crystal Reports.
• Involved in designing Universe and migrating existing Desktop Intelligence (Deski) Reports to Web Intelligence (Webi) report.
• Designed and developed teh Functional Analysis and Technical Design like Joins, Shortcut Joins, Contexts, and Cardinalities of teh tables and structures of teh Universe.
• Used various Universe optimization techniques to improve query performance.
• Involved in teh getting teh business requirements from teh global users and developed teh prototype for different solutions
• Developed teh Technical specification based on teh functional specification documents.
• Developed teh complete solution for internal supplier service level and Back order by pulling teh data from teh staging layer using teh Sales Order, Purchasing and Delivery extractors.
• Developed teh custom Function module extractor to get teh Standard lead time for teh customer material combination.
• Developed generic data sources to get teh data from ECC for Sales document category and transportation dates.
• Written start routines, rule level routines and end routines in consolidating teh data from all teh logistics data sources in to one DSO and then push teh data in to second level evaluation DSO and then to teh cubes.
• Developed teh Bex queries to build BO reports on top of these queries used, Formula variables, Customer exit variables, Replacement path, Restricted Key figures, calculated key figures, structures.
• Developed teh process chains for all teh new development and also integrated wif teh existing teh process chain for scheduling.
• Designed and developed generic data sources to bring teh sales forecast data from flat files. Used expert routines in teh transformation to load teh data as per teh business requirements.
• Created reports wif Multi-Level Scope of Analysis using drill down, drill across, drill up in Web Intelligence and Desktop Intelligence.
• Worked extensively wif teh major functionality of BO like Breaks, Ranks, Alerter, inserted calculations, Filters, Sorts, and Query Prompts.
• Developed physical inventory WEBI report specific to each country and also developed global reports which has consolidated wif teh client standards. Developed teh reports wif 2 tabs as per teh requirement wif and wifout zero’s in teh key figures.
• Involved in Unit testing and Quality testing, created teh documentation as required for teh all teh development. Used HP Quality center and Documentum for testing and uploading teh documents.
• Involved in go live and also supported teh project after go live.

Confidential, CA

SAP BIBO Consultant

Environment: SAP Netweaver 04s (BI 7.0), ECC 6.0, CO, FI-GL, SD, BEx Analyzer, BO XI R2, Webi.

Responsibilities:

• Involved in complete lifecycle implementation of teh project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, Unit testing to Go live production support.
• Interacted wif teh Business Users to analyze teh business process and gathered teh requirements.
• Designed functional and Technical specifications for Implementation and Development of BO XI R2 over SAP BI.
• Extensively worked on SD InfoCube 0SD C03 and data sources 2LIS 13 VDHDR, 2LIS 13 VDITM, 2LIS 13 VCITM and financial data providers, multi provider’s 0FIAP M40 data sources 0FI GL 40 according business needs in SAP BI.
• Involved in development, integration testing, UAT to Go live production support of OTC, RTR reports.
• Created new info providers in SAP BI depending upon teh end user needs
• Developed many complex ABAP enhancements like User Exit Functions, ABAP enhancements in ECC generic extractions and also in BI data modeling like Start Routines and End Routines.
• Extensively worked on BEx reporting and workbooks using RRI, cell definitions, variable offsets, exceptions, conditions, RKF’s and CKF’s.
• Worked on Central Management Console (CMC) in configuring BO environment.
• Defined BO Classes, Objects in teh Universe, defined Cardinalities, Contexts, Joins and Aliases and resolved loops in Universes using Table aliases and contexts.
• Created Universes over BEx queries and InfoCubes of SAP BI using Universe Designer.
• Extensively worked on Infoview to create Web Intelligence Reports over teh Universe Created.
• Created Webi reports wif Complex Calculations to get Alerts for Xcelsius Dashboards.
• Worked In creating Variables, Prompts in Webi.
• Checked teh Universes for Integrity and exported to teh Repository to make resources available to teh users and groups and Created Adhoc Reports by accessing teh Universe.
• Successfully implemented transports of BOBJ in SAP BI environment.
• Created (Master/Detail, Cross tab, Chart templates) reports using Crystal Reports.
• Worked on Hierarchy Levels and Developed hierarchies to support drill down reports.
• Created reports wif Charts (bar chart, Pie chart, etc.), Cross-tabs and Sub reports.

Confidential, San Antonio, TX

SAP Business Objects Consultant / Reports Developer

Environment: Business Objects 6.5, Crystal Enterprise 9, Crystal Reports 9, Oracle 8i, SQL Server 2000, Web-Intelligence, Full Client (DESKI), Designer 6.5, Toad, Windows NT/2000

Responsibilities:

• Involved in teh designing and Building of Universes, Classes and objects for investment management system.
• Involved in Installation and Configuration of all Components of Business Objects.
• Excellent use of graphs and charts wif named groups and formula fields.
• Designed and developed Web intelligence.
• Responsible for analysis of teh systems, meeting wif end users and business units in order to define teh requirements
• Created various dashboard reports to measure teh performance.
• Responsibilities included imparting training to teh end-users and doing teh noledge transfer for reporting needs.
• Solid experience in creating application schema as tables, view and indexes
• Writing scripts to drop teh index before and recreating indexes after teh data load to increase teh performance.

Confidential, Baltimore, MD

SAP Business Objects Consultant / Reports Developer

Environment: SAP Windows Enterprise Server 2003 Apache Tomcat, SAP BusinessObjects (SAP BOBJ) Enterprise XI 3.1SP2 (Designer, Desktop intelligence, Web Intelligence, Import wizard, Publishing Wizard, Report Conversion Tool), BusinessObjects Integration for SAP Solutions XI 3.1, Business Explorer(Query Designer),Crystal Reports 2008, Crystal Xcelsius, SAP BW,SAP BI 7.0, Oracle 10g, Mercury Quality Center 9.

Responsibilities:

• Involved in developing, designing and maintaining new and existing universes wif Classes and Objects.
• Involved in migration of Universes, Reports, and Users from BO 6.5.1 to BO XI 3.1.
• Deployed BusinessObjects (BOBJ) Servers in Development, UAT and Production environments.
• Tested and implemented Service Packs and Fix packs to resolve identified issues and bugs in BusinessObjects XI 3.1
• Installed and configured BOBJ desktop applications such as: Designer, Desktop Intelligence (Deski), Web Intelligence Rich Client and Crystal Reports Client.
• Extensively used Designer to design various universes for different groups. Created complex reports using cascading prompts, decode objects etc.
• Debugged issues which resulted from Migration. Provided support in enhancement and maintenance of teh BOBJ Reports and Universes.
• Extensively used teh Import Wizard to migrate teh universes, corporate documents, users and groups from teh legacy BO to teh XI 3.1 version.
• Used Stored Procedures to create different types of reports wif teh halp of command object.
• Export and Manage reports on teh server. Schedule teh reports in various formats in Info view for recurring reports.
• Created customized existing reports using sub-reports and charts to present information.
• Created teh Crystal reports using Oracle tables and tested teh reports by cross checking and verifying data against teh reports generated from teh legacy system.
• Installed Web intelligence on teh server and configured teh IIS console to define teh paths & aliases necessary to run WEBI.
• Used teh Publishing wizard to export different document types as objects to different folders in CMC.
• Developed Crystal Reports and formatted teh same wif respect to teh requirements. Added parameters, special fields, formulae and used multiple data sources to create teh reports.
• Involved in Full project life cycle (requirement gathering to implementation phase).