SAP BW & HANA
Resume:
Mobile: +1-682-***-**** Email: ***********@*****.***
Executive Summary:
SAP NetWeaver 04s - Business Intelligence consultant having overall 8+ years of experience in SAP Business warehouse configuration and delivery environment like HANA, BW3.x, 7.0, BW 7.3 on HANA & SAP BW 7.4 with BOBI4.0 & SAP BW 7.5 on HANA Migration in Business areas like SD, MM, FI and CRM, APO, SRM.
SAP BW on HANA certified from OpenSAP.
Currently working on SAP BW on HANA 7.3 implementation project.
Worked on SAP BW on HANA & HANA as a developer.
Strong ability to understand the business.
Training Attended SAP HANA & BW on HANA.
Having the savvy knowledge and understanding of Datawarehouse, ETL principals and practice.
Design and maintained data target/Info provider like Info objects, Basic Infocube, DSO and Multiprovider.
Working on IM Cube & IM DSO also created virtual provider on analytical view. Created composite & transit provider.
Experience in data loading and Monitoring process using Process Chains.
Created Process chains for Master Data and Transactional Data for Both Info packages and DTP & Worked on Transformation and DTP.
Installed Business Content and Customized to meet the user needs.
Worked on Data Extraction, Data Loading (Full/ Delta Customizing) and Data Staging Using, LO data Extraction mechanics.
Hands on experience and technical proficiency in Business content Data Extraction likes LO cockpit, FI-AP and also worked with Generic Extraction datasouces.
Used DSO to stage the data before transferring to the contents of the Info cube.
Extracted Data from the OLTP using the PSA staging Scenario.
Expertise in Scheduling and Monitoring of data flow to Info cubes, DSO objects.
Worked on Report Designing in order to format the reports as per the requirements.
Designed BEx Reports providing insight of Business Intelligence for Business Analyst for Decision making using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure and Used Variables.
Involved in managing of Info cube, which involves Info cube content, performance issues like compression of Info cube and rolling up the data to the aggregates.
Involved in Implementation, Development and Production supporting system.
Worked with business in gathering report requirements and building/maintaining work plans.
Excellent business analysis, trouble shooting, presentation, Interpersonal skills & Strong Leadership qualities.
Excellent oral and written communication and training skills.
Academic Qualification:
Master Of Computer Management
Training Attended:
SAP:
Data WareHouse : BW 7.3, BI 7.0, BW 3.5
ETL Tools : SAP BO Data Services 4.0 (Designer, Data Services Repository Manager, Data Services Server Manager, Management Console), SAP BO Data Integrator
In-Memory Tools : SAP HANA
Reporting: Business objects –Webi, MS Office.
SAP BW Performance Optimization
Oracle 8,9i, SQL.
Core Java, .NET, VB 6.0, D.S, C and C++.
Training Conducted
SAP BW on HANA
SAP HANA: including introduction, architecture, modeling, data provisioning, authorization & reporting.
SAP BW 3.5 including modeling and reporting
SAP 7.3 delta – Upgrade from SAP BW 3.5 to BW7.3
End users workshops
CAREER HIGHLIGHTS
SAP BI-HANA Skill set:
Implementation and Enhancement: Worked on end-to-end implementation.
BI Operations: Hands-on experience in areas of Data Loading (Full/Delta), Scheduling, Monitoring, working with Master Data, Transaction Data and Hierarchies.
Modeling: Experienced with creation and maintenance of Data Source, InfoPackage, InfoObjects, DSO’s, InfoCubes, DTP’s and MultiProviders according to the reporting requirements.
Extraction: Data extraction from R/3 systems as well as non R/3 systems such as Flat Files.
Business Content: Involved in evaluating Business Content and activating appropriate Business Contents for the business solution, as per client requirement.
BEx Reporting: BEx Analyzer and Query Designer, Restricted and Calculated Key Figures, Variables, Formulas, Structures, Conditions, Exceptions, and filtering of data.
Process Chain: Involved in developing new Process Chains and sound experience in scheduling, monitoring and handling issues of Process Chains.
SAP HANA Architect with experience in information modeler with development of various HANA models via Attribute/Analytic and Calculation views.
Strong knowledge and experience of SAP ERP Extraction in the areas of Finance, Supply Chain, SD/MM/PP -Logistics, and HR. Created universes, classes and objects by retrieving the data from various data sources and defining the necessary connections.
KEY PROJECTS HANDLED
Project details in Accenture
Project Name : BWoH Migration
Client : Pfizer
Duration : Aug 2016 – Present
Role : SAP BW & HANA Migration Lead.
Environnent : SAP BW7.5, SAP HANA, SAP BOBI, SAP BODS, SAP ECC, SRM,APO
Responsibilities for Novartis:
Currently leading BWoH migration project from BW 7.3 to 7.5.
Involved in business and Architecture discussions & studied of Business and technical flow of current objects to understand the Technical & Functional Migration.
Leading a team of more than 15 for the current project from onshore.
Worked closely with SAP Technical team on implementing the migration project on HANA.
Project details in Accenture
Project Name : IRIS.
Client : Novartis
Duration : Oct 2015 – July 2016
Role : Sr. SAP BW & HANA Development.
Environnent : SAP BW7.4, SAP HANA, SAP BOBI, SAP BODS, SAP ECC, SRM.
Responsibilities for Novartis:
Worked as an Application module Lead, involved in Change Management, effort estimations, development status tracking, status reporting to client and handle SAP team.
Leading a team of more than 8 for the project from onshore.
Worked on SAP BW on HANA, BOBI, BODS.
Worked with several users, and interacted with them to gather requirements.
Prepared a presentation of new functionality in BI for the client point of view.
OLTP extractions from SAP R/3 using LO Cockpit for SD, Purchase, Inventory, production planning.
Understanding the business process and applying them in Modeling of BW system.
Involved in development, design, UAT and after Go-live phases of projects.
Created Composite providers on BW Modeling tool (Eclipse base).
Also Worked on IM Cube & IM DSO also created virtual provider.
Worked closely with WEBI Reporting/BOA-OLAP/CR on the requirements.
Develop and drive implementation of BW best practices and standards for the team.
Plan, prioritize, and execute BW/BI development across the team.
Leading and managing cutover activities during implementation Go-live.
Project details in Accenture
Project Name : AADAMS.
Client : IDB.
Duration : Jan 2015 – Sep 2015
Role : Sr. SAP BW & HANA Consultant.
Environnent : SAP SRM, AP, AR, GL, FM, GM, SAP BW, SAP HANA, SAP BOBI 4.0.
Responsibilities for IDB:
Worked on SAP SRM, FI modules (AP, AR, GL, Fund Management, Grant management etc….) implementation with leading SAP BW on HANA & BO team.
Identify the business requirements with the help of existing documents and business process needs.
Lead a team of more than 7 for the project.
Basing on the requirements, determine which pre-delivered FI, SRM & COPA functional areas to be included.
Working on modeling and developed Analytical views for the transactional data, Attribute views for the master data, Analytical views & calculation views as final model in HANA Studio.
Working on IM Cube & IM DSO also created virtual provider on analytical view.
Technical Requirements Planning like frequency of data uploads events to be triggered (Process chains).
Identify the end user requirements (BEx, WEBI, Crystal Report 2013
Set up of the Development environment.
Business Content Check: Finalize a list of pre delivered business content to be activated by functional components, data sources, info cubes, objects, queries.
System Administration procedures like data access issues, definition of roles, responsibilities and tasks for each procedure.
Agree upon the instrument (template) to record the test result and additional requirements.
Develop evaluation criteria and test plan.
Testing of BW operating environment (Plug-ins, BW backend and BW front-end).
Populate SAP delivered business contents with customer data Verify the content activation Result.
Project details in Accenture
Project Name : Singapore WDA.
Client : Workforce Development Agency.
Duration : Feb 2014 – Dec 2014
Role : Sr. SAP BW Consultant.
Environnent : SAP CRM, SAP BW 7.4, SAP HANA, SAP BOBI 4.0, SAP BODS
Responsibilities for WDA:
Worked on SAP CRM implementation with Leading SAP BW on HANA & BO team
Worked with several users, and interacted with them to gather requirements.
Installed and configured SAP CRM extractor, Report, IM Cube, IMDSO & IO.
Writing and editing of SAP BEx queries using Query Designer.
Responsible for developing test cases, business validation rules for verification and validation of data quality.
Worked on transports of BW queries, objects from Development, Test and Production Environments.
Developed reports from SAP Info cube by using BEx query designer, applied filters, variables, and parameters/prompts.
Developed Webi reports, extensively used Variables, Drill down, Breaks, input controls.
Created simple reports including dynamic calculations involving Queries, List of Values (LOVS), local variables and multiple data.
Worked with business users for defining reporting needs, help design flexible queries, pre calculated reports using BEX reporting features like variables, conditions, exceptions
Creation and maintenance of OLAP universes source from BEx queries.
Worked on BW-BEx & BO-Webi performance issue.
Project details in Accenture
Project Name : BSCI.
Client : Boston Scientific
Duration : Oct 2012- Feb 2014
Role : SAP BW on HANA Lead consultant
Environnent : SAP ECC 6.0, BW on HANA, SAP BOBI 4.0, SAP BODS.
Responsibilities for BSCI:
Having experience on Actual Analytic view & Plan Analytic view & attribute views in CO-PA on SAP HANA (IMCE). Created Attribute view, Analytical view & calculation view for SD & MM modules and provide development for further BO reporting.
Working as a core team member as SME and handling the SAP BW on HANA & HANA as a developer.
Found BW basic designing bug, Appreciated by Client.
Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, Analytical views & calculation views as final model in HANA Studio.
Migrated HANA content from development, testing environment to Production environment using delivery units.
Developed data models for the Finance, SD/MM/PP -Logistics, and HR tables in HANA.
Executed Data Extraction Transfer Loading (ETL) using SAP Data Services 4.0 to import csv files into SAP HANA tables to reflect exchange live rates application.
Performed currency conversion in Analytical view in SAP HANA
Handled many SCRs, SMRs, UA tickets and met SLA.
Prepared the Cutover Activities documentation for Go Live.
Migrate CUBE & DSO in in-memory database.
Migrate inventory cube 0IC_C03 in in-memory database.
Monitoring data loads which will be scheduled for hourly, daily and weekly,
Load monitoring using RSPC, RSMO.
Project details in IBM
Project Name : CRAS (GREMIS and SDM).
Client : UBS
Duration : Feb 2011- Sep 2012
Role : SAP BW consultant
Environnent : SAP ERP system BI, FI, SRM, R/3 etc.
Responsibilities for SDM:
Worked as an Application module Lead, involved in Change Management, effort estimations, development status tracking, status reporting to client and handle SAP BI team members.
Study of Business and technical flow of objects to understand the requirement.
BI Objects Development/maintained- InfoObjects, DSO’s, Infocube, Transformation, DTP’s, Start/End routines and Process chains.
Activated Business Content Objects as per the client’s requirement.
Created/Maintained BEx Reports.
Change Management and effort estimations.
Performed Data Load Tuning by analyzing and adjusting, Indexes, Data Packet Sizing, Aggregates etc.
Involved in client interactions like con-calls, developing MOM’s and quality related activities of the project.
Involved in Knowledge sharing sessions with the team members.
Responsibilities: GREMIS
Gathering the client requirements for develop new data flow like Profit and Loss, Fixed Asset, Leases, Head Count, Projects, Forecast, Internal Orders and then create new reports and create new technical specification.
Enhance the DSO, Cube, InfoObject, Process chain and APD.
Create GREMIS new Model (MIS) with new DSO (Write Optimize, Direct Update), Cube with derivation of transformation (Start routine and End routine) based on certain criteria. Also loading the data for the new Model.
Created Process chains which include Local Chains.
Create Forecasting, Costcenter, Project, Subproject MIS reports.
Designed BEx Reports providing insight of Business Intelligence for Business Analyst for Decision making using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure and Used Variables.
Project details in Mangna Info
Project Name : Sabre.
Client : Saint-Gobain.
Duration : Nov 2010-Feb 2011.
Role : SAP BI Consultant.
Environnent : SAP ERP system BI, MM, SD, PP, CRM, R/3 etc.
Responsibilities:
Involved in Development as well as Production Support Project where the main task is to monitor the data loads, data source enhancements, check the tickets and resolve them.
Involved in the creation of different info objects, ODS, Cubes and MultiProvider.
Monitoring data loads which will be scheduled for Daily, Weekly and Monthly, if any error comes while loading data into BW from different source systems resolving those issues and handle the Broadcasting issues.
Transport the Query Element and Object from Dev à Qty à Pro.
Monitor the Info spoke when they failed repeat Delta and Full as a different way.
Involve in the development of new requirements.
Project details in Isun Solutions:
Project Name : Implementation and Support
Client : Provogue.
Duration : Dec 2009-Nov 2010.
Role : Sr. SAP BI Développer
Environnent : SAP ERP system BI, MM, SD, FI, ECC 6.0 etc.
Responsibilities:
Involved in Development as well as Production Support Project where the main task is to monitor the data loads, data source enhancements, check the tickets and resolve them.
Gathering the requirements. Analyzing the same with the existing SAP BI Content and create the new Report Reports on SD and MM as per client requirements.
Create Formulas, Selections, Structures, Calculated Key Figure, and Restricted Key Figure, Virtual key Figure and Used Variables and Use Offset.
Involved in the creation of different info objects, ODS, Cubes and Multiprovider.
Extracted data Into Info Cube, DSO, LO-Cockpit data sources from SAP using process chains.
Involve in the development of new requirements.
Monitoring of Info packages and analyzing the reasons for frequent failures of Info packages.
Monitoring data loads which will be scheduled for hourly, daily and weekly, if any error comes while loading data into BW from different source systems resolving those issues informing to the users.
Updated Data through PSA for Info Cube, ODS using Delta, Full update.
Involved in Load monitoring using RSPC, RSMO.
Maintaining reconciliation’s to verify the data in SAP R/3 and SAP BI are same of not after the data loads.
Monitoring the Roll UP’s and Compressions while loading the data in the Infocube.
Create the Info Cube as per Client requirements in Development System and then Transport the Cube in Production System.
Experience in carried out LO extraction involving creating data source, activating the business content, replicating data source, and mapping, creating an Info Cube, initializing Delta Method and finally creating an Info Package to extract transaction data regularly.
Installed Business Content Sales Overview Cube and designed and activated Customer service to meet user needs.
Worked on sales order Data sources and billing Data source to extract the data for the key figures like Sales Order Quantity, Gross Sales Quantity, Net Sales quantity, Net Shipment Quantity.
Extracted data from SAP R/3 using Business Content Extractors and also from Flat files.
Managed Data Loading using both Full Update and Delta Update.
Project details in Isun Solutions:
Project Name : BW Provogue
Client : Provogue
Duration : May 2008 – Nov 2009
Role : SAP BI Développer
Environment : SAP BW 3.5, R/3 4.5 BI 7.0, ECC 6.0
Responsibilities:
Upgrade Preparation Pre Checks. Check consistency of DDIC objects of Info cubes, Info Objects and transfer structures, update rules.
Technical Upgrade Post Activities (Replicate Data Sources), doing all the technically related checks.
Technical Upgrade Preparations in PREPARE and UPGRADE phases.
Reactivating the SAP BI System after Upgrading, Running RSD1 to check Info Objects also running the programs to check the transfer rules, ODS, Update rules.
Worked on BI 7.0 front-end upgrade, specifically migration of queries, workbooks, Web Objects and web reports.
Monitoring of Info packages and analyzing the reasons for frequent failures of Info packages.
Monitoring data loads.
SAP BI report to display details of employee like employee number,
Employee name, address, salary and tax etc.
Created Transport Request for the Developed Objects.
Managed Data Loading using both Full Update and Delta Update
Contact this candidate