PROFESSIONAL SUMMARY:

• 12 Years of experience in IT working on SAP HANA, BW and BO .
• Has worked on 3 Full life cycle BW implementations . Has done one green field implementation in BW on HANA .
• Experience working in Sales & Distribution , Material Management, CRM, FI, COPA and SCM - Event Management, PTP, OTC, MTD, ITR functional areas.
• Has worked on mixed approach of consuming BW Data models in HANA views.
• Good knowledge of In Memory Concepts, Columnar Store, Delta Merge, Table Partitioning.
• Ability to understand Business processes and leverage technical expertise in providing effective data warehousing solutions.
• Involved in all phases of project - Project Preparation, blue Printing, Gap Analysis, Design, Development, testing, cutover activities, Go-Live and Production Support.
• Has worked on Upgrade projects from BW 3.5 to BI 7.0 and BI 7.3 to 7.4
• Involved in Data model migration of Data Sources, Transfer Rules/Update Rules to Transformations, BEX Queries from BW 3.5 to BI 7.0 .
• Expertise in InfoCube design, DSOs, Transformations, Routines, Multiproviders, Composite Providers, APDs, Open Hub.
• Expertise in performance optimization techniques - Aggregates , Cube Partitioning/compression, building secondary indexes.
• Has extensively worked on creating FSDs, TDDs, preparing Test Scripts, Process Documents - Naming Convention document.
• ABAP experience in writing Transformation Routines, Start/End and Expert routines, Function Module extractions, DataSource Enhancements using BADI.
• Reporting expertise in developing BEX queries - CKFs, RKFs, Structures, conditions, Workbooks, WAD, Broadcasting reports.
• Experience in creating BICS connection to consume BEX queries in BOBJ WEBI and creating WEBI reports.
• Has created multiple utility programs in BW which helped in code merge activities, transports and automating data loads using process chains.
• Experienced in 3.5 Authorization concepts, RSECADMIN and SU53.
• Has worked on BW projects in Telecom, Hi-Tech and Pharmaceutical industries.

TECHNICAL SKILLS:

Data Warehousing: SAP BW versions 3.5, BI 7.0, BW 7.3 on HANA, 7.4, BW 7.5, BODS 4.X

ERP: SAP R/3 4.7, ECC 6.0

Reporting: BEx Query Designer, WAD, SAP BO Web Intelligence 4.1. Analysis Office

Languages: ABAP/4, SQL

ETL: BODS 4.2

PROFESSIONAL EXPERIENCE:

SAP BW Consultant

Confidential, Ft Lauderdale

Environment: SAP BW 7.5, REVPRO, Oracle SQL Developer, Analysis Office, MSBI

• Has been part of providing Analytics solution for Revenue Convergence ASC 606 which is implemented using Leeyo REVPRO.
• Has provided solution for the complex model of deriving Bookings data from ECC and REVPRO system.
• Has good understanding of Allocation process and deriving Carve Amounts based on POB, Product Mix.
• Has extensively worked on SQL Scripting in customizing REVPRO views using SQL Developer for data extraction into BW system.
• Has developed optimal Data model design solution by consolidating the data from ECC and allocations data from REVPRO.
• Has provided solutions for Previous Period Allocations, change date logic to provide snapshot reporting for downstream SSIS system.
• Assist in project management planning and coordination activities during project testing phases including creating test scripts, executing unit, functional, system, integration, user acceptance, regression and performance testing, and managing results and documentation using Quality Center.
• Has worked on Hybris data for G/L Reconciliation data flow design.

SAP HANA Consultant

Confidential

Environment: SAP HANA 1.0. SP12 & BW HANA 7.4.

• Has worked on creating reports for Vendor Analytics based of HANA Information views. Has developed Calculation views (Graphical and script based), Analytical Views on EKKO, EKPO, EKET.
• Worked on different types of joins on table - Inner join, Left outer join, Referential join, Text join and Temporal join.
• Has worked on currency conversions in HANA Views.
• Has migrated standard DSOs to In-memory optimized DSOs using migration Tool.
• Has analyzed HANA models and SQL performance using EXPLAIN PLAN TABLE and PLAN VIZUALIZATION
• Has consumed HANA information models in BW using Advanced DSO.
• Has worked on Smart Data Access (SDA) to migrate data from SAP Ariba.
• Has knowledge of configuring RFC connection for ECC and DB connection for HANA in SLT server.
• Data Provisioning and replicating data from source system to HANA Database using SAP Landscape Transformation(SLT)
• Has experience in LTR Transaction in monitoring table replication and monitoring dashboard.
• Has worked on POC to reduce database foot print to move BW data to NLS in Sybase IQ.
• Has used BODS ETL to extract reason code data from SNC system to HANA.
• Knowledge on Qlikview in consuming tables to create visualization objects - Resolving synthetic Keys, Circular References, Resident Command.
• Was involved in multiple process improvement projects. Objective is to reduce data load time, improving overall report availability and automating the process of manual loads.
• Has worked redesigning TM1 Data loads by using kicker DSO to do heavy uplifting of data using write optimized DSOs.
• Has worked on development of Cross functional reports like Purchase Order to Payment Cycle, OTIF report.
• Has developed reports FI AR - Customer Line Items Cleared , Payment Forecast .
• Has worked on consuming BW Data in HANA using Open ODS Views, Advanced DSOs and Composite Providers
• Has worked on automating process of uploading flat file by configuring logical path in AL11 and creating program to pick data and triggering process chain.
• Has been part of Business workshops in requirement gathering, performing Gap Analysis, preparing Technical Design Documents.
• Has developed program to identify inactive objects after data model transports making use of RSTRAN , RSDIOBJ , RSODSO and RSDCUBE
• Has worked on redesigning of Process chains in removing dependencies, properly aligning alert messages, adding new process types which validate active status of current run.
• Has worked through CAB process - Updating FSDs, TDDs in SolMan, preparing Test scripts in HPQC, capturing unit test results in Test Lab and performing cutover activities for production movement.
• Created Universes and Reports based on BEx quires and OLAP reports with BICS.
• Created the reports by using Excel Data Provider, Prompts and Drill Down, Input Controls and Merge Dimensions, Detailed Objects.
• Experienced in developing complex reports using Business Objects Webi Rich Client Enterprise having Parameter/Formula Fields and Selection Formulas, Grouping and Sub reports, Charts.
• Scheduled and Distributed the Documents through Infoview and CMC as well.
• Organized data in the reports by using Filters, Sort, Ranking and highlighted data with Alerts.

SAP BW HANA Consultant

Confidential

Environment: SAP HANA 1.0. & BW HANA 7.3/7.4

• Implemented SAP BW on HANA using LSA++ architecture.
• Has been active participant in functional Discussions in understand Business needs, implementing them in designing data models.
• Has done project planning - defining RICEFW objects, scope, resources and deliverable timelines.
• Has implemented Event Management to enable BW Reports including BW extraction related configuration in SCM system.
• Responsible for the implementation of SAP BI in Juniper and developing global reporting solutions.
• Has worked in developing generic datasources using Function module extraction using BADi, DataSource enhancement using table lookups.
• Has lead ITR track in developing reporting solutions in Install Base, Service Management, Leads, Opportunities, Quotes.
• Has done Business Content installation for SAP delivered Data Flows in SD, MM and FI areas.
• Has worked on AP Cycle Time report and Internal Audit Report in FI AP area.
• Involved in Upgrade Testing from BI 7.3 to 7.4 - Validating Data Flows, Queries, Authorizations, Source system Connections, Data Extractions from different source system.
• Has done multiple enhancements in data sources using BADI approach.
• Has worked on POS data for developing reports on Calculated and reported inventory.
• Created Web Intelligence WEBi reports using BICS connectivity with BEx queries as source

SAP BW Consultant

Confidential

Environment: SAP BW 3.5/7.X

• Has worked in BI 7.3 upgrade project.
• Has worked on migrating 3.X objects - DataSources, Transfer/Update Rules, BEX queries to BI 7.0 version.
• Has worked on creating Planning Profiles and Planning Levels for Marking Resource Management using BPS0.
• Extractions from Informatica using Power Center.
• Used APDs in formatting and sending data to Endeca - a Reporting tool.
• Worked on Projects involved in correcting the Sales data by using self transformations, lookup logics, Start and End Routines and Expert Routines.
• Has extensively worked on performance tuning by using Aggregates, partitioning, compression, Indexing, tweaking techniques in transformation logics, query tuning, write optimized DSOs.
• Has worked on redesigning of Business critical data models Radio Address Redesign, PFS Data Models.
• Has been involved in delivering reports for Net Activations, Subscriber counts, Open Commitments, GRS
• Has worked on creating reconciliation report using SQVI.
• Involved in data reconciliation and coordinating with the Functional consultants to fulfill the user requirements.
• Installing BI content during system Set up for trial and productive systems and providing support after Go-Live.
• Has worked on AHS in monitoring Process Chains, daily jobs, handling Work Order and resolving support tickets.

SAP BW Consultant

Confidential

Environment: SAP BW 3.5

• Responsible for the implementation of BW 3.5 in TTSL. Modules include SD, MM, FI, CO, HR.
• Upgraded BW 3.5 to BI 7.0. Well versed with the PREPARE run required for system upgrade and activities to be followed to restore data loads after upgrade.
• Extraction of data from variety of Source Systems like R/3, DB Connect extractions, Flat File Extraction
• Migration of ISFS Data Sources to RSDS Data Sources using Migration of DataSources.
• Designing of dataflow involving new BI Data targets like DSO using new ETL process of DTP
• Used Open Hub Services to send the formatted data to external MIS systems and also to Cognos system (Using OLEDB Connect) for reporting.
• Involved in Installation of Business content objects - Master data Info Objects, Info cubes, DSO, Queries, Workbooks, Roles making effective use of Metadata Repository
• Broadcasting of monthly MIS reports to the Circle heads
• Monitoring as well as resolving data load errors, broadcasting job monitoring, jobs monitoring in R/3 Source System.
• Designing of process chains and monitoring using RSMONI.
• Designing of Reports, queries and Workbooks using BEx and formatting of reports using Report Designer. Designing reports using web items in WAD.
• Extraction of SD and inventory data using LO extraction. Well versed in LO extraction.

SAP BW Consultant

Confidential

Environment: SAP BW 3.5

• Responsible for the implementation of BW 3.5 in DIESL.
• Extensively involved in extracting the data using data sources of Purchasing, Inventory, SD and FI modules.
• Generated various reports such as FWP Tracking report, Inventory Aging Report, Purchase Order to Payment Details, Provisions Reports, and Inventory Aging Analysis etc.
• Maintenance of Broadcasting of Monthly reports like Stock in Transit aging Report, Inventory report Material Group & Plant wise etc.
• Making effective use of BW Statistics Standard Reports in fine tuning the system for better performance.
• Used RRI concept in linking analytical reports to operational information in case of ESN Aging reports and CWIP aging report.
• Debugging and analyzing slow queries using RSRT and RSRV codes and tracing the front end data transfers and OLAP performance using RSTT.
• Implemented COPA for Actual and Budgeted value reports as well as BI Financial Reports.
• Creation of Authorization Objects, Roles and assigning roles to Users using PFCG