SUMMARY

• Over 5 years of professional experience as SAP BI,BODS and HANA consultant. Has deep technical knowledge on Data Extraction, Modeling and Reporting. Has experience in Implementation projects and Extensive experience in 24x7 support projects involves addressing several end - user tickets. Has strong analyzing skills and able to handle critical issues. Has ability to work independently and in team. Has good experience in BODS reporting tools i.e Web Intelligence, crystal reports, BEX,Universe design.Has good knowledge in Worksoft automated testing tool.
• Hands on Experience and Technical Proficiency in Data Extraction, Data Loading, Delta Management, Data Modeling, Info Cube, DSO, Multi-Providers
• Creating and managing the Info Objects, Application Component, Data Source, Info Source, Info Package, PSA, Transformations, Transformation Rules, Rule Types, Rule Groups, Routines, DTP, Error DTP, Error Stack, Info Cube, Data Store Object (DSO), Standard DSO, Write Optimized DSO, Info Set, Multi Provider, BI Accelerator, Business Content and Process chains.
• Involved in Extraction of Data from R/3 to SAP BI using Generic Extraction and LO Extraction with different Extraction methods for SD and MM Modules
• Experience in Filling / Deleting data from the Setup tables and also involved in Data source Enhancement
• Hands on Experience in Reporting using BEx Query Designer and BEx Analyzer
• Worked on Performance Issues like Info Cube Compression, Indexes, Line Item Dimension, Partitioning, Aggregates/BI Accelerator and Query Read Mode.
• Involved in the Production support activities of the project like Process Chain monitoring and solving ticketing issues related to daily activities.
• Hands on Experience in Web application designer (WAD).
• Involved in Developing new process chains and Sound experience in Scheduling, Monitoring and Handling issues of process chains
• Extensively involved in setting up the procedures for LO Cockpit, Involving Activating the Business Content Data Sources, Maintaining the Extract Structure, Generating the Data Source, Activating the Data Source, Enhancing the Data Source and Used the Enhancement RSAP0001 to fill the data into the Fields Enhanced.
• Involved in Managing of Info Cubes, which involves Info Cube Content, Performance issue like Indexes, statistics, Compression of Info Cube and Rolling up the data to the Aggregates.
• Good Knowledge on Business Objects web intelligence
• Good knowledge on data warehouse concepts
• Have planned and handled resource management
• Expert in project planning

PROFESSIONAL EXPERIENCE

CLIENT: Confidential, Irving,TX

SAP HANA, BI Consultant

Environment: SAP HANA,BI 7.3, SAP ECC6

Responsibilities:

• Involved in full life cycle implementation which included Analysis, Requirements gathering, Development,Testing, Reporting, Go-live and Post Go-live support
• Involved in migration of DB migration from oracle to HANA database
• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies
• Involved in SQL scripting
• Worked closely with SAP Technical team on implementing the First Customer's project on HANA
• Involved in installation and configuration of SAP Business Objects Data Services 4.0
• Created procedures in HANA Database.
• Involved in Support and Monitoring activities after go-live.
• Involved in enhancements of Data Services Jobs, HANA Models and applying Patches on HANA.
• Knowledge of SAP HANA security including User Management, Roles and Privileges
• Worked on BW powered by Hana.
• Worked on Hana studio.
• Created Attribute view, Analytic view,Calculation view in Hana studio
• Created Analytics Privileges, Function using SQL the Function Editor, Constant columns, Calculated Attributes
• Imported BW providers into HANA enterprise.
• Created Business objects Explorer reports on Hana Identification of the source tables and data mapping from SAP source tables.
• Experience in SAP HANA Data Provisioning using SAP LT Replication Server(SLT) and Data service
• Have performed performance tuning.
• Expertise in procedures
• Designed and implemented SAP HANA data modelling using Attribute view, Analytic view and Calculation view. Developed comples SQL scripts in Calculation views, SAP HANA Data provisioning and using SAP LT Replication server (SLT) Executed 

CLIENT: Confidential, Irving,TX

SAP BI and BODS Consultant

Environment: SAP BI 7.0/7.1, SAP ECC 6.0, MM, IM, BEx Analyzer, Query Designer, Web Application Designer, BO Designer (XIR 2.1, 3.1), WEBI (XIR 2.1, 3.1), XCelsius 2008, SAP HANA 1.X, Business Objects Data Services 4.2.

• End to End implementation fully in BI 7.0 and ECC Environment
• Worked on Activating Data Sources (RSA5 & RSA6).
• Scheduled data loads through Info Packages and DTP
• Extensively worked on LO Cockpit including Customizing and performing necessary procedures like setting up of V3 updates, Deleting Setup tables and Filling up of Setup tables
• Implemented Process Chains:Loaded Data into info Objects and Info Cubes for automate loads of Master Data and Transaction Data
• Involved in creating and maintaining InfoCubes, ODS Objects, PSA, InfoObjects, InfoAreas, MultiProviders, InfoSources, DataSources, and Info Packages.
• Uploaded master and transactional data from flat files, SAP BI and SAP R/3.
• Used DSO for staging data in between PSA and InfoCubes.
• Used VirtualProviders like MultiProviders and InfoSets for cross functional reporting
• Generated and Maintained Aggregates and Roll Up of activities on Info Cubes as part of Info Cube Management
• Expertise in generating reports - worked extensively in BEX Analyzer, BEx Query Designer in building queries and saving in workbooks and created custom queries using Conditions, Exceptions, Restricted key figures, Calculated key figures, Variables .
• Analysis of WEBI, conducting studies on WEBI and Implementation of reports
• Extensively worked on SAP ECC as a source system for generating reports using BEX Query Designer
• Report development on manufacturing modules like MM,PM,QM and integration experience with FICO
• Enhanced CO-PA and FI cubes with additional necessary missing fields
• Have experience in SAP Universe Builder, Data Visualization
• Have good knowledge and experience working with a variety of DBMS platforms and file sources including SQL Server, Excel, Flat Files

CLIENT: Confidential, Irving,TX

SAP BI Consultant

Environment: SAP BI 7.0, SAP ECC 6.0, MM, BEX Query Designer

• BI Monitoring in the Production System and the corrective action and Info Package Monitoring of all the operating Info Providers
• Master Data Loading into the Production System using Flat files etc.
• New info Cube Creation using and enhancing where necessary, Business Content in MM, SD Modules
• Extensively worked with PSA in Monitoring the Data Transfer from Source system into BW
• Loaded data from R/3 to BW using Initialization with Delta update and Full update methods
• Involved in both the Activities Monitoring the Periodical loads by using Process Chains and Ticket handling
• Scheduled Daily/Weekly/Monthly Data Loads.
• Reconstruct the data request from PSA in case of data load failure
• Activated Business content data sources and created customized data targets
• Enhanced Purchasing Header (2LIS 02 HDR), Purchasing Item (2LIS 02 ITM), Schedule Line (2LIS 02 SCL) with custom Fields such as Over delivery limit, under deliver limit, business Line etc using ABAP based on EKKO, EKPO, EKET etc to meet the end user reporting needs. Create custom data sources using Views and Functional modules extractors for Account Assignment for PO (EKKN), Purchase Requisitions Account Assignment (EBKN) and PO Services Account Assignment (ESKN), Service Entry sheet etc.
• Designed and created MultiProviders on Accounts Payables Cube, Accounts Assignment Cubes, Late Pay days cube to deliver reports such as late pay days, vendor analysis, blocked invoices, PO account assignment etc.
• Created transformations, Update rules and transfer rules and wrote ABAP routines in start routines, end routines to populate fields that was not provided by the dource systems and modified existing data to meet business requirements
• Created new data source for Purchase Orders, Purchasing Requisitions, Account Assignment, and Services and extracted the data to Layer 1, Layer 2 DSOs and Cubes.
• Used BW Statistics, Query Monitor and created Indexes, Aggregates to enhance query performance
• Responsible for supporting and stabilizing the system and handle the incident tickets during the initial stabilization period.
• Performed testing in Agile Methodology
• Developed Test strategy, Test plan and Test Closure documented
• Developed Test scenario, Test Conditions and Test scripts based on functional and technical specs, test plan
• Tested of SAP Plant maintenance module: Maintenance strategies, Maintenance plans, Notifications, and Maintenance Tasks