Viswanath Raja

**** * ***** **

Boise, Idaho -***06

832-***-****

actejw@r.postjobfree.com

SAP NW 2004s BW 7.3 /BI 4.0 Certified Consultant

SAP HANA 1.0 Certified Consultant

www.linkedin.com/pub/viswanath-reddy-raja/10/1a2/a91/

SAP BW/BO EXPERTISE

Eleven (11) years of overall IT experience in USA, Europe and India. Designed and implemented Business Applications in SAP BW/BI, IP, BO, BW-ABAP and HANA. Began technically, evolved functionally as a consultant with 5 Full Life Cycle Implementations.

Performed Requirement Gathering and Analysis at Client locations by Conducting Workshops, then prepared High and Detailed Technical Design Documents.

Five Full Cycle implementation experience in applications like SAP BW (3.5, 7.0, 7.3 and 7.4), ECC 6.0, SAP R/3 4.7 SAP-IP, and SAP BO- BI.

End to End data modeling using LSA and LSA++ architecture.

Used Business Objects Reporting tools like Dashboards Design Tool, Analysis Office for MS and WEBI.

Knowledgeable in SAP ECC, CRM, SRM Systems, experienced in SAP BW and IP technical design documents, and designed & developed reports using Bex and BO- BI.

Expertise in Multi-Dimensional Data Modeling, Planning/Forecast using Extended Star Schema and design implementation.

Designing the End-to-End Data Flows in BW Modeling.

Prepared high level and detailed level technical designs from functional specifications.

Worked with Generic Data Sources and SAP Delivered Data sources, LO Extraction, FI, CO-PA, Data loading (full/Init/delta upload), Scheduling and Monitoring.

Created BI components like Info Objects, Data Store objects, Info Cubes, Multi Providers, Transformations, DTP, Info Packages and scheduled the data requests.

Used DSO to stage the data before transferring the DSO contents into the Info Cube.

Changed the Existing data model of an Info Cube by adding new Characteristics and Key figures, involving the Re-initialization of Data Sources from SAP R/3.

Bex Analyzer, Bex Query Designer, Web Application Designer, Report-to-Report Interface and BO Analysis work books.

Configured Restricted key Figures, Calculated Key Figures, Variables, Cell Definition, Structures, Exceptions and Conditions in queries.

Used Business Objects reporting features such as Master Detail, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.

BW-ABAP skill in writing Start Routines, Field Level Routines and End Routines which are used in data manipulation in BI side and in R/3 side. Wrote Customer exits which are part of data extraction mechanisms into Data Sources for medium and low level ABAP requirements..

BW-ABAP skill in writing Filter Selections and file selections at Info Package and DTP.

Used SAP Solution Manager Tool to migrate objects from one system to another system, in Test case execution and as ticketing tool.

Overall BW Technical experience in Infrastructure, Databases (partitioning, Compression, Statistics, Aggregates and BWA), Sizing, Loading and Extraction (specifically performance), Reporting performance.

Variable Types and Processing types in Bex.

Documented Test Plans and completed Unit Testing of Developed Objects and Reports. Worked with Quality Assurance business resources to complete System and Integration Testing.

SAP Master and Transaction Data Tables.

SAP Transport Management System to migrate objects from Dev->QA->PRD.

Upgrade and Migration experience from SAP BW3.5 to 7.0 and then from 7.x to 7.3.

Test Case preparation for BW, BO back end and front end.

Daily conversation with Client teams to understand client requirements and update project status

As a Team Leader supervised the team, communicated with the team regarding project deliverables and reported status to project management daily.

Escalated and resolved cross team issues.

SAP BW-IP EXPERTISE

Modeling Planning Scenarios

Real-time info cubes, Multi Providers, Aggregation Levels, Filters, Planning Functions, Planning Sequences, Variables, Input Ready Query, Characteristic Relationships, Data Slices, Lock Management, Planning Function Types, FOX formulas, Transport of Planning Objects.

SAP HANA EXPERTISE

Modeling: Knowledge in creating Attribute, Analytic, Calculation views, Tables, Schemas, and Packages & Delivery Units in HANA studio. Worked on Import, Export, Mass copy, Changing Authorizing Schema, Attribute views, Analytic views, Calculation views & Analytic privileges in IMCE studio, Generate Time Data. Gained knowledge on different types of engines/servers used to process views.

Import/Export: Expertise in Importing & Exporting the developed views/objects to further environments in Developer mode, Delivery Unit Mode & SAP Support mode.

Extraction: Gained expertise in replicating the required tables, extracting data from SAP source system as well as from Non-SAP source system. Replicated data from flat files.

SLT Replication: Gained expertise in creating configurations, table replications in real time and scheduled.

Reporting: Gained knowledge on BOXI 4.x IDT (Information Designer Tool) – creating & publishing of Relational connection, Data Foundation layer & Business Layer. Reporting using Excel.

TECHNICAL SKILL

Data Warehousing: SAP BW 7.4, 7.3, 7.0, BW 3.5, HANA Studio (Model and Implementation)

Planning App’s: SAP BW –IP (Integrated Planning), BPC

ETL: SAP BO-DS, SAP BW/BI

ERP Packages: ECC 6.0, SAP R / 3 Version 4.7 / 4.6C / 4.6B, CRM

BI / Analytics: BEx Query Designer, BEx Analyzer, Web Application Designer, SAP BO XI 3.x /4.0 (Web Intelligence Rich Client, Crystal Reports 2008, Xcelsious 2008, Universe Design Tool, Information Design Tool, Dashboard Design Tool, Widgets, Analysis office for MS Excel/OLAP etc.)

SAP Lumira

Programming: BW ABAP / 4

Database: MS-SQL Server, HANA, Oracle

Operating System: UNIX, AIX, LINUX, Windows NT, Windows 98/XP/2000/2003, Mainframes (MVS/OS390), VM ware, Citrix.

PROFESSIONAL SUMMARY

Sierra Infosys Apr 2014 – Present

Sr. SAP BW/BI-BO/HANA Consultant

Client: Micron, Boise, ID Feb 2015 – Present

Sr. BW on HANA/BI-BO Consultant – Production Support & Integration Project

Responsible for requirement gathering from business users, estimation analysis and preparation of Technical design documents.

Data structures Implementation for HCM Personal Time Management, Organizational Management, Personnel Administration, and Payroll etc.

Extensively worked on Sales Orders, Delivery and Billing.

GAP Analysis for valuation class at material and plant combination.

BW Daily/Weekly/Quarterly data load process chain monitoring in BW 7.4.

BW-ABAP, Debug, Routines, Exits and Extractors.

Data source enhancements in SAP ECC. Migrating CMOD-RSAP0001 to BADI.

Frequent problem investigation, root cause analysis and solution implementation.

BW Remedy incidents resolution.

Architected EDW with SAP Net weaver BW LSA++.

HANA models integration with BW models using Transient and Virtual data providers.

Migration to HANA optimized info providers.

Creation of HANA views (Attribute, Analytical and Calculation views).

Created HCM reports using Crystal reports 2013.

Created Universes using IDT tool on SQL server data base.

Created HCM reports on BW data with connections SAP BW MDX Query & SAP Operational Data Store using BOBJ Crystal Reports 2013.

Designed and Developed WebI Reports using the features like Master/Detail, Charts, Cross Tabs, Slice and Dice, Drill Down, @Functions and Formulae to analyze the data

Created user Prompts, Conditions and Filters for various reports to specify the reporting parameters

Environment: BW 7.4, BO-BI, FF, HANA and ECC 6.0

Client: Tyson Foods, Springdale, AR Dec 2014 – Jan 2015

Sr. BW on HANA /BI-BO – System Integration Project

Responsible for requirement gathering from business users, estimation analysis and preparation of Technical design documents.

SD End to End Data Structures Design.

GAP Analysis for Customer Order Management (COM).

BW structures design for Logistic extractors.

Architected EDW with SAP Net weaver BW LSA++.

Creation of HANA views (Attribute, Analytical and Calculation views).

Environment: BW 7.3, BO-BI, FF, TM, HANA and ECC 6.0

Client: Coca-Cola, Atlanta- GA Apr 2014 – Nov 2014

Sr. BW/BI-BO/HANA Consultant

System Integration Project handles the scope for SAP BPC installation for Coke and integrates BPC’s Planning and BI Sales data to provide a consolidated report for C Level team.

Environment: BW 7.3, BO-BI, FF, CRM, HANA, BPC and ECC 6.0

Team Work & Roles:

Performed various roles as Lead Developer in various phases of the project.

Guided a Team of 2+ with daily work plan & reviews.

Presented all Design approaches and gained approvals from BI Review Board meetings.

Architecture & Blue Print:

Gathered requirements from business users and prepared Technical design documents.

Prepared End -End Data Flow Design Documents for educating team about Design Process.

Design & Development:

Conducted workshop with General Managers and SME’s for requirement gathering.

Developed customized FI, SD, CO, MM Reports according to business needs.

End-to-End Data Model Design and Data Extraction of FI-AR, FI-AP, FI-GL, FI-AA, CO-PA, SD, MM and HR from SAP ECC to SAP BW.

Involved in BW Analysis Authorizations/Security by creating Authorization Objects, Roles assigning to users using RSECADMIN and PFCG.

BW Back-End development for NW BPC.

Worked in OUTBOUND data flow to bring BPC Plan data from BPC BW system to FDW system.

Worked in Monthly RE Cycle to load Actual data for BPC.

Data loads from FDW system to BW-BPC system.

Data loads from FIM to BW-BPC System using BO-DS.

Process Chain monitoring using RSPC, RSPCM, /SSA/BWT.

Created Reports in the specified modules using BEx Query designer.

Involved in Change request (CR) and Ticket handling. As a part of the project, involved in data monitoring.

CR Handling included adding new Info-Objects to Info Providers, making changes in routines and performance tuning.

Involved in ticket handling, data reconciliation, and bug detection at report level or design level.

Ensured that all the data loaded into BI system by correcting any Process Chain failures due to Invalid characters, DSO Activation failures, data push through Open Hub etc.

Analyzed and Created Reports in accordance with new end user requirement.

Debugged ABAP code and checked for any data discrepancies.

Resolved support issues and data load monitoring in different time zones.

Top-Down Analysis of Issues and Coordination with client.

Dimensions, Models creation in BPC Admin Client Tool.

Master data load into Dimensions, Transaction data load into Models using Data Manager Packages.

Integrated BEx reports into BO Analysis office client tool and WEBI.

Involved in SAP Data Source Enhancements, Variable Exists, and Transformation Routines using BW-ABAP.

Designed 10-20 interfaces to extract data from Sales & Non SAP Systems.

Organized several data loads in the system with 100+ process chains.

Migrated Data Services based solutions to BI based on mapping rules and extractions.

Worked with various developments team members and prepared Tivoli Sequence for batch.

Developed and Delivered ABAP Programs to achieve complete automated data loads.

Worked closely with team and improved several process execution durations.

Proactively handled several pain points in development, data loads with ABAP based solutions.

Responsible for reviews of transports, post migration checks and issues resolution.

Worked closely with Basis, Infrastructure, SAP Teams to keep team’s productivity as high as possible during system copy, Production Space, Access related issues.

Accenture Feb 2007 – Feb 2014

Software Engineering Team Lead

Client: BASF, Ludwigshafen, Germany Jul 2012 – Feb 2014

Lead BW/BI-BO Consultant, Onsite Coordinator – System Integration Project

Environment: BW 7.3, BW-IP, BO-BI, Flat File Interface, CRM and ECC 6.0

Team Work & Roles:

Performed various roles as Solution Architect, Team Lead and Lead Developer in various phases of the project.

Guided a Team of 8+ with daily work plan & reviews both Onsite and Off Shore.

Guided entire team on BASF Policies on Design and Development.

Presented all Design approaches and attained approvals from BI Review Board meetings.

Architecture & Blue Print:

Gathered Planning requirements from business users and prepared Technical Specifications.

Prepared End -End Data Flow Design Documents for educating team about Design Process.

Conducted several meetings with Client to present design approaches and to get sign offs.

Design & Development:

Requirement gathering at client site (Ludwigshafen, Germany) for Market Understanding - Crop /Customer/Regional Split, Sales Planning and Forecasting.

Coordinated between client and offshore team regarding Detailed Technical Design preparation, BUILD, Unit Test, UAT test and Go-Live.

Made daily status calls with onshore and offshore team to get the complete update on project status and daily workload activities.

Data Flow design and Data extraction from SAP ECC to BW for SD, MM, FI, CO, HR and CRM.

Created Aggregation levels, filters, planning functions and planning sequences using ABAP based Planning Modeler (RSPLAN).

Created characteristic relationships in RSPLAN to derive value for the target characteristic using Master data attributes and Exit classes.

Constructed Data Slices to restrict key figure value changes from planning functions.

Worked with Business Users to understand their Business perspective in developing and modifying Universes and Reports.

Built Joins, Aliases and Contexts for resolving Loops in the Universes and checked the Integrity of the Universes.

Created the reports using Business Objects capabilities like Queries, Slice and Dice, Drill down, Functions, Cross Tab, Master Detail and Formulas etc.

Constructed Manual Input ready reports and assigned them to BO Analysis Work books.

Participated in Pre and Post Upgrade activities from SAP BW 3.5 to 7.0

Built input ready planning reports for following requirements:

Top down & Bottom up Sales Planning

Top down Sales Country, Zone, District and Territory

Rolling forecast reports

Product Crop Split at Sales Territory level.

Product Crop Split at Sales Country level.

Regional Sales Split.

Market data customer Split

Created planning sequences for Admin Initialization Process.

Developed test scripts and executed Unit and SFIT testing. Provided support for UAT.

Built Transactional and Master Process Chains for periodic upload of data.

Tested the data from CRM side to BW by using test cases on DSO, Info cube and Query level.

Performance tuned queries, Data models, Data Loading and Webi Documents according to best practices.

Designed and Developed BOBJ WEBI Reports for Sales summary and Point of Sale Reports, developed Crystal Reports for the Finance AR, AP and GL.

Designed and developed Xcelsious dashboard for Supplier spends analytics in the area of Suppler Relationship Management (Procure-to-Pay), using SAP NetWeaver BICS connector, by creating connections directly on BEx queries.

Designed/Developed WEBI Reports, Crystal Reports, Xcelsious dashboards for Finance and Sales to represent several KPI’s and Analytics.

Worked on Information Design Tool (BO-IDT).

Created Classes (Sub classes), Objects, Prompts and Predefined conditions and user defined objects and custom Hierarchies for drill down purposes.

Tested Universes and Reports, which includes

Database connectivity

Resolved loops and contexts to ensure the correct results from the query

Objects in the universe, to ensure the correct mapping of the objects

Aggregate awareness to ensure the query is pulling correct level of aggregation

Migrated reports and objects from development to production system using LCM.

Extracted CO-PA and FI-SL data from SAP ECC to SAP BW.

Extracted Business Partner Master data from CRM

Implemented SAP Data Source Enhancements, Variable Exists, and Transformation Routines using BW-ABAP.

Led Go-live activities for several releases.

Client: Vienna Insurance Group (VIG), Slovakia Jan 2010 – Jun 2012

Senior BW Technical Consultant – Production Support Project

Provided round the clock 24/7 on call production support.

Included and scheduled production chains using Control-M batch jobs.

Worked High, Medium and Low Priority Tickets.

Monitored Daily Chains, Weekly Chains, and Monthly Chains using RSPCM, RSPC and RSMO.

Raised remedy tickets to other groups/teams when performance of the system or data quality from source systems was not good.

Reloaded the data requests from PSA in case of data load failure.

Participated in Roll Up data to aggregates and compression of the cubes.

Monitored Info packages and analyzed the reasons for frequent failures of Info packages.

ROOT CAUSE Analysis for the Process Chain Errors and Fix.

Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction loads.

Maintained Reconciliations to verify the data in SAP R/3 and SAP BW were identical, or not, after the data loads.

Defined and developed process for BW archiving/Data Purging on DSO/Cubes using NLS.

Managed BW archiving/data purge project to move from SAP BW to Sybase IQ as Near Line Storage.

Data load activities/support for Applications like SD, MM, FI, CO, FF etc.

Maintained history for the tickets until closed.

Scheduled data loads into BW from R/3 involving full, initial delta loads & delta loads.

Job logs overview in SM21, ST22 and SM37.

Analysis on frequent load failures and Permanent solutions for the same.

Data source Enhancements analysis, development and deployment.

Change requests Analysis, estimation, design, development and deployment.

Analysis and Implementation of Data load and Report Performance.

Environment: BW 7.0, ECC 6.0 SD, MM, FICO, BO-BI

Client: Heineken, Amsterdam, Netherlands Jun 2009 – Dec 2009

Senior Technical Consultant – System Integration Project

BW Modeling: Key resource to build the BI Backend objects for Heineken CIL R45. Created Standard, Real time info cubes and DSO. Created real time info cubes to store plan data from manual inputs and flat file uploads. Built standard cubes to load data from real time cubes via DSO based on approval and completeness report.

Created process chains to load master and transactional data.

Transported the BI backend, front end and IP configuration from dev till production using SAP Solution manager (CRMD_ORDER).

Built Transformations, DTPs, Start routines, End routines and field level routines

IP: Created Aggregation levels, filters, planning functions and planning sequences using Planning Modeller (RSPLAN).

Constructed Characteristic relationships to derive value for the target characteristic using Master data attributes and Exit classes using SE24.

Built Data slices to restrict key figure value changes from planning functions.

Created custom defined planning functions using transaction code RSPLF1.

BW Front End: Created BI front end reports and manual inputs using Query designer. Constructed reports using Conditions, Exceptions, Cell definition, Structures, Variables, Restricted key figures and calculated key figures.

Created customized web templates using Web Application Designer for both end user reports and manual inputs.

Testing/Cutover: Worked in all testing phases including unit, integration and user acceptance testing.

Participated in cutover phase from preparation of the cutover plan sheet till go-live.

Participated in go-live support and knowledge transfer.

Management Role: As supervisor mentored associate, senior programmer level resources. As Boot Camp Trainer presented the 5 day BI Boot camp training course to Accenture internal resources.

Environment: BI 7.0, IP, SAP ECC 6.0

Client: Diageo, Scotland, UK Feb 2007 – May 2009

Senior BW Consultant – BW Solution Implementation for SAP ERP transactional Data.

NAM 2007: Performed development activities for North American region, participated in Cutover and provided Warranty Support for a 1 month.

Release 10: Worked as BW developer for North American countries, participated in Cutover and Warranty Support.

Release 11: This release combined both North American and European systems in a single instance; developer for SFR scenario (Supply Finance Reporting); participated in Cutover and Warranty Support. Worked with client in Scotland to close warranty issues.

Release 12: Developer for Nigeria, Ghana, EABL, and Kenyan Countries. Fulfilled GAP analysis for above releases in R12 and worked in Cutover and Warranty support.

Worked on standard and custom defined LO and Generic extractors. Installed relevant SAP business content. Used LO structures for extracting Procurement data, Inventory information and Sales information. Logistics Cockpit configuration and customization, Tracing problem to R/3 and resolution.

Developed the objects for Stock in Transit Scenario and extracted data from FI_GL_4 and did the validation on SIT Query with R/3 using reports FS10N & FBL3N.

Developed the objects for Wastages Scenario and extracted data from 0CO_PC_01&02, 0CO_OM_OPA_6 and did the validation on Wastages Queries with R/3 using reports COR3.

Developed the objects for Material Stock/Movements’ Scenario and extracted data from 2LIS_03_BX, BF&UM and did the validation on Inventory Queries with R/3 using reports MB5B&MB5L.

Worked on Manufacturing Variance scenario to find the variances between Actual, Plan and Target process order information and validated with SAP report COR3.

Worked on Product Costing Scenario to define cost components like Labor cost, packaging, raw material and subcontracting etc. for all final materials; developed reports like Product costing Summary report, FRP Cost Component report and did validated with SAP using reports MM03 and CK13N.

Created BIA Indexes on info cubes to improve the Query performance.

Worked on Transportation to move objects from Development to Consolidation to Production.

Involved in performance tuning (Loading and query performance) activities after post live activities.

REPORTING:

Developed Reports using BEx Analyzer and WEB Reporting.

Became conversant in the specifications provided by the functional consultants in the form of Medium level design documents. Interacted with onsite team to get to know the exact requirements, suggested changes where required and then developed the objects as per the evolved specifications.

Developed flexible queries using Filters, Free Characteristics, Navigational attributes in BEX analyzer to facilitate data analysis in a drill down version to enable easy access of information at various levels.

Worked on Report Component Testing and Product Testing by using Test Director 8.0 version.

Worked extensively on BEX Analyzer and BEX Browser.

Developed flexible queries using Filters, Variables, Exceptions, Conditions, restricted key figures and calculated key figures in BEX analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.

Copied Queries from one Cube to another.

Created Queries using different Variables using different Processing types.

Used RRI functionality for Jump Target to facilitate viewing the detailed report based on the available report.

Environment: BW 3.5, SAP R/3 4.5

Pantaloons Retail India Ltd., Mumbai, India Dec 2004 – Jan 2007

Junior Technical Consultant – BW Solution Implementation for SAP ERP transactional Data.

Created Data sources with SOAP connection and extracted POS data using BW Application server by using function module and variant, and created process chain for background processing.

Created Customized cubes such as Purchasing cube (VPUR_C01) and Inventory cube (VIC_C03), Used ODS to stage the data before transferring the ODS contents to the Info Cube. Constructed ODS reporting to give details of delivery items and schedule line items.

Involved in the Performance Tuning of Info Cubes like Aggregates, Compression, Partitioning and Indexes.

Designed, developed and modified Info objects, Info sources, ODS objects and Info Cubes.

Created Generic Extractors using Function Module and view.

As part of Information Consumer Layer designed BEx Reports providing Business Intelligence insight for Business Analysts for decision making using Formulas, Conditions, Selections, Structures, Calculated Key Figure, Restricted Key Figure, Data Mining, Save views and Used Variables with User Entry/Default Value, Sap Exit, Replacement Path, Customer Exit and Authorizations.

Set up procedure for extracting R/3 data for SD, MM using LO-Cockpit.

Filled setup tables for the LO extractors and used the V3 Update for Delta Management.

Generated the Data source from SAP R/3 using LO-Cockpit.

Installed Business Content objects from BW Side.

Activated Data sources in SAP R/3 using T-code RSA5

Mapped data source to info source with transfer rules in SAP BW.

Maintained Info Cube, Update Rules and Creation of Info Package; scheduled data into the Data Targets using process chains.

Created Aggregates for query performance.

Downloaded defects from Remedy and analyzed relating to reconciliation.

Transportation: Transported objects from BD1 to BQ1and BWP.

Authorizations: Created authorizations for store wise managers.

Environment: BW 3.5, SAP R/3 4.5

EDUCATION

Master of Business Administration, Anna University (2004)

Bachelors of Commerce in Computer Applications, S.V University (2002)

Contact this candidate