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.
• Hands on Experience in Creating Analytical and Attribute Views
• Hands on Experience in Creating Calculation Views with Graphical and SQL Script.
• Understanding of SAP BODS Workbench to extract SAP ECC extractors to HANA.
• Setup and Working with SAP HANA SLT replication.
• 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, 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
• Migrated SAP BW WAD reports to Business Objects 4.0 reports.
• 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

Business Intelligence: SAP BW 3.5, 3.1C, 3.0B, and BI 7.0, 7.3

HANA: Modeling 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, Xcelsius, Crystal Reports, BO Explorer.

Functional Module: SD, MM, PM, FI, CRM

Programming Languages: ABAP/4, SQL, VB 6.0

PROFESSIONAL EXPERIENCE

Confidential, Bartlesville OK

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.
• Utilized the Analysis Process Designer (APD) to populate summary cubes using complex queries on other cubes.
• Worked on BW system upgrade to 7.31 and migrated the objects and data flow from 3.x to 7.x.
• 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 data sources 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, Omaha, NE

Senior SAP BW/BI Consultant

Responsibilities:

• Implemented standard Business Content FI-GL and FI-AP cubes for transaction figures reports.
• Worked on POC for BW on HANA.
• Extracting data from SAP BI using SLT and Flatfile approaches for quick Data - Analysis.
• Experience with creating SAP HANA Analytical Views and calculation views .
• 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.
• Worked on ABAP Routines, User exits & Customer exits.
• 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.
• 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.
• 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.
• Migrated BEx WAD 3.5 reports to Business Objects 4.0.
• 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, Phoenix, AZ

Sr SAP Analyst

Responsibilities:

• Worked extensively with Administrative Work Bench (AWB) for creating InfoObjects, InfoCubes, DSO, Multiprovider, Info Sources, Transformation and Data Transfer Process (DTP)
• 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 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, Austin, TX

Senior SAP BW/BI Consultant

Responsibilities:

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