Harpreet Singh
SAP Time Management Consultant
Location: Houston, TX
Email: abm8gk@r.postjobfree.com
Summary:
. Total 5 years of IT experience, which includes development,
implementation, and support of turnkey projects with emphasis on SAP
HCM/HR module.
. Successfully completed three full life cycle Implementations in SAP HR
module from project preparation to Go-Live and support.
. Applied knowledge of ASAP Methodology and Solution Manager.
. Worked as SAP HCM Functional Consultant at various positions from a
member of Core Development Team member to Functional - Business
Analyst position.
. Excellent Public Sector experience at some major clients.
. Experience in heavily unionized environment.
. Upgrade experience from SAP 4.6C to ECC 6.0.
. Involved in various roles in different projects.
. Expertise in implementation and configuration of PA, OM, Time
Management, CATS and Payroll module.
. Expertise in ABAP and proficient debugging skills.
. Configuration, Unit testing, Integration testing, post implementation
support and training of SAP HR module.
. Exceptional troubleshooting and analytical skills to provide best
solutions for complex scenarios.
Technical Skills:
ERP Packages: SAP release ECC 5.0, 4.7, 4.6C, 4.6B, 4.5B
Languages: ABAP/4, C, SQL/PL SQL
SAP Interface tools: ALE, IDOC, LSMW, EDI and BAPI's
Databases: Oracle 8.x, MS SQL Server MS Access
Environment: Windows XP, 2000, NT, and 98, UNIX
Project Experience:
Shell Oil, Houston, TX Oct'08
- To date
Position: Global HR Functional Consultant
. Led the Time Management team in requirements gathering and
finalizing the blue print of the changes that are required.
. Led the effort in developing and implementing unit and integration
testing procedures for the HR module.
. Created test scripts for HR processes and updated regression test
scripts.
. Implement Projects, enhancements and post go live support for Time
Management and Payroll Module for Americas region including US,
Brazil, Chile, Argentina, Canada and Venezuela.
. Member of the team to upgrade system from SAP 4.6C to ECC 6.0.
. Work with various users and process owners for User Acceptance
Testing.
. Wrote various rules, updated schemas and time management
configuration to meet the new requirements and fix the defects in
existing configuration.
. Member of the team to upgrade system from SAP 4.6C to ECC 6.0.
. Updated and created overtime rules for different locations with
union agreements for daily, weekly and double overtime.
. Designed and developed the procedure to calculate working week for
employees with rotating and non-standard work schedules for FMLA
workbench.
. Wrote rules in payrolls schema to prorate the Benefits on
termination but not on enrollment.
. Wrote user-exits in CATS to block various attendance absence codes
based on different locations.
City of Houston, TX Oct '
07 - Oct' 08
Position: HR/Time Management Lead
. It is one of the large implementation for the fourth largest City
in US and has about 26000 employees.
. Work involves configuring the Time Management system as per city's
requirement taking into consideration the requirements for
different unions such as Fire, Police and Municipal personnel.
. Configured the work schedules, holiday calendars, absences,
attendances and quotas for different unions.
. Created different CATS profiles for different unions and different
authorization profiles.
. Developed custom rules for complex overtime calculations for
different unions with their unique requirements.
. Developed custom rule for holiday pay with different behaviors when
certain attendances are used.
. Developed custom rules for vacation accrual for different unions
and seniority.
. Developed custom rules for comp time accrual and automatic payout
after expiration or when cap of 240hrs reaches.
. Developed the procedure and functional specifications to interface
data from Nettime to CATS for Aviation department.
. Developed custom operation to store the information in a Z table
for salary cost recovery posting.
. Developed the system to accept grants using internal order directly
on the time sheet and charge the corresponding grant.
. Configured special rules to back out Holiday pay if the Employee
was absent the day before the holiday and day after the holiday.
. Configured the system to allow certain group of employees to code
an absence on the day of the holiday by manipulating the day type
rules.
. Training the city end users in Business process as configured in
SAP and also in system design and support.
LA Unified School District, Los Angeles, CA July' 07 - Aug' 07
Position: HR Consultant
. Developed Time Variance report to compare absence and attendances
in different selected periods.
. Payroll Variance report to compare payroll results for several wage
types in different selected periods.
. Payroll exception report to display employees who got pay checks in
previous period and not in current and employees who shouldn't
receive pay checks.
. Mass Work Schedule change Program to update HRP1010, HRP1018 and
infotypes 0000, 0001, 0007 and 0008 when payroll subarea changes in
new fiscal year.
. Smartform and Adobe form through BADI to generate a letter on leave
approval.
. Smartform and Adobe form Report to generate letters for employees
whose credentials are expiring within certain period.
. Program to delete extraneous records from infotype 0015.
University of Kentucky, Lexington, KY Feb' 06 - June' 07
Position: SAP HR Consultant
. Troubleshooting and debugging Time calculation schemas and rules.
. Created custom infotype 9993 to maintain time administrators for
different groups based on organizational units.
. Created Custom tables and dialog modules for several custom tables
and developed mass user maintenance tools.
. Worked in design and development of SAP HR Time and Attendance
Functionality using ECC 5.0 solution for the implementation Portal
using Employee Self Service (ESS)
. Configured HR Time Management objects: basic settings, number
ranges, time entry profiles, daily work schedules, period work
schedules, work schedule rules, absence quotas, absence types,
attendance types, holiday calendar, premium numbers, screen
control, CATS additional fields, time types.
. Developed the procedure and functional specifications to interface
data from Kronos to CATS for health department.
. Wrote rules for Overtime calculations and premium pay based on
requirements that were tied to various enterprise and personnel
groupings.
. Developed special calculation rules for compensatory time off for
salaried non-exempt employees.
. Wrote rules to monitor part time employees and generate messages
when they exceeded 15 weeks when they worked more then 20 hours a
week .
. Designed and developed Time Sheet custom enhancements, and custom
such as inbound interface to recharge departments based on labor
data and time transfer verification report.
. Configured Time Schema and Personnel Calculation Rules for various
Absence Quotas - Vacation, Sick, Personal Holiday, Employee
Recognition, etc.
. Developed the front-end validations for the Time Sheet processing
for Labor Cost Distribution of the "near actuals" and validation
for cross-fund charging using Business Areas within the SAP
solution.
. Worked in creation of payroll forms. Some of the unique
requirements have been to reflect the Quotas earned and used in a
pay period. Achieved this by writing special rules in time
evaluation to capture the required data and then attaching them to
dummy wage types. These wage types were called in payroll form.
. Created interfaces using BAPIs to fill custom tables for internal
orders and cost centers for ESS search helps in CATS time entry.
San Luis Obispo County, SLO, CA May' 05 - Feb'06
Position: SAP HR Consultant
. Responsible for implementing complete Time Management module and
CATS
. Implemented the entire suite of SAP Time Management functionalities
including Time Managers Work bench, FMLA workbench, Time evaluation
and CATS
. Designed and developed the monitoring of probation and evaluation
in time evaluation by developing unique rules using function 2012
. Developed the design for CATS time sheet approval based on a
separate Z table to store the list of approvers and these approvers
were assigned to an individual employee in a custom developed
infotype
. Configured Time managers Workplace for error processing and time
data maintenance functions for Time administrators.
. Configured the FMLA work bench to manage Federal FMLA, California
family rights act (CFRA), Pregnancy disability leave (PDL) and
concurrent monitoring with workers compensation by devising and
assigning reason codes
. County had about 28 unions and we had to configure work schedule
rules, quota rules and time management rules to meet the
requirements of a heavily unionized set up
. Designed and developed a module to calculate Secondary cost using
Fringe benefits, differentials and workers compensation's
experience and exposure rates to integrate smoothly with the
Payroll and FI Posting process in CATS user exits
. Generated Custom Payroll infotypes for Adhoc reports from payroll
clusters.
. Developed CATS User Exits that had to work during ESS time entry
for the following :
. To calculate secondary cost based on basic pay, fringe
benefits and differentials.
. To automatically generate and release holidays on CATS and
ESS.
. To block employees from coding overtime without regular 40
hrs for 7 day profile and 80 hrs for biweekly profiles.
. To create additional fields on CATS to store Reason Code,
Line Item text, Fringe Benefits Percentage and Personal
Subarea.
. To block employees to code Sick Leave with VTO.
. To default employees cost center from master cost center,
activity type based on Attendance/ Absence types.
. To block employees from coding standby (4A, 4B, 4G, 4F) on
the same day as VTO.
. Configured different data entry profiles for employees entering time
data into CATS.
. Program to delete probation counter from Time Managers Workplace.
Education:
. MEM (Computer Science) from St Cloud State University.
. BE (Computer Science) from Institute of Technology and
Management.
References will be available on request.