SAP BI/Business Objects Developer

* ***** ** ** ********** in SAP BO, BW and R/* implementations, custom development involving all phases of the package development life cycle to meet the business needs. Have Professional experience in designing, development of Data warehouse, Reporting in Business Objects Enterprise 4.0, XI3.0/3.1/4.0/R2/6.X.

Professional Experience

• Excellent Experience working on Business Objects 4.0, Releases XI R2/3.1/4.0 SP2, SP4 and SP5 (CMC, CCM, CMS, LCM, Promotion Management, Information Designer tool, Business Intelligence Consumer Services (BICS), Universe Design (Unv and Unx), Web Intelligence 4.0, Business Intelligence Web Services (BIWS), Report Conversion Tool, Crystal Reports 2001, Dashboard Design using Xcelsius, Live Office, Query As a Web Service (QaaWS), SAP Business Objects Explorer, Good understanding of BEX.

• Expertise in Business Explorer Suite - BEx Query Designer, BEx Analyzer and BEx Web Analyzer.

• Strong work experience in Dimensional Modeling, and designing Star and Snowflake Schemas, Fact and Dimension tables.

• Experience in using Information design tool (IDT), to create universes using multiple Data Sources.

• Created connections to BEx queries and BW Info providers using Business Intelligence Consumer Services (BICS) in IDT.

• Experience in Designing/Developing Universes/Data-Model, Developing Canned/Ad-hoc Reports, Scheduling and processing of reports.

• Excellent skills to develop reports using Web Intelligence Rich Client 4.0.

• Developed WEBI reports on SAP BW Queries using BICS.

• Modified BW queries in to generate WEBI reports in BO to meet user requirements.

• Expertise in creating Xcelsius Dynamic Dashboards using SAP BI data/ BEx Queries. Valuable Knowledge on Dashboard Designer Components like Charts, Selectors (Filters, label Based menus), Tab Sets, Canvas Containers.

• Proficient in Business Objects Reporting using Crystal Reports, WEBI Rich Client 4.0, Live Office and Xcelsius for both SAP and Non SAP sources.

• Strong knowledge In creating connections using Data Connection manager like Query Bowser, Live Office, Query As A Web Service (QAAWS), Flash Variables, SAP BI connectors, UD connecters, DB connectors.

• Strong experience as Business Objects Administrator including installation, configuration of BO tools, set up and maintenance of Business Objects Enterprise environment, creating and managing groups and user profiles.

• Experience in CMC Administration activities like creating and managing repositories, monitoring/granting, permissions and rights to users, user groups through Central Management Server.

• Worked on migration of the Business Objects from lower versions to XI R2, 3.0, 3.1, 4.0

• Worked on Business Objects with Databases like SQL Server 2000/2005, Oracle, Sybase, flat files, Teradata and DB2.

• Experience with Promotion Manager using CTS in migrating universes, reports and Dashboards from Dev to Test, UAT and Production environments.

• Strong experience in SAP BI/BW 7.0 – Business Objects 3.1/4.0, SAP BW-BO Integration, Creation of BI Queries(BEx) and Reports and Dashboards on top of BI/BEx Queries.

• Creation of Bex queries on BI 7.0, 3.5 (Reporting).

• Knowledge on SAP HANA 1.0.

• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with Latest technologies.

• Excellent analytical, time management, interpersonal skills and a good team player with excellent oral and written communication skills.

• Wide experience in interacting with end-users to gather and document the reporting requirements and giving training to the end users.

TECHNICAL SKILLS

Business Intelligence Tools Business Objects XI4.0sp4/3.1/XI3.0/XIR2/6.x/5.x, CCM, CMS, CMC, Information Design Tool, Business Intelligence Consumer Services (BICS), Universe Designer (Unv& Unx), Web Intelligence 4.0, Business Intelligence Services (BIWS), BI Launchpad, Live Office, LCM, Report Conversion Tool and QaaWS, Live office, Dashboard designer, Query Designer, CrystalReports 2008/2011, BexQueryAnalyzer

ETL Tools SAP BW 7.0, 3.5,Informatica, Data integrator XI,

Data Modeling Tools Dimensional data modeling, Physical & logical data modeling, ERWIN, Visio, Star Schema Modeling, Snow flake Modeling

Databases Oracle 11g/10g/9i/8i, SQL server 2000/2005, IBM DB2, MsAccess, Teradata, Sybase

GUI Tools Developer 2000, Visual Basic 7.X/8.0/9.0, Visual Source Safe 6.0d, TOAD.

Web Application Servers Weblogic 7.0, Apache Tomcat 4.0, 5.5.26, Web Sphere, IIS 6.0

Languages C, C#, Java (J2EE), SQL, PL/SQL

Scripting Languages ASP, Java Script, VB Script, HTML, XML DHTML, CSS

Operating Systems Windows Server 2000/2003, Windows XP, Windows NT, UNIX, Linux.

EBAY, Sanjose, CA April 13 –Till Date

Role: SAP Business Objects Developer

The project revolves around creating BICS Connection, developing Webi Reports and expose BIWS to create the Dashboards for Financial and Marketing (FP&A) teams. Reports are such as comparing the Current submission Vs. Prior year Actuals and Current Submission Vs. Forecast year budget.

Responsibilities:

• Interacted with the management and business Decision-makers to identify business requirements. Document reporting needs of the Business Service and Support Organization and disseminate those requirements into a data warehouse strategy resulting in both operational and analytical reporting.

• Used Restricted and Calculated Key Figures, Virtual Key Figures, Formulas, Variables, Replacement path Variables, Customer Exit Variables, User entry Variables in the Query Designer.

• Experience in creating universes using information design tool 4.0 and also connecting to multiple data sources.

• Involved in developing, designing and maintaining new and existing universes by creating joins and cardinalities responsible for creation of the universe with Classes, Objects and Condition Objects.

• Created Aliases and Contexts to resolve the Loops and Traps (fan traps and chasm traps).

• Modified BW queries in to generate WEBI reports using BI Launch Pad in BO to meet user requirements.

• Developed WEBI reports on SAP Bex Queries using BICS in Webi Rich client.

• Created monthly and summary reports in WEBI 4.0 for the different domains like Finance, Marketing and HR domains.

• Used Variables, User defined objects, Scope of analysis, Drill mode, Slice and dice mode, Prompts, and Conditions to make reports accurate and easier for analysis.

• Created WEBI reports & Crystal reports and deployed them through BI Launch Pad with Bex as source.

• Created Marketing and Finance Dashboards for FP&A, Inventory Management and Cost Center Accounting data.

• Created complex dashboards on Bex Queries using Query Browser in Dash board designer 4.0

• Created Dashboards for FP&A using BIWS and QAAWS in Dashboard Designer 4.0.

• Exclusively used QAAWS and Live Office to import data to spreadsheet and develop visually rich dashboards.

• Worked on optimizing the performance of the dashboards. Reduced the dashboard loading time by scheduling the backed source webi reports and by selecting the filter option changing with refresh on trigger option to pick from the latest instance.

• Created Dynamic Dashboards using SAP BI data/ BEx Queries. Have Valuable Knowledge on Xcelsius Dashboard Components like Charts, Selectors (Filters, label Based menus), Tab Sets, Canvas Containers.

Environment: SAP BO 4.0, Netweaver 2004S, SAP BW 7.3, ECC 6.0 Business Areas: MM (Purchasing), SD, BEx, WEBI, IDT, Dashboard Design Tool.

Silicon Valley Bank, Santa Clara, CA Dec 11 – March 13

Role: SAP Business Objects Developer

The project revolves around creating universes, Reports and Dashboards for their Online Financial Portal. Reports such as Company revenue, Department revenue, Profit by Year etc. Final phase is migration from Business Objects XI 3.1 to Business Objects XI 4.0.

Responsibilities:

• Interacted with Business Users and Business Analysts to gather and document the Requirements

and translate to Technical specifications for Designing Universes.

• Strong Experience working on Information Designer Tool, Webi Rich client 4.0, BI Launch pad & Dash Board Designer in SAP BO 4.0.

• Designed universes in Information design tool of SAP BO4.0 based on the requirements gathered from client.

• Designed Universes using IDT with Multi source data sources and defined Connection layer such as Data Foundation Layer and Business Layer and published the universes.

• Improved the performance and reduced the coding with the use of @functions (@aggregate

aware, @select, @prompt, @where).

• Created new and modified existing Hierarchies in the universes to meet Drill Analysis of the

user’s reporting needs.

• Developed Web Intelligence reports according to the report design specifications using BI launch pad and Web Intelligence 4.0

• Used BI Launch Pad for scheduling different reports and for developing Web Intelligence documents.

• Created Ad-hoc reports using web intelligence 4.0 functionalities like Cross Tab, Master Detail, Slice & Dice and Drill Down for Loss, loss item, loss party, coverage, exposure and allocation.

• Created and modified the WEBi reports for various SVB Financial clients.

• Worked extensively with the major functionality of BO like Breaks, sections, Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking.

• Created different types of reports, like Master/Detail, Cross Tab and Chart (for trend analysis).

• Created and manage alerts by subscribe to My Alerts and Emails in BI LaunchPad BO 4.0.

• Developed Dashboard and Interactive visualizations in Dashboard designer and Query browser in BO 4.0 for Financial Claims.

• Worked with LCM (Life Cycle Manager) in migrating universes and reports from Dev to Test, UAT and Production environments.

• Created graphical representation of reports such as Bar charts, 3D charts, Pie charts, Column chart, Line chart, Bubble chart using Dashboard Designer.

• Created Revenue Dashboard, Sales figure Dashboard using Xcelsius 2008 and Dashboard Designer.

• Created nine complex Xcelsius dashboards connecting with SAP BW BEx query for budgeting and long term financial planning.

• Used features such as functions, running totals, and parameters, conditional formats to develop highly formatted Crystal Reports.

• Worked closely with client in all phases to design, build, test and deploy SAP BI4.0 solutions.

• Trained users on Business Objects 4 and usage of reports.

• Migrated Business Objects XI 3.0 content (users/user groups, Universes, reports) in to Business Objects XI 4.0 environment using the Import Wizard.

• Involved in Business Objects Support, Problem Solving, Trouble shooting and developing End user Notes.

• Migrated Business Objects XI 3.0 content (users/user groups, Universes, reports) in to Business Objects XI 4.0 environment using the Upgrade Management tool.

Environment:

Business ObjectsXI 4.0/3.1/3.0/R2, SAP BI 7.0, SAP ECC 6.0, Oracle 11g, Toad Data Modeler, Web Intelligence XI R2/ XI, Infoview, Live Office, PL/SQL, QaaWS, Windows XP, Windows 2003 Server

PNC Bank, NY Feb 11 – Nov 11

Role: SAP Business Objects Developer

PNC bank is developing a transaction reporting system for the federal government in Washington DC. We

have deployed an ODS for various government financial trading partners and developed more than

20 Business Objects reports to capture financial transactions and keep track of the money that flows in and out of the agencies.

Responsibilities

• Work with business users and analyze the Reporting Requirements and Metric Analytics to come up with the technical specifications for the BO Reports from different sources.

• Enhanced the standard data source to meet client requirement.

• Building universes on top of SAP BW - Bex Queries using SAP Authentications.

• Worked on building Xcelsius Dashboards on top of universes build using SAP Integration Kit.

• Experience in using QAAWS connections in Xcelsius with Refresh on Load option which enables pulling of Live Data from Universes as well as Web Intelligence reports on Demand from Database.

• Design and develop various universes and configure Joins, Cardinalities, Loops, Contexts and Shortcut Joins.

• Created Xcelsius dashboards for visual understanding of information and publish to BO Enterprise.

• Created Xcelsius components like charts, menus and containers Mining data and performing statistical analysis using Predictive Workbench.

• Work on Performance Manager to create various Metrics, Analytics and use Dashboard Manager to build Corporate Dashboards.

• Created Rules for Dashboard Manager like Events, Conditions and Actions.

• Adopting strategies for List of Values involving customizing the list of values, Cascading list of values and exporting the List of Values with the universe.

• Use LCM (Life Cycle Manager) for exporting BO Objects from one environment to other.

• Use Database Expert, Group Expert, Select Expert, and Section Expert to create different Crystal reports.

• Developed and Converted Complex DESKI Reports to BOXIR2 -WEBI Using Report Conversion Tool.

• Migrated reports from 6.5 to XIR2 using Import Wizard.

• Used QAAWS and Live office functionalities of BO to pull Data from SAP Universes.

• Used CMC (Central Management Console) to manage the universes, users/groups, reports and Security model to objects.

• Design and deploy the security model for Analytics and Corporate Dashboards.

• Worked extensively with the major functionality of BO like Breaks, Ranks, Variables, Alerters, Formulas, Calculated data items, Filters, Sorts, and Query prompt.

• Created reports using Business Objects functionalities like Multiple Data Providers (Merging), Prompts, Slice and Dice, Drill Down, Cross Tab and Master Detail Created Complex Queries in Desktop Intelligence and Web Intelligence including Complex Conditions (wildcard characters, In List, Different From), Sub queries, and Grouping Conditions .

Environment:

Business Objects XI R2/6.5, SAP BI 7.0,SAP R/3 ECC 6.0, Oracle 10g/9i, Infoview, Crystal Reports XI, Web Intelligence XI, Xcelsius, SAP Integration Kit, QaaWS, Predictive workbench, Visio .

Citi Bank, Dallas, TX Mar 10 – Jan 11

Role: SAP Business Object Developer

Citi provides consumers, corporations, governments and institutions with a broad range of financial products and services, including consumer banking and credit, corporate and investment banking, securities brokerage, transaction services and wealth management. Developed data warehouse to assist Sales and Marketing Department to categorize their customers based on significant portfolio of services including checking accounts, savings accounts, personal loans and geographical area. Using different ad-hoc analysis, Warehouse is supposed to assist in defining strategy for each customer category.

Responsibilities:

• Interacted with Business Users in gathering, analyzing, and documenting business requirements, functional requirements and data specifications.

• Extensively created and maintained complex Business Objects Universes and Reports using the Designer and Reporting modules like Crystal Reports XI, Desktop Intelligence and Web intelligence.

• Developed BOBJ 3.1 using advanced features including Database Delegated (Smart Measures), Hyperlinks, Delegate Search, Data Tracking, Input Controls and Merge Dimensions

• Strong Integration skills between External Portals with SDK and Xcelsius Dashboards.

• Server Intelligent Agent (SIA), Central Configuration Manager, Central Management Console, Business Objects Enterprise, BO Performance Management, Auditor, Crystal Reports, Crystal Xcelsius, QaaWS, Voyager, Live Office, Dashboard Manager.

• Developed Crystal reports from Universes & published developed crystal reports to the Central Management Console and crystal Enterprise Environment.

• Worked with Crystal Report for creating complicated reports including sub-reports, parameter based reports, formula based, well-formatted reports, drilling reports, analysis reports, data reports.

• Involved in the migration of Business Objects system from version 6.5.1 to Business Objects XI R2. Used Import wizard to import existing User accounts, Groups, Categories, Universes, Reports (FC and Webi), Connections and Universe restrictions to BO XI R2 environment. Also used Import wizard to create repository back up file, Business Intelligence Archive Resource file.

• Created interactive Dashboards and Business Presentations by importing data from Excel sheets using Crystal Xcelsius.

• Created Pie charts, gauges sliders to create visual models in Xcelsius using QAAWS and crystal reports.

Environment:

Business Objects XI3.1 (CMC, CMS, CCM, Designer, DeskI, Web Intelligence, Info View, Dashboard Manager, QAAWS, Import Wizard), Business Objects 6.5.1(Supervisor, Designer, Reporter, Web Intelligence), Xcelsius 2008, SQL Server 2000, Sybase, MS Access, TOAD, SQL, PL/SQL, Windows 2003 Server, Crystal Reports XI, TOAD, PL/SQL, Oracle 10g/9i, Windows NT.

Verizon Wireless, Irving, TX Mar 09 – Feb 10

Role: Business Objects Developer

Verizon Wireless owns and operates the largest wireless telecommunications network in the United States, based on a total of 87.7 million U.S. subscribers. The project scope is to design and build reports for decision support for personal and phone usage data. Application provides revenue information and tracking system for their customers call time in minutes for billing as part of the contract. Reports were made to facilitate the end user to extract the true up and customer’s liability as well as give detail customer information, Service usages, Billing information, and account details.

Responsibilities:

• Created Business requirements documents for the modifications required for the reports and Universe, which included testing strategy, Business Objects fix and Business requirements etc.

• Cloned all folders, reports and universes, updated connections for new universes, re-pointed reports to new universes and updated logos

• Converted complex reports from DESKI to WebI.

• Resolved different issues in UAT after upgrading reports from XIR2 to 3.1Environment

• Used import Wizard to migrate reports, folders, users, groups, universes from different environments

• Scheduled and published the business objects reports based on the user requirements.

• Added/modified Users, Groups, folders and rights using Central Management Console (CMC)

• Supported hundreds of customers with BMC Remedy ticketing system

• Worked with SAP support to resolve any BO related tickets/issues.

• Involved in Business user meeting in fixing and explaining the reports for its errors and fixes.

• Involved in redesigning the Universe objects based on Business requirements.

• Supported/created complicated Webi reports with the following functionality subqueries, ranking, alerters, charts, filters, and merged dimensions, opendoc command etc

• Performed Unit Testing, Integration Testing, and User Acceptance Testing (UAT), to validate reports, and played an active role in product rollouts

• Involved in Migration and testing of BOXI upgrade from XI R2 to XI 3.1

• Interacted with the end users and provided Production Support

• Monitored and solved the issues encountered in Universes and reports while migration and tested before moving to production

• Organized work to Onshore and Offshore teams using SharePoint.

Environment: Business Objects XI 3.1/R2 InfoView, Designer, Central Management Console (CMC), Import Wizard, Desktop Intelligence, Web Intelligence Rich Client, Crystal Reports, Business View Manager, Report Conversion Tool, Oracle 9/10g, SQL server, PL/SQL Developer, BMC Remedy

Kaiser Permanente, Pleasanton, CA Jan 08 – Feb 09

Role: Business Objects Developer

Kaiser Permanente is the leading Health Maintenance Organization in the United States. This project was developed as an internal project for Human Resources and Sales department. Most of the Work involved creating Summary Reports Management review details and Sales Reports on region Wide levels using Business Objects. Provide various management levels with Reports, time series graphs, Dash Boards and pie charts using Business Objects.

Responsibilities

• Interacted with the Business Users to analyze the business process, gathered the requirements and made necessary changes to schema objects to fulfill their reporting and business needs.

• Analyzed the source data and work with Data Warehouse team in developing Relational Model.

• Designed and Developed Universes by adjusting parameters, defining joins, cardinalities and implementing features like predefined filters and Conditions.

• Created different classes, sub classes by assigning dimensional, detailed and measure objects according to the requirements.

• Created contexts and Aliases to resolve the loops problems in universe, derived tables using inner/ outer and equal joins as per the requirement.

• Assigned privileges according to their profiles based on CMC.

• Developed custom hierarchies in universe level and Scope of analysis in report level to drill up and drill down the reports.

• Used Report Conversion Tool to convert Desktop intelligence reports to Web intelligence reports.

• Worked extensively with PL/SQL, TOAD for writing user defined queries, stored procedures, views, Indexes.

• Worked very closely with ETL team to have necessary Views and data loaded for the creation of Reports.

• Involved in UAT and also in Unit testing.

Environment:

Business Objects 6.5, Universe Designer, Web Intelligence, Desktop Intelligence, Infoview, Import Wizard, Crystal reports, Oracle, PL/SQL, TOAD.

Ingram Micro: IM Global Implementation, Bangalore, India Nov06- Dec 07

Role: SAP BI & BO Developer

Ingram Micro, USA world’s largest technology distributor & a leading technology Sales, Marketing & Logistics Company. This fortune 100 company distributes and markets IT products from computer hardware suppliers, networking equipment suppliers, and software publishers. The scope of the project includes understanding scenarios & proposes solution in BI & creates reporting solution in BO.

Responsibilities:

• Activated of Standard Business Content to reuse the objects provided by SAP

• Migrated of data flow from 3.x to 7.0

• Created Custom Cubes/DSO to meet client’s requirement

• Created and maintained transformation to maintain data consistency

• Designed and built generic extractor to load inquiries data in BI as standard LO data source

• Created generic extractor using tables/views/function module / domain

• Created a generic extractor to extract classification data in BI to overcome the SAP solution

Business Content Activation carried out for the Infoobjects, InfoCubes, DSO’s and Transformations as per project requirements

• Enhanced the standard data source to meet client requirement

• Wrote ABAP code to eliminate erroneous characters during data load

• Created Super Bex Queries for BO Universe creation

• Created BO Universe on Cube/Multiprovider/Bex Queries

• Created WebI Queries to cater client’s requirement

• Designed and developed process chain to automate the loading process

• Monitoring data loads and job failures

• Resolution of data load errors and Job failures in SM37

• Resolving Help Desk Tickets for BW Production support in Remedy Web

Environment:

SAP BI 7.0 & BO XI R2

Saud Bahwan Group –BI 7.0 Implementation & Support, Bangalore, India Jan 05 –Oct 06

Role: SAP BI Developer

Saud Bahwan, Oman is the country’s largest business house. The group’s businesses include Vehicles Distribution, Construction & Agricultural Equipments, Oil fields & Special equipment and Travel. As a SAP BI Consultant responsible for Data Modeling, generic data sources and Reports. The scope of this project included implementation of SAP BW 3.5

Responsibilities:

• Created generic data sources to fetch Employee attendance related information from SAP R/3 and then replicated the same to BI

• Data Modeling activities and development of BI reports for analysis of Employee Information viz., Utilization, Efficiency, Productive Hours, etc

• Business Content Activation carried out for the Infoobjects, InfoCubes, DSO’s and Transformations as per project requirements

Environment:

SAP BW 3.5, SAP ECC 4.7

Education

• Bachelor of Technology in Electronics and Communication Engineering from GRIET affiliated to JNTU, Andhra Pradesh, India.

Contact this candidate