SUMMARY

• 6+ years of experience in SAP BI/ABAP with various industries like Auto - mobile, Manufacturing, Chemicals, and Telecommunications etc.
• Involved in areas of BI in data Modeling, Reporting and Extraction.
• Worked on SAP BI component like WDSO for fast data loading and immediate reporting.
• Worked on Modeling, Remodeling, Partitioning and Repartitioning in SAP BI.
• Implementation of BI which includes Data-Modeling, Data Extraction, Generic Data Extraction, Data Loading, Scheduling, Monitoring, LO Cockpit, BEx Query, Expertise in Business content services consisting of business rules, metadata, Data Extraction and Operational Data Stores.
• Expertise in query performance improvement by using APD when query takes long time.
• Involved in changing teh Existing data model of an Info Cube by adding new Characteristics and Key figures.
• Involved in creating a Generic Extractor using Tables and Views.
• Involved in setting up teh procedures for LO Cockpit, Involving Activating teh Business Content Data Sources, Maintaining teh Extract Structure, Generating teh Data Source, Activating teh Data Source.
• Worked on Exception aggregation on time characteristics.
• Involved in Generation - Worked extensively in BEX Analyzer in building Queries and saving in Workbooks (Excel work sheets) and created Custom Queries using Conditions, Exceptions, and Variables & Structures and created Web Templates.
• Worked on Calculated and Restricted Key Figures, Filters, Formulae, char value variables for Custom queries.
• Worked on Routines in teh transformations by using start and end routines.
• Exporting logically related objects to Testing /Quality Analysis system. Importing them back to Development system if needed for modifications.
• Worked on Enhancements, where in we enhanced teh standard data sources and replicated dat data sources to teh BI system.
• Worked on LO enhancement when required field moving to extract structure.
• Worked on Customer Exit and BADI based Data source enhancements.
• Knowledge on SAP HANA 1.0.

TECHNICAL SKILLS

ModulesSales & Distribution: (SD), Material Management (MM), Finance (FI).

Environment: SAP R/3 4.6C, 4.7, ECC 5.0, ECC 6.0, BI 7.0 and BI 7.4.

Operating Systems: MS-DOS, Windows 95/98/NT/2000 and XP.

PROFESSIONAL EXPERIENCE

SAP BI Consultant and Birst BI ASSOCIATE.

Confidential, California, USA

Responsibilities:

• Worked SD and MM - Inventory functionalities to meet teh business requirements.
• Worked on Technical Upgrade and implementation.
• Worked extensively on data modeling and designing activities.
• Complete implementation of BI data targets with R/3 source systems.
• Monitored Process Chains to load data from ECC 6.0.
• Used delta capable objects to stage teh data before transferring teh DSO content to teh info cube.
• Worked on Start Routines and End Routines within teh Transformations.
• Extract Master data and Transaction data from Source system.
• Used LO Cockpit extensively. Loaded teh data from R/3 to BW and used Initialization with delta update and full update methods for extracting Sales Order and Delivery Information.
• Extensively worked on Report to report Interface to display detailed level of data.
• Worked on Data source Enhancements for Enhancing teh Required Fields to meet teh Business Requirements.
• Improved data loading and query performance by compression, aggregates, rollup and partitioning.
• Created queries using BEx, and reports on BW Web reporting.
• Configured data sources in R/3 by using LO Cockpit (LBWE), initialized teh setup tables. Scheduled and Implemented delta mechanism for periodic loads.
• Worked on Exception Aggregation by using CKF to calculate last value and first value.
• Made necessary enhancements to teh Backend objects (Queries, DSOs and Info Cubes etc...) and Reports based on teh business requirement and transport them to production box as per teh release schedule.
• Worked on currency conversions by using variables in reporting level.
• Worked on flat file loads for master data.

SAP BI CONSULTANT

Confidential, California

Responsibilities:

• Worked extensively on data modeling and designing activities.
• Complete implementation of BI data targets with R/3 source systems.
• Monitored Process Chains to load data from ECC 6.0.
• Used delta capable objects to stage teh data before transferring teh DSO content to teh info cube.
• Worked on Start Routines and End Routines within teh Transformations.
• Extract Master data and Transaction data from Source system.
• Used LO Cockpit extensively. Loaded teh data from R/3 to BW and used Initialization with delta update and full update methods for extracting Sales Order and Delivery Information.
• Extensively worked on Report to report Interface to display detailed level of data.
• Worked on Data source Enhancements for Enhancing teh Required Fields to meet teh Business Requirements.
• Improved data loading and query performance by compression, aggregates, rollup and partitioning.
• Created queries using BEx, and reports on BW Web reporting.
• Configured data sources in R/3 by using LO Cockpit (LBWE), initialized teh setup tables. Scheduled and Implemented delta mechanism for periodic loads.
• Worked on Exception Aggregation by using CKF to calculate last value and first value.
• Made necessary enhancements to teh Backend objects (Queries, DSOs and Info Cubes etc...) and Reports based on teh business requirement and transport them to production box as per teh release schedule.
• Worked on currency conversions by using variables in reporting level.

SAP BI CONSULTANT

Confidential

Responsibilities:

• SAP BI for SD, MM Modules. Involved in Modeling, Extraction and Reporting.
• Data extraction from R/3 and legacy systems according to teh client’s requirements.
• Worked on LO& Generic Extraction based on client’s requirement.
• Using LO Customizing Cockpit, performed necessary procedures like maintained Extract Structures, Data sources, filling up of cluster tables and setting up of V3 update in SAP R/3 source system.
• Installed Business Content as and when required.
• Experienced in Generic Extraction and especially in creation of Generic data sources by using Table and Views.
• Involved in Activation and Installing Standard objects and reports of SD and MM from Business Content based on teh client Requirement.
• Created Multi provider and Info set based on Requirement.
• Created custom queries to build queries according to teh client’s requirement using Calculated Key Figures, Restricted Key Figures, Variables, Structures, and Query properties, Filters, Free Characteristics, Conditions and Exceptions and WAD.
• Used RRI feature to jump between teh Queries to analyze teh data efficiently.
• Expertise in query performance imp by using APD when query takes long times.
• Improved data loading and query performance by compression, aggregates, rollup, indexes and partitioning.
• Creation of Aggregates on Info Cubes in order to improve Query Performance.
• Roll up data from info cubes to aggregates, edit and maintain teh aggregates.
• Work experience on Routines within teh Transformations by using Start Routines.

SAP BI Consultant.

Confidential

Roles & Responsibilities:

• Involving in teh Service Improvement Tickets for permanent fixation of daily failures for long time.
• Ensured teh Deliverables in time with good quality.
• Accompanied teh team members where ever they struck up with difficulties towards teh Delivery.
• Knowledge sharing to newly identified team member. Handover sessions to support teams on go-live of teh new projects.
• Coordinating and Involving in tests and raising defects for failures.
• Closely worked with Project Team and other teams together for a smoother Go lives.
• Assuring teh KT for teh new Transports to teh Production System.
• Worked with Info Objects, Info Packages, Info Cubes, Multi Providers to load Master and Transactional data from SAP R/3 system and Flat files as per business demands.
• Maintaining Reconciliation’s to verify teh data in SAP R3 and SAP BW are same or not after teh data loads.
• Validated data consistency in reporting with Data Target against PSA after loading them to data targets.
• Worked on BI related ABAP like routines.
• Involved in performance tuning (Load and Reporting).
• Enhanced teh existing queries as per teh requirement.

Confidential

Roles & Responsibilities:

• Interacted with Client to get teh business requirements.
• Worked as Support consultant. Handled process chains and error handling
• Created Routines according to teh requirement.
• Designed and Developed Process chains for Master data loads and Transactional data loads with diff logics.
• Created teh customized objects based on teh requirement for Generic Data Sources and Flat files.
• Handled complex logics in transformations.
• Created Reports as per user requirement.
• Involved in SAP Netweaver Testing.
• Involved in LO data Extraction.
• Done report level changes and transported objects to QA and Prod/.
• Involved in performance tuning (Load and Reporting).
• Enhanced teh existing queries as per teh requirement.