SUMMARY

• Over 20 years of IT experience and around 18 years of experience in SAP, this includes 15 years of experience in Business Information Warehouse (BW/BI) and around 5 years of experience on SAP S/4 HANA, Embedded Analytics, HANA Live and BW - HANA, CRM.

TECHNICAL SKILLS

ERP: ECC 6.0/5.0,CRM 5.0, TPM,SRM 4.0, SRM 7.0, SAP R/3 - 4.6 B, 4.6C, 4.7,HCM 6.0

Business Warehouse: BWI 7.5/7.4/7.3/7.0 , SEM-BPS, BPC, SAP BW 3.5/3.1C/3.0B/2.1C

Database: HANA DB

PROFESSIONAL EXPERIENCE

Confidential

SAP S/4HANA Embedded BW Analytics Architect

Responsibilities:

• Activated Embedded SAP BW Client, Specified BW Client for Configuration, Assigned the Logical System Client, Set BW Namespaces to Changeable.
• Created Embedded Analytics (Embedded BW and HANA) Virtual Provider for Finance data model using S/4 HANA View which is based on ACDOCA table and ADSO.
• Created Composite Providers for reporting layer.
• Activated Business Content InfoObjects /ERP name space for Profit Center, Cost Center and G/L account which uses Hierarchies by using standard S/4 HANA views as Master data from Hierarchy Remote class.
• Implementation and UAT and Hypercare Support for APAC, CEE and S LATAM S/4 HANA and BW rollout
• Vistex Implementation on BW 7.4/7.5 for Rebates
• APAC, CEE and South Latam BW rollout cutover activities with new company codes
• Experience with SAP HANA Modeling using Different types of views.
• SAP HANA Data provisioning using SAP Landscape Transformation and SAP Data services, Flat File upload.
• Knowledge on Qlikview/Qliksense reporting
• Good working knowledge of SAP S/4 HANA Finance (1605 On- Premise) involving SAP Accounting, SAP Cash Management and SAP Integrated Business Planning for Finance.
• Ability to design and recommend Finance transformation roadmap with S/4 HANA Finance to clients based on various deployment scenarios.
• Proposal prepared on S4 HANA data to send it to Microsoft Azure Data Lake( ADL) cloud using SLT-SDK

Environment: SAP S/4 HANA 1605, Embedded BW 7.5 SP04, Fiori Apps, AFO, Microsoft Azure DevOps, HANA SDA

Confidential

BW-HANA Architect

Responsibilities:

• Requirements gathering, and business discussions with BW and APO teams for FGI (Finished Goods Inventory) Implementation for Planning for CA, BR, MX Regions planning.
• Provided the data for Purchasing and Inventory, Open Orders, Shipments feeds from BW-HANA to APO for Canada, Brazil and Mexico Regions
• Create ADSOs for Inventory and PO data for BODS datasources using LSA ++ Architecture
• Composite Providers are being used for BW and HANA reporting. Created Process Chains and Scheduled for Data Loads
• Cut-Over Activities for QA Systems and data loads in both BW-HANA and APO-BW landscapes
• Prepared Technical Specification document. Loaded Planning data bak to BW from APO.
• Prepared Unit Test Cases for SIT and used it in HP ALM QC. Regression Testing of BW Reports vs APO Planning Book
• Involved in HANA SPS12 Upgrade discussions and Architecture meetings

Environment: BW7.4, SP10, BEx, HANA 1.0 SPS12, ECC 6.0. BO 4.1, Analysis Office, BODS, HP ALM, Tivoli

Confidential, Sunnyvale, CA

BW-HANA Architect

Responsibilities:

• Requirements gathering, business workshops and reporting discussions on CRM, BW and Flat File sources
• Preparation of Functional Specification Design (FSD) and Reports Specification Design(RSD) for SAP BW Inventory Management, CRM Repair Order Design Process and RMA (Return Material Authorization) using CRM Complainants and Service Process Datasource.
• Data Flow Diagrams and CP (Composite Provider) Joins design for BEx queries. The front reports will be on BO.
• Preparation of Technical Design Document for all data models in each functional area (IM, ROSO/PO and RMA)
• Inventory Snapshot Design and Development
• Master Data (0PLANT and 0 MATERIAL) enhancements to add new attributes for Service Inventory and Manufacturing.
• Fit Gap Analysis and End to End Data Mapping design
• Impact Analysis for existing Providers which will be used for this LEAP project

Environment: BW7.4, BEx, HANA 1.0 SP10, ECC 6.0. BO 4.1, Tableau, CRM 7.0

Confidential, Portland, OR

BW Architect

Responsibilities:

• BW Project Systems Implementation for CAPEX Reporting ( Capital Expenditure Reporting for Utilities)
• Development of Project Actual Costs cube 0PS C02(Copied and enhanced to ZPS C02) for Actual Projects and WBS Applicant Numbers from ECC Source.
• Created Z Applicant number to map Project Information to report in hierarchical structure in CAPEX report.
• Implemented logic to populate Payment Account Type( Applicant Number) when it comes in as 710 or 720, the data should get mapped to sub applicant like 711, 712, 713…..etc.
• Cutover activities, and Transported objects to BI QA system and Testing and UAT signoff.

Environment: BW7.0, BEx, ECC 6.0. Enterprise Portals

Confidential, Scottsdale, AZ

BW Architect

Responsibilities:

• BW System study and recommendation of Performance improvements
• SAP BW Content Reports Development for Inventory Management and FI-AR reporting
• Enhancements to Inventory Standard Content reports by making changes to Site and Merchandise Category Hierarchies
• Created BEx reports to provide as an input to Microstrategy reporting group. Tested all Finance AR Reports and Inventory Reports with different test scenarios. Created Change requests and Stories for Sprint and transports

Environment: BW7.3 SP11, BEx, Microstrategy, ECC 6.0. Agile Manager(Sprints and Stories), Service Now

Confidential

SENIOR PROJECT MANAGER/HANA Solution Architect

Responsibilities:

• Proposals creation for new projects on HANA and BW, Resource planning, allocation and Capacity planning
• GAP Analysis and conducted business workshops and BW-HANA training to team members
• Review current data warehouse/data mart landscape (BW, non-SAP EDW’s) and planned analytics use cases.
• Detail post-migration application configuration changes to architecture and how BW design changes with SAP HANA (LSA++ best prac­tices).
• Prepared high level design documentation and roadmap for Global SAP implementations
• Upgraded from BW 7.0 to BW 7.4.Migrated all BW 7.0 Infocubes and DSOs to HANA Optimized Infocubes and DSOs.
• Created In-memory Infocubes in BW 7.4 on HANA, Imported BW models to HANA and Created Calculation Views using CE functions and used for reporting
• Created SQL Script and procedures for HANA modelling, Tested all the BW objects and conversion to HANA Optimized
• Installed HANA Live Content VDMs for FI and SD Modules and used for HANA Operational reporting
• Replicated ECC tables data into HANA Studio using SLT Replication method.

Environment: BI 7.0/7.4 SP08, BEx, BO BI 4.1, HANA 1.0, SPS09, ECC 6.0, BI-IP, TPM, SAP Lumira 1.25

Confidential, Atlanta, GA

Sr. BW/HANA Consultant

Responsibilities:

• Development and Enhancement of Master Data Extractors. BPC RE Cycles Data loads and Validations
• Testing of BI InfoObjects, DSOs and Queries and Multiprovider. Data Validations of Master data and Transaction Data.
• Transporting Objects to QA, and PROD using TOC and Rev-Trac.
• Tableau dashboard development for BI Load statistics
• Communicated with Stakeholders and Steering Committee on the Project status with updates.
• Migration of BW to HANA Optimized Objects. HANA Performance testing. BPC Appset transports and End User training
• Landscape switch from Development path to Break-fix environments, and sync all the transports and objects in both landscapes.

Environment: BI 7.0/7.3, BEx, Tableau, HANA 1.0, SP06, ECC 6.0, Solution Manager, BPC 7.5, BO/BI 4.1

Confidential

Sr. Architect

Responsibilities:

• Designing a Strategy for Hilmar Reporting using BO BI tools
• Architecture Design for SAP BW- HANA and ECC- HANA Live, Recommended HANA Side Car approach.
• BW-HANA Solution proposed for Stakeholders, Requirements gathering for all Reporting needs and Management reports.
• Conducting Business Blueprint workshops with Hilmar user group
• Gathering Reporting Requirements (As Is ), Gathering required KPIs and Dashboards information for Stakeholder management reporting.
• Preparation of the As Is and To- Be documents, Preparation of GAP Analysis document and identify the Standard and Custom Reports
• Preparation of Business Blue Print Document, Preparation of Functional Specification Documents.
• Developed the operational reports using HANA VDMs for QM and PM, PS and used HANA Live Query views
• Proposed Analysis Office for analysis and HANA operational reports, Preparation of RFPs for client proposals for Confidential HANA Practice. Pre=sales and Resource management for HANA Practice

Environment: BI 7.4/BEx, BO BI 4.1, HANA 1.0, SP06, ECC 6.0, Solution Manager, SRM 7.0