SAP BW HANA BOBJ

Srikanth Sirineni

SAP BI/BW Lead/Developer

Mobile: 480-***-****

Email: acyvh1@r.postjobfree.com

Over 15 years of IT experience including 13 Years of experience in Design, Development, Implementation and Production Support for Business Applications in SAP Business Intelligence/Warehouse (BI 7.X/3.X) with SAP R/3 (4.X/ECC 6.0),EIC,APO,HSE, SRM, xRPM and Business Objects 3.X/4.0

Highly experienced in working with following Reporting Tools

SAP BW 7.X, Bex, WAD

SAP HANA, S/4 HANA, FIORI

BOBJ 3.x/4.x, Webi, Design Studio, IDT, CMC, Analysis for Office

SAP Lumira, Tablue

BO-DS

Highly experienced in conducting user training sessions and preparing user training material

Extensive experience in creating Dashboards using SAP BI WAD, Business Objects (BOXI 3.X/4.0) Webi, Xcelsius and Live Office

Working as BI technical architect and on-site technical lead and managing 11 BI Consultants

Experience in working with offshore teams in multiple geographical locations

Extensive experience in Modeling, Data Extraction/Loading (ETL), Reporting, BO3.x/4.X reporting, Web Application Designer (WAD), Portal Reports, Analysis Process Designer (APD), Open Hub destinations, Information Broadcasting, BI Admin Cockpit

Extensively worked on HP Quality Center for uploading BW Test Scripts

Experience in working with HANA studio and creating HANA views

Experience in working with SLT replication

Author of multiple BI articles which were published in BI Expect online magazine

Proficient in Business Objects Reporting using Web Intelligence, Crystal Reports and Webi Rich Client, in building OLAP universes and Connections

Experience in working with RapidMarts and DataServices(BO-DS)

Extensively worked in designing/creating InfoObjects, InfoCubes, ODS/DSO Objects, InfoSets, Multiproviders, DTP, Transformations, Data Sources, InfoPacakage, InfoSources, Transfer Structures, Communication Structures, Process Chains, Transfer Rules, Start Routines, End Routines, Rule Groups, Update Rules, BEx Query Designer, BEx Analyzer, Views, Work Books, Calculated and Restricted Key Figures.

Highly experienced in developing query objects including restricted key figures, calculated key figures, Structures, RRI, Jump Queries, user entry variables, replacement path variables, customer exit variables, SAP exit variables, and authorization variables.

Highly experienced in upgrade of SAP BW Application from 3.1 to 3.5 and upgrade to BI 7.0 and from BI7.0 to BI7.03 to BW7.4.

Extensive experience in working with Redwood Cronacle to schedule loads

Worked on End-to-End life cycle projects starting from Requirement gathering from the business users and delivering the Reports.

Worked extensively in creating objects in HR, HR-EIC, PS, SD, MM and FI/CO functional areas and LO Cockpit, Set up tables and generic data extractions

Pfizer Pharmaceuticals, PA July’16 to Till Date

Environment –BI 7.4, HANA 1.0, BOBJ 4.1, ECC6, Design Studio,

Analysis for Office.

Leading the team of 11 BI consultants

As part of LeapFrog dashboard development

Worked closely with Auditing Business Users, Process Owners and Solution architects during requirement gatherings and development phase

Played key role in presenting various design options during the design phase

Played key role in creating and assigning Tech specs, Test scripts, and reviewing and routing for approval

Actively involved during the HANA upgrade in testing Leapfrog application

Played key role in developing complex interfaces for extracting BI data

Actively involved in creating KT documents and user training documents

Worked constantly with Pfizer BI Architect in delivering the application

Actively worked with team in resolving defects identified during SIT and UAT

Actively supported GO-LIVE and hyper care periods

Actively involved in identifying objects and finalize the scope for Phase 2

Created multiple HANA Views as part of data reconciliation program

Eli Lilly and Company, IN Nov’13 to June’16

Environment –BI 7.3/7.0, BOXI 3.X/4.0, ECC6

Developed SPLMRA target for Corporate Management system based Special Purpose Ledger data in ECC

Created required base data targets and Multi Provider

Closely working with Basis team to integrate SLT replication for real time data

Created multiple Bex Queries as per business requirement

Created BICS connections and and Webi reports

Successfully implemented Solution in BW to replace IBM CDC technology for SpotFire system.

Created DataSource in BW based on Purchasing, Accounts Payable and Vendor master data for SpotFire system

Complex start routines and End Routines were created to take care of Currency Conversion, Unit of Measures, Texts for master data

Successfully implemented BW Query migration project from BW3.X to BI7.X.

Worked closely with SAP for migrating more than 2000 queries, 500 workbooks and 150 Web Templates.

Worked closely with Business for unit and integrated testing after migration.

Deleted unused queries, Web Templates and Workbooks using BI statistics

Designed and Developed multi dimensional data models for HR targets like

Global Headcount & Actions

Staffing, Employee Previous Information

Pay Roll

Emergency Contact Information and Teams

Led upgrade projects for upgrading from BW 7.0 to BW7.3 and from BW7.3 BW7.4 systems

Resolved many upgrade related issues by working closely with SAP, Basis and Security teams

Applied critical OSS notes as recommended by SAP

analyzed obsolete functions using SAP_QUERY_CHECKER report and took corrective actions as per SAP’s recommendations

Responsible for creating BO objects like

OLAP connections(BICS) using Information Design Tool(IDT)

Webi Reports using BW queries

Scheduling Webi reports using Launch Pad

Enhanced Billing and Pricing Conditions data flows to add new Partner functions which enable business to report on third party agency order data.

Developed multiple reports for Clinical Grants customer group.

Developed BW custom extractors for Business Objects Data Services(BODS) and created multiple data flows in BODS

Created custom program to remove invalid characters for multiple data loads

Worked closely with Lilly power users/Business users in gathering requirements for new reports and enhancing existing reports.

Created process chain for Information Broadcasts settings which helped in saving lot of time when scheduling/unscheduling the broadcast.

Actively involved in creating/changing test scripts using HP QC

Pall Corporation, New York Jan’13 to till Oct’13

Environment –BI 7.3, BW.3.X, BOXI 3.X/4.0, ECC6

Involved in requirements gathering, developing and testing of CO-PA Margin Report for Financial executive team

As part of Margin Report Development, Created CO-PA DataSource(1_CO_PA_01) on ECC and loaded data for relevant data targets in BW

Installed 0CO_PC_PCP_01(Product Cost Planning - All Cost Estimates) datasource from Business Content and enhanced with Costing Dates information

Created Start Routine and End Routine for CO-PA data target to read Material Unwound values from Product Cost DSO when Unwound values are not present in CO-PA DataSource

Created Backlog Margin Report to show Open Orders with Planned Price. To achieve this created APD to read data from existing query based on Sales Cube

Created Month End Inventory Snapshot Report with Unwound Cost information for given Material and Plant. To achieve this created Multi Provider based on Inventory Cube and Product Cost DSO

Created OLAP Universes and required connections based on BW7.x Queries

Created multiple Webi Reports based on CO-PA Margin Report

Used Constant Selection in Query to suppress unassigned result rows issue

Created BI 7.X web template to show multiple versions of CO-PA Margin Reports

Used Information Broadcaster tool to broadcast report to executive team members

Eli Lilly and Company, IN Jun’08 to Jan’13

Environment –BI 7.3, BW.3.X, BOXI 3.X/4.0, R/3–4.X/ECC6, xRPM–4.0, HSE 2.0

Involved in Data-modeling, Data Extraction, Generic Extraction, Data Loading, Scheduling, Monitoring and Reporting for the MM, SD, HR and FI/CO modules.

Extensively worked with Purchasing(ZPUR_C01), 0CO_OM_CCA_4, Billing, CO-PA, FI-SL, CCA cubes in solving the customers’ issues and creating new reports

Enhanced Global Headcount cube and affiliate cubes with Shipping Address, Security Set, Global Id, Name of Chief, Position of Chief etc.

Enhanced Global HR Actions and affiliate cubes with Ethnic Origin, Military Status, Salary Committee, Hire date, Position Entry Date etc.

Developed new InfoCube for Employee Emergency Contact Address and Employee Contract Elements Information in HR module and all corresponding components like InfoObjects, InfoSource, Datasource, Transfer rule, Update routines, Start routine and queries and web queries for end users.

Enhanced 0PERSON_ATTR to pull the details like Employee SSN, Last Name, First name and Middle Name and Permanent Address.

Enhanced 0EMPLOYEE_ATTR to bring information like Building Number, E-Mail address, and work state.

Actively involved in developing Executive dashboard using Xcelsius, Webi reporting, Live Office and SAP BW.

Created multiple OLAP universes on BW queries to fulfill dashboard requirement.

Changed multiple existing Webi reports as per the customer requirement for dashboard.

Developed complex reports in EHS module using BI7.X query designer and Report designer tools

Expertise in application specific LO cockpit, CO-PA, FI-SL, generic data extraction from SAP R/3

Resolved many issues around the Upgrade. Created OSS messages for Upgrade issues and actively worked with SAP to resolve the issues.

Hands on experience in using Report Designer and Business Objects tolls.

Actively worked in configuration Portal iViews for BW Reports

Extensive working experience with information broadcast tool

Designed and Developed the Average Head count, Monthly view of employee

Created Aggregates on Info Cubes to improve the query performance.

Computer Associates (CA) Int. Jul’07 to May’08

Environment – BW3.5, BI 7.0, R/3 – ECC6

Created BI Dashboard for Project systems module for higher management to keep track of all the projects running in CA.

As part of creating dashboard, involved in creating InfoObjects, Infosources, Infocubes, Multi Providers, Infoset and all other infrastructure changes.

Using Web application Designer, designed many web reports, templates, Graphs, Uploading logo, Icons, Style sheets, creating tabs etc.

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.0

Migration of the Web Templates from 3.5 from 7.0.

Involved in the Pre Upgrade & Post Upgrade Activities for BI Plug-In Upgrade on the R/3 from 2003.1 SP 10 to 2004.1 SP 12

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.

Actively involved in creating default web template

Using BEx Query Designer, created many queries using pre queries, filters, variables, calculated Keyfigures/Restricted Keyfigures, Exceptions, and Conditions etc.

Created Master Data and transactional Infosources for uploading attributes and texts.

As part of upgrade team, involved in migrating many BW 3.X queries to BI7.X

Worked closely with SAP to resolve upgrade issues.

Created multiple Generic Data Extractors to create Data Sources for transaction and master data.

Eli Lilly and Company, IN Aug’03 to July’07

Environment – BW.3X, BI 7.0, R/3 –4.X/ECC6, xRPM – 4.0, HSE – 2.0

Extensively worked with CO-PA, FI-SL, CCA, Billing, FI-AP, AR, GL cubes in solving the customers’ issues and created reports for customers.

Using CCA cube, created new report to find out top vendors and their classification data for specific period.

Using M2 cube, created a report to find out Product Sales per month in particular company code, and comparing the same with prior year sales.

Using CO-PA cube, created a report to find out free Goods Report.

Involved in Data-modeling, Data Extraction, Generic Extraction, Data Loading, Scheduling, Monitoring and Reporting for the MM, SD, HR and FI/CO modules.

As part of load monitoring team lead, responsible for migrating, InfoPackage Groups, Event Chains into Process chains and troubleshooting the issues.

Involved in gathering requirements from user, creating Functional specs, Technical specs, Test plans, end user training.

Extensively worked on BEx Query Designer in designing many queries using pre queries, filters, variables, calculated Keyfigures/Restricted Keyfigures, Exceptions, and Conditions etc.

Extensively worked on Web application Designer in designing many web reports, templates, Graphs, Uploading logo, Icons, Style sheets, creating tabs etc.

Hands on experience in using Information broadcasting and Reporting agent tools.

Installed complete Business Content for SAP xRPM 4.0(SAP NetWeaver BI 7.0) and necessary changes to InfoObject, DSO, Cubes, Infosources.

Migrated good number of BW queries from 3.5 to 7.0 and solved issues while migrating.

Created new web reports for Business users using new graphs available in BI7.0

Used Information broadcasting tool to publish web reports in HTML and PDF formats to end users.

Using CCA cube, created new report to find out top vendors and their classification data for specific period.

Using M2 cube, created a report to find out Product Sales per month in particular company code, and comparing the same with prior year sales.

Using CO-PA cube, created a report to find out free Goods Report.

Enhanced Delivery cube with One-time account, Final Ship-to Party Information, Delivery Street, Delivery city fields etc.

Worked on Billing cube and enhanced with Billing Overall Status, Batch Number and Billing Cancellation Flag.

Created new reports in Bex using report designer tool.

Actively involved in developing Training and Events InfoCube in HR module.

Involved in Data-modeling, Data Extraction, Generic Extraction, Data Loading, Scheduling, Monitoring and Reporting for the MM, SD, HR and FI/CO modules.

Solved complex issues in data load monitoring.

Other miscellaneous areas of work include activation of BW Statistics cubes, extensive working with hierarchies and loading.

Contact this candidate