SUMMARY:

• My work experience includes 11 years of PeopleSoft Human Capital Management (HCM) implementations and upgrades in consulting roles; as well as, 11 years in Information Technology department roles.
• Project work includes two full HCM implementations, multiple PeopleTools, HCM upgrades, numerous Payroll Tax updates, one PeopleSoft Financial Management System (FSCM) upgrade and one FSCM implementation.
• As a consultant I learned how to work collaboratively with project team members and stakeholders to implement and maintain complex enterprise resource planning (ERP) applications and to gather requirements, mitigate risks, and successfully implement the applications in several organizations.
• As an employee, I have dug through manuals and collaborated with business owners, vendors and peers to understand how business applications work and have taught technical and functional team members how ERP systems and business processes can work in harmony.

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Application Development Associate Manager

Responsibilities:

• Reviewed functional design documents and wrote technical design documents for work units BN282 - Benefits Administrator Contacts Extract, HR159 - Valid SOC codes for Jobcodes, HR163 - Employee Position Reporting Tool, HR411 - Position Mass Upload, RHR423 - Separation Report including Layoff Details BI Publisher report, RPY462 - Summary of W2 to Treasury Query, RTA720 - Invalid Holiday Report, PY341 - Employee Tax Conversion, PY359 - Employee Cash Match Enrollment, and SA302 - Terminated and Transferred Employee Management.
• Completed the application engine build and associated documents for the work unit HR163 - Employee Position Reporting Tool program and the work unit PY341 - Employee tax Conversion program.

Confidential, Kansas City, MO

Application Development Associate Manager

Responsibilities:

• Application developer assigned to an Oracle PeopleSoft Human Capital Management functional team responsible for converting PeopleSoft HCM data of interest to targeted applications such as Workday, Kronos, ADP, Alight, and Broadspire. Assigned tasks included:
• Gathering conversion requirements via target application Parlor sessions and mapping PeopleSoft HCM data elements accordingly.
• Completing data and value mappings from PeopleSoft HCM data to the Workday, Alight, and Broadspire applications data.
• Wrote function design documents for employee demographic data from PeopleSoft HCM to Workday.
• Wrote functional design document for PeopleSoft HCM to Alight interface for demographic data, evidence of insurability, and garnishments due to child support medical coverage.

Confidential

Software Engineering Associate Manager

Responsibilities:

• Application developer assigned to the Oracle PeopleSoft Pension Administration implementation project team that is responsible for rolling out the custom Hire to Retire portal for the Confidential . Assigned tasks included:
• Modifying COBOL programs such as the Periodic Process, Benefits Calculator, and Retiree Payments processes in support of the Business team.
• Accepts change requests and problem incident reports. Analyze the reported situation to identify the root cause; then, refactor the program to align with the business rules or consults with the online configuration team to resolve any configuration issues.
• Submits migration requests and tracks the same throughout the migration process.
• Working individually as a software developer and as a part of a group of business analyst and programmers, when necessary, to accomplish team goals.

Confidential, Albany, NY

Software Engineering Associate Manager

Responsibilities:

• Application developer assigned to the Oracle PeopleSoft Pension Administration implementation project team that is responsible for rolling out the custom Hire to Retire portal for the Confidential . Assigned tasks include:
• Modifying PeopleTools objects as per change request and problem incident reports on the custom accounts transfer and member enrollment modules.
• Modifying COBOL programs such as the Periodic Process, Benefits Calculator, and Retiree Payments processes in support of the Business team. Accepts change requests and problem incident reports. Analyze the reported situation to identify the root cause; then, refactor the program to align with the business rules or consults with the online configuration team to resolve any configuration issues.
• Submits migration requests and tracks the same throughout the migration process.
• Working individually as a software developer and as a part of a group of business analyst and programmers, when necessary, to accomplish team goals.

Confidential, Hartford, CT

Software Engineering Associate Manager

Responsibilities:

• Application developer assigned to the Oracle PeopleSoft Pension Administration implementation project team.
• Built modules to fill gaps in the delivered pension benefits consolidation and calculation processing.
• Tasks included writing technical design documents based off on functional design documents and building solutions to such as:
• A custom process that evaluates a member’s payroll history and searches all pay periods of interest for the existence of pensionable earnings and translate earnings (dollars) into service equivalent hours and post the same basically setting the stage for periodic processing and benefits calculation processing.
• Refactored the Self-Service Benefits Estimate functionality to first populate custom tables used as input data to the benefits calculator program, then, display the calculation results to the member upon successful completion.
• Resolved problem incidents, wrote resolution documents, submitted migration requests, and validated migrations.
• Worked individually as a software developer and as a part of a group of business analysts and programmers, when necessary, to accomplish team goals.

Confidential, Columbus, OH

Software Engineering Associate Manager

Responsibilities:

• Application developer assigned to the PeopleSoft Financials and Supply Chain Management (FSCM) 9.1 project team responsible for rolling out the Procurement module using PeopleTools 8.52 in an Oracle / UNIX environment.
• Tasks included writing the Purchase Order Conversion Strategy document and the Purchase Order Details Interface to Ariba Functional Design document during the I & F phase.
• Then, wrote the Purchase Order Details Interface to Ariba Technical Design document during the Design phase.

Confidential, Portland, OR

Senior Systems Engineer/Analyst

Responsibilities:

• Sole technical support for Open Enrollment 2014. Enhanced the eBenefits and On-Demand modules. Modified interface programs for Cigna Health, Medco, VSP, etc. Wrote custom one-time application engine programs to resolve benefits data issues. Analyzed and modified custom code to resolve HSA buy-up calculation issues.
• Analyzed and modified Manager Self-Service Dashboard application package PeopleCode to resolve pagelet errors. Wrote a one-time application engine program to identify and fix orphaned AWE transactions that caused invalid data to be presented in the pending approval pagelet. Modified the custom Job/Position Change Manager Self-Service Dashboard functionality to work as expected with multiple components of pay.
• Designed and built integration broker web services functionality from PeopleSoft HCM to TIBCO to distribute organizational and user data changes as they occur through the TIBCO Business Works Canonical to internal and external systems that require web service integrations.

Confidential, Tukwila, WA

Principal Consultant

Responsibilities:

• Sole technical support for the production, test, and development environments.
• Refresh Test/Developments environments when requested. Review application server, process scheduler, and web server logs when necessary.
• Provided technical support to the Asset Management Reimplementation project. Created and configured the Excel to Component Interface utility. Created a custom application engine program to archive Asset Management transaction table data. Analyzed the delivered Transaction Upload process as needed, and tuned the excel to CI utility as needed to resolve online asset management data issues after the transaction upload process completed.
• Works with the client’s business analyst to resolve production problems as needed. Have resolved issues with Email Notification processing, Nvision Report processing, Voucher Upload processing, and AWE Workflow processing.

Confidential, Portland, OR

Principal Consultant

Responsibilities:

• Analyzed the eBenefits Employee Self-Service module runtime buffer to determine how to add dependents upfront, before the employee elected benefit plan options. Then, allow the employee to skip the benefit plan election process and derive Health Benefit plan enrollment after the Submit pushbutton is clicked based upon enrolled covered family members.
• Incorporated the covered family member bolt-on into the eBenefits Employee Self-Service module as envisioned by the Benefits Department. Minimized the modification’s impact on upgrades by creating a repository to store covered family members; then, merged that data into the delivered dependent buffers programmatically for use in the delivered benefit plan option election processes. If an employee skips the benefit plan option election process, logic similar to that executed when the employee elects medical, dental, or vision options is triggered when the employee clicks on the Submit pushbutton on the Submit Benefit Choices page.
• Analyzed comparison reports of objects between HCM version 8.9 and HCM version 9.1 for the eBenefits Employee Self-Service functionality in support of the 9.1 upgrade project that proceeding in parallel with supporting the production environment.

Confidential, Seattle, WA

Principal Consultant

Responsibilities:

• Wrote technical specification documents for conversion and interface programs; as well as, provided technical support to the project functional team.
• Created and/or modified ExcelToCI conversion utilities to load Vendor, Voucher, Item, and Asset data.
• Modified the Spreadsheet Journal Import ExcelToCI utility as per Confidential requirements.
• Provided the External Flat File layout for Journal Entry processing to ADP to assist with writing its Payroll General Ledger extract program
• Modified the delivered Positive Payment application engine program to extract data in a Payee or Standard format as per Key Bank formatting requirements for Payee Positive Payment and Standard Positive Pay
• Modified the delivered Automated Clearing House (ACH) file creation SQR process to populate data elements as per Key Bank requirements for the NACHA CCD+ format
• Initialized the Payment Dispatch service operation for sending the ACH files to the Bank using Integration Broker functionality. Configured External Banks as per Oracle | PeopleSoft specifications using the Financial Gateway functionality
• Designed and developed an inbound Daily Paid File application engine process to query file contents that were provided by Key Bank and update the PeopleSoft Payments table for each paid check.
• Designed and developed custom Approval Framework workflow to accommodate approval processes when entering Vendor and Voucher transactions

Confidential, Round Rock, TX

Developer

Responsibilities:

• Wrote three complex Time and Labor SQR reports.
• Time Reporting Codes ( Confidential ) by date—required report headings for Employee Detail and Company Summary.
• Confidential of interest were provided via the run control page and as a result, the TRC column headings had to be established at run time.
• Leave Patterns report—a report that queried the reported time table and captured leave patterns such as sick time taken in three consecutive days, vacation taken in two hour increments, vacation taken before or after scheduled days off, and reported time transactions that were flagged as unauthorized.
• Sick Leave Pool report—a report that queried the reported time table and captured employee information on Sick Leave Pool and Extended Sick Leave Confidential .
• Each report were date-range driven and used an application engine program to load a work table with its population to processing based upon run control parameters, then called an SQR program to gather the TRC information and build the report.
• I also completed unit testing of each report and wrote the Technical Design documents.

Confidential, Seattle, WA

Senior PeopleSoft Developer

Responsibilities:

• Modified the Candidate Gateway self-service page to start up in a custom search mode to display relevant job content more quickly, significantly enhancing the applicant’s online experience.
• Built a custom Faculty Tracking module to store comments and attachments of previously sent documents to prospective faculty members during the recruitment effort online.
• Modified configuration parameters for Time and Labor module. Holiday hours could be prorated based on employee’s full-time equivalent status. Changes greatly reduced manual corrections of pay sheet entries for Holiday earnings code and lowered payroll-processing time.
• Designed and built custom repository to capture and store personal digital assistant agreements. This functionality allowed each employee with a Smartphone to log onto a secure webpage and formally agree to the company’s internal cellular telephone security policy, before accessing the Microsoft Exchange system.
• Re-applied company’s customizations to bring needed functionality forward in the new version of the Grants and Purchasing modules.
• Enhanced Procurement module to function as expected by buyers throughout the organization, during the SciQuest MarketPlace implementation. Added functionality to the Create Requisitions module, to allow splitting a purchase across multiple requisition lines on a percentage basis. Modified Maintain Requisition module to launch specific PSQuery objects rather than displaying irrelevant pages.
• Reapplied customizations to Human Resources, Benefits Administration, Candidate Gateway, and Time and Labor modules. Saved the project timeline multiple times by analyzing enhancements to the new version of time and labor module — mainly the Approval Workflow Engine (AWE) functionality.
• Designed and built a Synchronous Service Operation to allow a third-party vendor (SciQuest, Inc. ) to send invoice transactions as XML documents to be received by the Financial system’s integration broker to populate the Voucher Build staging tables. Configured the Integration Broker. Built and configured the synchronous service operation. Wrote the transformation program which included XSLT code to transform each inbound XML document into a Rowset format. Wrote the Hander PeopleCode, an Application Class that converted the newly transformed Rowset data into Voucher Staging data and loaded it into the appropriate Voucher staging tables; then, generated an outbound XML document—the response to the third-party vendor. Worked with the Business Owner to complete data mapping documents and system testing of the Voucher Build processes.

Confidential, Seattle, WA

Senior Systems Analyst

Responsibilities:

• Designed and built custom time card repository system to capture data from 16 unique sources and loaded to a system of batches to be loaded into the pay sheets during payroll processing. Built the database repository and, using self-taught Application Engine programming skills, wrote programs to read the provided data files in their legacy form, and loaded the information of interest into the database tables. Added a user interface which allowed batches to be selected and approved for loading into pay sheets. Wrote Load-to-Paysheets process (using Application Engine development tool) to query repository for approved batches, loaded associated details into pay sheets of interest, and updated batch status to “Loaded into the Paysheets.” Improved financial decision making by introducing sensitivity and pricing models.
• Worked at length with PensionSmart Inc. consultant and multiple business analysts, to successfully implement the Pension module. This required researching, finding and moving nearly 20 years of payroll registry data to a more accessible location. Helped write Job Control Language (JCL) using FOCUS reporting system, and wrote Application Engine programs to scan, capture, and write data to clean-up repository, and to extract and load into pension historical detail tables. Built user interface to provide access to data and accommodate data clean-up effort. Modified conversion program multiple times until data exceeded Pension Department expectations.

Confidential, Tacoma, WA

Technical Business Analyst

Responsibilities:

• Gave technical support to the external PeopleSoft implementation team. Installed software, built databases, created application, web, and process scheduler domains in support of the project team. Analyzed server and database problems and provided troubleshooting information to the software vendor to help other organizations benefit from our solutions. Only had one eight-hour outage during the project life-cycle due to a broken backup utility requiring replacement from the vendor. Saved the organization thousands in salaries as I filled multiple roles including Systems Administrator, Database Administrator, and Programmer Support.
• Worked with primary and secondary consulting companies — Confidential and PeopleSoft — to implement the PeopleSoft Directory Interface using Active Directory (AD).
• Enhanced the benefits vendor reports to use standard Year-to-Date historical tables and modified the run control functionality to allow running previous months by adding a run as of date. Worked with the business owner and the external benefits carrier to clean up the previous transmitted data.
• Configured and implemented a third-party Garnishments module. Provided onsite programmer support and PeopleSoft systems administration support to Human Resources, Benefits, and the Payroll departments.
• Stayed onsite on Payroll Processing night (every Monday) to give immediate assistance with any problems until the pay sheets were confirmed and the bank tape was posted to the bank vendor’s ftp site.