Business Intelligence Objects

MUHAMMAD TABRAIZ KHAN

SAP Business Objects Consultant

Current Location : Houston, TX

Mobile : +1-832-***-****

Visa Status : H1B

Email : ***********@*******.***

Availability : 2 Weeks

Travelling Preference : Open to Travel

SUMMARY

I have 14+ Technical experience Business Intelligence (BI) and Data Warehousing applications in SAP Business Objects 4.3/4.2/XI3.1/XIR2, SAP Analytics Cloud (Story and Planning), SAP Lumira Designer, Tableau and Finance – Group Reporting.

Central Management Server (CMS): Proficient in managing and administering the SAP BusinessObjects platform through the Central Management Server (CMS). Skilled in configuring security settings, user permissions, scheduling reports, and monitoring system performance to ensure optimal operation and data integrity.

Teradata: Leveraged Teradata’s robust data warehousing capabilities to integrate and manage large volumes of data. Designed and optimized complex SQL queries to retrieve and manipulate data stored in Teradata databases.

Universe Designer (UDT): Experienced in creating and maintaining semantic layer definitions using the Universe Designer tool. Capable of designing universes that provide a simplified view of complex data structures, enabling business users to create ad-hoc reports and perform self-service analytics without needing expertise in underlying data sources.

WebI Reports: Developed, implemented, and maintained Business Objects (BO) reports and dashboards using SAP BO and Web Intelligence (WebI). Conducted performance tuning of BO and WebI reports and Teradata queries to ensure efficient data retrieval and report generation.

Provided technical support and troubleshooting for SAP BO, WebI, and Teradata-related issues.

SAP Crystal Reports: Proficient in designing, formatting, and generating pixel-perfect reports using Crystal Reports. Skilled in creating interactive, dynamic reports with features such as charts, graphs, cross-tabs, and subreports. Familiar with consuming data from multiple sources and integrating Crystal Reports with SAP BusinessObjects platform for efficient report distribution and scheduling.

Business Intelligence (BI) Reporting: Strong understanding of business intelligence concepts and methodologies, including data visualization, report design best practices, and dashboard development. Experienced in translating business requirements into actionable insights through effective data analysis and reporting solutions.

Data Analysis and Visualization: Skilled in performing data analysis and visualization using tools like SAP BusinessObjects, Excel, and Power BI. Proficient in manipulating and transforming data, creating meaningful visualizations, and presenting insights to stakeholders in a clear and concise manner.

Problem Solving and Troubleshooting: Adept at identifying and resolving technical issues and challenges related to SAP BusinessObjects platform, universe design, and report development. Experienced in troubleshooting data connectivity issues, performance bottlenecks, and report formatting discrepancies to ensure smooth operation and user satisfaction.

Collaboration and Communication: Excellent collaboration and communication skills, with the ability to effectively interact with cross-functional teams, business stakeholders, and technical experts. Proven track record of translating business requirements into technical solutions and delivering high-quality reports and analytics solutions that meet stakeholder needs.

Expert in optimizing views, BODS, Data modeling(Hana/S4HANA)/warehousing, Data analysis/visualization in SAP Analytics Cloud, Specializing in Business Intelligence developed through years of technology contracting and consulting roles in large organizations across a diverse range of industries including construction, manufacturing, sales, retail, oil & gas and pharmaceutical.

Strong database experience in using SAP HANA, Oracle 10g/9i/8i, MS SQL Server 2016/2014/2012/2008, MS Access

TECHNICAL SUMMARY:

Business Intelligence Tools: SAP Business Objects Integrator/Data Services 4.3/4.2/XI3.1/XIR2, SAP Analytics Cloud (Story and Planning), SAP Business Objects 4.3/4.2/XI3.1/XIR2, Web Intelligence, CENTRAL MANAGEMENT SERVER (CMS), UNIVERSE DESIGNER, CRYSTAL REPORTS, SAP Lumira Designer Universe Designer, Desktop Intelligence, InfoView / Launch Pad, CMC, Import Wizard, Report Conversion Tool, Data Integrator, Data Services, Xcelsius 2008, Query as a Web Services (QaaWS), Live Office, Tableau

Databases: SAP HANA/S4HANA, Oracle 10g/9i/8i/8.0, MS SQL Server 2016/2014/2012/2008/2005 (TSQL, SSIS, SSAS, SSRS), MS Access, Sybase, Dbase, IBM DB2, Teradata, Informix

Data Warehousing: SAP LT Replication Server (SLT) and Data Services, SAP Business Warehouse (BW), SAP BW on HANA, Star-Schema Modeling, Snowflakes Modeling, Qlik/Talend Data Integration and Quality, FACT Tables, Dimension Tables.

Operating Systems: Windows Server 2019, 2016, 2012 r2, 2000/NT, Linux, Unix, Dos.

Windows Utility: MS-Word, MS-Excel and MS-PowerPoint.

Dimensional Data Modeling Tools: Dimensional Data Modeling using SAP HANA/S4HANA Attribute, Analytic and Calculation Views, Data Modeling using Erwin modeling (Erwin 4.1/4.0/3.5), Physical & Logical Data Modeling, Multidimensional Modeling, Snowflake Schema/Star Schema Modeling (Normalization / De-Normalization Techniques), Erwin, Visio.

Query Tools: SAP HANA Studio 2.0, TOAD, SQL, PLSQL, SQL Navigator

SKILLS SUMMARY

No of Years

SAP BusinessObjects Business Intelligence XI 2.5, 3.0, 3.1, 3.2, 4.2, 4.3

18 Years

SAP BusinessObjects Data Services (Data Quality & Data Integrator)

10 Years

SAP Business Warehouse (BW)

10 Years

SAP BW on HANA

05 Years

SAP Analytics Cloud (SAC)

06 Years

S/4HANA / HANA Studio (Data Modeling, Contents, Views, Security)

05 Years

SAP BusinessObjects Mobile XI 3.1/4.1

12 Years

SAP BusinessObjects Information Delivery Tools (Crystal Reports, Web Intelligence, Xcelsious and Voyager)

15 Years

MS SQL Server 2005/2008/2014 (TSQL, SSIS, SSAS, SSRS)

18 Years

Databases IBM DB2

7 Years

EDUCATION

Year: 2009 M.S. (Information Technology)

Year: 2000 M.C.S.

CERTIFICATIONS/TRAININGS

Oct 2023 SAP Certified Application Associate - SAP Analytics Cloud Story Planning

Aug 2023 SAP Certified Application Associate - SAP Analytics Cloud Story Design

Sep 2019 MicroStrategy 10.5 Training from UAE

Jun 2019 Google Data Studio, Google Big Query, Google Data Fusion

Nov 2016 SAP HANA/S4HANA Online Training – SURYA HANA/S4HANA ACADEMY, India

Feb 2016 SAP Certified Application Associate - SAP BusinessObjects Web Intelligence 4.1

Dec 2015 SAP Certified Application Associate - SAP BusinessObjects BI Platform 4.1

Feb 2011 Oracle Certified Professional 10g Training-(ORACLE University)

Feb 2011 Oracle Certified Associate 10g Training- Techno-Ed Pvt. Limited (ORACLE University)

Dec 2010 SAP BusinessObjects Level 1 Solution Consultant Certification

Dec 2010 SAP BusinessObjects Level 1 Pre-Sales Consultant Certification

Dec 2010 SAP BusinessObjects Level 1 Sales Executive Certification

Project Experience

SAP BO/SAC Consultant Jul 2022 to Date

Client: Aramco Services Company

Location: Houston, TX

Environment: This project involves the implementation of SAP Analytical Cloud/Planning, SAP Business Objects XI 4.3, S/4 HANA Finance – Group Reporting solution along with implementation of Central Management Server (CMS), Universe Designer, Crystal Reports and S/4 HANA Finance solutions of AP, AR, Banking, Financial Planning & Analysis, Ad-hoc reporting on Webi and administration on SAP Business Objects XI 4.3 SP3 and Analytical Dashboards on Mobile and Dashboard, SAP HANA, SQL Server 2014/2008, Excel, Txt, Csv

Responsibilities/Deliverables:

Understand existing business processes, Analyze functionality of existing decision support and executive information systems, Understand subject matter

Leveraged Teradata’s robust data warehousing capabilities to integrate and manage large volumes of data.

Developed, implemented, and maintained Business Objects (BO) reports and dashboards using SAP BO and Web Intelligence (WebI) Reports.

Lead the resolution group for SAP BW/HANA production application & IT issues; from identification to closing all issues & provide excellent customer support.

Worked with HANA Calculation Views, HANA Table functions, HANA DB Procedures

Manage expectations of the project, Develop project plan for an increment/project

Performing standard tasks of group reporting for generation Consolidated Financial Statements.

Extracted CDS views based data into BW4HANA datasource.

Creates documentation for various stages of planning, design, implementation and support of SAP Business Intelligence Reporting and Visualization services

Provide training and ongoing support of Business Intelligence Reporting and Visualization to IT and business stakeholders

SAP BO/SAC Consultant Jun 2020 to Jun 2022

Client: The Boeing Company

Location: Seattle, WA

Environment: This project focuses on generation of Consolidated Financial Statements as per requirements monitored by Chief Financial Officer, on S/4 HANA Finance – Group Reporting solution along with implementation of other S/4 HANA, SAP BW, SAP Business Objects XI 4.3 SP3 solutions of AP, AR, Banking, Financial Planning & Analysis. In addition the scope also involved SAC implementation for feeding the Group reporting system with planned values for the purpose of generating consolidated financial statements.

Responsibilities/Deliverables:

Lead the effort to gather, analyze and model client data (customers, financials, operational, organizational, access channel), key performance indicators, and/or market data (competitors, products, suppliers), using a broad set of analytical tools and techniques to develop quantitative and qualitative business insights and improve decision-making.

Experience in developing BEx reports from given information using BEx Query Designer and training end users on BEx Analyzer, Web Portal.

Integrated SAP BO with Teradata, to perform connection setup, Universe designing, Develop reports in Web Intelligence (WebI) or Crystal Reports using the Universes connected to Teradata.

Created Consolidation Versions for Planned, Actual, Forecasted and Budgeted values.

Manage and lead the SAC projects to ensure timely delivery

Understand the technology landscape and how it affects the clients’ area of the business; trends associated with the technology; functional area and industries and the value propositions for clients to rotate to the new

Designed, implemented and delivered the planning solution for budgeting and forecasting in SAP Analytics Cloud – SAC.

Trained business users in utilizing SAP Analytics Cloud planning features of allocation, distribution, redistribution and spread.

Senior BO/BW Consultant & Data Analyst Oct 2018 to May 2020

Client: The Coca-Cola Bottling Company of Saudi Arabia (CCBCSA)

Location: Riyadh, Saudi Arabia (www.coca-cola.com)

Environment: Project SAP Analytical Cloud Implementation, SAP BusinessObjects XI 4.2, SAP Fi/CO, HCM, BW 3.5/BI 7.0/BW 7.3, SAP Lumira Designer, Ad-hoc reporting, SAP BW, HANA,, Financial Planning & Analysis, Web Intelligence, administration and Analytical Dashboards on Mobile and Dashboard, SAP HANA, SQL Server 2014/2008, AS400 DB2, Excel, Txt, Csv, Tableau

Responsibilities/Deliverables:

Responsible for the Software Development and Business Intelligence Reporting.

Creating Sales Reports and Analytical Dashboards for the Planning and Forecasting.

Implemented Procurement module in BW

Administration with the CMS for the Folder level, User Level, Universe Level and Connection level security.

What-If Analysis, planning, forecasting, budgeting reports.

Import and Export report for the Crystal Report.

Design the Universes with the UDT for reporting of Finance, Sales and other Business requirements.

Development of Mobile Dashboards and Sales Trend Analytics.

Worked extensively on Data Modeling design like creating Data Sources, Info Sources, Info objects, DSO, Transformations rules, DTP, Info Cubes, Multi-Providers.

Universe Designing, Contexts, Joins for resolving loops and integration of Universes with difference connections

SAP Business Object Installation / Implementation / Configuration with the desktop and mobile technology with Web Intelligence ad-hoc reporting

New requirement gathering and manage the resources.

BI Consultant & Data Analyst Jun 2013 to Sep 2018

Client: Fawaz Al Hokair (NESK Trading Projects LLC)

Location: Riyadh, Saudi Arabia (www.fawazalhokairfashion.com)

Project: SAP B1 (GL, AP, AR), Fixed Assets, HCM integration with SAP BusinessObjects XI 4.2/4.1, MicroStrategy 10.5, Google Data Studio, Big Query, Google Data Fusion

Role: BI Manager, Team Lead, SAP BI Consultant & Data Analyst

Environment: SAP BusinessObjects XI 4.2 and SAP BusinessObjects Mobile, SQL Server 2005/2008, Excel, Txt, Csv, Web Intelligence, BO Dashboard Manager, SQL, PL/SQL, Crystal Xcelsius, QaaWS, Microsoft Windows Server 2008 MicroStrategy 10.5, Oracle EBS, Oracle Fusion, Google Data Studio, Big Query, Data Fusion SAP B1 (GL, AP, AR), Fixed Assets, HCM integration with SAP BusinessObjects XI 4.2/4.1, MicroStrategy 10.5, Google Data Studio, Big Query, Google Data Fusion

Responsibilities/Deliverables:

Understand existing business processes, Analyse functionality of existing decision support and executive information systems, Understand subject matter

Manage expectations of the project, Develop project plan for an increment/project

Understand information architecture and technical architecture

Coordinate with program manager to ensure standards

Communicate with all other team members and vendors

SAP BusinessObjects Enterprise XI 4.2/4.1/3.1 Installation, Configuration, Implementation

SAP BusinessObjects Mobile Installation, Configuration and Implementation

Ongoing process to Implementation of SAP HANA

Universe Designing, Contexts, Joins for resolving loops and integration of Universes with difference connections

Configuration with SAP B1 Financial and HR module and developed Profit & Loss, Financial Planning & Analysis, AP, AR, Fixed Assets and other reports

Developed critical Web Intelligence and Desktop Intelligence reports like drill down, Slice and Dice, master/detail for analysis of parts benefits and headcount

Create dynamic dashboards based on KPIs and Metrics with the using of Crystal Xcelsius and BO Dashboard Manager Key role to implement SalesBuzz(bi-technologies.com) software for Delivery routes

SAP Solution Consultant Jun 2012 to May 2013

Client: Services & Solutions Company

Location: Riyadh, Saudi Arabia (www.ssc-arabia.com)

Project: SAP FI (GL, AP, AR) Implementation/integration with SAP BusinessObjects XI 3.1

Role: SAP Solution Consultant (Team Lead)

Environment: SAP R/3 Ecc6.0 Ehp4, Ehp6, SAP Business Objects XI 3.1, SQL Server 2005/2008, Excel, Txt, Csv, Web Intelligence, BO Dashboard Manager, SQL, PL/SQL, Crystal Xcelsius, QaaWS, Microsoft Windows Server 2008

Responsibilities/Deliverables:

Support Installation/upgrade of SAP R/3 Ecc6.0 Ehp4 to SAP R/3 Ecc6.0 Ehp6

Design Roles & Privileges and Assign to the Business Users

Accounts Payable/Receivable, Vendor/Customer groups, vendor/Customer master data, house banks, bank accounts, check lots, reason codes, automatic payments, recurring entries, invoices, credit memos, closing procedures.

SAP BusinessObjects Enterprise XI 3.1 Installation, Configuration, Implementation, Analysis, Design and Development, Administration of Business users need

Universe Designing, Contexts, Joins for resolving loops and integration of Universes with difference connections and BO Dashboard Manager

Loading and validating data, Working with Excel, TXT, CSV, Developing input schedules

Business Intelligence Consultant Mar 2010 to May 2012

NetSol Technologies Inc. – NTWK (NASDAQ) http://www.netsoltech.com

Client: British Petroleum (www.bp.com)

Project: SAP BusinessObjects XI 3.1 SP2 Implementation/Legacy Migration

Duration: Mar 10 to Aug 10

Role: SAP BusinessObjects Developer / Analyst / Designer / Team Lead/Administrator

Environment: SAP Business Objects XI 3.1 SP2, SAP BusinessObjects 5.1.0, Oracle 10g, Crystal Reports XI, Web Intelligence, BO Dashboard Manager & EPM, SQL, PL/SQL, Crystal Xcelsius, QaaWS, Microsoft Windows Server 2003

Client NetSol Financial Suite (NFS – Nissan Australia)

Project SAP BusinessObjects XI 3.1

Duration Sep 11 to May 12

Role SAP BusinessObjects Developer / Analyst / Team Lead/Administrator

Environment SAP Business Objects XI 3.1, Oracle 10g, SQL Server 2005/2008, Excel, Txt, Csv, Microsoft SQL Server Analysis Services, Microsoft SQL Integration Services, Web Intelligence, BO Dashboard Manager, SQL, PL/SQL, Crystal Xcelsius, QaaWS

Responsibilities

SAP BusinessObjects Enterprise XI 3.1 Installation, Configuration, Implementation, Analysis, Design and Development, Administration of Business users need

Universe Designing, Contexts, Joins for resolving loops and integration of Developed Objectives, Initiatives, KPIs and Target Values

Client Yamaha Motors, Australia (www.yamaha-motor.com.au)

Project SAP BusinessObjects XI 3.1 Implementation

Duration Sep 10 to Feb 11

Role SAP BusinessObjects Developer / Analyst / Designer / Team Lead/Administrator

Environment SAP Business Objects XI 3.1,Oracle 10g, Crystal Reports XI, Web Intelligence, BO Dashboard Manager, SQL, PL/SQL, Crystal Xcelsius, QaaWS, Microsoft Windows Server 2003

Client Multiple Demos (Getz Pharma, PEL, Mughal Steel, Soneri Bank..etc)

Project SAP BusinessObjects XI 3.1 Demos

Duration Mar 11 to Jul 11

Role SAP BusinessObjects Developer / Analyst / Designer / Team Lead/Administrator

Environment SAP Business Objects XI 3.1, SAP BusinessObjects Mobile XI 3.1, SAP BusinessObjects Business Planning and Consolidation, SAP BusinessObjects Strategy Management 7.0, SQL Server 2005/2008, Microsoft SQL Server Analysis Services, Microsoft SQL Integration Services, Web Intelligence

Contact this candidate