SUMMARY

• Around 7 years of experience as SAP BO Developer 3.x/4.x and Administrator in SAP Business Objects 4.x, SAP Design Studio 1.5, SAP Lumira 1.25, OBIEE Report Development, designing, deployment of Crystal reports and enterprise reports, OLTP and OLAP and Microsoft Excel; gained significant exposure in direct client facing, trouble shooting and Client Management capabilities.
• Exposure on Business objects Administration, integration Business Objects environment with other platforms like Tomcat, IIS.
• Experience in crystal report designing and migration from development to production environments.
• Provided extended Support in production environment on the issue with monitoring, testing and performance tuning on the reports, which are facing issues.
• Proficient in Central Management Console by maintaining security for Users and Groups on Folders and applications which are limited to the confined groups and setup as per their security privileges.
• Scheduling and monitoring the reports in BO environment and also troubleshooting on the schedule failures and setting up notifications to the report owners.
• Extensively worked on BI Launchpad by developing reports, which meet business requirements, and deploying them to other environment through LCM/Import Wizard in CMC.
• Exposure on CMS Job Server, Processing Server, Triggers, Server management and monitoring system performance from BO Instance Manager.
• Knowledge on Unit Testing, Integration testing to check any issues in the report and Universes which are deployed to other environment.
• Experience on the Multi - environment deployment throughout landscape.
• Exposure on the Architecture of Business Objects and installation and configuration of Business Objects.
• Exposure on Upgrade Management Tool for upgrade on SAP Business Objects from R3 to R4.
• Excellent proven technical documentation skills.
• Skilled in analyzing current business processes, determining System requirement, reporting needs, and configuring applications to match those needs while incorporating best business practices.
• Involved in Development and Implementation on KPI Dashboards and Customer Performance Dashboard for M&S Process Area in Confidential Project.
• Experience with Data Warehouse concepts, and methodologies, as well as strong knowledge with star schema and snowflake schema data models.
• Experience on Promotion activities and transporting them to other systems throughout the landscape.
• Requirement gathering by interacting with End Users and conducting work sessions within the team to meet the deliverables.
• Worked on Agile Methodology as well as on SDLC procedures in the implementation of Tableau Dashboards to Design Studio dashboards.
• Thorough understanding of managing the complete scope of tasks.
• Proven skills in understanding how to help a team identify, prioritize, and solve job related problems.
• Experience on development in RDBMS Oracle server.
• Setting up OBI Security for Metadata Objects (Users and Groups) access privileges and web catalog objects (Dashboard, Pages, reports and Folders) and Implemented Security by creating roles & web groups.
• An effective communicator with excellent relationship management skills and strong analytical, problem solving & organizational abilities.
• Experience configuring interactive dashboards with Drill-Down capabilities using Filters and Dashboard prompts.
• Exposure in Business Objects XI R4.1/R4 Enterprise suite using IDT, web intelligence reporting, and Dashboard Design Tool using QAAWS and Live Office.
• Exposure on SAP Lumira, Analysis Office and Design Studio and designed even POC’s on sample Universe and BEx data source in development environment.
• Having knowledge in all phases of System Development Life Cycle (SDLC).
• Ability to comprehensively understand data sources, relationships and locations.
• Tuned and enhanced universes with SQL queries for the report performance.
• Created extensive custom joins for blending data from several different data sources.
• Helped customize Tableau Server with Company Logo and Company Pop-Ups.
• Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics.
• 7.0Years of experience in Administration, analysis, design, development, and testing in Business objects XI R3/R4, Designer, IDT, Dashboard Design Tool, CMC, Web Intelligence, SAP Lumira, Design Studio, Analysis Office.
• Good knowledge in using end user ad-hoc reporting Info view, migration tool Import Wizard. Exposure in Central Configuration Manager (CCM) and Central Management Console (CMC).
• Ability to comprehensively understand data sources, relationships and locations.
• Designing UNIVERSE and creating WEB INTELLIGENCE reports, scheduling and publishing the reports.
• Experience in Business Objects XIR4in creating WEB INTELLIGENCE reports and publishing them to Business Intelligence Launch Pad.
• Exposure on SAP LUMIRA, Design Studio and Analysis Office.
• Experience in Migration older version reports to newer version reports.
• Responsible for any Universe object changes and implemented level of securities in particular universes.
• Excellent communication, interpersonal, analytical and technical skills.
• Good understanding of Data warehousing concepts and Data modeling.
• Responsible for any Universe object changes and implemented level of securities in particular universes.
• Using Crystal 2008 to generate reports based on requirements from Risk Management and some other Line of Business.
• Assigning Securities to Folders to relevant groups. Creating documentation for testing in processing Change Requests (CR’s) in Service Centre and also creating testing templates for users to post their testing instructions and results.
• Managing local folder structure in local file share server and assigning securities to particular users.
• Monitoring reports for different zones and its respective functional teams or departments.
• Worked on Agile and Waterfall Methodology on the implementation projects.
• Creating Backups BIAR Files for Universes, folders, connections and reports, therefore transporting them to different systems in landscape by using Promotion Management.
• Change coordinator for analyzing risks of implementing changes and coordinating to the implement the significant changes.
• Set up drill down functionality, alerts, and dynamic visibility to create interactive visualizations.
• Creating RRMX outputs of BEX reports into Analysis Excel reports for clear analysis and understanding on the data, which is required to reproduce proper results on the respective process area.
• Involving in UAT with users.

TECHNICAL SKILLS

ERP: SAP R/3 4.6C

Data Warehouse: SAPBI 7.3

Languages: C programming, HTML.

Operating Systems: Windows 9x/XP/2000,Linux

Databases: ORACLE, SQL SERVER2000

Business Analytic Tools: Design Studio, Analysis Office, Lumira, Crystal Reports

Methodologies: Agile, Waterfall and Iterative Waterfall

PROFESSIONAL EXPERIENCE

Confidential, California

SAP BO Lead and Administrator

Environment: Technology: CMC, CCM, SAP BW 7.3 and SAP BO 4.1 SP4, SQL Server, Web Intelligence, SAP Lumira, SAP Design Studio, Tableau 8.0

Responsibilities:

• Created workbooks and Dashboards using calculated metrics for different visualization requirements.
• This project was implemented on the Tableau Dashboard and SAP Design Studio dashboard.
• Drew upon full range of Tableau platform technologies to design and implement proof of concept solutions and create advanced BI visualizations.
• Web Intelligence Dashboard developed on SAP BW Query via BICS Connection.
• Involved in Estimation of this report as per Iterative Waterfall Methodology.
• Created traffic signals in Table cells by indicating the values which are positive and negative.
• Bar graphs in table cells indicating trends on the customer performance.
• Created Bubble chart based on the customer contribution projecting the trends on different quantitative measures.
• Created Rich Graphic visualization/dashboards to enable a fast read on claims and key business drivers and to direct attention to key area.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Created Technical design specifications on the report for future review and diagnosis on future issues.
• Knowledge transfer to the Centralized Quality Check team for testing on the BO report quality standards and guidelines on the quality of the report before moving it to Regression testing.
• Using same BEX query developed a POC on SAP Lumira, Infographic and developed storyboard replicating the Customer Performance.
• Composed story for SAP Lumira Visualization on the customer trends, sales and contribution.
• Resolved huge data problem in production system by splitting up the query and pointing the variables to appropriate query.
• Created variables to represent the icons, bar trends, graphs in cells and also arrows, which indicate the values up and down.
• Acquired knowledge on SAP Design Studio and Analysis Office.
• Analysis of the specifications provided by the client.
• Prepared Technical Design Documents for Universe and Web Intelligence reports.
• Analyzed the BEx Query from Generic Connection, which is data source for Customer Dashboard in BW front end RSRT interface.
• Worked on Promotion Management (Transporting the BIAR file, Creating the CR in YIAAT and in Service Center) across the landscape from DEV to Production
• Training the team on technical and process overview.

Confidential

SAP BO Developer, D&B Specialist

Environment: BW 3.5 & BI 7.3 Web Intelligence, SAP Lumira, AFO, IDT, SAP BW 7.3

Responsibilities:

• Analyzing the Build Specs on Proper Estimation of the project to deliver on time.
• Delivered project on time as per the estimation.
• Developed various Charts, Graphs, Scorecard and drill down reports.
• KPI evaluation reports development in BI 4.1 Webi using BEx queries.
• Designed POC on SAP Lumira Info graphic and Design Studio Dashboard based on the KPI BEx query and even on the excel sheet data which represents the KPI data for designing the dashboard.
• Created technical documentation on the KPI Dashboard that was developed basing on the BEx query and Excel data.
• Created some value added features on the sample data of KPI data using AFO.
• Designed, Developed and Unit tested various complex reports using Web Intelligence.
• Creating Universe using Universe design tool and Information Design Tool.
• Generated Custom variables, groups and formulas in Business Objects.
• Created Visualization using SAP Lumira and composed storytelling to the Info Graphic.
• Created High level design document of Webi report for KPI.
• Created complex reports with multiple data providers.
• Collaborated different data providers of Audit Universes and merged them to get common data.
• Extensively used Merged Dimensions, Functions, Variables, fold/unfold, sections, alerter, drill, functionalities within Web Intelligence.

Confidential

SAP BO Developer and Administrator, D&B Specialist

Environment: BW 3.5 & BI 7.0 CMC, CCM, BI Launch Pad, Web Intelligence Rich Client, Web Intelligence, IDT

Responsibilities:

• Analyzing the data issues/data mismatches in reports with source system data.
• Running Reconciliations and Realignments to correct the data.
• Analyzing the data issues/data mismatches in reports with source system data.
• Running Reconciliations and Realignments to correct the data.
• Involved in Cognos Elimination of the reports from all environments for compliance.
• Ticket analysis and resolution based on priority.
• Worked on Reporting Tickets from Market.
• Creating BIAR files for universes by using Promotion Manager.
• Extracting all relevant data for user management, XLS management using VBA Macro build Excel Spreadsheet.
• Involved in Administrative activities by creating New secured Folder for different markets around the Globe.
• Worked with different markets around the Globe and creating Respective AD groups for respective folders.
• Review/providing the solution for the incidents raised by the business users.
• Data Analyzing between SAP BW and SAP BO among web intelligence reports.
• Sending Status Mails & Market Communication Mails at Market Go-Live time.
• Assisting junior team members in error resolution during data load and any other technical issues.
• Worked on Promotion Management (Transporting the BIAR files, Creating the CR in YIAAT and in Service Center) across the landscape from DEV to Production
• Training the team on technical and process overview.

Confidential

SAP BO Developer

Environment: (with skill versions) BW7.0; Oracle 10g Web Intelligence, Web Intelligence Rich Client, BI Launchpad, UDT, IDT, Crystal Reports.

Responsibilities:

• Interacted with functional/end users to gather requirements of core reporting system to understand exceptional features users expecting with reporting system and also to successfully implement business logic.
• Participated in developing the Relational Model (Logical & Physical) and in documentation of technical methods of development as well as business related information regarding the design process.
• Reviewed User Requirements. Created detailed Functional Design Documents and Report design details documents for the reports.
• Involved in training the end user in basic and advanced Ad Hoc reporting as well as to create queries, format results, and share them with others within the enterprise and using Web Intelligence.
• Created Crystal reports using the legacy Requirements Documents.
• Involved in gathering requirements and requirements study, design reviews and analysis of input/output flow.
• Designed Web Intelligence reports on Customer Credit Processing and also used master detail feature to elaborate the deep understanding of the hierarchies, which are setup in the semantic level.
• Created Aggregate and derived tables for tuning up the performance of the Universe, also implemented shortcut joins to avoid loops formed during the integrity check.
• Coordinating with Database team for the database design and Created SQL quires for extract data from oracle database.
• Conducted weekly meetings to gather the necessary requirements.
• Designed Universe(s) for Insurance Claim, Financial and Billing system and Claim Order processing.
• Created Objects and prepared Reports like Financial reports, HR reports, standard, Adhoc reports, and universes
• Working with different kinds of Transformations for implementing simple and complex business logic.
• Extensively used Toad and Query Analyzer to verify if the data pulled by the report is correct compared to the database data.
• Based on Requirement Created complex crystal reports using the data from several database like Sybase, SQL Server and Oracle server database.
• Configuring IIS Server and Single-Sign-On application.
• Responsible to talk to business users and finalize on any enhancements.
• Hosted weekly status meetings to update and explain the work expected from them in coming week as well as get status on work completed to crystal developers.
• Responsible to trouble shoot problems incurred on parameter tool communication to Enterprise System.
• Resolved the Performance issues/Data issues within the Reports and Procedures.
• Created complex report using with 46 Sub reports, cross tab, custom functions, formulas and Suppressing conditions and Used advanced features like Dynamic and cascading Prompts.
• Exported Reports into PDF, Excel, word & RTF from Enterprise and resolved formatting issues.
• Worked extensively with the major functionality of BO like Breaks, Ranks, Alerter, Variables, Formulas, Filters, Sorts, Query prompt, Hyperlinks in Webi.
• Performed Administration tasks for our Project, Which Included Creating Folders, creating users/ Groups on Central Management Console and giving Appropriate Access levels.

Confidential

SAP BO Developer

Environment: (with skill versions) BW 3.5, BW 7.0 Dashboard Design Tool, Web Intelligence, BW query designer, SQL Server, UDT.

Responsibilities:

• Understood the functional design specifications and technical design documents.
• Prepared POC’s for client reviews.
• Created interactive multiple Dashboards by using Xcelsius Live office and QAAWS in order to test the performance of the dashboard.
• Created universe on top of the Oracle database in order to create queries by using QAAWS.
• Developed visualizations of complex data using filters, charts, single value components, selectors, and other components
• Add custom formatting, graphics, and animations Publish models in multiple formats.
• Set up drill down functionality, alerts, and dynamic visibility to create interactive visualizations.
• Transferring Knowledge (KT session) to the client for modules developed.
• Prepared training approach documents and unit test cases.
• Involving in UAT with users.

Confidential

SAP BO Developer

Environment: Informatica DW, Crystal Reports

Responsibilities:

• Created two complex dashboards, which use live office to feed the data into Xcelsius from source, Web Intelligence reports.
• Exported dashboards to server in different formats (PDF, SWF, and HTML) for end users and exported dashboards into XLF format in order to make available for other dashboard developers.
• Designed and developed Web Intelligence reports using features like Master/Detail, Charts, Crosstabs and drill down.
• Extensively used Calculations contexts, Variables, Breaks, Sorts and Alerters for creating Web I reports.
• Implemented row-level and Object-level securities in Universes for required groups and users.
• Designed Crystal reports for existing universes and created them on SAP as the source.
• Created complex Web Intelligence reports by linking objects from different data sources by using Merge Dimension option.
• Formatted Web Intelligence reports and scheduled them to be bursted as PDF to the report to web server.
• Created Classes, Objects, Prompts and Predefined conditions and user defined objects and enabled easy drill down by customizing hierarchies in the Universes.
• Tested Universes by using check Integrity before exporting and even tested reports before migrating them to the server.
• Published and Developed reports from BO repository.

Confidential

SAP BO Developer

Environment: Oracle, Crystal Reports

Responsibilities:

• Attended Business meetings and assisted business analysts in gathering requirements.
• Interacted with the SAP BW team members to understand the BRD’s and convert them into tangible specifications to implement them in report specifications.
• Interacted with Users and Business Analysts to understand and document the requirements and translate these to technical specifications for designing Universes and Business Object Reports.
• Created Universes from SAP BW/BI, BEX queries, info cubes.
• Embedded reports directly into developed web applications and thick client report generation.
• Designed Universes and used @functions like @prompt (user defined queries) @where (for creating conditional filters) and @select creating duplicate objects in the process of building reports in Universes.
• Having KT with ETL team on any report specifications and understanding the requirements and feasibility.
• Created Universes and resolved loops by using aliases and contexts.
• Enabled drilling options on the reports according to different aspects of client business.
• Tested Universe and reports, verifies the data by running SQL against the database.
• Tested Universe and reports, which includes database connectivity and aggregate awareness to ensure the query is pulling the correct level of aggregation.
• Mocking up the data considering security and confidential data. Thorough Documentation of all the Reports with Report definition, field definitions and layouts.
• Created documentation of unit test cases.
• Created templates on top universes and SAP BW.
• Created templates in local mode and BI platform mode by selecting the mode in preferences.
• Used all predefined templates, which are available in the design studio version 1.3.
• Change and analyze the data in different ways by using the “EDIT INITIAL VIEW” option.
• Filter the data by using various filter methods, which are available in “EDIT INITIAL VIEW” option.
• Used display options of data in “EDIT INITIAL VIEW” option.
• Created templates by using TAB STRIP, PANEL, Page Book, and Grid, Radio button, Filter Panel and charts.
• Displayed components based on selection by using Dynamic Visibility.
• Implemented bookmarks by using BUTTON component.
• Implemented alerts in charts.
• Executed Application in both local and on BI Platform.
• Experience working on Agile(Scrum) methodology on developing Design Studio Dashboards.
• Worked on Business Analytics Dashboard based on the Audit BW data source.
• Designed pre-defined template for creating Confidential Dashboard.
• Procurement dashboard by migrating Tableau Dashboard into Design Studio dashboard.
• Created Custom CSS codes for presenting good visualizing dashboards.
• Creating Dataset from BW, Excel, Universes and editing the acquired dataset.
• Modifying columns and its data type and also changing the date formats using Split function.
• Installation of SAP Lumira and creating good effective storyboards to show the profit margin on particular set of products.
• Modifying the datasets in the Lumira Desktop based on the requirement to create good visualization dashboard.
• Providing support to end-users on the usage of the datasets and providing training sessions to them on the understanding of the data sets.
• Providing documentation on the usage of Lumira Desktop to users for their easy understanding on the data.
• Acquiring data from multiple excel work books.
• Creating Measures and time hierarchies with some longitude and latitude data.
• Manipulating data in prepare room as per Lumira Visualization.
• Creating calculated figures and dimensions and functions to get appropriate data.
• Working on chart builder and filtering data in measures and dimensions panel.
• Creating story with some Pictograms and shapes to enrich the visualization.
• Linking of another page in same story and adding dynamic text to a story.
• Working with Cross tabs in stories.