SUMMARY

• Architect Design, Develop, and Implement SAP BW Hana systems and processes to capture, integrate and distribute information in enterprise business intelligence.
• Leverage subject matter knowledge in SAP BW (Business Warehouse) with SAP HANA (High Performance Analytic Appliance) to lend additional credibility to their project teams and add value to their projects.
• Identify business requirements, requirements management, functional design, prototyping, process design (including scenario design, flow mapping), testing, training, defining support procedures and supporting implementations.
• Architect, design and develop an enterprise business intelligence and data warehousing solution. Over 12+years of strong experience in implementingEnterprise Scale Reporting SolutionsusingSAP BW / BO/Hana.
• Hands on Experience in SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
• Certified in SAP Business Warehouse powered by SAP HANA in Open SAP Online Course
• Experience in Near Line Storage (NLS) using Sybase IQ to archive data from BW Hana.
• Experience in SLT & RDA processes for Real Time Reports.
• Experience in SAP Design Studio.
• Comprehensive functional knowledge inSales & Distribution(Sales Orders, Deliveries, Billing),MM(PurchasingP2P& Inventory Management),PP, QM, SRM,FI/CO(General Ledger, AR, AP, Funds Management, CCA, PCA and COPA) and General business process of SAP ECC.
• Experience in migration activities for BW 7.3 on Hana migration, pre migration i.e.,housekeepingactivities and post migration i.e., check consistency of tables by running program ex: RSDU TABLE CONSISTENCY, RS BW POST MIGRATION, transfer inconsistentInfo Objectsfrom SAP Business Content.
• Expertise in using Universe Designer/Information Designer Tool using BICS(Business Intelligence Consumer Services)over BEx queries and Info Cubes to migrate & model data from BI to BO for reporting. Excellent skills to develop reports using Webi/Crystal Reports live Office.
• Extensively worked on BO performance over Bex by implementing Query Stripping, removing unused hierarchies in BEx, Suppressing unused hierarchiesin BW.Used Web Intelligence scheduled reports to enhance user experience, Enabled“Use Selection of Structure Elements”for queries which have several restricted and calculated key figures.
• Experience on Converting the Regular tables to Real Time tables through SLT (SAP Landscape Transformation) Process and also converting the Standard Data Sources to Real Time Data Sources (RDA).
• Extensively worked on Designing and maintenance of data targets like the Info Objects, DSO Objects, Info Cubes, Info Sets, open hub, APD and Multi Providers, SAP HANA - optimized DSOs,SAP HANA-optimized Cubes, Composite Providers,SemanticPartitioned Objects(SPO), 7x Migration Tool, AnalyticalIndexas per the SAP Best practices.
• Expertise inimplementation andmigrating from BW 7.01 to BW 7.3 on Hana.
• Experienced in activatingstandard Business Content, extendingandenhancingusing User Exits according to the end-user requirements
• Involved in Post-Production support that includes monitoring ofprocess chainsand data loads, reconstruction of data targets in case of failed loads, rescheduling ofprocess chains, debugging of transfer, update routines and transformations. Extensively worked on theBI Accelerator (BIA),which involves creating BIA indexes and rolling up of the data.
• Expertise in creatingBex Queriesusingstructures, variables, calculated key figures, restricted key figures, cell restrictionsandRRI Jump Queries and modifying standard templatesandcreating custom templatesUsing Web Application Designer.
• Expertise in writing ABAP code instart / end routineand routines in transformations, CMOD code for Bex Variables, Custom Extractors.
• Experiencetraining end usersin Bex reports, workbooks, Crystal reports and Xcelsius.
• Experience in working individually, onsite - offshore model, multi delivery location (global delivery) model and multi-vendor environment.
• Worked on BODS Data migration to Migrate data from Non-SAP and ECC systems to SAP BW.

TECHNICAL SKILLS

Data Warehousing: SAP BW 3.5 & BI 7.0/ 7.3/7.4.

SAP R/3: ECC 6.0, R/3 4.7

Languages: ABAP/4, XML, HTML, C

Databases: Oracle, BW on HANA

Tools: & Utilities: Visio, MS-Office

Operating System: Windows NT/98/95

PROFESSIONAL EXPERIENCE

Confidential

Sr. SAP BI/Hana Consultant

Responsibilities:

• Worked in Catalyst Rel. 1,2 US implementation
• Involved in a detailedgap analysisbetween the SAP Standard Business Content and Reporting Requirements.
• Worked on Lag analysis concept where we have we different fiscal variants (USA Vs other countries) to update corresponding Fiscal period.
• Worked on GPC reports design where we have used the concept converting Data Model to KF Model to improve the query performance.
• Worked in Hana Studio for creation of advanced DSO’s & Composite Providers.
• Involved in Analysis Authorization objects for users data security authorizations.
• Worked on ABC/XYZ analysis report by Product & Product location level.
• Worked on Open PGI, Pipeline, OBD (Outbound) & IBD (Inbound) reports.
• Worked on Supply Chain Reports like Monthly Inventory Snapshots, Inventory Projection, Products Past Shelf life & Demand Vs Supply reports.
• Worked on SOE (Statement of Expenses) reports distribution to respective users through broadcasting (using Email Bursting) using Cost center Authorizations.
• Worked on UC4 job scheduling tool for Process chains schedules.

Confidential

Sr. SAP BI/BO/Hana Consultant

Responsibilities:

• Managed Onsite and Offshore Teams (Development and Support) and acted as SPOC for all communication
• Extensively involved in gathering thereporting requirementsfrom the business users by meetings.
• Experience in Converting functional requirements to technical design documents.
• Worked in architecture team to design the new requirement and redesign the existing flows.
• Involved in a detailedgap analysisbetween the SAP Standard Business Content and Reporting Requirements.
• Extensively worked onwriting test scriptsand also on theUnitandIntegration testingof the reports.
• Worked on Enterprise Hana to create Attribute Views for the master data, Analytical Views for the transactional data and the Calculation Views for the Complex logics (Graphical & SQL Script) in HANA Studio.
• Designed and Developed Reporting on Hana Analytical Views and publish them in BW with Virtual Provider.
• Migrated HANA content from development, testing environment to Production environment using Delivery Units.
• SAP HANA Data provisioning using SAP Landscape Transformation and SAP Data Services, DXC, Flat File Uploader in SAPHANA Architecture.
• Having Experience in HANA Objects creation using SQL Script for Calculated Views and also execution of Store Procedure in HANA.
• Reconciled the data with the existing BW Reports with the new HANA Models.
• Have Experience in Near Line Storage using Sybase IQ to archive data from BW Hana.
• Experience in SLT & RDA processes as part of real time reports.
• Worked on Daemons which will be used to push the data from ECC to BW Hana System at regular intervals.
• Experience in Converting Hana Optimized DSO’s to Standard DSO’s for SLT Purpose
• Worked on Composite Providers which has the feature of Union and Joining Functionality.
• Generated BO universe on Bex queries and created Webi reports.
• Worked on different areas SD, MM, QM, PP, Inventory, and APO.
• Worked on all the backend objects like Info objects, DSO, Info cube, Info set, Multi providers
• Designed anddeveloped custom DSO’sandInfo cubesas per the requirements.
• Extensively worked on BWA/BIA, Aggregates, Partitioning of info cubes, and secondary indexes on DSOs.
• Extensively worked on BEx Queries, CKFs, RKFs, Cell definitions, Workbooks, WAD.
• Involved in Year end and Period end activities.
• Experience in maintenance of Authorization objects for roles in reporting.
• Actively Involved in Providing the Solution for recurring failures in Production to keep system healthy.
• Actively involved in monitoring the Production System and close the service requests (SR) with in SLA deliveries in ticketing tool Global Resolution System (GRS) & Service Now (SN).
• Worked on extremely complex landscape where there is separate path for Break-fix and Development.
• Extensively worked on thestart / end routinesand theroutinesin the transformations.
• Created generic extractors usingfunction modulesand tables for reporting on the custom build contract application in ECC.
• Experience in Data flow with multiple systems like Sending the data from APO to BW then to Smart Ops once respective optimization completes sending the resulted data back to BW and then to APO BW.
• Worked on Inbound and Outbound Interfaces ( Ex: Setting up of message types, Partner profiles for the respective configuration)

Environment: SAP BI 7.0/7.3/7.4, BW on HANA, SAP ECC 6.0, SAP BO 3.1, HANA 1.0 SPS9

Confidential

Sr. SAP BI Consultant

Responsibilities:

• Worked in architecture team to design the new requirement.
• Involved in upgrade activities from SAP BW 3.5 to SAP BI 7.0
• Involved in cutover plan preparation for all go-lives.
• Worked extensively on performance tuning on existing process chains, set up the dependencies, master data and hierarchies.
• Worked on different areas SD, MM, QM, and Inventory.
• Worked on all the area of ABAP related to BI like extractors, Function modules, Views, Customer-exit variables, Expert routine, start routine and end routine
• Worked on Sales performance reports.
• Set standards, review check list for BW development and ABAP development related to BW.
• Work on BEx Queries, user profiles and role assignment.
• Worked on BODS for Data migration to Migrate data from Non-SAP and ECC systems to SAP BW Systems
• Worked on Developing jobs to extract data from SAP Extractors & Tables, SAP BW DSOs, load to BW PSA
• Worked on creation of DS data stores to connect to data sources such as SAP R/3, SAP BW and Oracle
• Worked on Data Profiling and Data Validation Scenarios

Environment: SAP BI 7.0, SAP BW 3.5, SAP BODS, SAP ECC, and SAP R/3 4.7.

Confidential

SAP BI Consultant

Responsibilities:

• Worked extensively in all the backend objects like DSO, Info cubes, Info objects, multi providers
• Involved in giving training on BI activities to core technical team
• Worked extensively on extractors / Data sources.
• Work on Bex Queries, RRIs, WAD, CKFs and RKFs, role assignments.
• Exposed to full lifecycle right from BW configuration, modeling, analysis, design specification, development, performance tuning and maintenance.
• Designed Technical documents based on business requirements in SD, MM, Financial Management.
• Analyzed, Designed, developed, coded and implemented standard/ customized Info Cubes and DSO (ODS) Objects for MM, SD, FI-CO
• Extensively worked on Generation of Data sources, activation of Info Sources, Transferring Master Data to Characteristics and Transaction data from ECC systems to Info Cubes in BI. Responsible for loading Plan/Actual Master data (Texts, Attributes and Hierarchies)/Transaction data from ECC Data Sources and from Flat Files.
• Regarding Logistics Extraction Cockpit, Maintained extract structures for Sales & Distribution. Developed and enhanced data sources & activated the extract structures for the above modules. Designed data loads Schedule for Lo-cockpit Data Sources.
• Involved in Preparing the Business Blueprint Documents.
• Involved in Loading of Historical Data from Oracle 10g to SAP-BW through DB
• Used the Business Content Sales Overview Infocube for overall Sales Analysis. The transaction data is loaded from different Source Systems using the Info Sources such as Sales Order, Delivery, Billing Document and Sales Order/Delivery using LO-Cock Pit.

Environment: SAP BI 7.0, SAP BW 3.5, SAP ECC, and SAP R/3 4.7.

Confidential

SAP BW Consultant

Responsibilities:

• Worked on activation of BI Content and modified standard extractors related to SD and MM.
• Extensively used BW standard Lo-cockpit business content extractors to extract data from SAP R/3 to BW and performed enhancements to accommodate business needs.
• Designed and developed Info cubes, Info Sources and loaded data from SD module to BW. Worked on line item dimensions.
• Used ABAP Routines in Update rules & Transfer Rules to update characteristics and Key Figures in the Info Cubes.
• Created Info Packages and Info Package Groups to do Full, Initial, and Delta extraction for both Master and Transaction data.
• Involved in Converting the key figure Data model into Account Data model in Budget and forecast part.
• Created transport and communication structures, transfer rules, update rules for ODS and Info Cube.
• Created custom CO-PA Cube, ODS, Data Mart to satisfy business requirements.
• Developed designs dealing with currency conversions as per the user requirements.
• Managed and monitored several data loads. Optimized load performance by adjusting the packet sizes.
• Used BEx to create reports with exceptions, conditional formatting, restricted key figures and calculated key figures.
• Worked extensively on BEx Analyzer and customized the reports creating variables, exceptions and conditions.

Environment: SAP BW 3.5, SAP R/3 4.7.

Confidential

SAP BW Consultant

Responsibilities:

• Development of Technical specification documents for the developments assigned.
• Object development and review of the development requests assigned.
• Creation of unit test plans for the objects developed.
• Interaction with onsite for clarifications of issue
• Ensuring a high quality solution for all the delivered objects to the client within the schedule.
• Data Dictionary objects like Database tables, Structures, Data element.
• Worked as a developer in BW-OTC (Order-To-Cash) team, mainly provides all backend work for Sales Reporting to the management
• Performance tuning for the existing objects.
• Extracted data from legacy system using flat file interface.

Environment: SAP BW 3.5, SAP R/3 4.7.