SAP ABAP S4 HANA Technical consultant Resume Lake Forest, IL, USA - Hire IT People

SUMMARY

Native SQL Script, create SQL Script procedure and UDF.
Created Attribute and Analytic view.
Create Dimension, cube and star join type Calculation view utilizing input parameters, variables, currency and unit conversion.
Implement Analytical Privilege and Decision table.
Create View proxy on Information model.
Core Data Services (CDS) and VDM Techniques.
S/4 HANA Embedded analytics (Query Manager, OVP)
Worked on Hana Data provisioning using SAP Landscape Transformation (SLT) to replicate data from ECC ERP Application to HANA Landscape through SLT server.
Performance Tuning using SCI, ATC, SQLM, SWLT.
Worked on HANA DB Migration project for Code Readiness with the help of Simplification Database.
Worked on HANA Data Provisioning using BODS.
Functional knowledge & technical expertise on multiple SAP Modules i.e. SAP ABAP (Certified), FI, SD, MM, PP, GTS, APO, CRM, WM, SAP IS/M.
Performed Performance Tuning & Analysis using ABAP/4 Runtime Analysis Tool and SQL trace for query optimization to improve overall performance of several program.
Expert in object - oriented methodology.
Hands on experience on OData SAP Netweaver Gateway.
Very strong debugging skills and quick problem-solving skills.
Extensively worked on transferring data from legacy to SAP system using various data transfer techniques such as LSMW (using Batch Input and Direct input) and BDC.
Expertise in Dialog Programming Using Screen Painter and Menu Painter.
Worked with interface for file upload/download using file-handling techniques.
Developed and modified existing forms using SMARTFORMS and Adobe form.
Experienced in using various modularization techniques like subroutines, Function modules, RFC’s, BAPIs.
Expertise in ABAP Classical, ALV and Interactive Reports.
Extensive experience in analysing runtime errors and debugging ABAP programs.
Good hands on experience in enhancement like BADIS and USER EXITS, OOP's and RFC technology in SAP R/3
Ability to write and validate the technical specification and able to create test Scripts
Strong skills in Technical analysis, designing, reviews, testing and implementation of SAP developments.
Experienced in data dictionary objects such as Domain, Data Element, Table, Search help, Views.
Good exposure in ALE, IDOC, CIF.

PROFESSIONAL EXPERIENCE

SAP ABAP S4 HANA Technical consultant

Responsibilities:

Analysed simplification database using ATC for S4/HANA readiness on custom development using check variant S4HANA READINESS 1909.
Worked on Prepare Phase and Realize phase using SAP ACTIVATE Methodology for custom code evaluation. Performed SAP HANA Checks, SAP S/4 HANA checks, Code adoption and performance tuning.
Performance tuning using ABAP Test Cockpit with inspector check variant PERFORMANCE DB.
Used SQL Monitor tool (SQLM) and SQL Worklist Tool (SWLT) to find out the list of objects and build scope list which needs performance tuning.
Created POC on SAP Fiori Master detail application using CDS View.
Created POC on CDS View for S/4 Embedded Analytics (Query Browser App), Analytic Tools (RSRT) and Transactional App S/4 HANA.
Created DCL on CDS Views to invoke security on the CDS views.
Created CDS Table function with parameters to achieve join between two tables using marker Class.
Created List Report Application using WebIDE (Smart filter FIORI Application) from CDS View with help of BOPF integration and UI Annotations. Also extended the UX by implementing Hook methods by adding validation and determination and built a Transactional APP.
Worked on BODS Designer Components-Jobs, Workflows, Data Flows, Formats, Data Store and Scripts.
Extensively used ETL methodology for Data Extraction, transformations, loading using Data Integrator.
Created delta Jobs to load data from legacy source to SAP system based on the business rules provided.
Analysed the error log for trouble shooting batch jobs.
Interacted with Functional team to fix the load errors at ETL end.
Created idoc interface (Idoc type: WMMBID02) between Manhattan WMOS system and SAP for warehouse operation like goods receipt and goods adjustment for Vendor PO, DC to DC transfer, return to DC and eCom returns when inbound shipment is received in WMOS.
Worked on custom BOL smartforms.
Created BODS for inventory sync process.
Created POC on Over page (OVP) Fiori app using Consumption CDS View/Web IDE to display dashboard report on IDOC processing.
Designed and built custom functionality to implement smaller assortment of articles for Fast fulfilment center. This will help the business to identify articles and carry a smaller assortment, rank the articles and identify its source of supply and assortment category.
Create article assortment/assortment modules and listing for sites for ULTA Fast fulfilment centers to fulfil ECom orders. Create custom process and programs to support the business functionality. Build logic for multiple criteria to rank the articles in BW/HANA for example Articles master data, Past sales, forecasted quantities, Fragrance and Aerosol identification criteria ect.
Created API PROXY to create and update article master. Payload comes from PIM through PI. Also extending the articles to all stores and DCs.
Created POC on REST API using ODATA Services for Sales Order status report based on schedule line item.
Experience in leading and guiding teams to develop and deliver project goals. Roles Performed as Technical Solution Architect, Technical Leader and Developer.
Senior local point of contact for delivery of SAP services. Responsible for performance of Technical SAP team from multiple vendors and reporting to SAP IT Director of success, progress as well as challenges and risks.
Actively involved into cutover plan and prepared hypercare dashboard report.

Environment: SAP Version 7.5, HANA 1809, BODS 4.1

Confidential, Lake Forest, IL, USA

SAP ABAP S4 HANA Technical consultant

Responsibilities:

Involved into HANA DB migration project and used Code Inspector and ABAP Test Cockpit (ATC) to find out error prone objects which may lead to a spurious result and fixing the objects for HANA DB readiness.
Involved into SAP Upgrade project from ECC 6.0 to EHP8 NW 7.5
Worked with Archive team, OM, SCM and FFS team closely on number range clean up project and developed a processing program which helped all teams to reduce both time, money and effort considerably. This process actively makes the billing documents eligible to be archived so that the number range can be re-used in the future.
Developed Back Order Report in OOPS ALV.
Involved in GCom BennMan project and developed several reports and interfaces.
Developed Order Audit report for Audit purpose.
Developed utility program to compare any table contents between R3 system and the backup .dat files.
Developed Sourcing RFQ Email for Canada to contain the body of the response so the vendor can just fill out and return with a PDF attachment.
Developed REST API to invoke employee purchase program for Confidential .
Developed Return Order confirmation using ADOBE Form.
Developed SOE CallCreateCICInteractionService in CRM system.
Developed several SOAP API Services (REST APIs) to consume the functionality in SOE.
Worked on an enhancement to implement functionality related to Employee purchase order.
Involved and organized daily Scrum, Sprint Planning, Sprint Review, Sprint Demo, Sprint Retrospective and Team Story Grooming sessions every week.

Environment: SAP Version 7.4.

Confidential, Hoboken, NJ, USA

SAP ABAP HANA Technical Consultant

Responsibilities:

Learnt new SAP Module IS-M and developed/designed complex objects related to subscription and renewal module.
Developed custom interface program and IDoc to transfer external price list to TIBCO from SAP which includes list price, Agent NET Discount prices, Deep discount prices and product attributes in XML, CSV and XLSX format.
Worked on an enhancement which allowed Confidential users to Display and change Renewal profile determination tables, Renewal profile tables, Notification tables, Notification profiles tables, Activity table and Renewal plan table.
Developed a custom report which gives details about current and past subscription data to determine the no of issues they should print for each journal publications.
Worked on Invoice forms which cover Non-EAL invoices, CSS, TBT and Societies. These forms has ability to re-print upon request and will be mailed by Bill trust (In US) / Quick issue (Outside US).
Involved into several performance improvement initiatives during SIT 1 and SIT 2 phase by restricting Select statements, using inner joins, changing where statements, creating secondary Indexes, defining buffered table, using hashed tables, avoiding linear execution and introducing several modularization techniques etc.
Responsible to work on showstopper defects and provide resolution maintaining SLA.
Performed project reviews and quality assurance roles in the area of ABAP domain in SAP Media module. Provided my expertise in designing complex cost-effective solutions, creating high level technical specification, performance tuning, system integration and managing onsite-offshore model.
Good experience working with project management tools such as MS Project, Share point and JIRA.

Environment: SAP Version 6.0.

Confidential, Minneapolis, MN, USA

Onsite Delivery Lead - AMS and SAP ABAP Technical consultant

Responsibilities:

Developed program got GTS Product master HS Code conversion.
Developed program to Mass upload of material pricing group and material plant into GTS.
Developed interface program to receive product numbers in SAP from EPR.
Developed a report to retrieve UPNs by product no and display all fields that are relevant to differentiating UPNs for regulatory License management purpose and compliance reporting.
Developed program to manually upload PO pending changes to APO DP using BAPI BAPI PBSRVAPS CHANGEKEYFIGVAL2.
Developed few other complex enhancements in APO SNP and PPDS are which need continuous interaction with user/Functional consultants.
Worked with Integration Model, Core Data Interface (CIF), Live Cache, Planning Areas, Planning Books related developments.
Perform project reviews and quality assurance roles in the area of ABAP domain.
Responsible for all AMS development tickets for SD, MM, FI, APO, CRM, GTS modules.
Involved in consulting, development, UAT, end-user training, cut-over and post go-live support.
Manage, track and communicate overall RICEFW development progress to higher management.
Provide technical approval for final functional spec for each assigned RICEFW object.

Environment: SAP Version 6.0.

Confidential, Peoria, IL, USA & India

SAP ABAP Technical consultant and Onsite Development Lead

Responsibilities:

Thorough knowledge in interfacing Master and Transactional data from ECC to APO using CIF. Worked Extensively on Material CIF enhancements at both ECC and APO level.
Worked on Dynamic CIF of Info records (PIRs) and Contracts in ECC during their creating for a particular Order type. Implemented CIF user exits to avoid SMQ1/SMQ2 queue failures.
Developed an enhancement on SAP R/3 order processing functionality which needs to be extended to support Confidential order processing and business requirements specific to performance measurement of CAT order to delivery activities from the time the order received till the time order being delivered. This includes PSL Date, Order change freeze date, Planned PGI Date and confirmed PGI Date.
Developed an enhancement which will be used to post monthly JE Purchase Accounting postings for: (1) Third-party drop shipments (2) Subcontracting. The auto JE will get triggered as a part of FI GL month end closing process.
Developed a very complex program related to the Order promise date which encompassed (a) initially providing the OPD value, (b) calculating the OPD tolerance range (OPD Min and OPD Max values), (c) the ability to launch APO, the Sales Order, and the Production Order, directly from the report to either view or change values to drive a different CPGI/PPGI Date, (d) calculate the amount of time has passed since the Order Acknowledgement was sent relative to the execution time of the report & (e) either approve the OPD value or revise the OPD later.
Worked on an enhancement for certain sales models that need to be invoiced in USD and the account coordinators have to manually change the currency code in the sales orders. So currency needs to be changed and exchange rate needs to be re-determined.
Developed shipment order status report to support the Management to plan for Shipment and view past shipments in Mach-1. This Report can be used by the Operations Manager to collectively display of - 1. Key information for Sales Orders & related Production Orders. 2. Key information for planning shipments 3. Key information for completed shipments.
Manage, track and communicate overall RICEFW development progress to higher management.
Coordinate the detailed activities of development resources. Manage, track and communicate status for all assigned RICEFW development work.
Ensure the identification and documentation of all RICEFW development dependencies.

Environment: SAP Version 6.0.

Confidential, Allentown, PA, USA

SAP ABAP Developer Development Coordinator

Responsibilities:

Developed MSDS Conversion program to import MSDS from MSDgen to SAP and hung on associated real-subs. This will allow internal and external customers to access MSDS, keeping Confidential compliance.
Developed Conversion for DG classification which will be used in Bill of Lading, Sales declaration forms, Air declaration and manufacturing documents including product inner container, product outer container and markings.
Implemented BADI EHS DG 001 (Check frame shipment) to check Florida Ether limit as Florida Ether law required permit to purchase and sell Diethyl Ether and ether containing mixtures greater than 2.5 gallon within the state of FL DOH.
Implemented enhancement to calculate WIP as DLV when the received qty is within the tolerance of the planned qty.
Implemented enhancement related to STO in GTS which will be used to move stock between Confidential plants in the system as some plant movements will involve cross border activity where Confidential is the exporter of the record. This will provide visibility to licensable movements prior to staging material for load to conveyance.
Implemented EXIT MM06E005 EXIT SAPMM06E 013 to invoke PO compliant control in GTS to placement of demand on the vendor when the transaction is determined a risk in the system upon checking a status of the PO in GTS. This will put a compliance hold on the PO.
Implemented 3rd Party Compliance Control Check in SAP GTS to enable capability to prevent a PO being sent to a vendor when the Sales Order is on hold.
Developed CIF interface in order to perform Demand Planning in SCM 7.0 as certain types of the materials Master data will be transferred from ECC to APO upon activation of Integration Models for both Products and locations.
Build an interface with TRAX system to create necessary Export documentations from US which includes 3 files. Customer Master, Product Master and Transaction.
Preparing estimates for all assigned RICEFW objects assigned using client specific template and approval process.
Manage and coordinate overall activities of development resources for SAP development work.
Provide implementation and go-live support of assigned RICEFW objects.
Document and ensure adherence to development processes and strategies using several tools like Confidential Team Room, GDMS, SAP Solution Manager

Confidential, Milwaukee, WI, USA

SAP ABAP Developer and Development Coordinator

Responsibilities:

Developed billing documents based on the invoices from Confidential invoices system which created the dealer invoices for vehicle and PAM orders for York location.
Worked on enhancement for Phase 2 of GDP for motorcycles order processing on the Global Dealer Portal (HD-Net).
Developed conversion program to convert Avantis York entity structure into the new SAP Functional Locations.
Developed conversion to load SAP equipment class and characteristics data with Avatis York equipment specification sheet data that contain additional information for the shop floor equipment.
Developed conversion program to transfer equipment master from York Avantis System into SAP.
Worked on an enhancement to update the SO with Product Hierarchy to Level 5 and Model Year.
Developed RF transaction to enable RF Functionality for TCode LT09 which is used for creating transfer orders for storage unit (Bin to bin transfer).
Developed enhancement to updated deliveries with PGI for P&A Materials shipments while USP worldwide shipment is used at York facility.
Developed interface program to send CKD Shipment details to CI System which will be required for the users to prepare the international shipment invoices from CI System.
Developed program to provide APO DP with retails sales data from Nova-view \Visa which is a key input to forecasting production and sales.
Developed Product mix Maximum output report for work centers based on components which will enable capacity planners to determine maximum part output for a given work center based on the current demand scenario.
Ensure controls and signoff of each step in the development process for RICEFW objects.
Responsible for quality assurance and development standard compliance for all assigned development work.
Provide technical approval for final functional spec for each assigned RICEFW object.

Environment: SAP Version 6.0.

Confidential, US, New Jersey

Application Programmer and SAP ABAP Consultant

Responsibilities:

Configuring the SAP FI as per the Customer requirements.
Understanding new business requirement upon consultation with customer and preparing new business requirement documents.
Coordinating with Offshore team members and helping them to deliver objects in a smarter way.
Testing the configuration / objects done by the Onsite team members / offshore team members for verification purpose.
Provide production support to SAP FI module.
Solving tickets and maintaining SLA/SLO for them and driving the team towards the same goal.
Helping other team whenever needed/issue is related with Finance and other applications as well.
Providing technical assistance during US day-time.