Name: Srinivas Rao

Phone: 469-***-****

Email: acp3qk@r.postjobfree.com

PROFESIONAL SUMMARY

. 6+ years of IT experience in SAP BW/BI - Data Modeling, Extraction

(ETL), Information Presentationand Analysis.

. Experiencein SAP BOBJ/BOBI.

. Excellent interpersonal & communication skills to work Cross-

functionally with Enterprise Team members and handle multiple tasks.

. Good knowledge in functional concepts of SAP ERP- MM, SD, and

FImodules.

. Good technical skills and willingness to learn new concepts and

technologies.

. Trained in HANA/BW on HANA.

SAP EXPERTISE

. Involved in Implementationof SAP BW/BO projects using ASAP

methodology, including Development, Enhancement, Support

andMaintenance projects.

. Proficient in translating business requirements into multiple

reporting solutions.

. Experience in client facing,End-User training, documentation and

specifications.

. Experienced in Database Modeling & Design with Data Warehouse Concepts

such as Star Schema, BW Schema -Dimensional& Fact tables.

. Proficient in SAP OLTP extractions of LO-Cockpit, Application specific

SD, FI, MM, PP, HR, Generic extraction, flat files and extraction from

DB Connect for legacy data (non SAP).

. Well versed in reporting tools including BEx Query Designer and BEx

Analyzer, using Excel workbooks, Custom Query design, Variables,

Structures, CKF, RKF,selections, formulas, filters, conditions,

exceptions, cell definitions and Ad-hoc Reports using BEx Web

Analyzer.

. Expertise in working with SAP BOBJ Platform such as UDT,IDT, Web

Intelligence, Crystal Reports 2008/2011, Crystal Reports for

Enterprise,QAAWS, Live Office,Xcelsius Designer 2008 and SAP

Dashboard Designer 4.0.

. Skillful in, Basic understanding of ABAP Programming language related

to SAP BW - Customer Exits, Transformation Routines and Data Source

Enhancements.

. Hands-on experience in Data Load Performance Tuning, Query Performance

Tuning by using Partitioning, Aggregates, BI Accelerator, Infocube

Compression techniques, parallel processing of loads and ensuring

timely updated data.

. Knowledge in Data Extraction Transfer Loading (ETL) using SAP BOBJ

Data Services (BODS 4.1) for loading data from non-SAP system to SAP

system.

. Strong Knowledge in HANA Modeling Concepts; In creating HANA

Attribute, Analytical, and Calculation Views, Analytical Privileges,

SQL Functions, Open ODS views, Transient, Composite and Virtual

providers on HANA views, BO Explorer view sets and Webi reports on

HANA Analytical views. BOBJ Universes on HANA Views/Tables.

. Proficient Knowledge with SAP BW 7.3 on HANA,Migration of BW Objects

into In-Memory optimized DSOs &Infocubes and ETL- Data Provisioning

Using BODS 4.0/4.1,SLT & DXCfrom SAP & non SAP systems into HANA.

Excellent knowledge in SQL scripting and CE functions.

Technical Skills:

ERP SAP ECC 6.0, SAP R/3 4.7.

Data warehouse and Reporting Tools SAP BW (Versions 7.4, 7.3, 7.0, 3.5),

SAP BO (Versions 4.1, 4.0 and XI 3.1)

ETL Tool SAP BODS 4.0, 4.1

In-memory RDBMS SAP HANA 1.0

Languages SQL

RDBMS Oracle 9i/11i, MS SQL 2005/2008, MS

Access.

Operating System Windows 2003/2008/NT/XP/7/8

PROFESSIONAL EXPEREINCE:

Startekk Toronto, ON June 2013 - Present

Project: PerformanceKPI

(Outsourced Development & Maintenance projects)

Role: SAP BW/BODeveloper

Responsibilities:

. Coordinating all business requirements gathering efforts with the BW

Project Manager,Designing the data solution to satisfy defined

business requirements.

. Supported ongoing development and enhancements for multiple

businesses.

. Discussions with team members and created business specifications and

data flow diagrams.

. After completion of SAP BI configuration based on SAP BW as source,

creating BOBJ reports on top of BEx queries and presentation of

information in corporate dashboards.

. Successfully IntegratedSAP BW 7.3 with Business Objects 4.0/4.1.

. Used Web Intelligence tool for web based query and reporting.

. Created Technical specifications and standard modeling documents for

BW and BOBJ.

. Installing Business content in BW 7.3 and ECC R/3, Activated data

sources in R/3 for Transaction data and Master Data. Mapping KPIs with

Standard SAP business content and analysis.

. Performed data modeling and developed BOBJ reports for FI, MM, SD and

HR Master and Transactional data.Migrated content from DEV to QAS, DEV

to PRD environment.

. Created BW Infocubes and MultiProviders as per the requirement and

maintained Aggregates and Rollup activities as a part of the Infocube

Management.

. Implemented 0PY_C02, 0PY_PP2 HR Cube and extracted the data from

0HR_PY_1, 0HR_PY_PP_2 & 0HR_PY_1_CE.

. Extracting data from SAP R/3 by using LO Cockpit, Application Specific

and customized Generic Extraction as per requirements.

. Created Universes using IDT (Information design tool) on top of BW

OLAP, Oracle/MSSQL DB tables/views, and Flat files and developed the

Web Intelligence reports, dashboards and deploy them in BI launch pad.

. Developed BEx Queries and defined Calculated and Restricted key

figures, Structures, Variables, Exceptions, Conditions, Filters and

Formulas, for customized reporting using BEx Query Designer BEx

Analyzer & Developed several workbooks.Developed Web

Intelligencereports and dashboards for different operations and KPI's

forHR Personnel &Time Management and Financial data (Payroll) and

analyzed in dimensions.

. Worked with the ERP Consultants in configuring the Enterprise

Structure and Employee Structure as per client requirements as part of

sourcing Personnel Administration data.

. Created and maintained Employee Hierarchy Reports, Employee

Performance Reports using BEX Analyzer.Developed variety of reports

like Employee Joining Report, Working Hours report, Payroll

reports.Generated Payroll periods, Cumulative Periods, & Absentee

Quotas through Reports (RPTQTA00).Utilized Hierarchies in the

reporting to provide drilldown features.

. Maintaining Reconciliation's to verify the data Integrity and data

quality

. Implemented Process Chains for automated master data and transaction

data loads of all modules.Documentation of the project.

. Monitoring of daily, weekly, monthly loads and notifications to

multiple businesses as per requirements.

. Daily support activities - PC monitoring, health checks and status

updates to business users.

Environment: SAP BI 7.0/BW7.3, SAP BOBJ 4.1/ BODS 4.1, and Atos

Service desk tool,Oracle 11g, MSSQL and SAP ECC ERP 6.0.

SHIRO Technologies Dallas, TX Sep 2012 - May

2013

Client: Celanese International

Global GT Project (Development & Maintenance)

Role: SAP BW/BO Developer

Celanese is a global technology and specialty materials company that

engineers and manufactures a wide variety of products essential to everyday

living. As part of the SAP-ERP program, SAP-BI (Business Intelligence) will

be implemented as an Enterprise Data Warehouse. SAP-BI will follow the

Enterprise Data Warehouse approach to become single source of truth at the

corporate level. Existing data marts and Enterprise SAP will feed data to

this Enterprise Data Warehouse enabling centralized reporting and analytics

for Operational, Managerial, Executive and Leadership Teams.

Responsibilities:

. Involved in Design & Development of SAP BI Data Modeling and Front-end

Reporting.

. Data availability dashboard activities in SAP BOBJ.

. Worked with Business Users to determine their reporting requirements

in SD and HR Area.

. (BI 7.0) Performed Data Modeling and Reporting requirement analysis

and creation of queries based on business requirements; Build Info

Objects, Infocubes (Multidimensional, BW Star schema), Data Store

Objects (DSO), Multi Providers, and Infosets.

. Extracted ECC data for Personal Management, Payroll, and Personal

Administration in HR, Delivery, Shipping Document in Sales and

Distribution.

. Worked extensively with Sales Order, Billing, Delivery/Schedule line

and Document condition objects. Enhanced the data sources

2LIS_11_VAHDR, 2LIS_11_VAITM and 2LIS_11_VASCL.

. Worked extensively with Inventory Management using standard data

source 2LIS_03_BF, 2LIS_03_UM and 2LIS_03_BX.

. Extensively worked on building Queries using Calculated and Restricted

key figures, Structures, Variables, Exceptions, Conditions, Filters

and Formulas.

. Designed and maintained Universes using different schemas in the

Oracle Database.

. Created several Crystal reports, Webi Rich client reports and

graphical presentation.

. Created new Universes, Reports and modified existing Universes and Z

-reports in SD/MM/HR.

. Created custom Time hierarchy Year-Qtr.-Mon-Week and Year-Mon-Week in

Universe using BO Designer. Defined Aliases and Contexts to resolve

the join issues in the Universe, Solved the issues such as loops,

traps, cardinalitiesand data mismatch.

. Developed Drill down, Link Report reports, sub reports, used various

Charts and Graphs like Bar Chart (Side By Side, Stacked), Line graphs,

Pie Charts using Web Intelligence Reporting Tool.

. Published and Migrated reports in Development/Test to Production

Domains

. Worked along with Functional & ABAP consultants on various

enhancements projects for existing BW Reports across modules like HR

and FI.

. Worked with Production Support team for performance Improvements of

loads/Reports by creating Aggregates, Indexes for lookup & parallel

processing of loads

. Experience in improving query performance using Query Cache, RSRT

debug and defining aggregates. Improve Loading performance through DSO

staging, created multiple Infocubes, BEx query structure, aggregates,

compression, PSA packet sizing, change log deletion & partitioning.

. Implemented dynamic charts and graphs in dashboards to improve look

and feel using Xcelsius.

. Planning for Nightly data loads for any new Module implemented and

working on various performance initiatives to reduce loading time for

timely data availability.

. Responsible for scheduling reports as email attachments in xls or pdf

formats.

. Trained Business Users to create BEx& BOBJreports.

. Production support activities &ticket resolutions.

Environment: SAP BI 7.0/BW7.3, SAP BOBJ suite 3.x/4.0, BODS 4.0, and

Service desk tool.

Pacific Sunwear, Nov 2011 - Aug 2012

Parsippany, New Jersey

Project: Planner-Reward forExcellence

(Implementation &Support)

Role: SAP BW/BO Developer

Pacific Sunwear is a United States-based retail clothing brand rooted in

the youth oriented culture and lifestyle of California. The company sells

lifestyle apparel, along with footwear and accessories designed for teens

and young adults. The company operated over 800 stores in all 50 states.

Responsibilities:

. Worked extensively on Data warehousing workbench RSA1 (BI 7.x)

. Extensively worked with the business and data analysts in requirements

gathering and to translate business requirements into technical

specifications.

. Coordinating with end-users and business analysts to understand the

scope of business requirements, user expectations, and ensure the

accuracy of reporting specifications

. Created reports using multiple data providers. Created ODS, Infocubes

& Multi-providers and extracted SD data (Data sources 2LIS_11_VAHDR,

2LIS_11_VAITM, 2LIS_11_VASCL) of SAP R3 into SAP BW using LO

Cockpit(LBWE) extraction.

. Worked extensively with Inventory Management using standard data

source 2LIS_03_BF, 2LIS_03_UM and 2LIS_03_BX.

. Involved in different phrases of the project like analyzing

requirement, planning, execution and Maintenance. Worked with Flat

files systems to load data into SAP BI.

. Extensively worked with PSA in Monitoring the Data Transfer from

source systems into BI

. Uploaded master and transactional data from flat files and SAP as the

OLTP source worked extensively on administration workbench (RSA1).

. Created the customized objects using BEx Query Designer according to

the business requirement and Functional Specifications.Worked on BEx

Query Designer & BEx Analyzer by defining Variables, Conditions,

Filters, Exceptions, Calculated key figure, restricted key figures.

. Generated the Business Objects reports involving complex queries, sub

queries, Unions and Intersection.Generated various reports on Daily,

Weekly, Monthly and Yearly basis

. Created complex Universes, Linked with existing Universes from Data

marts. Resolved loops, & created complex Reports, using BO

Functionalities like Slice and Dice, Drill Down, Variables, Filters,

Breaks, Alerts, cross tabs and other features.

. Worked with Xcelsius for creating simple dashboards and simple crystal

reports and convert those into user interfaces like excel files,

PowerPoint representations for better understanding.

. Developed various Reports for Area wise, Regional, National, and

Response Analysis using Crystal Reports / Business Objects. Business

users to use Web Intelligence to create ad-hoc reports as well as view

existing published reports.

. Coordinated with SAP OLTP functional and ABAP Team for Enhancements

through FM &Exits.

. Tested about 80 Business Objects full Client reports in the BOBJ

environment.

. Generating and scheduling standard and Ad-hoc reports using BO and

Crystal Reports.

. Worked closely with technical peers to insure successful integration

of developed applications.

. Participated in developing the Relational Model (Logical & Physical)

and in documentation of technical methods of development as well as

business related information regarding the design process. Created

various validation reports between BW systems and BOBJ system.

Environment: BI 7.x, Business Objects 4.x, Web Intelligence, Crystal

Reports 2011, Oracle 9i, & MS SQL.

Lumbini Elite Solutions & Services Jan 2011 to Oct

2011

Client:Tyco, USA

Princeton New Jersey and Bangalore India

Project:(Global)KPI Product Performance

(Development, Enhancement andSupport)

Role: SAP BW/BODeveloper

Responsibilities

. As a BW developer involved in development activities of the project.

. Redesigned custom cubes to improve reporting performance.

. Integrated all the data in BW using Infosets and MultiProviders to

create reports as per requirement.

. Worked on generic extraction using Table/View to extract data from SAP

R3 ERP system.

. Customizing and activation the Business Content Objects and Loading

the data into data targets.

. Used BEx Query Designer to develop reports and facilitate data

analysis using CKFs, RKFs, free characteristics, Exceptions,

Conditions, Filters, Jump targets (RRI), Structures, formulas and

Variables.

. Gathered requirements from the management for functionality, display

and effectiveness of the reports, Created initial Classes & Objects,

qualification for the Universes in both on/off line modes

. Designed and maintained Universes using different schemas in the

Oracle Database.

. Worked with Xcelsius for creating simple dashboards and simple crystal

reports and convert those into user interfaces like excel files,

PowerPoint representations for better understanding.

. Created cross tabs, Charts, folding, filters, prompts, alerters and

variables in designing reports.

. Worked on SAP Business Objects Data Quality XI to do address

profiling, parsing, standardization, cleansing, matching for master

data such as org structure, customer and vendors.

. Post completion of SAP BI configuration based on SAP BI as source

creating Universes on top of BI queries and developing the BO

dashboards, WEBI reports and placing all this reports in corporate

dashboard and presenting these dashboards through info view to the

management

. Published and Migrated reports in Development/Test to Production

Domains

. Developed complex reports using Business Objects functionality like

Slice and Dice, Drill down, Cross Tab, Master detail and Formulas etc.

. Maintaining Reconciliation's to verify the data in SAP R3 and SAP BW

on monthly and quarterly Basis. Maintained both the Master and

Transaction data for the Infocube created in ERP sources.

. Error Handling on Extraction, Data loading and end user issues on

Reporting.

. Daily Discussions with Team lead, Team members and Modeling as per the

requirements.

Environment: SAP BI 7.x/BW3.5, SAP ECC6.0, BOXI 3.1/3.2, MS Suite,

Oracle11g, and XML-WS.

Circle Consulting Ltd., Feb 2010 to Dec

2010

Client: ALFALAVALBangalore India

Project: (Implementation, Support& Maintenance)

Role: SAP BI/BOAssociate Consultant

Responsibilities:

. Handling BW in SAP ERP Applications.Activated, Installed and Extended

Business Contents based on Gap Analysis established on user

requirements.

. Worked on DWH Workbench: Data Model - Designing & testing of Info

Objects, Infocubes, Data Store Objects (DSO), MultiProviders, Infosets

and Open Hub Services.

. Worked in keeping DSO as staging layer before transferring the

contents to the Info Cube.

. Making all the reporting data targets filled with the Master data and

Transaction data correctly.

. Worked extensively on generic extraction, standard LO extractors,

Installed relevant SAP business content. Used LO Data sources for

extracting sales order, delivery billing information and scheduled

data extractions in LO cockpit.

. Worked along with ABAP Developers in Enhancing Standard Extract

structures with Sales Order, Billing, Delivery/Schedule line and

Document condition objects. Enhanced the data sources 2LIS_11_VAHDR,

2LIS_11_VAITM, 2LIS_11_VASCL, 2LIS_11_VDITM and 2LIS_11_VAHDR as per

user requirements on SAP ECC ERP.

. Used BEx Query Designer to develop reports and facilitate data

analysis using filters, navigational attributes, calculated and

restricted key figures.

. Communicated with ABAP Team for Enhancements through user Exits in BEx

Query Designer.

. Designed and maintained Universes using different schemas in the

Oracle Database

. Created several Crystal reports, Webi Rich client reports and

graphical presentation.

. Created new Universes, Reports and modified existing Universes and

reports

. Detected cardinalities, loops, and checked the Integrity of Universes

. Created custom Time hierarchy Year-Qtr.-Mon-Week and Year-Mon-Week in

Universe using BO Designer

. Worked on all advanced reporting features in WEBi XI like Drill Down,

Drill Up, Breaks, Scope of Analysis, Ranking and report level variable

based filtering to create complex reports.

. Created the customized objects according to the Functional

Specifications.

. Updating the data load status and sending the status of the loads

every hour.

. Handling Change request, data load details and designed Process Chains

to trigger Multiple Data Loads.

. Analyzed, designed, developed and tested reports while working

directly with end-users and technical members of the team

Environment: SAP BI 7.x, BEx, SAP ERP ECC 6.0, SAP BO XI 3.1, MSSQL,

Oracle11g, XML-WS,

SHIRO TechnologiesInc.,May 2009 to Jan 2010

Client: Multiple Business Verticals

Dallas Texas and Mysore India

Project: OTC, PTP, FIAR/AP Reports

Role: Business Analyst

Responsibilities:

. Responsible for conducting workshops, requirement documentation, design

and configuration of Sales Order process (OTC), (PTP) and configuration

changes in Logistics and Execution.

. Involved in the requirement gathering for floor care, production planning

& supply network planning,

. Instrumental in preparation of Blue print and data flow diagrams.

. Designed Functional and Technical Design according the Project

Requirements.

. Involved in activating SAP Business Content objects and prepared custom

objects where necessary.

. Developed Custom BI Queries likeActual vs planned production quantities

reports as per Customer Specific requirements.

. Involved in show and tell of BI reports to the end users.

. Involved in preparing the test scripts, designs and test execution in

testing tool.

. Involved in product test by running the test scripts.

. Client Liaison & Documentation, Internal and External presentations.

. Technical mentor to team members.

. Understanding and ensuring implementation of quality standards (QMS)

. Transforming, migrating, validating and reconciliation of data.

Environment: Microsoft Business Suite, Oracle9i, MSSQL 2005, SAP Business

Objects XI R2/R3, MS Excel Based Reporting and Crystal Xcelsius Dashboard

Designer.

Contact this candidate