Resume

Sign in

Sap Data

Location:
India
Posted:
September 26, 2018

Contact this candidate

Resume:

Profile:

Over all **+ years of I.T, experience in SAP BPC10.1, SAP BPC 10, BW/BO MAINFRAME and TESTING Includes 5 years of U.S.A experience.

Over 3 years of experience in SAP BPC 10.1 embedded SAP BPC standard 10.0, and 3 years in SAP BW 7.0, 7.3, 7.4, 7.5 and SAP BO.

Good working knowledge on SAP BPC 11 embedded.

Good knowledge on SAP IBP

Technical:

Data Warehouse : BW 7.0, BW 7.3, BW7.4, BW 7.5

ERP Integration : SAP ECC 6.0

Reporting Tools : SAP BEX Reporting, BO 4.1, Analysis for Office, Crystal Reports

SAP BPC10.1, EPM 10.0.

Worked on Tools : SAP–BPC10.1 (Embedded), BEX, SAP HANA, BW 7.5. AO

SAP BPC 10.1,11,10 &SAP IBP&SAP BW Skills

Involved with Functional team in preparing the Functional Specifications

Involved in Preparing Technical Specification Documents

Enhanced Customer Specific HANA Calculation Views

Extensively worked on BW on HANA - Eclipse based modeling, Composite Provider, Advanced DSO

Used all advanced modeling techniques to improve reporting performance

In Memory Planning using the Planning Application Kit

Developed the Fox Formulas using the PAK -Planning Application Kit

Installed Analysis for Office in SAP BPC 10.1

Configured BPC Work Status with a Badi for SAP BPC Optimized for S/4HANA

Created a Business Process Flow for SAP BPC,version for S/4HANA

Implemented the Comments in SAP BPC for S/4HANA

SAP BPC 11 EMBEDED .-Good Working knowledge on –

ADSOS, Composite providers, Hana views, aggregation level, filters, planning functions, and planning sequences, Bex queries on top of ADSO’S, Composite Providers

Demand Planning - knowledge on-

Attribute key figure, time bucket profile, storage bucket profile, Planning, Basic building block of demand planning- Info object, info cube, source system

Planning jobs, activity, Life cycle planning, like modeling, Phase in, phase out profile, disaggregation concept

Created POC for OPEX, HCM and REVENUE Planning in standard BPC 10.0

Worked on security set up, Creating task profiles, data access profiles to allow users to

Perform task and access assigned data

Performed and Configured for UAT Testing

Master and Transaction Data loading into BPC Dimensions and BPC cubes from BI cubes

Using Data Manager Packages

Executed the optimization tool including light and full optimization on a given application

Experience in user authorizations

Experience in Developing EPM Input schedules and Reports, Business Process flows (BPF).

Implementation of BI 7.0, which includes Gap Analysis, Requirements gathering, Data

Extraction, Data Loading (Full /Delta Up-Load), ETL, Scheduling, and Monitoring

Experience with SAP BI components including Data Source (OLTP-ECC, Flat files), Extract

Structure, Extractors, Info Objects, Transformations, DTP, Loading Master data and Hierarchies, DSO, Info Cubes, Multi providers, Remote cubes, Open Hub, Process chains Aggregates, Business content Enhancements, BEx Analyzer, BEx Browser, BEx reporting

Experience/Project Work:

Client11: Caterpillar (Teklink Inc., Hyd) Sep 2017 - Till Date

Role: SAP BPC 10.1 optimized for S4 Hana Technical Consultant

Project Description/Scope:

Caterpillar is an American corporation which designs, develops, engineers, manufactures, markets and sells machinery, engines, financial products, and insurance to customers via a worldwide dealer network.

In 2016, Caterpillar was ranked #59 on the Fortune 500 list and #194 on the Global Fortune 500 list

Worked on Tools:

SAP–BPC10.1 Optimized for S4 HANA, BEX, SAP HANA, and SAP BW 7.5, AO (Analysis for Office 2.4)

Responsibilities/Deliverables:

Conducted Business workshops with users

Created workshop output documents for Sales, Revenue,WBS planning and Cost Center planning

Activated the Standard IBPF content, Business functions, and data sources, and Installed SAP BPC Optimized for SAP S/4HANA

Created a Provisional Characteristics in SAP BPC Optimized for S/4 HANA

Customized the standard SAP HANA Calculation Views FCO_C_PRODUCT,FCO_C_COSTCNTR

Created the virtual material in BW which consumes the actual and provisional material data

Adapted Content Real-Time Info Cube ERP/SFIN_V20,for writing the plan data to ACDOCP table which points to FCO_C_IBP_ACDOCP Hana view

Adapted Content Virtual Info Cube ERP/SFIN_V01, for reading the Actual data from ACDOCA table which points to FCO_C_IBP_ACDOCA Hana view

Adapted the real-time info provider ERP/SFIN_R01 for writing plan data

Created the Multi Provider on top of adapted real time and virtual info cube

Created the Aggregation Level on top of multi provider for each planning scenario

Created the Bex Queries on top of aggregation levels

Created the Planning functions like DELETE,COPY and REVALUATION etc on top of aggregation levels

Created the planning filters on top of aggregation levels

Created the planning sequences on top of aggregation levels

Tested the planning sequences in the RSPLAN as per requirement

Created the FOX scripting for deriving the customer-defined calculations

Implemented the Characteristic relationship for the input ready queries

Installed the Analysis Office for the Embedded BPC, making Bex queries available for Embedded BPC

Created the sales planning on monthly,yearly reports using the Analysis for Office

Created the cost center planning on monthly, and yearly reports using AOA

Wrote VBA macros for planning function, planning sequence and save functionalities

Created an Environment and Models for SAP BPC Optimized for S/4 HANA

Configured the BPC Work Status with a BADI for SAP BPC Optimized for S/4HANA

Configured the Business Process Flow for SAP BPC for S/4HANA

Configured the Comments for input ready queries in SAP BPC Optimized for S/4 HANA

Configured the Audit, and security for SAP BPC Optimized for S/4 HANA

Configured the objects in S/4 HANA for transportation

Client10: Vodafone, Pune, Feb 2017 – Aug 2017

Role: SAP BPC 10.0 consultant

Project Description/Scope:

Vodafone is telecom industry, implemented Capex, Opex, Revenue models in sap Bpc.

Responsibilities/Deliverables:

Developed BRD (Business Requirements document) and TRD (Technical requirements document)

Created the poc’s to show the different functionalities to the user

conducted the work shop presentations and collected The requirements to fill the gaps

Involved in Opex, Capex, Manpower planning requirement and blueprint design documents

Involved in Designing the HCM Plan based on the Departments and Designations

Involved in Revenue Solution design process

Configured and managed various Data Manager Packages and Link for Master data and Transaction data load and other tasks.

Analyzed the data flow from ECC to BI based on COMPANY wise and PRODUCT wise

Created the BW objects at the BW side of the BP to load the BW data

Written Script Logic for various business related calculations requirement.

Developed and maintained reports and Input Forms for Management Reporting

Handled Troubleshooting/Debugging Client issues which comes from various areas of BPC and BW

Client9: Reliance 4G, Mumbai, May 2015 to Oct 2016

Role: SAP BPC 10.0 Technical Consultant

Project Description/Scope:

Reliance is telecom industry, implemented Capex, Opex, Revenue models in sap Bpc

Responsibilities/Deliverables:

Gathered the requirements for blue print, planning, budgeting and forecasting functionalities

Involved in workshops for requirements gathering and prepared the design documents.

Conducted the work shop presentations for opex and revenue planning and created workshop output docs

Managed client expectations through formal and informal communications

Created the BI objects at the BW side of the BPC to load the BW data

Maintained connectivity between R/3, BW and BPC systems, extract data from data sources

Replicated the Meta data in BW as well as create transformations and data transfer processes to the BW targets and finally load data to data targets

Participated in the daily meetings with the on-site coordinator to discuss the deliverables

Configured the environment, configured models for planning

Created, maintain custom dimension/ info object, dimension property, dimension hierarchy for entity, account, product and time.

Generated the Income statements

Involved in Opex and Revenue Solution design process

Involved in Designing the HCM Plan based on the Departments and Designations

Configured data manager extraction from ECC and BW system for the actual, plan data

Executed the optimization tool for light and full optimization

Loaded the data to BPC model from BW

Created Input templates for revenue planning, HR planning, cost center planning

Created the Reports for variance analysis for MTD and YTD, P&L and BS

Client8: INFOTECH, HYD, Sept 2012–Apr 2015

Role: Sap BW consultant

Project Description/Scope:

Hetero Drugs is Parma industry, implemented sap bw

Responsibilities/Deliverables:

Analyzed the existing system and identifying the different objects

Identified the Gap Analysis

Monitored Info Objects, Data Sources, Transformations, Info Packages and Info Cubes for

Master and Transactional data from SAP R/3 system and flat files into BI system

Monitored custom Info Cube and other Info Objects as per the data model

Monitored the info packages and analyzing the reasons for frequent failures of info packages.

Monitored Info Packages; Event Scheduling

Developed new objects based on the requirement and the gap analysis.

Monitored process chains for master data loading transactional data loading for weekly deletion of Psa

Client7: BANK OF AMERICA (IBM, HYD), 2011 Aug – Jan 2012

Role: SAPBW/BO Consultant

Project Description/Scope:

BANKING DOMAIN TO DEVELOP WEBI, CRYSTAL REPORTS.

Responsibilities/Deliverables:

Analyzed the Bex, Crystal Functional specs

Interacted with Business Users to understand the requirements and translate these to Technical Specifications for IDT and Business Object Reports

Posted the issues in the issue Tracker

Developed the Bex, Crystal Technical specs using the Functional specifications

Reviewed the Technical Specs with the Business people

Developed the POC in the Crystal Reports

Reviewed POC with the Business and made the required changes to the POC.

Designed and Developed the Bex Queries for the reports in BI 7.0

Designed and Developed the Crystal Reports based on the requirements

Setting up the configurations for publishing process for the Crystal Reports

Extensively worked on Hierarchy, Conditions, Drilling functionalities, Drill down, Prompts, Functions, Formulas, Complex filters, Variables, LOV’s, @Functions, and @Prompts

Created users/ groups and defined their roles and set privileges using the CMC

Used the formatting options like cross tab representation, Group By, data sort options, calculations, font, colors etc.

Prepared Test Cases for Unit Testing

Involved in Unit testing, System testing and User Acceptance Test (Universes and Reports) throughout migration process.

Client6: Robert Half international, (Nano semantics inc) USA, AUG 2007- JUN 2011

Role: QA Engg

Project Description/Scope:

Recruiting manpower consulting for full time and contractors.

Responsibilities/Deliverables:

Developed test plan, test cases and test scripts in Quality center, after the requirements are signed off

Used Quality center to develop Test Sets

Used back-end database SQL queries to perform data testing

Executed the UNIX scripts and commands to check the log files

Documented Manual Test cases, Test procedures and Test results.

Extensive Black box Testing

Performed Functional, GUI testing

Reviewed and Analyzed business requirement documents, technical requirements and functional specification of various functionalities.

Involved in Gathering the Onsite Biz requirements and sending to Offshore

Coordinated the Test Env Downtime during Test cycles as a part of code Deployment to accommodate the Onsite and Offshore Test timings

Involved in coordination of QA activities from Onsite to offshore

Involved managing offshore QA resources

Conducted Defect Status meetings with Offshore and Onsite Leads to discuss the defect Details found during testing

Created the Automation framework for the application to make sure the adequate coverage for the regression testing

Client5: Life Masters, South San Francisco, CA, (Nano semantics inc ), OCT 2006 – AUG 2007

Role: QA Engg

Project Description/Scope:

Online-hospitalized services

Recruiting man power consulting for full time and contractors .

Responsibilities/Deliverables:

Reviewed Business Requirement documents (BRD), Software Requirement specification (SRS) and prepared Test Plan.

Used back-end database SQL queries to perform data testing

Documented Manual Test cases, Test procedures and Test results

Extensive Black box Testing

Performed Functional, GUI testing

Reviewed and Analyzed business requirement documents, technical requirements and functional specification of various functionalities.

Developed positive & negative scenarios for the requirements

Developed test plan, test cases and test scripts in Quality center, after the requirements are signed off

Used Quality center to develop Test Sets

Conducted the Smoke testing to check the High level functionality of the application

Created the Automation framework for the application to make sure the adequate coverage for the regression testing

Client4 : Mc Graw Hill, Monterey, CA, USA (Nano semantics inc) DEC‘04 to JUN ‘06

Role: QA Engg

Project Description/Scope:

Publishing company conducts online exams for primary and secondary schools

Responsibilities/Deliverables:

Reviewed Business Requirement documents (BRD), Software Requirement specification (SRS) and prepared Test Plan

Used back-end database SQL queries to perform data testing

Documented Manual Test cases, Test procedures and Test results

Performed Web Testing & Black box Testing

Performed Functional, GUI testing & web based application

Reviewed and Analyzed business requirement documents, technical requirements and functional specification of various functionalities.

Developed positive & negative scenarios for the requirements

Developed test plan, test cases and test scripts in Quality center, after the requirements are signed off

Client3 : AVIVA INSURANCE, (streamline technologies) Jun’03 to Nov ‘04,

Role: mainframe developer

Project Description/Scope:

This project is insurance domain developed in mainframes

Responsibilities/Deliverables:

Prepared the document of understanding(high level design).

Preparation of detailed design in (flow charts, pseudo code)

Coded in cobol language to prepare Stub

Client2: North American Bank, Toronto Dominion, Aug’02 to May’03

Role: mainframe developer

Project Description/Scope:

This project is banking domain developed in mainframes

Responsibilities/Deliverables:

Prepared of the document of understanding(high level design)

Prepared of detailed design (flow charts, pseudo code)

Coding is done by using low level design docs(LLD) And Pseudo code

Coded in cobol language to prepare Stub

Code review is done against the High level design docs(HLD)

Testing –preparation of test plans and test cases

Client1 : Canadian Imperial Bank of Commerce (CIBC), Satyam computers, (streamline technologies) Hyd, Mar ’01 to Jul ’02

Role: mainframe developer

Project Description/Scope:

This project is banking domain developed in mainframes

Responsibilities/Deliverables:

Preparation of the document of understanding(high level design).

Preparation of detailed design ((flow charts, pseudo code)

Coding is done by using low level design docs(LLD) And Pseudo code

Coded in cobol language to prepare Stub

Code review is done against the High level design docs(HLD)

Testing –preparation of test plans and test cases

Education: B.tech (Mech) in 1997 from S.K university



Contact this candidate