Sap Data
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