sap bobi resume

Abdul Cell: +91 9945228220SAP BO/BI Devoloper. Email:[email protected]

CAREER SUMMARY

Having 4 years of experience in SAP BO, which includes 1 year experience in SAP BI 7.0. I had worked extensively as DW Consultant with major Clients like Motorola, TVS Motors in Data warehouse tools like Business Objects5.x, 6.5, XIR2, XI R3.1,& SAP BI ,XCelsius2008 . My Technological expertise are System analysis, Product Implementation, Dash Board development, Universe Design, Report Development Well trained and good knowledge in SAP BO 4.0

Technical Experience

SAP BO: Expertise in Designing ROLAP & OLAP Universes using Databases and BW. Good Exposure to BO SDK & Experience in a product development and Implementation & Production support. Experienced inBusiness objects universedesigning, Desktop Intelligence, Web Intelligence, Info view, CMC and administering the BO activities using Business Objects XIR2/BOXI3.1. Expertise in creating Xcelsius dashboards using QAAWS and Live Office. Complete expertise in WebIntelligence reporting, Desktop Intelligence reporting in Business Objects. Experience in designing and developing canned and adhoc reports, scheduling the processes. Expertise in creating, organizing, publishing and scheduling reports. Expertise in Universe designing, developing and generating complex, Adhoc, dashboard Reports, Business views, List of values along with Unit Testing. Expertise in Designing Universes using BW and R/3 data sources and developed reports in WebI, Xcelsius Dashboards and Crystal Reports. Hands on Experience in creating SQL Queries and have sound knowledge on SQL Expertise in Business Objects administrator settings for various users and assigning rights and permissions for various features, objects and users in Central Management Console. Knowledge of complete SDLC process Experience in documentation Functional documentation, HLD & LLD, STS (Software Testing Specification), Test Plan Design and Review. Good knowledge of Application servers, Web Servers, browsers. Experience in working with SAP BW/R3 Datasources using BO Tool Expertise in working and implementation of Crystal Reports .

SAP BI:

Data Modeling Expertise in designing and developing Info objects, DSO, cube and Multi provider. Knowledge on Performance tuning for Improving data loading and query performance by maintaining Aggregates, Compression, Partitioning, Indexing of Info Cubes. Extractions - Extracted data from LO Logistics Cockpit for SD Extraction, Business Content Extraction for developing the Universe and updating the existing universes, and Generic Data Sources from Tables and function module. Well conversant with LO extraction, activation of Data source, job control, checking Delta Queue, filling Setup tables, maintaining Extract structures. Good knowledge and working experiencein BI related ABAP like Start, End routines, Function Modules and Customer Exits. BEx Reporting Good in front-end Business Warehouse components for Queries, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions and BEx Analyzer. Customizations - Experience in activating Standard Business Content according to the requirements. Process Chains- Involved in extracting the data from R/3 to BI, Loading (Full /Delta Up-Load) and Monitoring.

QUALIFICATION

Bachelor of Science (B.Sc in computer science) from Sri Venkateshwara University. PROFESSIONAL EXPERIENCE

Working as a SAP BO/BI developer in Keane India, Bangalore since June 2011 to Till Date. Worked as a Business Objects Associate in Starvis IT ,Bangalore from May 2009 to May 2011

TECHNICAL SKILLS

Data WarehouseSAP BI 7.0, SAP BW 3.5,Oracle10g,sql

ERP PackagesSAP R/3 4.7, SAP Net weaver ECC 6.0

Reporting ToolsSAP-BEx, SAPBO XIR2/XIR3 and 3.1

Operating systemWindows 98/2000.Windows NT

Programming LanguageHTML,SQL

PROJECTS DESCRIPTION

Project#1Project TypeImplementation

ClientTVS Motor Company Limited

RoleBI/BO Devoloper

OrganizationKeane India

DurationFeb 12 Till date

Environment(with skill versions)Software

Database : BI 7.0Tools : BOXI R3 (Webi & Xelcious),O/s : Windows

Description: TVS Motor Company Limited, TVS Group is the third largest two/three wheelers manufacturer in India and among the top ten in the world. The company currently sells TVS Motor cycles and its products. All the data has been captured in the reports. This project is to perform sales analysis at TVS Motors. Business Objects is primary reporting tool used by various departments of an organization. As a growing organization lots of activities were going on simultaneously such rationalizing of reports, upgrade to Business Objects 3.1 in order to use latest features of tool to provide better and faster reporting deliveries along with providing support to current reports and environment.My Responsibilities:

Involved as key resource for analyzing SAP BI and BO query requirements. Modeling and creating BI objects like info objects, DSOs,Write Optimised DSO,Infosets, infocubes,physical infocube, virtual infocubes, and multiproviders Installed the standard business contents and customized the cubes to meet the requirement. Extensively worked on LO cockpit extraction to extract data from source system (R/3). Developed Generic DataSources using View to meet the end user requirements.. Designed queries in BEx Query Designer using Conditions, CKF, RKF and Variables. Created aggregates on infocube for improving query performance. Created Start Routines End routines as per the requirement Involved in creation of BO Universe using the Bex queries. Extensively used Webi to develop BO reports. Designed Web Intelligence reports using the Universes built on Bex Queries. Created different reports containing charts showing revenue and operating income by different divisions, marketing shares. Metric goals by Created Dashboards, scorecards to monitor business performance, insightful analytics and role-based dashboards. Used Calculations, Sorting, Rank, Drill Down, Cross Tab, Master detail Format for creating Business Objects Reports. Interacted with Business Users and Business Owners to know their Business views in developing and modifying Reports with Building of Universe Classes and objects accordingly. Created various analytical reports like Market Share, Trending, Rank reports from multiple data providers. Developed What If analysis so that higher management can analyse the business. Worked on gauges, dials, label based menus, charts, spreadsheet to make dashboard more dynamic. Completely taken care the responsibilities to deliver the reports in the prescribed formats. Developed Universes/Connections from BEx Queries. Designed Dashboards for Top management using Xcelsius (Dashboard Designer Tool), Live Office and QAAWS. Created periodical reports monthly, quarterly and annual reports like Category Analysis Report Volume Share which gives insight into the Volume Share amount for the past 3, 6 and 12 months, Calendar and Fiscal years across different product levels. Tested Universes and Reports, which includes Database Connectivity, Objects in the Universe to ensure correct mapping and verify the data. Migrated Universes/Reports from Development to Test environment and finally into Production environment using LCM(Import Wizard).


ClientNorthwestern Mutual

RoleBO Devoloper

OrganizationKeane India

DurationJun11 Jan12


Database : Oracle 10g, sql,BEXTools : BOXI R3 (Webi & Deski),O/s : Windows

Description: Northwestern Mutual is one of the largest insurance and financial services company in the United States of America. The north western is leading direct provider of individual mutual insurance, investment products and products for group and employee benefits, business insurance and reinsurance in USA. This project was intended for the company people to analyze both written polices as well as claims to see which coverages are most profitable and which are at least profitable and also to measure profit over time by covered item type, country, state, demographic profile, underwriter, sales broker and sales region. For this purpose various kinds of reports are generated on the basis of types of polices, policy holder information, policy item details and premium payment details and types of claims in order to provide more flexible analysis. My Responsibilities: fined BO Classes, Objects, in the Universe, defined Cardinalities, Contexts, Joins and Aliases and resolved loops inUniversesusing Table aliases and contexts. Checked theUniversesfor Integrity and exported to the Repository to make resources available to the users and groups and Created Adhoc Reports by accessing the Universe. Enabled dynamic report linking by passing Variables (prompts) between reports. Designing, developing and deploying using Universe Designer, Web Intelligence, Desktop Intelligence, Info View and CMC. Created (Master/Detail, Cross tab, Chart templates) reports using Webi Reports. Worked on Hierarchy Levels and Developed hierarchies to supportdrill downreports. Extensive experience in creating reports with Charts (bar chart, Pie chartetc), Cross-tabs and Sub reports. Resolved performance issues by writing stored procedures and command objects in Crystal reports. Performed unit testing, systemintegration testing, anduser acceptance testingof Crystal Reports at various levels. Create daily, weekly, monthly and quarterly reports for the management team and field operator managers using BO reports.

Project#3Project NameIMAPS(Integrated Mototorola Advanced Planning System)

ClientMototorola

RoleBO Developer

OrganizationStarvis IT ,Bangalore

DurationApril10 June11


Database : Sql, MS Acess,ExcelTools : BOXI R2 (Webi & Deski),O/s : Windows

Description: Motorola is a global leader in wireless, automotive and broadband communications. IMAPS aims at providing demand/supply reports to the customer to view the ONE VIEW database. It provides customer the information to view forecast/demand ratio in Mobile Devices. This project is mainly to make as a single system to manage demand and supply for different regions. Source is ODP and Data ware house is EDW, main aim of this project is to deliver reports to users based on which they can take decisions regarding Demand and Supply. Responsibilities: Creating reports using web based reporting tools of Business Objects using Java Report Panel, HTML Panel, and Interactive Editing. Use of various reporting functionalities like Drill, Filters, Alerters, Formulas, Variables, Multi Data Providers, Ranking, Merging, Sections, Query Panel, Report Panel, Formatting etc. Creating different types of users in Central Management Console and assigning various rights to them. Migrate the project from one environment to another environment in Data services. Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe. Created complex reports stating revenue generation per year using cascading and user objects like measure objects by using @aggregate aware function to create the summarized reports. Restricting rights to the user for security purpose. Dashboard Manager with Enterprise Performance Management.. Standardizing the EPM Dashboard formats, nomenclature, etc as per the user specifications. Working in Infoview and customizing it as per the customer requirements. Providing connections to the database using Universe Parameters. Resolving loops and traps using aliases and contexts. Exporting the universe to the repository, and using it in Infoview to develop reports. Resolved the loops using aliases and contexts Created multiple contexts for catering different functional areas in single user query Participated in designing, developing, and maintenance of reports Formulated data to appear in Master- Detail and Cross-tab reports Created the reports using Business Objects functionalities such as queries, slice and dice, drill down, cross tab, master detail, and formula Created complex reports by using Multiple data providers. Creating reports using Web Intelligence, Desktop Intelligence, Crystal Reports. Exporting the universe to the repository, and using it in Infoview to develop reports.


ClientHasbro Inc

RoleAssociate

OrganizationStarvis IT ,Bangalore

DurationMay09 March10


Database : Oracle 9!Tools : BOXI R2 (Webi & Deski),O/s : Windows

Description: Hasbro is a worldwide leader in childrens and family leisure time entertainment products and services, including the design, manufacture and marketing of games and toys ranging from traditional to high-tech. Its brands include PlaySkool, Tonka, Milton Bradley, and Parker Brothers. Sales in 2001 were $2,856.3 million Responsibilities: Involved in analysis and development of Business Objects reports. Involved in Designing the Universes. Created Classes, Objects, Measures, Conditions, Prompts in Universe. Created the Aliases and Contexts to resolve the loops. Created Derived Tables. Developed various reports like Tabular, Cross Tab, Chart, and Master/Detail Reports. Involved in Unit Testing of the Reports.

1

sap bobi resume

Documents