Srinivas Perumandla

Email id: acta7t@r.postjobfree.com

Ph no: 415-***-****

SENIOR SAP BW/BO/BPC/HANA CONSULTANT

Summary:

** ***** ** ******** ************ experience which includes SAP BW/BI, SAP Business Objects,SAP BW on HANA and SAP BPC . SAP BW/BI Analyst and Implementation experience for various applications includes SD, MM,HR,FI Modules (AP, AR). Strong experience in SAP ABAP/4.

Techno-functional experience which includes Project Plan Preparation, execution of project plan, configuration of BI System, Modeling, Activating /enhancing Standard objects of Business Content, Installing BI Administration Cockpit, developing InfoObjects, InfoCubes, DSO, MultiProviders, Update Rules, Transfer rules, Infosources, Transformation, DTP, Process Chains, Generic datasources, custom exits, routines, enhancing data sources, queries, reports, Unit Testing, UAT test plans, Documentation, authorization objects and security roles. Very good knowledge of Open Hub Destination, Document Management, Net Weaver, Data loading from SAP, Non-SAP systems and other third party tools like SSIS and BEx Analyzer, Web Analyzer, Query Designer, User interface to other reporting tools.

3 Years of Business Objects experience which includes Integration of BO with SQL Server, Oracle database, Teradata, Universe Design, Webi, Dashboards, BI Launchpad and Analysis.

16 months of SAP HANA Techno-Functional experience that includes migration of SAP BW to SAP BW powered by HANA, creating and administering Composite InfoProviders, Transient Infoproviders and Virtual Infoproviders.

Experience in developing BPC EPM reports,Input Schedules and data loads from BW to BPC .

Extensive knowledge in multiple upgrade projects of SAP BW Systems from BW 3.x to BI 7.0.

Contribute to the full project life cycle ( Project management, design, development, testing, training etc. ) to ensure the delivery of BI projects is on time and to budget.

Actively participate within the team to support other team members as required. Share ideas and provide advice, guidance, assistance to others within the team in order to develop the capability of the team and self.

Production system support, regression testing, reconciliation and monitoring of monthly releases of new development into production.

Good understanding of data visualization dashboards creation in Tableau.

Primary Skills

Datawarehouse : SAP BW / BI – 7.x

SAP Business Objects BI 4.x

SAP BPC

SAP ECC 6.0/ 5.0, SAP R/3 4.7

Secondary Skills

ETL Tools - SAP BODS

Web Technologies - HTML, MS Visual Basic.

Databases - SAP HANA,Oracle, SQL Server,Teradata.

Professional Experience :

eBay Inc - SanJose,CA Mar 2015 – Present

SENIOR SAP BW/BO/BPC/HANA CONSULTANT

2C Split( Two Company split project) is the separation process of systems related to eBay and PayPal .As part of this project, we have made a system copy of eBay systems,removed eBay related company codes data and handed over the systems to PayPal .

eBay Enterprise Split is separation project for which new controlling area 9800 was created and all the new queries developed for the business were updated with the new controlling area.

BPC FP&A Phase 2 – New account based layer is created with the updated MRA objects,optimization of data flow and new reconciliation workbooks are developed as part of this project.

SAP BI Cosolidation Project is the on going project to consolidate the different SAP BW systems and Reporting systems across landscape .

Responsibilities:

Developed backend BW objects and updated BPC EPM Report for FX Modeling which is used for planning.

Translated business requirements into SAP functional requirements and created Functional Design Specifications.

Enhanced BPC EPM Headcount Driver Input Template .

Created reconciliation workbooks to compare data in different systems across SAP BW andscape and BPC.

Optimized data flow for the Market Places Core Revenue objects to minimize data load time in BPC.

Performed end to end system validation for the new SAP BW 7.4 system and BOBJ objects.

Developed BEx reports for eBay Enterprise Split project and coordinated UAT .

Prepared BOBJ Transport guidelines document which will be useful for collecting BOBJ objects using the CTS+ method.

Fixed long running Headcount report issue for user.

Develop custom hierarchy for PayPal 0Costcenter hieararchy from SAP MDM system to reflect the new P & L statement.

Monitored the cutover activities during the system copy of eBay for Mock PayPal systems.

Validated the data in PayPal system after the system copy

Resolved the defect raised by the testing team during the validation of Mock systems.

Coordinated UAT for the new PayPal P &L report using HPQC application.

Remodelled IP Foundation infocube by adding new infoobjects and modified ABAP code to populate new objects and refreshed respective HANA objects.

Monitored Inbound and outbound jobs related to Interfaces like KHALIX, NEOFLEX and BANK SLA.

Dropped data related to eBay from PayPal boxes using selective deletion.

Handled Branding project to update the new logos in BOBJ reports across BI applications in eBay and PayPal.

Environment : SAP BW Powered by SAP HANA, SAP ECC,SAP BOBJ and SAP BPC

Target Corporation-Minneapolis,MN Oct 2014 –Jan 2015

SENIOR SAP BW/BI/BO/HANA CONSULTANT

Target has been using SAP BW for maintaining its EDW and reporting with Oracle as the backend database and it planned to move from SAP BW to SAP BW powered by SAP HANA.

Responsibilities:

Requirement gathering, WBS, Project planning.

Upgrade of SAP BW 7.31 SP03 to 7.4 SP05.

In-memory optimization of SAP BW to SAP HANA.

Optimization of SAP BW Objects POST Migration.

Failover Scenario for Production High availability.

Query Optimization/Performance test.

Data migration from /POSDW/TLOGS to /POSDW/TLOGF.

Worked on SAP HANA Attribute Views, Analytic Views, Calculation Views, Analytic Privileges and Procedures.

LSA ++ Optimization.

Production after care support – Upgrade and Migration.

Environment : SAP BW Powered by SAP HANA, SAP ECC.

Covanta, Morristown, New Jersey Feb 2014 to Sep 2014

SENIOR SAP BW/BI/BO CONSULTANT

Covanta is one of the leading recycling, renewable energy and waste management companies. Covanta puts waste into action, transforming it into high quality recyclables, raw materials and energy.Each year Covanta transforms over two million tonnes of materials into high quality recyclate, and yet more into over 760 gigawatt hours of renewable energy. Covanta is implementing SAP BW to report on the functional areas like FI, PP and HR which are in SAP ECC.

Responsibilities:

Testing Post SAP BW 7.3 technical, functional upgrade, SP08 implementation and system is ready for HANA implementation.

Prepared Functional Specifications, Technical Specifications and Unit Test Cases for SAP FI(New GL, AP, AR, AA) and HR.

End to end development of BW HR modules like Personnel Administration, Payroll,Time Management and Organizational Management and development of SAP BO WebI reports.

Developed ABAP based customer exit variables to pass the values to the report.

Installed BI content and developed end to end data flow objects.

Developed webI reports on top of SAP BW Bex reports .

Collected BW objects to transport requests.

Perfomed data reconciliation between ECC and BW

Unit Acceptance Testing is in process.

Developed Open hub objects to generate and save PO, Sales Order, BOM, Inventory files on Application server directory where customer access get pull data in files.

Developed new DSO, InfoCubes to store customer specific data.

Enhanced existing InfoProviders, transformation process to fill the gaps and meet customer requirements

Gathered customer requirement, Analyzed, prepared functional specifications, technical specifications.

Environment: SAP BW BI 3.x/ 7.3, SAP BW, NetWeaver 7.0, BEx Web Analyzer, Query Designer, SAP ECC 6.0 (FI/CO,SD, MM, HR).

Coca-Cola Refreshments, Atlanta, GA Feb 2013 to Jan 2014

SENIOR SAP BW/BI/BO CONSULTANT

Coca-Cola offers a special pricing to some whole sale gaints such as Samsclub in US which will be controlled by process defined by the CCR management and they analyze pricing information using SAP BO reports defined on Vendor Manged Pricing (VMP) system which is built on Oracle OLTP system.

Responsibilities:

Worked on some changes in the schema of Vendor Managed Pricing module.

Developed the Universe and ad hoc reports using Business Objects Web Intelligence.

Developed webI reports on top of SAP BW Bex reports, Oracle and Teradata as source.

Developed dashboards based on the static data source.

Created reports using Desktop Intelligence functionalities like Sections, Breaks, Filters, Alerters, slice and dice, drill down functions and formulas etc.

Created linked reports for WEBI reports using open document functionality.

Used variables for building complex BI report columns.

Migrated BO components from Dev to Quality and to Production.

Performed and coordinated System Integration Testing (SIT) and User Acceptance Testing (UAT

Environment: SAP BO 4.0.

Coca-Cola Refreshments, Atlanta, GA Mar 2012 to Jan 2013

SENIOR SAP BW/BI CONSULTANT

This was an implementation of SAP BW HR related custom modules to monitor employees performance which was extracted from legacy systems to SAP BW.

Responsibilities:

Worked in BW-HR module of CCR to provide information about the Employee appraisals (Current/ History) and Performance management metrics through the reports : Performance Ratings - Current & History and Performance Management Metrics.

Performance Management Metrics - Competencies Rating Distribution.

Creation of custom datasources based on ECM infotypes.

Worked on BEx query creation/ changes, bookmarks in AR AP project.

Prepared technical specification document for Talent acquisition and ECM Objects.

Developed Open Hub Destination objects to export data from CCR to KO systems.

Developed process chains to include the new data load objects.

Validated the sync up process of objects in two development servers.

Environment: SAP BW 7.0

British American Tobacco,SFO,CA. Aug 2011 to Feb 2012

SENIOR SAP BW/BI CONSULTANT

British American Tobacco is the world's most international tobacco group, with quality brands sold in more than 180 markets and a responsible approach to doing business from crop to consumer.

Responsibilities:

Fixing post go-live defects and supporting.

Post go-live user support, production support, enhancements

Exposure to Business Objects 4.0 features in Analyzing new feature and tools.

Tested and validated data in Quality Systems.

Unit test, Packaged and moved all developed objects from development system to Quality system

Developed InfoProviders for Finance (New GL, AP, AR, AA), HR and integrated reports

Developed data load process in BI to load data from ECC systems and exporting data into non-SAP systems

Prepared Functional Specification, Technical Specifications and Unit Test Cases for SAP FI/CO (New GL, AP, AR, AA), MM, HR ( Pay roll, Personnel Administration, Org Management, Time Management, Benefits ).

Gathered As Is business processes, Reports soft copy, hard copies and documents,Business Critical Reports requirement from Business Functional specialists.

Created routine based transformations using ABAP code.

Worked with business users and team leads to develop system requirements, analyze data element and continuous end-user support. Designed Industry standard business requirement document for the reports and involved in the requirements gathering process for the reporting environment.

Developed manuals and provided training on how to create ad-hoc reports to the users.

Environment: SAP BW BI 7.1, NetWeaver 7.0, BEx Web Analyzer, SAP ECC 6.0 (FI/CO,MM,HR/HCM).

The Babcock & Wilcox Company, Charlotte,NC Aug 2010 to Aug 2011

SENIOR SAP BW/BI CONSULTANT

B&W NOG is a multi-million dollar operating segment of the worldwide energy services provider .B&W's Nuclear Operations Group is responsible for designing, manufacturing, and delivering products and components for Department of Energy programs, many of which are vital to the United States' national defense efforts. B&W is implementing SAP ECC (FI/CO, P2P,Q2C,HR), CRM, BI software packages for their global business processes, reporting and prepared Blue print documentation.

Responsibilities:

Migrated queries and workbooks from SAP 3.5 to SAP BI 7.0 version.

Copy queries from cube to multiprovider and developed workbooks on the MP .

Develop new queries on infocube and multiproviders as per client’s requirement.

Prepare technical specifications from functional specifications.

Created generic datasource by using function module to extract data from different tables in ECC.

Created DSOs and multiproviders for loading and reporting purpose.

Enhanced datasources to include new columns in the report.

Moved transport requests from one system to other.

Performed the role of PMO to coordinate with the team members working in different locations.

Participated in the daily & weekly client calls and send status mails.

Users support and Production support after go-live.

Developed Snapshot model for Inventory Management, FI-AR Aging Reports.

Developed InfoProviders for Finance (New GL, AP, AR, AA), HR, SD, PP and integrated reports

Develop data load process in BI to load data from non-SAP systems and exporting data into non-SAP systems

Activated Business content objects and datasources in SAP BI, ECC systems

Prepared Functional Specification, Technical Specifications and Unit Test Cases for FI/CO (New GL, AP, AR, AA)

Gathered Business Critical Reports requirement from Business Functional specialists

Organized BI workshops and participated ECC Blue Print Process workshops

Worked with business users and team leads to develop system requirements, analyze data element and continuous end-user support. Designed Industry standard business requirement document for the reports and involved in the requirements gathering process for the reporting environment.

Developed manuals and provided training on how to create ad-hoc reports to the users.

Environment: SAP BW BI 7.1,NetWeaver 7.0, BEx Web Analyzer,, SAP ECC 6.0 (FI,PA,SD,IM, PP,HR).

Nestle GLOBE (Alert Tool Management) Jan 2010 to Jul 2010

SAP BW/BI CONSULTANT

Nestle is the Platinum Client of SAP. Nestle has established a global business improvement program called GLOBE which enables the efficient functioning of their business worldwide. Nestle is one of the largest food company having factories in 85 countries Alerting is a Nestle tool designed to raise alerts related to BW/SEM data loads and dispatch them for resolution. Alerts are raised for errors in PC steps, long running check of SAP tables RSPCLOGCHAIN and RSPCPROCESSLOG based on APD running at regular execution and chains that are not started on time. Parameters for alerting are maintained via transaction YALERT_MAINTAIN (customized transaction for Nestle).

Responsibilities:

Develop APD jobs based on ABAP custom code and schedule the APD jobs which are used to generate alerts.

Configure steering tables with the accurate process chain parameters.

Perform testing of new alerting functionalities developed by Onsite Development team.

Suggesting solutions to the onsite coordinator for fixing bugs in implementation of alerting.

Dispatching of alerts to the production and preproduction monitoring teams and review the issues experienced by team members in working with alerts.

Configure the table YGTTC_ALERT_EVEN which is used to develop relationship between time based chains and event based chain.

Send status mails to BI OPS heads on alternate days about the progress of the tool and communicate through conference call on weekly basis.

Cross check the performance of the tool against the report availability at end of the day.

Environment: SAP BW 3.5, SAP BI 7.0.

Nestle GLOBE Jan 2009 to Dec 2009

SAP BW/BI CONSULTANT

Production monitoring team monitors daily data loads from R/3 systems, SEM-BPS, APO, CRM

and flat files. Need to monitor the BW and SEM-BPS production boxes of three Zones AMS, AOA

and EUR. Follow the SLA of 95% of Report availability every week. Update the status of Reports

to Onsite BW team and markets providing all the technical details.

Responsibilities:

1st Level IM Resolution Team (Offshore).

IM tickets in Production and Ad hoc activities,

Selective deletion from specified targets, Aggregates deactivation and rebuilding, Flat file loading, Setup table filling, Monitoring tickets

Execution of requests raised to offshore (From onsite team – to include instructions) (RMs)

Housekeeping, Proposing resources for weekend activities, Planning weekend activities, Follow up and technical support.

During import all (Prod and Pre-Prod), assist with PMA’s (Pre-Manual and Post-Manual Actions).

Providing technical support to resources in addition to Production and Pre-Production. Monitoring teams for the problems in data load monitoring.

Reviewing tickets before resolving and reassigning.

Environment: SAP BI 7.0,SAP BW 3.5

Nestle GLOBE Oct 2007 to Dec 2008

SAP BW CONSULTANT

Production monitoring team monitors daily data loads from R/3 systems, SEM-BPS, APO, CRM

and flat files. Need to monitor the BW and SEM-BPS production boxes of three Zones AMS, AOA

and EUR. Follow the SLA of 95% of Report availability every week. Update the status of Reports

to Onsite BW team and markets providing all the technical details.

Responsibilities:

2nd Level support as member of Production monitoring Team (Offshore).

Monitoring of Data Loads (Master data & Transaction data) from various source systems like R/3, CRM, SEM and APO into BW and SEM.

Analyzing the errors in the data loads and report to the corresponding team.

Managing master data, texts and hierarchies.

Performing the data targets by having the correct and up-to-date data like

Reconstructing the data requests from PSA in case of data load failures.

Roll up of data from Info Cubes to Aggregates

Compression

Raising the requests for analyses and solutions in case problems are not in the scope of Production monitoring.

Updating of Report availability for each market as per documented instructions

Scheduling and editing of Process Chains.

Error handling

Client Discussion, Co ordinate with the onsite team to resolve issues to meet client defined SLA's.

Mentoring

Participation in knowledge transfer sessions.

Environment: SAP BW 3.5, BI 7.0

AIG Global Investment Group, NY Mar 2007 to Oct 2007

Position: SAP BW Consultant

We replaced the existing Non-SAP reporting system with SAP BW System.

Responsibilities:

Developed process chains, Queries and preparing Functional Design Specifications

Analyzing InfoProviders to fine tune the data load performance, query performance.

Developed Data Transformation Process to load Budget Information, Standard Transformation Process.

Developed InfoCubes FI-GL, AP, AR Line items and Project Systems, MM(Purchase)

Activated BI Content objects (Infoobjects, DataStore, InfoCubes, Queries) for FI-GL, AP and AR (Purchase),SEM-BCS application components in NetWeaver2004s(BI 7.0)

Activated FI-GL, AP and AR data sources.

Developed FI-GL Line Items InfoCube, G/L Analysis Reports in SAP BW 3.5 and demonstrated them to Business functional specialists.

Installed and Activated BI Administration Cockpit

Developed security model to access SAP BI data and run reports

Project Planning and execution

Global Solution for SAP Project which is implemented for Various Business Units across the world

Prepared SAP BW architecture document and reviewed with Business Team.

Collected existing sample reports, scanned hard copies, tagged them saved on shared folder for review. Reviewed all existing reports and source systems information.

Organized workshops about the SAP Business Intelligence System functionality, reporting features to Business Functional specialists.

Worked with business users and team leads to develop system requirements, analyze data element and continuous end-user support. Designed Industry standard business requirement document for the reports and involved in the requirements gathering process for the reporting environment.

Developed manuals and provided training on how to create ad-hoc reports to the users.

Environment: SAP BW 3.0B/7.0

Geller & Company, New York, NY Dec 2006 to Feb 2007

Position: SAP BW Consultant

Developed data model, process control, reporting for FI/CO information which includes GL, AP, AR, AA.

Responsibilities:

Performance tuning by checking/deleting/repairing/building Indexes, maintained the aggregate table indexes.

Database statistics are used to optimize the query performance.

Testing SAP BW and SEM components and delta process with different scenarios before upgrade and after upgrade from SAP BW 3.5 and SAP R/3 4.6C to mySAP 2004.Supporting Production and Users to resolve day-to-day issues.

Designed, Developed, Tested POC for FI Asset Accounting in SAP BW and loaded data from MS SQL database by using DB connect.

Modified existing FI AP, AR, GL, SL line Items Data Architecture, Master Data to improve performance and resolved data loading issues.

Designed, Developed and implemented InfoSpokes using Open Hub service to load data into flat files and Inventory Evaluation.

Designed, developed and implemented Process chains to load fixed assets, G/L Line Items, AP Line Items, Master Data, Hierarchies and Billing data.

Created customer exits for variables using ABAP code.

Designed, developed, Tested and Implemented full life cycle FI GL, AP project in SAP BW using Standard Business Content objects and customized objects like InfoCubes (Basic, Transactional), ODS (Standard, Transactional), InfoObjects, InfoSets, MultiProviders, Queries, workbooks, Web reports, Roles to meet the Business Requirement.

Modified existing Authorization Profiles for SAP BW.

Environment: SAP BW 3.0B/3.5.

Hanes Brands Inc., Winston Salem, NC Jan 2006 to Nov 2006

Position: SAP BW Consultant

Responsibilities:

Designed, developed, implemented and published financial reports using BEx Analyzer, Web Browser, Web Application Designer.

Created InfoSpoke using Open Hub service to retract data from BW to SAP R/3 system.

Created process chain to run the jobs in sequence.

Configured the business requirements specified in the Business Blueprint phase in the related system landscape

Did customizations of data sources, ETL, and data modeling for FI/ special purpose ledger application component.

Developed InfoCubes for FI-SL actual/plan data..

Designed, Developed and implemented full life cycle project which includes data modeling, ETL, Data sources creation at SAP R/3 for FI AP application components.

Environment: SAP BW 3.5, BEx Analyzer, SAP R/3 4.6B,

Education:

Bachelors in Computer Science and Engineering.

Contact this candidate