Data Sap

Professional Summary:

Over * 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.

Experience Summary:

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

Worked on SAP Business Objects Platform and SAP Business Explorer.

Good knowledge of WEBI report designing. Web Intelligence creation and formula creation.Creating reports using Multiple Data Sources:- Multiple Queries, Merge Dimension. Business Objects reporting functionalities such as Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks. Creating Report Level Filters, Scope of Analysis for drilling. Reports on BEX queries using OLAP universe and BICS connectivity. Creating Report Level Filters, Scope of Analysis for drilling. Embedding image in the report.

Worked on BW powered by Hana.

Worked on Hana studio.

Created Business objects Explorer reports on Hana

Good Knowledge in SAP HANA data modeling using Attribute View, Analytic View and Calculation View

Good Knowledge in Direct Extractor Connections.

Hands on experience in HANA modeling. Created multiple schemas and table definitions. Experience in creating Attribute views, analytical view and calculated views. Experience in applying privileges.

Extensive experience in developing data models in SP04.

Worked with BI team to ensure all business requirements are met in technical specifications.

Worked closely with BASIS on new HANA system migration process and complete manual tasks from BW Side.

Worked with ECC, Business and other interface teams & coordinate End-to-End testing

Have good knowledge on core data warehouse concepts.

Have good knowledge ABAP routines in Transfer rules, update rules, Transformations, start routine, end routine from info providers.

Have good knowledge on SAP lifecycle development.

Translated business requirements into functional specifications.

Have good knowledge in SQL scripting

Carried out Performance testing in New migrated HANA Environment.

Involved in testing in Agile .waterfall methodology

Developed Test strategy, Test plan and Test Closure documentsed

Developed Test scenario, Test Conditions and Test scripts based on functional and technical specs, test plan

Prepared requirements traceability matrix and defect lifecycle management process.

Tested of SAP Plant maintenance module: Maintenance strategies, Maintenance plans, Notifications, and Maintenance Tasks.

Created and edited functional locations and Equipments

Have experience in testing of Integration with logistics modules. SD, MM, WM.

Prepared and maintain documentation, including functional specifications, training materials

Have experience in designing, developing and configuring in SAP Business Warehouse 7.x.

Have experience in data extraction from SAP and non-SAP system

Worked extensively in business processes across various SAP functional modules like PM,MM etc.

Experience in the OLTP extraction of data of SAP LO-Cockpit, MM,generic extractions

Have experience in Dashboard design

Experience in building complex dashboards and guide customer team as well

Hands-on experience with all aspects of application testing: unit, QA, integration, and performance.

Excellent interpersonal, written, and oral communication skills

Ability to plan, be detail oriented, and deep problem solving skills

PROFESSIONAL EXPERIENCE:

CLIENT:BELL Canada,Irving,TX

SAP HANA, BI Consultant

Nov 2012-Feb 2015

Project :BI 7.3 Implementation

Environment :SAP HANA,BI 7.3, SAP ECC6

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 Data Extration Transfer Loading (ETL) using SAP Data Services 4.0

Designed function module specifications for Generic Extractors.

Created Schemas and performed Schema Mapping

Performed integration testing

Tested and validated various objects and deliverables.

Reconciliation of data between the planning area, backup cubes, PSA and BI Reports.

Designed Info cubes and DSO’s for Staging of Forecast data.

Created Ad-hoc reports, dash board reports

Master and transaction data loads in BI.

Building and generation of Business Objects Universes on top of SAP BW queries.

Training of Business Users about the new reports and reporting options using BEx.

Monitored the process data loads.

CLIENT:UNIDO- United Nations Industrial Development Organisation, Irving,TX

SAP BI and BODS Consultant

August 2010 – Oct 2012

Project Type: Implementation

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

Deployed packaged universes, extended universes an

Creating new reports in Crystal Reports and WEBI.

Activated Business content Data sources and created customized Data target

Creation of sample reports using BEX

Extracted data in various data targets depending on the user requirements like DSO,Info Cube

Developed reports using BEx Analyzer and BEx Query Designer

Design the process chains flow according to client requirement

Worked on data source & ODS objects enhancements as per the customer requirement.

Extensively involved in loading data from flat files to different data targets like PSA, DSO, and Info cubes.

Involved in Upload of Master Data and Transaction Data using process chains and validated data in source and targets.

Extensively involved in data extraction from SAP R/3 both LO Cockpit and Generic Extraction

Hands on experience in performance issues like creation of Indexes, Compression, Aggregates and roll up

Created BEx reports by using Formulas, selections, structures, exceptions, conditions, calculated key figures, restricted key figures and variables with user entry/default value and Replacement path

Performed testing in Waterfall Method

Prepared requirements traceability matrix and defect lifecycle management process.

Have experience in testing of Integration with logistics modules. SD, MM, WM.

CLIENT:UNIDO- United Nations Industrial Development Organisation, Irving,TX

SAP BI Consultant

June 2008 – July 2010

Project Type: Implementation

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

EDUCATION

Bachelor Of Engineering in Computer Science,2008

Contact this candidate