Sap Data

HARITHA RAJULA

Email : *******.*******@*****.*** Contact # 786-***-****.

SUMMARY

• Over 10 years of experience in Information Technology industry with SAP BW (3.5, BI 7.0,BI 7.3), SAP

ABAP,SAP R/3,SAP ECC in SD/MM/FI/CO/HR/POS modules .

• Expertise in the functional and technical areas of SAP BI 7.0 with full cycle implementations

using ASAP methodology.

• Expertise in the technical capabilities of BI 7.0 & BI 7.3 ( Transformations, DTPs, BI Accelerator, etc.)

• Over one year of experience in integration of SAP BI and BOBJ and migration of BEx reports to BOBJ.

• Experience in Data modeling using InfoCube, MultiProvider, ODS, Transfer rules, Update

rules, InfoSet, InfoSources, DataSources, Transfer Routines, Update Routines and Start

Routines.

• Extensively worked with ABAP on Transformations (with complex start/end routines), Update Rules,

Transfer Rules and User Exits.

• Experience in Installation of Business Content Objects.

• Experience in construction of customized InfoObjects, InfoCubes,RemoteCubes and ODS/DSO

objects

• Designed and developed queries for reporting using BEx Analyzer, Query Designer and Web

Application Designer

• Created web reports using WAD and saved them as i-views to leverage SAP-Enterprise Portals.

• Developed Update and Transfer Routines in BW to implement business rules and conversions while

extracting data from R/3

• Expertise and intensively worked on SAP BW Security and Authorizations

• Extensively worked on pre and Post Up gradation activities for BW 3.5, BI 7.0 & BI7.3

• Expert in creating Process Chains for Automation of process and Better Performance

• Enhanced Data Sources and Created Generic Data Sources as part of Extraction.

• Conducted and performed Performance tuning Techniques (Aggregates, Cube Compression, Line Item

Dimension, and Indexing) for Improving the Reporting.

• Used and created Info Spokes for OPEN HUB services

• Extensively worked in Data Extraction from Multiple SAP and Non SAP (Legacy) Systems using

Business Content,LO,LIS,CO-PA,FI-SL, Flat File, Generic Extraction Methods for legacy data.

• Involved in developing ABAP objects using Reports (Classical, Interactive, and ALV), SAP Queries,

Data Dictionary, Dialog Programming, BDC (Conversions, Interfaces), LSMW, and BAPIs. Worked in

SAP SCRIPTS, SMARTFROMS worked in Enhancements (User Exits and BADIs), RFC, ALE, IDOC,

EDI, and BAPI with functional modules SD, MM, FICO, PP, PM and HR.

• Extensively involved in BI Production Support in handling daily batch jobs, load failures, delta failures,

Performance issues, BIA issues, System issues, reporting issues, locking issues, resource bottleneck

issues.

• Solid experience in Front-end BW queries, workbooks and templates, RRI, Calculated and restricted

key figures, Variables, Virtual characteristics, Information Broadcasting and publishing reports in the

Portal.

• Attended in house training and Have good knowledge on SAP HANA.

• Proficient in coordinating and managing the activities between on-shore and off-shore teams.

• Excellent Communication, Interpersonal skills, Problem solving abilities and effectiveness in working

independently or as a team player

Educational Qualifications:

MCA (Master of Computer applications) from Andhra University, INDIA.

TECHNICAL SKILLS:

SAP BW Versions: 7.3/7.1/3.5.

SAP CRM Versions: 5.0.

SAP R/3 Versions: ECC, 4.7, 4.6C.

Business Objects: Business Objects XI 3.1, Designer, Web Intelligence rich client, Desktop Intelligence, Info View,

Xcelsius 2008

Databases: Oracle 9.i/8.i.

BW reporting: BEX Analyzer (3.x and 7.0), Query Designer (3.x and 7.0), WAD (3.x and 7.0) and SAP Portal.

ERP Packages: SAP SD, MM, FI/CO, HR and CRM modules

Operating Systems: Windows 2000/XP/NT.

PROFESSIONAL EXPERIENCE

Client: HD Supply,SanDiego,CA September 2013 to till Date

Senior SAP BW Developer(MSA and Development Team)

Environment: SAP ECC 6.0, SAP BI7.0, Bex Designer, WAD, HCM.

Involved in global implementation of HR OM/PA modules

Responsibilities:

• Post Production support, which involves daily monitoring of data loads via process chains, trouble shooting

and correcting the known errors and escalating the unknown to the SAP support team.

• Analyzed and Corrected production problems as they occur in the SAP BW system

• Customized and maintained Data Sources such as Billing (2LIS_13_VDHDR), Sales Order

(2LIS_11_VAITM), and Delivery Order (2LIS_12_VCHDR) Purchasing Order Item (2LIS_02_ITM) for MM .

• Worked on Extraction of Material Classification Data from R/3 to BW.

• Developed numerous custom datasources using database views and custom function modules.

• Utilized the Analysis Process Designer (APD) to perform custom calculations of projected inventory levels.

• Enhanced business content datasources with append structures and ABAP user exits.

• Developed process chains to facilitate data loading.

Client: Good Year Tire and Rubber Company, Akron April 2013 to September 2013

Senior SAP BW Analyst

Environment: SAP ECC 6.0, SAP BI7.0, Bex Designer, WAD, HCM.

Involved in global implementation of HR OM/PA modules

Responsibilities:

• Delivers HCM consulting experience at functional and technical level.

• Involved in modeling OM/PA Data models and created generic extractors.

• Responsible for customizing the standard table to enable standard extractors extract data from IT302

Additional actions.

• Responsible for enhancing the standard 0Employee/0Person as per the business needs.

• Responsible for modeling the Headcounts and actions Infoprovider and Staffing infoproviders to enable

business to report on them.

• Created generic extractors and enhanced standard extractors using BADI’s.

• Created Start routines, end routines and expert routines in transformation using ABAP.

• Created expert routine to extract direct managers in the Org Units where a org Chief is missing from

IT0105.

• Coordinated with Security in Designing, developing, and maintaining structural authorizations and

standard/derived roles for position-based HR security strategy, driven by complex span-of-control

requirements.

• Created test environment, test plans, test data involving Business users in the UAT/Integration testing

• Created training documentation/power point presentations for the Business Users

Client: Grace Kennedy, Denver Oct 2012 to Feb 2013

Senior SAP BW Consultant

Environment: SAP ECC 6.0, SAP BI7.3, Bex Designer, WAD, BOBJ 4.0,SD,POS,FI.

Responsibilities:

Project involves migrating applications from SAP BW3.5 to SAP BI7.3. Use SAP BW to extract data and build

dashboards in Xcelsius, and build and modify existing reports and simultaneously create and design reports using

SAP BOBJ.

• Upgraded from BW 3.5 to BI 7.3 Technical Upgrade and Dash Board implementation.

• Interacted with the management and business Decision-makers to identify business requirements.

Documented reporting needs of the Business Service and Support Organization and disseminated those

requirements into a data warehouse strategy resulting in both operational and analytical reporting.

• Successfully executed the BI Upgrade strategy from BW 3.5 to BI 7.3 including Pre-Upgrade and Post

Upgrade tasks (collecting system objects, Security).

Upgrade Activities:

• Involved in the Pre Upgrade Activities (3.5 to BI 2004s).

• Running of Reports for activation of all the Objects.

• Running RSRV for the Consistency Check for Master and Transactional Data.

• Running the Report RSUPGRCHECK Report for Checking the Consistency Check.

• Involved in the post Upgrade activities (BI 2004s).

• Involved in the Base Line Testing

• Migrated Library Items from 3.5 and from 3.5 to 7.3.

• Emptying the Queues (SM13 & LBWQ) by running the V3 Jobs.

• Deleting the Data from the Set Up Tables

• Running the Process Chains to fetch Data and Emptying the RSA7.

• Resolved many issues around the Upgrade. Created OSS messages for Upgrade issue.

• Conducted the User Training on the New Bex Features. Installed and configured the BI Admin Cockpit.

Successfully deployed the New Analysis Authorization.

• Worked closely with the Corporate Consultants in providing Functional Specifications to enhance the

current and develop new ODS and InfoCubes. Defined Custom Cubes and MultiProviders for the business

scenarios along with aggregates.

• Responsible for developing High level Data flow and revising the Gap Analysis.

• Used Hierarchies in the reporting to provide drill down features. Designed and developed reports with filters

and free characteristics.

• Worked on Custom extractors using function module for BOM extraction

Client: Forest Labs, Long Island Feb 2012 - May 2012

Senior SAP BW Consultant and Lead

Environment: SAP ECC 6.0, SAP BI, Bex Designer, WAD, BOBJ

Responsibilities:

• Worked on BW Upgrade project for Patch and plug in upgrades, which involved preparation of all clients

for upgrade, post upgrade testing.

• Was responsible for the change management process and moving the objects to production .

• Developed Standard Test case template for Pre and Post Upgrade process in upgrade.

Tested Sandbox and development environments as per test cases in upgrade process from the

business users.

• Perform test support patches and OSS Notes for Upgrade.

• Involved in creation/approval of transports between D-Q-P systems.

• Created test environment, test plans, test data involving Business users in the UAT/Integration testing

• Created training documentation/power point presentations for the Business Users

• Created process chains for data loads and used and applied logic on info packages for building pseudo

deltas.

• Administered the user’s roles and privileges in Central Management Console.

• Scheduling the documents and distributing them using CMC and monitoring them.

• Creating aggregates and indices for better query performance

• Configured SAP BW and source systems

• Evaluated statistical performance and made recommendations to basis support for optimization

Client: British Petroleum, Houston TX Sep 2010 - Aug 2011

SAP BW Consultant (BW-BO integration, Enhancements and Production Support, BW Upgrade)

Environment : SAP BW 3.5, BI 7.0,SAP R/3, ABAP/4, BEx, Query Designer, WAD and Portal, Universe Designer,

Desktop Intelligence(DESKI), Web Intelligence(WEBI).

Requirement: Design, Development & Enhancements, Queries & Reports & Cutover Activities

• Enhancements to Standard Data Sources

• Data Loading to Inventory Targets

• Unit Testing & Automating the Loads

• Designing & Development of BEx Queries & Reports

Responsibilities

• Post Production support, which involves daily monitoring of data loads via process chains, trouble shooting

and correcting the known errors and escalating the unknown to the SAP support team.

• Maintaining Reconciliation’s for Finance and Inventory data to verify the data in SAP R/3 and SAP BW are

same or not after the month end data loads as a part of month end activities.

• Actively involved in transition Phase to take Knowledge transfer and prepared SMTD document for SAP-

BW system.

• Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process

Chains.

• Maintaining the queue – related to the system generated tickets and customer generated tickets.

• Maintaining Work History for all the tickets until it is closed down.

• Handling Customer generated tickets and interacting with users for getting clarifications, giving effective

solutions to SIR’s assigned involving report and data issues.

• Interacting with different teams for the delay of schedule loads and re-schedule the loads when the file is

arrived by control m team

• Analyzed and Corrected production problems as they occur in the SAP BW system

• Preparing status reports on Data Load monitoring of daily, weekly and monthly loads

• Enhancing the Standard Data Sources across functional areas as per the Business Requirements

• Enhancements to User Exit variables for Queries

• Design & Development of BEx Queries across all Functional Areas

• Design & Development of Workbooks and publishing them as per Business Roles

• Extensively coordinated with the Security teams to design & implement Analysis Authorization for various

Reports

• Enabling some of the Business Content Characteristics as Authorization Relevant

• Conducting the Train the Trainer Session for the Business Users

BW-BO Integration:

Business Objects Responsibilities:

• Involved in SAP BI BO integration and Migration of BI Bex Queries into BO.

• Created OLAP universes on Info cubes, Multi Providers and BEx Queries using Universe Designer.

• Designed and developed Xcelsius Dashboards using Universe (Query as a Web service), Web reports( Live

Office), BI queries( BICS) and also used Open Document to drill down from Dash board to detail level of

reports created using Web Intelligence.

• Involved in performance tuning of various WEBI reports in BOBJ side.

Client: DCC, DerbyShire County Council, UK Mar 10 – Sept10

SAP BI consultant

Environment: SAP BI, SD, HR, FI

Requirement:

Derbyshire County Council (DCC) has launched the Coré Systems Project, an initiative to migrate its Finance, HR

and Procurement business activities from the present mainframe and other legacy systems to SAP ECC and SAP

SRM.

DCC has chosen SAP Business Warehouse as the analytical tool of choice for management and strategic reporting

across the SAP landscape. It is to be utilized in the medium to long term as an open Enterprise data warehouse

solution but initially will be used as a compliment to SAP operational reporting, and not its direct replacement.

Responsibilities:

Extracted data from FI-SL, 0FI_AP_4 and 0FI_AR_4.

Extracted data from Organization Management, Personal Administration, Pay Role and activated HR

related business content in BW

Extracted data from SAP R/3 FI, CO modules into BW and created necessary objects in BW for data

staging, transfer, and analysis.

Extended 0employee_attr to include the employees reports to manager, Address, Weekly hours, Weeks per

year, teacher reference number, pension membership, salary protection code, pay method, CRB cleared

status, continuous service date

Worked extensively on BEx Query Designer. Developed flexible queries using filters, Navigational

attributes in BEx Query Designer to facilitate data analysis in a drilldown Way to give detailed level of

information.

Involved in configuring and creation of DataSources, InfoSources to extract data from various Flat Files and

SAP R/3 systems.

Uploaded Master and Transactional data from Flat Files and R/3 Source System.

Scheduled and Monitored data loads into BW from R/3 involving Delta Initialization and Delta Upload.

Troubleshooting of BW data extraction / load problems.

Incorporated Transfer rules for InfoCubes and customized update rules using ABAP/4.

Generated reports using BEx (Business Explorer) with exceptions, conditional formatting restricted,

calculated key figures, Currency translation keys and RRI (Query Jump Targets) as per the requirements of

the query.

Used the variables in BEx Analyzer and published the reports and Created web reports through report

template in WAD (Web Application designer).

Created queries on 0FIAR_C03, 0FIAR_C02.

Created Reports on Organization Management ODSs and Authorized to Particular End User.

Customized Business content reports of 0PA_C01 as per the Requirement of the End users.

HR reports Include Comparison 4 quarters previous year, Percentage Distribution of Entries, leaving rate,

Average Head count, Net Entry Rate, Number of Entries, Head Count full-/part time Staff

Created new queries with Variables, Calculated Key figures to the SAP BW.

Published reports on web using Web Application Designer.

Responsible for Performance tuning of the interfaces and reports in the Production and development

environnent

Applied the OSS notes as required

Client: Cornerstone, Hydro One June 09 – March10

Senior SAP BI Consultant

Environment: SAP BW 7 SAP ECC, BEx, ABAP/4, Oracle 8i, and Windows 2000

Networks, our largest subsidiary, are involved in the planning, construction, operation, and maintenance of our

transmission and distribution network. Launched in May 2000, Hydro One is a holding company with four operating

subsidiaries. It emerged from the restructuring of Ontario Hydro as the owner and operator of the wires operations

formerly provided by the provincially owned utility. The company employs approximately 4,000 full-time staff across

the province. Hydro One Networks Inc. owns and operates Ontario’s 28,600 km high-voltage transmission system.

The system transports electricity to 67 large industrial customers, 55 local distribution companies, and its own low-

voltage distribution business.

Responsibilities:

Involved in Developing the Technical Specifications requirements and also converting the Functional

specs into Technical Specs.

Worked on loading Master data and transaction data from flat file and SAP R/3.

Created Info Objects, DSO objects, Info Cubes, Multi Providers, Transformation and Data transfer

process.

Worked with Multi Provider to combine several Data targets (info Cube, DSO, Info Object) to generate a

Consolidated Report from Multiple Data targets.

Customized and maintained Data Sources such as Billing (2LIS_13_VDHDR), Sales Order

(2LIS_11_VAHDR), and Delivery Order (2LIS_12_VCHDR) for the SD module and Purchasing Order

Item (2LIS_02_ITM) for MM

Exclusively involved in BEx Reports and WAD Reports like Analysis Reports and Operational Reports.

Extensively worked on Unit Testing to writing test Scenarios.

Extensively worked on performance tuning to fine tune the Query performance and Data load

performance.

Analyzed report performance for statistics and implemented proposals for aggregate creations and

indexing. Tuned queries using Partitioning, Aggregates and Multi providers.

Good knowledge on necessary settings of inventory management, purchasing, process keys and

moment types involved.

Client: Tedrive, Germany Feb 09 – May 09

SAP BI Consultant

Environment: SAP BI 7.0, ECC 6.0, BEX, ABAP/4, Windows XP

Modules: FI, CO

Develops and produces driveshafts, differentials and steering systems for the global automotive industry. With

annual sales of €480 million and 2,600 employees at five locations, Tedrive is a flexible mid-sized automotive

supplier active on a global level. Established in April 2007, the company operates under the Tedrive Holding B.V.

umbrella. Its headquarters is located at Heerlen in the Netherlands.

Responsibilities:

Interacted with business end users to gather requirements and transformed them into a data model with the

concept of Extended Star schema.

Analyzed business reporting requirements that could be satisfied with SAP business content and installed

the necessary objects.

Identified data sources based on end-user reporting requirements, and created Info Cubes, extracted data

from CO module.

Extensively used BEx analyzer, created queries with variables, filters, calculated key figures, restricted key

figures, exceptions, conditions etc. Developed Report – Report Interface for all the Cost Center Accounting

(CCA) queries to drilldown from CUBE level to ODS level and then to R/3 level.

Used Transport connection to move objects from development to quality environments. Worked with

Transport organizer to migrate the newly developed queries, process chains to Test client for testing and

then migrated to production.

Attended Weekly status meetings and documented each stage of the Implementation.

Client: Cadbury Europe, Cadbury UK Jan 08 – Feb 09

Senior SAP BW Consultant

Environment: SAP BW3.5, R/3, BEX, ABAP/4, Windows XP

Modules: MM, SD, FI

Cadbury has been synonymous with Chocolate since 1824.Cadbury is one of the world’s largest chocolate

producers. There is a need to improve Cadbury business model in response to the challenges presented by the

changing market place. The One Europe project will deliver a new category focused business model based on the

centralization of core commercial and supply chain activity at Cadbury new Regional Head Quarters in Rolle,

Switzerland. Centralizing will help achieving global objective of fewer, faster, bigger and better while still maintaining

market specific branding.

Responsibilities:

Worked in prod support team as well as development team.

Provided consultation for other projects that needed BW expertise.

As Team member involved in modeling part of BW Objects.

Prepared technical specifications for HR – Time Audit report Jump Functionality.

Compiled the test cases for User Acceptance testing of the BW objects.

Tested the BW Objects in Development and Testing environments as per the test sets.

Production Support and Enhancements

Prepared Technical Specification for all the Enhancements related to HCM and SD modules.

Enhanced HCM, SD data sources and build custom build reports as per the user requirement.

Configuring the dataflow (InfoObject, ODS, Infocube and MultiProvider).

Prepared Technical Specification for all Break fix Enhancements for Production Support Issues.

Prepared Test sets for User Acceptance testing of all the Enhancements and Break fix Enhancements for

production support.

Extensively worked on the production support issues in Personnel Administration and Organization

Management Modules of HR.

Resolved Production support issues related to Purchasing Data Cube and Purchasing Group Cube.

Resolved Production support (severity-2&3) issues related to Head Count Cube, Timesheet Data (Total)

Cube, Time Sheet Data Approved Cube and Payroll Cube.

Resolved BW job failures in HR and FI Cubes.

Scheduling & Monitoring of Process chains (Master Data & Transactional Data).

On Call support and updating the Severity's of requests in Service Center.

Allotting the Production Issues to the Cube Owners.

Attended Weekly status meetings and documented each stage of the Enhancement.

Client: Insight, Limited Brands Apr 05 – Dec 07

SAP ABAP Consultant

Environment: SAP BW 3.5C, R/3 4.7, BEX, ABAP/4, Windows XP

Modules: SD, FI, PM, MM

This project is SAP R/3 implementation for Limited Brands, Inc., this is a manufacturer of retail brands like Express

men’s and women’s, Victoria’s Secret Stores, Victoria’s Secret Beauty, Victoria’s Secret Direct, Bath & Body Works,

The White barn Candle Co. and Henri Bendel. The limited brands are also comprised of various supporting

business, or functions, that develop and execute strategies for the individual brands and the enterprise as a whole.

The Limited Brands INSIGHT is a SAP enterprise implementation, focused on developing a global design for the

entire operations of the firm.

Responsibilities:

Developed a report for creation/deletion of partner profiles for customer (partner type 'KU'). In this

case inbound and outbound parameters of a reference customer are copied to the target customers.

Developed a report for creation/deletion of partner profiles for vendor (partner type 'LI'). In this

case inbound and outbound parameters of a reference vendor are copied to the target vendors.

Developed a report for Attribute Value Testing for characteristic values of size and packaging of

given set of articles.

Developed a tool for validating the Customer PO texts for given Sales order(s).

Developed an ALV report to replicate the functionality of a normal standard report program with

Dispute/Case Management functionality. Its major features include Custom Transaction Code, A wide

selection criteria with dynamic selection capability, F4 help for all the selection criteria, An ALV report with

save, export to excel and print options.

Developed an ALV report to match the Factory 856 and the Forwarder 856 transmissions on carton

quantities. If the number matches the user from the report can trigger the goods receipt for the inbound

delivery. In the case of a mismatch the user will either correct the problem manually or request a resending

of EDI messages from the factory and/or forwarder.

Developed an ALV report to display list of all customers in a certain zip code with sales reps,

partners and product line.

Developed an ALV report produce a report of customers created within a date range

Client: Holden, GM Australia Jan 03 – Mar 05

Environment: Seebeyond,SAP NW2004s, R/3 ECC-5, Windows XP.

Modules: SD, FI, CO, PP, PS, MM

GM Holden Ltd is an automaker that operates in Australia, based in Port Melbourne, Victoria. The company was

founded in 1856 as a saddlery business, but later moved into the automotive field, becoming a subsidiary of the

U.S.-based General Motors (GM) in 1931. After the GM takeover, the company was named General Motors-

Holden's Ltd, becoming Holden Ltd in 1998, with the current name adopted in 2005.

Responsibilities:

• SeeBeyond Developer and Production support member

• Involved in identifying to fix the defects and Change Requests raised.

• Involved in development of

o Reports

o Dialog programming

Contact this candidate