Gayathri R

Client Overview:

Ecolab is a global sustainability leader offering water, hygiene and infection prevention solutions and services that protect people and the resources vital to life.

• I have been a part of BW on HANA development and enhancement deliverables.
• Analyzed business reporting requirements and proposed a data model for the same.
• Design of high-level and detailed-level documentation for submission for client approval.
• Development of end-to-end data models involving DSO, InfoCube, APDs, BEx queries, and process chains.
• Implementation of start/end routines for transforming the data as required.
• Usage, creation of composite, hybrid providers, and multi-providers.
• Development of bug fixes and logic changes as a part of incident/problem solutioning.
• Experience in working with extractors of various kinds: SAP and non-SAP.
• Development of data sources based on non-SAP data sources, such as Informatica, JDA, LIMS, and UD Connect.
• SAP extractors are based on ODP, CDS views, HANA views, BEx query as sources, etc.
• Extensive testing across landscapes, including scenario-based testing.
• Reverse engineering of BW reports and associated data flow through documentation and presentations that serve as the technical specifications for the Azure deliverables.
• Involved in multiple brainstorming sessions that enable bridging the gaps between complex business problems and their solutions in the process of reverse engineering different objects and frameworks.
• In-depth architecture analysis with functional and technical experts to pave the way for transforming the BW architecture into azure modelling.
• Interpretation of ABAP and GUI frameworks into logical statements.
• Wrote user manuals and other documentation for roll-out in customer training sessions.
• Extensive cross-skill training for freshers and experienced personnel in the area of SAP BW and SAC.

Client Overview:

Coop Danmark is Denmark's leading consumer goods retailer cooperative, with more than 1,000 stores owned by 1.9 million members. The company operates supermarkets, hypermarkets, and discount stores, offering products in housing, kitchen, furniture, beauty, books, bicycles, and toys categories, enabling customers to avail themselves of all of it in the same place.

• I have been a part of BW4HANA development and enhancement deliverables.
• Analyzed business reporting requirements and propose data model for the same
• Design of high level and detail level documentation for submission of client approval
• Development of composite providers based on top of two or more Hana views
• Field mapping of HCPR to the respective field in source Hana views
• Association of master data directly to the HCPR output field
• Creation and assignment of input parameters in the HCPR output tab.
• Definition and association of the same with the predefined class type
• Creation/Enhancement of HANA views based on info objects, ADSO, existing HANA views
• Experience in different types of views- Attribute, Analytic and Calculation view
• Development of the required logic in HANA views using joins- left outer, inner, full outer
• Cardinality mapping during join function
• Worked with table functions, transformation/Bex as a source, ODS view creation
• Worked to create flows from both SAP and non-SAP sources (Teradata, flat file)
• Creation of Bex queries in the eclipse modeler, definition of variables, input parameters, filters, conditions
• End to end testing of data models and queries across all landscapes
• Import of objects using the HANA platform
• Hands on Experience in SAC reports, Creation of stories from models, data sources, troubleshooting SAC errors with respect to authorization and data drill down issues
• Work experience in the creation and understanding of AFO reports, data validation, and planning workbooks.
• Experience in ABAP CDS view extraction and ODQMON processing
• Developed training materials and conducted trainings for staff members on new technologies or processes.
• Reviewed all deliverables prior to release ensuring accuracy, completeness, quality assurance standards are met.

Client Overview:

The company is an Australian chain of supermarkets and grocery stores owned by Woolworths Group. Founded in 1924, Woolworths today is Australia's biggest supermarket chain with a market share of 33% as of 2019.

• I have been a part of BW ON HANA development/Enhancement deliverable
• Analyzed business reporting requirements and propose data model for the same
• Design of high level and detail level documentation for submission of client approval
• Creation/Installation of required BW data objects and their corresponding data flow
• Design/enhancement of ECC data sources in align to the business requirement need
• Implementation of start/end routines for transforming the data as required
• Usage/creation of composite/hybrid providers/MPs
• Creation of Bex queries/BODS/process chain for the requirement if needed
• Creation of schedulers/dtps for data extraction and loading
• Posting of sample data at the source end for testing
• Collection of objects via transports and execution of transport movement process
• Object consistency check/TR checks
• Execution of unit test, UAT, performance testing, integration testing across system landscapes and production cutover
• Provide cutover support and post production support for the implemented objects
• Experience in BW upgrade activities
• Involved in Data volume management project reducing the database size by deleting the unused/inconsistent objects and optimization using RSREQREDUCE
• Implementation of calculation views with respect to Near real time stock update application on the HANA database in the cloud environment
• Implemented error handling strategies within the ETL process to ensure correct loading of data into target system.
• Coordination with various teams for the reconciliation of data across streams pre and post production
• Interaction with the SAP team for HANA database issues and recovery
• Issue investigation and resolution through OSS
• Involved in System upgrades/patches; however, SAP has the overall control
• Supported end users with user acceptance testing of the BI solutions developed.
• Provided training sessions on usage of various reporting tools such as BEx Analyzer and WAD for end users.

• Client Overview:

Singapore Airlines is the flag carrier airline of Singapore with its hub at Singapore Changi Airport. The airline is notable for using the Singapore Girl as its central figure in corporate branding.

• Development of data models for the enhancements provided by the client
• Requirement gathering directly from the end user and design the blueprint
• Interaction with various functional teams for requirement analysis and testing thus build a strong functional knowledge in PM, FI applications
• Collaborated closely with project managers, designers, and other developers in order to complete tasks efficiently and effectively.
• Design of Bex queries and BO reports
• Extensive creation of Bex queries using Calculated key figures, Restricted key figures, Formulas, Variables- Characteristic, text, hierarchy
• Usage of Cells, conditions, exceptions, structure, exits for pulling out the formatted data
• Have vast knowledge in various features of Bex elements
• Small BO report design without universe sourced from Bex queries and flat files
• Single point of contact for BW and BCP applications embedded with BW with respect to the client.
• Understanding of the client-based FI application hosted using BCP, where users post their year-end financial statements and deliver enhancements for the running application.
• Also provided extensive support to users for the platform during the peak fiscal activity
• Direct interaction with the client and held ownership for BW application related issues and developments
• Resolved customer issues by establishing workarounds and solutions to debug and create defect fixes
• Wrote user manuals and other documentation for roll-out in customer training sessions.
• Coordinated testing and validation procedures through software development lifecycle.
• Debugged existing application functionality to identify areas of improvement.
• Established best practices for coding standards within team environment.

Client Overview:

Bank of America is an American multinational banking and financial services corporation headquartered in Charlotte, North Carolina. It is the second largest bank holding company in the United States by assets.

• Worked on finance module developments - Data source creation using views and BADIs
• Installation of standard info providers, multi providers and Bex query
• Creation of custom providers –DSO, cubes, transformations using start, end and expert routine
• Implementation of Near-Line Archival Project.
• Worked exclusively on change management practices.
• Worked on Service NOW for handling small and medium CRs
• Worked on creating and modifying the Bex queries
• Worked on creating Info objects, DSOs and Info Cubes
• Worked on Data source enhancement
• Worked on creating and modifying the BW workbooks in Bex Analyzer and SAP BO
• Have experience in writing ABAP code in transformation routines and exits
• Problem management for long time product/design issues by providing RCA and solution with documentation and proceed with CRs
• OSS notes raised to SAP for long pending problems and system bug fix
• Supported end users with user acceptance testing of the BI solutions developed.
• Provided training sessions on usage of various reporting tools such as BEx Analyzer and WAD for end users.
• Implemented error handling strategies within the ETL process to ensure correct loading of data into target system.
• Maintained quality-focused performance benchmarks and schedules when directing project teams.
• Prepared detailed documentation including flow charts, diagrams and user manuals for different components of the system.
• Monitored job execution logs on a daily basis to identify any errors or inconsistencies in the system.
• Collaborated with other teams such as Basis and Security team during system upgrades or migrations.
• Ensured compliance with all relevant standards while developing BI solutions based on customer requirements.
• Worked effectively in team environments to make the workplace more productive.

Company Overview:

L&T Valves Limited designs and manufactures various industrial valves for the oil and gas, power, petrochemicals, chemicals, fertilizers, and pharmaceutical sectors. L&T Valves is a leader in flow-control solutions. The company is a subsidiary of Larsen & Toubro, a technology and engineering conglomerate.

• End to end implementation of BW landscapes
• Interaction with Basis to set up the initial landscape and install business content
• Worked on Requirement gathering and exclusively dealt with client for the same as the project was happening at the client location
• Streamlined acquisition of reporting requirements and specifications to disseminate across multiple business lines and IT support teams.
• Conferred with clients regarding information processing or computation needs.
• Worked on creating Info objects, DSOs and Info Cubes
• Worked on Data source creation using standard BI content, flat files and function modules
• Worked on creating and modifying the Bex queries
• Worked on creating and modifying the BW workbooks in Bex Analyzer and SAP BO
• Have experience in writing ABAP code in routines and small enhancement of ECC datasource
• Experience in TR movement processTR collection, release and execution
• Exclusive unit and User acceptance testing with the client
• Data reconciliation, Production roll out activities and post production support
• Created custom reports using BEx Analyzer, Query Designer and BOBJ tools.
• Supported end users with user acceptance testing of the BI solutions developed.
• Provided training sessions on usage of various reporting tools such as BEx Analyzer and BO for end users.
• Prepared detailed documentation including flow charts, diagrams and user manuals for different components of the system.

Client Overview:

The Procter & Gamble Company (P&G) is an American multinational consumer goods corporation headquartered in Cincinnati, Ohio, founded in 1837 by William Procter and James Gamble. It specializes in a wide range of personal health/consumer health, and personal care and hygiene products; these products are organized into several segments including Beauty; Grooming; Health Care; Fabric & Home Care; and Baby, Feminine, & Family Care.

• Strong exposure to support landscape including incident management, problem management and request handling

Incident handling

• Worked on Remedy Incident tool
• Working on the incidents assigned, will provide the solution based on data quality issue or user understanding issue with in the SLA
• Have experience in analyzing the ABAP code i.e., in routines, CMOD code and Bex customer exits
• Repetitive incidents will be noted and will check the possibility for permanent fix by creating Problem tickets, where RCA is done for causing the issue

Problem management

• Root cause analysis RCA is done and solution with clear step by step analysis and plan of action to resolve the issue
• Report creation for client presentation of incident/problem/ count using add on tool

Request/Fulfillment management-

• To assist the users to complete the requests raised

BW data loads monitoring-

• Process chain creation, modification, scheduling, de-scheduling, and monitoring of the scheduled and running process chains.
• Ad hoc loads execution as per the timelines
• Delta/Full load fixes and process chain maintenance
• Implemented error handling strategies within the ETL process to ensure correct loading of data into target system.
• Transport movement process and support.
• Researched new features released by SAP for improvement of current BI solution architecture.
• Prepared detailed documentation including flow charts, diagrams and user manuals for different components of the system.
• Performed performance tuning of existing InfoCubes and DataStore Objects.
• Managed time effectively to ensure tasks were completed on schedule and deadlines were met.