Avanthi C
E-mail: abloq1@r.postjobfree.com Ph nr : 614-***-****
__________________________________________________________________________
Summary
. SAP Technical Architect with 8+ years of IT experience in SAP which
includes HR technical, functional and Logistics modules working in
both industry & consulting.
. Conversant with all phases of SAP R/3 implementation to include
project preparation, gap analysis, blueprint, realization, cutover and
go-live
. Accomplished with strong Know how of HR Modules like OM, Time
management, PA, Payroll, and Benefits.
. Experience in SAP Application Design, Development, Customizing,
Support and Upgrade.
. Designed and implemented Reports, Function Modules, RFC, Dialog
Programming, ALV Grid, Interfaces, SAP Script, Smart forms, Adobe
forms and Object Oriented Programming.
. Developed Outbound and Inbound programs for HR benefits processing
. Troubleshooting experience in tracing back the issues with the
Functional configuration such as errors with PCR's and Schemas.
. Extensively used Logical Database PNPCE, PNP and macros for HR custom
developments.
. Designed and developed several web services for Interfacing with
Legacy system and also involved in the creation of Dynamic actions.
Experience in User Exits, SAP Enhancements and BADIs.
. Hands on SAP HR Workflow Configuration and customizing experience.
. Designed Interfaces programs between SAP and Legacy system using, BAPI
and IDOC.
. Knowledge of BI with PSA, Info Sources, Transfer Structures, Update
Rules, Start Routines and Extract Structures.
. SAP Product versions experienced with ECC 6.0, 5.0, 4.7, 4.6c, 4.6b
Certifications
. SAP Certified Net weaver development consultant (ABAP)
. SAP Certified Human Resources - Management consultant (HRMS)
Work Experience
Client : Digital River Inc, Minneapolis (Apr 09 -
present)
Role : SAP HR Techno Functional Consultant.
Project description : Implementation & Support
Designed and developed benefit interface programs to process the
continuation of benefits coverage such as Benefits eligibility report,
COBRA Termination etc.
. Developed reports and applications that required input/output to info
types, HR objects and payroll clusters
. Employee Data Conversion: Created a BDC Program to upload employee
information using Session method that includes employee actions,
organizational assignment, personnel data, Addresses, basic pay and
bank detail..
. Designed several custom reports using PNP Logical database and
standard Macros.
. Outbound interface: Created an interface to generate an outbound file
for Vanguard Retirement Plan from the result table based on the wage
types for Vanguard. This also generates a report along with the
outbound file. This Report/Interface was created by extracting
information from Payroll Results Cluster (PCL2) and Results tables
using PYXX_READ_PAYROLL_RESULTS.
. Implemented a CATS user exit CATS0005,CATS0002 to accommodate custom
fields and validation of Time sheet
. Created custom reports such as Monthly Over time approval report using
ALV Grid and Ad-hoc queries for Business users.
. Designed and Developed Dynamic actions for triggering SAP
notification.
. Plan Premium Report: Developed a classical report which displayed the
Employee Benefit information about which payments are made in which
plan like Health Insurance, Vision Coverage, and Dental.
. Time Report: Developed an Interactive report to display the number of
absences, attendance, and overtime hours using the Infotypes 0002,
2001, 2002, and 2005. Based on the selections taken in the data entry
screen the data from the corresponding Infotypes is displayed.
. Developed new infotypes for various custom requirements.
. Involved in the Development of Custom Object creation for the OM
module and also development of infotype for the same object.
. Good Understanding of Structural Authorization in Organization
Management module.
. Involved in the development of Schemas and Personnel Calculation rules
for Time Management.
Client : Vulcraft, Brigham City, Utah (Jan 2008 - Dec
2008)
Role : ABAP HR Consultant
Project Description : Extensively used OO ABAP for all custom
developments
. Designed interactive reports using PNP Logical database for listing
the employees based on the selections made by the user in the
selection screen such as company code, personnel area, employee group
and employee sub-group.
. Designed report to display the list of the available positions in a
particular department in the organization, by fetching data from
HRP1000 and HRP1001 tables.
. Created multiple BDC sessions for HR-PA data conversion project from
legacy systems to SAP. The employee master data migrated from
PeopleSoft for Initial Conversion and Conversion-Hire. Infotypes
(IT0000, IT0001, IT0002, IT0006, IT0008, IT0009, IT0014, IT0015,
IT0021, IT0041, IT0104, IT0105, IT0107, IT0108, IT0109, IT0194,
IT0195, IT210, etc.) had to be loaded in a specific order to fulfill
the functional requirements.
. Designed the functional and technical specifications for conversion of
Planned Working Time (Infotype7) and Tax Info types (207 - 210) and
developed the same.
. Developed program to convert payroll data for IT 221(Payroll Result
Adjustments) for specific wage types using Batch Input.
. Designed smart form that displays the salary information for employees
through ESS navigation menu. Used BAPI to get the salary information
for employees.
. CATS Data Transfer report: Developed a program that used to verify
CATS data has successfully transferred to time infotypes (2001 and
2002) and that the Infotype data matches the CATS data. CATS data may
be missed during the "Transfer to target components" process due to
locked personnel numbers. This report shows CATS data that has no
corresponding Infotype record..
. Involved in Development of reports using Component controller of ABAP
Web dynpro
. Developed several HR forms for Time sheets, Compensation breakup and
Exit Interview forms.
. Designed a report which list the changes relevant to master data
infotypes.This report is scheduled in the process chain before the
payroll process is initiated.
. Developed custom Infotypes and also enhanced the existing infotype to
fulfill the business requirement
Client : Tyco Electronics, Harrisburg, PA (Mar 07 - Nov
07)
Role : Technical Lead
Project Description : SAP ABAP and HR Upgrade from 4.6 C to ECC 6.0
. SPAU Adjustments - With and Without Mod adjustments for Standard
Programs.
. Standard Code Remediation for Unicode and Non Unicode custom programs.
. Correcting the EPC errors by replacing obsolete statements and
Function Modules.
. Designed Data conversion and interface programs for the new
transactions such as creating rebate documents.
. Involved in Quality related activities such as QC for the Code
Remediation work
. Application Support during testing & implementation.
. Technical coordinator for ABAP and product related Queries
. Testing and applying Enhancements where exits are been replaced with
BADI for the new release.
. Developed BDC programs where there is change in the screen sequence
for the upgraded version.
. Code remediation for Reports when old functions modules need to be
replaced
. Utilized SAP OSS for some non-standard errors, getting release notes
and applying the related patches to resolve the errors wherever
required.
. As per the HR Upgrade modified several reports which were using PNP
Logical Database and replaced with PNPCE and reworking on code to
ensure the business goal.
. Changed several custom programs which were using old ALV function
modules as that was effecting the overall code
Client : Farm Credit Canada - SAP CANADA (Oct 06 -Jan
07)
Industry : SAP Consumer Mortgage and Loans Implementation
Role : ABAP Consultant
Project Description : Application development and support
* Designed Output notification for distribution notice using SAP
Smartforms
* Involved in Creating HR reports, Payroll reports.
* Cloning a Standard Incoming Payments program for adding additional
fields and handling the logic to process them.
* Worked on Reports such for third party Payments download.
* G/L Interface - Interface from SAP to People Soft to transfer GL
Account balances per fiscal period.
Client : Areva- HORIZON, US (Jan 2006- Sept 2006)
Industry : Energy Sector
Role : ABAP HR Consultant
Project Description : HR Development and Support
* Involved in Creating HR reports, Payroll reports.
* Developed report which gives org details for the Employee. Used
Logical database and Macros.
* Developed report to retrieve the payroll results by reading the
cluster directory using CU-READ_RGDIR and Payroll results using
PYXX_read_Payroll_Result.
* Developed Monthly salary report and displays the monthly salary
statement in ALV format. Used PXXX_Payroll_Result FM to read the
payroll results and clusters.
* Developed ABAP queries using SQ01, SQ02.
* Enhancement: Created a Function module to get the payroll status based
on the input parameter payroll area from the database table T569V with
the export parameter as status of control record and import parameter
as payroll area.
* Worked with inbound interface for Absence Quota Correction to update
Info type 0008; and to create employment remuneration information
records in Info type 2010 respectively.
* Developed Labor welfare Report and used Logical database PNP.
* Debugging the code related to payroll reports and fixed the payroll
bugs.
* Developed Compensation Flexible Employee Data Report, Personnel
Flexible Employee Data Report, FMLA Event Tracking Report and Position
Control Report.
* Worked on BDC to upload data to infotypes 0014 and 0015.
* Modified the component under enhancement PBAS0001 to validate the info
type information.
* Created a user-exit to validate time sheet, the enhancement used was
CATS0006.
* Implemented an user exit EXIT_SAPFP50M_002 for Grievance Infotype
(0102) to check if the user enters a personnel number, grievance
number and stage for which the record already exist in the table
(PA0102) for the same personnel number, then system should throw an
error message.
* Developed function modules to determine the tax company code and
worksite of an employee based on the personnel area/sub area and to
retrieve current as well as next payroll or accounting period
respectively.
* Used FM CU_READ_RGDIR to get the payroll period and sequence number
for all the employees and read wage types for loans, deductions or
any.
Client : CP SHIPS, Tampa, FL (June 2005 - Dec
2005)
Industry : Energy Sector
Project Description : Application Development and Support
. Created summary reports for various distribution channels and sales
districts. Which include order quantity, orders sum, total number of
orders, Sorted on various parameters selected by user.
. Created data dictionary tables to store materials of certain category
that is used in reports of backlog and invoices listing.
. Developed BDC programs to load sales orders, vendor information, using
BDC Session method.
. Downloading from SAP system to legacy system, daily report of goods
issue & goods returns.
. Extensively worked on support activities, which include code analysis
& performance tuning of various objects.
. Customized the Sales and Distribution Cycle in relation to Order
Management, Shipping, Delivery Processing and Billing.
. Knowledge in ALE, IDOCs dealing with partner profile, message types
and output determination with respect to purchase orders, Sales order,
invoice and advance shipping notifications.
. Involved in training program to rapidly develop necessary technical
skills needed to ensure a successful project rollout.
. Provided development support for updating Material Master Data, text
and characteristics, for all materials within the inventory. Tasks
involved data analysis and cleansing, mapping to SAP R3/4.6C using
both LSMW and custom code, production support during the update
process and follow-up with end users for verification.
Client : Andrew Corporation, IL (Jan - June 2005)
Industry : Utilities
Project description : Application Development
. Technical design and migration of interfaces comprising custom process
programs, custom tables, and custom functions, data conversion, and
mapping of data with external manufacturing systems running in
multiple platforms through EDI translator MQ-Series.
. Handled LSMW as well as developed BDC programs, both batch input and
direct input, to migrate Materials and services master data in MM,
Outstanding Orders and Contracts data in MM, Vendor master with
multiple views in MM, Storage bin master data in WM, Materials stock
data at Bin level in WM, Customer materials info records data in SD,
and Sales delivery data in SD.
. Migrated, customized, & developed ABAP reports in MM, SD. Customized
and developed Stock Status Report & Shipping Performance Report,
Evaluation and Analysis of Vendor orders in MM, Payments and purchase
activities in MM and AP, Inventory of a material for all movement
types in MM, and Analysis of Customer payments and orders list in SD.
. Populated Goods Movement details in a Custom Z Table each time a goods
movement is created through MIGO or PGI by using MB_DOCUMENT_BADI.
. Worked on BAPI_BILLINGDOC_CREATEMULTIPLE for creating the Billing
documents with reference to Sales Orders. Subsequently contracts are
created with reference to the billing documents
. Created module pool dialog program for planned order pegging with
validations, screens with table control to update some of the tables
above with data of wafer ID, and Lot ID details.
Client : GSSC-Gauteng Shared Services -SAP South Africa
(Jan- Dec 2004)
Industry : Shared Services
Project Description : ECC6.0 and SRM Implementation.
. Designed Forms for creation of Contract Legal documents, RFQ Form,
Purchase Requisition using Smartforms
. Application Design to create RFQ using SMS notification, Defaulting
Attributes in a Auction BID
. Designed & Configured an Interface using ALE between two SAP systems,
which are functionally related to two different geographical locations
and acts as separate entities
. As a part of Implementation team handled various kinds of Data
Conversions which includes Material Master, Engineering Change
Management (ECM)
. Created a Report to monitor the Outstanding Deliverable Quantities in
Sales order
. Developed ALV Reports like Customer Net Margin & the Customer
Consignment Stock
. Developed SAP script Layout for Notification (QM)
. Developed the screens using Screen Painter to include additional
fields to sap standard screens using User Exits.
. Developed the form to print monthly credit and debit details using sap
script.
. Customized the settings, so that system checks whether material is
available on particular date.
. Developed some reports for Batch Management, Split Valuation.
Client : Varroc Engineering, India (Feb 2003- Dec 2003)
Industry : Engineering and Instruments.
Project Description : Implementation and support
. Designed and developed data load programs for initial legacy data
loading and custom interactive reports. These requirements included
extensive use of BDC's, & Reports
. Interactive report which displays all the sales orders for one
particular customer, the items order for that particular order,
quantity ordered, goods issue date and contact information about that
customer
. Created reports in SD module such as sales order status report, which
covers information of various organization levels, delivery status,
invoice status, shipping details and partner function details
. Developed and modified various SAP Scripts, which include, Purchase
Order Layout & Goods Receipt Layout
. Developed an interface allowing determining the effective price for an
article or a group of articles and a group of owners, and to update
the corresponding database used to communicate the effective prices to
stores.
. Developed and tested interfaces and master data loads from legacy
system to SAP R/3 system using Batch Input Sessions (BDC - Batch Data
Communication) and Call Transaction.
. Designed and developed reports using inbound IDOC files for sales
orders created by EDI subsystem.
. Using Business Object Repository, created BAPI test programs for SAP
Business Objects like customer, material, sales order and their
corresponding access methods.
. Designed and developed a complex report in order to print customer
account statements and to create a transaction file.
. Responsible for maintain programming standards and code reviews.