Shamshuddin Shaik

• (BW4, Datasphere & SAC Consultant)
• Environment: BWonHANbw4A, S4HANA, SAP ECC, Native HANA, Tableau, BO 4.3 (Webi, A4 Office and Analysis for OLAP), SAP SD, Retail, FI, and MM
• Currently working on Agile Sprints on demand-based stories for Logistics reports in SCM area
• Currently working on critical reports like Freight visibility, international transportation Cost report, Historical transport costs and Stock Exchange Dashboard
• Building new reports using the hybrid models for Freight Volume, Units, Stages, Costs for Transport Management and DIFOT reports in PUR area
• Involved in daily discussion with Aldi Business/functional team to understand the requirement and delivered FSD's and TSD's accordingly
• Working closely with Data Engineers and ALDI IT experts to get the requirements and convert them to requirement specification
• Involved in Daily scrum Calls with the Scrum master to get the list of objects targeted for the upcoming release and worked with the offshore team to deliver them as planned
• Created Input ready queries to fulfill planning requirements using Aggregation levels and Planning functions
• Worked on Data modeling in Datasphere and consumption of data into SAC
• Experienced in Data Wrangling, Model Config, Story Development and Security
• Developed complex advanced formulae using Data actions and consumed in Multi-actions to automate the process using Planning Calendar
• Continuous collaboration and discussions with Financial Planners during the Budget and Forecast predictive & Allocation processes
• Worked on Predictive Forecasting, Data Distribution, OPEX, CAPEX planning, Allocations, Data Actions for planning scenarios in SACP
• Expertise / Knowledge of SAC predictive capabilities, augmented analytics, forecasting, Smart Assist, Smart Predict, Smart Discovery, creating story canvases, advanced story designing, blending data, formulas, cross calculations, input controls, linked analysis
• Strong hands in building Data Actions and Allocation Processes, Copy Data within and between models, Calculate Data with Advanced Formulas, Create Advanced Allocations, Data Locking, Processes and Data Locking Tasks Successfully deployed interface and consumption analytic models for the demand use cases in Datasphere.
• Created Entity relationship models for data preparations, views by joining different source tables and created data flows and executed for data federation
• Worked on Data flows and task chains auto scheduling and manual execution based on the demand
• Experienced in DataSphere functionalities with BW bridge and replication scenarios into DataSphere
• Delivered Repeat Quantity tool requirements to have an AFO based tool to view Promotions, forecasts and quantity details based on country and Region
• Currently supporting UAT sessions with users and working on defects and in preparation to cutover activities for Pre-PRD and PRD environments
• Involved in developing the solutions for the Gaps raised for the rollouts of AT and DE
• Successfully delivered the sprint 3, 4 and 5 gaps for DP5 project
• Prototypes successfully delivered and built for the critical design to fulfill the business requirements for Repeat Quantity tool
• Currently helping the ADM team with retrofits in Track 2 system to have consistency in Track 1 and 2 developments
• Currently performing the Pre and Post cutover activities for Go-Live prep
• Involved in Unit test, ALM test runs, scenarios to complete the testing for user Demo's
• Developed complex data models to support business decision-making.

• Environment: BW4HANA, SAP ECC, S4HANA, Native HANA, BO 4.2 (Analysis for Office), SAC, FI & SD.
• Part of the Integral Planning Horizon project forums to understand the business requirements to introduce new KPI’s for Forecast Accuracy and BIAS along with Business Owners and the Solution architects.
• Redesigned HANA Attributes Views, Calculation Views, and HANA Analytical Views for various Sales & Finance Extractor Loads and called them using the Open ODS (Using Database Tables/ Views) in SAP HANA Studio for SAP BW/4 HANA.
• Worked on developing and deploying SAP Analytics Cloud Models and stories using Acquired and Live connections data.
• Worked on Advance modelling concepts like Geo Dimensions, Calculations and Security.
• Worked on Import jobs, Datasets, Models and Modelling strategies (Structure and Data) with ETL and ELT.
• Experience working with analysis across models (Linked dimensions, Blending, Calculated measures and Dimensions)
• Experience in working with VDM’s using CDS views to support Embedded and Strategic reporting.
• Delivered various critical dashboards like Profitability Health & Compliance, First Year Sales 1 & 2, CAD Indicators and Forecast accuracy using SAC.
• Successfully delivered stories in SAC Mobile using Canvas and Responsive pages and Implemented stories using different features of SAC.
• Experience in applying smart features of SAC according to the requirement and analysing the data.
• Tested and resolved data issues in SAC Dashboard stories also involved with transports of from dev tenant to prod SAC tenant.
• Delivered CR’s (change requests) and incidents to help business with respect to the go-live support for the development work.
• Data Profiling and Harmonization activities to get correct data from different sources into Corporate BW data models.
• Worked on Business requirements and development of FACC, BIAS, Snapshot comparison and Trend reports.
• Extensively worked on different BW4 HANA data flow objects (Dataflows, Composite Provider, ADSO, Open ODS View).
• Worked on Sprint requirements for Portfolio Health and Compliance report using BW modelling, HANA views and dashboards.
• Worked on Business requirements and development of HANA views for Portfolio Health Dashboard.
• Worked on development of HANA views for CAD indicator Dashboard.
• Worked on BW sprint requirements for BW developments to build Compliance Report and it’s corresponding SAC dashboard.
• Worked on SNOW/Charm processes to transport the changes across the landscape.
• Worked on migrating existing AFO reports to SAC for reporting requirements.
• Worked on Governed and Self-service reports in SAC and related data models.
• Prepared and executed different test cycles (UT, UAT and Regression) before moving the BW and HANA changes in the landscape.
• Supporting all the cutover (Pre and Post) and Go live activities.

• Environment: BW4HANA, S4HANA, SAP ECC, Native HANA, BO 4.2 (Webi, A4 Office and Analysis for OLAP), SAC, SAP SD, FI, IM and COPA
• Duration:, Workshops/ Meetings on requirements with Business Owners from each business area along with Solution architects
• Data Profiling and Harmonization activities to find the right / suitable fields to full-fill requirements from all the sources (MFG Pro, ICO and One SAP)
• Analysing COGNOS data to fit into Global COPA model in BW to decommission the COGNOS dependency
• Preparing Overall mapping from all the different sources to Global ANBI system and get them approved with SA's
• Used CDS views to extract Fact, Dimension, Text, and Hierarchy data into BW
• Creation of different ADSO's for Global COPA model (BW Saturn, ICO and MFG Pro Data)
• Creation Attribute views, Calculation views for master data and transaction data (Dimensions and Star)
• Experience in SAP HANA development, migration, optimization, and support for mixed approach with Native and SAP BW on Hana solutions
• Executing different test cycles (UT, UAT and Regression) before moving the BW and HANA changes in the landscape
• Creation of Cutover and Run book for executing the pre and post activities for QA and PRD
• Enhancement / Creation of new Meta and normal process chains as per the requirement and data loading activities
• Analytic Privileges to restrict the users based on Company code and Profit centre
• Helping with a POC on Analytics Hub to centralize all the Analytics for governance and roles
• Worked on SAP Analytics Cloud by creating Stories with existing models and data sources
• Created temp models along with Business to analyse and plan the reports
• Supporting all the go live activities like, one pager documents, user training and supporting documents.

• Environment: SAP BI 7.5, BW on HANA, BO 4.2 (Webi, A4 Office and Analysis for OLAP), BPC, SCM/SPP, SAP MM, IM, IPOS (Unipart / Neovia) and Bex Tools
• Duration:, Associated with P22 and P5 Projects under P2020 Program
• Working on Wave2 requirements and its related CR's for P22 and SPM remediation for LPROD, DRP for P5 project
• Listen to the business stake holders and Business process owners to understand business needs, analyzes complex business requirements, reporting requirements and propose the best solution for them, and convert them into write the functional specification
• Preparing the development tracker, development activities and working along with the development plan
• Supported all the activities related to SAP Database Migration Option tool (SAP DMO)
• Worked closely with Transfer/Migration cockpit and successfully supported Inplace/remote conversion, scope collection, Object mapping, Map Objects (Providers), Partition criteria's for SPO's and determining the usage of involved objects
• Worked on Critical SCM - SPP (APO) remediation for DRP to get PREQ and DS data into BW
• Worked on Daily material movement, Stock and Ageing reports Sourcing data from IPOS to BW
• Worked on Inventory extraction scenarios like Stock initialization, Material movements and Revaluations for extracting Material Stock values and Snapshots from SAP ECC
• Worked on Stock, Stock In-transit, and Ageing reports using Inventory BW data flows using the master data from SPP and IPOS
• Worked on Forecasting, Availability, C&CR and NPI core master data reports
• Delivered new Purchase Req and Delivery Schedule reporting solution for DRP data by reading the data from Live Cache to report the Purchase requisitions and Delivery Schedules
• Successfully completed Wave1 and Wave2 requirement (30+ reports) developments and UAT with business users
• Successfully delivered Wave2 CR's (Changes in existing reports) as requested and validated with Business
• Delivered new COPA based reporting solution with customer Hierarchy for Operating concerns JLR0, JLR1 and Neovia data
• Assessed the Business validation sessions for Wave2 reports with PRD data and planning pre and post cutover plans for the next release of reports for Go-live
• Successfully supported the 1st roll out (South Africa) Go live for P5 Project including the Pre and Post cutover activities and the incidents raised for the issues.

• BI 7.4, BW on HANA, BO 4.1 (Webi, Analysis for Office and OLAP), Lumira, ECC 6.0 and Bex Tools
• Duration:, Associated with new CAPEX, P&L Budget, and Passenger Mix Analysis for Outturn and Site reports for MAG using BI 7.4 as a Back end and Webi and Analysis for Office as a front-end tool
• Requirement analysis, scoping of requirements and preparing Detailed High-Level Designs
• Attending Workshops and Buddy up meeting with MAG and CAPG teams to understand the requirements
• Compared the requirements with the existing report packs
• Prepared the plan and development activities and working along with the development plan
• Worked on technical design for CAPEX Outturn in BW and reports using AFO (Analysis for Office)
• Worked on new BW models using 7.4 BW modeling using HANA Studio
• Involved in HANA modeling objects for the data models to support reporting requirements
• Worked on Composite Provide based data consumption and reporting structure using BW 7.4.

• Project: Global Dashboards, STONE, RMA, Expense Reporting, Payroll, GTS& CR's
• Role:, and, Environment: SAP BI 7.3/7.4, BO 4.0/4.1, ECC 6.0 (SAP HR, GTS, IM, SD & FI) and Bex Tools
• Duration:, Successfully delivered projects like Payroll Reconciliation, GTS (Global Trade Services), Expense Reporting and Encore (Product Costing)
• Also working on Change requests like Purchasing Price Variance and Purchasing Account Assignment and Cost Center Accounting data flows from Smart France and China
• Worked on Payroll reconciliation project to deliver 6 reconciliation reports for different sites in JLR based on their Payroll group (HR)
• Worked with Security team with regards to authorizations/access to the payroll recon report
• Worked on Encore project to develop 2 Product Costing (CO-PC) reports for costing-based analysis for JLR
• Worked on Expense reporting project (FI and PO) to deliver 6 reports for expense controllers and senior management in JLR and automated planning data loads using IP
• Worked on GTS to deliver 2 (SAP GTS) reports for classification and LTVD (Long term vendor declarations) for JLR
• Successfully delivered Logistics analytic reports (SD and MM (Procurement)) with integration of Global master data to provide management reports and dashboards for Centre of Excellence Group
• Successfully delivered STONE solution for Brazil with the scope of 4 Logistics reports using SD and NF (Nota Fiscal) and re-testing the existing reports to avail them for Brazil Market
• Experience in attending Workshops and business meetings for Scope and Requirements
• Worked on Preparing Project and Delivery Plans to fit the requirements in the POAP
• Involved with BW on HANA migration to migrate standard BW objects to HANA optimized Objects (DSO's and Info Cube's)
• Financial planning through planning sequences and input ready queries using IP
• Data extraction from APO and ECC system and planning the data using BI IP
• Effectively used estimation tool to estimate the efforts for smooth execution of the project
• Working Closely with Basis an EP (Enterprise Portal) for getting the system related issues and Single Sign On and managing the access, connections and Test user id's for BI/BO
• Working Closely with Stakeholders and Business to understand the business requirements and getting the logical solutions for the requirements
• Worked on Requirements analysis, scoping of requirements and preparing Functional Design Documents
• Created Design Documents to support the FDD's to ease the developments
• Worked on Graphical Data Modeler to manage Data Flows
• Worked on Multiple Source system connectivity to support Globalization of data for reporting
• Effectively handled master data to support compounding of multiple sources of data
• Effectively handled cascading of data based on the user selection to ease the usage of reports
• Worked on Special Nota Fiscal Data Sources to support compliance for Brazil taxation
• Created data flows to support reporting requirements for Global Master data (MDM) and Order to Cash, Finance, Procure to Pay, Human Capital Management, Quality Management, Plant Maintenance and SAP Nota Fiscal (NF'e)
• Created new WEBi and AOLAP reports based on Bex and OLAP connections via BICS in CMC
• Involved in all test cycles (Unit, UAT and Regression) to support testing and defect resolution
• Managed all Transport movements within the landscape including the cutover activities
• Managed transition to BAU support team for post go live support
• Effectively managed the performance improvement activities to improve the load and system performance.

• Project: PATHFINDER New Tools is an initiative to design, prototype and test new tools in SAP such as HANA and BO
• Project: SFS (Segmented Financial Statement Reporting)
• Project: DLSO (Data Load Scheduling and Optimization)
• Project: PCA, ET, CCA, APO (DP & SNP), Process KPI and COPA (Sales Performance) Redesign to BW Scalability & Performance-BWSP (LSA)
• Project: Data Archiving using NLS and Data Deletion (PCA, CCA, PKPI, ET, IG, AA and Faster vs Sales performance)
• Project: Faster Annual Year End Changes2008, 2009, 2010 & 2011
• Project: New Steering Concept for Reporting (PCA, CCA, PKPI, ET, IG, AA and Faster vs Sales performance)
• On successful deployment of the prototype all the existing solutions (800 + SAP BI reports & the BW) would be retrofitted using these new tools
• 7.3 (NW 2004S), HANA 1.0, BI4, BEx Query Designer, Report Designer, Web Intelligence, Dashboards, Analyzer, Web Analyzer, Web Application Designer, Crystal Reports.

• Environment: SAP BI 3.5, ECC 4.7
• Involved in creation of Info Objects, Info Cubes, ODS, Info Source, Data Source, Communication Structure, Transfer Structure, Transfer rules, Update rules, Update methods, info packages, Transformations and DTP’s.
• Worked with Business Content Extractor LO Cockpit, FI extractions and created customized extractors to extract data from R/3.
• Involved in Developing Multi providers, Info sets and Open Hub services.
• Loaded the data from R/3 to BW and used initialization with delta update and full update methods.
• Managed and monitored several data loads. Optimized load performance resolved the errors and inconsistencies during the data loads.
• Involved in Performance Issues like Creation of aggregates & compression of the Info cube to improve the query response.
• Transporting the developed and changed objects from development system to different system Landscape using Rev-Track.
• Development of new Info Cubes, Creating Info Sources, Setting transfer rules.

· Activating necessary Business Content Objects.

• Used ODS to stage the data before transferring the ODS contents to the Info Cube.
• Loading data into BW system from flat files.
• Set the extraction process using LO execution cockpit and CO-PA extractor.

· Performing GENERIC extractions with delta enabled.

• Enhancing data sources by appending new data elements using enhancement component and used user exits.
• Created and maintained queries in BEx analyzer which involved using conditions, exceptions, RRI, structures, calculated & restricted key figures, variables, query views.
• Created Process chains for different Business areas.
• Scheduled daily/weekly/monthly data loads and process chains.
• Worked on Performance and Job monitoring.
• Created and monitored aggregates as part of query performance.
• Performance tuning using Partitioning and Compression.
• Changing existing queries suiting the requirements of the client from time to time.
• oaded the Master data manually and using Process chains.