SUMMARY

• SAP BW HANA consultant around 10 years of experience in SAP BW, BW on HANA, Integrated Planning, BPC, BO and ABAP.
• Experience in SAP HANA Modeling for an implementation project as a HANA consultant.
• Experience in 4 full life cycle end to end implementation and 2 upgrade and many support projects.
• Experience as techno functional consultant for different modules like FI, SD, COPA and MM.
• Proficient in carrying out requirement analysis, multi - dimensional data modeling, developing and testing both back-end and reporting objects.
• Good skill in liaising with end users/clients/business for the business requirements.
• Good team handling skills involving Onsite/Offshore model.
• Excellent communication, team handling and inter personal skills.

TECHNICAL SKILLS

• Excellent conceptual/in depth knowledge in various aspects of HANA including modeling, transport, data provisioning, development standards, best practices and BOBJ reporting on HANA information views.
• Experience in HANA Modeling studio creating attribute, analytic and calculation views for BOBJ reporting. Performance tuning of the existing information views for better run time in BOBJ. Involved/coordinated the transport of views to the landscape.
• Experience in analyzing the performance of information views using plan visualizer.
• Specialization in configuration and setup of SAP business content and SAP BW extractors utilization, System Analysis, Requirement Analysis, Validation, Technical Solution Design, Development, Testing and Quality Control with a focus on better performance and easy maintenance of the system.
• Strong planner and organizer with demonstrated ability to master new concepts quickly, incorporate the latest technology, and develop business solutions that increase efficiency and productivity
• Creating/Enhancing the Functional and Technical design document.
• Involved in development, implementation and maintenance of business intelligence solutions.
• Involved in End User Training & Support.
• Experience in various stages of SAP BI 7.0, 7.3, 7.4 and 7.5 including Data Modeling, Extraction and Reporting.
• Experience in the performance optimization in the data loading, reporting aspects of BW using BI Accelerator, customization and enhancements.
• Performance tuning of BO reports using BICS connection.
• Strong association with the architecture team and participated in the discussions regarding planning and implementation of the overall BW landscape and architecture.
• Competent skills in SAP BW Data Modeling of Composite Providers, Open ODS view, Advanced DSO’s, BW workspace, InfoCubes, DSOs, InfoObjects, Multi Providers, Infosets, APDs and Open Hub Services.
• Excellent skills to work on Business warehouse extractors such as LO-Cockpit, Generic Extractors, Standard Extractors and Generic Delta Extractors.
• Good experience with Flat File Extraction, Generic Data Sources, BI Content Data Sources, Full and Delta Extraction Management.
• Excellent skills to develop all kinds of ABAP Routines (Start/End) during Transformations/update rules. Designed Custom extractors using User-exits, routines and Function Modules. Worked on all kinds of BI-ABAP requirements.
• Experience with Front-end Business Warehouse Components, which involved constructing custom queries for the business based on the requirements.
• Excellent skills to solve Data loading issues and Developed Detailed Cutover plans. Managed huge cutover activities and solved issues during the process.
• Good experience in SAP BI Integrated Planning and the different modeling scenarios using aggregation levels.
• Experience in SAP BO tools like Web Intelligence, Business Objects Analysis for Office, Lumira and Design Studio.
• Experience on SAP ECC with in depth knowledge in Data Dictionary, ABAP Reporting using Classical & ALV Reports, applications using dialog programming, ABAP objects, enhancement techniques including user exits, BADI’s and BAPI.
• Good understanding of SAP Retail, SD, MM, FI and POSDM.

PROFESSIONAL EXPERIENCE

Confidential

Senior SAP BW/BI/IP PAK Consultant

Environment:SAP BW 7.5 on HANA, BOBJ & IP

Responsibilities:

• Upgrade to SAP BW 7.5 from 7.3.
• Planned and executed in all aspects of the upgrade from the initial cost and effort estimation to testing and Go Live.
• Involved and executed the following phases of the project like System and Resource availability and planning, verify all SAP prerequisite notes, landscape validation, pre-upgrade tasks, technical upgrade tasks and post upgrade validation.
• Complete re-designing of the existing landscape using composite providers and Advanced DSO’s. Converted existing cubes and infoproviders into adso’s and used them in composite providers.
• Extensive usage of BWMT eclipse for the creation of reports and data models.
• BW to non-SAP data transfer using BODS.
• Implemented the BW workspace in 7.5 the Planning modeling for updating to the BW system.
• Implementing planning and forecast IP PAK. Using manual planning and planning functions with fox formulas. The planning reports are delivered using Design Studio and Analysis for Office tool.
• Supporting users and their requirements in functional areas like Order to Cash, Procurement, Inventory and Production planning.
• Complex modeling and data modeling design using advanced DSO’s to track all changes to Sale orders from CDHDR and CDPOS table using custom extractors. Consumed the same data using Design Studio dashboard development.

SAP BW/BO/HANA Architect

Environment:SAP BW 7.4 on HANA, BO Analysis for Office & ECC 6.0, HANA CAR

Responsibilities:

• Initial system study for BW 7.4 on HANA upgrade and its corresponding development using Composite providers and Advanced DSO.
• Mapping all the POSDM components to the HANA CAR POSDT system and generating report on top of new POSDM information views.
• HANA modeling using the BW POSDM content in the CAR HANA system and consuming the same in Lumira and BOBJ Analysis for Office.
• Data Provisioning in SAP HANA using SLT.
• Ensuring the HANA information views are based on the best practices with respect to modeling views, using joins and filters.
• Involved in the data archiving process in BW for better performance.
• Extensive performance optimization researches and suggestions for the BW system on SQL server.
• Liaising with users/business to find out the scope for the enhancement of the report.
• Handled the inventory scenarios for the business involving stock in transit for reporting purpose.
• Designing/creation of workbook, worked closely with the security team to restrict/assign access to users different regions based on the authorization.
• Modeled the moving average cost works from the extractor perspective so that it aligns with the business/reporting need.
• Re-designed the complete process of modeling side for a Purchasing report which involves change in the back end for capturing the deletion indicator.
• Worked along with Basis for the pre upgrade activities for a patch upgrade in 7.3
• Created aggregates in the system for cubes with long running queries as part of performance optimization.

SAP HANA BW BO BPC

Environment:SAP HANA SP 09, BW 7.4, BOBJ 4.0, Microsoft BI & ECC 6.0

Responsibilities:

• Extensive involvement in the phases of the project including involvement in BOBJ report creation with HANA views.
• Extensive HANA modeling with attribute, analytic and calculation views for data from different source systems including ECC, BW and legacy systems.
• BW backend data modeling using Advanced DSO’s and Composite Providers.
• Extensive experience in building Universes and retrieving data using Universes.
• Identified the bottlenecks for performance using plan visualizer and did performance tuning on the views for better run time for the BOBJ reports.
• Developed reports in Webi using information views containing data from legacy systems and AFS module.
• Worked with Security on the Analytical privileges and proposed best practices.
• Involved/ coordinated with Basis on the transport of the views across landscapes.
• Worked in the BPC EPM Add In for forecasting and budgeting reports.

SAP BW Lead / QA Delivery Manager

Environment:SAP BW 7.3 & ECC 6.0

Responsibilities:

• Involved in cutover activities, initial loading of the data and other critical process for the BW implementation phase of Go Live.
• Created a report in BW to show the financial movements based on a store and a day. It shows the Cash Receipt vouchers, Cash Payment Vouchers, Gross sales, Layaway deposits etc. It involved creating cubes and Multiprovider in the backend to achieve the same
• Custom datasource/DSO creation for the extraction of certificate, environment and disposal fees from ECC which involves end routines in BW to combine header and item data.
• Created Financial Statement report for profit centers comparing current year to date and previous year to date values.
• Created many custom reports in FI, MM and SD using selection, formulas, RKF, CKF and cell structures.
• Implemented many Business content reports aligned with the requirements from the business with the use of RRI.
• Created an APD application to send data from a BW Multiprovider as a text file to a folder in the application layer. It involved ABAP routine and formula.
• Created Generic Datasources using Table/View option for a custom table using the timestamp field and loaded the same into a standard DSO.
• Created a custom query for the APD process to pull data from the cube and used the query as source in APD.
• Created write optimized DSO’s, standard DSO’s, end routine and process chains. It was done to extract the Adjustment and Forecast fee to BW from ECC.
• Enhanced the standard Datasource for sending data from POSDM to BW using BADI.
• Created extractor and did the modeling in BW for bringing the pricing information to BW.

SAP BI IP/BO Project Manager

Environment:SAP BI 7.0 & ECC 6.0 & BO

Responsibilities:

• Liaising with the end users on a daily basis regarding the functionality of the reports and collecting further requirements.
• Created complex webi reports with multiple queries, custom sql, using complex fuctions, merging dimensions at report level, drill down, drill up, drill across, complex filters etc
• Created a broadcasting setting to send the report output as mail and worked with the Basis team regarding the configuration settings in scot.
• Monitoring of the Transactional and Master Process chains on daily, weekly and monthly basis
• Created Text variables to dynamically show the header of the columns in the report.
• Updated the planning queries with the totals and subtotals based on the customer requirement.
• Modified non input ready queries to input ready queries based on the end user requirement.
• Migrated the queries to WebI as per the business requirement. That involved all the queries which are not input ready queries.

SAP BW BO IP Lead

Environment:SAP BI 7.0, BOBJ 4.X & ECC 6.0

Responsibilities:

• Involved in the end to end phase of the projects including Requirement gathering, Blueprint discussion, Realization, Testing and Go Live phase.
• Designed the layout of the project based on the requirements collected from the customer.
• Installed standard cubes and its related objects from business content and loaded the master data and transaction data.
• Developed custom DSO’s, InfoCubes and MultiProvider for BI and IP reports.
• Loaded the setup tables for SD and MM related DataSources and extracted data to BW.
• Worked extensively with Inventory cube 0IC C03 with marker and no marker update compression.
• Performance monitoring and tuning of BO reports during application testing and production operations.
• The most challenging was the material replacement scenario which involved extensive ABAP work and BI.
• Loaded the historical and current data into Inventory cube by setting up marker and no marker update
• Created Unit of Measure conversion in BI to convert the UoM from Cases to Sticks in a particular report using the reference InfoObject 0material.
• Created Process Chains for Transaction Data and Master Data load including SD, MM and many InfoObjects.
• Created background event in BW and used it to trigger the Process chain which loads data to a DSO from a table which gets loaded from a flat file. ABAP program was written to upload data to table which in turn trigger the event to execute the process chain to load to the DSO.
• Developed formula type planning functions to derive the results based on the complicated requirements from the customer.
• Implemented user exits in BI to calculate version of the forecast dynamically in the planning reports.
• Created input ready queries in BEx Query designer based on the aggregation level and developed workbooks in BEx Analyzer based on the reports.
• Monitored the query results using RSRT.
• Developed Aggregation Levels, Filters, Planning Functions, customer exit variables and Planning Sequences for IP reports.
• Created Yearly forecast and Rolling forecast (monthly) reports based on the requirements by the customer.
• Worked closely and extensively with the Basis team in the Transport Management System to collect, release and import objects in the Development, Quality and Production system.
• Created test cases for the reports in the BW side and performed the same for inventory and sales module.
• Involved in the end user training and all other documentation work.

SAP BI/BO/ABAP Consultant

Environment:SAP BI 7.0 & ECC 6.0

Roles & Responsibilities:

• Provided solutions to the design flaws after extensively analyzing the system.
• Designed BEx Reports providing insight of Business Intelligence for Business Analyst for Decision making using Structures, Formulas, Selections, Calculated Key Figure, Restricted Key Figure and Variables.
• Designed and developed many reports in WebI as per the business requirement in logistics area.
• Created a Report to Report Interface (RRI) for showing the sales data in region wise
• Enhancements and additional developments were done to ensure the accurate reporting requirements
• Provided proactive system monitoring to resolve critical production issues
• Extensive support with permanent solution & root-cause of analysis by meeting the Service level agreement.

SAP BI Consultant

Environment:SAP BI 7.0 , ECC 6.0

Responsibilities:

• Developed queries in BI based on the Custom CRM tables.
• Designed the ETL for BI/CRM Integration
• Validated all the variables, formulas, text variables, restricted and calculated key figures, custom exits
• Included the newly created DTPs in the Process Chain for that automatic scheduling of data loads
• Resolved the source system error with the Basis team with the help of SAP Note ‘1478123 - FAQ: Source system’ and also checked various parameters using the note.
• Created Unit test Case documents for the developed objects.
• Validation and testing of the reports based on BEx Queries.

SAP BI/BO/ABAP Consultant

Environment:SAP BI 7.0, ECC 6.0

Responsibilities:

• Developed a Generic DataSource for Master Data, Text and Transaction Data using the transaction RSO2
• Developed a Functional module based DataSource to handle delta extraction
• Developed a custom DataStore Object and InfoCube which displays sales data
• Developed a Query which displays the total sales details in year wise
• Involved in the development of pricing routines for SD.

SAP ABAP/BW Consultant

Environment:SAP ECC 6.0, BW

Responsibilities:

• Reviewed the existing data model and gathered requirements from the functional consultants regarding the new approach.
• BW support phase handling process chain monitoring.
• Enhanced couple of reports in SD using BEx Query Designer.
• Worked together with the functional consultant in creating new condition records and pricing conditions.
• Implemented BTE to retrieve field descriptions for custom fields in VK11, VK12 and VK13.
• Involved in the support project of SD module various phases of development such as reports, exits and BADI’s.
• Implemented a Function Exit for checking the material details while extending a material in MM01.
• Implemented a BADI (LE SHP TAB CUST HEAD) to add a custom tab for delivery in transaction VL01N / VL02N.
• Developed an interactive report using object oriented ALV in MSD showing the checklist of the proof of delivery of products to customers based on the date, courier agencies and customers.
• Implemented a user exit in SD module to check a duplicate purchase order.