SUMMARY:

IT Consultant with over fifteen years of experience in analysis, design and development of business applications and have worked exclusively with PeopleSoft software since 1997 focusing on delivery excellence with industry leading applications in both Financial Management System (FMS) and Human Capital Management (HCM HR, Benefits and Payroll) and with deep technical knowledge, a consulting background and work ethic and excellent communication skills to supplement any team and deliver success.

AREAS OF EXPERTISE:

infrastructure support development system tuning and troubleshooting and technical documentation.

TECHNICAL SKILLS:

• PeopleTools 8.49 PeopleTools II
• PeopleCode PeopleSoft Application Engine
• Integration Broker PeopleSoft PeopleTools
• PeopleSoft Accounts Payable PeopleSoft AR and Billing
• PeopleSoft HR and Benefits PeopleSoft Crystal Reports
• Oracle Fusion SQL/SQR and PeopleCode
• Oracle SQL and PL/SQL BI Publisher
• Visual Basic Test Director
• PeopleSoft Server Admin. STAT
• Oracle DB2
• SQL Server MS Access

PROFESSIONAL EXPERIENCE:

PeopleSoft Senior Technical Consultant

Confidential, Oakland, CA

Responsibilities

• As a member of new PeopleSoft HCM 9.2 (PeopleTools 8.53) new implementation team, developed requirements as assigned by Project Manager following functional requirements and standards and guidelines.
• Developed BI Publisher reports by creating Application Engine program, BI Publisher template definition and source utilizing complex SQL scripts for Benefits Vendor and Benefits Reconciliation report.
• I Modified broken Integration Broker process of complex Skill Soft integration process. By running PeopleCode trace and reviewing Application Engine and Application Package PeopleCode found Service Operation WSDL node was missing connector URL as well as routing/connectors. Also had incorrect credentials stored in Message Catalog.
• Client needed customized delivered Self Service Absence Balances page that would require extensive work by “cloning” and modifying component. I was able to provide solution with more efficient and quicker turnaround solution by creating PeopleSoft 9.2 Related Content Services.
• Revolved customizations developed by other consultants that were not working properly.

PeopleSoft Senior Technical Consultant

Confidential, Chicago, IL

Responsibilities

• Assigned to TransUnion South Africa PeopleSoft Financials 9.2 upgrade project from Mar 2015 through July 2015. Development was done at TransUnion Chicago office. Designed, developed and conducted unit testing for PeopleSoft Accounts Receivable for Electronic File Transfer process for Direct Debits which included the following: Create outbound electronic file transfer file with each new direct debit extract following specifications outlined by the bank and client.
• Process bank's inbound file, validate data and send information back to bank following specifications indicating whether to accept or reject totals. Process accepted/rejected file from bank. If rejected, update dd control.dd status to 'E' and if successful, change to 'E'. Process non - sufficient funds report. Identify customers and deactivate.
• Assigned to Denton’s in Chicago as PeopleSoft HCM/Payroll 9.0 Developer Production Support and some of my tasks were the following: Developed outbound Benefits Health Advocate outbound file following specification set by the vendor utilizing Application Engine and PeopleCode. Enrolled California employees in new Benefits Sick Time Plan using PeopleCode and Application Engine.
• Developed configuration scripts for Broward Sheriff’s Office/Ft Lauderdale, FL as part of the PeopleSoft 8.9 to 9.2 HCM upgrade.
• Oracle HCM Fusion ver 9 Developer. Created outbound extract for UGN client in Chicago using Oracle Fusion application for plant in Mexico following data mapping documentation.

PeopleSoft Senior Developer

Confidential, Rosemont, IL

Responsibilities:

• Responsible for developing, configuring, implementing General Ledger interface from PeopleSoft AP to Sysco SAP GL using Application Engine, PeopleCode, PeopleTools and SQR. Created several vouchers with different business units and source to test functionality.
• Added code/functionality to work dynamically in parallel and for when doing live.
• Wrote technical documentation with description of program, objects, unit test results and running instructions.
• Responsible for developing, configuring, implementing General Ledger interface from PeopleSoft Expense to Sysco SAP General Ledger using Application Engine, PeopleCode, PeopleTools and SQR.

PeopleSoft Senior HCM Developer

Confidential, Chicago, IL

Responsibilities:

• Responsible for developing, configuring, implementing and maintaining PeopleSoft 8.9 HR and Payroll and other applications.
• Designed, developed, tested, analyzed and implemented solutions to meet business needs and Objectives and ensuring quality standards are met.
• Provided advanced Level 3 support which involved investigating operational or systematic problems and providing resolution using advanced analytical skills and tools as necessary for developing, configuring, implementing and maintaining PeopleSoft 8.9 HR and 3rd party CORT Payroll.
• Responsible Part of the 8.9 to 9.2 PeopleSoft HR and Payroll upgrade currently in technical design phase.
• Imported Direct Deposit accounts for Attorneys becoming partners with Confidential & Confidential .

PeopleSoft Senior HCM and Financials Developer

Confidential, Minneapolis, MN

Responsibilities:

• Retrofitted customizations for a PeopleSoft 8.9 to 9.2 HCM, Campus Solutions and Financials/Supply Chain Management Upgrade.
• Added Level Three Enhanced do-modal link to Expense Report Lines and My Wallet using custom PeopleCode and delivered pages.
• Developed new functionality to Expense My Wallet to allow filtering My Wallet transactions by Credit Card using dynamic SQL and PeopleCode.
• Implemented AWE (Approval Framework) utilizing custom application classes.
• Created Related Content for Expense Reports to view Travel Authorizations, Cash Advances, and Payments data.
• Defined and published Navigation Collection for custom Components.
• Analyzed, documented, and estimated level of effort for retrofits during scoping phase of Project.
• Conducted Code Review and Unit Testing and wrote test scenarios in preparation for migration to Test environment for Functional User Testing.

PeopleSoft Senior Financials Developer

Confidential, Chicago, IL

Responsibilities:

• Implemented Taxware to PeopleSoft Integration for Billing tax calculation. Customized App Package PeopleCode to for mapping PeopleSoft Product Codes. Modifed PeopleCode for third party tax system interface to suppress zero dollar invoice lines from being processed.
• Created process using SQR to purge files from Unix directory older than eighteen months and scheduled monthly recurrences.
• Developed process to download Co-op invoices to Excel. Uploaded Excel, after modified by user using Application Engine, PeopleCode, File Layout and SQR.
• Resolved service request on daily basis as part of production support
• Created PeopleSoft Web Service and soapUI 4.0 for Share Point team as part of development/testing for workflow.
• Implemented SSL on our 8.1 and 11g WebLogic servers for our PeopleSoft Financials 9.1 and CRM 8.48 web servers.

PeopleSoft Senior Financials Developer

Confidential, Bloomington, IL

Responsibilities:

• Performed PeopleSoft FSCM 9.1/8.51 upgrade from version FSCM 8.8/8.49 for GL/AP/AR/AM/PO/TE/e-Pro modules.
• Performed compare reports and identifying customizations and retrofitting them in the 9.1 Environment.
• Did analysis compare reports and identifying object by object customizations that need to be applied to 9.1/8.51 database.
• Applying object by object customizations to 9.1. Unit testing and fixing issues related to GL, AP and AM processes, pages and records. Applying customizations to JRNL1.XLS and spreadsheet Journal upload GL EXCL JRNL app engine. Applying 8.8 AM SQR customizations for AMAEDIST and AMDPCLOSE to 9.1 app engines. Applying new change requests to 9.1 pages and components. Fixing EDI File layouts for 9.1 upgrade. Assisting users in performing system testing for the customizations and processes and fixing issues. Testing nVision reports and Crystal Reports using PS queries. Migration of PS objects and trees using Application Designer. Creating PS users, roles and permission lists in the development environments and providing page security, component security, process security, query security and query trees for all PS users and developers.

PeopleSoft Senior HCM Developer

Confidential, San Bernardino, CA

Responsibilities:

• Production support and application development with Confidential . in PeopleSoft ELM 9.1, HCM 8.8 and Financials 9.0 tools 8.50 and 8.49.
• PeopleSoft Payroll Production for weekly and bi-weekly pay cycles. Resolved payroll issues and was on rotating on-call.
• Designed and developed integration between PeopleSoft HR/Payroll and new Time and Attendance RedPrairie system. Utilized Application Engine and PeopleCode to extract Department, Job, Employee and Organizational Hierarchy into XML format.
• Modified delivered PeopleSoft Financials 9.0 EFT program that generates CTX820FE file to meet to requirements of different vendors. Some vendors requested order in which RMR and ADX (payments and adjustments) were written to the EFT file.
• Developed Component Interface (CI) to convert 2.800 “Courtesy Clerks” Job code ‘0001’employees to newly created Department “Front Office” for HR to normalize data prior to upgrading to new Time and Attendance system (RedPrairie).
• Created new workflow in Job Data for HR to notify Store Managers and HR of New Hires, Demotions, Pay Rate changes and transfers.
• Developed point-to-point integration from HCM 8.8 to ELM 9.1 (tools 8.5).

PeopleSoft Senior Developer

Confidential, Los Angeles, CA

Responsibilities:

• Member of the 8.0 to 9.0 (tool set 8.47) PeopleSoft Financials Upgrade team for the Confidential followed Confidential and California rules, regulations and procedures for GL, Accounts Payable and Purchasing modules.
• Re-apply online client customizations (PeopleCode, Application Engine, pages, fields, records, components), unit test and system test Technical Environment.
• Consulted with client to analyze requirements; design, document and estimate proposed technical solutions.
• Applied online client customizations to PeopleSoft environments. Performed unit, system and regression testing on respective Environments.
• Converted complex SQL scripts into XML Publishing reports. This involved converting SQL scripts into PS Queries, XML system configuration, applying XML Word Plug-in, designing, developing, uploading and running header and report templates.
• Modified custom Crystal and SQR reports and applied PeopleSoft 9.0 changes.

PeopleSoft Financials and HRMS Technical Consultant

Confidential, Minneapolis, MN

Responsibilities:

• Designed and developed interface using SQR that reads data from several flat files and inserts data into PeopleSoft 8.9 HRMS Time and Labor. This program performs a series of validations that either rejects or accepts time transactions. Rejected transactions are sent to an Exceptions Report and flagged in a transactions table with appropriate error.
• Accepted transactions are then inserted into Time and Labor Rapid Time tables.
• Program creates a separate session for each source type and inserts this information into “Submit All Rapid Time” run control page and launches program. It also logs statistical information into a custom page/table that includes source, number of records processed, number of records rejected, timestamp, etc. After the files are processed, files are renamed and moved to a another directory.
• Developed new components, pages, records, PeopleCode, Portal Structure and Content definition, for transactions log page, run control page and processing rules page using PeopleTools.
• Removed customizations that had been made for the previous financial system so that integration between HCM and FSCM will be completed.
• Conducted PeopleSoft production payroll support.
• Created Technical Design document. Also wrote Unit and QA Test documentation.

PeopleSoft HCM Technical Consultant

Confidential, Hanover, MD

Responsibilities:

• PeopleSoft 8.0 to 8.9 HCM/Payroll upgrade team member responsible for analysis of customizations, applying modified code to 8.9, create and document unit test results.
• Modified pages, records, fields, PeopleCode and components using PeopleTools.
• Responsible for implementing technical modifications to Person Model changes and implementing TAM according to client’s needs as well as configure and test is functionality.
• Performed online object development with PeopleTools for pages, records, PeopleCode and Portal objects.
• Modified SQRs and applied 8.9 upgrade changes, in particular Person Model changes.

PeopleSoft HCM Technical Consultant

Confidential, Fort Worth, TX

Responsibilities:

• Upgraded HR SQR interface programs from 8.3 to 8.9 either adding new functionality and integrating new 8.9 data structure.
• Assisted in PeopleSoft upgrade from 8.3 to 8.9.
• Resolved HR and Payroll production issues.

PeopleSoft HRMS Analyst

Confidential, Los Angeles, CA

Responsibilities:

• Support both PeopleSoft HR and Financials 8.1 including production issues as well as updates/enhancements.
• Preparing and working on PeopleSoft upgrade from 8.1 to 8.9.
• Resolved production issues in HR and Payroll.
• Made customizations to PeopleSoft Expense module based on client’s specifications.
• Ran payroll several times in a Development environment while testing a new deduction Code.
• Created/posted/paid AP vouchers while testing W-2 functionality in AP.

PeopleSoft HRMS Technical Consultant

Confidential, Minneapolis, MN

Responsibilities:

• Developed PeopleSoft 8.8 HR/North American Payroll to GL Interface. Created program that inserted data into temp table to be extracted by several other programs for different GL formats.

PeopleSoft HRMS Consultant

Confidential, San Francisco, CA

Responsibilities:

• Executed Kaiser IBM Mainframe JCL Interface/bridge programs that generate files and reports as part of Labor and Distribution and Financials General Ledger Parallel Testing.
• Analyzed and reconciled Mainframe Labor and Distribution files and reports against PeopleSoft 8.8 HR and Financials GL reports.

PeopleSoft Financials Developer

Confidential, Edina, Minnesota

Responsibilities:

• Converted PeopleSoft Financials Projects Interfaces from 7.5 to 8.8. This included modifying all selects, updates and inserts in SQRs where Table Structure had changed.
• It also involved, in some cases, creating an Application Engine program with new URL definition and, PeopleCode modifications to allow SQRs to upload files on local PC since PeopleSoft 8.8 no longer supports local files uploads for SQRs.
• Added components to the PeopleSoft 8.8 Portal registry, which included adding objects to menu, portal, folder and security.
• Converted Interfaces that in 7.5 were inserting directly to the Projects Tables and GL tables to the new 8.8 Staging/Interface Tables.
• Completed Interfaces on time to User Testing.

PeopleSoft HRMS Sr. Business Analyst/Consultant

Confidential

Responsibilities:

• Completed data mapping of PeopleSoft version 8.3 vs. Spain’s Meta4 HR System. Tested all facets of HR and Benefits data entry (new hires, benefits enrollments, termination, etc.)
• Completed Data Mapping/transformation, data translation, extraction and testing between PeopleSoft 8.3 and Spanish Payroll System and HR (Meta4).
• Contributed to HRMS functional and technical interface design between PeopleSoft and Payroll System (Meta4).

PeopleSoft HRMS Technical Developer

Confidential

Responsibilities:

• Resolved technical issues such as adding new functionality by modifying pages, records, search records, components through PeopleCode and PeopleTools 8.1.
• Moved objects between development, testing and production environments.
• Created new functionality (pages, records, PeopleCode, PeopleTools) for inactive/retired Employees (“Pasivos”) in PeopleSoft 8.1.
• PeopleSoft 8.1 HR to Spanish Payroll interface.

PeopleSoft HRMS Technical Developer

Confidential

Responsibilities:

• As a member of the Customization and Reporting Team, developed new Crystal reports based on user's specifications. It involves creating new objects (components, pages, PeopleCode, records, menus, security) following strict guidelines and documentation procedures.
• Resolved issues following strict object transport and documentation guidelines.
• Designed, developed, documented and maintained Payroll and HR inbound and outbound interfaces using PeopleTools and SQR Runner, TestDirector and Application Designer.
• Developed and maintained HRMS version 8.1 reports using SQR tool.

PeopleSoft Financials Technical Developer

Confidential

Responsibilities:

• Developed Inventory Forecast Process as part of PeopleSoft version 8 upgrade.
• This process assists Confidential in predicting how many Server configurations they can produce for sales forecast. Developed this process by Components, new RunControl records, panels (pages), PeopleCode, Records, Menu, Process definition and SQR process/reports.
• Assisted client in PeopleSoft 8 upgrade related issues.

PeopleSoft Financials Senior Business Analyst

Confidential, Cypress, California.

Responsibilities:

• Researched, applied relevant patches, modified code, setup, tested and applied PeopleSoft Financials year-end1099 process to Production database.
• As an integral member of the PeopleSoft 8 Upgrade team, researched, applied patches, converted data from PeopleSoft 7.5, updated existing custom panels, SQR, Application Engine, PeopleCode and process definitions to version 8 for Accounts Payable, Accounts Receivable, Asset Management, Purchasing, Inventory, General Ledger and Order Management modules.
• Researched, applied relevant patches, modified code, setup EDI Manager, modified Payment Predictor Application Engine program to fit user’s requests, tested and applied Financials Accounts Receivable Payment Predictor process to Production database.

PeopleSoft Financials Administrator/Manager

Confidential, Century City, California

Responsibilities:

• Developed new customized PeopleSoft Accounts Receivable Payment Entry process. Designed, created, modified and tested new records, panels, panel groups, menus, security, queries, PeopleCode, views, and trained staff from Customer Service and Cash Management Department.
• Coordinated and managed new process for generating PeopleSoft Accounts Payable COD invoices. Process included documenting current process, testing and training new personnel.
• Designed, developed tested and implemented Monthly Mail and Marketing Interface. Tested it with Customer Service Manager prior to implementing interface successfully.
• Downloaded, applied and tested patches to Development PeopleSoft database prior to applying to Production database. Installed, re-compiled and tested PeopleSoft COBOL updates.

PeopleSoft Technical HR Consultant

Confidential, San Mateo, California.

Responsibilities:

• Designed, created, modified and tested PeopleSoft 7.5 Payroll/ADP Check Printing Interface. Coordinated with ADP Check Printing contact running, testing and transmitting extract file from PeopleSoft to ADP.
• Modified PeopleSoft Version 5 HR and Financials Modules to make Y2K compliant utilizing PeopleCode, People Tools, Application Upgrader, SQL and SQR. Created PeopleCode functions to allow 50/50-windowing functionality.
• Designed, developed tested and implemented 401k and Retirement PeopleSoft SQR Interfaces for version 5. Which I later upgraded to version 7.5, following Putnam and Fidelity Investments’ specifications and schedule.
• Analyzed, created extracts, imported, and tested legacy data for conversion.
• Optimized existing PeopleSoft Interfaces by removing redundant and unnecessary code and improved performance by 100%.
• Provided PeopleSoft Technical Support to HR and Benefits Department and resolved issues promptly.
• Made modifications (application designer, process scheduler, operator security, etc.) utilizing PeopleTools.

PeopleSoft Financials Technical Financials Consultant

Confidential, Irvine, California.

Responsibilities:

• For an owner and publisher of 22 newspapers, served as Financials Technical Consultant.
• Designed, developed and implemented SQRs to convert legacy system vendor data into PeopleSoft.
• Designed, developed and implemented Circulation, Advertising, Electronic File
• Transfer and Bank Reconciliation interfaces via SQR program.
• Performed Crystal report definition and construction.
• Responsible for AP modifications using PeopleCode, PeopleTools, and SQR.
• As Technical Consultant in charge of developing and implementing 52 SQR reports for PeopleSoft Human Resources version 7.
• Trained and directed client’s employee in PeopleSoft, SQR and Crystal reports.
• Responsible for PeopleSoft Human Resources modifications using People Tools.
• Performed data and objects migration utilizing Data Mover, Import Manager and Application Upgrader.

Application Financials Developer

Confidential, Pleasanton, California

Responsibilities:

• Completed various functional and detail design specification tasks for Sales and Accounting departments.
• Implemented changes to records, panels, PeopleCode, run control and SQR files for Billing and A/R within the financial module. Expected live date is July 1998.
• Design and implement client needs for application enhancements.
• Expanded Oracle skills through Advanced SQL and PL/SQL classes in San Francisco Oracle Office.
• Converted Paradox procedures into Oracle Functions for the Bonus 98 Project.
• Solved client outages of existing applications within time commitments.
• Converted Paradox application to a Client/Server Oracle/Delphi application.
• Convert Paradox reports to Crystal 32-bit reports.

Technical Support Consultant

Confidential, San Francisco, California

Responsibilities:

• Resolved Network and Desktop PC Application issues for over three hundred users.
• Documented and resolved pending Network and PC issues.
• Implemented software upgrades and reported to Information Systems Manager.
• Troubleshoot, analyzed, and documented all phases of projects.
• Configured and installed software on new workstations.
• Learned quickly new methods and software for implementation with little direction.

Systems Engineer

Confidential, Concord, California

Responsibilities:

• Provided second level support to Confidential ’s trading floors.
• Set up NT Workstations for production in the trading floors.
• Project Leader for backup solution across the LAN for servers in the trading floors.
• Tested and documented new NT workstation platforms.
• Created site specific hard drives for testing by Quality Assurance group.
• Configured NT workstations for different hardware and software requirements.