SAP BW/BI HANA consultant
Resume:
RANJEETHA KETINENI
SAP BI & HANA Consultant
*********.***@*****.***
Certified in SAP BI and HANA
1
EXPERIENCE SUMMARY:
Name of the Organization Duration Position Held
Stone Apple
Dec 2015 to Till Date
SAP–BI and HANA
Consultant
IBM
Jan 2011 to Oct 2015
SAP–BI and HANA
Consultant
British American Tobacco Feb 2009 to July 2010 SAP –BI Consultant Affiliated Computer Services Feb 2008 to Dec 2008 SAP-- BW Consultant KEANE Jan 2006 to Dec 2007 SAP-- BW consultant
CHELLUR & PRASAD Company June 2005 to Dec 2005 Accountant Executive Summery:
9+ years of experience in SAP-BW/BI, SAP HANA, R/3 in handling implementation and production support projects.
Certified in SAP BI and Certified in SAP HANA
Involved in Complete SAP BI Implementation Project Life cycle that includes Customer requirement gathering, Design, Development, Testing, Go-Live and post production support.
Extensively involved in understanding business challenges, End-user requirements, doing GAP analysis and documenting the business requirements into preparing the functional specification accordingly and converting them as Technical specifications.
SAP HANA Development of Scenarios involving Attribute, Analytic, and Calculation Views
BI Modeling – Currently working in a BW 7.3 implementation projects and has experience in working with complete BW 7.3 functionalities/data models. Previously worked on different BW versions of BW and extensive hands on experience in working on InfoProviders (SPOs, DSO, InfoCubes, InfoObjects and Multi Providers), Datasources, Transformations, DTP’s, InfoSources, Process Chains, Aggregates, BWA and Open Hub.
BI Extraction – Extensive experience in activating and working with LO, and COPA extractors in different functional areas like SD, FI AP, FI AR, HR(HCM), MM, Retail and HCM. Extensively worked on customizing the R/3 data sources with lot of enhancements and also worked Custom Extractions (Generic Extractors) from different SAP systems. Extensively worked on third party (DB) extractions and flat file extractions.
ABAP/4 – Worked on ABAP for data transformations, lookups, Start routines and End routines.
BI Reporting – BEx Analyzer, BEx Query Designer, Web Application Designer (WAD), Web analyzer, RKFs, CKFs, Variables, created custom queries and used Conditions, Exceptions, RANJEETHA KETINENI
SAP BI & HANA Consultant
*********.***@*****.***
Certified in SAP BI and HANA
2
Workbooks, Query views, Customer exits. Worked closely with Micro Strategy reporting tool where BW as the source of data.
Worked on BW Transports – Extensively worked on transports with maintaining proper sequences. Ability to Understand the Transport fails and fixes quickly. Used different Transport mechanisms like RevTrac, SOLMAN, etc...
Performance – Worked on different performance activities like, improving load performances, reporting performance improvements and system performance tasks.
BW Production Support - Data load management, event processing, experience in automating data loads using Process Chains and batch jobs, monitoring the process chains, data loads
(Full /Delta) and monitoring database for any space issues and get it adjusted as per the expecting rise of data.
Worked on all phases of project from blueprinting, configuration, development, integration testing. Solution delivery and result-oriented individual in analyzing project situations and implementing solutions.
Technical Skills:
SAP Technologies
SAP BI (7.3, 7.0, 3.5), HANA, BO, ECC(Data Extraction) Reporting/Designing
Tools
Business Explorer, Web Application Designer, Business Objects, Crystal Reports, Xcelsius.
SAP Modules
SD, MM, PD, HR(HCM), FI,CO.
SAP WORK EXPERIENCE:
Project 1:
Client : Dr Pepper Snapple Group (DPSG) – Dec 2015 to Till Date Project Nature : Support, and Enhancements Project R/3 System : MM, APO, CRM
Role & Responsibilities:
Project CAPSTONE is highly customized with huge volumes of SAP BW implementation involving Informatica, SAP – CRM, MDM, ECC, SP, TM, Customer Matching, Vertex with integration to Microstratgey & Business Object XI 4.0 as reporting tools
The major KPI for Capstone is Case Sales Volume and is very critical to report to wall street to show how the company is performing
RANJEETHA KETINENI
SAP BI & HANA Consultant
*********.***@*****.***
Certified in SAP BI and HANA
3
Project implemented industry best practice on the design, Layered Scalable Architecture
Extensive use of BW 7.3 features, esp: Semantic Partit ioned Objects in all LSA layers and implemented a quarterly partitioning for Daily flows and half yearly partitions for Monthly flow
Developed a custom BADI implementation to auto generate SPOs as per business requirement
Project 2:
Client : British Petroleum - Jan 2015 to Oct 2016
Project Nature : Implementation, Support, and Enhancements Projects R/3 System : SD, FICO
Extensively involved in problem management, issues, and solutions. Involved in client based discussion to arrive at a decision and finalize the solutions for non-stabilized BW system for client Schweppes.
Have been unanimously received client appreciation for taking up the responsibility of a non- stabilized system and resolving client age old issues in a timely and quality manner.
Have been recognized by client and the GO and have been awarded as best performer consecutively twice.
Role & Responsibilities:
Involved in Understanding the functional specifications and development of high-level technical specs.
Involved in solving performance-related issues and also involved in Creation of Aggregates to optimize queries performance.
Monitoring of infopackages and analyzing the reasons for frequent failures of infopackages.
SAP HANA – Worked for different POCs in sales analysis. Experience on HANA modeling
(Attribute views, Analytical view, Calculations views), SLT and BODS extractions and Reporting.
SAP HANA Data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio
Worked on HANA for building POCs for customers and HANA RDS Solutions .
Preparing Document for client Understanding.
Project is highly customized with huge volumes of SAP BW implementation involving Informatica, SAP – CRM, MDM, ECC, SP, TM, Customer Matching, Vertex with integration to Microstratgey & Business Object XI 4.0 as reporting tools.
The major KPI for the project was Case Sales Volume and is very critical to report to wall street to show how the company is performing.
RANJEETHA KETINENI
SAP BI & HANA Consultant
*********.***@*****.***
Certified in SAP BI and HANA
4
Project implemented industry best practice on the design, Layered Scalable Architecture.
Extensive use of BW 7.3 features, esp: Semantic Partitioned Objects in all LSA layers and implemented a quarterly partitioning for Daily flows and half yearly partitions for Monthly flow.
Project has the unique requirement to freeze the transactional data at the month end along with the master data to be able to do the Month End Reporting for the certified bottlers only for the last 36months.
The month end cube contains the month end frozen transactional data as well as master data attributes required for reporting. In the event of closing the data for the next month, the snap shot of data present in Month End Closed cube is copied to Snap shot cube (47 partition cube).
Project 3:
Client : Schweppes - Jan 2011 to Dec 2014
Company : IBM
Project Nature : Implementation, Support, and Enhancements Projects R/3 System : SD, MM, APO, Hyperion, Informatica, SAP BODS. Role & Responsibilities:
Involved in the support activities like analyzing the customer problems in the production and providing appropriate solutions.
Worked on various report development and enhancements.
Handled various support activities in various modules.
Involved in Load Monitoring Using RSPC, RSMO, and SM37.
Involved in monitoring the infopackages groups and process chains.
Involved in solving tickets regarding extractions and load failures.
Delta loading from R/3, flat files using PSA. The data loads for master data and transaction data.
Generated and Maintained Aggregates and Rollup activities as part of the Info cube Management.
Involved in maintaining documentation for all the Support Activities.
Monitoring and Trouble-shooting Issues.
Extensive Custom ABAP coding (only with field-symbols) is used to stamp the data onto the Closed Cubes.
Implemented a “Delta Flip” logic using custom program to initiate delta after full load to support the month end close process and daily close process. RANJEETHA KETINENI
SAP BI & HANA Consultant
*********.***@*****.***
Certified in SAP BI and HANA
5
In addition, project has flex dimension to derive certain time categories namely CM,CMPY,12MM,12MMPY,YTD,YTDPY,2YFY and PYFY at the backend(extensive ABAP
- Pivoting) to improve query performance and allow easy slice & dice in reporting.
Extensive performance techniques used due high volume project
Extensive use of multi provider assignments involving 15 Semantic partioned info cubes and unique logic to support the business process to check the bottler in reporting
Implemented a “Custom Domain” to achieve precision to the 8 decimal for float key figures. Project 4:
Client : BAT (British American Tobacco) Feb 2009 to July 2010 Company : BAT
Project Nature : Implementation, Support, and Enhancements Projects R/3 System : SRM system, APO
Enhancement Project
This was a new field addition to the BW objects which would carry the Ship-to- Address data from the SRM r/3 systems.
Was responsible in making changes on the BW, to data target objects and at the reporting level
Handled the UAT issues and successfully it was released to production Germany and Italy Migration Project
This project was related to migration of data from one r/3 source system directing it to other r/3 objects in BW.
It involved changes in the source system connection, user roles, BW authorizations, reporting authorization
And changes in the exits
Successfully handled the UAT issues and released to production Parallel Loading Project
It was an enhancement project to over come the loading lock issue in the BW environment.
Prepared the necessary ground work in BW to over come the lock issue, like creation of the generic extractors, prepared the basic technical document to carry out the project and for future reference, creation and modifying the data target etc
Creation of transfer rules, update rules and taking the decision of using the over write and the key field to update the data further to the ODS and Cubes. RANJEETHA KETINENI
SAP BI & HANA Consultant
*********.***@*****.***
Certified in SAP BI and HANA
6
Created info packages and populated Info cubes with initialization and delta loads at predefine scheduled time settings. Used Full Update methods depending on the requirement.
Extensively worked on generic extractor from the active table of the ODS
Used ODS to stage the data before transferring the ODS contents to further data target
Creation of message variant in the process chain for all the process chains on about 25 process chains with successful and ending with errors messages.
The variant would send an email to the support team to quickly resolve/handle the process chain error.
Time dependent Product category description changes
The requirement was to show the changes in the description of the product ID based on the time period the old date and the new date.
The enhancements were done to the reports and the object to adapt the new/changed description based on the year.
Changing of the object as time dependent object.
Variable creations to the reports using the product category. Project 5:
Client : Motorola
Company : ACS (Affiliated Computer Services) Feb 2008 to Dec 2008 Project Nature : Support and Bex Reports Development R/3 System : HR (Human Resource)
Role & Responsibilities:
Was responsible in developing new reports based on the client /user requirement
Used Hyperion reports as the basis to develop the BW reports.
Used the service center (peregrine) issue handling tool. Involved in escalating high-prioritized tickets regarding extractions Performance Issues and also load failures. Maintaining Work History for all the tickets until it is closed down.
Development of specific Queries based on user requirements using Query Builder and Web Application Designer as well as utilization of Business content related queries and workbook.
Involved with performance tuning of Queries
Monitoring and analyzing the reasons for failures of Info packages
As part of the performance and development team, involved in performance tuning of Queries by maintaining Aggregates, Compression, Partition, indexing of Info cubes. Query Result as, Background Jobs.
RANJEETHA KETINENI
SAP BI & HANA Consultant
*********.***@*****.***
Certified in SAP BI and HANA
7
Project 6:
Client : Pedilite Industries Pvt Ltd
Company : KEANE July 2007 to Dec 2007
Project Nature : Support
Role & Responsibilities:
Working with standard Business Content info cubes and used it for all sales analyses and used related Info sources to upload the data into the Cube.
Uploaded data for analyses into Info Cubes, ODS Objects and Master data tables by triggering initialization, delta and full update methods to implement a Performance oriented, periodic data transfer strategy.
Generated and maintained aggregates and rollup activities as part of the Info cube management
Good hands on experience in Installing Business Content.
Created and Maintained Transfer Structure, Communication Structures.
Expertise on Generic Extractors to extract Database table Project 7:
Client : EID parry (India) Ltd., July 2006 to June 2007 Company : KEANE
Project Nature : Implementation & Support
Role & Responsibilities:
Understanding and coordinating with functional consultant in configuration, Implementation
& Support of BW by identifying the needs of customer. Good hands in Installation of business content, Data modeling data sources transfer, data Extraction, data Maintenance, Reporting using Business Explorer, creating BW objects such as Info Objects, Info source, Info cubes ODS Objects, etc.
Responsible for design, development and extraction of data from R/3 Source system and Flat files to the BW System.
Created and activated Info source for transaction and master data. Assigned Source Systems to the Info source and updated.
Worked on flexible Queries using filters, variables, navigational attributes in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.
Used RRI interface to jump on to other query to get detailed data. RANJEETHA KETINENI
SAP BI & HANA Consultant
*********.***@*****.***
Certified in SAP BI and HANA
8
Managed and monitored several data loads. Optimized the load performance by adjusting the Packet sizes.
Project 8:
Client : EID parry (India) Ltd., Chennai, India
Work Location : KEANE (Caritor (India) Pvt. Ltd), Chennai Duration : Jan 2006 to June 2006
Project Nature : Training on FICO
There was about 6 months training on FICO and BW by the company. Education Qualification:
Masters in Business Administration (PGDM).
Bachelor in Business Administration.
Note : Green card Holder
Contact this candidate