Sap Bobj Consultant
Professional Summary:
- Over 7 years of experience in the field of Information Technology with specialization in Business Intelligence.
- Solid experience in building the Analytical Solutions using Business Objects Suit.
- Experience in interacting with Business Users to understand the Business Process
- Gathered the Requirements then Transformed the Requirements into Technical Terms
- Expertise in Design, Development and Rolling out the BI Solutions in timely manner
- Provided excellent Customer Service to the Business Units
- Over 3 years of experience in SAP BI/BW based Business Objects implementations
- More than 5 years of experience in Relational Databases based on Web Intelligence Reports
- Experience inBusiness objectsuniverse designing,Business ObjectsWeb Intelligence, Info view andCrystal Xcelsius dashboards.
- Have experience in designing and developing the Universe and updating the existingUniverses, developing ad hoc reports.
- Developed the BEX queries on top of Infocubes/Multiproviders.
- Excellent communication, negotiation, trouble-shooting, interpersonal and user training skills with result oriented dedication.
- Strong interpersonal skills with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel
- Bachelor of Technology in Computer Science and Engineering
Confidential,NY March 2010–May 2012
SAP BOBJ Consultant
Environment: Business Objects 3.1 SP3, SAP BI 7.1, Windows NT, BEx Query Designer, Web Intelligence, Live Office 3.1, Xcelsius 2008, BI Widgets and BI Web Services.
Responsibilities:
- Worked with SAP BI Team and business resources to gather business requirements and drive functional and technical designs for BI Solutions.
- Developed BEx queries on Infocubes/Multiproviders with Calculated and Restricted Key figures, Conditions, Filters, Variables, Variable Offsets for Business Objects reporting purposes.
- Evaluated different methods to connect various SAP BI components in Business Objects stand point to build Universes, Xcelsius Dashboards and Reports.
- Developed Universes on Infocubes/Multiproviders and BEx queries and added custom objects like filters and calculated measures
- Built various Xcelsius dashboards for SAP HR and Finance modules
- Created Joins, Contexts, and Aliases for resolving Loops and Universe Tuning and checked the Integrity of the Universes
- Utilized QaaWS, Live Office, BI Web Services to connect to BI data sources for Dashboard development
- Created several complex Web Intelligence reports for Daily Scheduling and Distribution
- Included the detail report URL in Xcelsius dashboard with Open Document feature; Passed the user selection from dashboard to detail Web Intelligence report
- Validated the Dashboard/Report data using BEx web, Query Monitor and List Cube
- Performance Tuning the Universes/Web Intelligence reports on Infoproviders by applying best practices
- Utilized Offset Prompt approach to pass fixed time based prompt values to the Web Intelligence reports and eliminated the need for periodic changes to the prompt values in the report schedules
- Created publications to distribute customized reports to user community.
- Provided full life-cycle support and development of BI solutions from requirements to go-live support
Confidential,Irvine, CA Jan 2009- Feb 2010
SAP BOBJ/BW Consultant
Environment: SAP BI 7.0, Business Objects 3.1 SP2, Crystal Reports 2008, Web Intelligence, Live Office 3.1, QaaWS,
Xcelsius 2008
Responsibilities:
- Interacted with Business Users to get the requirements for Management Dashboards.
- Developed BEx queries with Variables, Calculated and Restricted Key figures, Conditions, Filters etc. for
Business Objects Reporting.
- Created various Universes on Infocubes, ODS, Multiproviders and BEx queries.
- Performance Tuning the Universes/Reports by applying best practices.
- Utilized Live Office and QaaWS to get the data from various data sources.
- Built various Xcelsius dashboards for Sales & Distribution, Material Management and HR
- Resolved loops, chasm and fan traps using contexts, aliases and integrity checks
- Used the Aggregate Awareness feature of Business Objects for the Optimization and Performance tuning of Universes.
- Utilized BIWS using Web Intelligence with Flash Variables on Xcelsius to provide customized dashboards to
Sales Team
- Applied Content Security on Dashboards by publishing it in multiple folders (one for each BW role/ department) and configured the dashboard to get the data from WebIntelligence report instances created by service account for respective role
- Utilized LDAP user credentials to provide custom Dashboards/Reports to non SAP users
- Developed several complex WebI documents for Dashboards
- Provided the dashboards from SAP portal using open document link to Business Objects Infoview using Single Sign On
- Scheduled the publications with Batches and utilized features like zipped report delivery with password protection
Confidential,Huntington Beach, CA Sep 2008- Jan 2009
SAP BOBJ Consultant
Environment: Informatica, Business Objects 6.5/XI R2/3.0, Live Office, Xcelsius, Oracle 9i/10g, SQL Server 2000/2005.
Responsibilities:
- Responsible for gathering customer requirements, architecting prototypical solutions, acquiring customer acceptance, and managing software processes from initial design to final implementation and deployment.
- Created various Universes on Oracle, SQL Server Data sources and included Aggregate Aware function for faster data retrieval
- Developed Dashboards using Xcelsius allowing the leadership teams to analyze headcount, compensation and performance trends and metrics for all levels of the organization.
- Built Executive Reports and Dashboards and maintained them by updating the Business Plan numbers periodically.
- Developed On-Demand, Linked Sub reports on Web Intelligence using Open Document feature.
- Utilized Calculation contexts for several Web Intelligence reports.
- Resolved loops by creating Aliases & Contexts and checked integrity of universes.
- Involved in optimizing the universe developing time and SQL Tuning to increase the query performance.
- Diagnosed complex problems in the BI environment and worked with ETL team members, System Engineers and customers to resolve them in a timely manner.
- Developed User Training Manual and Trained the users to build adhoc reports and scheduling
Confidential,Bangalore India Jun 2005- Aug 2008
Business Objects Developer
Environment: Informatica 6.2, Business Objects 6.5b, Oracle 9i, SQL Server 2000, PL/SQL.
Responsibilities:
- Created BO Universes for reporting purposes.
- Created reports using Web Intelligence and Business Objects Reports Client
- Tested the data in the reports against application data.
- Created Contexts and Aliases to resolve chasm and fan traps in Universes.
- Documented report specifications as required.
- Scheduled reports to run in Broadcast Agent.