SUMMARY

• 8 Years 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, and Analysis Office, Crystal Reports and Crystal Reports Enterprise, ODI.
• Exposure on Business objects Administration, integration Business Objects environment with other platforms like Tomcat, IIS.
• Ability to learn new technologies and meeting with fast paced environment.
• 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.
• Experience in crystal report designing and migration from development to production environments.
• Designing UNIVERSE and creating WEB INTELLIGENCE reports, scheduling and publishing the reports.
• Experience in Business Objects XIR4 in 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.
• Exposure on migration of Business Objects from 3.1 to 4.0.
• Conversion of Deski to Webi reports by using Report Conversion Tool.
• 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.
• Designed complex reports from SAP BEX queries by using Analysis Office on Excel and also PowerPoint.
• Prepared sample dashboards by using SAP design studio in order to provide the in-depth training for Confidential market users and also Tech-M offshore resources.
• 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.
• Working on BEX Reports using Query Designer and Analyzer migration to Web Intelligence reports.
• Experience on Data visualization tool SAP Explorer.
• 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.
• Experience on SAP Lumira, Analysis Office and Design Studio and designed even reports and applications on Universe and BEx data source in development environment.
• An effective communicator with excellent relationship management skills and strong analytical, problem solving & organizational abilities.
• Experience with Data Warehouse concepts, and methodologies, as well as strong knowledge with star schema and snowflake schema data models.
• Knowledge on SAP BPC and Informatica.
• Skilled in analyzing current business processes, determining System requirement, reporting needs, and configuring applications to match those needs while incorporating best business practices.
• 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.
• Excellent proven technical documentation skills.
• 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.
• Experience on Software Development Life Cycle (SDLC) and involved on all stages on the project implementation.
• Experience on Oracle SQL and SQL Server.
• Experience on creating Analysis Office reports which are based from BEX queries.
• Experience on BO Report development from RDBMS Oracle server.
• Involving in UAT with users.

TECHNICAL SKILLS

ERP: SAP R/3 4.6C

Data Warehouse: SAPBI 7.3

Languages: C programming, HTML5, Java Scripting, CSS.

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

Databases: ORACLE, SQL SERVER2000

Business Analytic Tools: Design Studio, Analysis Office, Lumira, Crystal Reports, Explorer, Web Intelligence, Dashboard Design Tool, BEX Query Designer, Analyzer.

Methodologies: Agile, Waterfall and Iterative Waterfall

ETL Tools: Informatica, ODI.

PROFESSIONAL EXPERIENCE

Confidential, San Jose, California

SAP Business Intelligence Analyst

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

Responsibilities:

• Requirement gathering by conducting business meeting sessions with users on the reports and dashboards.
• Developing Universe using Information design tool and considering the tables which are required for business and also performing data modeling in then IDT.
• Involved in administrative activities like assigning security for groups and application as per user security privileges.
• Administration and supervise configuration of all business objects.
• Involved in data modeling task that is performed in Oracle SQL Developer.
• Documentation on all business objects and metadata and supervise security of all areas.
• Coordinating with various departments and configuring all ETL extractors as per SAP requirement.
• Providing support to all SAP Business Objects and providing appropriate upgrade on environment.
• Designing ad hoc reports on top of relational universe by using Web Intelligence.
• Ensuring compliance and best practices as per business standards and preparing reports as per business requirement.
• Created DEBS operational dashboard using Dashboard Design Tool which is significant for CALWIN functional area.
• Evaluating all data from end users and preparing dashboards as per their requirement.
• Working closely with user community and developed various functional specifications.
• Troubleshooting issues which are caused in production environment.
• Documentation of test cases on the UAT testing that are performed by the end users before migrating the project to production environment.

Confidential, California

Process Area Lead

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.
• Created Web Intelligence report on Customer Performance for Marketing and Sales process area.
• Implemented complex features in Web Intelligence report by dynamically representing dashboard functionality in Webi.
• Implemented Traffic Signals to represent trends on Customer on each department involved.
• 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.
• 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.
• 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.
• Created Analysis Office Excel reports from BEX reports which are based on SAP Data source (SAP BW).
• 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.
• Created Marketing Sales trend Data visualization in SAP Explorer Information Space.
• Training the team on technical and process overview.

Confidential

Team Lead

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 Webi Report based on the KPI ‘s of Service Governance of Confidential and also documented the whole report creation steps for future reference.
• Represented different KPI’s on Explorer.
• 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.
• Prepared visualizations on Universe in Development system and from multiple workbooks and also from BEx query on customer performance.
• 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 workbooks.
• 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.

Confidential

Administrator

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.
• Involved in Cognos Elimination of the reports from all environments for compliance.
• Exposure on visualizing data by using Exploration Views in Explorer.
• Created Master/detail report in Webi based on the hierarchies, which are coming Universe.
• 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.
• Provided extended Support in production environment on the issue with monitoring, testing and performance tuning on the reports, which are facing issues.
• Worked on 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.
• Worked with different markets around the Globe and creating Respective AD groups for respective folders.
• Set up drill down functionality, alerts, and dynamic visibility to create interactive visualizations.
• Created Reports from BEX queries by using Analysis Office for Excel.
• Troubleshooting many issues faced by End users on the Analysis Office.
• 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.
• Scheduling and monitoring the reports in BO environment and also troubleshooting on the schedule failures and setting up notifications to the report owners.
• 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:

• Interacted withbusiness users, business owners to know their Business views in developing, modifying universes and report development.
• Analyzed the existing database and created/modified theUniversesusing Business objectsDesignerModule.
• Created new Classes, Objects and Conditions. DetectedCardinalitiesandLoops. Resolved the loops by creatingAliases andContextsand checked the Integrity of the Universes.
• Exported the universes to theRepositoryto make the resources available to the users.
• Used the functionality oflinking universesso as to have the flexibility to use the objects defined in one universe in another.
• Created standardFull ClientandWeb Ireports based on business requirements with drill down functionalities.
• Reports were formatted according to the user requirements using Business Objects functionalities likeBreaks, Calculations,Slice and Dice, Drill Down and Variables.
• Organized data in the reports usingFilters,Sorting,Rankingand highlighted data usingAlerter.
• Managed the Servers using the Central Configuration Manager (CCM).
• Responsible for setting up theUsers/Groups, assigning the privileges to the Users using Central Management Console (CMC).
• Used Import wizard to import existingUser accounts,Groups,Categories,Universes,Web I Reports,Connections andUniverse restrictionsto BO XI R2 environment.
• Created complex reports inWeb IntelligenceandDesktop Intelligenceusing advanced functionalities like report level prompts, scope of analysis and ranking.
• CreatedWeb Ireports with multiple data providers and synchronized the data usingMerge Dimensionsoption in BO XI R2.
• Linked reports usingOpen Documentsyntax to link master report to a detail report by creating hyperlink objects in the Universes and Reports.
• CreatedCrystal reportsusingBusiness ViewsandUniversesas data providers.
• Created new Universes specifically designed for creation ofDashboards.
• Responsible for creatingDashboards,Metrics,Rules,AlertsandGoalsusingPerformance Manager (EPM) XIR2for user analysis based on user requirements.

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.
• Extensively worked on flash variables and XML data source and also works on custom web services.
• Implemented performance tuning techniques on the Xcelsius dashboards.
• 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

Junior 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.