Sap Bw Business Analyst
Resume:
Consultant’s Profile
Waqar Saeed
SAP BW, SAC and HANA – Senior Consultant
Current Location : Houston, TX
Mobile : +1-832-***-****
Visa Status : H1B
Email: : **********.***@*******.***
Availability : 2 weeks
LinkedIn : https://www.linkedin.com/in/waqar-saeed-a0461618/ Travelling Preference : Open to travel
SUMMARY:
• Technical background includes experience in SAP BW, BI/BO, SAC, SAP Datasphere and HANA with a proven record of company accomplishment and customer satisfaction.
• Working in SAP since 2008 and focus areas have been BW 3.5/BI 7.0/BW 7.3, BW on HANA, BW4HANA with working knowledge of BI 4.1, native HANA and SAP Analytics Cloud (SAC).
• Worked with clients in the area of Telecommunication, FMCG, Oil & Gas, Fertilizer businesses, IT industry and Auto Industry with Global Clients.
• Hands-on experience with SAP (Native) HANA data modeling, schema management, data provisioning technology including SAP LT Replication Server, Data Services and Smart Data Integration (SDI).
• Hands-on experience of working with SAP BW powered by HANA and BW4HANA features, among others, standard and custom SAP BW Extractors, complex transformations, advanced DSOs, composite providers, exposing BW models as HANA views, mixed scenarios, HANA Analysis process in BW and LSA ++ best practice and performance optimization concepts.
• Working knowledge of SAP Business Objects Enterprise BI4.1/4.2
• Visualization tools: Tableau, Web Intelligence 4.1, SAC
• Working knowledge of SAP Business Planning & Consolidation (SAP BPC)
• Good expertise in business content extractors, LO cockpit configuration, generic extraction using cursor-based function modules and CO-PA extraction.
• Efficiently manage the SAP support team / network to ensure adequate cross training to provide job rotation and cross functional support coverage at all times.
• Ability to work effectively in a dynamic, deadline-driven, team-based milieu with conflicting & competing priorities.
• Good expertise of working with Tableau and SAP BW as source system.
• Hands-on experience with SAP S/4 Embedded analytics specifically with Core Data Services (CDS) views development technique.
• Dashboard development experience in SAP Analytics Cloud, with SAP BW live and extract data connection.
EXPERIENCE
• Proficient in SAP methodologies, implementing BW within SAP architecture in the areas of data modeling (OLAP) using MDM based on BW extended star schemas.
• Well versed in installation, simulation and activation of Standard Business Contents.
• Expertise in BW on HANA related modeling i.e. advanced DSO, Open ODS and composite providers.
Consultant’s Profile
Page 2 of 8
• Good expertise in native HANA modeling attribute view, HANA Table functions, HANA DB procedures and XS Jobs.
• Experience of migration from BW to BW4HANA
• Experience with various SAP Business Objects (BOBJ) tools (WEBI, Design Studio) development lifecycle on BW4HANA or SAP (Native) HANA or S/4 HANA from design through implementation and production support.
• Used live data connection to connect SAC with SAP finance cube and built dashboard for management.
• Established SSO connection between SAP FIORI tiles and SAC, so that users do not have to enter any passwords.
• Expertise in defining ODS objects, Aggregates, Multiproviders.
• Working knowledge of R/3 extraction methods such as CO-PA, LO Cockpit and Generic Extractions.
• Experienced in Enhancements of datasources, start routine, End Routine, Infopackage routine, transformation routines and customer exits.
• Hands-on experience in process chains, job scheduling tools, and monitoring.
• Experience in developing BEx reports from given information using BEx Query Designer and training end users on BEx Analyzer, Web Portal.
• Dashboard development using Tableau with SAP BW as datasource and publishing them to Tableau server using SSO, scheduling and monitoring and jobs and managing dashboard users.
• Tableau dashboard for SAP HR, procurement and Finance.
• Administration of tableau server (creation of sites, groups, users and assigning them to projects)
• Worked with Lumira 2.0 designer to design interactive dashboards.
• Developed dashboard with tableau and assigned to users using active directory authentication. Linked tableau dashboard with WEBI for master detailed report.
• Expertise in development of BI Dashboards and Web Intelligence reports.
• Experience of handling inventory scenario.
• Extracted COPA and built profitability reports on top of it.
• Expertise in reconciliation of data using reconciliation datasources.
• End user training on front end tools of BI.
• Used Open hub destination to pass data into S3 bucket of Amazon Web Services (AWS).
• Involved in the design and development of Web Intelligence reports in MM, HR, FICO, PM, PP, PS, SD and C4C Modules.
• Installation and Integration of SAP Business Objects (BO) Server.
• Administration of Business Object Server.
• Migration of CRM reports to Cloud for Customers (C4C) SKILLS SUMMARY No of Years
SAP Business Warehouse (BW) 15 Years
SAP Analytics Cloud (SAC) Planning 05 Years
BW4HANA 05 Years
SAP BW on HANA 06 Years
SAP Business Objects (BO/BI) 08 Years
Native Hana Modeling 03 Years
SAP Datasphere 01 Years
Tableau with SAP BW 05 Years
Consultant’s Profile
Page 3 of 8
EDUCATION:
• 2000-2003 Master’s Degree in Computer Sciences
Certification:
• SAP Certified - SAP Analytics Cloud Story Design. https://www.credly.com/badges/c58a400b-d183-4acc-8aa3-922bfba3d505
• SAP Certified with NetWeaver Business Intelligence BI 7. (2009)
• SAP Certified - Reporting / Modeling and Data Acquisition with SAP BW/4HANA 2.0 https://www.credly.com/badges/4a212c14-cf3c-4220-bdf8-8810c350cd02 Senior Consultant - SAP BW4HANA and SAC Jan 2021 to Current Client: Ford Motor Company (Contract)
Location: Michigan
Industry: Automotive
• Lead the resolution group for SAP BW production application & IT issues; from identification to closing all issues & provide excellent customer support.
• Analysed and translated the client's business requirements and functional specifications into technical specifications, data flow diagrams and data models.
• Used SAC capabilities to predictive, augmented analytics, forecasting, Smart Assist, Smart Predict, Smart Discovery, story canvasses, advanced story designing, blending data, formulas, cross calculations, input controls, linked analysis.
• Established integration between C4C and SAP BW using ODP connection.
• Built analytical reports and dashboards for C4C leads, opportunities, sales quotes and legal tickets.
• Worked with HANA Calculation Views, HANA Table functions, HANA DB Procedures and XS Job
• Developed CDS views in S4HANA and consumed them in BW4HANA and SAP Analytics Cloud.
• Enhancements done on standard CDS views to meet client requirements, developed CDS views on both tables and other CDS views.
• Used CDS views with joins and associations, used expressions and annotations to meet client requirements.
• Created FI analytical reports related to customer aging, vendor aging and accrued revenue.
• Utilized SAC business content using best practices, and market trends to enhance reporting and analytics.
• Modelled data flows using LSA++ for optimum performance.
• Involved in complete implementation/upgrade of Finance and HR Dashboard Project based on complete modeling of ECC data and external Legacy data in HANA.
• Development of calculation views on top of HANA tables to feed the universes.
• Good knowledge of Importing and Exporting Landscapes, Tables and Models, Documentation, User Management, Backup and recovery in SAP HANA
• Created universe on top of HANA calculation views using IDT and developed Webi reports.
• Involved in development of front-end dashboard using Tableau
• Used Hand table functions and DB procedures.
• Extracted COPA and built profitability reports on top of it. These report contains comprehensive Consultant’s Profile
Page 4 of 8
functionality for financial consolidation, planning, and performance management.
• Migrated SAPI based datasources to ODP for BW4HANA.
• Extracted CDS views based data into BW4HANA datasource, delta handling using annotations.
• Used ADSO’s, open ODS and composite views for data reporting for faster performance.
• Converted some ABAP routines to AMDP routines for HANA push down performance optimization.
• BO and BW connectivity.
• ETL from non SAP systems using business objects data services (BODS)
• Developed Analytical reports (FICO, HCM, SD, PP) in Business Objects WebI using BICS connection. Designed standard reports in BO crystal reports designer (Financial Statements, Profit and loss Statement, Cash flow, Tax etc), Universe Design to meet requirements.
• Administration of Business Object Server, including creation of roles and users management in CMC.
Senior Consultant - SAP BW on HANA & SAC Jun 2020 to Dec 2020 Client: KDRP (Keurig Dr Pepper) (Contract)
Location: Plano TX
Industry: Food and Beverage
• Involved in Requirements Gathering, participated in Discussions with Users and Business Owners
• Worked with different users to gather business requirements and transformed them into a data model using extended star schema model
• Enhancement of existing datasources, enhancement and monitoring of reports and process chains.
• Extracted data and sent to external server using Open Hub Destination for Business Objects planning and consolidation (BPC).
• Analysis process designer (APD) to transform data for BPC.
• Performance optimization of exiting Infocubes using aggregates.
• Implementation of Transport and logistics in BW and BO from multiple TMS sources.
• Implemented Procurement module in BW.
• Development of Purchasing reports using Web Intelligence
• Performance optimization and implementation of BW statistics.
• Sales dashboard development.
• Implemented complete procure to pay full lifecycle in BW and Business Objects BI 4.0, that covered purchase requisitions till payments done to the vendor. Role : Principal SAP BW and HANA Consultant
Company : ELM Company (Subsidiary of ministry of finance KSA) http://www.elm.sa/ Location : Riyadh, KSA
Industry : Information Technology
Duration : Feb 2015 to June 2020
Role & Responsibilities
• Lead the resolution group for SAP BW production application & IT issues; from identification to closing all issues & provide excellent customer support
• Analysed and translated the client's business requirements and functional specifications into technical specifications, data flow diagrams and data models.
• Migrated SAP BW to BW4HANA and converted LSA to LSA++ architecture which is a best Consultant’s Profile
Page 5 of 8
practice for HANA.
• Used HANA ODP and ODQ.
• Worked with HANA Calculation Views, HANA Table functions, HANA DB Procedures and XS Job
• Worked extensively on Data Modeling design like creating Data Sources, Info Sources, Info objects, DSO, Transformations rules, DTP, Info Cubes, Multi-Providers.
• Extensively performed ABAP developments in start routine, end routine and field routine.
• Enhanced new FIGL cubes with additional necessary missing fields.
• Created Bex queries related to customer aging, vendor aging and accrued revenue.
• Maintenance Process Chains to automate and schedule the data loads.
• Created Olap universe using IDT in order to consume Bex Queries created.
• Created various Bex queries as per the requirement.
• Created WEBI reports based on BICS connection using IDT tool.
• Created HR, procurement and finance analytical Dashboards in tableau with SAP BW as datasource for higher management.
• Combined multiple datasouces in Tableau dashboards (BW datasource and File) using data blending.
• Connected WebI report with tableau dashboard for master detail report.
• Managed tableau server for users, groups and sites. Assigned groups and user to projects and managed them as per requirements.
• Configured BO servers in CMC for performance tuning, like cloning WEBI processing server and setting up parameters within processing server and Adaptive processing server for better performance.
• Scheduling WEBI report and email the notifications.
• Mapped Enterprise Portal users to backend BW user for single sign on.
• Assigned different levels of user authorization at BW, BO and EP levels.
• Developed and published SAP transaction and utilization reports in graphical format for higher management.
• Developed dashboard using Lumira 2.0 designer and published it for end users on BO server.
• Designed Tableau dashboard for HR and Finance, used SAP BW queries as a source of data. Published dashboards on Tableau server and authorized users using active directory authentication. Created master detailed report using Tableau integration with Web Intelligence.
• Designed Tableau dashboard by using SharePoint list as datasource and by using OData connection.
• Developed dashboard with SQL server data as datasource.
• Dashboard development in SAP analytics Cloud (SAC) Role : Senior SAP BI and BO Consultant
Company : Almarai http://almarai.com/
Location : Riyadh KSA.
Industry : Fast Moving Consumer Goods (FMCG)
Duration : December 2011 to Dec 2014
Role & Responsibilities
Almarai is a largest FMCG with more than 50k employees. It is FMCG with huge amount of sales, production and procurement data, which was captured in SAP and all analytical reporting was done in SAP BI.
Consultant’s Profile
Page 6 of 8
Automation of BW data for BPC
• Complete automation of BW data for BPC using Analysis process designer (APD) and Open Hub Destination.
• Extraction of Sales data from legacy system and transformed it as per format which BPC load understands.
• Loading and monitoring of master and transactional data in BPC.
• Development of EVDRE reports in BPC that give sales revenue with cost and margins as per each rolling forecast.
• Retraction of planned data from BPC to ECC 6
PROJECT & Support Duration 2+ Years
Development and Support of SAP Business Warehouse and Business Objects
• Enhancement of existing datasources, enhancement and monitoring of reports and process chains.
• Extracted data and sent to external server using Open Hub Destination for Business Objects planning and consolidation (BPC).
• Analysis process designer (APD) to transform data for BPC.
• Performance optimization of exiting Infocubes using aggregates.
• Implementation of Transport and logistics in BW and BO from multiple TMS sources.
• Implemented Procurement module in BW.
• Development of Purchasing reports using Web Intelligence
• EVDRE Report development in Business Object Planning and consolidation (BPC)
• Performance optimization and implementation of BW statistics.
• Sales dashboard development.
• Implemented complete procure to pay full lifecycle in BW and Business Objects BI 4.0, that covered purchase requisitions till payments done to the vendor. Role : Senior SAP BI and BO Consultant
Consultancy : Abacus Consulting formerly PWC http://www.abacus-global.com Industry : Fertilizers
Duration : May 2010 to December 2011
Role & Responsibilities (Includes development of new Project and Support)
• Involved in Requirements Gathering, participated in Discussions with Users and Business Owners
• Worked with different users to gather business requirements and transformed them into a data model using extended star schema model
• Activation of standard business contents.
• Analysed legacy data in oracle applications to load into business warehouse.
• Activation of controlling and profitability analysis (CO-PA) Datasource and development of custom cubes on these Datasource.
• Enhanced Datasource with custom fields.
• Wrote start routine, end routine, transformation routine and customer exits as per requirements.
• LO cockpit configuration of SD, PP, PM, QM and MM modules.
• Process chains development and monitoring.
• BO and BW connectivity.
• Developed dashboards in BO Xcelsius (SD, PP, FICO, HCM) and development of standard reports Consultant’s Profile
Page 7 of 8
in BO crystal reports designer (Financial Statements, Profit and loss Statement, Cash flow, Tax etc) and adhoc queries in web Intelligence, Universe Design.
• Installation and Integration of SAP Business Objects (BO) Server with SAP BI.
• Administration of Business Object Server.
Role : SAP BI/BW Consultant
Consultancy : Siemens http://www.siemens.com
Industry : Oil & Gas
Duration : April 2009 to May 2010
Client: : Maari Petroleum Company Limited https://mpcl.com.pk/ Role & Responsibilities
Includes development of new Projects and Support
• Involved in complete life cycle Implementation of SAP BW that includes Data Extraction, Data Modeling and Reporting
• Worked with different users to gather business requirements and transformed them into a data model using extended star schema model
• Analyzed business reporting requirements that satisfy with SAP Business Content and installed the necessary objects for Business Content Cubes
• Involved in creating custom Master data InfoObject with compounding characteristics
• Setup periodic data loads from R/3 full/delta enabled and legacy system (flat files) containing certain customer information and enhancement of extract structure
• Assigning data sources to the Info Source, defining transfer structure, configuring the extract structures for replication and updating of data source from the source system
• Worked on remote cubes to support real time data. Extracting required data from the data source of PSA to ODS, Worked on ODS objects and Info Cubes
• Involved in using performance enhancements features such as Cube Partitioning, Indexing, maintaining aggregates and compression
• Created Hierarchies both time dependent and time independent
• Generated reports using BEx (Business Explorer) with exceptions, conditional formatting, restricted and calculated key figures.
• Designed and optimized the queries (top customers, monthly incoming orders and revenues, product analysis, returns).
Role : SAP BW/BI Consultant
Consultancy : Infovision Europe GMBH http://www.infovision-europe.com Project : Nokia Siemens Networks
Industry : Telecommunications
Duration : May 2007 to March 2009
Role & Responsibilities
Includes development of new Projects and Support
• Involved in Requirements Gathering, participated in Discussions with Users and Business Owners
• Scored High reputation with users in interaction and fulfilling their requirements on time and quality.
• Created & maintained infoObject, custom data sources, InfoSources, communication structures, transfer structures, transfer rules, update rules, info packages & info package Consultant’s Profile
Page 8 of 8
groups and scheduling the data requests.
• Extracted SAP R/3 master and transaction data. Loaded data from the external file system, flat files.
• Involved in the development of user-defined data sources.
• Responsibilities include development of new Info Cubes & Enhancements to the existing functionality as per the user requirements.
• Gathered requirements, designed cube/Operational Data Store (ODS) architecture, created custom Info Sources for master and transaction data, created ODS objects, cubes and multiproviders.
• Responsibilities include development of new Info Cubes & Enhancements to the existing functionality as per the user requirements.
• Involved in design, development, testing, and enhancements of user requirements.
• Experience in Data modeling using Star Schema design in CO-PA, SD, MM.
• Development of specific Queries based on user requirements using Query Designer and Web Application Designer as well as utilization of Business content related queries and workbook.
• Used generic extraction and custom extraction to extract data from SAP R/3 to BW.
• Interaction with Users to get reporting requirements and Customization of workplace for user role to publish web reports.
• Created Info packages, Scheduled loading of data to BW Server using Process Chains and used the process chain to monitor data loading into the Data Targets.
• Involved in performance tuning of the InfoCubes and reports for various modules. Role : SAP BW/BI Consultant
Consultancy : Infovision Europe GMBH http://www.infovision-europe.com Project : Nokia Siemens Networks
Industry : Telecommunications
Role & Responsibilities
• Understanding the expectations of client top management and managing delivery against those expectations.
• Created info cubes in SD, FI, and Purchasing to load data from R/3 into respective cubes.
• Created MultiProvider to combine data from Time zone cubes, queries built against MultiProvider to view the data and stored the queries in Workbooks.
• Extensively worked with the Logistic Cockpit tool for MM structures.
• Designed a Product cost controlling (CO) cube for analysing planned and actual quantities/costs and to find the variance between the plan and actual.
• Created Multi Cube for specific queries of SD, FI, and Purchasing. Incorporated transfer rules for InfoCubes.
• Created queries using restricted key figures, filters, so that users of particular Time zone can see their particular data only.
• Improved performance of existing SAP BW Queries and reports by creating Aggregates, Compression and Partition etc.
• Developed the Process Chains to automate the data upload and aggregates.
• Conducted presentations, end users training. Support in resolving technical issues
Contact this candidate