SUMMARY

• 8+ years of SAP Business Objects (BO) experience which includes 3 Life Cycle Implementations
• Has extensive experience in working with multiple projects encompassing multi - cultural teams from diverse geographical regions.
• Experience working for corporations across diversified industry verticals includes Pharmaceutical, Retail, Manufacturing.
• Extensively worked on Lifecycle Manager, publishing reports to roles and portal, broadcasting workbooks, reports to end-users, user interfaces, Experience in providing the security using Authorizations for various requirements.
• Marked experience in generating customized queries using Restricted and calculated key figures, Variables, Conditions, Exceptions and Report Filters.
• Worked on performance tuning by using delta loads, process chains and creating aggregates, carried out day-to-day monitoring, fixing loads etc.
• Hands on experience in Business Object reporting particularly skilled in working with BO versions
• Established and worked on universes using universe designing tool and Created BICS connection over BEx queries using Information design tool.
• Worked extensively on Web Intelligence,QAAWS,Live office.
• Interacted with the end client for gathering requirements and developed functional specifications.
• Actively participated in developing training material and User Guides.
• Verse with SAP Business Objects Mobile client for various Mobile Devices
• Worked on Rapidmarts for decision makers to access the information easily.
• Experienced QlikView developer - the pioneered in-memory Dash boarding tool and WEBI.
• Adept at creating, organizing, publishing and scheduling reports using Central Management Console.
• Created reports for analysis using Web Intelligence via Web Intelligence Rich Client and via Bi Launch Pad.
• Good Experience in BW Extractions, BW Modeling and BEX Reporting, BPS and Integrated Planning
• Worked on SLA scenarios to make query suitable for Business Objects enterprise server reports.
• Extensively used Designer, Business Objects Dashboard Manger and Desktop Intelligence.
• Experienced in Business objects universe designing (OLAP Universes), BICS, IDT, UDT, Crystal reports, Visual intelligence, Design Studios, Explorer, Analysis, Business View Manager, Mobile BI, Infoview and Business Objects Enterprise (BOE).
• Hands on experience in creating BO Xcelsius dashboards involving all sorts of selectors and prompts with particular focus on dynamic visibility,Business intelligence analytics platform and KPI’s to large-scale multi layer reports.
• Used Import wizard\Upgrade Management tool extensively for migration 6.5 to BO XI R2 to XIR3 and 4.0\4.1 and also package BI content into Business Intelligence Application Resource (BIAR) format for backup or Change management.
• Involved in End-User training on Navigating reports, Live office, Post Go-Live maintenance manuals, Web Application Designer, Portals.
• Good with Rapidmarts to get the maximum value from SAP Business objects solutions with flexible and comprehensive reporting, query and analysis functionality for lines of business.
• In depth understanding ofSAP R/3functionality (SD, MM, PP, FI, CO-PA), CRM & SRM, Standard Business Contents and Data Modeling (star schema, extended star schema, flat structure and multi dimensional data modeling) in Sap BI/BW.
• Worked with databases like SQL server, Oracle, Sybase.
• Troubleshoot and documented installations and implementation of BO XI R2 on Linux server and Sybase database and provided knowledge transfer regarding universes/webi development best practices.
• Proficient in OLTP extractions of SAP LO-Cockpit, SD, FI, MM, HR, CO-CCA generic extraction, flat files & using DB Connect for legacy data.
• Extensively worked in designing and configuring back-end components including Extractors, InfoObjects, Hierarchies, InfoSources, Update Rules, Transfer Rules, Transformations, InfoCubes, MultiCubes, ODS/DSO, InfoSets, InfoPackages, Datamart and Data Transfer Process (DTP), SAP HANA.
• Strong experience with OLAP reporting in BW.
• Expertise in naming standards,writing modeling guidelines,developing user training material and training users on utilizing,training and administering BW queries.
• Expertise in DataSource Enhancement, User Exits, Loading, Scheduling, Monitoring, Process Chains, Open Hub Service, Authorizations, User Profile Maintenance, Reporting Agent, Enterprise Portal Integration, Information Broadcasting and alert monitor.
• Proficient in writing ABAP User exits for transaction data and complex routines in start routine, end routine and update routines.
• Worked on red hat LINUX platform.
• Expertise in working with 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.
• Expertise in creating and maintaining Process Chains and Meta Chains for automating data loads.
• Evaluated statistical performance using BW Statistics for optimization. Improved data load and query performance by using BI Accelerator (BIA), Compression, Aggregates, Indexes, optimizing Data packet size.
• Documented functional specifications, technical specifications, test cases, test results and production support documents.
• Excellent Documentation, communication, verbal, and problem solving skills. Proficient skills to communicate effectively with Team members, developers, clients and end users in a diverse environment.

TECHNICAL SKILLS

Reporting: BusinessObjects5.x/6.x/XI 3.x/BI 4.0/4.1, Integrated Planning, Desktop Intelligence, Dashboards, Web Intelligence, OLAP Intelligence Reports, Crystal Reports XI, Advance analysis for office, Java Reporting Components, COM Reporting Components

Operating Systems: Windows 9x/2000/XP/Vista, 7, LINUX, UNIX, MS-DOS

Language: C, C++, Java, SQL, PL/SQL, Visual Basic 6.0

Database: Oracle 8.x/9.x/10g/11g/12g, SQL Server 7.0/2000, MS Access, Teradata

ERP Packages: SAP ECC 6.0, R/2,R/3, R/4,4.7

Data warehouse: BI 7.3, BI 7.0, BW 3.5

Web/Application Servers: IIS, Apache v2, Tomcat 4.1

Administration: CMS, Supervisor, CMC (Central Management Console)

PROFESSIONAL EXPERIENCE

Confidential, Aiken, SC

SAP BI/BO Consultant

Environment: s: Business Objects 4.0/4.1,BW 7.3,Oracle 11g, MS SQL Server, Crystal Reports, Dashboards, Web Intelligence, Info view,.BEx AnalyzerThe Bridgestone family of companies, which include Confidential, is a world leader in tire and related technologies. The collective entities utilize the tri-polar research and development centers in Tokyo, Akron and Rome to produce advanced tire technologies for products that meet consumers’ needs.

Responsibilities:

• Actively interacted and scheduled meetings with the business users to gather the reporting requirements, performed gap analysis and developed design documents.
• Efficiently lead small to large sized teams in various assignments
• Worked as Production Support Lead for the Business Objects Reporting environment.
• Created intricate queries by incorporating Free Characteristics, Calculated Key Figures,Restricted Key Figures and Variables.
• Defined variables using SQL related functions so as to design customized multiple dimension reports.
• Created BICS connections using Information Designing Tool and formed both .unx and .unv universes using Universe Designing Tool.
• Designed and developed proof of concept for accessing Webi Reports and Xcelsius dashboards from Mobile Devices
• Worked on Rapidmarts to improve decision making with faster access to accurate, complete LoB data.
• Looked into integrity issues and exported universes to the CMC (Central Management Console) to make resources available to users and groups.
• Performance tuning by analyzing and comparing the turnaround times between SQL andQlikView
• Designed versatile, flexible reports using Web Intelligence components like conditions, operators and functions and integrated these in Live Office Work Sheets.
• Enabled dynamic report linking by passing variables (prompts) between reports.
• Worked with Crystal Reports for generating and formatting with Standard, Summary, Cross Tab and grouping reports.
• Developed User Interactive Sheets & Reports as business needs. Writing SQL Scripts to load the relevant Data inQlikViewApplications.
• Created Aggregation Levels, Planning Filters, Planning functions, Planning Sequences,Data Slices, Characteristic Relationships using Integrated Planning
• Worked on Run update installation software and Run promotion management tool in upgrade process from 4.0 to 4.1
• Designed intricate dashboards involving dynamic visibility by employing a variety of selectors and charts.
• Worked on Rapidmarts to accelerate deployment with prebuilt data integration,database models, and semantic layers.
• Developed BEx queries for reporting on InfoCubes, ODS and Multi Provider by defining Structures, Variables, Formulas, Exceptions, Selections, Navigational Attributes, Conditions providing drill down functionality in reporting.
• Installed, configured and tested Business Objects Enterprise (BOE) server products on DEV, QA, test and production servers in a extremely fast paced environment on LINUX platform.
• Created BI OLAP universes over BEx queries using Universe Designer, published the reports on the web using Web Application Designer (WAD).
• Experienced in gathering and analyzing the requirements from end-users and creating multifaceted Ad-Hoc reports using Business Objects Desktop Intelligence.
• Extensively worked on formatting Business Objects reports to meet the user’s requirements using Calculations, Variables, Prompts and Sorted inputs, Drill down, Slice and Dice, Contexts, Alerts.
• Worked on application servers, Mobile BI and performance optimization giving various publications.
• Worked on both Business objects 3.1 and 4.1 for data federator and multisource universes respectively.
• Extensively Worked with Explorer, SAP Live Office to create connections between WEBI and Xcelsius Dashboards, Design Studio, Visual intelligence. Worked on different structures, INFOVIEW to create Web Intelligence Reports over BO Universes.
• Worked with migrations and content security, performance tuning concepts and user interfaces.
• Trained Super Users to develop ad-hoc queries in BI Query Designer. The training included creating queries from various sources such as InfoSets, MultiCubes, use of aggregations and creating input parameters among other items.
• Responsible for development and extraction of data from ECC source system into BI from SD, MM and FI modules.
• Responsible for implementing FI-GL using Business Content DataSources and Cubes to deliver the Balance Reports.
• Designed and maintained InfoCubes, MultiProviders, RemoteCubes, ODS objects with consistent star schema and efficient multi-dimensional data modeling techniques.
• Extensively created custom cubes and DataStore objects by enhancing the business content also developed Write Optimized DSO’s for EDW layers and Standard DSO for Consolidation Layers.
• Created Generic DataSource in the ECC source system to facilitate Inventory Accuracy Rate reports like Quantity Difference, Quantity Count.
• Migrated users and roles using Lifecycle Manager..
• Configured Data Manager Packages to upload flat file using Conversion file and transformation files.
• Created Analysis Process Designer (APD) to extract pricing data into CSV file format for further analysis by using data transformations.
• Performed automated deletion of PSA and Change Log tables using Process Chains to improve the Data Management.
• Proposed and installed BW Statistics to monitor the Load and query performance on cubes and enhanced the performance by building aggregates on required objects. Injected BW statistics event in the process chain for Data collection.
• Implemented Compression and Partition techniques for cubes to improve the query response time. Proposed archiving strategy for future based on Time characteristics.
• Worked on the implementation of BI Accelerator. Involved in identifying cubes for BIA, Creating indexes and performing BIA index reorganization.
• Created reports from purchasing data sources like Purchase Orders Quantities, Purchase Order Values, Open/Closed Purchase Orders, % of confirming PO, Amount outstanding, and Confirmed Quantity.

Confidential, LA, CA

SAP BI/BO Consultant

Environment: s: SAP BI 7.3, Windows 2003 Server, SQL SERVER, BEx, Business Objects (XI). WEBI, Crystal reports, Dashboards

Responsibilities:

• Involved in full cycle implementation, which includes Gap Analysis, Requirements gathering, Blue printing, Development, Testing, Reporting, Go-live and Post Go-live support.
• Experienced in migration from Import wizard and LCM in Business Objects 3.1.
• Worked extensively on reporting and transactional structures, Database layers.
• Created BW OLAP Universes on top of BW Queries to access the BW data in Business Objects. Extensively used Calculations, Variables, Prompts and Sorted inputs, Drill down, Slice and Dice, Alerts for creating Business Objects reports and worked on Analysis and Visual intelligence.
• Worked with client team to help them make a decision on the selection of hand held devices based on end user usability, compatibility with SAP BoBJ Mobile Server and Tools supported.
• Active role in the design, architecture and development of user interface objects in QlikView applications.
• Lead the production support team to handle issues with the reports and the universe.
• Designed interactive and easy to interpret reports by incorporating exemptions and conditions.
• Designed customized reports and queries for priority customers and cost centers.
• In order to create single report retrieving data from different queries linked universes and merged dimensions at Web intelligence.
• Performed tasks on Rapidmarts to minimize risk with a modular framework that makes it easy to adapt to changing needs.
• Installed BO XI R2 SP2 on Linux, configured and validated the BO XI R2 after installation. Managed BO XI servers via CMC, created the folder and groups in CMC.
• Provided inputs on Issues faced, Steps Taken, Best Practices while converting/creating report for Mobile Devices
• Developed different planning workbooks, Input Queries required for CCA,PCA and Balance Sheet Applications and integrated planning sequences to buttons in the workbooks.
• Connected WebI reports to the Dashboards using Live Office, QAAWS and BI services and used these report’s data for designing specific and interactive dashboards.
• Worked extensively on designing dashboards with BI WAD and dashboards displaying dynamic visibility.
• Worked on validating the existing reports each time the Business Objects environment is upgraded.
• Experienced in using the Report Conversion Tool to convert Desktop Intelligence reports into Web Intelligence
• Created Interactive Dashboard reports for carrying out analysis of the various aspects of profit and cost centers
• Worked on direct connection between SAP BW Bex query to Webi by BICS connection in BO 4.1.
• Created WEBI reports and crystal reports and deployed them through info view with BW universe as source.
• Developed and conducted training programs for QlikView user groups and administrators.
• Scheduled reports using scheduler infoview as well as CMC.
• Designed and developed Business Objects Universe for Aging report.
• Performed Referential Integrity Check for both the Master Data and Transaction Data at DTP and transformation levels.
• Exported XML output for BW queries as a source for Xcelcius dashboards and worked on Design Studio.
• Worked in coordination with the basis team to Transport (DEV to PROD) the objects.
• Created necessary documentation throughout the project implementation. Conducted User Training for end users about the navigation features possible in the reports.
• Developed InfoSpokes using Open Hub service to extract data from BW into .CSV format.
• Created custom InfoCubes for company wide Sales, Delivery, Billing and Purchasing with various aggregate periods (business day of the year, business day of the month etc.)
• Migrated DataSources from 3.x to 7.0. Modified the business content update and transfer rules to transformation rules.
• Performed Remodeling on already existing InfoCubes to add new keyfigures and characteristics.
• Reviewed system statistics and other measures to identify the need for aggregates, indexes, compression and other performance improvement techniques.
• Responsible for compression and partition of certain cubes for enhanced performance. Proposed archiving strategy for future based on Time characteristics.
• Improved query performance and data load using OLAP cache.
• Created Price Purchase Variance (PPV) and Foreign Exchange Exposure (FX) reports. Created FI reports “Overdue analysis (Aging report)” “Payment History”, “Due date for net payment”.
• Generated Cost Center “Internal Order” report which provides an overview of the incurred costs and consumption quantities on an internal order group during the reporting timeframe and the fiscal year. Also developed reports such as Actual costs, Plan/Actual, Target/Actual.
• Created Variables, Restricted Key figures, Calculated Key Figures, Filters in the BW Queries. Built code for specific User exit variables and replacement path variables to capture the requirement for Year-to-date, Quarter-to-date and Month-to-date.

Confidential, Orange, CT

SAP BI/BO Consultant

Environment: s: SAP BI, Crystal Reports XI, Business Objects Xi/3.1, Designer, Web Intelligence, Windows 2003 Server, Teradata BEx, Business Objects (XI).

Responsibilities:

• Designed and developed various financial reports and later also customized the report using Report designer. The reports were based on the FI-GL Income statement, Balance sheet, Cash flow and Assets Management.
• Created report in Demand Planning Forecast Deconstruction which allows the business users to break down the forecast by size and distribution center.
• Created Universes and exported these to CMS for making it available to BO end users.
• Designed reports using universes as main data providers and created intricate queries using sub queries and loop prompts.
• Appended newly designed objects to Requests and Tasks and Transport them to Quality Analysis and Production system.
• Worked extensively on WAD (Web Application Designer) for creating and formatting web templates and created I-views for these templates.
• Developed customized and flexible queries using Web Intelligence, filters for multidimensional analysis of the relevant data.
• Worked with SAP Workforce Management for carrying out Business Forecasting and Analytical Analysis.
• Automated reports for weekly, monthly and yearly schedule using Crystal reports.
• Formed and maintained Report to Report Interface..
• Developed Activity vs Non Activity Forecast reports for business users which is to determine if the activity based forecast increases the statistical forecasting accuracy.
• Extensively created Formula Variables, Conditions, Exceptions, Exception Aggregation, Cell editors, Customer Exit Variables and Structures for developing complex custom reports.
• Linked reports using Open Document syntax to link master report to a detail report by creating hyperlink objects in the Universes and Reports
• Worked on Info Burst tool to burst the reports for business users, most of the bursting was done at quarter end and year end
• Developed Dashboards and Score cards for detailed analysis using Performance Management.
• Created complex reports by linking data from multiple data providers
• Created Web services using query as web service
• Created dashboards and presentations from spreadsheets by using Crystal Xcelsius
• Experience in Data Quality, Data Services & Data Federator
• Extensively involved in conducting and monitoring test results for Unit testing and Functional testing of several user exits and routines and user inter faces.
• Main responsibilities include Development, Enhancement, User Problems, Process Chain and Job Monitoring activities. The major supported SAP modules were FI, SD, and HR.
• Created custom cubes and activated transfer structure, transfer rules, communication structure and update rules (both ODS and InfoCube level).
• Created ABAP Routines in transfer rules and update rules for updating the Characteristics and Keyfigures according to the requirements.
• Extensively Worked on extracting HR data sources to develop the data model for Organizational Management (OM) and Personal Administration (PA), where using this data model reports were developed for the Business users.
• Created process chains to automate the scheduling of data extraction, ETL process, Monitored data loads.
• Developed Error DTP’s on Standard DTP for Error Stack.
• Involved in Performance enhancement features such as Cube Repartitioning, Indexing, Remodeling, maintaining Aggregates, Rollups and cube Compression. Responsible for enhancing the performance of system by addressing time consuming loads by fine tuning code or system parameters based on situation.
• Created HR reports for the scenarios like Average head count, Number of fixed-term employees at the end of month or quarter, Age distribution, Average service years, Gender ratio %, Starters % (YTD), Leavers % (YTD).

Confidential, Houston, TX

SAP BW/ BO consultant

Environment: s: SAP BW 7.0, Business Objects 3.0, Designer, Web Intelligence, Info view, Windows NT, ASP, SQL Server

Responsibilities:

• Analyze the reporting requirements with the business users and come up with the technical specifications for the BO Reports.
• Generating the Standards and templates for the reports, interfaces and the universes.
• Creating, maintaining and modifying the universes using Business Objects designer for CBR.
• Creating, maintaining and modifying the business critical reports using the Crystal Reports.
• Creating the reports using Business Objects functionalities like Multiple Data Providers, Prompts, Slice and Dice, Drill Down, Cross Tab and Master Detail.
• Created trend reports with charts and Bar Graphs on crystal and exported them to live office.
• Created Prompts for end users to enter the values of his own criteria to view the data using 6 different prompts which includes Division, year, Multi Unit.
• Performed both Unit and System integration testing of the Data marts.
• Testing of reports in Development Environment populating data from production.
• Using live office we had self service access to current information, updatable data in user documents, spreadsheets and presentations.
• Worked Extensively in Crystal SDK, JRC component and familiar with integrating complex report containing Parameters and sub reports with Java.
• Used Crystal Management Console for scheduling the reports which are saved in different format like Excel and PDF Format and then e-mailed to the Users.
• Published reports using Info view, and trained users for ad hoc reporting.
• Fixed several Defects in existing reports, created production release notes.
• Worked on BEx Query Designer in designing queries using Filters, Variables, Navigational Attributes and Structures to facilitate flexible, performance tuning concepts, QAAWS, detailed drill down data analysis to required level of information.
• Worked with Web Application Designer (WAD) for creating web templates for FI, PP modules, transactional structures. Created complex web templates, used interactive charts, and tables.
• Worked extensively on reporting for the extracted data and involved in creating role based security and authorization for all objects.
• Solved issues/tickets regarding Queries/workbooks. Used different techniques to resolve issues about queries and query output and satisfied the end users with the output results.
• Responsible for design, development and extraction from R/3 source system and Flat file to BW.
• Handled assignments where the responsibility was to activate standard InfoCubes and create custom cubes.
• Designed custom cubes and Operational DataSources, developed delta management functionality and optimal use of update rules keeping query performance in view.
• Worked on HR Personal Administration, to report on Head Count, Personal Actions, Recruitments and Salary Distribution by cost center etc.
• Enhanced Master DataSources for Employee to get additional data like base location, University, highest level of qualification to suit the business reporting requirements.
• Created reports for FI module like sales and profit, Reconciling data in CO-PA, Purchase price variances (PPV).

Confidential, IL

SAP BW BO Developer

Environment: s: SAP BW 3.5, SAP R/3, Desktop Intelligence, Web Intelligence, Info view, CMC, NET, SQL SERVER, DB2

Responsibilities:

• Business Objects XI R2 Administration and handled clustered environment with 400 users.
• Created Technical design documentation for universe and ensure the thorough and accurate testing.
• Interacted with business analyst and users to identify reports requirements and transform it in to reports specification and develop reports.
• Creating new jobs, workflows, data flows, data stores, functions, and transformations in Business objects - Data Integrator.
• Efficient in Optimizing, Debugging and testing SQL queries and stored procedures written in Oracle and also working on Toad to tune the SQL.
• Created complex objects and condition and resolving loops using context and alias.
• Created complex reports using multiple data providers, filter and breaks. Created complex variable and formula.
• Development of performance dashboards enabling business intelligence reporting (BI) including benchmarking, metric identification
• BO System usage monitoring, BO Security design and implementation, BO Central Management Console, BO Info View.
• User Creation and Security at different levels of Hierarchy in management.
• Implement Data Level Security in Universe, Folder, and Application wise.
• Worked with Import Wizard. Created Daily and Weekly BIAR Files. Import and Export One Environment to Other Environment. (Groups and Users List and Universes and reports and Dashboards.)
• Involved in writing Unix Shell Scripts for Automated process of Scheduling.
• Created Purchase order control report, this report will show the statuses of Purchase orders and Sales orders in particular the third party purchase orders and sales orders.
• Developed an interactive report to list the purchase orders details for a vendor that has interactive drill down options to give the details of vendor from vendor master.
• Designed making extensive use of the ODS capabilities, delta management functionality and optimal use of update rules keeping query performance in view.
• Effectively designed and presented reports.
• Developed process chains to automate the initializing of data upload processes.
• Formed ODS objects for capturing erroneous data.
• Worked on BEx Query Designer in designing queries using filters, variables, navigational attributes and structures to facilitate flexible, detailed drill down data analysis to required level of information.
• Created variables for Currency Conversion Types and used variable offsets for comparing data between periods and for value ranges
• Created reports which display sales order and line items, which needed to be delivered on a particular date.
• Created variables with user/sap exits, calculated key figures, formulas and structures in query development, working with workbooks, exception reporting, conditional reporting.
• Extensively involved in production support issues involving data loading, monitoring, and batch issues.
• Maintained extract structures for Purchasing, Inventory and Sales & Distribution. Generated data sources & activated the extract structures for the above modules. Scheduled data uploads in cockpit.
• Designed and developed custom ODS objects, InfoCubes for Inventory data and activated Update rules for these data targets.
• Responsible for job schedules for loading Master data (Texts, Attributes and Hierarchies) for Materials and Sales arenas.
• Extracted the data using logistics from Sales and Billing DataSources to populate the Custom InfoCubes that evaluates quantities and values for sales orders, deliveries and returns, and invoices.
• Created InfoPackages with Full Loads, Delta loads, Initialization with/without data transfer etc. Tested the data loadings, delta loads and verified data with R/3 side.
• Worked on creating start routines and end routines in update rules to ensure proper loading of data.