PROFESSIONAL SUMMARY:

• SAP BW/BI Consultant with over 8 plus years of Techno-Functional experience in SAP BW/BI.
• Trained in and having knowledge in SAP HANA.
• Knowledgeable on all aspects of BW-IP and Unified Models in context of in BPC 10.1
• Expertise in all phases of SDLC like Realization, Analysis, Multi-Dimensional Schema Design, Functional Specification, Technical specification, Development, Performance tuning, testing, documentation, Support maintenance and trouble-shooting
• Created objects like Infoobjects, Infosources, DTP, Infopackage, InfoCube, DSO objects Standard, Write-Optimized , Multiprovider, Infoset, Transformations, Transfer rules, Update rules, etc.
• Expertise in ETL and Data Modeling Data Extraction, Generic Extraction, Data Loading , Scheduling, Monitoring, Reporting Web publishing.
• Strong ABAP programming skills including customizing extractors, Function modules, writing Start routines, Transfer routine and user exits.
• Experience in automating loads using Process chains and use of BW Monitor to supervise data loading.
• Activated Standard Datasources and created Generic Datasources.
• Developed recovery procedures between different staging layers due to the loss and inconsistencies in data.
• Involved in 2 full - life cycle BW implementations, upgrade from 3.X to 7.0, Enhancements and Post Production Support in the areas of SAP SD, MM,OTC, PM, FI as well as SAP CRM.
• Strong experience in creating WebI reports with Bex queries.
• Experience in integrating SAP BW 7.3 with SAP Business Objects 4.0
• Organizing, Publishing Scheduling Reports from BI Launch Pad
• Expertise in Universe designing, developing and generating reports with complex business views, ad-hoc reports, and dashboards along with user acceptance test.
• Expertise in Report Generation - Worked extensively in BEX Analyzer in building Queries and saving in Workbooks Excel work Sheets and created Custom Queries using Conditions, Exceptions, Variables Structures and created aggregates for frequently used queries, RRI Jump queries, Web Publishing and Training End-users.
• Experience in building complex Bex queries and user exit variables.
• Expertise in BW Performance Tuning: Experience in Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing of info cubes and use of statistics for the same. Extensively used variety of techniques to boost the performance of BEx Query.
• Done implementations using SAP ASAP methodology and through understanding of SAP Best Practices
• BW Transports Object Collection Transports Movements across Landscapes, expertise in migrating and transporting objects.
• Experience in working along with core team and handled multiple roles of Senior BI consultant, Onsite Coordinator, BI Consultant and BW Developer/ Technical Consultant.
• Experience in implementing, configuration and solving module-level issues and Project conflicts and able to resolve them appropriately in time.
• Good communication skills, interpersonal skills, self-motivated, quick learner.

Technical Skills/Tools:

• Business Intelligence: SAP BW 3.5, 3.1C, 3.0B, and BI 7.0, 7.3
• HANA: Modelling studio
• ERP: SAP R/3 4.7/4.6C and SAP ECC 5.0/6.0
• Reporting: BEx Report Designer, Web Application Designer WAD , SAP BO 4.0, Universe Designer, Webi, Xcelcius, Crystal Reports, BO Explorer.
• Functional Module: SD, MM, PM, FI, CRM
• Programming Languages: ABAP/4, SQL, VB 6.0

Work Experience Details:

Confidential

Senior SAP BW/BI Consultant

Responsibilities:

• Identified the necessary Business Content using content browser and content analyzer, mapped the business process requirements with the available Business content. Installed and activated the relevant Business content for master data and transactional data.
• Implemented standard Business Content FI-AP cubes for transaction figures reports.
• Extracted and uploaded data into InfoCubes from DataSources like Cost and Allocation 0C0 OM CCA X , Internal Order 0C0 OM OPA X , Account Receivable 0FIAR AR 4 and Account Payable 0FIAR AP 4 for the FI CO modules from the Business content.
• Involved in Remodeling the Data Targets and Enhanced the Extractor.
• Implemented standard Business Content FI-GL and FI-AP cubes for transaction figures reports
• Written ABAP User exit for customizing the standard BI 0FI GL 10 datasource.
• Designed and implemented a custom extractor to extract FI tables from R/3 into BW.
• Prepared Technical specifications for the Functional Specifications.
• Identified the gaps for the requirements as a part of design.
• Monitoring and implementing the solutions to the errors in the Production System.
• Developed process chains to automate the initialization and delta updating of all data.
• Created process chains for data loading, delta uploading and periodical PSA deletion.
• Worked on ABAP routines for complex data loads in start and end routines, transformations, update rules, transfer rules.
• Utilized new BI 7.0 transformations and DTPs for all new developments.
• Developed custom datasources using database views and custom function modules, also created Badi for datasource enhancements.
• Designed and implemented a custom extractor to extract PM tables from R/3 into BW.
• Expertise with BI reporting for Data Analysis with BEx Analyzer, BI Accelerator, Web Application Designer and implementing BEx Queries, Variables and Workbooks
• Loaded data for Master Data objects Attributes, Texts and Hierarchies .
• Created custom extractors based on various maintenance tables to the staging area to Calculate the material costs, labor costs and service costs planning plant wise, maintenance plan, maintenance item wise.
• Involved in performance tuning by maintaining aggregates, compression, partitioning, indexing of info cubes.
• Created queries in the BEx and also created variables, text variables, structures, calculated key figures, restricted key figures, exceptions, conditions and RRI features.
• Daily meetings have been setup with the end users for designing the reports and extensively trained the client on BI7.0 BEx Analyzer.
• Created Open Hubs and performed the process of retraction to get the data back.

Environment: SAP BI 7.3, SAP ECC.6.0

Confidential

Senior SAP BW/BI /IP Consultant

Responsibilities:

• Expensively designed and created the Configured Aggregation Levels, custom Filters and Functions, Planning Sequences, Input enabled BEx queries to support user interaction.
• Build custom function using Formula Extension FOX formula, Characteristics Relationships Data Slices in SAP Integrated Planning IP for Analysis.
• Used BW-IP for a Cost Centre Planning b Head Count and c Personnel Cost Planning. Work involved extensively use of standard IPfunctions FOX formulas to support planning and forecasting models.
• Activated Business content for Material movements 2LIS 03 BF in administrative work bench and enhanced the data source.
• Enhanced standard data source 2LIS 03 BF for populating document header text MKPF-XBLNR and document type MKPF-BLART from Article Document header table MKPF in ECC
• Enhanced 0vendor Vendor Master to populate purchasing group from LFMI vendor master record purchasing organization data table for a one to one relationship with vendor and buyer for business reporting requirement added
• Developed generic extractor using view on Bill of Materials. Tables used are MAST Article to BOM Link and STKO-BOM Header for BOM master data source. Table STOP-BOM item for Item level generic data source. The BOM Project was developed to determine the Component cost and component vale for Weekly Stock status reporting and Weekly Stock Item Level Status reporting.
• Implemented the data extraction process on BI 7.0 that includes installation of the Business content, creating data transfer processes DTP using the new BI 7.0 features.
• Gather the security requirements for the reports in different process flows such as OTC, PTP, FI, SVM to work with security in providing the right level of security and validating the data authorizations
• Developed the flow for BI purchase requisition in material management MM .
• Working closely with users for day to day upcoming issues with the newly introduced products in demand planning area and its concerned development for its requirements in CRM area.
• Responsible for implementing the new developments and the changes based on the estimate and working closely with the functional for its design and further developments
• Worked on ABAP Routines, User exits Customer exits.
• Participated in Cutover activities during go live and provided support for data loads / issues.
• Using BEx Query Designer new layout, Exception Aggregation to define complex queries, defining Exceptions, Conditions which are later deployed in variety of scenarios like Excel workbooks and web applications.
• Expertise with BI reporting for Data Analysis with BEx Analyzer, BI Accelerator, Web Application Designer and implementing BEx Queries, Variables and Workbooks
• Loaded data for Master Data objects Attributes, Texts and Hierarchies .
• Created Process chains and Meta Chains for loading Master data and also for loading Transactional Data.
• Involved in PSA and change log deletion for reducing the table space issues.
• Building Crystal report for displaying master and transaction data, using Group headers and sub-queries in the main report.
• Experience in building complex crystal reports with multiple data sources, Query Filters and Group Headers and calling from WebI reports.
• Directly used SAP BEx queries to build Webi documents by using BICS connection.
• Created Inventory Webi reports based on plant storage locations and material movements.
• Rewrite some of the WAD reports to SAP Design Studio as a part of BW upgrade project.
• Developed some complex Dashboards using Design studio and Dashboards 4.0 for key business units.
• Created queries in the BEx and also created variables, text variables, structures, calculated key figures, restricted key figures, exceptions, conditions and RRI features.
• Daily meetings have been setup with the end users for designing the reports and extensively trained the client on BI7.0 BEx Analyzer.

Environment: SAP BI 7.0, SAP ECC.6.0, BEx Analyzer

Confidential

Sr Analyst

Responsibilities:

• Assist in the evaluation and development of tools, technology, processes and services to solve business and technical challenges
• Ability to work effectively in a complex matrix environment with virtual teams of high-level professionals
• Created Functional specifications based on the business requirements in SD module.
• Involved in setting up procedure to extract R/3 data for SD using LO, Generic Extraction and customizing to the requirement using Business Content.
• Enhanced Sales Infocube with a custom field and a standard database field to meet the user requirements.
• Worked on the different areas like Order to Cash, Budget to Reporting Finance Asset Accounting, SRM, and Procure to pay areas based on the functional specifications.
• Designed and developed Asset Accounting flow from ECC and developed Asset Reports BEx reports .
• Worked on the function modules and exits for data extraction and data source enhancements.
• Worked on FI- AP AR, New GL extraction, reconciled GL delta and the p l report with the source for the accuracy and tracing of net earnings.
• Coordinating between the offshore and onsite workload issues and taking care of the issues and concerns of the client.
• Improved the system performance and worked closely with basis assisting them in applying the patch upgrade. Worked on the BIA accelerator for rollups and re indexing of the data targets.
• Working closely with the basis to resolving the issues in production and performed testing at multiple levels for issues in production. Worked on installation of business content, activating the data source, developed a number of transfer routines, and worked extensively on administrator workbench, modified transfer structures, update rules.
• Worked on activating the standard business content infocubes 0SD C01 Customer and 0SD-C03 Sales overview .
• Involved with performance tuning of queries by maintaining Aggregates, compression, partition of info cubes.
• Working with CKF and RKF for BEx reporting.
• Working with CMOD code for master and transaction data.
• Experience in debugging issues on IDOCs and daily loads failures.
• Created a Dashboard with the Net Sales value report by Calendar years and drilled down further by Quarter, Sales Organization, Sales Offices and Sales Reps using BEx tools Analyzer, Query Designer and Web Application Designer .
• Delivered Documentation for all new objects and enhancements.
• Conducted workshop training for the end users on BEx tools and various reports execution.
• Enhanced Business Content, Data Sources with delivered/custom InfoObjects Key figures. Activated Business Content as required.
• Involved in BW upgrade into BI and migrated the BW 3.x datasources to BI 7.0 datasources.

Environment: SAP BW 3.5, SAP BI 7.0, ECC 5.0

Confidential

Senior SAP BW/BI Consultant

Responsibilities:

• Extracted the MM data using LO cockpit extraction from the datasources '2LIS 03 BF', '2LIS 03 BX' and '2LIS 03 UM'.
• Created a custom Infocube for monitoring the material movements and warehouse stocks and populated this InfoCube with data extracted from the above datasources.
• Uploaded master and transactional data from flat file and SAP R/3 as the OLTP source
• Created Infopackages for initial, full and delta uploads for both master data and transactional data.
• Involved in performance tuning by maintaining aggregates, compression, partitioning, indexing of info cubes.
• Developed basic cubes for Customer and Quotations, Created aggregates and indexes for InfoCubes to improve the query performance.
• Loaded business content, and performed activation of SAP supplied InfoObjects.
• Extensively used Process Chains to automate data loading process.
• Transported the objects from Development to QA and then to Production.
• Extensively made use of BEX Analyzer to build queries with structures, filters, calculated key figures, restricted key figures and RRI features on the Material movements and warehouse stocks, Customer, and Sales InfoCubes.
• Created web templates using Web Application Designer WAD .
• Successfully exported the daily snapshot data to another BW system using Open Hub Service.
• Set up extraction using LO LBWE Execution Cockpit V-3 updates.
• Involved in Analysis, design, development of Infocubes and ODS objects

Environment: SAP BW 3.5, SAP R/3 4.7

Confidential

SAP BW/BI Consultant

Responsibilities:

• Responsible for implementation of the overall plan and delegation and management of work tasks.
• Reported and escalated responsibilities to senior management and involved in daily interaction with team members.
• Experience with business content as well as creating info sources, info objects, info cubes, ODS objects, transfer/update rules.
• Converted all daily and event based loading to process chain with alerts and messaging to on-call staff.
• Knowledge of roles and authorizations for info objects, info cubes.
• Worked extensively on administration workbench RSA1 . Defined, designed and configured master data, info objects, ODS and info providers.
• Involved in development of aggregates, ODS and in partitioning the Infocubes to improve the performance of the Infocubes.
• Defined Hierarchies and navigational attributes for the info cubes for improving the drill down capacity of reporting.
• Developed reports using query designer, BEx analyzer and web application designer.
• Configured use of restricted key figures, structures, variables and calculated key figures in queries.
• Created conditions, exceptions and filters for query evaluations, including follow-up actions for mail and reporting agent.

Environment: SAP BW 3.5, SAP R/3 4.7