SUMMARY

• SAP BW/HANA Certified Consultant with overall 18 years of strong background in SAP Analytics. Skilled at SAP applications SAP BW/BOBJ 4.2/BPC/SAP HANA along with SAP HANA Replication technologies like SAP SLT and SAP Data Services.
• SAP Experience is scattered over various industries like; Manufacturing, Material Science, Oil Industry, and IT industry.
• Strong experience on multi system landscape architecture and integration aspects between heterogeneous system technologies in the areas of Implementation, Modelling, security, Data Provisioning, SAP BW/HANA and HANA modelling, BPC Modelling and Administration and BOBJ reporting.
• Experienced in best practice to design efficient data models with SAP LSA/LSA++ Architecture and to improve optimal performance of SAP Analytics systems.
• Experience in various SAP modules like SD, FICO, Inventory, Supply Chain, Plant Maintenance, Material Management, Production Planning, IS - OIL, IS-Retail - including, Blueprint, functional specifications, data flow designs, data modelling, extraction, testing and end user training.
• Experience on BW/BO/HANA & BPC 10.1 Migration/Upgrade project activities.

TECHNICAL SKILLS

• SAP BW /HANA Data Modelling/Reporting
• SAP BOBJ 4.2 Development/Migration/Administration
• SAP BW ABAP/HANA experience
• SAP BW4/HANA Modelling Knowledge
• S/4HANA Logistics and Embedded Analytics experience
• Knowledge in SAP Analytics Cloud (SAC)
• Extracting data from S4/HANA and CDS View
• Knowledge in creating CDS Views
• SAP BI WEBI/IDT/UDT/Design Studio/Lumira/Analysis office experience
• SAP BPC 10.1 Modelling, Development of Reports, Administration
• NetWeaver Enterprise Portal Administration
• Microsoft SharePoint Technology Administration

PROFESSIONAL EXPERIENCE

SAP BW/BO/HANA/BPC Lead

Confidential

Responsibilities:

• Managed BW/BI/BPC system development and data warehouse architecture and assured a successful integration of all components within the BI solution as well as interfaces.
• Managed and guided a 10 member BW/BI team onsite and offshore in solving technical issues and provided technical guidance and worked as a key SME person in successfully coordinating and managing offshore-onshore model.
• Responsible for Architecture Design, Development, production support, mentoring and guiding the team on all technical issues and interacted with offshore team on a day to day basis.
• Worked on estimation and proposal for implementation projects. Worked on various initiatives like Recruitment, and White Paper Reviews, as a part of Business Analytics group.
• Gather requirements from process teams/business owners; translate business needs into data modeling and reporting solutions.
• Coordinate and work with both the functional process data reporting team and the technology team to review and set up best practices in design and development.
• Established naming conventions, standards, development guidelines and best practices in implementing Business Warehouse.
• Involved in Requirement gathering, Gap analysis, design, development, testing, documentation, maintenance, troubleshooting and performance tuning.
• Involved in working with functional team members of various SAP modules like SD, FICO, Inventory, Supply Chain, Plant Maintenance, Material Management and Production Planning.
• Involved in developing Blueprint, functional specifications, data flow designs, data modelling, extraction, testing and end user training.
• Excellent knowledge in SAP BPC Modeling, Reporting and Administration
• Involved in requirement collection from various departments to find out the important reports Info Providers, SAP Queries to convert to HANA and Analysis office.
• Hands on experience in BW/HANA modeling, experience in creating Attribute views, Analytical view and Calculated views and applying privileges.
• Transform data as per business requirements and loaded the data into SAP HANA database using SAP Business Objects Data Services (BODS) and SAP Landscape Transformation (SLT).
• Experience in latest S/4HANA Embedded Analytics, consuming CDS Views and creating Analysis Office, Webi Reports and Dashboards.
• Experience in latest BW technology SAP BW/4HANA in modelling and reporting and familiar with latest technology like Fiori
• Experienced in loading data from tables in HANA database to BW data marts and knowledge in BODS data extraction and modelling
• Involved in setting up procedure to extract R/3 data for PM and QM using LO, Generic Extraction and customizing to the requirement using Business Content.
• Installed and enhanced standard business content DataSources for various SAP Modules and extracted the data from ECC system.
• Enhanced and Developed Custom extractors using function modules and replicated to BW system and involved in the performance tuning of Custom Extractors.
• Developed Business Objects reports (BI-BO integration, Universe, Webi, Live Office, Crystal reports)
• Extensively used Information design tool (IDT), to create universes using multiple Data Sources. Created connections to BEx queries and BW Info providers using Business Intelligence Consumer Services (BICS) in IDT.
• Created OLAP connections in BOBJ environment to establish the connection with ECC and BW systems to retrieve data to expose in reports.
• Created various BEx Reports, Webi Reports, Live Office presentation, Xcelsius Dashboard and Crystal Reports for various Departments like Sales, Finance, OEM, Supply Chain, and Accounting Depts.
• Developed Scorecards using BOBJ Web Intelligence and provided to the top management.
• Developed various Dashboards using Design Studio and Lumira Designer.
• Extensively worked on BO Mobile report creation and security setup for BO Mobile Platform.
• Involved in creation of Transactional ODS for extracting the data through Advance Process Design (APD) technology for the data analysis purpose for Finance team.
• Created complex BEx Queries using Structure, Calculated Key Figures, Restricted Key Figures and Web Templates.
• Involved in Analysis Authorization and creation of transport using Solution Manager and transporting Requests of various Objects of the BW system from Development, Quality and to Production environment.
• Involved in Administration of Enterprise Portal and Share point Intranet sites.
• Created Process Chains for the info packages scheduled on daily and Weekly basis and dealt with PC Failures.
• Interacted with SAP and Basis Team to fix implementation/issues related with BW/HANA/BO/BPC systems.

SAP BW/BO and HANA Native Modelling and Development

Confidential

Responsibilities:

• Experienced on BW/HANA Eclipse Modelling Tool features.
• Considered LSA++ Methodology, Using ADSO, Composite Providers and exposing BW objects in HANA Views, etc.
• Experienced on SAP Operational Data Provisioning (ODP) extractor mechanism.
• Experienced in SAP HANA information models and Hana Views (Attribute, Analytics and Calculation views), SDA (Smart Data Access), SAP HANA Live (Analytics).
• Created restricted Columns, Calculated Columns and User filters expressions.
• Created HANA modelling scenarios - columns Table/row, SQL Script Procedures, Attribute Views, Analytical Views using Calculation views.
• Experience in Performance tuning activities related to SAP BW/HANA.
• Used different types of Joins Inner/left outer/Right outer /Full outer /Referential/Test joins.
• Utilized Variables/Input parameters to filter the data based on user’s dynamic selections.
• Extensively developed various BW InfoProviders and Reports and published in Enterprise Portal.
• Created BO Reports, Scorecards and Dashboards using various BO tools and published to the users.
• Managed and administrated BO system and users on a day to day basis.

SAP BW/BO/HANA/BPC Migration & upgrade

Confidential

Responsibilities:

• Accountable for SAP BW/HANA/BO/BPC migration project preparations, participated in SAP workshop and involved in project plan preparations.
• Prerequisites Migration considerations like; to migrate old reporting authorizations to 7.x, all 3.x BEx components and Web templates must be migrated, no longer supported.
• BW Clean-up prior to BW/HANA migration activities like; removing staging areas, summary tables, log files, temporary storage locations for data and that is moved to higher-level models.
• Implemented SAP recommended HANA notes in order to generate BW/HANA housekeeping cockpit.
• Post-migration tasks like; enabling HANA server Functions, complete rebuilt BW system indexes table Inconsistency checks, Activate Inactive objects DSOs, IC, MPs, ISs, IOs etc…,
• BPC Post-upgradation activities activate deactivate planning models, Data manager data loads, input templates checks, Web client consistency checks.
• Associated with Designs and configuring servers on SAP BOBJ 4.2 including; CMS Repository, Monitoring database, Auditing data base, processing servers, web servers etc.
• Involved in configuring Single Sign On (SSO) with windows Active directory.
• Involved in configuring LDAP Authentication and mapping LDAP against Windows AD.
• Experience with SAP BW/BI4.2 Security mappings including User Management, Roles, and Privileges.
• Experience with various SAP BI4.2 tools, development lifecycle on either BW or SAP (Native) HANA from design through implementation and production support.
• Deployment experience- Webi, Design Studio and Lumira using Relational connections, OLAP, and BICS experience. User setup for BO/BW /BPC and configuration of connections in EPM tool.
• Generated most of the Financial reports using Webi like; Daily/Weekly revenue, Daily Sales Trend outstanding report.

Confidential

Senior BW Consultant

Responsibilities:

• Involved in report design workshops with business users by building reporting mock-ups, prototypes and workshop output forms.
• Technical feasibility analysis of requirements, Data Modelling, Design & deployment of BI - reporting solutions. Technical Architecture of BEx and Web Reporting Layer.
• Developed DSO for various layers like DWH Layer, Staging layer, Reporting Layer for Point of Sales. Involved in creation of InfoCubes for Merchandise Procurement, Open Contract, Stock & Store Article and Multiprovider for Daily, Weekly and mark down queries.
• Created Open Hubs to extract data for Header, Detail and Tender values from various DSO’s and stored these values in CSV files and provided for CRM team.
• BI transports, BI cutover and inactive deal conversion
• Reviewed of process documentation on various phases of project like high level design, detailed design, realization, integration testing, user acceptance testing and go-live & support.