Sap Abap On Hana / Hana Modeling Resume
CA
SUMMARY
- A Multi - skilled SAP professional with 15 years of experience as an SAP ABAP/ ABAP on HANA / Hana Modeler/ Consultant and involved in 4 full life cycles. Skilled in all phases of the software development lifecycle; expert in translating business requirements into technical solutions; and fanatical about quality, usability, security and scalability.
- SAP Certified Development Associate - ABAP with SAP NetWeaver 7.50 Certificate
- SAP Certified SAP Native HANA 2.0(SPS04) C HANAIMP 16 Certificate.
- Performing all stages of SDLC cycle (i.e. Requirement gathering, preparing design for technicalsolution, development/Coding, testing, GO-live support etc.)
- Expert in handling jobs in the area of SAP customization/report development (ABAP) and involved in Implementations, Upgrade, production support and Support & Maintenance of SAP MM, PP, PM, SD, EWM, LE and FI/CO Modules.
- Coordinate with system partners to gather business requirement, finalize design and perform technical analysis.
- Worked on upgrade from ECC 6.0 to S4HANA 1809 & eventually to 1909 version.
- Expertise in developing various RICEF objects which include:
- Expertise in developing: Function Modules, Remote function modules(RFM), Dynamic programming, ABAP Objects (OOPs), ABAP Query, OSS Notes, Dialog Programming (Module Pool), Menu Painter, Screen Painter, Logical Data Base (LDB), BTE (Business transaction events), Batch Jobs, ABAP proxies, Enhancement Framework, RF screens, Data Dictionary (Lock Objects, Search Helps, Domains, Data Elements, Tables), VOFM Routines.
- Worked on ALE, EDI, RFC and IDOC Interfaces between SAP to SAP and SAP to Non-SAP.
- Extensive Worked on Performance Tuning Using SE30, SQL Trace ST05 transactions, code inspector (SCI) and abap test cockpit (ATC).
- Expertise in ABAP Debugging, Job scheduling, SAP Query, data archiving and debugging standard SAP Code.
- Extensively worked with Integration Builder Design & Configured PI Adapters like File, RFC, IDOC, SOAP, SFTP and MAIL as sender & receiver channels.
- Involved in Code Reviews, Time Line Schedules and Leading Offshore Teams.
- Expertise in Background Jobs, Debugging, Run Time Error analysis
- Experience in developing SAP S/4 HANA Core Data Services (CDS Views) and ABAP Managed Data-base Procedures (AMDP), Open SQL and SALV Classes.
- Experience in ABAP in Eclipse, Development of ABAP Objects via Eclipse, debugging, unit testing, and runtime analysis.
- Experience in building CDS views with associations, joins, union, input parameters, table Functions and SQL expressions.
- Experience in BASIC, COMPOSITE AND CONSUMPTION VIEWS.
- Experience in VDM, annotations, enhancing or extending CDS views, nested views.
- Experience in exposing CDS views to ODATA.
- Expertise in SAP Netweaver gateway framework and RESTful services and OData web services.
- Mentored junior developers and assist in ABAP development and software practices.
- Managing Offshore Support team, Mentoring team, Project coordinating on deliverables
- Expertise in native HANA modeling, SQL Script, Stored procedures, Performance tuning
- Expertise in Data modeling- Attributes Views, Analytical Views, Calculation Views, Stored Procedure, Business rules in to Decision Tree and Analytical Privileges.
- Expertise in advanced modeling using Hierarchies, derived views, restricted calculated column, variable, input parameter, currency conversion.
- Expertise in Calculation views GUI Based, and Script based.
- Experience in different data provisioning techniques like SLT, BODS, SDA and SDI.
- Developed flow graphs to get remote sources to Hana.
- Expertise with different performance techniques like Explain plan, visualize plan, tracing, partitioning.
- Converted analytical and attribute views to calculation views, since SAP stopped those views.
TECHNICAL SKILLS
SAP R/3: Versions, 4.0, 4.6c, 4.7, ECC 6.0, SAP HANA 1.0 and HANA 2.0.
Operating Systems: MS-DOS, Windows 95/98/2000/ NT.
RDBMS: Oracle 8i, 9i, MS-Access, SQL-Server.
Scripting Languages: HTML, Java Script, CSS
Programming Language: ABAP/4, C, C++, SQL, and MS.Net
PROFESSIONAL EXPERIENCE
Confidential, CA
SAP ABAP on Hana / Hana Modeling
Responsibilities:
- Lead team of 12 developers handling end-to-end software development in multiple projects.
- Raised the code efficiency of the programs.
- Recommended architectural improvements, design solutions and integration solutions.
- Proposed technical feasibility solutions for new functional designs. Provide deliverable estimates, manage monthly and quarterly releases for ABAP deliverables.
- Provided maintenance and development of bug fixes that occurred during system upgrade.
- Developed a complex calculation view using SQL Scripts.
- Designed and Developed process dashboard for Unknown deductions project in FI module. Received highly positive appreciation from the CFO.
- Created custom IDocs for EDI (810) Invoice by extending the INVOIC02 IDoc type and adding the logic in the User Exit (EXIT SAPLVEDF 002)
- Designed and developed Screen Exit for purchase order and batch details by accessing data on the screen in functions even if it is out of scope using memory variables and field symbols.
- Developed CDS views for using FAGLFLEXT VIEW for Cost of sales (COS) report for FICO module.
- Developed Extended CDS views for sales and FI related modules.
- Developed CDS view and publish it as ODATA service using Auto-exposure for Purchase orders standard text.
- Improved performance of CDS views by following SAP best practices.
- Worked on interfaces using ABAP proxy communication. These interfaces are build using proxy communication with PI as middle between SAP system and the legacy system.
- Developed the Fulfillment interface program wherein when the tracking numbers is physically generated at shipping station after PGI and posting all tracking no to website through GIS integration.
- Developed CDS view for Stock Transfer Order Details report and service enabled them as OData service for FIORI app.
- Developed ODATA service for custom tables.
- Developed ODATA service for purchase order, ODATA create method for single header and multiple item table input.
- Developed ODATA service used post method to update data into custom table.
- Developed SAP HANA information models such as Calculation views (Scripted and graphical), Stored Procedure, table functions, decision tables.
- Created Store Procedures to be used in Analytical Privileges for security.
- Developed custom ABAP Reports using Eclipse ADT.
- Created multi-dimensional data models using information models using Hana Studio.
- Worked with the functional team to understand the business specifications for each requirement.
- Involved in daily scrum calls.
- Developed flow graphs to get data from remote sources into HANA.
- Created flow graphs and stored procedures to implement the business rules while fetching data into HANA.
- Developed complex calculation view using SQL Script.
- Developed multiple calculation views for Interim Financial Statements
- Developed calculation views for Plan / Actual (BPC / BW multi-cubes for Plan data / ACDOCA for actual) for expenses and revenues.
- Developed SAP HANA information models such as Calculation views (Scripted and graphical), Stored Procedure, table functions, decision tables.
- Created information models for COPA multidimensional reports that include COPA variance and Actual/Plan comparison reports using XSA.
- Created models using both Virtual tables (Smart Data Access) and Physical tables.
- Created Input parameters, Variables, Calculated columns, restricted columns (KPIs) according to the business requirement.
- Created Analytic Privileges based on filters required as per the users using the privileges like restriction based in country and region etc. using normal filter and stored procedures upon the data models.
- Created Store Procedures to be used in Analytical Privileges for security.
- Worked extensively on performance tuning of Hana Models using Explain Plan, Visualize Plan and Expensive statement trace.
- Involved in moving HANA models from Dev to QA and Prod using ALM.
- Involved in Unit testing and User acceptance testing for fixing the bugs raised from test team.
- Worked on production support issues.
ENVIRONMENT: S/4 1909 (FI-CO, SD, MM), HANA 2.0
Confidential, MI
Sr. SAP ABAP on Hana / Hana Modeling
Responsibilities:
- Lead a team of 15 developers coordinating and managing offshore team. Handling end-to-end development activities.
- Raised code efficiency of the programs, lead the code review team.
- Developed a COS (cost of sales) ALV report, where it generates journal entry at the profit center level with custom table for gl accounts using OOABAP.
- Developed auto cash application report for FI module.
- Performance tuned on time delivery report for MM module.
- Developed ALV tree cockpit Monitor, based on the EDI 856 ASN received will create outbound delivery, PGI, Invoice creation (OTC).
- Developed custom classes, created dynamic methods which can be used across other programs using OOABAP.
- Involved in troubleshooting CRM Middleware related issues.
- Developing objects by providing best solution and design and also resolve issues of the CRM WEBUI module involving component enhancement, working with component usage, linking business partners, transaction launchers, RFCs, dynamic interfaces, etc.
- Developed inbound cockpit using OOABAP where the error files can be processed on a monitor.
- Sales order schedule line enhancements to include various new custom fields.
- Developed ODATA service which consumes 2 RFC’s for sales order creation.
- Developed ODATA service for CDS views for exposing the views to FIORI APPS.
- Developed Custom IDOC types to support Order to cash (OTC) docs exchange between partners.
- ABAP Programing Model for SAP HANA - CDS views and AMDPs, Open SQL, SALV Classes.
- Created and consumed CDS views in custom ABAP programs based on the requirement and achieved code push down to database layer.
- Developed a module pool program for packing of harness in the container, scanning the serial number of HU (Handling Units) One By one.
- Experienced in developing Core Data Services (CDS Views) and ABAP Managed Data-base Procedures (AMDP).
- Created and consumed CDS views in custom ABAP programs based on the requirement and achieved code push down to database layer.
- Developed custom ABAP Reports using Eclipse ADT.
- Accelerated ABAP Custom code using SQL Monitor (SQLM), ABAP Test-cockpit (ATC), SQL Performance Tuning Work list (SWLT).
- Developed IDOCS based inbound interface remote function module (RFM) to create Purchase Orders using inbound IDOCS data from Legacy System.
- Responsible to develop inbound interface using IDOCS to update Tracking Numbers against Handling Units for Delivery documents.
- Developed adobe forms FI, SD, MM, LE and WM module.
- Developed many Adobe forms LE modules like carton, pallet and case labels.
- Worked IDOC “IDOC INPUT DELINS START” to add segments.
- Worked with functional team to gather requirements and create technical documentation.
- Developed Hana models like attribute views, analytical views and calculation views (Graphical and Script based).
- Developed flow graphs and stored procedures to implement business logic while fetching data from remote sources into HANA.
- Developed calculated columns, hierarchies and input parameters as per the business requirement.
- Created Calculated Attributes and Measures, and Restricted Measures in Aggregation node to serve different business requirements.
- Worked on creating analytic privileges for security.
- Worked on performance tuning the HANA models using Explain plan and Visualize plan.
- Worked in SQL script and Stored Procedures. Created table functions and used them as input in the calculation views.
- Mapped the Input parameters form table functions into calculation views.
- Used ALM (Application Lifecycle Management) for transporting of models to production.
- Worked with the test team to fix bugs raised in Unit testing.
- Worked closely with the end-users to fix the bugs raised after moving data models to production system.
ENVIRONMENT: SAP HANA 1.0 SPS11, ALM, (FI-CO, LE, EWM, SD, PM, MM, PP).
Confidential, Sunnyvale, CA
SAP ABAP Consultant Lead
Responsibilities:
- Developed an interface program that would extract the Vendor line item display (FBL1N) items.
- Implemented a BADI for transaction fb60 such that it does not allow users to create duplicate reference for vendor invoice creation.
- Loaded open AR, AP and GL transaction balances from Legacy using IDOC with message type ACC DOCUMENT.
- Implemented BADI ME PROCESS PO CUST to update/overwrite functional area in purchase order.
- Upgrade activities using SPDD, SPAU and SPAU ENH for ABAP and VISTEX objects. Upgrade from 4.6c to ECC 6.0.
- Implemented a purchase order duplicate check in USEREXIT USEREXIT CHECK VBAP.
- Modified standard Scripts and smart forms according to client requirement.
- Development of G/L account open line item list display based on G/L acct and purchasing entities.
- Master data loads of Material Master, General ledger, Profit centers and Cost centers using Batch Input Method.
- Worked on BAPI BAPI ACC DOCUMENT POST (FB01) for uploading G/L Balances and Accounts Payable data.
- Integrated legacy system with the ECC using sender File adapter and receiver IDOC adapter for Purchase Orders ORDERS05.
- Set up the ALE by creating partner profiles, configuring ports and creating port definitions and configuring inbound and outbound parameters for the partner profiles for EDI.
- Modified standard Scripts and smart forms according to client requirement.
- Modified standard screens using Enhancement spots according to client requirement.
- Fixed various EDI and ALE problem tickets in Production Support capacity.
- Designed and developed Several DIALOG DYNPROS to collect and trigger subordinate ALE processes that used custom IDOC and Function Modules.
- Conversion of the Material IDOC (Message type: MATMAS) to XML format and store the same in the application server for further use in XI/PI.
- Created IDocs in FI for sending FI document using FIDCC1 and IDoc FIDCCP02 and Invoice using INVOIC and IDOC INVOICE02..
- Sales: Defined and Assigned Sales Document Types, Item Category and Schedule Lines. Configured and assigned number ranges Delivery Types and Billing Types.
ENVIRONMENT: ECC 6.0 (MM, SD, FI, EWM, PM).
Confidential, East Hanover, NJ
Sr. SAP ABAP Consultant
Responsibilities:
- Developed screen for creating user roles using ALV (OOPS) where the user can create, modify and delete the user and save to database.
- Developed tab strips for creating authorization code and functional codes using ALV (OOPS) where the user can create, modify and delete the user and save to database.
- Developed tab strips for creating Default contract using ALV (OOPS) where the user can create, modify and delete the data and save to database.
- Evaluate performance of technical objects and tune objects for better performance using ST05, ST22 etc
- Created customized debit note, modified standard toolbar to add customized buttons and created customized search help for fields in ALV and added buttons in alv line items and worked on Modal Dialog box screen.
- Created various lock objects for customized tables to enque and deque the tables while inserting or updating the database.
- Worked on Business Transaction Events for FI/CO.
- Created Interface from treasury to bank after payment run with payment information.
- Created customized tables as required and worked on table maintenance generator.
- Responsible for development of outbound interface for Purchase Order using IDOCS.
- Implemented BADI to enhance Purchase Order Functionality in ME21N.
- Maintained partner profile and created inbound/outbound IDoc's to generate sales orders/purchase orders and involved in generating EDI's. Enhanced pricing catalog fields and thus pricing procedure determination using custom fields.
ENVIRONMENT: ECC 6.0 (MM, SD, FI, EWM, PM).
Confidential,Houston, TX
Sr. SAP ABAP Consultant
Responsibilities:
- Involved in SAP R/3 Version Upgrade from 4.7 to ECC 6.0
- Identified the key business process requirements and Correct Testing Paths
- Created high-level Summary Documents and maintained every step.
- Technical comparison of both versions of multiple R/3 Instances and updated Version ECC 6.0 with required customized code by using T-Codes: SPAU and SPDD
- Analyzed the SAP Released OSS notes and applied wherever required
- Responsible for post upgrade functionality testing
- Resolved all functional issues in SAP Data Archiving due to upgrade
- Developed aging report for customer & vendor according to client requirement.
- Developed user-exits for the T-code Fnv2 in the correspond tab to auto generate the file number.
- Developed various reports & smart forms and performance tuned the programs.
- Modified DUNNING form for the T-code F150. To generate reminder letters to customers for overdue items according to the client requirement.
- Developed smart form for T-code FNI2. This form is a contract and will be issued to customer at the contract stage.
- Setting up SAP-ALE (IDOC) interface by creating / maintaining distribution model, login system, message types, activating the change pointers, generating partner profiles. IDOCS reduction and filtering for the documents Material Master (MATMAS03).
- Developed Inbound Interface which Posts INVOIC02 IDOC's to SAP ECC via proxy for Invoice creation.
- Involved in performing Unit Test, Integration tests and tracking the defects to closure.
ENVIRONMENT: 4.7, ECC 6.0 (MM, WM, SD, FICO), Win 2000/XP, MS Office.
Confidential, Atlanta, GA
Sr.SAP ABAP Consultant (Team Lead)
Responsibilities:
- Developed Payment advice with check printing using table control and smart form, where the program can Send Mail with PDF attachment, Fax and SMS .
- Developed Mass upload using BAPI for Purchase Order ME21N.
- Developed Mass Upload using BDC for info record ME11.
- Developed Mass upload using BAPI Purchase requisition ME51N.
- Developed Mass upload using BAPI Material Master Creation MM01.
- Developed payment interface file for the bank to the external system for direct debit.
- Implemented BTE for transaction FB02.
- Experience working with various EDI standards (ANSI X.12) like EDI 850, EDI 834. Used third party software's like Conversion Agent to perform the EDI conversions to support various industry standards.
- Developed Mass upload for Budget t-code KO22 using BDC.
- Modified the standard Script for the check printing for t-code F110.
- Modified DUNNING form for t-code F150 and also developed the customized
- Badi for cash advance posting for t-code PRFI on METHOD exb706k. The purpose of this Badi is to control G/L posting for Cash Advance. The requirement is to post cash advance into respective entity account.
- Developed Upload program for t-code F-02 using BAPI. This program is to Upload Firm Expenses to GL accounts.
- Developed report detailed expenses. This report will provide detailed expense listing by engagement and employee to enable practice administrators and engagement managers to validate billable and non billable expenses.
- Performances tuned the P & L report and fix the bugs.
- Working on both Implementations and supporting issues on FI and EM modules.
- Developed Technical Specifications from Functional Specifications.
- Used Exit in MV45AFZZ to populate sales agreement on the Sales Order Line Item.
- Used Exit MV45AFZB to trigger pricing when determining a new agreement.
ENVIRONMENT: ECC 6.0 (MM, SD, FI, WM), Win 2000/XP, MS Office.
Confidential
SAP ABAP Consultant
Responsibilities:
- Created an interactive report program to give details on sales orders customer-wise
- Created report to display list of stock for a material with subtotal of stock for each storage location and grand total of the stock at end of the plant
- Created a Report to display a list of Purchase Requisitions with details like MRP Controller, Release Date and Unit of Measure along with standard details
- BDC: Uploaded data from sequential file to create multiple material master records
- Developed BDC Program for transferring Customer Master Record.
- Created multiple methods in the Implementation Class of a BADI for certain calculations like currency conversion, pricing simulation.
- Designed and Developed a BDC Program to upload Work Center (CR01) data and Vendor master (XK01) data from legacy to SAP R/3.
- Extensively involved in Implementing User Exits related to Billing (RV60AFZD) and Pricing (Move additional fields into the Communication table used for Pricing USEREXIT PRICING PREPARE TKOMK and USEREXIT PRICING PREPARE TKOMP).
ENVIRONMENT: ECC 6.0 (MM, SD, FI, PP, QM, WM), Win 2000/XP, MS Office.
Confidential
Technology Analyst
Responsibilities:
- Developed Aging Report for Customer.
- Developed Script for Payment Voucher For T-Code FB62.
- Modified the standard Script for the check printing for t-code F110.
- Performance tuning the programs.
- Developed Smart form Barcode printing for carton & Pallet label for their lot traceability system.
- Worked on the Bapi concept to release and change the Purchase Order by concern person using the Bapi BAPI PO CREATE1 and BAPI PO CHANGE respectively for that input field purchase document no (EBELN) using table EKKO and EKPO.
- Used BDC for transferring & conversion data into the SAP system. Wrote BDC programs to update and change Customer Master Data by session method for transactions VD01 and VD02 to update KNA1 table.
- Designed and coded a BDC program for Sales order that updated records in the sales order screen or will create new sales order depending on the source data file from external systems using VA01 and VA02 transactions.
- Designed and coded a BDC program for open purchase orders of known vendor (ME21) in Materials Management.
- Financial Data upload, Vendor Master Upload, Monthly Material price updates, Costing update
- Customer Master uploads: Quality Management data: Inspection Plans upload, Certificate of profiles, Conformance & Materials assignments upload through direct input and BAPI method.
ENVIRONMENT: 4.7E (MM, SD, FICO), Win 2000/XP, MS Office.
Confidential
Responsibilities:
- Developed a Sales Report to monitor order information flow of billing.
- Modified standard script for Credit Note and Debit Note.
- To track accurately Service Orders and Notifications developed a report called Warranty Order report. Clubbing of two standard transactions IW39 & IW59.
- Developed the Report for Global stock status for external procurement of finished goods using ALV.
- Analyzed and redesigned the reports on FI to improve their performance using in ABAP/4 Performance Tuning.
- Created an Interactive Report for displaying plant status report to know the status of a particular material.
- Certificate receipt incoming goods for INBOUND DELIVARY VL31N, VL34N and Included logic using function module in Sap Standard program MV50AFZ1.
- Modified SAP Standard form PSFC STD LAYOUT (PP Print Standard Layout Set) SAP Print program PSFCJOBT.
- Studying the User requirements, existing developed Programs, Layout sets, Modifying Programs, Transactions and Layout sets to get the User required Output.
- Developed BDC program to migrate Vendor Master Data from legacy system to SAP.
ENVIRONMENT: 4.6C ECC 6.0 (MM, SD, FI, IM), Win 2000/XP, MS Office.
