Around 7 years of experience in SAP BI/BW implementation projects and having over all 2 years of experience in Business Objects. Involved in 6 complete life cycle implementation of BW Projects that include data modeling, data extraction, reporting.

Experience Summary:

• Expertise in Data Modeling, Data Extraction and reporting in BW 3.5 as well as BI 7.0.
• Strong in Model , Design and Develop Info Objects, Info Cubes, Multi providers, Info Sources, DSO, DTP, Transformations, Update Rules and Transfer Rules.
• Experience in OLTP Extraction from SAP ECC systems to BW systems.
• Experience in data extraction from non-SAP systems (Flat files).
• Experience in Generic Extractors, LO-COCKPIT, CO-PA.
• Experience in Data Source Enhancements.
• Experience in Open hub destination services, Infospokes.
• Experience in Scheduling Batch processes through process chains.
• Experience in Performance Tuning - Improved data load and query performance by doing compression, aggregates, partitioning.
• Expertise in BusinessExplorer (QueryDesigner, BExAnalyzer, ReportDesigner, WebApplication Designer)
• Extensive knowledge of Queries using filters, structures, calculated and restricted key figures, Exception, Conditions.
• Experience in analyzing and mapping Business Process to BW and writing Business Blue Prints in ASAP Methodology.
• Experience in Routines Start, End, Expert and Field routines.
• Expertise in coding in customer-exits to enhance data source.
• Experience in creation of Process Chains.
• Experience in Portals and Visual Composer.
• Generate reports using Crystal reports on UNIVERSE, OLAP CUBES and MDB files..
• Strong Knowledge on Object Oriented ABAP.
• Experience in developing ALV Reports and ABAP Query reports.
• Experience in using various modularization techniques like subroutines, Function modules, RFC’S and class modules.
• Experience in creating and maintaining the SAP Data Dictionary objects
• Experience in create and enhance Classes, Business Objects and User Interfaces.
• Excellent troubleshooting and debugging skills.
• Train and mentor other team members.
• Experience with Agile/ Scrum Mode in team of ten.
• Ability to work closely with Business Analysts to translate their needs effectively into robust and fully realized technical solutions.
• Perform Code Inspection/Reviews.

Technical Skills

Data Warehouse : SAP BI 7.0, SAP BW 3.5
ERP : SAP ECC 5.0, ECC 6.0
Reporting Tools : Query Designer, BEx Analyzer. Report Designer, Web Application Designer
User Interface Tools : Visual Composer, Microsoft Silverlight
Databases : Oracle8i/9i, MS SQL Server 2000, MS Access
Languages : ABAP, C, C++, SQL
Operating Systems : Windows XP/VISTA/Windows 7
GUI Tools : Crystal Reports 7.0/8.0/9.0/10/XI/XIR2,

Professional Experience

• Working with Confidential, from Jan 2012 to Till date as SAP BW / BI Consultant.
• Worked with SAP LABS from Oct 2007 to Oct 2011 as SAP BW / BI Consultant.
• Worked with Confidential, from Nov 2005 to Sept 2007 asAssociateSAP BI / BW Consultant.

Education

Bachelor of Technology, Electrical and Electronics Engineering

Project Details

Client

Confidential,

Project Name

BW Implementation services

Role

SAP BI/BW Consultant

SAP Environment

SAP ECC 6.0 (sap system), SAP BI 7.X, Business explorer, Flat Files

GUI Tools

Crystal Reports 7.0/8.0/9.0/10/XI/XIR2

Duration

Jan 2012 to Till date

Project Description:
To develop new BI reports as per the business requirements and customize the standard reports in different application modules such as FI, CO and SD.
Responsibilities:

• Participate in discussions with functional Consultants on business requirements.
• Involve in analyzing functional specifications and building Technical Specifications.
• Creation of new customized Info Objects, Data Source, Info Package, Transformations, DSO’s, Info Cubes and Open Hub Destination services in Data Warehouse Workbench.
• Extraction of data from SAP ECC by using Generic Extraction and install the business content datasource.
• Extraction of data from flat files.
• Extraction of data from LIS, LO-COCKPIT,CO-PA.
• Data loading from ECC to BW and used Initialization with Delta and Full updates.
• Control Dataflow using Transformations, InfoPackages, and Data Transfer Process.
• Develop Process Chains for Master Data Loads and Transaction Data Loads with the help of Info Packages.
• Process chains are scheduled for Periodic Loads.
• Implement all types of routines using ABAP OO.
• Enhance data sources using Customer exits.
• Transport objects from development systems to quality systems.
• Resolve Data load issues.
• Monitor of Info packages and analyzing the reasons for failures.
• Maintaining Reconciliation\'s to verify the data in SAP R3 and SAP BI are same or not after the data loads.
• Configure and implement BI reporting using Query Designer, BEx analyzer for analytical reporting needs.
• Develop Queries, Calculated and Restricted key figure, Exception, Conditions.
• Configure use of Restricted Key figures, Variables, Exceptions and calculated Key figures.
• Perform Data Extraction from sap or non-sap systems.
• Build UNIVERSE using BO integration kit.
• Generate reports in Crystal reports using OLAP cubes, UNIVERSE.
• Build Interactive Dashboards/Xcelcius.
• Run Performance and unit tests.
• Perform code reviews on the programs developed by other team members.

Client Name

Confidential,

Project Name

BW Implementations

Role

SAP BI/BW Consultant

Employer

SAP Labs Pvt Ltd,India

SAP Environment

SAP ECC 6.0 (sap system), SAP BI 7.X, Business explorer, Flat Files

GUI Tools

Crystal Reports 7.0/8.0/9.0/10/XI/XIR2

Duration

Oct 2009 to Oct 2011

Project Description:
To develop new BI reports as per the business requirements and customize the standard reports in different application modules such as FI, CO, SD and MM.
Responsibilities:

• Participate in discussions with functional Consultants on business requirements.
• Involve in analyzing functional specifications and building Technical Specifications.
• Creation of new customized InfoObjects, Data Source, InfoPackage, Transformations, DSO’s, Info Cubes and Open Hub Destination services in Data Warehouse Workbench.
• Extraction of data from SAP ECC by using Generic Extraction and install the business content datasource.
• Extraction of data from flat files.
• Extraction of data from LO-COCKPIT, CO-PA.
• Data loading from ECC to BW and used Initialization with delta and full updates.
• Control Dataflow using Transformations, InfoPackages, and Data Transfer Process.
• Develop Process Chains for Master Data Loads and Transaction Data Loads with the help of Info Packages. Process chains are scheduled for Periodic Loads.
• Implement all types of routines using ABAP OO
• Transport objects from development systems to quality systems.
• Build web pages and integrate into enterprise portal using Visual Composer
• Resolve Data load issues.
• Monitor of Info packages and analyzing the reasons for failures.
• Maintain Reconciliation\'s to verify the data in SAP R3 and SAP BI are same or not after the data loads.
• Configure and implement BI reporting using QueryDesigner, BExanalyzer for analytical reporting needs.
• Generate reports in Crystal reports using queriesdeveloped by query designer.
• Build Interactive Dashboards/Xcelcius
• Develop Queries, Calculated and Restricted key figure, Exception, Conditions.
• Configure use of Restricted Key figures, Variables, Exceptions and calculated Key figures.
• Perform Data Extraction from sap or non-sap systems
• Run Performance and unit tests.
• Perform code reviews on the programs developed by other team members.

Client Name

Confidential,

Project Name

Custom Development

Role

SAP BI/BW Consultant

Employer

SAP Labs Pvt Ltd,India

SAP Environment

SAP ECC 6.0 (sap system), SAP BI 7.X, Business explorer, Flat Files

GUI Tools

Crystal Reports 7.0/8.0/9.0/10/XI/XIR2

Duration

Oct 2007 to Sept 2009

Project Description:
To develop new BI reports as per the business requirements and customize the standard reports in different application modules such as FI, CO, SD and MM.

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.
• 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.
• 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
• Enhanced the update rules for COPA Info Cube to meet the new business requirements for Total Discounts, Gross Trade Sales and Net Sales
• Developed Infoobjects, Infocubes, ODS, transfer rules, communication structure, update rules and Info packages
• Involved in performance tuning by maintaining aggregates, compression, partitioning, indexing of info cubes and use of statistics for the same
• Worked on info cubes to analyze the accounts receivable transaction figures and line items for the customers.
• Installing FI-AA, FI-AP, FI-AR and FI-GL Business Content.
• Used ODS objects to stage the data before transferring the ODS object contents to the Info Cube.
• Uploaded master data and transactional data from files and SAP R/3 as the OLTP source.
• Using Business Explorer (BEx) created custom queries based on the detailed query and business requirement
• Used Filtering, Conditions, Variables, and Navigational Attributes.
• Created queries, reports, Workbooks and web-reports on Bex Analyzer and posting of reports on the web/portal with drill down and execution capabilities.
• Trained users on using BEx reports and explained the functionality of BEx features.

Client Name

Confidential,

Project Name

BW Production Support

Role

Associate SAP BI/BW Consultant

Employer

Alcatel-Lucent Pvt Ltd,India

SAP Environment

SAP ECC 6.0 (sap system), SAP BI 7.X, Business explorer, Flat Files

Duration

Nov 2005 to Sept 2007

Project Description:
To maintain already developed BI reports and monitor the data flow from ECC systems to BI systems.
Responsibilities:

• Monitor daily, Weekly, Monthly and on demand Process Chains.
• Monitor of data loading through Process chains.
• Monitor of Process chains and analyzing the reasons for frequent failures of Extractions.
• Maintain Work History for all the tickets until it is closed down.
• Maintain Reconciliation’s to verify the data in SAP R3 and SAP BW is same.
• Data loading was monitored and the failed data packets were analyzed and if possible manually edited in PSA (mostly for invalid characters) and re-loaded to DSO.
• Involve with performance tuning of Queries by maintaining Aggregates, Compression of Info Cubes.
• Involve in Load monitoring using RSPC, RSMO, SM37, and SM50.
• Schedule attribute change runs centrally. Involved in Validated data consistency in reporting with data target against PSA after loading them to data targets.
• Develop Process Chains for Master Data Loads and Transaction Data Loads with the help of Info Packages. Process chains are scheduled for Periodic Loads.