Sap Bi Consultant Resume
Cincinnati, OH
PROFESSIONAL SUMMARY:
- Having 11+ years of experience in software design, development in fields of Client/server technologies which includes extensive experience in Business Intelligence tools BI 4.2 SP3, BI 4.1 SP4, SP2, SP4, 4.0 SP4, SP5, BO XI R3.1, XI R2, 6.x, 5.x, Crystal Reports 10, XI, XIR2, and Crystal Xcelsius 4.5, 2008, Dashboard Designer and SAP Design Studio 1.1 and 1.3.
- Knowledge of Installing and Configuring BI 4.0 along with publishing Webi Reports and Dashboard into Mobile (tablet and phone) devices.
- Expert knowledge in SAP Design Studio and Lumira (SAP Lumira 2.1 Designer and Developer tools).
PROFESSIONAL EXPERIENCE:
Confidential, Cincinnati, OH
SAP BI Consultant
Responsibilities:
- Involved in an ongoing development project for WebI, Lumira dashboards for PG BI team.
- Was hired to assist in the UAT phase of the project in fixing the defects raised by users.
Environment: SAP BI 4.2 SP6, SAP Lumira 2.2.
Confidential, Spring, TX
SAP Lumira Consultant
Responsibilities:
- Grow, Value and Simplify (GVS) is a Downstream business project of Confidential in developing front end and backend applications for the team which came into existence because of the re - org in Downstream.
- This is an SAP America implementation project of Reporting Analytics for Confidential Downstream to develop more than 100 Design Studio dashboards and 400 Webi reports and also to avail SAP Analytics Cloud for users who need self-service capabilities for their day to day reporting needs.
- Worked extensively with end users by conducting workshops to derive the reporting needs for users.
- Created functional and technical design documents based on the inputs from the workshops.
- Worked with Design team of SAP to create mockup visualizations for sign-off from users and build real-time dashboards connecting to HANA Views.
- Developed more than 11 Design Studio/Lumira dashboards and 50 webi reports as part of the project.
- Involved in the upgrade of Design Studio to Lumira and converted all the project files to Lumira 2.1 as part of the upgrade project effort.
- Worked on Setting up access for project users who need self-service access in SAP Analytics Cloud.
- Trained users on how to access HANA Views through the connection and create Models on top of views.
Environment: SAP BI 4.2 SP4, SAP Design Studio 1.6 SP5, SAP Lumira 2.1, SAP HANA 1.0 SP12
Confidential, Silver Spring, MD
SAP BO/Design Studio Consultant
Responsibilities:
- Scope of the Project was to develop Dashboards and reports connecting to SAP systems feeding information from BW BeX queries and SAP HANA Views directly.
- Installed and configured SAP BI 4.2 SP3 at Discovery in Dev and Prod environments by setting up SSO through LDAP authentication.
- Setup more than 300 users in the system to access reports and dashboards.
- Developed dashboards and WebI reports connecting to SAP HANA views and BeX queries directly.
- Had to develop Universe in situations where Ranking was not a possibility in Design Studio where the backend was HANA Views.
- Created multiple dashboards and webi reports linking the reports to the dashboards and passing parameters from dashboard to webi reports for detailed view of the data.
- Trained the users on developing individual storyboards connecting to backend sources like HANA Views, BEx queries.
Environment: BI 4.2 SP3, Web Intelligence
Confidential, Dallas, TX
SAP BO/Design Studio Consultant
Responsibilities:
- Confidential was planning to move from Tableau dashboards to SAP BI suite reports and dashboards that are being used by their Operations business users.
- The project was to deliver a POC initially to show how the data can be transformed into SAP HANA and then utilize SAP Business Objects tools like Web Intelligence reports, Design Studio dashboards, Lumira storyboards for the successful decommissioning of tableau reports.
- Worked with Tableau users to understand the current tableau dashboards and convert them to SAP BI reports and dashboards.
- Developed dashboards and reports connecting to HANA views using Design Studio 1.5/1.6.
- Configured the Mobile Categories in BI environment for the reports and dashboards to be able to publish in the Mobile Categories so users should be able to retrieve them in iPad.
- Trained users on developing Lumria Storyboards for their Data Discovery daily needs.
Environment: BI 4.1 SP6, SAP HANA SP11, Design Studio 1.5/1.6.
Confidential, Lansing, MI
SAP BO/BI Consultant
Responsibilities:
- Worked in an ongoing project by Confidential at the client for report and design studio dashboard development.
- Worked closely with Business Users in getting the sign off on the dashboards as per the Guided Analytics process that was promoted by the implementation partner Confidential to the client.
- Backend source for the reports and dashboard were Bex queries.
- Developed one Design Studio application and 3 webi reports.
Environment: BI 4.1 SP4 (BI Launch Pad), SAP Design Studio 1.5, BICS connectivity.
Confidential, Houston, TX
SAP BO Consultant
Responsibilities:
- Was one of the consultants hired by SAP America to be a part of Design Studio implementation at Exxon Mobil.
- Developed two Design Studio dashboards based on the requirements analyzed by the Functional analysts from SAP.
- Exxon was one of the clients to participate in Beta testing of Design Studio 1.5 performance enhancements. Participated in the beta testing of DS 1.5 and provided feedback.
Environment: BI 4.1 SP5 (BI Launch Pad), SAP Design Studio 1.4/1.5, BICS connectivity.
Confidential, Lake Forest, CA
SAP BO/BI Consultant
Responsibilities:
- Confidential had an old system of BOBJ XI 3.1 with only 120 end users, and wanted to revive the system to be able to create Mobile compatible reports and dashboards by upgrading to latest version and adding more users to the system.
- Migrated the existing webi reports from XI 3.1 to BI 4.1 SP4 system. New reports were created in this process and some old reports were retired.
- All the dashboards and reports developed were to be completely mobile compatible as they were being accessed by the Sales personnel all over the globe through SAP BI Mobile App.
- Setup documentation process for Promoting reports and dashboards from Dev to QA and QA to Prod.
- Was responsible for taking care of the promotion from Dev to QA and QA to Prod.
- Opened multiple OSS messages to SAP to notify the issues identified in Webi reports once enabled in Mobile APP.
Environment: BI 4.1 SP4/SP5 (BI Launch Pad), Information Design Tool, SAP BI Mobile Server, Business Objects XI R3.1.
Confidential, Springdale, AR
Business Objects Consultant
Responsibilities:
- Was part of a project implemented by Hitachi which was an overhaul of different ERP and reporting systems used at Confidential .
- Interacted with Business Analysts, Business Users and Managers in Understanding existing business model and customer requirements and gathered the business requirements.
- Developed Universe and Webi reports as part of the project.
- Configured the SAP BI Mobile App and Mobile Categories for the users to be able to open the webi reports and dashboards in Mobile applications.
- Held training for end users who are interested in the availability of reports in mobile application connecting to BO Enterprise
Environment: BI 4.1 SP2/SP4 (BI Launch Pad), IDT, Webi Rich Client, Information Design Tool, Design Studio 1.2/1.3
Confidential, Dallas, TX
Business Objects Consultant
Responsibilities:
- Worked closely with the Operations team to build a Reporting solution in mobile applications through SAP BI Mobile App.
- Done workshops and involved in gathering the requirements of the project to define the KPI’s for the Executive Dashboard project.
- Twelve Webi reports and Seven Dashboards were developed as a part of the solution that was designed to be completely Mobile compatible.
- All the webi reports and dashboards were developed in view to be mobile compatible.
- A user can launch all the webi reports when clicked on certain areas of the dashboards.
- Used the SAPBI open document syntax to link the dashboards to each other in the mobile version and to link webi reports to the dashboards in the mobile version.
Environment: BI 4.1 SP2 (IDT, Web Intelligence, BI Launch Pad), Dashboard Designer 4.1 SP2, SAP Design Studio 1.2, SAP BI Mobile Server, SAP HANA Data Marts, SAP BW 7.3, IBM Netezza.
Confidential, Houston, TX
SAP BO/BI Consultant
Responsibilities:
- Installed and configured the SAP BI 4.0 SP05 version in Production and Development servers of Confidential
- Prepared high level documentation for the installation of BI Platform 4.0 SP05 on Server and Client Installations.
- Successfully established connectivity to SAP BW and SAP BOBJ in CMC.
- Configured BI Mobile Server in SP05 for the dashboards to be able to open in iPad, and webi reports in iPad, iPhone, and Blackberry.
- Designed the layout of the Webi reports and Dashboards working actively with the high level Corporate Personnel.
- Trained the power users and BI developers on Webi Reports, Business Explorer (creating and managing InfoSpaces) and how to publish the webi reports to be made compatible to launch in iPad or any mobile device.
Environment: BI 4.0 SP5 (IDT, WebIntelligence Rich Client, BI Launch Pad), Dashboard Designer.
Confidential, Dallas, TX
SAP BO/BI Consultant
Responsibilities:
- Involved in the initial stage of dashboard and webi reports development by working with end users on gathering the requirements and presenting them with different options and functionalities in the dashboard and webi reports.
- Presented a mockup version after initial discussions to confirm the look and feel, scope and content of the dashboard.
- Developed four webi reports to determine Wholesale and retail information of different regions and different KPI’s.
- Used Gmaps plugin a product from Centigon Solutions to illustrate their door information on Gmaps inside the dashboard.
- Developed Quantum GIS shape files to embed on the GMaps plugin to enable users to interact on the GMaps plugin.
- Used BICS Connectivity to utilize the BeX query data into the dashboards.
- Variables were passed to Webi reports from Dashboard for the users to do more analysis on details information with the reports.
Environment: BI 4.0 (Information Design Tool, Universe Designer, BI Launch Pad, Dashboard Design, Gmaps Plugin).
Confidential, Dallas, TX
Business Objects Consultant
Responsibilities:
- Worked closely with the DBA’s and ETL developers in determining the data model for the Project.
- Developed the Universe responsible for the Dashboard fetching the aggregate table data into which the data is loaded on a nightly basis.
- Designed the layout of the dashboards working actively with the high level Corporate Personnel, and part of end users.
- Presented a mockup version of all the 7 dashboards developed by publishing them into the share point portal and navigating between different dashboards.
- Integrated the Business Objects environment with Share Point so as to publish the developed xcelsius dashboards into Share Point.
- Developed multiple dashboards in Xcelsius and published to Share point Portal and linked the dashboards to each other, so that the user will be able to navigate from one dashboard to the other.
- Passed various parameters from the parent dashboard to the child dashboard.
- Linked existing WebI reports to the dashboards and passed the variables to satisfy the prompt conditions in the reports.
Environment: BOBJ Enterprise XI 3.1 SP4 (Universe Designer, WebIntelligence Rich Client, Infoview), Xcelsius 2008 SP4, Qaaws.
Confidential, Houston, TX
BI/BO Consultant
Responsibilities:
- Responsible for the ongoing development of the Dashboards, Reports and Universe designing.
- Understand their requirements and give them different scenarios of dashboards and help them in identifying the possible best solution to the presentation of the dashboards.
- Implemented Row Level Security in the Universe to restrict the data viewed by different departments throughout the organization.
- Implemented Object Level Security to restrict the view of the user to particular Class/Object in the Universe to assist in their Ad-hoc reporting.
Environment: BI 4.0 (BI Launch Pad, Dashboard Designer), BOBJ Enterprise XI 3.1 (Universe Designer, WebI), Xcelsius 2008 SP3, Qaaws.
Confidential, Deer Field, IL
Business Objects Developer
Responsibilities:
- Worked mostly on Universe Development, Webi Reports and Dashboard development.
- Prepared Test Cases and Test Scripts for Unit Testing.
- Involved in Unit testing, System testing and User Acceptance Test (Dashboards and Reports) throughout migration process.
Environment: BOBJ XI R3.1 (SP2) Enterprise (Universe Designer, Web Intelligence, WebI Rich client), Xcelsius 2008 SP2/SP3 (Qaaws, Live Office, Flash Variable, Portal Data, BI Web Services), Oracle 10g, IBM DB2, SAP Net Weaver BW 7.x.
Confidential, Appleton, WI
Sr. Business Objects Developer
Responsibilities:
- Created users and groups and assigned privileges for each user group and applied row level and object level securities to the groups and users using CMC.
- Created Hierarchies, complex objects using various @functions such as @select, @prompt, @where, @aggregate aware in Universe.
- Created pre-defined filters and cascading prompts in Universe level.
- Responsible for Migrating the Business Objects Universes/Reports across the Servers/Repositories (Development to Testing, Testing to Production Servers) using Import Wizard.
- Created Web I reports using Business Objects WEB I and exported to the corporate documents.
- Created simple and complex reports including dynamic calculations involving Contexts, Queries, Hierarchies, List of Values (LOVS), local variables, Alerts, Ranking and multiple data providers.
- Developed interactive Dashboards using Xcelsius 2008 by importing data from excel sheet.
- Involved in using Xcelsius 2008 to transform Microsoft Excel spreadsheet data into interactive Flash media files.
Environment: BusinessObjects XI R2, WEBI, Crystal Reports XIR2, Xcelsius 2008, Oracle 10g, MS SQL Server 2005, MS Access, IBM DB2, Windows 2003 Server, MS-Office.