Profileimage by Aijaz Shaikh Solution Architect in SAP - BI/BW/BO/BW4HANA/BPC/ Profile(www.linkedin.com/in/aijaz-shaikh-94829526) from Mumbai

Aijaz Shaikh

available

Last update: 09.02.2023

Solution Architect in SAP - BI/BW/BO/BW4HANA/BPC/ Profile(www.linkedin.com/in/aijaz-shaikh-94829526)

Company: Freelancer - SAP Consultant
Graduation: MBA(IT & Systems), Bachelors in Computer Sciences
Hourly-/Daily rates: show
Languages: Arabic (Elementary) | English (Native or Bilingual) | Hindi (Native or Bilingual)

Attachments

bwhana1-RecordOfAchievement.pdf
bifour1-1-RecordOfAchievement.pdf
hsead1_RecordOfAchievement.pdf
roambi1-RecordOfAchievement.pdf
hanacloud1-2-RecordOfAchievement.pdf
s4h5-RecordOfAchievement.pdf
s4h1-RecordOfAchievement.pdf
BPC_certificate.jpg
SAP_C_BW4HANA_20_Aijaz_Shaikh.pdf
sac5_RecordOfAchievement.pdf
Cv-Aijaz-Shaikh-SAP-upload_090223.pdf
SAC-SAP-Global-Certification_090223.pdf

Skills

Career Objective:
“To set and achieve higher benchmarks in IT industry through extensive handwork, interpersonal, educational and communicational skills thereby ensuring self and organizational growth for a long term association and mutual benefit”

SAP Experience Summary:
IT professional with 16+ years of diverse IT Industry experience incorporated with 18+ clients covering multiple Implementations, Enhancements, Support, Global Rollout projects, highlights include:
  • More than 16 yrs of relevant experience with SAP Solutions in Analytic.
  • Good understanding of various SAP modules and their interconnection.
  • Adequate knowledge in newly emerged technologies
  • Good leadership, Communication, Presentation & Customer Relationship Management skills.
  • Ability to lead, drive and strategize the multiple cross function business model.
SAP Skill based Experience details
  • BW4HANA : SAP Certified Consultant with Real time exposure to BW4HANA scenarios modelling, Worked on Badi provider enhancement, Creating Composite provider, Advanced DSO. Worked on ODQ and HANA optimized contents using both Eclipse and Hana Studio Worked on Analysis for Office for BW queries. Exposure to SAC for Data Reporting.
  • BW on Hana: Worked on HANA Optimized BI Content using LSA++, Data management (Active / non Active data),Monitor non-Active Data concept, HANA Optimized InfoCubes, Creating Advanced DSO, Composite Provider, ODSview using Hana Studio, Knowledge on Hybrid Provider based on DataStore, based on Direct Access, Knowledge on HANA Views for Queries as Infoproviders, Hana Live Views(Query / Reuse / Private ), System landscape approach using Side car scenario and Integration scenario, BW on HANA affect on Process chain, Authorization(Analytic/Object/Package level Privileges)
  • BI/BW  – Design & Build InfoProviders (Infocubes, ODS, MultiProviders, Infoobjects) & associated data flow structures (Infosources, DataSources, Transfer & Update rules), Infopackage monitoring and scheduling, Process Chains and Reporting Agent. Data upload from different source systems (SAP R/3,CRM, Manugistics, Hyperion), LO Cockpit configuration in R/3, Generic Extraction and user exits. – Query design and output, advanced query design features (cell restrictions, exceptions, conditions). Testing with Respect to different Modules by comparing Corresponding ECC reports with the BW reports by understanding the different SAP modules functionality of the concern area. Activating standard SAP BI content and applying the reusability by modifying them in accordance to the Business requirements. Query performance management (Aggregates, Multicubes, Query settings, BW Statistics installation, Compression, Dimension Analysis) and Data Loading performance management (Parallel loads, infopackage settings, ODS management, Init v/s Delta loads)
  • BOBJ Reporting and Administration: Experienced in Web Intelligence, BO analysis for Excel, Dash Board Designer etc as the BOBJ tools to implement successful reporting as a part of various Projects, Overview of CMC and other related BO settings. Expertise in CMC Tools Promotion Management, Handling IDT, Design Studio. Knowledge of  Universe Design Tool, Query as Web Service designer. Good experience on creating crystal reports in SAP Business Objects to write complex formulas, Alerts, Conditions, designing a report along with proper header footer, Using Cross tab tables in reports and other equivalent functions of crystal reports.
  • BPC10 (Business Planning and Consolidation): Understanding the business flow for Consolidation of statements, creation of models, dimensions, environments, loading valuable finance data through flat files and BI systems, Generating reports based on the data stored in models from BI systems in BPC systems. Setting up the ownership manger, Consolidation manager for the systems, Desiging customize complex reports for HAGL consolidation
  • Native Hana: Worked on HANA modeling (Analytical/Calculation/Attribute) views, Operational data provisioning (SLT replication method, DXC method), SLT configuration etc. Consuming HANA views on Ms Excel using HANA MDX version
  • SAP BODS: Experience in creation and setting up data stores, projects, workflows, data flows, complex Jobs, Work Flows, Data Flows, and Scripts using various Transforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target, Change Data Capture on both SOURCE and TARGET level and implemented the SCD Slowly changing Dimension Type 1, Type 2 and Type 3.
  • FusionOps: Hold Novice level experience on Fusion ops monitoring, Monitoring Facts, Dimensions reviewing SAP tables. Configuring Fusion Ops system for provided scenario by the functional consultant. Maintaining system security, Add/Edit/Maintain user, Provide roles security to them as requested and approved by the team.
  • SAP Solman: Knowledge on Solution Manager with respect to Template management, Test management, IT task management, Control management, Incident Management, Creating, Testing, executing Test Cases as per requirement.
  • SAC: Certified SAP consultant holding adequate Knowledge on SAC(SAP Analytics Cloud) with respect to Data preparation, Design, create, and add analytical applications to SAP Analytics Cloud. Design, create, and add stories to SAP Analytics Cloud. Describe the use of for SAP Analysis for Microsoft Office, edition for SAP Analytics Cloud and SAP Analytics Cloud, analytics designer, Content Presentation, Sharing and Collaboration, Digital Boardroom, Mobile, and SAP Analytics Hub.
  • Analysis for Office(AO): Worked on AFO Reports with datasource as BW queries, Local data provider, Excel. Reports navigation and analyze, working with prompts, workbook components, data filters, Calculate keyfigures, Restricted Keyfigures, Data sorting, comments, Conditional formatting, Cell formatting, adding rows and columns, Formatting styles, adding diagram, Using formulas| Predefined SAP functions, working with tools and formulas, views etc, writing expert formulas as per the report requirments.
  • ABAP: Knowledge on ABAP can understand the code and able to right Includes and Routines in ABAP at a Novice level. Good knowledge on code analysis, problem identification

Project history

02/2018 - Present
Moduslink Global Solutions – BI Run and Maintain(R&M)
Moduslink Global Solutions (>10.000 employees)

Project Profile:
The project is to run and maintain the existing BI Solutions of Moduslink, Provide necessary technical solutions to improve the existing solutions with an approach to let the client get the best fit within the SAP ecosystem.
ModusLink Corporation provides digital and physical supply chain solutions to many of the world’s leading brands across a diverse range of industries, including consumer electronics, telecommunications, computing and storage, software and content, consumer packaged goods, medical devices, retail and luxury and connected devices. With a global footprint spanning North America, Europe and the Asia Pacific, the Company’s solutions and services are designed to improve end-to-end supply chains in order to drive growth, lower costs, and improve profitability.
Responsibilities:
• Leading Team to work through right direction.
• Identifying the potential service improvements and work accordingly to get this implemented correctly
• Understanding the Process documents and follow the procedure accordingly.
• Guide Peer and other Team members to materialize the content and requirement as per client’s need.
• Studying the Moduslink BI systems and HANA systems.
• Load monitoring and upgrading the Process with Process chains.
• Working on the enhancements and the change requests as per Clients requirements.
• Providing Fine Tuning solutions to their existing Systems.
Environment: SAP BI 7.4.

09/2017 - 01/2018
Armtec LLP Canada – BIBO Implementation
Armtec LLP

Project Profile:
The project is to implement BIBO Solutions to Armtec based on the FSD’s provided by the client. Need through expertise and knowledge on the business process, Mapped Business to IT providing the Best practices of SAP. Reporting is been done using Analysis for excel, WebI and crystal reports.
The Project deals with providing an analytical solution as a Solution Architect to Armtec using the platform of SAP BI and BO as a front end reporting tool on there various business operations which covers Finance, Operations, Supply Chain Reporting. The detailed level scope provided below
Responsibilities:
• Leading Team to work through right direction.
• Understanding the Function Specs.
• Guide Peer and other Team members to materialize the content and requirement as per client’s need.
• Writing the technical specs accordingly in alignment with the Functional specs.
• Understanding the business standard BI content.
• Creating BI and BO related objects.
• Worked on Extraction, Transformation and Load process
• Creating Bex queries and connecting them to Web I reports using BICS connections
• Create BO reports based on the BI sources.
• Expertise BO resource for Promotion Management, Web I and Analysis Reportin

03/2015 - 03/2017
H.D Smith BIBO Support
H.D Smith (Pharmaceuticals and medical technology, >10.000 employees)

Project Profile:
The project is to support H.D Smith on their various BI support activities, Ticket Resolution, Load Monitoring providing fine tuning solutions for their existing systems along with Fusion Ops system.
Responsibilities:
• Studying the H.D Smith BI systems.
• Load monitoring and upgrading the Process with Process chains.
• Working on the enhancements and the change requests as per Clients requirements.
Providing Fine Tuning solutions to their existing Systems.
Environment: SAP BI 7.4, SAP BO 4.1

05/2014 - 02/2015
LeasePlan UK BIBO - Implementation
LeasePlan (Automotive and vehicle construction, >10.000 employees)

Project Profile:
The project is to implement BI BO solutions to leverage the Analytical solutions for their Freight Management. The requirement mainly is to activate the standard BI content and customize it will little level of complexity and materialize the data through BO reports using Bex as a source query
Responsibilities:
• Understanding the Function Specs.
• Writing the technical specs accordingly in alignment with the Functional specs.
• Understanding the business standard BI content.
• Creating BI and BO related objects.
• Creating Bex queries and connecting them to Web I reports using BICS connections
• Create BO reports based on the BI sources.
• Expertise BO resource for Promotion Management, Web I and Analysis Reporting
Environment: SAP BI 7.3, SAP BO 4.0

07/2012 - 10/2012
Coca Cola Enterprises, USA, BPC 10 Support - Planning
Coca Cola Enterprises

Project Profile:
Coca-Cola Enterprises is a subsidiary of the Coca Cola Company in the United States. The company produces concentrate, which is then sold to licensed Coca-Cola bottlers throughout the world. The bottlers, who hold territorially exclusive contracts with the company, produce finished product in cans and bottles from the concentrate in combination with filtered water and sweeteners. The bottlers then sell, distribute and merchandise Coca-Cola to retail stores and vending machines. The project is about to do the planning for all the products and Raw materials which include there ABP (Annual Business Planning), LRP(Long Range Planning) and MMF (Mid Month Forecasting). It includes different business process which coke had used to do the planning. The project deals with designing different Input forms and reports to view them
Responsibilities:
• Studying the COKE systems.
• Creating Dimensions and models in BPC systems in order to fine tune them.
• Updating Master data in the dimensions for different products.
• Creating complex reports in BPC systems
• Setting up Member formula for specific dimensions as per the functionality specified
• Transporting the BPC objects accordingly into system
• Understanding the defects in existing implementation and fixing them
• Using Data Transformations using flat files and BW targets.
• Understanding existing planning scenarios for coke and do the modifications accordingly
• Good Knowledge for setting up of planning functions.
Environment: SAP BI 7.3, SAP BPC 10.0

02/2012 - 07/2012
HAGL, Vietnam, BPC 10 Implementation - Consolidation
HAGL - Phoenix Group (>10.000 employees)

Project Profile:
HAGL (Hoang Anh Gia Lai) Group is a Vietnam based major industry giant which is holding business in various verticals such as Rubber Plantation, Real Estate, Furniture, Power Machinery, Mining and other related business the project is extensively about implementing the BPC tool in HAGL with BI being a based system, Its about theconsolidation of the HAGL’s book of accounts with complex reporting which are viewed dynamically using dashboards.
Responsibilities:
• Studying the HAGL systems.
• Creating Dimensions and models in BPC systems.
• Updating Master data in the dimensions.
• Creating the ownership manager for the same
• Configuring controls for the same
• Creating complex reports in BPC systems
• Setting up Business rules as per the functionality specified
• Transporting the BPC objects accordingly into system
• Setting up the Security and BPF as per requirements
• Data Transformations using flat files and BW targets.
• Setting up data validations
• Good Knowledge for setting up currency conversion, IC elimination, Account transformation etc.
• Sound knowledge of IFRS kit and related provisions, Ownership structure for the Organization. Covered various scenarios of Consolidation.
Environment: SAP BI 7.3, SAP BPC 10.0

08/2011 - 11/2011
Diageo, Great Britain, BI 7.3 Enhancement and Support
Diageo

Project Profile:
Diageo is a global alcoholic beverages company headquartered in London, United Kingdom. It is the world's largest producer of spirits and a major producer of beer and wine. The project is about the development and implementation activity of LSA (Layered Scalable Architecture) where in different data layers are been implemented in Diageo’s BI servers. The projects mainly focus on the quality of Solution Architect; it includes deep understanding of the LSA structure and its capabilities to ensure a smooth quick and sleek reporting system.
Responsibilities:
• Deep understanding of the Diageo’s BI systems.
• Creating various data layers of LSA using DSO’s, Cubes & Multiproviders
• Creating complex transformations between targets
• Enhancing existing BEx reports by the new logic which is used in LSA architecture.
Environment: SAP BI 7.3, SAP ECC 6.0

12/2009 - 03/2011
Infineon, Germany, BI 7.0 Enhancement and Support
Infineon

Project Profile:
Infineon BI Support and Enhancement Project acquires with working on the change requests for the existing system, enhancing the existing flow of BI systems, providing BI support across various modules such as Purchasing, HR, CRM, PM, AR etc .
Responsibilities:
• Studying the Infineon BI systems.
• Load monitoring and upgrading the Process with Process chains.
• Working on the enhancements and the change requests as per Clients suggestions.
• Changed relevant Data targets – DSO’s, Cubes and Multiproviders.
• Created project documents as and when required for the change process.
• Access to Remedy 7 and good knowledge of change processes.
• Successful Transportation of BI Objects through Infineon Systems.
• Onsite lead Coordinator managing the team with relevant team management skills.
Environment: SAP BI 7, 3.5x SAP ECC 6.0

07/2009 - 11/2009
Procter and Gamble, USA, BI 7.0 Implementation
Procter and Gamble,

Project Profile:
BI Analyst Netweaver is a enhancement project where the dashboard was created on an BSP application. Flex designers work on Dashboard to make them changes available necessary actions are required to be done in BI systems which are used in backend.
SC-CPO Measures is an implementation project which extracts the data from SAP ECC systems, Transforms the data and relevant BI reports are made to publish the data. The CPO part of project comprises of various sections under purchasing module such as Purchase Orders, Purchase Request, Trigger database, Outline Agreement. The SC part of project comprises of various section under finance module such as Accounts payable, General Ledger, Invoice Ledger.
Responsibilities:
• Studying the Procter and Gamble’s BI systems.• Created Technical Specs of the OA flow.
• Designed relevant Data targets – DSO’s, Cubes and Multiproviders.
• Created test documents to ensure that data is validated in BI targets.
• Created BI report on OA flow.
• Created UTP for BI reports ensuring smooth and concise data on Web.
• Successful Transportation of BI Objects through P&G Systems.
Environment: SAP BI 7, SAP ECC 6.0

05/2007 - 06/2009
Chevron Oronite, USA, BI 7.0 Implementation
Chevron

Project Profile:
Chevron Oronite was having all its data stored in JD Edwards systems all over its branches across the world. There primary goal was to collect and transform all this data from JD and shift to SAP R/3 systems. Once the data is transferred into SAP systems it will then connected to BI systems for Global Reporting. The Scope of the Project is to collect the data from OLTP system to OLAP systems and then make Global reporting on the Data targets which be integrated through Chevron dashboard – A Cognos frontend to view the reports.
Responsibilities:
• Studying the Chevron Oronite BI and ECC systems.
• Worked on Master data & Transactional data for loading the data right from creating the Iobjects
• Analyzing and creating the design (HLD, LLD) documents required for development.
• Took Active part in designing the Functional specs with the Client thereby ensuring the approval for desired modules
• Maintain the quality status for the project for ISO Audits
• Used SAP functionality to accomplish the projects
• Testing different SAP modules with respect to Application Product testing and Integrated Planned Testing for Finance, Sales, Controlling.
• Better understanding of the SAP working modules of Sales, Finance, Controlling.
• Understand the Business requirements for Chevron
• Activated the BI content info objects and info providers as per the Clients requirements
• Created web reports for the Client
Environment: SAP BI 7, SAP ECC 6.0

Certifications

SAC
2022
BW4HANA
2021

Local Availability

Only available in these countries: India
Looking to work remotely, Available to travel for Busniess Meetings as and when needed for the Project.
Profileimage by Aijaz Shaikh Solution Architect in SAP - BI/BW/BO/BW4HANA/BPC/ Profile(www.linkedin.com/in/aijaz-shaikh-94829526) from Mumbai Solution Architect in SAP - BI/BW/BO/BW4HANA/BPC/ Profile(www.linkedin.com/in/aijaz-shaikh-94829526)
Register