Data Sap

Rajanikanth Chenna

SAP BW/BO Consultant

Phone: +004*-****-** 6166/ 751-****-***

Email: ********@*****.**.**

Professional Summary

** ***** ** ** ********** with over 10 Years in SAP from the areas of SAP BW, SAP BO, SAP BPC, SAP BODS, IDQ, SAP BI-IP/BPS & ABAP/4 working for Fortune 500 Companies like Shell, Honda, RWE, SBD, GSK, FMCNA, Harley Davidson, All State, NBC Universal, Philips, Accenture.

Worked in 10 projects with full life cycle implementations, enhancements and production support in the areas of SAP AR, AP, GL, CCA, PCA, CO-PA, HR, PS and Logistics (MM, SD, PP) modules.

Experience Summary

SAP BW:

Expertise in data modeling- Creating necessary InfoObjects, DSOs, InfoCubes, InfoSets, MultiProviders, InfoPackages, Process Chains, Transformations and InfoSources.

During Extraction, worked extensively on End-to-End Implementation projects, performing identification and installation of Business Content DataSources besides enhancing existing datasources or creating generic, as per the business requirements.

Worked on migrating legacy consolidation system data into SEM-BCS consolidation as Actuals. Worked on mapping with consolidation structure and validated by applying extensive transfer and update rules.

Worked on uploading data into BCS for financial and statistical data, developed tasks and methods for validations, currency translations and inter-unit elimination.

Very Strong working knowledge on various Reporting activities: BEx Query Designer, BEx Analyzer, Web Application Designer, Web templates for I-Views Reporting, Conditions, Exceptions, Alerts, Variables, Exits, Cell Definitions, Restricted / Calculated Key figures.

Good experience in extracting data from different functional areas of SAP R/3 source systems and also from Flat files

Strong experience in interacting with Business/End Users and writing Business Requirement documents, and converting them into Functional and Technical documents

SAP BO:

Excellent experience of SAP BO Front End reporting including BO Universe Designer, Web Intelligence (Webi), Crystal reports and Xcelsius. Worked on BOXI 4.0, created P2P dashboards with Dashboard designer.

Worked on SAP Design Studio 1.0 in building centralized dashboard functionality for KPI planning framework.

Created WebI reports via BICS interfacing BW BEx queries directly and also via Universe.

Worked on schema design and development of Universes based on business requirements.

Worked on joins and created prompts, conditions, filters and calculations on Universes.

Worked on BO XI 3.1/ R2 Web Intelligence reports in BO Infoview. Worked developing multiple interactive dashboards using Xcelsius

Created Crystal reports and integrated into Web Intelligence. Created various reports with complex charts and also worked on drill down, drill through functionalities.

Worked on other legacy Cognos system, migrated reports from Cognos development studio into BO Desk I reports.

Good knowledge on Qlikview11- about data loads, design interface and distribution aspects.

Sound Knowledge in RDBMS, SQL, PL/SQL and XML

SAP BPC, BI-IP, BPS:

Worked on budgeting system implementation using BPC. Worked on developing BPC application components such as Application Set, Dimensions and Applications.

Loaded and validated data, created business rules/ logic/ calculations in BPC. Worked on currency translations, inter-company eliminations and journals.

Professional Experience

Work Location: UK

Client(s),

Duration- Role

Shell/ BG Group – Reading, (11/2015- Current) - [BW/ BPC]

RBS – Brighton, (07/2015 – 10/2015) – [BW/ETL/BO]

FriendsLife – Bristol, (06/2014 – 06/2015) – [ETL/BW/BO]

Unipart/JLR- Oxford (1/2014 – 05/2014) – [BW/BO]

Shell- London-DSMI-GPMR/GSAP (4/2013 – 12/2013) – [BW/BO/BPC]

Honda – Swindon, (07/2012 - 11/2012) – [BO/BPC]

RWE npower – Swindon, (01/2012- 06/2012) - [BW/BO]

Stanley Black and Decker, Slough, (09/2011 - 01/2012) [BW/BO]

Iberdrola, Scottish Power, Glasgow, (06/2011 - 08/2011) [BW/ETL]

Amey, Oxford, (11/2010 - 06/2011) - [BO/BW]

GSK, London, (05/2010 - 11/2010) – [BW/IP]

Environment

SAP BW7.4 SP5, SAP BI7.0, SAP EPM BPC10.0 NW, BPC7.5 NW, SAP HANA SPS05, SAP BO XI4.0, SAP BOBI4.1, SAP Design Studio 1.0, Universe Designer, Crystal Reports 2008, Dashboard Designer, SAP BODS4.0, Informatica 9.5, IDQ9.6, Oracle 9i, SQL Server, SAP BEx Query Designer, SAP WAD, ABAP/4,

SAP Modules

MM, WM, SRM, SD, FI-AP, FI-AR, FI-GL, PS, PM

SAP BW Activities:

Worked on BW (7.4 and 7.0) data modelling, transformation, data loads to Info Providers. Worked extensively on SAP BEx Query designer and SAP Web Application designer to build reports.

Developed custom extractor for exception data from ECC opentext system. Developed custom extractor(s) for buyer information from SRM system.

Created process chains to automate daily scheduled loads to fill data targets for the newly developed/ changed extractors.

Worked on creating BEx analyzer queries and embedded into various workbooks.

Interacted with finance, PS (project system) and procurement department users for requirement details and also worked with them in UAT and final signoff to handover reports.

Extensively worked on IS-U applications such as IS-U Billing, Device Management, FICA and CS. Configured standard content and developed bespoke objects for IS-U applications.

Analyzed the error ratio in various transactions such as meter reading, billing and invoicing.

Designed and developed performance indicators for diff. job categories, Productive average, Unproductive average per day, RIGS Gas ON, % jobs completed in period

Worked on complex routines in transformation during data extraction.

Worked on data modelling for brand contribution scenario, created required data flow from project system module by extracting WBS actual data.

Worked on CCA actual data flow by extracting data required for cost center planning.

Schedule daily, weekly, monthly data loads and schedule new jobs. Advise on delta loading and ODS loading process.

SAP BO Activities:

Worked on creating SAP HANA Information views in Information Design Tool (IDT).

Worked on WebI report based on IDT's SAP HANA analytical view.

Worked on building KPI planning framework using SAP Design studio 1.0

Working on automated dashboards for OTC GKA/ Priority account WebI based dashboards for KPI analysis with various top/bottom views at country, account, sold-to level requirements.

Worked on procurement dashboard (to provide consolidated view on MM & SRM data) using Dashboard Designer (BOXI4.0) via SAP BI connection.

Worked extensively on BO WebI (BI4.0 SP5 Patch 12) to report BW BEx data via BIC connection, leveraging BI4.0 new features such as Object Linking to build dashboard look and feel interaction analysis reports in WebI.

Worked on developing WEBI reports and dashboards for the INSIGHT project reporting for BPC planning application data through ODBO connector.

Worked on month end report reports to deliver key product managers about SKU performances.

Worked on posting invoices in FI module to create test data and further to reconcile data in the BO reports.

Worked on developing WEBI (Web Intelligence) reports for HR Time and Attendance module.

Worked on KPI reporting with multi-level drill-down by integrating open document links.

Worked on summary and detail KPI reports for KPIs such as early leavers, early arrivals, late arrivals, late leavers, no clock in, no clock out etc.

Worked on quarterly forecast release to planners and supporting various issues to resolve to complete submission process.

We provide support on various planning activities involving relevant (input schedules, EvDRE reports and reconciliation reports) applications of Finance, Asset, Indirect costs, Projects and Tax modules.

Support reporting on primary statements (involving balance sheet and P&L accounts), Cash flow & KPI reports.

Work Location: USA/ EU

Client(s),

Duration- Role

FMCNA, MA - (05/2009 - 04/2010) – [BO/BPC]

All State, IL - (06/2008 - 04/2009) – [BO/BW]

Harley-Davidson, WI - (08/2007 - 05/2008) – [BW]

Philips - Eindhoven, NL - (12/2005) – (07/2006) - [BW]

NBC Universal - London, UK - (07/2006) – (03/2007) - [BW/BPS]

Environment

SAP BO XI R2, SAP BO XI R3.1, Oracle 9i, SQL, Crystal Reports 2008, SAP BI7.0, SAP BPC, BO, SAP CRM, Oracle 9i, SQL Server, Unix, DB2, BEx Analyser, BEx Query Designer, BEx Web Application Designer, ABAP/4, ABAP OO, BPC 7.0 NW

SAP Modules

MM, SD, FI-AP/AR/GL, CO-PA, CO-PC, PS, CRM

SAP BI Activities:

Analyzed business requirements, planned schema structure and worked on design and development of Universes using BO Designer module.

Worked on creating SAP BEx queries specifically used for creating BO Universe based on mapping requirements of universe components and BW OLAP structures.

Worked on developing universes based on SAP BEx queries.

Developed BO WEBI reports for based on the BEx query based universes.

Exported the universes to the Repository to make resources available to the users.

Worked on BO XI 3.1 Web Intelligence reports. Created crystal reports and integrated into Web Intelligence. Also worked on Xcelsius for building dash board reporting through Universe, WebI and Crystal Reports.

Worked on Project System (PS) standard content, configured data flow and extracted WBS elements, Orders, Statistical Keyfigures from ECC system by implementing regular delta loads through Process Chain. Also worked on Plant Maintenance (PM) extractors such as ‘Planned Costs’, Maintenance Orders’ and ‘Maintenance Notifications’.

Defined and implemented InfoObjects, DataStore Objects, Info Cubes, MultiProviders, and InfoSets. Worked on Routines, User exits & Customer exits.

Developed control table, Write-Optimized DSO to manage user’s role based authorizations and default values for Flash templates.

SAP BW delta load; info package creation, modify update rules and communication structures and day to day transport support. Resolve and implement BW Query faults (Day to Day).

Worked on developing BEx WAD templates such as Head-count, Employee Compensation, Perfomance bonus, non-employee rates and expense and tax applicactions by using BEx WAD tool for BI-IP objects.

Worked on developing aggregates for improving query performance. Activated BW statistics for measuring performance of BW objects. Also worked on performance tunings options such as Compression, ETL optimization techiniques.

Worked on support activities: provided primary/secondary support for monitoring data loads ensuring reports available to users on time. Worked on master data/ transaction data issues, resolved issues in queries, reconciliation issues, created aggregates for improving query performance, worked on information broadcasting.

Worked on enhancements in BPS and BW.

Worked on migrating data from COAMR for actuals in BPS and BCS systems with various mapping/transformations.

Created Transactional Info Cubes and Planning Areas in Planning Workbench

Involved in development of Queries using Filters, Conditions, Exceptions, Restrictions, Calculations in BEx Query Designer and BEx Web Application Designer.

It involves daily, weekly, month end and quarter end support by resolving the issues in the area SEM BPS. Batch monitoring of daily network and month end loads through the automated process using Process Chains.

Worked on developing web applications in web interface builder by incorporation planning objects such as planning layouts, variables, planning levels, planning packages, planning functions and global planning sequences.

Worked on transporting planning objects, variables and web applications across systems.

Work Location: India

Client(s)

ExxonMobil Project - (02/2005) – (11/2005)

HP PSG Project - (09/2004) – (02/2005)

GMAC Project - (11/2003) – (09/2004)

Role

SAP BW/ABAP/4 Consultant

Environment

SAP R/3 4.6C, SEM 4.0, BW 3.5 & BW/BPS, ABAP/4

SAP Modules

MM, SD, FI-AP, FI-AR, FI-GL, IS-Oil & Gas

SAP BI Activities:

Requirement Study, design & development of the application. Involved in Gap analysis for end-user requirements.

Explored SAP business content components to determine best fit for user requirements.

Worked on volume, revenue and expense data flow. Worked on reports such as revenue and volume, profit analysis and service agents and shipments [ExxonMobil]

Created Generic Data Sources using database Views and Function Modules on Tables and Info Set Queries.

Created new reports as per requirements. Developed the Enterprise controlling (ECCS) Budget Vs Actual reports. Installing FI-AA, FI-AP, FI-AR and FI-GL Business Content. Worked on Aggregates. Performance Tuning of BEx Reports. Involved in Modifying the Existing BEx Queries according to new Business Logic.

Worked on the BW-APO data load scenarios such as loading legacy data into SAP BW & APO systems, loading data from planning area of SAP APO system to SAP BW system and loading data from SAP BW system to SAP APO system

Created Technical Design documents for the InfoCubes & ODS objects. Prepared Test Scripts for the simulation of the data load into the data targets.

Created queries on the InfoCubes to show the weekly data and also worked on customer exit to modify the characteristic value variable. Developed the reports: Component Ship Plan Report, Component Purchase Plan, CPP Market Share Report, Weekly Net Short Report, NRP Report, GBU RDP Report and GBU RDP Waterfall

ABAP/4 Work:

Developed BDC Program to Change G/L Account Company Code Data.

Worked on Profit center budget uploading for the transaction KE51.

Developed a program to create parked document by running a BDC through FBV1.

Non-SAP Experience: CMRI, Roorkee, India. Role: Research Associate (08/2001 – 07/2007)

Environment: C, C++, HTML and JavaScript

As part of the research scholar worked on the project: “Training and Skill Tracking System”, for maintaining and tracking skill set data of each employee in a firm. This also includes automating the training request, training approval, training schedule process. It also provides various privilege levels for user depending on the designation of employee.

Education: Master of Technology from Indian Institute of Technology, Roorkee (I.I.T.R), India.

Contact this candidate