SUMMARY

• SAP BW/4 HANA Consultant with 8+ years of experience in SAP BW/4 HANA, Business Objects 4.x, BW 7.x powered by HANA platforms.
• Hands - on experience in gathering business requirements, analyzing the business process, architecture, implementation, support, migrations, upgrades, testing, go-live and post-go-live support of end-to-end SAP Business Intelligence environments including: frontend: BW Query, Business Objects - Web Intelligence (WebI), Analysis for Office, Design Studio, Crystal Reports, SAP Lumira, Power BI, Tableau. backend: BW and HANA DB, IDT, CMC, BOBJ Data Services and HANA Studio/Eclipse.
• Hands on experience in working on BW/4HANA, creating Advanced DSO (ADSO), Open DSO Views, Composite Providers. Experience in integrating BW with various SAP and Non-SAP source systems. Experience in sourcing data from BW/4HANA to visualization tools using calculation views. Knowledge of replication scenarios (ODP, Extractors). CDS views with analytical annotations. Migration from SAP BW 7.5 to BW/4 HANA 2.0 using migration cockpit and scope transfer tool. Creation of Calculation views for customized requirements, generating HANA views from BW objects, creating custom views on BW generated views using union, joins, projections, aggregations, variables, calculated and restricted columns. Experience modeling LSA++ architecture HANA optimized transformation and DTP, ETL processes, data flow object. Involved in creation of dynamic Analytic privileges in HANA. Replacing B-ex Customer exists using Input parameters, Scalar & tabular functions. Transportation activities using HANA transport container (HTC). Data Tiering Optimization.
• Worked extensively on support project using Waypoint ticketing system - incident/ problem/change. Finding resolution and root cause analysis for incidents. Worked efficiently on incidents with tight SLAs.
• Data extraction experience and good functional knowledge of various SAP modules such as SD, MM PP, FI-CO, CO-PA. SAP ABAP/4 Programming, Function modules.
• Others - Integrated Planning, Analysis Process Designer (APD), BPC, WAD, BEx Analyzer, Report Designer, DB Connect, Open Hub, BW Accelerator.

PROFESSIONAL EXPERIENCE

IT - Senior Consultant SAP BW/4 HANA BO

Confidential, Bellevue, WA, USA

Responsibilities:

• Involved in Migration from SAP BW 7.5 to BW/4 HANA 2.0 using migration cockpit and scope transfer tool.
• Creation of Calculation views for customized requirements, generating HANA views from BW objects, creating custom views on BW generated views using union, joins, projections, aggregations, variables, calculated and restricted columns.
• Experience modeling LSA++ architecture - Advanced DSO, composite provider, HANA optimized transformation and DTP, ETL processes, data flow object.
• Involved in creation of dynamic Analytic privileges in HANA based on the requirements
• Replacing B-ex Customer exists using Input parameters, Scalar & tabular functions
• Involved in Management of Transportation activities across the DEV, QA, PROD Environments using HANA transport container (HTC)
• Data Tiering Optimization
• Involved in development of Business Objects WEBI queries on top of BW Queries & HANA Models - Snowflake demand extraction
• Coordinating with offshore for the daily deliverables throughout the ASAP phases.
• Involved in explaining the end user requirements to the Onshore/Offshore & filling the gaps.
• Extensive experience in translating business KPIs into HANA models.
• Worked extensively on ITIL process Waypoint ticketing system - incident/ problem/change.
• Finding resolution and root cause analysis for incidents
• Worked efficiently on incidents with tight SLAs.

Environment: SAP BW/4 HANA 2.0, BW 7.5 on HANA, BOBJ 4.1, Analysis for Office,

HANA Studio

Confidential

Responsibilities:

• Environment BW/4 HANA, SAP BW 7.0, BW 7.5 on HANA 1.0, WEBI
• Modules: Sales & Distribution, Sales, Billing, Delivery
• SAP BW 7.0 Migration to BW/4 HANA 1.0 - Migrated BW 7.0 data Flows, queries from 4 regional BW systems to BW 7.5 HANA system
• BW development - Developed new BW data flows - Advanced DSOs, composite providers for BW 7.5 on HANA and BW/4 HANA.
• Experience modeling LSA++ architecture - Advanced DSO, composite provider, HANA optimized transformation and DTP, ETL processes, data flow object.
• Creation of Calculation views for customized requirements, generating HANA views from BW objects, creating custom views on BW generated views using union, joins, projections, aggregations, variables, calculated and restricted columns.
• Replacing B-ex Customer exists using Input parameters, Scalar & tabular functions
• Involved in Management of Transportation activities across the DEV, QA, PROD Environments using HANA transport container (HTC)
• Data Tiering Optimization
• Involved in development of Business Objects WEBI queries on top of BW Queries & HANA Models - Procurement Dashboard.

OptiAnalytics product

Confidential

Responsibilities:

• Environment: Business Objects 4.1, BW 7.4, Tableau, Power BI
• Major Dashboards Implemented – Development of Export Sales Turnover Analytics Dashboard using Dashboard Design tool which performs analysis various dimensions of Export Sales
• Involved in full life cycle - modeling, analysis, design specification, development, performance tuning and maintenance in BI74
• Porting BEx reports to Dashboard Design using BICS connectivity
• CMC – Created 15 OLAP connections in CMC which is utilized in Dashboard Query browser
• Design dashboard using Tableau, Power BI, Dashboard designer

Development and support

Confidential

Responsibilities:

• Environment - BW 7.4, APD, WAD, INTEGRATED PLANNING
• Real-time Objects Creation in Datawarehouse - Created real-time infocubes and stored planned data in DSO and input ready queries in BEX.
• Planning logic through IP - Creation of Aggregation level, Filter on Aggregation level, custom Planning Function, Planning Sequences, FOX
• Creation of Development Components in WAD/APD - Created WAD templates/RSPLAN/APD to execute input ready queries and planning sequences and store data back in real-time infoproviders in BW. Creation of iView, page, workset, role, user in Enterprise Portal.
• Execution sequence through Process Chains - Created process chains to ensure sequential execution of planning sequences/APD, target content deletion etc.
• Process Chain Monitoring, Performance Tuning

Confidential

Responsibilities:

• Environment- BI 7.0
• Requirement gathering – Requirement gathering from customer for BI and creation of Functional & Technical design documents of requirement in BW system.
• Implementation - Implementation of COPA Datasource, BW Modeling and development of Profitability Analysis Report. Address transport related issues across landscape
• Facilitation of User testing Creation of test scripts, Assisted super users to perform functional user testing
• Major Reports Implemented - design and development of profitability analysis report using custom developed CO-PA Extractor
• Post Go-Live Support - Supported critical reports in the initial phase of go live and performed loading of data in BW system for all components with queue initialization.
• Support - Activities including daily Process Chain monitoring and creation of load status report. Resolution of support tickets related to BI reports, load and operational issues. Manage SLA of support tickets. Creation of Master Schedule for Process Chains. Created chart on dependencies of Process Chain processes. Performance Optimization on Process Chains.

Software Consultant

Confidential

Responsibilities:

• Worked on ERP Gems-HR & Payroll Module.
• Aided clients during payroll processing, assistance to create and update the prerequisite information to a successful salary processing such as master data entry, employee profile updates, salary updates, promotions and increments, transfers, etc. in the HRMS.
• Audited the accuracy of data using MS Excel.
• Designed, developed, analysed and tested the application.