Functional Consultant Application Developer

Vishal Agrawal

Phone: 717-***-****

Email: ************@*****.***

***** ******* ****** **, *******, TX - 77433

Professional Summary:

18+ years of experience as SAP HCM Techno Functional Consultant with end-to-end implementations.

Citizen of USA.

Worked on multiple HCM US Payroll Projects as SAP ABAP Developer.

Developed Fiori applications, BTP full stack application on BAS, Free style and Fiori Elements based.

Created CDS Views on HANA cloud.

Expert in creating OData services.

Expert in Time, PA and Payroll modules in HCM.

Expert in FPM Leave Request Object Configuration.

Working experience in CPI integration between SF and LMS.

Main areas of expertise in ABAP/4 are Object Oriented methodologies, Web Dynpro, Adobe Forms, Enhancement Framework, BADIs, User Exits, Dialog Programming, HCM Processes & Forms, ALV Reports, SMARTFORMS, SAP Script, Module Pool, BDCs, RFCs, OSS Notes, creating and maintaining DDIC objects, Interfaces, HRFORMS, Debugging & Performance Tuning, HCM Processes & Forms, Logical Database.

Excellent troubleshooting and debugging skills.

Expertise in Functional & Technical specification writing skills.

Experience in holding UATs with the client.

2 years of experience as Team Lead/Coordinator.

WORK EXPERIENCE:

Huston Independent School District, Houston TX. April2021-Current

Role: Specialist Application Developer

Added the Customer Fields in ESS/MSS Leave Request screen. To achieve this, I used Webdynpro Component ‘FPM_FORM_UIBB’ and Component Configurations ‘HRESS_CC_GUIBBF_LEVREQ’. Webdynpro Component ‘FPM_OVP_COMPONENT’ and Component Configurations ‘HRESS_CC_PTARQ_LEAVREQ’. Also extended the standard structure 'HRESS_S_PTARQ_LR_FORM'.

CPI Interface is created using cloud integration tools to automate and overcome the manual process of extracting and updating of Org. and Job data between SF BizX to SF-LMS database. File is picked up from SF SFTP and is filtered and massaged using XSLT, groovy scripts it is then converted to CSV format from XML with defined columns as per the LMS data connectors requirement.

Working on HRASR_DT reports. Working with users to write Functional specs to customize existing applications.

HISD runs a payroll of 30k employees. Production support mostly includes intense debugging, changing adobe sign, so10 texts, W2 OSS.

Develop HCM Process and Forms applications of a regular basis for teachers, HR Users, Principals.

Worked on multiple tickets related to validations in time entry attendance type etc. Logic is mostly based on finding unaccounted hour for the week, scheduled hours for the week, ESS hours for the week, CATS leave hours for the week.

Developed an interface which reads training data from SuccesFactors and updates that in a new Infotype 9005 GT Certificate. Runs as daily update.

Developed Covid Stipend application for all HISD employees. Employees with see the application in ESS. They filled the application and attached their vaccination certificate to claim one time stipend.

Total reward statement view was in Adobe. Chrome does not support Adobe so changed the view accordingly in Web Dynpro.

Worked on two CPI interface to Upsert SSN and appStatusId in SF for PERNRs received as input file.

WORK EXPERIENCE:

PA turnpike Commission, Harrisburg PA. Jan’2019 – April2021

Role: Consultant

Completed SPAU/SPDD on 4 landscapes for year-end upgrade.

Complete overhauling of Dunning Letters using SAP Script and SO10.

Developed Pay slip on Adobe Form using HRFORMS as source of data.

Worked on PO and Contract mail rejection and approval logic. Worked extensively on BADIs i.e. BBP_DOC_CHECK_BADI and BBP_ALERTING_BADI.

Implemented a few methods for ‘RH_SFI_SYNCHRONIZE_EMPL_DATA’ to sync employee data with SuccessFactors.

Made changes in mails triggered through Workflow on PA40 for various action types and status codes.

Handling great number of debugging related issues for HCM, SRM and FI i.e. missing text from pay slips, dump in pay slip for an employee in ESS, FMDERIVER Upgrade issue.

Made changes to SECA (Self-Employed Contributions Act)

form a Web Dynpro Application.

Developed multiple HCM interfaces which write data on shared server or send data through mail daily as BG Job i.e. SERS, Vehicle Plates.

Modified Automatic Payment Program Logic to handle the PennDOT Restoration payment and associated G/L Account Posting as per the business requirement. TCODES used – FB60, F110, FBL1N, FBRA.

Make changes in Adobe forms related to FI and HR.

Developed multiple SRM reports and Enhancements i.e. PO and Contracts.

Worked on SPAU after support package implementation.

Developed ODATA Services for multiple users.

Atos Origin, Mumbai Sep’16-Oct 2018

Role: Consultant

Key Responsibilities:

Worked as SAP ABAP consultant at IIT Bombay SAP Implementation.

Project at Atos Origin:

Indian Institute of Technology Bombay Sep’16-Oct’18

Role: Consultant

Developed Pay slip on Adobe Form using HRFORMS as source of data.

Developed an ABAP Web Dynpro application that uses CAPCHA functionality for login screen.

Developed multiple HCM Process & Forms: Employees fill forms on portal for Medi-claim, Reimbursement, and Overtime etc. Developed these forms using HRASR_DT using HR Forms & Processes. Events of these forms use individual BADI and a Feeder class CL_HRASR00_FPM_FEEDER. Developing Forms and conducted UATs.

Developed multiple Web Dynpro applications for module E-Recruitment.

Extended Purchase Order BAPI to accommodate some new customer related custom fields.

Designed OData data models to fetch header data from EKKO (PO Header) and item data from EKPO (PO Document Items) and then fetch line items for header data based on association and navigation.

Generated Odata Service that exposes material master data. Generated OData service to be consumed in Fiori App.

Capgemini – AppsOne, Mumbai Dec’14 - Sep’16

Role: Consultant

Key Responsibilities:

Worked as SAP ABAP consultant with Capgemini for clients like Afcons Infrastructure, MRF, ZS, and Mother Dairy etc. Afcons was implementation and I was at client site Andheri West.

Project at Capgemini:

MRF Ltd.: Oct’15 - Aug’16

Role: Consultant

Worked as an ABAP consultant on multiple modules.

Validations in BADI ME_PROCESS_PO_CUST for PAN no and minimum and maximum amount in PO.

Developed BDCs to create vendors and extended vendors.

Developed Smartform for displaying the Purchase Order Acknowledgement.

Enhanced many custom infotypes as per user requirements.

Developed various forms for MM module including Purchase Requisition form, Contract form, PO form.

Modified the Sales Order User Exit MV45AFZZ for matching Apple Requirements for AOE Process

Modified the Billing User Exit RV60AFZC, RV60AFZZ based on client requirements for Tax Calculation at the Invoice Level.

.

Afcons Infrastructure Limited: Dec’14 - July 15

Role: Consultant

Implementation project- Worked mainly on PMS related reports a bit on payroll.

Developed pay slip on Adobe Form using HRFORMS as source of data.

Worked on BADIs like 'HRHAP00_VAL_DET' to allow defaulting Training and development plan from appraisal document

Worked on BADIs like 'HRHAP00_DOC_BC' to throw error messages on appraisal document if an employee is rated either too low or too high

Developed Training Calendar report based on Web Dynpro. An employee can see what all trainings he or she is entitled to.

Developed a mass upload program to create Appraisal Document for all employees eligible for appraisal in a cycle. Functions used ‘HRHAP_TEMPLATE_GET_DETAIL’, 'HRHAP_DOCUMENT_CREATE', 'HRHAP_DOCUMENT_CHANGE_STATUS'

Developed an Upload Program to update General Attribute Maintenance for Type (D, Business Event Type) using functions 'RH_OM_ATTRIBUTES_INSERT' and 'RH_OM_ATTRIBUTES_UPDATE'.

Developed master interface for 585 (Section 80 Deductions), 586 (Section 80 C Deductions) etc.

Individual Development Plan report is generated for an employee any time throughout the year to monitor the planned IDPs and the actual actions taken by the employee. Used Web Dynpro for this requirement.

Yash Technologies Mumbai Apr’13- Dec’14

Role: Consultant

Key Responsibilities:

Worked as consultant with Yash technologies for clients like CEAT, Anchor, L&T, SBI etc.

60 Days FeedBack - Designed a Webdynpro component for new employees to give their feedback after they have finished 60 days in SBI. Feedback form saves all the results through RadioButtonGroups indexes into a custom table. The custom table can then call using a custom program which uses an ALV to show all the details.

Used User Exit CATS0006 to validate CAT2 entry.

Used ‘MB_MIGO_BADI’ to create a tab in MIGO. Tab used a table control matrix to get packing details of quantity as input from user. At users command smartform gets generated based on data from the matrix.

Designed BAPI program for material extension for the client CEAT using ‘BAPI_MATERIAL_SAVEREPLICA’. Transactions used SE37, SE38, MM01, MM02, MM03.

Worked on BTE’s and Validations in FI for F-43, FB01.

Worked on multiple BI functions.

Fantastic Advertising

Entrepreneur Sep’08–Mar’13

Produced advertisements and projects as freelancer. Budgeting projects, hiring manpower, equipment, locations were part of my duty.

IBusinessSolution, Harrisburg, Pennsylvania Mar’05-Jul’2008

Role: SAP HR Principle Analyst

Key Responsibilities:

Worked in United States with IBusiness Solutions as Principal Analyst for more than three years.

Projects with IBusinessSolution

Pennsylvania State System of Higher Education, PA: Mar’06 – Jul’08

Role: SAP HR Principle Analyst

Enhancement of fast entry Screen for info type 2010 and 15 to add WBS and Cost center.

Worked on Payroll Check printing script YPCC_CHECK_UNN changed the driver program ZPYRFFOUS_C. I changed few things like logic for mailing address, leaves data etc.

Developed various Custom wage types from the Model wage types for paying out basic pay and effecting deductions with balances and totals and additional payments to the employees.

Use various reports like wage type reporter, payroll journals and cost center report for biweekly reconciliations and trouble shootings for various inaccuracies.

Worked as key team member during upgrades and several support pack implementations, did SPAU, SPDD reconciliations, wrote test scripts and tested various payroll transactions.

Worked on Personnel Actions and Dynamic Actions in personnel administration. Created new personnel actions like ‘Student pay Change’, ‘Benefits enrollment’ etc.

Developed inbound interface to update 0014, 0015, 0386, 0169 with data coming from third party vendors. Used HR_INFOTYPE_OPERATION to update infotypes.

Designed and developed the Deferred Overtime project for Banking of Overtime hours for service employees using CATS for the data feed for HR.

Developed numerous outbound interfaces for HR to comply with vendor’s requirements such as Aetna, Highmark Blue shield, United Concordia and others.

Efunds Corporation, Minneapolis: Oct’05- Mar’06

Role: Software Programmer

The legal entity changes in Deluxe lead to changes in Infotype 0001. Earlier the Personnel Sub area was used for the determination of the part time and full time employee but the current scenario Personnel Sub Area holds the Tax entity. I wrote conversion programs to change the infotype 0001 and 0000 for active and inactive employees. The programs are different as active employees were rehired but for inactive only infotype 0001 was to be changed.

Created an outbound interface of Credit Union deductions after each staff monthly/weekly payroll. (Infotype 0014)

Added a User Exit for the Benefit plan. The requirement was to group employees based on their original hire date on (Infotype 0041).

Created customize tables and wrote conversion program to uploaded master data.

MIT, Cambridge: Apr’05 – Oct’05

Role: SAP ABAP Consultant

MITSIS Bio Feed: Mitsis Bio Feed is an inbound interface to upload the graduate and undergraduate student in MIT to The SAP system. MITSIS is the system of record for student information. MITSIS sends an incremental file of changes each day. The MITSIS Bio feed program reads the MITSIS file from the SAP application server. The program does a consistency check before taking any action. It treats every record as the final word from The MITSIS Bio feed program Create Undergrad, create Grad, Transfer TEM person to Grad/Undergrad, Transfer Undergrad to Grad, terminate grad/Undergrad or it updates existing PERNR or it determines that no action is necessary in SAP. Used Call Transaction Method and function ‘HR_INFOTYPE_OPERATION’ to carry out the process. Infotypes worked upon are as follows. (IT0000, IT0001, IT0002, IT0006-1, IT0006-9, IT0007, IT0008, IT0009, IT0048, IT0094, IT0105, IT0207, IT0208, IT0209, IT0210, IT0210, IT0235, IT1000, IT1001, IT1008, IT1013, IT1018, IT9105). I have done extensive work on FICA exemption for graduates and undergraduates.

Designed and developed an outbound interface to provide new benefit enrollment in flexible spending accounts for medical and dependent care to Benefit Concepts on a weekly/monthly basis. It only includes new enrollment in one/both of the plans. This process is also used annually to send all new enrollments for the following year into these plans. (Infotype 0170).

Developed a conversion program to upload an extracted file for infotype 14 and 15.

Developed a conversion program to update the vacation eligibility through Plan maintenance (PP02).

Designed and developed Child Support Garnishment Report for HR. (infotype 0194)

GE Energy, Mumbai Jun’03 – Feb’05

Role: Software Engineer

Key Responsibilities:

Worked as software programmer with Bently Nevada.

T & L Expense Report: SAP system does not provide a summary Expense Reporting tool that meets the needs of the local International payroll entity for paying expenses incurred by Service personnel. Currently the Field Engineers were to input expenses into two databases. It was Services desire to enter the expenses only once, and use SAP as the expense vehicle where GE T&L does not exist as a reporting tool for reimbursement.

I proposed the solution of using existing program “SAPLSLVC_FULLSCREEN” and change it according to the requirement. (CJ20N, CATSDB, CATS2, PR05, PR20, ALV GRID)

Developed a Service Overdue Report tracks the jobs that are overdue with regard to customer want dates used SAP objects like PRPS, PRTE, HRP1001, PROJ, JEST, TCJ04, TCJ05, and PA0001.

Developed G/L ledger, Customer Ledger and Vendor ledger reports, Trial Balance Report, Vendor Ageing, and Customer Ageing Reports.

Qualifications/Education

Degree/Diploma

University

Year

Grade

Master of Management Studies

Lucknow University

1997-1999

I

Bachelor of Management Studies

Lucknow University

1994-1997

I

Trainings Attended:

Training in SAP SD module from Growel Softech, Mumbai during year 2002-2003.

Training in Foxpro and Visual Basic from Aptech Computer Education, Lucknow during year 1998-1999.

Contact this candidate