SUMMARY:

• 9+ years of IT experience in Implementation, Upgrade and Support in SAP HANA/BW/BI/CRM. Over 4 years of extensive experience in SAP HANA - Data Modeling, Data Provisioning, Reports development.
• Experience working on SAP HANA 9/10/11 and 12 Versions.
• Extensively Worked on SAP HANA Modeler (HANA Design Studio), Designing Schemas, Creating Packages, Attribute View, Analytical View, Calculation view, Analytic Privileges, Stored Procedures and CE Functions.
• Strong expertise in SAP HANA Data Provisioning/Replication techniques like SLT, Direct Extractor Connection(DXC), SAP BODS 4.0/4
• Designing the data flows to load the data from non-SAP source systems to SAP HANA.
• Extensive experience in writing Stored Procedures in HANA using SQL Script
• Strong Experience in Performance Tuning and Query Optimization
• Developed Views to use for Tableau Reporting for Negotiation Snapshot.
• Expertise in SQL, PL/SQL, Java Script and Node JS.
• Good understanding of SAP HANA user management and security.
• Good Understanding of standard SAP modules. (FI/CO, SD, MM, PP, HR, QM, PS, WM, EWM, PLM, Revenue Recognition)
• Experience working on HANA, BW, SRM, SCM, CRM, ECC systems.
• Experience working in Implementation, support, upgrade, Data Migration and Enhancement Projects.
• Worked on Unit Testing, Integration Testing and Performance Tuning.
• Good experience in preparing technical designs. Analyze the business requirements and develop according to the requirements.
• Excellent business communication, presentation, documentation, leadership, management skills& good understanding of Offshore-Onsite co-ordination model.
• Experience with analytical visualization tools like Lumira, Tableau
• Developed high quality ABAP deliverables which includes, Detailed technical design specifications, batch job scheduling, Unit test planning, Custom Tables, ABAP Programs and Interfaces, Code reviewing, ABAP/4 performance tuning.
• Handling of the production support tickets and resolving them as per the ticket priority and transporting them into Quality and Production environments.
• Ability to learn quickly and take up new tasks and responsibilities.

PROFESSIONAL EXPERIENCE:

Confidential (San Jose, CA)

SAP HANA XS Lead Consultant

• Created blueprint for Technical/Functional specifications and standard modeling documents for HANA.
• Involved in requirements gathering and provided solutions to Supply chain management.
• Working on Agile SCRUM Methodology
• Worked on HANA XS applications and building HANA Native modeling objects such as Information Models, Stored Procedures, OData Services, XSJS/XSODATA API services.
• Build HANA information models (Attribute views, Analytical views, Calculation views, and Column/Row based tables) in HANA design studio for efficient data integration.
• Working on Performance Testing and Load Testing Process. Modified Procedures and Views to improve the performance and execution time.
• Worked on Negotiation details, Dashboard design, Supplier details, POR, What IF, Week to Week Analysis, GSM Software.
• Partitioning tables for Performance Tuning.
• Explain Plans and Visual Plans in SAP HANA Studio to analyze and optimize SQL queries.
• Developed XSJS and procedure to Upload the Commodity Manager & Supplier Details data from CSV file, validate the records with the corresponding Request and Response tables and Download the error records into CSV File.
• Developed XSJS and procedures in Updated the Savings Target, Quarterly Adjustments, Demand Derating for the Negotiations through CSV file format and Display the related data once updated in the form of Bar Chart and Line graph, and display the complete data on the UI after the calculations. Created XSJS for each type of Adjustments and corresponding Procedures and Tables to Update the uploaded data and created Calculation Views to display the Spend, Savings and Actual Calculation Values for the uploaded data and send the response to UI to display the data in Bar and Line Charts.
• Validate upload file data and download the error records.
• Developed Launch Settings creation and Cancellation process.
• Created Procedure and XSJS to display the MPN, CPN counts and corresponding Spend and Savings calculations for each quarter for each supplier and Commodity Manager.
• Created OData Services for Suppliers details, Quote History, Negotiation Attributes.
• Developed XSJS, OData Services and Procedures related to Plan of Record used by Commodity Manager and Finance Analyst.
• Involved in Performance Tuning and Optimizing the SQL Queries in the Procedures and XSJS.
• Involved in Object Migration to different Test systems.
• Experience in Managing Offshore Teams.
• Involved in Communications with UI Team to finalize the Response format and the List of API calls from UI Page.

Confidential (Southborough, MA)

Senior HANA Modeler

• Created blueprint for Technical/Functional specifications and standard modeling documents for HANA.
• Worked on trigger based data replication for SAP ECC using SAP Landscape transformation (SLT)
• Created multiple models in HANA such as model consisting of replicated SAP tables VBAK, VBAP, VBUP and VBUK.
• Build HANA information models (Attribute views, Analytical views, Calculation views, and Column/Row based tables) in HANA design studio for efficient data integration.
• Developed Customer Sales Analysis report in ALV (Sales organization Drilldown, Business Unit Drilldown, Customer Type) using IDA.
• Worked on data Migration to SAP ERP and SAP CRM
• Resolved performance issues by writing stored procedures and command objects in crystal
• Developed Real-Time Information models to support SLT replicated tables for SAP ECC.
• Transported objects by creating delivery units HANA monitoring traces for performance optimization.
• Imported Flat files using SAP HANA import wizard.
• Monitored triggers, data loads for SLT schema.
• Created transformation in SLT for enhancing BP Role, BP Status and business required fields.
• Created SQL script based Calculation views using CE functions.
• Created Quote Analysis Report for RSA and EMC.
• Generated OData service using CDS views
• Created LSMW’s based on the requirement to update the custom table, update employee change flag related to territory.
• Used the joins like Inner, Referential, Outer in the HANA views (Graphical and Script-based).
• Created CDS views to display the invoice details and display the customer complete address.
• Create calculated columns, Restricted Columns, Input Parameters on the HANA Views according to the Reporting requirements.
• Created Visualization Reports with Charts and Geographical options on SAP Lumira.
• Actively Participated in Support and Monitoring activities after go-live.
• Working on Performance Testing and Load Testing Process.
• Modified Procedures and Views to improve the performance and execution time.
• Designed Technical Specifications and Unit Test documents.

Confidential (Irvine, CA)

Project Lead and Senior HANA/BW Consultant

• Experience in Creating Attribute views, Analytic views, and calculation views as a part of SAP HANA Modeling.
• Replicated the Application Tables from SAP ECC to SAP HANA Studio using the Real-time SLT Process.
• Created Fiori applications for Sales order Stock and BOM
• Developed data loading strategies for master data, transactional data and delta uploads.
• Developed OData services.
• Extracted data using flat files for raw materials in order to track inventory.
• Developed a Revenue Report based on the requirement
• Implemented Replication technologies like SLT, DXC (Direct Extraction Connection) with ECC to HANA System.
• Worked on Loading data from Excel to SAP HANA DB
• Migrated objects from ECC to HANA.
• Worked on performance tuning of the HANA Views and SQL Script codes using Debugger and Explain Plan scenarios.
• Transported objects by creating delivery units between SAP landscapes.
• Worked on Data Migration Project.
• Expertise on Debugging the transactions SMQ1 and SMQ2 to check how the data is flows down from CRM to R/3 or R/3 to CRM Systems
• Worked on CRM Sales Mobile Application project, CRM implementation. Developed Action Profiles, RFC, CRM events and Enhanced BSP Components according to the requirement.
• Implemented BADI for CRM Mobile Sales to modify the fields and to enhance the custom fields. Developed new GenIL Component Set, BOL Model, GENIL classes, backend API’s, custom Component with dynamic search, result view and navigating to the objects.
• Implemented Geo coding in order to display accounts, contacts, leads and opportunity on the map based on the location (addresses).
• Created ZRFC’s to create and change the Customer details for Shopping cart.
• Enhance Customer creation and change BAPI to accept additional fields value form the shopping cart screen.
• Worked extensively on the SAP GUI for HTML via ITS (Internet Transaction Server)
• Experienced in using the HTML Styles, HTML templates, java script and browser script.
• Designed Technical Specifications and Unit Test documents for HANA, CRM and ECC objects.

Confidential

Team Lead and Senior

• Defined Action Profile, Text Determination Profile, Date Management, Org Structure, Status Profile for Opportunity Management, Sales Order and Quotation Management.
• Addition of custom fields to service contract. The additional of custom fields in CRM Web UI is done with the Application Enhancement tool (AET tool).
• Created SAP CRM Webservices.
• Implemented BADI for CRM Mobile Sales to modify the fields and to enhance the custom fields.
• Implemented BADI to enhance Opportunity, Lead, Partner, Sales and Accounts fields according to the requirement.
• Implemented CRM LORD2 BADI to copy price conditions from Opportunity to erp quote.
• Modified the XML form in order to hide the address block in account creation.
• Monitoring the Inbound/Outbound queue entries in case of error.
• Developed an LSMW in CRM to load Master data.
• Developed ITS screens in MM and WM modules.
• Developed RFC’s for Shopping cart to create/ change the customer and billing address according to the requirement.
• Created a Webdynpro application using Adobe
• Implemented OSS Notes for several transaction codes.
• Modified existing smart forms according to the requirement.
• Developed new GenIL Component Set, BOL Model, GENIL classes, backend API’s, custom Component with dynamic search, result view and navigating to the objects.
• Enhanced BSP Components to add custom fields.
• Developed the custom Program used to Send Email attaching the Adobe Quote created through the online Process and stored at a Particular Network Folder.
• Worked on Pallet Building and Shipment Process, Process Weaver Packing Slip and Characteristics of class.
• Worked on business objects, events, triggering mechanisms, workflow builder, steps, task and triggering of workflow from Webdynpro Component.
• Developed and designed Forms using Adobe Forms, Smart Forms and SAP Scripts.
• Worked on several interfaces, RFC’s and reports according to the requirement.
• Implemented OSS notes.
• Developed ITS screen in WM module for Pallet Building and Shipment Process objects.
• Implemented Adobe Interaction forms for Pricing Conditions.
• Enhanced standard BADI’s, User Exits according to the requirement.
• Extended IDOC DELVRY01 (Delivery Interface) to ZDELVRY01 DES to send plant information.
• ALE/EDI-IDOC configurations & Custom segments creation for Purchase Order.
• Created Adobe form for Sales order, PO, invoice and delivery.
• Developed Webdynpro applications to display the purchase order details according to the requirement.
• Implemented user exit to include fields for tax exemption fields by adding additional tab in SD transaction.
• Worked on support Tickets, Resolving the critical issues by monitoring and documenting
• Monitored Batch jobs and maintained trackers and Remedy.

Confidential

ABAP HR Consultant

• Enhanced standard infotype 0378 by adding custom fields.
• Created a custom infotype.
• Developed a workflow to send the mail to the person responsible.
• Created Organization Management Infotype of field infotype.
• Modified existing workflows according to the requirement.
• Developed objects in PA and OM Modules.

Confidential

Project Lead and Senior Developer

• Worked on CRM 7.0 WEB UI enhancements in Customer Support.
• Worked with BSP WD CMPWB and enhanced views to include customer specific logic.
• Enhanced BSP components to meet the business requirements
• Worked in Production support environment and handling production issues.
• Monitored Batch jobs and maintained trackers and Remedy.
• Worked on production support fixes.
• Created a Material Purchase Price Variation Report comparing standard and actual procurement costs of the purchase orders, one each for standard PO’s and sub-contracting PO’s at multiple levels (Company code, Plant, Vendor, PO and material).
• Developed a program to display the report output in excel format using OLE.
• Report to send the files from ABAP proxy to XI and RFC to provide f4 help for field.
• Extended IDOC Delivery Interface to send the plant information.
• Developed Smart Forms and driver program for Ticket Correction Announcement and Ticket Correction Confirmation.
• Developed ALV Reports with Webdynpro.
• Developed Webdynpro Applications with View, Windows and configured Outbound, Inbound plugs, and bind them with navigation links.
• Modified various layouts and print programs based on the client requirements.

Confidential

ABAP Developer

• Worked on enhancing the BADI’s, User exits.
• Created multiple reports to display the data in interactive ALV format.
• Developed Smart forms, Adobe Interactive forms in modules FI,MM, WM, SD
• Developed update programs to update system and user status, settlement rule, RA keys and progress version, Milestones and sales line item delivery date with forecast finish date.
• Developed and changed layout sets for Invoice, order confirmation; purchase order.
• Modified existing CRM programs according to the business requirement.
• Designed Webdynpro Application and Work Flows.
• Enhanced components to add custom fields in search and result screen.
• Designed Technical Specifications and Unit Test documents.
• Actively participated in Support activities for bug fixes in all the modules

Confidential

ABAP Developer and CRM Developer

• Developed a program to extract the GL account details, BOM details
• Designed interface for Import/Export file from desktop to Webdynpro and vice versa.
• Modified an SAP Script (RVADOR01) as per user requirements, which is for Sales Order Acknowledgement.
• Enhanced existing webdynpro application based on the business requirement.
• Worked on ALV Reports, Webdynpro Application, Dialog Programming, Forms, and Enhancements according to the requirement.
• Modified existing SAP Scripts, Smart Forms and Converted Smart forms to Adobe Forms
• Worked in Production support environment and handling production issues.
• Monitored Batch jobs and maintained trackers and Remedy.
• Worked on production support fixes
• Worked on the Uni-code Remediation for various objects.
• Worked on 2 upgrade projects from 4.7 to ECC 6 and ECC5 to ECC6.
• Worked on SPDD and SPAU objects for ECC 6.0 Upgrade.
• Worked on Unicode Fixes and Obsolete Function modules

Confidential

ABAP Developer

• Developed a program to extracted Customer Master and Bank Details from HHEA client and uploaded to HEA and developed ABAP interface to create Customer Master and Bank Details and to extracted Sales Details from HHEA client and uploaded in HEA using VA02
• Developed reports (Classical, Interactive and ALV) in SD, MM, PP like Sales Statement, in transit report and to extract pricing condition details and upload programs for Customer, Vendor Master Data, Production Orders, Balances and Material Master details.
• Developed User exits, Function Exits, Field Exits and also BADIs for Sale order, Delivery order and Invoice related Transactions.
• Developed Purchase Order, Work Order, Release Order, Contract Order, Excise Invoice and Commercial invoice smart forms
• Created Adobe form for Goods receipt and Goods invoice.