EXECUTIVE SUMMARY:

• 20+ years of ERP (HCM&FSCM) experience including 14+ years of PeopleSoft HCM (8.9 to 9.2, Tools 8.58)
• Areas of interest and strength include PeopleSoft HCM with Analysis, Design, Development, Testing, Security, Integration, Workflow, Implementation and Production support.
• Strong HCM domain knowledge includes PeopleSoft Core HR, Workforce Administration, Benefits, Benefits Administration, Time & Labor, Payroll (North America) and Payroll to GL interfacing.
• Have performed in diverse roles like Developer, Tester, Technical Lead, Techno - Functional, Business Analyst, Functional Consultant.

TECHNICAL SKILLS:

People Tools 8.58 (PeopleCode, Application Engine, SQR, AWE, XML Publisher, COBOL, Excel to CI, Fluid), Oracle SQL & PL/SQL, Crystal Reports, Oracle Forms & Reports Developer 2/6/6i.

WORK EXPERIENCE:

Confidential, FT Lauderdale, FL

Lead Consultant Techno-Functional

Responsibilities:

• I work closely with HRIM team, SME’s and end users for supporting their day to day activities including Requirement discussions, Planning, setup, design, development and support activities.
• Had major role in architect, development and support of following items listed module wise.
• Planning, Setup, Support.
• Workforce Administration and Organization - Foundation tables, JOB attributes, Approvals, Actions-Reasons, Positions, Multiple employee Instances, CWR’s.
• Benefits & Compensation - Benefit plans, attributes, Rates and rules, Ben program configurations, Eligibility and event rules, Base compensation, Payroll integrations, Leave plans and processing, Employee benefit data management, processing, interfacing and reporting.
• Experience in ACA, FRS (Florida Retirement system) configurations and reporting.
• Schedules, Workgroups, Task configurations, TRC’s planning and Payroll integrations, Rules (Including development) and Rule programs, Time Administration process, Employee data management with Project costing integrations.
• Calendars, pay groups, earning codes, deductions, garnishments, tax tables, Employee payroll data management, Payroll processing, Retro pay, reporting, W2 processing and Payroll to GL Interfacing.

Confidential

Workforce Admin

Responsibilities:

• Customization of Overtime calculation by compounding supplemental earnings, Supplemental pay calculation for prior period adjustments, Paysheet load customization for few earning types, customization of PAYGL01 Payroll to GL interface to distribute earnings, deductions, taxes by department, project, program. Loading Payroll data using Excel to CI such as yearly uniform, executive health reimbursements, one-time deductions, and retro payments.
• Worked on various interfaces Vendor and 3rd party benefits administrator, Inbound and outbound data includes Employee, Dependent demographics data, Current elections, Options generated by BenAdmin; inbound data includes new demographics data, Employee selection out of available options.
• Admin leave plans driven by Job classification, Overrides, Donations, union leave banks, Roll-Overs, Sick bonus day for not being sick, forfeiting rules. Yearly summaries, notifications etc.

Confidential, Chicago, IL

Technical consultant

Responsibilities:

• Worked on Retro Pay functionality fit-gap issues, related customizations.
• Worked on Position data and Incumbents Process enhancements to meet business specific requirements.
• Various Benefits related gaps like designing a Ad hoc report to identify health dependents over age 19 requiring documentation with next 2 months, Process to update Dependent Student Validation Status field monthly, Produce a letter to employees advising them of documentation renewal requirements, Follow-up letter with report to ensure compliance.

Confidential, Long Island, NY

Techno functional consultant

Responsibilities:

• Involved in retrofit issues related to up-gradation from 8.3 to 8.9
• Prepared document based on 8.3 to 8.9 DEMO to DEMO compare reports for newly added/deleted various record definitions, added/deleted fields in various record definitions, for truncated fields, changes record types.
• Developed a field level mapping document for the new PeopleSoft modifications from 8.3 to 8.9 includes HR, Benefits, Recruiting, Payroll modules.
• Identified the impacted SQR’s, the level of impact due to the upgrade to PeopleSoft 8.9, Oracle 10g and Confidential modifications as well. Documented the impacts, as a guide to developer’s team for the retrofitting. Prepared the comparison document to assist developers’ team for customizations. Includes 600+ SQR’s, various online panels and Workflow functionality in different modules.
• Prepared scripts to export queries from RPT database and to delete unwanted, invalid queries. For the reports a script to give statistics of usage to identify the reports are being used or not, the frequency, communicated with business users after approval identified those reports are not being used thus to exclude from 8.9 upgrade.
• Involved in identifying, trouble shooting various conversion issues and prepared scripts for pre, post conversion tasks, such as discrepancies of hire, termination date issues, recruit workforce status conversions, annual base benefits base rates and no of other conversion issues.
• Prepared Portal Navigation training documents for Payroll, Recruit for the new 8.9 portal. Worked with clients to plan testing activities.

Environment: AS/400 DB2, Oracle Developer and Oracle 8i.