SUMMARY:

• SAP HANA BW BO certified consultant with 13 years of experience as Developer, Techno Functional Consultant and Architect.
• Worked on various versions of SAP HANA, BW and BO with multiple implementations, Upgrade& Migration, Support projects experience and Strong Hands - on experience in large-scale Data Warehousing projects.
• Working experience on various modules such as FI, COPA, SD, MM, BW-IP, BPC,APO, HR, PM, IS-Utilities, IS-Telecom, Retail, SAP CRM and Ariba.
• Good hands on experience in various phases of the project such as design, development, cutover and hyper care support.
• Managed project delivery, expectations and coordination with multiple business units and IT Teams.
• Extensively worked in Data Extraction from SAP and Non SAP (Legacy) Systems for LO, FI GL, LIS, Flat File and Generic Extraction Method s.
• Created Composite providers, Open ODS Views, ADSO,Multi Providers, Info Cubes, DSO, Open Hub and APD, generic extractors, based on the business requirement.
• Extensively worked on ABAP Programming for creation of Routines in start routine, end routine, expert routine in Transformations, BADIs and User Exists.
• Create and maintain automated process chains, background batch jobs to load data on daily, weekly and monthly basis. Resolved data loading issues and maintains issue log .
• Extensively worked on creation and Enhancements of Information Models and HANA Live in HANA as per best practices.
• Worked on HANA performance optimization by using Visualize plan, Expensive Statements Trace, Code push down, HANA Memory Consumption for system performance, data extraction and Reports execution time.
• Extensively worked on Data provisioning techniques SLT, DXC, SDA (Smart Data Access) & SDI (Smart Data Integration).
• Worked on SAP HANA Sizing, HANA migration & Optimization .
• Extensively worked on BW, BO and Tableau reporting tools.
• Worked on data extraction from ODP data sources and real time data for Embedded Analytics.
• Created Technical Specifications from Functional Specifications and BR documents.
• Provided project go live support and End User Training for executing of Reports in BW and BO reporting tools.
• Work on SAP notes implementation to correct/enhance system functionalities defined by SAP.
• Knowledge of CDS development, XS and OData Services.
• Provided analysis and resolution to assigned helpdesk support tickets .
• Actively participated in trainings and knowledge sharing sessions by subject matter experts in BW, BO, HANA DB, HANA modeling, BW on HANA and HANA roadmap.
• Having good Understanding and knowledge of Integrating Big data (Hadoop) with HANA.
• Having good understanding of new features of BW/4HANA.
• Having good understanding of new features of and Hands on Training S/4HANA system.
• Worked on project delivery and management through PMP and Agile Methodologies.

TECHNICAL SKILLS:

Business Intelligence: SAP BW 3.5, BI 7.X, BW 7.4 on HANA, BO 4.x .

ERP: SAP R/3 4.7/4.6C and SAP ECC 5.0/6.0

Reporting: BW BEx, WAD, SAP BO, Tableau.

Functional Module: SD, MM, FI,COPA, CRM,HR,PM,PS,IS-Utilities, IS-Telecom.

Programming Languages: ABAP/4, SQL, PLSQL.

PROFESSIONAL EXPERIENCE:

SAP HANA BW BO Senior Consultant

Environment: SAP HANA 1.0 SP12, BW 7.4, BO 4.1

Responsibilities:

• Worked on Translating business needs into Data Modeling and Reporting Solutions.
• Designed and developed data models in BW based on LSA++ Architecture.
• Worked on developments of Open DSO, Advanced DSO, Composite Provider.
• Worked on creation and modification of Transformations in BW.
• Worked on Performance tuning of data loads in BW .
• Created and modified Calculation View, SQL Scripting, Functions, Database Procedures and Analytical Privileges in Native HANA.
• Worked on data extracted using SDI and through ODP data sources into BW for Non-SAP Master and Transaction data .
• Worked on HANA performance optimization by using Visualize plan, Expensive SQL Statements Trace, code push down option and data filtering at appropriate level in data models.
• Worked on ETL Process for SAP and Non-SAP Source using BODS into Enterprise HANA.
• Worked on creation and modification of jobs, workflows, dataflow, Query transformations in BODS .
• Worked on integration, loading, scheduling, and managing data for BW and BPC .
• Worked on BW transformation developments using ABAP inline declarations.
• Worked on data extraction from ODP data sources and real time data for Embedded Analytics dashboard for FSA (Forecast scheduled agreements).
• Worked on development of Universes in B I/BO 4.1 using IDT from relational databases.
• Worked on development of Reports in BI/BO 4.1 using WEBI, Design Studio, Lumira.

SAP HANA BW BO Senior Consultant.

Environment: SAP HANA 1.0 SP10, BW 7.4, BO 4.1

Responsibilities:

• Developed Data models in BW based on LSA++ Architecture.
• Developed the data flow that consists of Data Source, Transformation and Info Providers (Open DSO and ADSO) in BW.
• Created and Modified Calculation View, SQL, SQL Scripting, Database Procedures, Decision Tables in Native HANA .
• Worked on HANA performance optimization using HANA PlanViz, Expensive SQL Statements Trace and HANA Memory Consumption.
• Worked on consuming and Enhancements of HANA Live Views in HANA as per best practices.
• Worked on integration, loading, scheduling, and managing data for BW-IP.
• Worked on development and modification of BW BEx reports.
• Worked on development of Universes in BI/BO 4.1 using IDT from relational databases.
• Worked on development of Reports in BI/BO 4.1 using BO launch pad (WEBI Reports), Design studio, Crystal Reports, Analysis office, Lumira and Tableau.
• Worked on troubleshooting and Performance improvement of BO Universes and reports.
• Created Attribute Views, Analytical View and Calculation Views based on best practices in HANA Studio.
• Worked on ETL Process for SAP and Non-SAP Source using SLT and BODS into Enterprise HANA.

SAPHANABW BO Senior Consultant

Environment: SAPHANA 1.0 SP09, BW 7.4, BO 4.1

Responsibilities:

• Managed project delivery, expectations and coordination with various business units and IT Teams.
• Collected and recorded project knowledge and experience and actively imparted it to other members of the team.
• Guided the team in creating Design Document and technical detail level of Documents.
• Worked on Data models in BW based on LSA++ Architecture.
• Worked on BW Developments using ODP data source with Smart data access .
• Worked on development of Universes in BI/BO 4.1 using IDT from relational databases.
• Worked on developments of reports in BI/BO 4.1 using BO launch pad, Analysis office, Lumira and Power BI.
• Worked on troubleshooting and Performance improvement of BI/BO Universes and reports.
• Worked on SQL Developments for creating scripted views in HANA.
• Worked on Creation of Analytical, Attribute Views and Calculation Views based on best practices in HANA
• Worked on consuming and Enhancements of HANA Live Views in HANA as per best practices.
• Worked on Data Provisioning using SLT Replication server from ECC.
• Worked on Data Provisioning using BO data services ( BODS ).
• Worked on creation and modification of jobs, workflows, dataflow, Query transformations in BODS .
• Worked on Analytic Privileges.
• Worked on various components of SAP HANA.

SAP BW Lead Consultant

Environment: SAP BW 7.0 & BW 7.4

Responsibilities:

• Checking and Implementing Up-gradation process from BW 7.0 to BW 7.4 SP09.
• Coordinated and executed the pre and post upgrade activities.
• Conduct impact analysis and implementation of SAP notes as per requirements.
• Conduct downtime estimation and supported the testing process.

SAP HANA BW Lead Consultant

Environment: BW 7.4SPS8

Responsibilities:

• Interaction with process owners and Functional teams for requirement gathering.
• Creation of detail level technical Documents.
• Created Attribute Views, Analytical View and Calculation Views based on best practices in HANA Studio.
• Worked on SAP HANA Sizing using quick seizer and Optimization of HANA system.
• Enhanced Standard Data Sources for CRM and FI Modules.
• Installed Business content for CRM and FI Modules.
• Review all developments created by team members.
• Created status updates for progress, issues, and risks for development of reports.
• Worked on Data Provisioning using SLT Replication server from ECC.
• Worked on Data Provisioning using BO data services (BODS).
• Worked on Data models in BW based on LSA++ Architecture.
• Worked on development of BW BEx reports.
• Worked on development of Reports in BI/BO 4.0 using BO launch pad, Dashboards, Lumira.

SAP HANA BW BO Lead Consultant

Environment: SAP R/3 4.7,SAP BI 7.3, BO 4.0, HANA 1.0 SP5

Responsibilities:

• Installed Business Content Objects, designed and developed SO, Cubes, Multiproviders and Info sets to meet business needs.
• Configured Data sources in R/3 by using LO Cockpit initialized the setup tables. Scheduled and Implemented delta mechanism for Periodic loads.
• Involved during realization, final preparation phase and hyper care support.
• Implemented SD, MM, PP, SRM Modules.
• Preparation of Technical specification documents from functional documents.
• Created and customized of Extract Structure,, Data Source, Info Objects, Transformation, DSO, Info cube, Multi Provider, Info sets.
• Performance tuning for Info cube designer, data loading and Queries execution times.
• Extensively worked on New Authorization Concept in BI-7, Created Authorization objects, User Specific Roles.
• Created processes for Data Mining with Analysis Process Designer.
• Worked on development and modification of BW BEx reports.
• Having hands on Experience on Web Application Designer.
• Worked on development of Reports in BI/BO 4.0 using BO launch pad.
• Created POC for IS-Utility modules on Native HANA.

SAP BW BO Lead Consultant

Environment: SAP BW 7.0.

Responsibilities:

• Installed Business Content Cubes, designed and developed DSO, Cubes, Multiproviders and Info sets to meet business needs.
• Configured Data sources in R/3 by using LO Cockpit initialized the setup tables. Scheduled and Implemented delta mechanism for Periodic loads.
• Resolved support issues and maintenance activities like Data loading, Job Monitoring, Scheduling the jobs, designing and use of the process chains Write logic to bring Master data in Transactional data using transformation routine.
• Performance tuning for Info cube designer, data loading and Queries design.
• Query performance tuning using RSRT.
• Worked on creation and processing of data through APD and Open hub.
• Created MultiProviders, based on Info cubes, ODS Objects.
• Enhancement on Transactional data sources and Master data sources.
• Customer Exit Variables as per reporting requirement.
• Creating the Business objects WEBI reports based on BEx Query.

SAP BW Senior Consultant

Environment: SAP BI 3.5 Implementation and Support

Project Responsibilities:

• Activated standard Business Content as per business requirements for IS-Utilities Module.
• Creation and customization of SAP BW components including Extract Structure, Data Source, Info Objects, Transformation, DSO, Info Providers.
• As per business requirement created Generic Data source’s in ISU - DM, Billing, and FI-CA module and based on that created DSO’s as per business Logics.
• Created Master and Transactional Process Chains for Daily/Weekly/Monthly data loads and scheduled accordingly to upload the data into info providers with appropriate dependencies.
• Worked on Mass upload of ISU-Sales data process.
• Creating Web templates based on report requirement, assigning queries to template and Generate PDF as well as Excel Format.
• Worked on creation and processing of data through APD and Open hub.
• Done master data enhancement adding fields based on reporting requirement.
• Created processes for Data Mining with Analysis Process Designer.
• Performance tuning for Info cube designer, data loading and Queries design.
• Extensively worked on authorization concepts in BW 3.5.

SAP BW Consultant

Environment: SAP R/3 4.7 BW 3.5.

Responsibilities:

• Implemented CS, DM, FI-CA and Billing Modules for IS-Utilities.
• Modified standard Content & created custom info sources, data sources, communication structures, transfer rules & update rules for info cubes & ODS.
• Developed Generic Extractor using Tables and Views and extracted data as per the business requirement.
• Resolved support issues and maintenance activities like Data loading, Job Monitoring, Scheduling the jobs, designing and use of the process chains.
• Worked Extensively on Query Designer using Conditions, Exception highlighting, restricted key figures, Variables, Filters, Free Characteristics, Structures, and Cell Restrictions.
• Worked on creation and processing of data through APD and Open hub.
• Created Master and Transactional Process Chains for Daily/Weekly/Monthly data loads and scheduled accordingly to upload the data into info providers with appropriate dependencies.
• Created Authorization in 3.5with roles and assigned the same to appropriate users.
• Monitor periodic data loads from SAP R/3 to BW.
• Created processes for Data Mining with Analysis Process Designer.

SAP BW Consultant

Environment: SAP R/3 4.7, BW 3.5 .

Responsibilities:

• Worked extensively on BEx Designer and BEx Analyzer for queries creation, modifications and Execution.
• Preparation of test plans, test cases and execution &reporting..
• Monitoring periodic data loads and error rectification from SAP R/3 to BW.
• Preparation of Technical specification Documents
• Manual Scheduling of Daily/Weekly/Monthly data loads and Process chains.