Sap Data

Malleshwari Agina *****************@*****.***

SAP HR Functional Consultant – Certified Phone: 412-***-****

Experience Summary:

I have over 8 years of experience in SAP and 5 years in SAP HR (certified in SAP HR v4.7). My experience involves

analysis, design, configuration, development, testing and implementation of business solutions in SAP HR 4.6C and ECC

6.0. I have been involved in implementations, release upgrade and production support projects.

Skills:

SAP HR Functional – Highly experienced in configuration of Personnel Administration (PA), Organizational Management

(OM), Benefits (BN), Compensation Management (CM), and Payroll (PY). Workable knowledge in Time

management(TM) and ESS.

SAP Technical – HR ABAP, ABAP/4, Ad hoc/SAP Queries, ABAP runtime analysis, ABAP debugger, ALE/EDI IDoc

technology for PA and PY interfaces, Interface toolbox PU12, LSMW.

SAP Trainings - SAP HR v4.7, SAP workflow, SAP ESS

Other Packages – Remedy ARS, ITSM, Mercury Test director, Documentum

Project Assignments:

Sep 2008 to Present

SAP HR Upgrade – SAP HCM Functional Consultant for Medrad, Pittsburgh, PA – US (SAP HR Business Analyst)

Benefits:

• Configured new health, vision and dental plans for open enrollment for new years 2009 and 2010 respectively.

• Defined a new salary band, new high deduction plans and new costs rules for employee, employer and provider

contribution under each salary band for various bi-weekly, monthly and part time plans for providers Highmark,

UPMC, Delta, MetLife and VBA.

• Created a miscellaneous plan for crediting the biweekly and part time employees with 5 dollars per month and

monthly employees with 10 dollars a month if enrolled in a specific health plan using a new adjustment reason

“wellness credit”

• Enrolled new hires and existing employees for open enrollment of new year and printed out confirmation forms.

• Created new wage types relevant for the processing of benefits in payroll

• Assigned deduction model for each benefit plan to process deductions in pay period under Benefits Integration for

Payroll

• Configured feature to default a payment model for new employee subgroups

• Worked in creating a benefit interface for a new provider.

• Configured feature to default first program grouping for new employee subgroups

• Worked on testing changes to the enrollment and confirmation forms to reflect the new deduction and

miscellaneous plans

• Worked on testing changes to PU12 Payroll interface to CERDIAN to outsource new costs and new plan details

Personnel Administration:

• Defined new Personnel areas and Subareas when a new company Possis was acquired and defined new,

employee groups and subgroups based on the employee population.

• Maintained additional details for personnel subareas with government Ids for employer Id, Tax Company, EEO

and VETs company Ids, reporting unit for Equal Employment.

• Maintained EEO/VETS-100 reporting units assigned by Equal Employment Commission and address to be

printed on the EEO-1 and VETS100 report

• Configured EEO codes and AAP categories to jobs

• Uploaded Org units, Position and Jobs in SAP and performed initial load of Possis employees using win shuttle

tool which saved a lot of time and effort for the staff in HRIS

• Configured infotype change log for long term documents for Audit report which is sent to business every month to

validate the changes performed and check for any inconsistencies

• Changed info group for hire and term actions to enable addition and delimition of cell phone information

• Created new actions and reasons for Bayer Dependent care, Payroll to Non-payroll, transfer to and from Bayer

• Addition of missing zip codes for few states verifying it in USPS website

Interfaces:

• Supported Benefit interfaces that outsource benefits information to its providers like Highmark, UPMC, VBA, Delta

and MetLife.

• Supported PU12 Payroll interface that outsources gross payroll information to CERDIAN

• Worked on building a virtual edge interface that uses a flat file to create new hires and creates all infotypes using

PA30 and creates PA – OM relationships using PO13 and also performs benefits enrollments using new hire

adjustment reason

Reports:

• Assisted business in building for (LMS) Learning Management Solutions to give them information about new hires

or when they move into a company. Along with this movement information, the report shows if a training profile

(Course ID and Course Description) has been associated with the employee’s position so the coordinators can

make a determination if a profile needs to be altered

• Worked on building custom reports for COBRA, Salary Extract file, Wage and Salary report, Workers

Compensation report, AAP report and Vacancy report

Other Responsibilities:

• Scheduling and Monitoring of benefit interface jobs, Payroll interface jobs

• Monitoring of batch sessions

• Building requirement documents and functional specifications

• Involved in change board meetings

• Involved in technical discussions with development teams

Jan 2008 to Aug 2008

SAP HR Data Migration and Conversion – SAP HCM Functional Consultant for Johnson & Johnson, New Jersey –

US (Team Member)

Responsibilities:

• Gathered requirements, worked on Data collection, assessment and estimation of efforts during initial phase of

the project

• Collected and summarized data points for all legacy applications like Lawson, Wilma and performed data sample

analysis

• Prepared Functional Design Documents (FDDS) based on user cases for 120 HRMD/PeopleSoft and

Payroll/PeopleSoft Inbound and Outbound Interfaces

• Reviewing Technical Design Documents (TDDS) to ensure all requirements have been met for new reports and

enhancements

• Analyzed existing business process and identified possible SAP solutions

• Analyzed time and payroll data, personnel data and org data to identify gaps and discuss the same with business

integrators and end users

• Lead development team for conversion activities

• Prepared unit test plans and formal test scripts and assisted developers in system, integration, performance

testing

Mar 2007 to Dec 2007

SAP R/3 Upgradation and Unicode Conversion 4.7 to ECC 6.0 – SAP HCM Functional Consultant, Airbus,

Toulouse – France (Team Lead)

Unicode Activities:

• Involved in all phases of Technical Upgrade from v4.7 to ECC6.0 including development, unit and integration

testing, user acceptance testing (UAT), stress testing and post go-live support

• Involved in 4 Iterations and testing for the following systems DEV2/DEV7/TST/PROD

• Worked on Unicode Conversion for more than 2000 HR ABAP Programs and 400 HR Interfaces.

• Created integration test scenarios and Involved super users for UAT

• Created new training documents for consultants, business users for upgrade changes and discussed the change

impact analysis

• Performed SPDD (Reset to Original or Modification Asst) activities to adjust dictionary objects.

• Performed SPAU (Reset to Original or Modification Asst) activities to adjust programs, FMs, screens, interfaces,

documentation, text elements.

• Worked on OSS Notes applied in upgrade

• Performed UCCHECK which lists Obsolete Keywords & Syntax using

• Maintained central list for all Unicode change transports

• Created Post go-live Issue list with solution

Compensation management:

• Defined new planning periods for compensation adjustments

• Defined infoset for Roster to determine fields to be displayed for compensation statement

• Involved in setting up salary structures for planned compensation and basic pay infotypes by creating new pay

grade and pay scale areas and pay scale types, pay grade levels and pay scale groups

• Configured Long Term incentives attributes to handle different change events, multiple exercising methods and

life events for company merger

Payroll:

• Gathered requirements for new reports used for third party submission and reconciliation which utilized data from

payroll cluster results PCL2 and cluster tables RT, CRT and WPBP

• Modified standard SAP journal and remuneration statement reports to suit client requirements

• Creation of control records for new payroll areas

• Changed Basic pay screen for EU countries to display Annual Salary on the overview screen

• Assigned new payroll accounting areas to period modifiers

• Created new wage types for Additional Payments infotype for Corporate management and Professional

Other Responsibilities:

• Distributed work load and managed the technical team of 12 members at offshore

• Help set up VPN connection and network link in India

• Been a single point of contact for the entire duration of the project for communication, tracking and escalation of

data issues

• Created Test scripts based on user cases to validate the business features

• Extensively used Mercury test director for defect reporting and tracking

Jul 2004 to Feb 2007

SAP R/3 Implementation – SAP HR Functional Consultant for Global Business Integration Process for Eli Lilly

and Company, Indianapolis - US (Module Lead)

Payroll:

• Detailed experience in analyzing security issues in handling payroll data

• Expertise in understanding payroll control record and payroll driver program

• Analysis and correction of payroll errors from payroll simulation run and posting to accounting run

• Created payroll organization, payroll accounting and payroll periods

• Created wage type catalog and wage type groups for basic pay, additional payments and recurring payments and

deductions

• Maintained tax data like tax authorities valid for the company and tax types for Medicare valid for other taxes

infotype and assigned them to tax authorities. Created new tax areas and maintained tax authorities for them, and

assigned tax authorities to tax models

• Maintained zip code ranges for tax areas

Benefits:

• Configured health plans including medical, dental and vision

• Defined standard cost and coverage variants based on age and salary of an employee

• Maintained all features related to benefit area, first and second program groupings, termination type based on

action type terminate

• Supported benefits interface to PeopleSoft using Idoc technology

• Assisted business in building a custom report for benefits eligibility report

Compensation Management:

• Configured pay scale structure pay grade levels and areas for country grouping US

• Defined new pay scale groups and min, max and reference salary levels for Netherlands, UK and Germany

• Configured new performance and appraisal rating

• Used a Merit delivery tool which uploads appraisals infotype and creates a new record in basic pay infotype with

annual salary increase based on the appraisal ratings. The tool uses a flat file structure

Personnel Administration:

• Defined enterprise structure to fit company needs including personnel area, personnel sub-area, employee group

and employee sub-group.

• Created personnel action types and reasons for actions from Hire to Term and customized infogroups for each

action under customizing procedure

• Configured and created various subtypes for the standard Info types like Address, communications, family

members infotypes

• Worked on dynamic actions to default Date Types in IT0041 when hiring and terminating an employee

• Changed dynamic actions to send mail to the personnel administrator whenever there is a change in Org

Assignment IT0001

• Dynamic actions to default dates and Nationality in Family IT0021 when the number of children entered in

Personal data IT0002 is not space.

• Configured features to default org key, administrators, number ranges, pay scale type and area in basic pay and

payroll area in org assignment infotype

Organizational Management:

• Involved in integration with the personnel administration and Org Management by using the RHINTE00,

RHINTE10, RHINTE30 and RHINTE20 reports.

• Created new object types for planned compensation infotype under data Model enhancements

• Created a new evaluation path to retrieve information from org units, positions and supervisors

• Created new positions and jobs using an upload tool

• Assigned the various organizational units and positions to cost centers in FI.

• Assisted business in developing an ORGEXTRACT that creates a list of employee information to be used as a

data extract for a web based org chart. The output is downloaded in a UNIX directory where e-biz would retrieve

the file and update the org chart. This data was also sent to LDAP that maintained consistent data for enabling

single sign-on

Time management:

• Created personnel subarea groupings for work schedules and daily work schedule for new personnel subareas

• Defined periodic work schedules for new employee subgroups

• Configured feature to default value for work schedule for new employee groups and subgroups

Other Responsibilities:

• Retrofitted changes in development system and tested the functionality in Stage and Quality environments

• Prepared functional specifications for ABAP developments required for New Reports, Enhancements and to

coordinate with the developer in testing the development.

• Evaluated all change requests pertaining to the HR business processes for impact, effort, feasibility, and

consistency with the global design and ensured all changes to GBIP solution were made in a manner consistent

with project, IT, and overall client policies, standards, and strategies.

• Responsible for the Service Level Agreements and the deadlines / deliverables for special projects agreed with

the client.

• Responsible for Integration testing and System testing. Automated test scripts for performing Regression testing

using Mercury Test Director.

• Worked as Team Member in data set up activities like IIT & FIT and achieved the targets within a time frame for

different releases.

• Tracking the trouble tickets raised by the customers in Action Remedy System.

• Coordinating with business integrator’s of client to resolve tickets and implement changes within the stipulated

time.

• Coordination between the onsite and offshore teams and assist the offshore team to get access, knowledge

transfer, execution of the work.

Dec 2003 to Jun 2004

SAP R/3 Implementation – SAP HR Techno/Functional Payroll Interfaces for Global Business Integration Process

for Eli Lilly and Company, Bangalore, India (Team Lead)

PA and Payroll Interfaces:

• Built and supported Payroll Interfaces using Interface Tool Box (PU12) for the following affiliates: Brazil, Canada,

and France, Geneva, Germany, Italy, Mexico, Netherlands, Puerto Rico, Spain, UK and US. These Interfaces

are used to export HR master data, time and gross payroll data to a third party tool PeopleSoft, where the net

payroll was calculated

• Created interface format and file layouts and configured change validation for each infotype used in PU12

• Created control records for payroll areas and deleted PU12 clusters on request

• Execute Comparison reports on a monthly basis to compares data between SAP and People soft.

• Set up partner profile, message types and idoc types as part of the EDI/Idoc interface

• Built and supported HRMDA interfaces with ALE change pointers for distribution of HR master data to

PeopleSoft. The HRMDA message types sent out PA, PD and PD relationships data which was loaded into

subscription tools

Reports:

• Developed wage type report and union savings plan report

• Developed wage type statement and gross and net validation payroll reports.

• Created new employee view of staffing by modifying outbound interface program to include sales territory data

from custom PD infotype

Other responsibilities:

• Managed a team of 8 members and distributed work load and coordinated with onsite team lead with weekly

status reports

• Created and Monitored payroll data export background Jobs in Production and Monitored of PU12 files.

• I was the single point of contact for 14 countries to support payroll data

• Performed QA review of the programs and developed test cases via variants.

• Performed runtime analysis, code review and unit testing of programs

• Created program documentation, PU12 configuration documentation and Technical & Functional specifications

using Documentum tool.

• Execution of test scripts using Mercury Test Director.

• Tracked trouble tickets and managed change requests using Action Remedy System (ARS)

• Have gained adequate knowledge about the EDI interface concepts, change pointers, and filter creation.

Jul 2003 to Dec 2003

SAP R/3 Implementation – SAP HR Technical Consultant for Global Business Integration Process for Eli Lilly and

Company, Bangalore - India (Team Lead)

Reports:

• Designed and developed below reports based on PNP and PCH Logical databases:

Internal Applicant Analysis report.

-

HR Security – Personal Area audit report.

-

Employee education and qualification report

-

Hire Action audit report.

-

Internal Staffing metrics by AAP Category

-

Org Management Audit report

-

Enhancements:

• Enhanced a BADI for giving the Minimum Authorization to view Personal data (IT0002) for the Users.

• Developed the user-exits regards to the Search help elements and authorization checks.

• Worked on SAP Enhancement: PBAS0001 to check for date types in date specification infotype

Interfaces:

• Developed Interfaces to transfer data from legacy system using BDC (Session method) to upload, address data,

bank details, tax data and superannuation details in PA and objects, object relationships infotypes in OM.

• Developed Function Module for creation of Inbound IDOC for PB30 and PB40 transactions. This Interface

Function Module reads the People Click Applicants data from an IDOC, to create or update applicant data in

SAP.

• Developed program for creation of Outbound Program. This Outbound Interface exports Requisition Data from

SAP to People Click via IDOC/Mercator to an Interface file.

• Created BDC conversion programs for following infotypes: Personal Data, Addresses, Family

Members/Dependents, Basic Pay, Bank Details

• Modified SAP Script for Quality Certificates and Notifications to add additional columns.

• Created Interactive user screens using Dialog Programming to manipulate data.

Other Responsibilities:

• As a team lead of the development team contributed to Data Conversion project between SAP R/3 4.0 and legacy

mainframe system. Conversion procedures included data gathering, analysis, mapping, and cleansing.

• Working on the feedbacks received from the client after reviewing the Tech specs and analyzing the Conceptual

Documents (Functional Specifications)

• QA review of the program, Code Review and Unit Testing of programs

• Allocation of ABAP development work to the ABAP Team and involved in ABAP effort estimation

• Reporting the Team work to the onsite on a weekly basis through teleconference

Aug 2001 to Jun 2003

SAP R/3 Implementation - ABAP Technical Consultant (SD, MM) Maintenance Repair & Overhaul (West Virginia,

Poland, Canada, UK Rollouts) Pratt & Whitney Hyderabad – India

BDC programs:

• Developed Programs for creation of Sales Employees using XD02 transaction.

• Developed programs for creation of New spare parts pricing

• Developed Programs for creation of Views for Materials and scripts.

• Creation of Accounting and Costing Views based on the Material Types and Valuation Types for the split valuated

materials using MM01 transaction.

• Creation of scripts for Travelers (Production Order) and Packing Lists

• Creation of standard texts as a common program for the maintenance purpose of the entire project using SO10

transaction.

• Created bins for the new warehouses and flag the empty bins for deletion using tcode LS01N transaction.

• Deleted bins for the old warehouses and flag the empty bins for deletion using LS02N transaction.

• Created all Equipment Records for all WIP engines and modules (if required) and maintain Hierarchy using IE08

and IQ03 transactions

Other Responsibilities:

• Creation of technical specifications and test cases for programs

• Performed code review and unit testing

EDUCATION:

B.Tech (Electrical & Electronics Engineering)

Contact this candidate