Information Technology Consultant, Package Consultant, Application Developer/Package Consultant

Organization Name: NTT DATA Services Pvt Ltd.

Joyson Account:

Joyson Safety Systems is a global leader in mobility safety providing safety-critical components,
systems, and technology to automotive and non-automotive markets.

Project Name: Joyson Safety Systems Jul 2019 - March-2020
Role/Title: Information Technology Consultant
Work Location: NTT Data, Hyderabad, India
Project description:
Joyson Safety Systems is a global leader in mobility safety providing safety-critical components,
systems, and technology to automotive and non-automotive markets.

* Worked in to migrate Oracle DB to HANA database, doing checking existing ABAP code
compatibility to for HANA code-to-data mechanism and doing performance tuning as per HANA
guidelines. Using HANA Model created for reporting into ABAP program (through external view or
Database Proxy). Developed ABAP CDS View and ADMP method and extensively reuse them in ABAP
program to get performance benefit of HANA.
* Worked on ABAP CDS View, AMDP, HANA View and HANA Store Procedure.
* Created CDS Views to Display Sales order header and item details, generated OData services
&Consuming OData service in Fiori App.
* Hands - on experience in creating Tables, Procedure, Decision Table, Table Function, and
various objects.
* Creating the Attribute, Analytical and calculation views based on business requirements
* Experience with SAP HANA Programming including Structured Query Language (SQL), SQL Script.
* Knowledge of AMDP-ABAP managed Database Procedure and CDS (Core Data Service) View create in
DDL source Editor.
* Involved in preparation of Test planning, Test Estimates, Test Strategy.


Environment: SAP S/4 HANA, SAP HANA 2.0, SAP NW 7.5, Dashboards.

Organization Name: Infosys Technologies Pvt Ltd.

McKesson Account:

McKesson Corp. is one of the largest providers of medicines, pharmaceutical supplies, and health
information technology (IT) products and services in the United States.

Work Location: Infosys, Hyderabad, India
Project description:
McKesson Corp. is one of the largest providers of medicines, pharmaceutical supplies, and health
information technology (IT) products and services in the United States.

Responsibilities:
* Developed Daily/Weekly Auto-Mail Report As per Functional Requirement in SAP.
* Involved in the Issues raised by the End-users.
* Review the bug fixes and helping the team with technical solutions.
* Responsible for Maintenance, Modification and Development of the SAP applications as per the
requirement and technical norms.
* Bug fixing/change the existing code due to new requirements/build a new code etc.
* Being responsible for run time analysis and performance tuning of developed reports.
* Developed SQL procedures in HANA for rebates amount calculation.
* Developed one Automation step for creation payment proposal at the time of payment split in
F110 transaction for FICO module.
* Automation step for creation payment run at the after of payment split in F110 transaction
for FICO module.
* Developed three applications using O-Data services from SAP.
* Using these O data services, we have created a chat bot, through INFY NIA chat bot services
where whole front end is designed.
* Developed many enhancements for standard SAP programs and bug fixes for custom code plus
standard code according to project requirements.
* Good knowledge of ABAP Transport Mechanism (with Rev Track) to move repository object from
development to quality to productive environment.
* Expertise in ABAP Coding standards with In-Line declarations version 7.40 & 7.50.
* Modified ABAP custom programs code to Improve Performance by using HDB.
* Experience with data modelling using Attribute View, Analytic View, and Calculation View.
* Good knowledge of Code Review and Performance improvement (ABAP Trace SAT/SE30) of ABAP Code.
* Good working experience on ABAP static performance tools Code Inspector (SCI) with custom
check variant and ABAP Test Cockpit (ATC) to optimize ABAP custom codes for HANA DB migration
as well as Performance improvement of any DB.
* Knowledge of using SQL Performance Tuning Worklist (SWLT) to combine static and dynamic
performance analysis of ABAP code for HANA DB migration.