Summary:

Mr. Quijano has extensive Technical Information systems experience with proven expertise in Peoplesoft products. He is a skilled application developer and a persistent hard worker. He is known as very capable, who could always figure things out. He is versatile and adaptable to new technologies. His works included maintenance, extensions, upgrades and development of reports and interfaces. He has excellent troubleshooting skills and in-depth analysis, contributing to customers better understanding the intricacies of the software and stabilization of the system.

Skills Summary:

Operating Systems:

Windows NT and XP, MVS/ESA, Unix

Databases:

Oracle, SQL Server, DB2, MS Access

Languages:

SQR, COBOL, SQL, PeopleCode, JCL, C/C++, HTML, XML, XSLT, WSDL, Basic, JavaScript, PS IScript, PL/SQL, Business Process Execution Language

Software Technologies:

PeopleSoft 8.4/8.8/8.9, PeopleTools 8.48, MS Office XP, CSP, CICS, Novell, Librarian, TSO, Visio, Data Flow Diagramming, MS Frontpage, MS Networking, Dreamweaver, ColdFusion, PS 8.4 Enterprise Portal, Livelink, Identity Management, PGP, Reflection FTP, Qwest Stat, Oracle JDeveloper, Oracle BPEL Process Manager, Oracle Business Intelligence, Oracle ESB, Oracle Web Center Suite, PS Workflow, LDAP

PeopleSoft:

Base Benefits, Commitment Accounting, Financials & Supply Chain Management, Human Resources/HCM, Payroll, Time and Labor, Enterprise Portal

PeopleTools:

Application Designer, Application Engine, Application Messaging, Business Interlink, Business Process Design, Component Interface, Crystal, Data Mover, Import Manager, Integration Broker, nVision, Object Security, Operator Security, PeopleCode, Process Scheduler, PS Query, Tree Manager, File Layout, Business Interlink, ExceltoCI

Work Experience:

Confidential, July 2007 to January 2009
Confidential,September 10, 2007 to January 2009
PeopleSoft HRMS Technical Consultant

• Worked on the Cost Center Restructuring project, this converted the employee’s department to the more organized departmental structure that can easily tie up the data for Financial and security purposes.
• Created security profile online page to implement and organize employee’s security access and tie it up with the Security Tables. This also generates report for the security hierarchy.
• Developed interface programs to Sunlife and ePrism and enhanced Salary and Budget load for Compensation processes. This facilitates data sharing between Peoplesoft and the other systems.
• Developed program for Jobcode reorganization and perform regular maintenance activities and production support for on-call tasks.
• Invesco AIM is maintained in PS HCM 8.9 using PeopleTools 8.46 and Oracle on Windows NT and UNIX.

Confidential,July 9, 2007 to September 9, 2007
PeopleSoft HRMS Technical Consultant

• Member of a team involved in maintenance, support and globalization projects.
• Enhanced the on boarding process by enabling the system to update LDAP directly for new Hires and Rehires, and facilitate the exit process by also disabling security.
• Global Santa Fe’s system is maintained in PS HCM 8.9 using PeopleTools 8.47 and SQL Server on Windows NT.

Confidential, November 1999 to July 2007
Confidential,April 24, 2007 to May 24, 2007
PeopleSoft HRMS Technical Consultant

• Member of an implementation team for Sun Identity Management 7.0 tasked mainly to integrate with Peoplesoft HRMS.
• Finalized objects like component interfaces, records, SQL views, indexes and triggers necessary to enable integration with IDM. Involved in testing, handling additional requirements and improving SQL statements for more efficient table access.
• Safeway’s system is maintained using PS HRMS 8.8 using PeopleTools 8.44 and DB2 on OS/390 mainframe.

Confidential,April 3, 2006 to February 17, 2007
PeopleSoft HRMS/Financials Technical Consultant

• Member of development and production support team for enhancement and maintenance of both HR and Financials systems.
• Applied multiple PS Financials AM bundles to keep the module up to date and also enable utilization of PS delivered functionalities on Bonus Depreciation for Gulf zone assets.
• Upgraded interface to Livelink on Voucher Entry and Vendor Maintenance pages to enable access to Invoices and Vendor’s 1099 forms.
• Programmer support for year end 1099 processing, engaged in troubleshooting issues and streamline of custom programs.
• Involved in troubleshooting issues and support requirements on Purchasing Requisitions, custom Capital Appropriation module and Positive pay file creation and transmission.
• Some HRMS enhancements include, developed online pay check view with historical YTD data using printer friendly html objects and PS Iscript, designed and coded the Belo contact feed interface to IBM, converted custom local taxes reporting programs to PS delivered process thus reducing maintenance during the application of upgrades or patches and revised Benefit data extract for intranet processing adding additional information on retirement benefits and savings plans.
• Assisted in the development and implementation of E-recruit in PS HRMS 8.8.
• Utilized Stat for PS Objects migration, versioning and change control, used ftp and encryption softwares in handling interface files and involved in day to day resolution of production issues.
• Belo’s system is maintained using PS HRMS 8.8 using PeopleTools 8.46 and PS Financials 8.0 which is currently being upgraded to PS Financials 8.8.

Confidential,August 17, 2005 to March 30, 2006
PeopleSoft HRMS Technical Consultant

• Member of the development team for the upgrade project from PS HRMS 8.0 to HCM 8.9.
• Involved in the setup, analysis, and coding of customizations to programs that need to be retrofitted to the new version. Upgraded 80+ SQR’s and SQC’s.
• Addressed/resolved 40+ batch and online user testing issues related to the upgrade project.
• Wrote generic codes and SQC’s to save on programming effort and to avoid duplication of processes.
• Involved in production support, addressing issues in Payroll, Benefits and other adhoc requirements.
• Revised the Benefits program to create Benefits reporting table to handle future dated records only for New Hires and Rehires for the current month.
• Attended meetings and have done research and analysis to determine better approaches in delivering an application process or resolving an issue.
• Streamlined manual processes through the development of PS Feed programs that extract Payroll and HR data for other systems.
• UT MDA was upgraded from PeopleSoft 8 to PS HCM 8.9 using Oracle, Unix and Windows NT.

Confidential,August 30, 2004 to August 16, 2005
PeopleSoft Technical Consultant

• Member of an implementation team engaged on PS 8.3 HCM-Financials-SCM Integration Project (includes HR, Payroll, T& L, Benefits Administration, GL, AP, PO, AM, PC and INV)
• Researched and activated the Payroll to AP Interface using the delivered Enterprise Integration Points to automatically create Vouchers for Garnishments and General Deducts like Union Dues and United Way. Activated App. Messages, revised App. Engine program, Subscription PeopleCode and prepare SQR programs to enable the process
• Developed SQR programs for Health Benefits Provider Interfaces (utilizing the Snapshot approach), this generated the benefits interface files for Personal Care and Delta Dental.
• Created new programs for Head Count report, and custom Leave Accrual programs for 11 Leave plans. Set up Leave Accrual job streams using App. Engine programs, Job, recurrence and process definitions
• Researched/resolved Issues on the following: Accrual Percent on Pay Calendar, activate of Project Costing reports, use of Journal generator and combination editing, Return Materials Issues, Account Code issues, Inventory and Cost Management duplicate accounting entries for interunit expensed issues (applied patch to fix this issue), added PeopleCode to enforce data entry rules on various data entry pages, and revised PO printing
• Revised the Inventory RMA, Putaway and Receiving pages to allow GL Overrides and create a facility to update the business unit GL on the created accounting entries. This is to extend the PS version’s missing functionality to handle expense issue returns for Express Inventory issues, which have business unit GL overrides. Developed App. Engine program, PeopleCode, Component Interface and set up portal registry structures to implement these changes
• Research the delivered Procurement Cards process and apply customizations based on existing business practices. Developed custom App. Engine programs and utilized File Layouts in the process
• CCI’s system is PS HRMS 8.3 and PS Financials/SCM 8.4, using PeopleTools 8.19 and 8.44, Oracle 8, Unix and Windows NT, 2000

Confidential,December 29, 2003 to August 27, 2004
PeopleSoft HRMS Technical Consultant

• Member of production support team for PS HRMS 8, tasked mainly to resolve production problems and extension of the functionality of the system.
• Prepared multiple adhoc queries and custom SQR reports for Payroll, Commitment Accounting, HR, Benefits and Compensation departments. Also developed a report extracting data from Kronos.
• Resolved taxation issue on supplemental wages, to tax the earnings based on the graduated tax rate instead of using the entered supplemental wage rate, determined problem on paysheets creation and modified payroll job process and company table setup to correct this issue. Determined the cause of the problems on the inflated FLSA rates for Exception Hourly employees and researched on Garnishments being taken on refunds.
• Enhanced existing reports and processes, like adding additional fields to existing custom tables and views, changes in report layouts, additional file extracts for other interface systems and adding email functionality to SQR reports.
• Prepared web page for myHR which is the sign on screen for Self Service modules, and assisted on home page revisions to access the different PS environments.
• MDA’s system is PeopleSoft 8 using PeopleTools 8.14, Oracle 8, Unix and Windows NT.

Confidential,October 2003 to December 19, 2003
PeopleSoft HRMS Technical Consultant

• Member of re-implementation team for PS Time and Labor 8.8, upgrade team for PS HRMS 8.8 and GL Interface systems.
• Customized the Weekly Elapsed Time page for added functionality based on the client’s specification and existing Time and Labor system. Added validations based on Value Lists, PeopleCode and modified page, prompt tables based on security access.
• Resolved the problem on Task Templates and modified Time Administration Application Engine for client’s unique requirements.
• Set up new folders and content references for Fund Code maintenance and Manage Groups which included development of a custom version of Static and Dynamic groups setup.
• Reviewed and assisted in testing of the Account Code Overlay of Time and Labor data for the Substitute Teacher’s Time reporting codes, also helped test the custom Overtime program for Overtime premium system generated records.
• Revised and enhanced GL Interface program for version 8.8 upgrade.
• Resolve T&L system testing and data setup issues, also tuned SQL views for more acceptable performance.
• HISD’s system is PeopleSoft 8.8 using PeopleTools 8.43, SQL Server 2000 and Windows NT.

Confidential,August 14, 2003 to October 24, 2003

• Member of a team that developed programs and implemented the Paid Time Off Leave Accrual re-engineering project. Developed Automatic Enrollment of Probationary Employees from Negative Benefit Plan to Positive PTO Benefit plan, other reports and online pages. Also revised GL Interface program for these changes.
• Lead programmer in the development, testing and implementation of the HR/Badge System Interface project. Clean up bugs and errors in programs, rename fields and revised Application Engine programs.
• Called upon to prepare multiple adhoc reports for Payroll Earnings and revised Check program to sort checks over 5,000 to top of report.
• Developed program and specifications for Time and Labor Editor Audit report, Overtime Over 16 Hours report and added PeopleCode to restrict Time Entry personnel to edit their own Time records.
• Performed production support activities by troubleshooting, analysis and resolution of batch processing problems and other PeopleSoft system inquiries.
• Maintained Parkland’s system PeopleSoft 8.18 using Oracle and Windows NT.

Confidential,April 7, 2003 to April 11, 2003

• Revision and testing of Payroll/GL Interface program for Split Accounting period processing.

Confidential,March 2000 to December 31, 2002
PeopleSoft HRMS Technical Consultant

• Member of development and support team for PS HRMS (Public Sector), Budget and Encumbrance (B&E) and GL Interface systems.
• Developed SQR reports and processes for Payroll, B&E, HR, Compensation, Benefits, Time and Labor, Teachers Retirement System and GL Interface.
• Developed Gross to Net report, which became one of the most widely used programs in HISD\'s PS Payroll custom reports.
• Designed and developed maintenance programs for Fund Conversions and Fund Expiration processing making the process more proactive and easier to maintain.
• Improved and stabilized the Account Code load process, Encumbrance processing and GL Actuals Interface from PeopleSoft Payroll to SAP Financials, thereby eliminating the multiple months of processing backlog. Tuned programs set up audit tables and developed archived programs.
• Revised GL Interface program for Split Accounting period processing.
• Prepared processes to load Budgets for new Fiscal Year, other batch updates and mass load of budget records resulting in hundreds of man-hour savings on data entry.
• Researched and resolved issues on the FMLA administration panel to address client’s needs.
• Analyzed Payroll Pay Check Distribution Patches and Fixes to determine which one needed to be implemented and applied them correspondingly also provided other PeopleSoft upgrade activities.
• Provided training on SQL to client\'s technical and functional employees.
• Performed troubleshooting, analysis and resolution of operational problems, occasionally prepared batch payroll processes.
• Maintained HISD’s system using PeopleSoft 7.51 and 7.52, SQL Server and Windows NT.

Confidential,November 1999
PeopleSoft HRMS/Financials Technical Consultant

• PeopleSoft Consultant assigned to post implementation projects.
• Analyzed and applied HR patches.
• Provided troubleshooting, analysis and resolution to processing problems on PeopleSoft Accounts Payable and General Ledger.
• Performed research required to streamline the Accounts Payable Check process.
• Maintained Greystar\'s systems in PeopleSoft 7.52 using PeopleTools, COBOL/SQL, SQRs, Crystal, PSNVision, SQL Server and Windows NT.

Confidential, 1998 to 1999
PeopleSoft Financials Technical Consultant

• PeopleSoft Consultant and member of the development team for the PeopleSoft Financials General Ledger (GL) implementation.
• Provided troubleshooting, analysis and resolution to production batch and on-line problems for the entire PS Financials suite.
• Maintained and enhanced existing programs, loaded panels and implemented jobs running in Process Scheduler.
• Developed programs to generate PeopleSoft GL reports (accounts details, products volume comparison and tabulation, trial balances, batch proof list and general ledger detail reports) and also interface programs from legacy systems to PeopleSoft GL and vice versa.
• Documented job process flow, and implemented programs in production using SQRs and JCLs.
• Maintained Financial Systems in PeopleSoft 5.1 using PeopleTools, SQRs, DB2 and MVS/ESA.

Confidential, 1993 to 1998
PeopleSoft Technical Consultant, 1995 to 1998

• Provided system support, enhancements, troubleshooting and development of interfaces to other systems for PeopleSoft HR/Benefits/Payroll System.
• Developed new SQR programs such as YTD Earnings, Taxes and Deducts reports, Statement of Payments Report, Conversion Programs and Table Updates.
• Tuned selective complex SQLs to enhance system performance and tax-reporting programs to shorten processing time.
• Implemented Tax Upgrades and ensured that customizations were maintained.
• Developed programs for conversion of Deducts and Benefits from legacy system to PeopleSoft.
• Prepared report programs for mainframe and PeopleSoft Payroll reconciliation during parallel processing using SQRs, SQL Loader and PL/SQLs.
• Provided technical support on Unix, Oracle or PeopleSoft, set up Korn Shell scripts to run SQRs, COBOL programs, FTPs and other table/file maintenance process in production.
• Analyzed business processes and coordinated with the client for user requirements and also provided production support on Payroll processing batch problems.
• Maintained the existing SQL Menu for Production Control processes and trained co-employees on how to load programs and Korn Shell scripts on SQL Menu to turn over programs to production.
• Maintained Payroll, HR and Benefits systems in PeopleSoft 4.12 using PeopleTools, SQRs, Oracle, SQL Menu, PL/SQL, COBOL, Unix Scripts and PeopleCode.

Mainframe Programmer/Analyst Consultant, 1993 to 1995

• Worked on maintenance of Payroll, Benefits and other Personnel mainframe systems.
• Provided program updates on for tax changes and program developments for regular, monthly, quarterly and year-end processing requirements.
• Designated to maintain/troubleshoot existing programs and to develop ad hoc programs for reports and file updates, revised batch and on-line applications and prepared JCLs for batch jobs.
• Maintained systems using MVS/XA, COBOL, VSAM, ISAM, Easytrieve, ROSCOE, Magic, Nomad and TSO/ISPF.

Confidential, 1989 to 1993
Systems Analyst/Lead Programmer

• Developed two of four modules of the Reserves and Liquidity Trading System that was used by the Asset, Liability and Liquidity Management Department. The system supports the trading activity with Central Bank and other banks. It provided on-line inquiries on existing inventory balances and was used to enter different transactions such as sales and purchases of securities.
• Lead programmer for the Commercial Papers module of the Money Market Trading System (MMTS) that supported the bank’s dealership function in response to its projected increase in trading activities. It provided on-line capabilities to view Commercial Paper inventories and monitored client accounts. It provided accurate and up-to-date inventory balances/movements reports, management reports and contributed more efficiency in the processing of documents.
• This system was developed in IBM 4381 and implemented in IBM ES 9000 using Design 1, MVS/XA/ESA, CSP/DB2, TSO/ISPF, SPUFI, CICS/VS and COBOL/DB2.

Education & Training:

Bachelor of Science in Computer Engineering
M.B.A. (33 hours)
PeopleSoft Trainings :
PeopleTools 1 Version 7
PeopleTools 2 Version 7
PeopleCode Version 7
PeopleTools 1/PeopleTools 2 V7.5 to V8.4 Delta
PS 8.4 PeopleTools Portal Suite
PS 8.8 Time and Labor Suite
PS 8.8 HR Administer Base Benefits
Using PeopleSoft North American Payroll
Oracle Fusion Middleware Boot Camp – Peoplesoft Focus
PS 8.8 Introduction to Workflow