PROFESSIONAL SUMMARY:

• More than 11 Years of experience in SAP BI/BW.
• Worked on extractors in the areas of Sales and Distribution, Material Management, CRM, HR, Plant Maintenance, SCM - Event Management, Finance and Costing & Profitability
• Expertise in creating SAP HANA information models Attribute Views, Analytic Views, and Calculation Views with graphical and script based methods using SQL Script.
• Reporting expertise includes using Lumira in creating data sets on top of HANA Information models, BO Reporting and BEX.
• Expertise with SAP HANA Studio with Modeling and Administration Perspectives in SAP HANA Enterprise environment.
• Experience in 3 Full Life cycle implementations in SAP BI / BW for different modules.
• Excellent skills in Extraction from SAP R/3, LO extractors, CO-PA, FI, Business Content and Generic Extractions.
• Working Experience in all phases of the project from blue print, gap analysis to customizations, Go-Live, Post Live Production support, User training documentations.
• Experience working in CRM subject areas like Install Base, Service Management, Planning Profiles in integrating the planning layouts with CRM .
• Experienced in upgrade activities from BW 3.5 to BI 7.0 .
• Involved in Data model migration of Data Sources, Transfer Rules and Update Rules from BW 3.5 to BI 7.0 .
• Extensive experience in BI/BW with Info cube design, DSO objects, Info Sets, Multi Providers, Info Objects, Hierarchies, Data Sources, Update Rules, Transfer Rules, Info spokes, Open Hub Service, Info sets,
• Expertise in creating Data transfer processes using process chains and extensive experience in extraction, transformation, data distribution and APD Process.
• Experience in BI enterprise reporting with SAP Net Weaver BEx Query designer, restricted Key Figures, calculated Key figures, structures and cells, properties of Attributes and Characteristics, hierarchies, Variables, exceptions & conditions, report to report interface (RRI) BEx Analyzer and BEx Web Analyzer
• ABAP experience in writing Transformation Routines, Start/End and Expert routines, Function Module extractions.
• Involved actively in supporting the various issues addressed by the Users from the client side and providing them with required solutions.
• Performance tuning of queries using aggregates, table partitioning, indexing of Info Cubes.
• Experienced in 3.5 Authorization concepts.
• Has good knowledge in Telecom domains projects.

TECHNICAL SKILLS:

Data Warehousing: SAP BW versions 3.1c, 3.5, BI 7.1, BI 7.3

ERP:  SAP R/3 4.7, 4.6, ECC 5.0, ECC 6.0, CRM

Functional Module: SD, MM, FI, CRM

Reporting:  BEx Reporting Designer, WAD, BO, Lumira, Tableau

ETL: Business Objects Data Services (BODS)

Languages:  C, C++, Java, ABAP/4, SQL, PL/SQL.

Confidential

SAP BW Consultant

Responsibilities:

• Building Reporting and Visualization objects in Lumira by creating Data Sets on HANA models.
• Has worked on designing HANA data models for Vendor evaluation reports. Has created analytical and calculation view (Graphical and script based) for modeling of above report.
• Have extensively worked on Calculation views. Used different types of Calculation view options like Dimension, cube and star join
• Worked on different types of join conditions like Inner join, Left outer join, Referential join, Text join and Temporal join.
• 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 done target table transformations to enhance table structure.
• Have performed table partitioning on large tables for performance optimization
• Develop Webi Reports & Dashboard as per business requirement
• Has knowledge of using CE functions in building script based calculation views.
• Has expertise in installation of HANA Live Content.
• Has worked on BW powered by HANA models like Composite Provider, Open ODS view, Advanced DSO and HANA Optimized Cube.
• Has worked on data extraction from ECC and BW to HANA on Batch Mode.
• Has worked on creating BO reporting using WEBI and Design studio.

Environment : SAP HANA Studio, SAP BI 7.4, Business Objects, Tableau. Business Modules: RTR, PTP

Confidential, Sunnyvale, CA

SAP BW Lead Consultant

Responsibilities:

• Implemented SAP BI on HANA using LSA++ architecture.
• Has been active participant in functional Discussions in understand Business needs, implementing them in designing data models.
• Has implemented Event Management to enable BW Reports including BW extraction related configuration in SCM system.
• Responsible for the implementation of SAP BI in Confidential and developing global reporting solutions.
• Has been heading CRM track which includes Cross functional Areas MTS, OTC, Install Base and Service Management. Responsibilities include managing the resources, designing Technical Specifications and design documents, communicating with functional users in converting requirements into technical solution and project planning.
• Has worked in developing generic datasources using Function module extraction using BADi, DataSource enhancement using table lookups.
• As a part of project, has implemented multiple enhancements along with Standard Business Content installation in CRM area.
• Has been part of architecting, designing and developing data models to support reporting requirements as well as sourcing to BO DS.
• Identify areas of improvements to enhance the stability, efficiency, and ensure high performance of BI system.
• Challenges include extracting data from variety of sources like Demantra, Sales force.com, Ariba, Demantra using BODS into BW.

Environment : BI7.4, CRM 7.0, ECC 6.0, ABAP/4, Query designer, Business Objects, BODS, Sales Force, SAP HANA Database, Business Modules: CRM, ECC, SCM

Confidential, Alpharetta, GA

SAP BI/ BW Consultant

Responsibilities:

• Has worked in BI 7.3 upgrade project.
• Worked on CRM, Planning Profiles and MRM
• 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 been involved in delivering business critical reports like Net Activations, Subscriber counts, Open Commitments, GRS
• 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.
• Knowledge in remodeling, Repartitioning.
• Has worked on AHS in monitoring Process Chains, daily jobs, handling Work Order and resolving support tickets.

Environment : BI7.0, ECC 6.0, ABAP/4, Query designer, WAD, SOLMAN, Informatica, Endeca, Business Modules: SD, MM, FI-CO

Confidential

 SAP BI/ BW Consultant

Responsibilities:

• Responsible for the implementation of BW 3.5 in Confidential . 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.
• Involved in improving the process by taking initiatives to improve the System performance, taking the effective decisions to improve the query performance and Analyzing the WHM Statistics and improved Load Performance.
• Experience in creation of Source Systems - R/3, DB Connect, Flat File, BI Systems Configuration of XI Systems.
• Involved in transportation of objects to Development, Quality and subsequently to Production servers.

Environment : BW 3.5, ECC 6.0, ABAP/4, Oracle 9i/10g, BEx Analyzer, Query designer, WAD, Business Modules: SD, MM, FI-CO, HR

Confidential

SAP BW Technical Consultant

Responsibilities:

• 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.

Environment : BW 3.5, ECC 6.0, BEx Analyzer, Query Designer , BEx Broadcaster, WAD , Business Modules: SD, MM