Primarily responsible for completing, testing and debugging Application Engines and Component Interfaces to convert Assets, Vendors, Open Purchase Orders, Accounts Payable Open Invoices, General Ledger monthly summary balances for 2012 and detailed transactions for 2013, Locations and Ship To Locations, Item Master, Supplier Contracts, Contract Documents and Comments, Contract Binds and Bind Values, Item Business Units, Inventory Balance & Costing, Preventative Maintenance Schedules, Equipment Parts List Templates, Work Order Templates, Work Order History, Par Location, Items, Contracts and Prices and Default Putaway Locations. Completed an Application Engine interface of Employee data from Oracle HR.
Time & Labor – Updated a custom Application Engine to annually process the roll-over and cash-out of compensation time.
Core HR – Responsible for requirements definition, the project plan, liaison with the Benefit vendor’s technical team, management of the project’s business analysts and documentation of the project’s results. Analysis begun in 2011 was used to identify employee pay rate history utilized in retirement benefit calculations. These findings were verified against multiple systems of record and used to identify gaps and inconsistencies in the vendor’s data. Corrective data was identified and interfaced to the vendor’s administrative system.
Core HR – Designed and coded Application Engines and Component Interfaces to convert Personal Data, Job history and Position Management. Customized the Job Data component to support a broker workforce model. Developed an SQR to calculate employee union dues owed based on paid hours.
Payroll – Designed and coded Application Engines and Component Interfaces to convert Federal, State and Local taxes, Tax Balances, Direct Deposits, Garnishments and General Deductions.
Base Benefits, Ben Admin – Data conversion for Dependents and Beneficiaries and enrollments to Health plans, Savings Plans (401k), Long and Short Term Disability, Leave Plans, FSA and Life Insurance. Customized PeopleCode edits on the Employee Benefit Enrollment page to prevent employees from electing coverage plans above the amount requiring evidence of insurability. Converted the PeopleCode edits for the “On Demand Event Maintenance Election Entry” page from warnings to errors. Developed an SQR to identify over-age dependents enrolled in Benefit plans, email a notification, and then drop them from the plan. Developed an SQR to update annual benefits base rates for brokers based on prior year commissions.
Core HR – Designed and developed an Employee Turnover analytics page based on Job data, Departments and Locations.
Base Benefits – Developed new PeopleCode edits for the Self Service Savings Plan (403b) Enrollment and eBenefits pages. Developed SQRs to print enrollment confirmation letters to employees. Updated the 403B interface SQR to the Benefits vendors.
Base Benefits – Developed PS Queries to identify dependents newly enrolled in Medical and Dental plans.
Core HR – Developed business requirements and SQL queries to audit employee pensionable pay rate history based on Job data compensation rates, unions and shift factors over a ten year time period.
Position Management – Developed an Application Engine to perform mass Position Change.
Base Benefits – Developed Application Engine inbound interfaces for Medical, Dental Plan and Insurance enrollments and terminations.
Core HR – Analyzed and reapplied PeopleCode customizations. Designed and coded new customizations required due to the Person model. Identified obsolete custom objects to be removed from 9.1. Assisted with SYSAUDIT cleanup. Fixed a wide variety of defects found during 9.1 integration testing.
Core HR 8.8 – Customized the Manager Self Service Termination process to include multiple termination types and workflow approvals.
Payroll – Developed an Application Engine to add “Other Earnings” to paychecks as part of the calculate pay process for selected employees based on special accumulator values and Benefits enrollments.
Core HR – Designed and coded Application Engines and Component Interfaces for core HR data conversion from ADP EV3. Constructed new Manager Self Service components to enable supervisors to edit and update selected data for their direct reports. Customized the Manage Hires event and the Job component to automatically enroll and un-enroll employees in Benefits Plans. Customized the Manager Self Service Terminate an Employee process to include comments. Designed and created a security feature to control access to menu items based upon the users’ Paygroup.
Base Benefits – Developed an Application Engine to generate run controls and schedule the Calculate Periodic Accrualprogram for all eligible Plan Types and Benefit Plans.
Payroll – Developed an Application Engine to deliver Payroll Registers and email notifications to each location. Upgraded inbound interface SQRs. Implemented PGP encryption and FTP processing for outbound SQRs.
Talent Acquisition, AWE – Implemented the JobOpening and JobOffer workflow events. Customized the Recruiting Add New Applicant pages. Developed PeopleCode edits on the Job Offer component to edit salary ranges against salary group data. Developed PeopleCode to populate licenses and certificates for new hires.
Core HR – Fixed defects and performed SQL tuning for SQRs, PeopleCode and Application Engines.
Payables, Receivables, Projects – Identified, documented and reapplied PeopleCode customizations. Developed new customizations for 9.0.
General Ledger – Customized the chart field and combination edit Application Engine to apply custom business rules.
Time & Labor, Payroll – Developed an ExcelToCI tool to load data to the Elapsed Time page. Customized the time approval page to allow supervisors to approve time based on location and schedules. Customized the Retroactive Payroll process to separate mass Retros from regular on-cycle Retros. Developed a gross-up procedure for other earnings based on special accumulators.
Base Benefits – Customized the Benefits Summary and Timesheet pages. Developed an SQR to compare core Person model data to external non-PeopleSoft data. Customized many of the Benefits Open Enrollment pages. Developed a Mass Termination SQR based on employee expected end date.
Core HR – Designed and developed many customizations to on-line PeopleCode, Component Interfaces, Application Engines and SQRs. Customized mass-update pages and processes. Customized defaults and edits for the New Hire and Job Data pages. Built Role-based security restrictions to field edit logic on Job Data. Applied patches and bundles.
Time & Labor – Customized the Weekly Elapsed Time page to allow entry for two weeks and added custom business rule edits. Developed a page for employees to view paid time and either approve or submit change requests.
Benefits – Developed a leave of absence tracking bolt-on module based on Job data. Customized Benefits Open Enrollment to use new edit tables for medical providers.
Payroll – Customized a bolt-on Retirement module with interfaces to Payroll. Developed a gross-up modeling page, pages to show Paid-time-off by pay period, an Employee Self Service W-2 Reissue page and a page for viewing Payroll details based on special accumulators. Created a California Employment Department Audit SQR by pay period based on check data and special accumulators.
Time & Labor – Developed Application Package code to customize the Weekly Elapsed Time page to include extensive business rule edits and validations. Developed several new summary pages. Upgraded custom SQRs. Developed custom rules for the Time Administration process. Applied bundles and tax updates. Developed customizations to process time adjustments with workflow approvals.
Asset Management, Payables, Purchasing – Developed several Application Engine programs and Component Interfaces to load assets to the Asset interface tables, extract asset information to flat-files, load receipts to Purchasing and load Purchase Orders to Purchasing. Customized the Dispatch POs SQR.
Inventory, Purchasing, Order Management – Developed a series of Component Interfaces for integration with handheld devices including PO receiving, physical cycle counting, bin-to-bin inventory transfers, inter-unit inventory transfers, inter-unit receiving of transfers and recording production completions. Customized Integration Broker Service Operations between Financials and CRM. Developed custom SQRs.
Receivables – Developed programs to update customer data from external sources and to email shipment notifications to customers.
Order Management, Billing – Created custom records, pages and PeopleCode. Created a replacement for EDI Manager using File Layouts, Application Messages and publish PeopleCode. Created Application Engines to process multiple EDI transactions including forecasts, purchase orders and invoices.
Projects – Designed and coded an Application Engine to interface transactions from Payables, Receivables and several external applications into a central Projects hub.
Core HR, Base Benefits – Developed customized panels and PeopleCode. Updated SQR interfaces to external applications.
Core HR, Base Benefits, Payroll – Reapplied customizations to core HR panels, PeopleCode and SQRs. Constructed a PeopleSoft data warehouse for legacy HR, Benefits and Payroll data.
Order Management – Customized the following EDI transaction sets: Purchase Orders, PO Acknowledgments, Shipping Notices and Invoices. Customized EDI maps, SQRs, staging tables, EDI Manager and EDI Agent functionality.
Order Management – Designed and coded customizations to the Order Management EDI processes to accommodate creating orders from forecasts, updating existing orders from forecasts and several methods of releasing orders to Inventory.
Payables – Customized dynamic SQL for the COBOL payment posting program to create prorated accounting entries for discounts taken.
Stock Administration – Fit/gap analysis, customization and testing. Converted legacy data and developed custom SQRs.
Financials 7.5 upgrade and production support. Technical Team Lead for the development of Stock Administration module. Human Resources production support. Designed, developed and implemented a telemarketing/sales opportunity tracking application with PeopleTools.