Senior SAP BI/BO Professional
Abdullah Abbar & Sons Cold Stores
Total years of experience :24 years, 3 Months
Successfully completed 2 SAP BI full cycle implementation along with 1 SAP BO 4.0 full cycle implementation.
As SAP BI consultant, successfully completed two full cycle BI implementation projects for Abbar & Zainay Group.
AS BI consultant, following major tasks accomplished.
• Scope of BI implementation comprises of SD, MM, HR, PP, PM and FI modules
• Analysis and activation of relevant Business Contents
• Creating new objects (Info Objects, info sources, DTP’s, info cubes, DSO).
• Activating and modifying the existing data sources.
• Creating generic data sources using Tables, Views and function modules.
• Working extensively on LO setup and extraction.
• Worked on Transformations and DTP’s to load the data to data targets.
• Did Extensive Work on Transformation routines, info Package Routines.
• Used DSO to stage the data before transferring the DSO Contents to the Info Cube.
• Uploaded master and transactional data from files, Oracle, SQL Server and SAP as the OLTP source.
• Configuring use of restricted key figures, variables, exceptions and calculated key figures in queries. Created aggregates to improve the query response.
• Creating exit type variables.
• Extensive work on APD( Analysis Process Design ) with ABAP routines.
• Reading of queries and Cubes using ABAP code.
• Creating process chains and monitoring the background jobs on daily basis.
• Worked extensively on BEx Query Designer. Developed flexible queries using filters, navigational attributes in BEx Analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.
• Creating corporate Dashboards using Web Application Designer (WAD) and Bex Analyzer
• Worked on BEx Report Designer for Formatted Reporting.
• Worked on Information Broadcasting for Printing and Export and use ABAP to change parameters.
• Worked on Enterprise Portal 7.0 to Display the BI Reports using Iview’s .
• Worked on New Analysis Authorization using RSECADMIN.
• Analyzing and fixing the data load problems.
• Checking data consistency reconciliation between R/3 and BW.
• Extensively used Bex Analyzer for management dashboard and Analysis. Including VBA code.
• Consolidation of different source system including Non SAP system.
• Management Dashboards for Sales, Procurement & HR Departments using SAP BI system As source.
• Webi Analytical reports for super users.
• Crystal report for fixed format reporting and deployment on SAP BI Server.
• Distribution of Weekly Financial reporting to management using scheduling.
As a SAP BW consultant, I was assigned the responsibility for complete implementation of BI solution in the organization.
As a member of BW implementation team, responsible for the following:-
• All standard BI implementation activities related to Modeling & Extraction completed successfully
• Extracting data in ODS and InfoCubes after creating Transfer rules, info packages and update rules.
• Setup Flat file extraction for legacy(BPCS) data, Assigning Data Sources to the Info Source, Defining Transfer Structure, and Metadata maintenance for the Info Source and source system.
• Created aggregates to improve the query response.
• Creating corporate web template using Web Application Designer (WAD)
• SAP security and authorizations. (User admin support and BW related security issues).
As a member of SEM-BPS team, Involved in
• Successfully completed Sales Planning on Material, Sales office, Region and Customer level using four planning levels.
• Creating Standard and multi planning areas.
• Creating data slices for data locking through activating and deactivating data slices.
• Creating variables including number of exit variables.
• Creating characteristics relationship using Combination, Derivation and check function modules for valid combination of characteristics relationship.
• Creating planning levels, Planning packages, Planning functions, parameter groups, Planning sequence.
• Creating exit type planning functions and FOX planning function.
• Creating manual planning layout using Non Hierarchical and Hierarchical data model.
• Creating BSP application using web interface builder
Taking care of All SAP ABAP, Cognos and MIS and Basis Activities
In House application.
work as a project Manager
and make five modules for shaheen shipping pakistan.
1> Genral Ledger
2>Invetory control
3>Sales
4>Purchase
5>Payroll
Work as senior programmer
and make following modules for different comapnies
1>Almustafa Marketing and Distrubuters
>Purchase system
>Sales system
>stock tracking
>Genral Ledger
2>Zora Knit
>Production Management system
>sales system
>purchase
3>English biscuite manufactures (Pvt) Ltd.
work on ERP of computer infinity which totaly
build for EBM.
and More
Graduation bachlor of science in computer